コード例 #1
0
ファイル: global.php プロジェクト: hackingman/TubeX
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']);
}