Exemple #1
0
        $photoplog_categorybit = $photoplog_ds_catopts[$photoplog['catid']]['options'];
        $photoplog_catoptions = convert_bits_to_array($photoplog_categorybit, $photoplog_categoryoptions);
        $do_comments = $photoplog_catoptions['allowcomments'] ? 1 : 0;
    }
    if (!$do_comments) {
        photoplog_index_bounce();
    }
    if ($photoplog_comment_info) {
        if ($photoplog_comment_info['userid'] == $vbulletin->userinfo['userid'] && defined('PHOTOPLOG_USER10') || defined('PHOTOPLOG_USER12')) {
            $photoplog['fileid'] = $photoplog_comment_info['fileid'];
            $photoplog_have_comment = $photoplog_comment_info['comment'] != '' ? 1 : 0;
            $db->query_write("DELETE FROM " . PHOTOPLOG_PREFIX . "photoplog_ratecomment\r\n\t\t\t\tWHERE commentid = " . intval($photoplog['commentid']) . "\r\n\t\t\t\t{$photoplog_catid_sql2}\r\n\t\t\t\t{$photoplog_admin_sql2}\r\n\t\t\t");
            if ($photoplog_have_comment) {
                $db->query_write("UPDATE " . TABLE_PREFIX . "user\r\n\t\t\t\t\tSET photoplog_commentcount = photoplog_commentcount - 1\r\n\t\t\t\t\tWHERE userid = " . intval($photoplog_comment_info['userid']) . "\r\n\t\t\t\t");
            }
            photoplog_update_fileuploads_counts($photoplog['fileid']);
            photoplog_update_counts_table($photoplog['catid']);
            ($hook = vBulletinHook::fetch_hook('photoplog_comment_dodelete_complete')) ? eval($hook) : false;
            $photoplog_url = $photoplog['location'] . '/index.php?' . $vbulletin->session->vars['sessionurl'] . 'n=' . $photoplog['fileid'];
            exec_header_redirect($photoplog_url);
            exit;
        } else {
            photoplog_index_bounce();
        }
    } else {
        photoplog_output_page('photoplog_error_page', $vbphrase['photoplog_error'], $vbphrase['photoplog_bad_tank']);
    }
}
($hook = vBulletinHook::fetch_hook('photoplog_comment_complete')) ? eval($hook) : false;
if ($_REQUEST['do'] != 'comment' && $_POST['do'] != 'docomment' && $_GET['do'] != 'edit' && $_GET['do'] != 'delete' && $_POST['do'] != 'dodelete') {
    photoplog_index_bounce();
Exemple #2
0
 $photoplog_rating_infos = $db->query_read("SELECT userid, fileid,\r\n\t\t\tSUM(IF(rating > 0, 1, 0)) AS cntr1\r\n\t\t\tFROM " . PHOTOPLOG_PREFIX . "photoplog_ratecomment\r\n\t\t\tGROUP BY userid, fileid\r\n\t\t");
 $photoplog_rating_cntr = 0;
 while ($photoplog_rating_info = $db->fetch_array($photoplog_rating_infos)) {
     if ($photoplog_rating_info['cntr1'] > 1) {
         $photoplog_rating_cntr++;
         break;
     }
 }
 if ($photoplog_rating_infos && $photoplog_rating_cntr) {
     $db->data_seek($photoplog_rating_infos, 0);
     while ($photoplog_rating_info = $db->fetch_array($photoplog_rating_infos)) {
         if ($photoplog_rating_info['cntr1'] > 1) {
             $photoplog_first_comment = $db->query_first("SELECT commentid, catid\r\n\t\t\t\t\t\tFROM " . PHOTOPLOG_PREFIX . "photoplog_ratecomment\r\n\t\t\t\t\t\tWHERE fileid = " . intval($photoplog_rating_info['fileid']) . "\r\n\t\t\t\t\t\tAND userid = " . intval($photoplog_rating_info['userid']) . "\r\n\t\t\t\t\t\tAND rating > 0\r\n\t\t\t\t\t\tORDER BY dateline ASC\r\n\t\t\t\t\t\tLIMIT 1\r\n\t\t\t\t\t");
             if ($photoplog_first_comment) {
                 $db->query_write("UPDATE " . PHOTOPLOG_PREFIX . "photoplog_ratecomment\r\n\t\t\t\t\t\t\tSET rating = 0\r\n\t\t\t\t\t\t\tWHERE fileid = " . intval($photoplog_rating_info['fileid']) . "\r\n\t\t\t\t\t\t\tAND userid = " . intval($photoplog_rating_info['userid']) . "\r\n\t\t\t\t\t\t\tAND commentid != " . intval($photoplog_first_comment['commentid']) . "\r\n\t\t\t\t\t\t");
                 photoplog_update_fileuploads_counts($photoplog_rating_info['fileid']);
                 photoplog_update_counts_table($photoplog_first_comment['catid']);
                 $photoplog_commentid = $photoplog_first_comment['commentid'];
                 $photoplog_msg = $vbphrase['photoplog_updating'] . ' - ' . $vbphrase['photoplog_comment'] . ' ' . $vbphrase['photoplog_id'] . ' ' . $photoplog_commentid . ': ' . $vbphrase['photoplog_rating'] . ' != 0 ';
                 print_description_row($photoplog_msg, 0, 1);
                 @flush();
                 @ob_flush();
                 $db->free_result($photoplog_first_comment);
             }
         }
     }
     $db->free_result($photoplog_rating_infos);
     print_description_row('<strong>' . $vbphrase['photoplog_done'] . '</strong>', 0, 1);
     print_table_footer();
     print_cp_redirect("photoplog_maintain.php?" . $vbulletin->session->vars['sessionurl'] . "do=update", 1);
 } else {