You can do it with mysql query

Code:
update videos set video_active=1, video_approve=1, video_type='private' where video_approve=0;
Take a database backup before doing this.