$href .= "#comm" . $comment_id; } elseif (isset($_POST['delete_comments']) && iPRP_MOD) { $do_calc_comments = true; if (!isset($_POST['comment'])) { fallback(FUSION_SELF . "?did=" . $review->id); } $errors = 0; foreach ($_POST['comment'] as $id => $val) { if (!dbquery("DELETE FROM " . DB_PRP_COMMENTS . " WHERE comment_id='" . $id . "'" . " AND review_id='" . $review->id . "'")) { ++$errors; } } } elseif (isset($_GET['subscibe']) && $prp->settings['allow_notify'] && iMEMBER) { $do_calc_subscribers = true; if ($_GET['subscibe'] == "1") { $ok = dbquery("INSERT INTO " . DB_PRP_NOTIFY . "" . " SET" . " user_id='" . $userdata['user_id'] . "'," . " review_id='" . $review->id . "'," . " visited='yes'," . " details='0'"); } else { $ok = dbquery("DELETE FROM " . DB_PRP_NOTIFY . "" . " WHERE user_id='" . $userdata['user_id'] . "'" . " AND review_id='" . $review->id . "'"); } $review->log_event(PRP_EV_SUBSCRIBE, 0); } if ($do_calc_avg) { $ok = dbquery("UPDATE " . DB_PRP_DOWNLOADS . "\n\t\tSET\n\t\tavg_vote='" . prp_calc_avg_vote($review->id) . "',\n\t\tcount_votes='" . ff_db_count("(*)", DB_PRP_VOTES, "(review_id='" . $review->id . "')") . "'\n\t\tWHERE review_id='" . $review->id . "'"); } elseif ($do_calc_comments) { $ok = dbquery("UPDATE " . DB_PRP_DOWNLOADS . "\n\t\tSET\n\t\tcount_comments='" . ff_db_count("(*)", DB_PRP_COMMENTS, "(review_id='" . $review->id . "')") . "'\n\t\tWHERE review_id='" . $review->id . "'"); } elseif ($do_calc_subscribers) { $ok = dbquery("UPDATE " . DB_PRP_DOWNLOADS . "\n\t\tSET\n\t\tcount_subscribers='" . ff_db_count("(*)", DB_PRP_NOTIFY, "(review_id='" . $review->id . "')") . "'\n\t\tWHERE review_id='" . $review->id . "'"); } if ($errors == 0) { fallback($href); }
$new_ver = "1.7.10"; $set_tbl = DB_PREFIX . "prp_settings"; // $mysql[] = "ALTER TABLE " . DB_PREFIX . "prp_reviews" . " ADD KEY (cat_id)"; $mysql[] = "ALTER TABLE " . DB_PREFIX . "prp_reviews" . " ADD KEY (user_id)"; $mysql[] = "ALTER TABLE " . DB_PREFIX . "prp_reviews" . " ADD KEY (license_id)"; $mysql[] = "ALTER TABLE " . DB_PREFIX . "prp_comments" . " ADD KEY (review_id)"; $mysql[] = "ALTER TABLE " . DB_PREFIX . "prp_files" . " ADD KEY (review_id)"; $mysql[] = "ALTER TABLE " . DB_PREFIX . "prp_log" . " ADD KEY (review_id)"; $mysql[] = "ALTER TABLE " . DB_PREFIX . "prp_images" . " ADD KEY (review_id)"; $mysql[] = "ALTER TABLE " . DB_PREFIX . "prp_notify" . " ADD KEY (user_id, review_id)"; // count comments $query_id = dbquery("SELECT dl_id FROM " . DB_PREFIX . "prp_reviews"); while ($data = dbarray($query_id)) { $comm_count = ff_db_count("(*)", "prp_comments", "(dl_id='" . $data['dl_id'] . "')"); $avg = prp_calc_avg_vote($data['dl_id']); $mysql[] = "UPDATE " . DB_PREFIX . "prp_reviews" . " SET" . " count_comments='" . $comm_count . "'" . " WHERE dl_id='" . $data['dl_id'] . "'"; } break; case '1.7.10': $new_ver = '1.8.0'; $set_tbl = DB_PREFIX . "prp_settings"; // $mysql[] = "ALTER TABLE " . DB_PREFIX . "prp_cats\n\t\tADD COLUMN cat_review_access tinyint(3) unsigned NOT NULL default '0'"; $mysql[] = "UPDATE " . DB_PREFIX . "prp_cats\n\t\tSET\n\t\tcat_review_access=cat_access"; $mysql[] = "ALTER TABLE " . DB_PREFIX . "prp_settings\n\t\tADD COLUMN review_restricted text NOT NULL"; $mysql[] = "UPDATE " . DB_PREFIX . "prp_settings\n\t\tSET\n\t\treview_restricted='" . stripinput($locale['PRP407']) . "'"; /*!!!NO BREAK!!!*/ /*!!!NO BREAK!!!*/ case '1.8.0': $new_ver = '1.8.1';