It shouldn't be too hard to join the table containing the list of qualified videos with the main video table and delete from the the qualfied table where the hidden flag is set (or visibility flag is unset) in the main table. This could also be done with a subquery, but I think it's a mySQL database, and only the newest versions of mySQL support subqueries.AbsoluteDestiny wrote:See, the way the deletion works is that it effectively "hides" the video. WHen the qualified list was made I think Phade must have found the qualified members and then listed *all* their videos including deleted ones.
I'll see if I can get him to fix it, although it may involve people doing their nominations again, I dont know.
Alternatively a simple PHP/Perl/etc. script could be used to grab the list of hidden videos and build another query to delete those specific entries from the qualified list.
I'm probably not saying anything you guys don't already know, but since you weren't sure if it could be done without forcing people to redo their nominations, I'm just pointing out some options that shouldn't require starting nominations over, which wiping and recreating the table might do, depending on where the votes are stored.
In case you guys do need any help with this stuff, I'm a little out of practice with SQL queries, but I'd be glad to try to help if necessary.
I don't understand !!!
Wgat is it ? A friends's contest ?
