PHP prp_calc_avg_vote 예제들

예제 #1

파일: do_did.php 프로젝트: simplyianm/clububer

    $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);
}

예제 #2

파일: db_update.php 프로젝트: simplyianm/clububer

     $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';