/** * Class constructor. * * @param object $post_data multi rating results from the database * @param int $set_id multi rating set id */ function GDSRArticleMultiRating($post_data, $set_id) { $this->set = gd_get_multi_set($set_id); $this->review = $post_data->average_review; $this->user_votes = $post_data->total_votes_users; $this->visitor_votes = $post_data->total_votes_visitors; $this->votes = $post_data->total_votes_users + $post_data->total_votes_visitors; $this->user_rating = $post_data->average_rating_users; $this->visitor_rating = $post_data->average_rating_visitors; $totals = $this->user_rating * $this->user_votes + $this->visitor_rating * $this->visitor_votes; if ($this->votes > 0) { $this->rating = number_format($totals / $this->votes, 1); } }
function render_multi_editor($settings) { $multi_id = $settings["multi_id"] == 0 ? $this->g->o["mur_review_set"] : $settings["multi_id"]; $post_id = $settings["post_id"]; $init_votes = $settings["votes"]; $set = gd_get_multi_set($multi_id); if (is_null($set)) { $set = gd_get_multi_set(); } $multi_id = !is_null($set) ? $set->multi_id : 0; if ($multi_id > 0 && $post_id > 0) { $vote_id = GDSRDBMulti::get_vote($post_id, $multi_id, count($set->object)); $multi_data = GDSRDBMulti::get_values($vote_id, 'rvw'); if (count($multi_data) == 0) { GDSRDBMulti::add_empty_review_values($vote_id, count($set->object)); $multi_data = GDSRDBMulti::get_values($vote_id, 'rvw'); } } else { $multi_data = array(); } $votes = array(); if (count($multi_data) > 0) { foreach ($multi_data as $md) { $single_vote = array(); $single_vote["votes"] = 1; $single_vote["score"] = $md->user_votes; $single_vote["rating"] = $md->user_votes; $votes[] = $single_vote; } } else { for ($i = 0; $i < count($set->object); $i++) { $iv = isset($init_votes[$i]) ? $init_votes[$i] : 0; $votes[] = array("votes" => $iv == 0 ? 0 : 1, "score" => $iv == 0 ? 0 : $iv, "rating" => $iv == 0 ? 0 : $iv); } } if ($settings["admin"]) { include $this->g->plugin_path . 'integrate/edit_multi.php'; } else { return GDSRRenderT2::render_mre(intval($settings["tpl"]), array("post_id" => $settings["post_id"], "style" => $settings["style"], "height" => $settings["size"], "votes" => $votes, "set" => $set, "allow_vote" => true)); } }
function render_multi_custom_values($template_id, $multi_set_id, $custom_id, $votes, $header_text = '', $override = array(), $tags_css = array(), $star_factor = 1) { $set = gd_get_multi_set($multi_set_id); $rd_unit_width = $override["size"]; $rd_unit_style = $this->g->is_ie6 ? $override["style_ie6"] : $override["style"]; $rd_unit_width_avg = isset($override["average_size"]) ? $override["average_size"] : $override["style"]; $rd_unit_style_avg = isset($override["average_stars"]) ? $this->g->is_ie6 ? $override["average_stars_ie6"] : $override["average_stars"] : $override["style"]; return GDSRRenderT2::render_mrb($template_id, array("style" => $rd_unit_style, "allow_vote" => false, "votes" => $votes, "post_id" => $custom_id, "set" => $set, "height" => $rd_unit_width, "header_text" => $header_text, "tags_css" => array("MUR_CSS_BLOCK" => ""), "avg_style" => $rd_unit_style_avg, "avg_size" => $rd_unit_width_avg, "star_factor" => $star_factor)); }
$number_posts = $number_posts_post; } else { if ($select == "page") { $number_posts = $number_posts_page; } else { $number_posts = $number_posts_all; } } $max_page = floor($number_posts / $posts_per_page); if ($max_page * $posts_per_page != $number_posts) { $max_page++; } if ($max_page > 1) { $pager = GDSRHelper::draw_pager($max_page, $page_id, $url, "pg"); } $set = gd_get_multi_set($set_id); ?> <script> function checkAll(form) { for (i = 0, n = form.elements.length; i < n; i++) { if(form.elements[i].type == "checkbox" && !(form.elements[i].getAttribute('onclick', 2))) { if(form.elements[i].checked == true) form.elements[i].checked = false; else form.elements[i].checked = true; } } } </script>
function add_vote($post_id, $set_id, $user_id, $ip, $ua, $votes) { global $wpdb, $table_prefix; $set = gd_get_multi_set($set_id); $data = $table_prefix . 'gdsr_multis_data'; $trend = $table_prefix . 'gdsr_multis_trend'; $trend_date = date("Y-m-d"); $sql_trend = sprintf("SELECT id FROM %s WHERE vote_date = '%s' and post_id = %s and multi_id = %s", $trend, $trend_date, $post_id, $set_id); wp_gdsr_dump("TREND_CHECK", $sql_trend); $trend_data = intval($wpdb->get_var($sql_trend)); wp_gdsr_dump("TREND_ID", $trend_data); $trend_added = false; if ($trend_data == 0) { $trend_added = true; $sql = sprintf("INSERT INTO %s (post_id, multi_id, vote_date) VALUES (%s, %s, '%s')", $trend, $post_id, $set_id, $trend_date); $wpdb->query($sql); $trend_id = $wpdb->insert_id; } else { $trend_id = $trend_data; } GDSRDBMulti::add_values($trend_id, $user_id, $votes, "trd", $trend_added ? "add" : "edit"); GDSRDBMulti::recalculate_trend_averages($trend_id, $set); $data_id = GDSRDBMulti::get_vote($post_id, $set_id, count($set->object)); GDSRDBMulti::add_values($data_id, $user_id, $votes); }
/** * Save multi rating or review for a post * * @param int $post_id id of the post to add values * @param int $multi_set_id multi set id * @param array $values list of values */ function gdsr_save_multi_review($post_id, $multi_set_id, $values) { global $gdsr; $set = gd_get_multi_set($multi_set_id); $clean = array(); foreach ($values as $v) { if ($v < 1) { $v = 1; } $clean[] = $v > $set->stars ? $set->stars : $v; } $record_id = GDSRDBMulti::get_vote($post_id, $multi_set_id, count($set->object)); GDSRDBMulti::save_review($record_id, $clean); GDSRDBMulti::recalculate_multi_review($record_id, $clean, $set); }
function vote_multis($votes, $post_id, $set_id, $tpl_id, $size) { global $userdata; $ip = $_SERVER["REMOTE_ADDR"]; if ($this->g->o["save_user_agent"] == 1) { $ua = $_SERVER["HTTP_USER_AGENT"]; } else { $ua = ""; } $user = is_object($userdata) ? $userdata->ID : 0; $data = GDSRDatabase::get_post_data($post_id); $set = gd_get_multi_set($set_id); wp_gdsr_dump("VOTE_MUR", "[POST: " . $post_id . "|SET: " . $set_id . "] --" . $votes . "-- [" . $user . "]"); $values = explode("X", $votes); $allow_vote = true; foreach ($values as $v) { if ($v > $set->stars) { $allow_vote = false; break; } } $vote_value = GDSRDBMulti::recalculate_multi_vote($values, $set); if ($allow_vote) { $allow_vote = gdsrFrontHelp::check_cookie($post_id . "#" . $set_id, "multis"); } if ($allow_vote) { $allow_vote = GDSRDBMulti::check_vote($post_id, $user, $set_id, 'multis', $ip, $this->g->o["logged"] != 1, $this->g->o["mur_allow_mixed_ip_votes"] == 1); } $rating = 0; $total_votes = 0; $json = $summary = array(); if ($allow_vote) { GDSRDBMulti::save_vote($post_id, $set_id, $user, $ip, $ua, $values, $data); $summary = GDSRDBMulti::recalculate_multi_averages($post_id, $set_id, $data->rules_articles, $set, true, $size); gdsrFrontHelp::save_cookie($post_id . "#" . $set_id, "multis"); $rating = $summary["total"]["rating"]; $total_votes = $summary["total"]["votes"]; $json = $summary["json"]; do_action("gdsr_vote_rating_multis", $post_id, $user, $set_id, $values, $rating); } include STARRATING_PATH . 'code/t2/templates.php'; $template = new gdTemplateRender($tpl_id, "MRB"); $rt = GDSRRenderT2::render_srt_voted($template->dep["MRT"], array("rating" => $rating, "unit_count" => $set->stars, "votes" => $total_votes, "id" => $post_id, "vote" => $vote_value)); $json = apply_filters("gdsr_vote_rating_multis_return", $json, $summary, $values); $enc_values = "[" . join(",", $json) . "]"; return '{ "status": "ok", "values": ' . $enc_values . ', "rater": "' . str_replace('"', '\\"', $rt) . '", "average": "' . $rating . '" }'; }
function init_operations() { $msg = ""; if (isset($_POST["gdsr_multi_review_form"]) && $_POST["gdsr_multi_review_form"] == "review") { $mur_all = $_POST['gdsrmulti']; foreach ($mur_all as $post_id => $data) { if ($post_id > 0) { foreach ($data as $set_id => $mur) { $set = gd_get_multi_set($set_id); $values = explode("X", $mur); $record_id = GDSRDBMulti::get_vote($post_id, $set_id, count($set->object)); GDSRDBMulti::save_review($record_id, $values); GDSRDBMulti::recalculate_multi_review($record_id, $values, $set); } } } $this->custom_actions('init_save_review'); wp_redirect_self(); exit; } if (isset($_POST["gdsr_editcss_rating"])) { $rating_css = STARRATING_XTRA_PATH . "css/rating.css"; if (is_writeable($rating_css)) { $newcontent = stripslashes($_POST['gdsr_editcss_contents']); $f = fopen($rating_css, 'w+'); fwrite($f, $newcontent); fclose($f); } wp_redirect_self(); exit; } if (isset($_POST['gdsr_debug_clean'])) { wp_gdsr_debug_clean(); wp_redirect_self(); exit; } if (isset($_POST['gdsr_cache_clean'])) { GDSRHelper::clean_cache(substr(STARRATING_CACHE_PATH, 0, strlen(STARRATING_CACHE_PATH) - 1)); $this->o["cache_cleanup_last"] = date("r"); update_option('gd-star-rating', $this->o); wp_redirect_self(); exit; } if (isset($_POST['gdsr_preview_scan'])) { $this->g = gdsrAdmFunc::gfx_scan(); update_option('gd-star-rating-gfx', $this->g); wp_redirect_self(); exit; } if (isset($_POST['gdsr_t2_import'])) { gdsrAdmDB::insert_extras_templates(STARRATING_XTRA_PATH, false); wp_redirect_self(); exit; } if (isset($_POST['gdsr_upgrade_tool'])) { require_once STARRATING_PATH . "/gdragon/gd_db_install.php"; gdDBInstallGDSR::delete_tables(STARRATING_PATH); gdDBInstallGDSR::create_tables(STARRATING_PATH); gdDBInstallGDSR::upgrade_tables(STARRATING_PATH); gdDBInstallGDSR::alter_tables(STARRATING_PATH); gdDBInstallGDSR::alter_tables(STARRATING_PATH, "idx.txt"); $this->o["database_upgrade"] = date("r"); update_option('gd-star-rating', $this->o); wp_redirect_self(); exit; } if (isset($_POST['gdsr_updatemultilog_tool'])) { GDSRDBMulti::recalculate_multi_rating_log(); wp_redirect_self(); exit; } if (isset($_POST['gdsr_mulitrecalc_tool'])) { $set_id = $_POST['gdsr_mulitrecalc_set']; if ($set_id > 0) { GDSRDBMulti::recalculate_set($set_id); } else { GDSRDBMulti::recalculate_all_sets(); } wp_redirect_self(); exit; } if (isset($_POST['gdsr_cleanup_tool'])) { if (isset($_POST['gdsr_tools_clean_invalid_log'])) { $count = gdsrTlsDB::clean_invalid_log_articles(); if ($count > 0) { $msg .= $count . " " . __("articles records from log table removed.", "gd-star-rating") . " "; } $count = gdsrTlsDB::clean_invalid_log_comments(); if ($count > 0) { $msg .= $count . " " . __("comments records from log table removed.", "gd-star-rating") . " "; } } if (isset($_POST['gdsr_tools_clean_invalid_trend'])) { $count = gdsrTlsDB::clean_invalid_trend_articles(); if ($count > 0) { $msg .= $count . " " . __("articles records from trends log table removed.", "gd-star-rating") . " "; } $count = gdsrTlsDB::clean_invalid_trend_comments(); if ($count > 0) { $msg .= $count . " " . __("comments records from trends log table removed.", "gd-star-rating") . " "; } } if (isset($_POST['gdsr_tools_clean_old_posts'])) { $count = gdsrTlsDB::clean_dead_articles(); if ($count > 0) { $msg .= $count . " " . __("dead articles records from articles table.", "gd-star-rating") . " "; } $count = gdsrTlsDB::clean_revision_articles(); if ($count > 0) { $msg .= $count . " " . __("post revisions records from articles table.", "gd-star-rating") . " "; } $count = gdsrTlsDB::clean_dead_comments(); if ($count > 0) { $msg .= $count . " " . __("dead comments records from comments table.", "gd-star-rating") . " "; } } if (isset($_POST['gdsr_tools_clean_old_posts'])) { $count = GDSRDBMulti::clean_dead_articles(); if ($count > 0) { $msg .= $count . " " . __("dead articles records from multi ratings tables.", "gd-star-rating") . " "; } $count = GDSRDBMulti::clean_revision_articles(); if ($count > 0) { $msg .= $count . " " . __("post revisions records from multi ratings tables.", "gd-star-rating") . " "; } } $this->o["database_cleanup"] = date("r"); $this->o["database_cleanup_msg"] = $msg; update_option('gd-star-rating', $this->o); wp_redirect_self(); exit; } if (isset($_POST['gdsr_post_lock'])) { $lock_date = $_POST['gdsr_lock_date']; gdsrAdmDB::lock_post_massive($lock_date); $this->o["mass_lock"] = $lock_date; update_option('gd-star-rating', $this->o); wp_redirect_self(); exit; } if (isset($_POST['gdsr_rules_set'])) { wp_gdsr_dump("POST", $_POST); gdsrAdmDB::update_settings_full($_POST["gdsr_article_moderation"], $_POST["gdsr_article_voterules"], $_POST["gdsr_comments_moderation"], $_POST["gdsr_comments_voterules"], $_POST["gdsr_artthumb_moderation"], $_POST["gdsr_artthumb_voterules"], $_POST["gdsr_cmmthumbs_moderation"], $_POST["gdsr_cmmthumbs_voterules"]); wp_redirect_self(); exit; } }
function render_multi_rating($post, $user, $settings) { if ($this->is_bot) { return ""; } if (is_feed()) { return ""; } $set = gd_get_multi_set($settings["id"]); if ($set == null) { return ""; } $dbg_allow = "F"; $allow_vote = true; if ($this->is_ban && $this->o["ip_filtering"] == 1) { if ($this->o["ip_filtering_restrictive"] == 1) { return ""; } else { $allow_vote = false; } $dbg_allow = "B"; } if ($settings["read_only"] == 1) { $dbg_allow = "RO"; $allow_vote = false; } if (is_single() || is_page() && $this->o["display_comment_page"] == 1) { $this->init_post(); } $rd_post_id = intval($post->ID); $rd_user_id = intval($user->ID); $rd_is_page = $post->post_type == "page" ? "1" : "0"; $remaining = 0; $deadline = ""; if ($this->p) { $post_data = $this->p; } else { $post_data = GDSRDatabase::get_post_data($rd_post_id); if (count($post_data) == 0) { GDSRDatabase::add_default_vote($rd_post_id, $rd_is_page); $post_data = GDSRDatabase::get_post_data($rd_post_id); } } if ($post_data->rules_articles == "H") { return ""; } if ($allow_vote) { if ($this->o["author_vote"] == 1 && $rd_user_id == $post->post_author) { $allow_vote = false; $dbg_allow = "A"; } } if ($allow_vote) { if ($post_data->rules_articles == "" || $post_data->rules_articles == "A" || $post_data->rules_articles == "U" && $rd_user_id > 0 || $post_data->rules_articles == "V" && $rd_user_id == 0) { $allow_vote = true; } else { $allow_vote = false; $dbg_allow = "R_" . $post_data->rules_articles; } } if ($allow_vote && ($post_data->expiry_type == 'D' || $post_data->expiry_type == 'T')) { switch ($post_data->expiry_type) { case "D": $remaining = GDSRHelper::expiration_date($post_data->expiry_value); $deadline = $post_data->expiry_value; break; case "T": $remaining = GDSRHelper::expiration_countdown($post->post_date, $post_data->expiry_value); $deadline = GDSRHelper::calculate_deadline($remaining); break; } if ($remaining < 1) { GDSRDatabase::lock_post($rd_post_id); $allow_vote = false; $dbg_allow = "T"; } } if ($allow_vote) { $allow_vote = GDSRDBMulti::check_vote($rd_post_id, $rd_user_id, $set->multi_id, 'multis', $_SERVER["REMOTE_ADDR"], $this->o["logged"] != 1, $this->o["mur_allow_mixed_ip_votes"] == 1); if (!$allow_vote) { $dbg_allow = "D"; } } if ($allow_vote) { $allow_vote = $this->check_cookie($rd_post_id . "#" . $set->multi_id, "multis"); if (!$allow_vote) { $dbg_allow = "C"; } } $multi_record_id = GDSRDBMulti::get_vote($rd_post_id, $set->multi_id, count($set->object)); $multi_data = GDSRDBMulti::get_values($multi_record_id); $votes = array(); foreach ($multi_data as $md) { $single_vote = array(); $single_vote["votes"] = 0; $single_vote["score"] = 0; if ($post_data->rules_articles == "A" || $post_data->rules_articles == "N") { $single_vote["votes"] = $md->user_voters + $md->visitor_voters; $single_vote["score"] = $md->user_votes + $md->visitor_votes; } else { if ($post_data->rules_articles == "V") { $single_vote["votes"] = $md->visitor_voters; $single_vote["score"] = $md->visitor_votes; } else { $single_vote["votes"] = $md->user_voters; $single_vote["score"] = $md->user_votes; } } if ($single_vote["votes"] > 0) { $rating = $single_vote["score"] / $single_vote["votes"]; } else { $rating = 0; } if ($rating > $set->stars) { $rating = $set->stars; } $single_vote["rating"] = @number_format($rating, 1); $votes[] = $single_vote; } $debug = $rd_user_id == 0 ? "V" : "U"; $debug .= $rd_user_id == $post->post_author ? "A" : "N"; $debug .= ":" . $dbg_allow . " [" . STARRATING_VERSION . "]"; $tags_css = array(); $tags_css["MUR_CSS_BLOCK"] = $this->o["mur_class_block"]; $tags_css["MUR_CSS_HEADER"] = $this->o["mur_class_header"]; $tags_css["MUR_CSS_TEXT"] = $this->o["mur_class_text"]; $tags_css["MUR_CSS_BUTTON"] = $this->o["mur_class_button"]; if ($settings["tpl"] > 0) { $template_id = $settings["tpl"]; } else { $template_id = $this->o["default_mrb_template"]; } return GDSRRenderT2::render_mrb($this->o["mur_style"], $template_id, $allow_vote, $votes, $rd_post_id, $set, $this->o["mur_size"], $this->o["mur_header_text"], $tags_css, $settings["average_stars"], $settings["average_size"], $post_data->expiry_type, $remaining, $deadline, $this->o["mur_button_active"] == 1, $this->o["mur_button_text"], $debug, $this->loader_multis); }
function wp_gdget_multi_set($multi_id) { global $gdsr_cache_multi_sets; $set = $gdsr_cache_multi_sets->get($multi_id); if (!is_null($set) && is_object($set)) { return $set; } else { $set = gd_get_multi_set($multi_id); $gdsr_cache_multi_sets->set($multi_id, $set); return $set; } }