query($sql); return $wpdb->rows_affected; } function clean_invalid_log_comments() { global $wpdb, $table_prefix; $sql = sprintf("delete %s from %sgdsr_votes_log l left join %scomments o on o.comment_ID = l.id where l.vote_type = 'comment' and o.comment_ID is null", gdFunctionsGDSR::mysql_pre_4_1() ? sprintf("%sgdsr_votes_log", $table_prefix) : "l", $table_prefix, $table_prefix); $wpdb->query($sql); return $wpdb->rows_affected; } function clean_invalid_trend_articles() { global $wpdb, $table_prefix; $sql = sprintf("delete %s from %sgdsr_votes_trend l left join %sposts o on o.ID = l.id where l.vote_type = 'article' and o.ID is null", gdFunctionsGDSR::mysql_pre_4_1() ? sprintf("%sgdsr_votes_trend", $table_prefix) : "l", $table_prefix, $table_prefix); $wpdb->query($sql); return $wpdb->rows_affected; } function clean_invalid_trend_comments() { global $wpdb, $table_prefix; $sql = sprintf("delete %s from %sgdsr_votes_trend l left join %scomments o on o.comment_ID = l.id where l.vote_type = 'comment' and o.comment_ID is null", gdFunctionsGDSR::mysql_pre_4_1() ? sprintf("%sgdsr_votes_trend", $table_prefix) : "l", $table_prefix, $table_prefix); $wpdb->query($sql); return $wpdb->rows_affected; } function clean_dead_articles() { global $wpdb, $table_prefix; $sql = sprintf("delete %s from %sgdsr_data_article l left join %sposts o on o.ID = l.post_id where o.ID is null", gdFunctionsGDSR::mysql_pre_4_1() ? sprintf("%sgdsr_data_article", $table_prefix) : "l", $table_prefix, $table_prefix); $wpdb->query($sql); return $wpdb->rows_affected; } function clean_dead_comments() { global $wpdb, $table_prefix; $sql = sprintf("delete %s from %sgdsr_data_comment l left join %scomments o on o.comment_ID = l.comment_id where o.comment_ID is null", gdFunctionsGDSR::mysql_pre_4_1() ? sprintf("%sgdsr_data_comment", $table_prefix) : "l", $table_prefix, $table_prefix); $wpdb->query($sql); return $wpdb->rows_affected; } } class GDSRDB { function get_database_tables() { global $table_prefix; $tables = array( "data_article" => $table_prefix.'gdsr_data_article', "data_comment" => $table_prefix.'gdsr_data_comment', "votes_log" => $table_prefix.'gdsr_votes_log', "votes_trend" => $table_prefix.'gdsr_votes_trend', "moderate" => $table_prefix.'gdsr_moderate', "multi_sets" => $table_prefix.'gdsr_multis', "banned_ips" => $table_prefix.'gdsr_ips' ); return $tables; } function get_post_title($post_id) { global $wpdb; return $wpdb->get_var("select post_title from $wpdb->posts where ID = ".$post_id); } // conversion function convert_row($row) { switch ($row->moderate_articles) { case 'I': $row->moderate_articles = __("articles", "gd-star-rating").': '.__("inherited", "gd-star-rating").''; break; case 'A': $row->moderate_articles = __("articles", "gd-star-rating").': '.__("all", "gd-star-rating").''; break; case 'V': $row->moderate_articles = __("articles", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->moderate_articles = __("articles", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; case 'N': default: $row->moderate_articles = __("articles", "gd-star-rating").': '.__("free", "gd-star-rating").''; break; } switch ($row->moderate_comments) { case 'I': $row->moderate_comments = __("comments", "gd-star-rating").': '.__("inherited", "gd-star-rating").''; break; case 'A': $row->moderate_comments = __("comments", "gd-star-rating").': '.__("all", "gd-star-rating").''; break; case 'V': $row->moderate_comments = __("comments", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->moderate_comments = __("comments", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; case 'N': default: $row->moderate_comments = __("comments", "gd-star-rating").': '.__("free", "gd-star-rating").''; break; } switch ($row->rules_articles) { case 'I': $row->rules_articles = __("articles", "gd-star-rating").': '.__("inherited", "gd-star-rating").''; break; case 'H': $row->rules_articles = __("articles", "gd-star-rating").': '.__("hidden", "gd-star-rating").''; break; case 'N': $row->rules_articles = __("articles", "gd-star-rating").': '.__("locked", "gd-star-rating").''; break; case 'V': $row->rules_articles = __("articles", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->rules_articles = __("articles", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; default: $row->rules_articles = __("articles", "gd-star-rating").': '.__("everyone", "gd-star-rating").''; break; } switch ($row->rules_comments) { case 'I': $row->rules_comments = __("comments", "gd-star-rating").': '.__("inherited", "gd-star-rating").''; break; case 'H': $row->rules_comments = __("comments", "gd-star-rating").': '.__("hidden", "gd-star-rating").''; break; case 'N': $row->rules_comments = __("comments", "gd-star-rating").': '.__("locked", "gd-star-rating").''; break; case 'V': $row->rules_comments = __("comments", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->rules_comments = __("comments", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; default: $row->rules_comments = __("comments", "gd-star-rating").': '.__("everyone", "gd-star-rating").''; break; } if ($row->visitor_voters == 0) { $votes_v = '/'; $count_v = '[ 0 ] '; } else { $visitor_rating = @number_format($row->visitor_votes / $row->visitor_voters, 1); $row->rating_visitors = $visitor_rating; $votes_v = ''.$visitor_rating.''; $count_v = sprintf('[ %s ] ', $row->pid, $row->visitor_voters); } if ($row->user_voters == 0) { $votes_u = '/'; $count_u = '[ 0 ] '; } else { $user_rating = @number_format($row->user_votes / $row->user_voters, 1); $row->rating_users = $user_rating; $votes_u = ''.$user_rating.''; $count_u = sprintf('[ %s ] ', $row->pid, $row->user_voters); } if ($row->review == -1 || $row->review == '') $row->review = "/"; $row->review = ''.$row->review.''; $total_votes = $row->visitor_votes + $row->user_votes; $total_voters = $row->visitor_voters + $row->user_voters; if ($total_voters == 0) { $votes_t = '/'; $count_t = '[ 0 ] '; } else { $total_rating = @number_format($total_votes / $total_voters, 1); $row->rating_total = $total_rating; $votes_t = ''.$total_rating.''; $count_t = sprintf('[ %s ] ', $row->pid, $total_voters); } $row->total = $count_t.__("rating", "gd-star-rating").': '.$votes_t.'
[ '.$row->views.' ] '.__("views", "gd-star-rating"); $row->votes = $count_v.__("visitors", "gd-star-rating").': '.$votes_v.'
'.$count_u.__("users", "gd-star-rating").': '.$votes_u.''; $row->title = sprintf('%s', $row->pid, $row->post_title); return $row; } function convert_category_row($row) { switch ($row->moderate_articles) { case 'A': $row->moderate_articles = __("articles", "gd-star-rating").': '.__("all", "gd-star-rating").''; break; case 'V': $row->moderate_articles = __("articles", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->moderate_articles = __("articles", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; default: $row->moderate_articles = __("articles", "gd-star-rating").': '.__("free", "gd-star-rating").''; break; } switch ($row->moderate_comments) { case 'A': $row->moderate_comments = __("comments", "gd-star-rating").': '.__("all", "gd-star-rating").''; break; case 'V': $row->moderate_comments = __("comments", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->moderate_comments = __("comments", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; default: $row->moderate_comments = __("comments", "gd-star-rating").': '.__("free", "gd-star-rating").''; break; } switch ($row->rules_articles) { case 'H': $row->rules_articles = __("articles", "gd-star-rating").': '.__("hidden", "gd-star-rating").''; break; case 'N': $row->rules_articles = __("articles", "gd-star-rating").': '.__("locked", "gd-star-rating").''; break; case 'V': $row->rules_articles = __("articles", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->rules_articles = __("articles", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; default: $row->rules_articles = __("articles", "gd-star-rating").': '.__("everyone", "gd-star-rating").''; break; } switch ($row->rules_comments) { case 'H': $row->rules_comments = __("comments", "gd-star-rating").': '.__("hidden", "gd-star-rating").''; break; case 'N': $row->rules_comments = __("comments", "gd-star-rating").': '.__("locked", "gd-star-rating").''; break; case 'V': $row->rules_comments = __("comments", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->rules_comments = __("comments", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; default: $row->rules_comments = __("comments", "gd-star-rating").': '.__("everyone", "gd-star-rating").''; break; } return $row; } function convert_moderation_row($row) { if ($row->user_id == 0) $row->username = 'visitor'; else $row->username = sprintf('%s', $row->user_id, $row->username); return $row; } function convert_comment_row($row) { if ($row->visitor_voters == 0) { $votes_v = '/'; $count_v = '[ 0 ] '; } else { $visitor_rating = @number_format($row->visitor_votes / $row->visitor_voters, 1); $row->rating_visitors = $visitor_rating; $votes_v = ''.$visitor_rating.''; $count_v = sprintf('[ %s ] ', $row->comment_id, $row->visitor_voters); } if ($row->user_voters == 0) { $votes_u = '/'; $count_u = '[ 0 ] '; } else { $user_rating = @number_format($row->user_votes / $row->user_voters, 1); $row->rating_users = $user_rating; $votes_u = ''.$user_rating.''; $count_u = sprintf('[ %s ] ', $row->comment_id, $row->user_voters); } $total_votes = $row->visitor_votes + $row->user_votes; $total_voters = $row->visitor_voters + $row->user_voters; if ($total_voters == 0) { $votes_t = '/'; $count_t = '[ 0 ] '; } else { $total_rating = @number_format($total_votes / $total_voters, 1); $row->rating_total = $total_rating; $votes_t = ''.$total_rating.''; $count_t = sprintf('[ %s ] ', $row->comment_id, $total_voters); } $row->total = $count_t.__("votes", "gd-star-rating").': '.$votes_t.''; $row->votes = $count_v.__("visitors", "gd-star-rating").': '.$votes_v.'
'.$count_u.__("users", "gd-star-rating").': '.$votes_u.''; if ($row->review == -1) $row->review = "/"; $row->review = ''.$row->review.''; return $row; } // conversion // moderation function moderation_approve($ids, $ids_array) { global $wpdb, $table_prefix; $sql = sprintf("select * from %s where record_id in %s", $table_prefix."gdsr_moderate", $ids); $rows = $wpdb->get_results($sql); foreach ($rows as $row) { if ($row->vote_type == "article") GDSRDatabase::add_vote($row->id, $row->user_id, $row->ip, $row->user_agent, $row->vote); if ($row->vote_type == "comment") GDSRDatabase::add_vote_comment($row->id, $row->user_id, $row->ip, $row->user_agent, $row->vote); } GDSRDB::moderation_delete($ids); } function moderation_delete($ids) { global $wpdb, $table_prefix; $sql = sprintf("delete from %s where record_id in %s", $table_prefix."gdsr_moderate", $ids); $wpdb->query($sql); } // moderation // templates function get_templates($section = '') { global $wpdb, $table_prefix; if ($section != '') $section = sprintf(" WHERE section = '%s'", $section); $sql = sprintf("select * from %sgdsr_templates%s order by template_id asc", $table_prefix, $section); return $wpdb->get_results($sql); } function get_template($id) { global $wpdb, $table_prefix; $sql = sprintf("SELECT * FROM %sgdsr_templates WHERE `template_id` = %s", $table_prefix, $id); return $wpdb->get_row($sql); } function edit_template($general, $elements) { global $wpdb, $table_prefix; $sql = sprintf("UPDATE %sgdsr_templates SET `section` = '%s', `name` = '%s', `description` = '%s', `elements` = '%s', `preinstalled` = '%s' WHERE `template_id` = %s", $table_prefix, $general["section"], $general["name"], $general["description"], serialize($elements), $general["preinstalled"], $general["id"]); $wpdb->query($sql); return $general["id"]; } function delete_template($id) { global $wpdb, $table_prefix; $sql = sprintf("DELETE FROM %sgdsr_templates WHERE `template_id` = %s", $table_prefix, $id); return $wpdb->query($sql); } function add_template($general, $elements) { global $wpdb, $table_prefix; $sql = sprintf("INSERT INTO %sgdsr_templates (`section`, `name`, `description`, `elements`, `preinstalled`) VALUES ('%s', '%s', '%s', '%s', '%s')", $table_prefix, $general["section"], $general["name"], $general["description"], serialize($elements), $general["preinstalled"]); $wpdb->query($sql); return $wpdb->insert_id; } function insert_default_templates($path) { global $wpdb, $table_prefix; $path.= "install/data/gdsr_templates.txt"; if (file_exists($path)) { $tpls = file($path); foreach ($tpls as $tpl) { $tpl_check = substr($tpl, 0, 3); $tpl_insert = substr($tpl, 4); $sql = sprintf("select count(*) from %sgdsr_templates where section = '%s' and preinstalled = '1'", $table_prefix, $tpl_check); $counter = $wpdb->get_var($sql); if ($counter == 0) { $sql = str_replace("%sgdsr_templates", $table_prefix."gdsr_templates", $tpl_insert); $wpdb->query($sql); } } } } // templates // totals function front_page_article_totals() { global $wpdb, $table_prefix; return $wpdb->get_row(sprintf("select sum(visitor_voters) as votersv, sum(visitor_votes) as votesv, sum(user_voters) as votersu, sum(user_votes) as votesu from %s", $table_prefix."gdsr_data_article")); } function front_page_comment_totals() { global $wpdb, $table_prefix; return $wpdb->get_row(sprintf("select sum(visitor_voters) as votersv, sum(visitor_votes) as votesv, sum(user_voters) as votersu, sum(user_votes) as votesu from %s", $table_prefix."gdsr_data_comment")); } function front_page_moderation_totals() { global $wpdb, $table_prefix; return $wpdb->get_row(sprintf("select vote_type, count(*) as queue from %s group by vote_type", $table_prefix."gdsr_moderate")); } // totals // recalculate function recalculate_articles($gdsr_oldstars, $gdsr_newstars) { global $wpdb, $table_prefix; $rate = $gdsr_newstars / $gdsr_oldstars; $sql = "UPDATE ".$table_prefix."gdsr_data_article SET user_votes = user_votes * ".$rate.", visitor_votes = visitor_votes * ".$rate; $wpdb->query($sql); } function recalculate_comments($gdsr_oldstars, $gdsr_newstars) { global $wpdb, $table_prefix; $rate = $gdsr_newstars / $gdsr_oldstars; $sql = "UPDATE ".$table_prefix."gdsr_data_comment SET user_votes = user_votes * ".$rate.", visitor_votes = visitor_votes * ".$rate; $wpdb->query($sql); } function recalculate_reviews($gdsr_oldstars, $gdsr_newstars) { global $wpdb, $table_prefix; $rate = $gdsr_newstars / $gdsr_oldstars; $sql = "UPDATE ".$table_prefix."gdsr_data_article SET review = review * ".$rate." where review > -1"; $wpdb->query($sql); } function recalculate_comments_reviews($gdsr_oldstars, $gdsr_newstars) { global $wpdb, $table_prefix; $rate = $gdsr_newstars / $gdsr_oldstars; $sql = "UPDATE ".$table_prefix."gdsr_data_comment SET review = review * ".$rate." where review > -1"; $wpdb->query($sql); } // recalculate } ?>