photoplog_update_fileuploads_counts_array($photoplog_file_ids);
photoplog_regenerate_counts_table_v2($photoplog_cat_ids);
$_REQUEST['do'] = 'wipe';
}
}
if ($_REQUEST['do'] == 'approve' || $_REQUEST['do'] == 'unapprove') {
$photoplog_moderate = 1;
if ($_REQUEST['do'] == 'approve') {
$photoplog_moderate = 0;
}
if ($db->query_write("UPDATE " . PHOTOPLOG_PREFIX . "photoplog_ratecomment\r\n\t\t\t\tSET moderate = " . intval($photoplog_moderate) . "\r\n\t\t\t\tWHERE commentid IN (" . $photoplog_comment_sql . ")\r\n\t\t\t")) {
if ($_REQUEST['do'] == 'approve') {
$db->query_write("UPDATE " . PHOTOPLOG_PREFIX . "photoplog_fileuploads\r\n\t\t\t\t\tSET moderate = 0\r\n\t\t\t\t\tWHERE fileid IN (" . implode(',', $photoplog_file_ids) . ")\r\n\t\t\t\t");
}
photoplog_update_fileuploads_counts_array($photoplog_file_ids);
photoplog_regenerate_counts_table_v2($photoplog_cat_ids);
$_REQUEST['do'] = 'wipe';
}
}
}
if ($_REQUEST['do'] == 'wipe') {
if ($photoplog_inline_action == 'files') {
if ($vbulletin->options['photoplog_display_type'] == 1) {
setcookie('photoplog_inlinepost', '', TIMENOW - 3600, '/');
} else {
setcookie('photoplog_inlinethread', '', TIMENOW - 3600, '/');
}
}
if ($photoplog_inline_action == 'comments') {
setcookie('photoplog_inlinepost', '', TIMENOW - 3600, '/');
}
$photoplog_fetch_userinfo = $db->query_first("SELECT username,email\r\n\t\t\t\t\t\tFROM " . TABLE_PREFIX . "user\r\n\t\t\t\t\t\tWHERE userid = " . intval($photoplog_fileids_row['userid']) . "\r\n\t\t\t\t\t\tAND (options & " . intval($vbulletin->bf_misc_useroptions['adminemail']) . ")\r\n\t\t\t\t\t");
if ($photoplog_fetch_userinfo) {
$photoplog_username = unhtmlspecialchars($photoplog_fetch_userinfo['username']);
$photoplog_title = $photoplog_fileids_row['title'];
$photoplog_subject = $photoplog_message = '';
eval(fetch_email_phrases('photoplog_declined_comment', -1, '', 'photoplog_'));
vbmail($photoplog_fetch_userinfo['email'], $photoplog_subject, $photoplog_message, true);
}
$db->free_result($photoplog_fetch_userinfo);
}
}
$db->free_result($photoplog_fileids_query);
foreach ($photoplog_checked_commentids as $photoplog_commentid) {
$photoplog_comment_info = $db->query_first("SELECT userid,comment\r\n\t\t\t\t\tFROM " . PHOTOPLOG_PREFIX . "photoplog_ratecomment\r\n\t\t\t\t\tWHERE commentid = " . intval($photoplog_commentid) . "\r\n\t\t\t\t");
if ($photoplog_comment_info) {
$photoplog_have_comment = $photoplog_comment_info['comment'] != '' ? 1 : 0;
if ($db->query_write("DELETE FROM " . PHOTOPLOG_PREFIX . "photoplog_ratecomment\r\n\t\t\t\t\t\t\tWHERE commentid = " . intval($photoplog_commentid) . "\r\n\t\t\t\t\t\t")) {
if ($photoplog_have_comment) {
$db->query_write("UPDATE " . TABLE_PREFIX . "user\r\n\t\t\t\t\t\t\t\tSET photoplog_commentcount = photoplog_commentcount - 1\r\n\t\t\t\t\t\t\t\tWHERE userid = " . intval($photoplog_comment_info['userid']) . "\r\n\t\t\t\t\t\t\t");
}
}
}
}
photoplog_update_fileuploads_counts_array($photoplog_fileids_array);
photoplog_regenerate_counts_table_v2($photoplog_catids_array);
}
}
}
print_cp_redirect("photoplog_comment.php?" . $vbulletin->session->vars['sessionurl'] . "do=moderate", 1);
}
print_cp_footer();
