function DeleteVideo($video) { $DB = GetDB(); $DB->Update('DELETE FROM `tbx_video` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_video_clip` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_video_thumbnail` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_video_rating` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_video_flagged` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_video_featured` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_video_favorited` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_video_custom` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_video_stat` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_video_comment` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_video_private` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_user_favorite` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_conversion_queue` WHERE `video_id`=?', array($video['video_id'])); $DB->Update('DELETE FROM `tbx_thumb_queue` WHERE `video_id`=?', array($video['video_id'])); if ($video['status'] == STATUS_ACTIVE && !$video['is_private']) { Tags::RemoveFromFrequency($video['tags']); } $video_dir = new Video_Dir(Video_Dir::DirNameFromId($video['video_id'])); $video_dir->Remove(); UpdateCategoryStats($video['category_id']); UpdateSponsorStats($video['sponsor_id']); $t = new Template(); $t->ClearCache('video-watch.tpl', $video['video_id']); }