prefix); $wpdb->query($sql); $sql = sprintf("truncate table %sgdsr_multis_values", $wpdb->prefix); $wpdb->query($sql); $sql = sprintf("truncate table %sgdsr_multis_trend", $wpdb->prefix); $wpdb->query($sql); } function get_stats_count($set_id, $dates = "0", $cats = "0", $search = "") { global $table_prefix; $where = " and ms.multi_id = ".$set_id; if ($dates != "" && $dates != "0") { $where.= " and year(p.post_date) = ".substr($dates, 0, 4); $where.= " and month(p.post_date) = ".substr($dates, 4, 2); } if ($search != "") $where.= " and p.post_title like '%".$search."%'"; if ($cats != "" && $cats != "0") $sql = sprintf("SELECT p.post_type, count(*) as count FROM %sterm_taxonomy t, %sterm_relationships r, %sposts p, %sgdsr_multis_data ms WHERE p.ID = ms.post_id and t.term_taxonomy_id = r.term_taxonomy_id AND r.object_id = p.ID AND t.term_id = %s AND t.taxonomy = 'category' AND p.post_status = 'publish'%s GROUP BY p.post_type", $table_prefix, $table_prefix, $table_prefix, $table_prefix, $cats, $where ); else $sql = sprintf("select p.post_type, count(*) as count from %sposts p inner join %sgdsr_multis_data ms on p.ID = ms.post_id where p.post_status = 'publish'%s group by post_type", $table_prefix, $table_prefix, $where ); return $sql; } function get_stats($set_id, $select = "", $start = 0, $limit = 20, $dates = "0", $cats = "0", $search = "", $sort_column = 'id', $sort_order = 'desc', $additional = '') { global $table_prefix; $where = " and ms.multi_id = ".$set_id; if ($dates != "" && $dates != "0") { $where.= " and year(p.post_date) = ".substr($dates, 0, 4); $where.= " and month(p.post_date) = ".substr($dates, 4, 2); } if ($search != "") $where.= " and p.post_title like '%".$search."%'"; if ($select != "" && $select != "postpage") $where.= " and post_type = '".$select."'"; if ($sort_column == 'post_title' || $sort_column == 'id') $order = " ORDER BY p.".$sort_column." ".$sort_order; else $order = " ORDER BY ".$sort_column." ".$sort_order; if ($cats != "" && $cats != "0") $sql = sprintf("SELECT p.id as pid, p.post_title, p.post_type, ms.* FROM %sterm_taxonomy t, %sterm_relationships r, %sposts p, %sgdsr_multis_data ms WHERE ms.post_id = p.id and t.term_taxonomy_id = r.term_taxonomy_id AND r.object_id = p.id AND t.term_id = %s AND t.taxonomy = 'category' AND p.post_status = 'publish'%s%s%s LIMIT %s, %s", $table_prefix, $table_prefix, $table_prefix, $table_prefix, $cats, $where, $additional, $order, $start, $limit ); else $sql = sprintf("select p.id as pid, p.post_title, p.post_type, ms.* from %sposts p left join %sgdsr_multis_data ms on p.id = ms.post_id WHERE p.post_status = 'publish'%s%s%s limit %s, %s", $table_prefix, $table_prefix, $where, $additional, $order, $start, $limit ); return $sql; } } class gdsrAdmDB { function reset_db_tool() { global $wpdb; $sql = sprintf("update %sgdsr_data_article set views = 0, review = 0, user_voters = 0, user_votes = 0, visitor_voters = 0, visitor_votes = 0, user_recc_plus = 0, user_recc_minus = 0, visitor_recc_plus = 0, visitor_recc_minus = 0", $wpdb->prefix); $wpdb->query($sql); $sql = sprintf("update %sgdsr_data_comment set review = 0, user_voters = 0, user_votes = 0, visitor_voters = 0, visitor_votes = 0, user_recc_plus = 0, user_recc_minus = 0, visitor_recc_plus = 0, visitor_recc_minus = 0", $wpdb->prefix); $wpdb->query($sql); $sql = sprintf("truncate table %sgdsr_votes_log", $wpdb->prefix); $wpdb->query($sql); $sql = sprintf("truncate table %sgdsr_votes_trend", $wpdb->prefix); $wpdb->query($sql); $sql = sprintf("truncate table %sgdsr_moderate", $wpdb->prefix); $wpdb->query($sql); } function get_voters_count($post_id, $dates = "", $vote_type = "article", $vote_value = 0) { global $table_prefix; $where = " where vote_type = '".$vote_type."'"; $where.= " and id = ".$post_id; if ($dates != "" && $dates != "0") { $where.= " and year(voted) = ".substr($dates, 0, 4); $where.= " and month(voted) = ".substr($dates, 4, 2); } if ($vote_value > 0) $where.= " and vote = ".$vote_value; $sql = sprintf("SELECT count(*) as count, user_id = 0 as user FROM %sgdsr_votes_log%s group by (user_id = 0)", $table_prefix, $where ); return $sql; } function get_visitors($post_id, $vote_type = "article", $dates = "", $vote_value = 0, $select = "total", $start = 0, $limit = 20, $sort_column = '', $sort_order = '') { global $wpdb, $table_prefix; if ($sort_column == '') $sort_column = 'user_id'; if ($sort_order == '') $sort_order = 'asc'; if ($sort_column == 'ip') $sort_column = 'INET_ATON(p.ip)'; else if ($sort_column == 'user_nicename') $sort_column = "u.user_nicename"; else $sort_column = "p.".$sort_column; $where = " where vote_type = '".$vote_type."'"; $where.= " and p.id = ".$post_id; if ($dates != "" && $dates != "0") { $where.= " and year(p.voted) = ".substr($dates, 0, 4); $where.= " and month(p.voted) = ".substr($dates, 4, 2); } if ($select == "users") $where.= " and user_id > 0"; if ($select == "visitors") $where.= " and user_id = 0"; if ($vote_value > 0) $where.= " and vote = ".$vote_value; $sql = sprintf("SELECT p.*, u.user_nicename FROM %sgdsr_votes_log p LEFT JOIN %s u ON u.ID = p.user_id%s ORDER BY %s %s LIMIT %s, %s", $table_prefix, $wpdb->users, $where, $sort_column, $sort_order, $start, $limit); return $sql; } function get_stats_count($select = "", $dates = "0", $cats = "0", $search = "") { global $table_prefix; $where = ""; if ($dates != "" && $dates != "0") { $where.= " and year(p.post_date) = ".substr($dates, 0, 4); $where.= " and month(p.post_date) = ".substr($dates, 4, 2); } if ($search != "") $where.= " and p.post_title like '%".$search."%'"; if ($select != "") $where.= " and p.post_type = '".$select."'"; if ($cats != "" && $cats != "0") { $sql = sprintf("SELECT count(*) as count FROM %sterm_taxonomy t, %sterm_relationships r, %sposts p WHERE t.term_taxonomy_id = r.term_taxonomy_id AND r.object_id = p.ID AND t.term_id = %s AND p.post_status = 'publish'%s", $table_prefix, $table_prefix, $table_prefix, $cats, $where); } else { $sql = sprintf("select count(*) as count from %sposts p where p.post_status = 'publish'%s", $table_prefix, $where); } return $sql; } function get_stats($select = "", $start = 0, $limit = 20, $dates = "0", $cats = "0", $search = "", $sort_column = 'id', $sort_order = 'desc', $additional = '') { global $table_prefix; $where = ""; $extras = ", '' as total, '' as votes, '' as title, 0 as rating_total, 0 as rating_users, 0 as rating_visitors"; if ($dates != "" && $dates != "0") { $where.= " and year(p.post_date) = ".substr($dates, 0, 4); $where.= " and month(p.post_date) = ".substr($dates, 4, 2); } if ($search != "") $where.= " and p.post_title like '%".$search."%'"; if ($select != "" && $select != "postpage") $where.= " and post_type = '".$select."'"; if ($sort_column == 'post_title' || $sort_column == 'id') $order = " ORDER BY p.".$sort_column." ".$sort_order; else $order = " ORDER BY ".$sort_column." ".$sort_order; if ($cats != "" && $cats != "0") $sql = sprintf("SELECT p.id as pid, p.post_title, p.post_type, d.*%s FROM %sterm_taxonomy t, %sterm_relationships r, %sposts p, %sgdsr_data_article d WHERE d.post_id = p.id and t.term_taxonomy_id = r.term_taxonomy_id AND r.object_id = p.id AND t.term_id = %s AND p.post_status = 'publish'%s%s%s LIMIT %s, %s", $extras, $table_prefix, $table_prefix, $table_prefix, $table_prefix, $cats, $where, $additional, $order, $start, $limit ); else $sql = sprintf("SELECT p.id as pid, p.post_title, p.post_type, d.*%s FROM %sposts p left join %sgdsr_data_article d on p.id = d.post_id WHERE p.post_status = 'publish'%s%s%s limit %s, %s", $extras, $table_prefix, $table_prefix, $where, $additional, $order, $start, $limit ); return $sql; } function check_post_review($post_id) { global $wpdb, $table_prefix; $articles = $table_prefix.'gdsr_data_article'; $sql = "select review from ".$articles." WHERE post_id = ".$post_id; $results = $wpdb->get_row($sql, OBJECT); return count($results) > 0; } function get_categories($post_id) { global $wpdb; $sql = "SELECT s.name FROM $wpdb->term_taxonomy t, $wpdb->terms s, $wpdb->term_relationships r WHERE t.taxonomy = 'category' AND t.term_taxonomy_id = r.term_taxonomy_id AND t.term_id = s.term_id AND r.object_id = ".$post_id; $cats = $wpdb->get_results($sql); $output = ''; foreach ($cats as $cat) $output.= $cat->name.", "; $output = $output != '' ? substr($output, 0, strlen($output) - 2) : '/'; return $output; } function update_category_settings($ids, $ids_array, $items, $upd_am, $upd_ar, $upd_cm, $upd_cr, $upd_ms, $frc_std, $frc_mur) { global $wpdb, $table_prefix; GDSRDatabase::add_category_defaults($ids, $ids_array, $items); $dbt_data_cats = $table_prefix.'gdsr_data_category'; $update = array(); if ($frc_std != '') $update[] = "cmm_integration_std = '".$frc_std."'"; if ($frc_mur != '') $update[] = "cmm_integration_mur = '".$frc_mur."'"; if ($upd_ms != '') $update[] = "cmm_integration_set = '".$upd_ms."'"; if ($upd_am != '') $update[] = "moderate_articles = '".$upd_am."'"; if ($upd_cm != '') $update[] = "moderate_comments = '".$upd_cm."'"; if ($upd_ar != '') $update[] = "rules_articles = '".$upd_ar."'"; if ($upd_cr != '') $update[] = "rules_comments = '".$upd_cr."'"; if (count($update) > 0) { $updstring = join(", ", $update); $sql = sprintf("update %s set %s where category_id in %s", $dbt_data_cats, $updstring, "(".join(", ", $ids_array).")"); $wpdb->query($sql); } } function update_reviews($ids, $review, $ids_array) { global $wpdb, $table_prefix; GDSRDatabase::add_defaults($ids, $ids_array); $dbt_data_article = $table_prefix.'gdsr_data_article'; $wpdb->query(sprintf("update %s set review = %s where post_id in %s", $dbt_data_article, $review, $ids)); } function update_settings_full($upd_am, $upd_ar, $upd_cm, $upd_cr, $upd_atm, $upd_atr, $upd_ctm, $upd_ctr) { global $wpdb, $table_prefix; $dbt_data_article = $table_prefix.'gdsr_data_article'; $update = array(); if ($upd_am != '') $update[] = "moderate_articles = '".$upd_am."'"; if ($upd_cm != '') $update[] = "moderate_comments = '".$upd_cm."'"; if ($upd_ar != '') $update[] = "rules_articles = '".$upd_ar."'"; if ($upd_cr != '') $update[] = "rules_comments = '".$upd_cr."'"; if ($upd_atm != '') $update[] = "recc_moderate_articles = '".$upd_am."'"; if ($upd_ctm != '') $update[] = "recc_moderate_comments = '".$upd_cm."'"; if ($upd_atr != '') $update[] = "recc_rules_articles = '".$upd_ar."'"; if ($upd_ctr != '') $update[] = "recc_rules_comments = '".$upd_cr."'"; if (count($update) > 0) { $updstring = join(", ", $update); $sql = sprintf("update %s set %s", $dbt_data_article, $updstring); $wpdb->query($sql); } } function lock_post_massive($date) { global $wpdb, $table_prefix; $sql = sprintf("update %sgdsr_data_article a inner join %sposts p on a.post_id = p.id set a.rules_articles = 'N', a.rules_comments = 'N' where p.post_date < '%s'", $table_prefix, $table_prefix, $date); $wpdb->query($sql); } function update_restrictions($ids, $timer_type, $timer_value) { global $wpdb, $table_prefix; $wpdb->query(sprintf("update %sgdsr_data_article set expiry_type = '%s', expiry_value = '%s' where post_id in %s", $table_prefix, $timer_type, $timer_value, $ids)); } function update_restrictions_thumbs($ids, $timer_type, $timer_value) { global $wpdb, $table_prefix; $wpdb->query(sprintf("update %sgdsr_data_article set recc_expiry_type = '%s', recc_expiry_value = '%s' where post_id in %s", $table_prefix, $timer_type, $timer_value, $ids)); } function upgrade_integration($ids, $cmm_std, $cmm_mur, $cmm_set) { global $wpdb, $table_prefix; $dbt_data_article = $table_prefix.'gdsr_data_article'; $update = array(); if ($cmm_std != '') $update[] = "cmm_integration_std = '".$cmm_std."'"; if ($cmm_mur != '') $update[] = "cmm_integration_mur = '".$cmm_mur."'"; if ($cmm_set != '') $update[] = "cmm_integration_set = ".$cmm_set; if (count($update) > 0) { $updstring = join(", ", $update); $wpdb->query(sprintf("update %s set %s where post_id in %s", $dbt_data_article, $updstring, $ids)); } } function update_settings($ids, $upd_am, $upd_ar, $upd_cm, $upd_cr, $upd_am_rcc, $upd_ar_rcc, $upd_cm_rcc, $upd_cr_rcc, $ids_array) { global $wpdb, $table_prefix; GDSRDatabase::add_defaults($ids, $ids_array); $dbt_data_article = $table_prefix.'gdsr_data_article'; $update = array(); if ($upd_am != '') $update[] = "moderate_articles = '".$upd_am."'"; if ($upd_cm != '') $update[] = "moderate_comments = '".$upd_cm."'"; if ($upd_ar != '') $update[] = "rules_articles = '".$upd_ar."'"; if ($upd_cr != '') $update[] = "rules_comments = '".$upd_cr."'"; if ($upd_am_rcc != '') $update[] = "recc_moderate_articles = '".$upd_am_rcc."'"; if ($upd_cm_rcc != '') $update[] = "recc_moderate_comments = '".$upd_cm_rcc."'"; if ($upd_ar_rcc != '') $update[] = "recc_rules_articles = '".$upd_ar_rcc."'"; if ($upd_cr_rcc != '') $update[] = "recc_rules_comments = '".$upd_cr_rcc."'"; if (count($update) > 0) { $updstring = join(", ", $update); $wpdb->query(sprintf("update %s set %s where post_id in %s", $dbt_data_article, $updstring, $ids)); } } function delete_voters_log($ids) { global $wpdb, $table_prefix; $sql = sprintf("delete from %sgdsr_votes_log where record_id in %s", $table_prefix, $ids); $wpdb->query($sql); } function delete_voters_main_thumb($id, $value, $article = true, $user = true) { global $wpdb, $table_prefix; $update = ""; if ($value > 0) { if (!$user) $update = "visitor_recc_plus = visitor_recc_plus - 1"; else $update = "user_recc_plus = user_recc_plus - 1"; } else { if (!$user) $update = "visitor_recc_minus = visitor_recc_minus - 1"; else $update = "user_recc_minus = user_recc_minus - 1"; } $sql = sprintf("update %sgdsr_data_%s set %s where %s_id = %s", $table_prefix, $article ? "article" : "comment", $mod, $article ? "post" : "comment", $id); $wpdb->query($sql); } function delete_voters_main($id, $value, $article = true, $user = true) { global $wpdb, $table_prefix; $mod = $user ? "user_voters = user_voters - 1, user_votes = user_votes - 1" : "visitor_voters = visitor_voters - 1, visitor_votes = visitor_votes - ".$value; $sql = sprintf("update %sgdsr_data_%s set %s where %s_id = %s", $table_prefix, $article ? "article" : "comment", $mod, $article ? "post" : "comment", $id); $wpdb->query($sql); } function delete_voters_full($ids, $vote_type, $thumb = false) { global $wpdb, $table_prefix; if ($vote_type == "artthumb") $vote_type = "article"; if ($vote_type == "cmmthumb") $vote_type = "comment"; $delfrom = $table_prefix."gdsr_data_".$vote_type; if ($thumb) { $sql = sprintf("select id, user_id, vote from %sgdsr_votes_log where record_id in %s", $table_prefix, $ids); $del = $wpdb->get_results($sql); if (count($del) > 0) { foreach ($del as $d) { $update = ""; if ($d->vote > 0) { if ($d->user_id == 0) $update = "visitor_recc_plus = visitor_recc_plus - 1"; else $update = "user_recc_plus = user_recc_plus - 1"; } else { if ($d->user_id == 0) $update = "visitor_recc_minus = visitor_recc_minus - 1"; else $update = "user_recc_minus = user_recc_minus - 1"; } $sql = sprintf("update %s set %s where post_id = %s", $delfrom, $update, $d->id); $wpdb->query($sql); } } } else { $sql = sprintf("select id, user_id = 0 as user, count(*) as count, sum(vote) as votes from %sgdsr_votes_log where record_id in %s group by id, (user_id = 0)", $table_prefix, $ids); $del = $wpdb->get_results($sql); if (count($del) > 0) { foreach ($del as $d) { if ($d->user == 0) $update = sprintf("user_voters = user_voters - %s, user_votes = user_votes - %s", $d->count, $d->votes); else $update = sprintf("visitor_voters = visitor_voters - %s, visitor_votes = visitor_votes - %s", $d->count, $d->votes); $sql = sprintf("update %s set %s where post_id = %s", $delfrom, $update, $d->id); $wpdb->query($sql); } } } $sql = sprintf("delete from %sgdsr_votes_log where record_id in %s", $table_prefix, $ids); $wpdb->query($sql); } // ip function get_all_banned_ips($start = 0, $limit = 0) { global $wpdb, $table_prefix; if ($limit > 0) $limiter = " LIMIT ".$start.", ".$limit; else $limiter = ""; return $wpdb->get_results(sprintf("select * from %sgdsr_ips where status = 'B'%s", $table_prefix, $limiter)); } function get_all_banned_ips_count() { global $wpdb, $table_prefix; return $wpdb->get_var(sprintf("select count(*) from %sgdsr_ips where status = 'B'", $table_prefix)); } function ban_ip_check($ip, $mode = 'S') { global $wpdb, $table_prefix; $sql = sprintf("select count(*) from %sgdsr_ips where `status` = 'B' and `mode` = '%s' and `ip` = '%s'", $table_prefix, $mode, $ip); $result = $wpdb->get_var($sql); return !($result == 0); } function ban_ip($ip, $mode = 'S') { global $wpdb, $table_prefix; if ($mode == 'S') $ip = GDSRHelper::clean_ip($ip); if (!gdsrAdmDB::ban_ip_check($ip, $mode)) $wpdb->query(sprintf("INSERT INTO %sgdsr_ips (`status`, `mode`, `ip`) VALUES ('B', '%s', '%s')", $table_prefix, $mode, $ip)); } function ban_ip_range($ip_from, $ip_to) { global $wpdb, $table_prefix; $ip = $ip_from."|".$ip_to; gdsrAdmDB::ban_ip($ip, 'R'); } function unban_ips($ips) { global $wpdb, $table_prefix; $sql = sprintf("delete from %sgdsr_ips where id in %s", $table_prefix, $ips); $wpdb->query($sql); } // ip //users function get_valid_users() { global $wpdb, $table_prefix; $sql = sprintf("SELECT l.user_id, l.vote_type, count(*) as voters, sum(l.vote) as votes, count(distinct ip) as ips, u.display_name, u.user_email FROM %sgdsr_votes_log l left join %s u on u.id = l.user_id group by user_id, vote_type order by user_id, vote_type", $table_prefix, $wpdb->users); return $wpdb->get_results($sql); } function get_valid_users_count() { global $wpdb, $table_prefix; $sql = sprintf("SELECT count(distinct user_id) from %sgdsr_votes_log", $table_prefix); return $wpdb->get_var($sql); } function get_user_log($user_id, $vote_type, $vote_value = 0, $start = 0, $limit = 20, $ip = "") { global $wpdb, $table_prefix; $types = array("article", "artthumb", "comment", "cmmthumb"); if (!in_array($vote_type, $types)) return array(); $join = $select = ""; $vote_value = $vote_value > 0 ? ' and vote = '.$vote_value : ''; $range = $limit > 0 ? sprintf("limit %s, %s", $start, $limit) : ""; $ip = $ip != '' ? ' and l.ip in ('.$ip.')' : ""; if ($vote_type == "article" || $vote_type == "artthumb") { $join = sprintf("%sposts o on o.ID = l.id", $table_prefix); $select = "o.post_title, o.ID as post_id, o.ID as control_id"; } else if ($vote_type == "comment" || $vote_type == "cmmthumb") { $join = sprintf("%scomments o on o.comment_ID = l.id left join %sposts p on p.ID = o.comment_post_ID", $table_prefix, $table_prefix); $select = "o.comment_content, o.comment_author as author, o.comment_ID as control_id, p.post_title, p.ID as post_id"; } $sql = sprintf("SELECT 1 as span, l.*, i.status, %s from %sgdsr_votes_log l left join %s left join %sgdsr_ips i on i.ip = l.ip where l.user_id = %s and l.vote_type = '%s'%s%s order by l.ip asc, l.voted desc %s", $select, $table_prefix, $join, $table_prefix, $user_id, $vote_type, $vote_value, $ip, $range); return $wpdb->get_results($sql); } function get_count_user_log($user_id, $vote_type, $vote_value = 0) { global $wpdb, $table_prefix; if ($vote_value > 0) $vote_value = ' and vote = '.$vote_value; else $vote_value = ''; $sql = sprintf("SELECT count(*) from %sgdsr_votes_log where user_id = %s and vote_type = '%s'%s", $table_prefix, $user_id, $vote_type, $vote_value); return $wpdb->get_var($sql); } //users // moderation function get_moderation_count($id, $vote_type = 'article', $user = 'all') { global $wpdb, $table_prefix; if ($user == "all") $users = ''; else if ($user == "users") $users = ' and user_id > 0'; else if ($user == "visitors") $users = ' and user_id = 0'; else $users = ' and user_id = '.$user; $sql = sprintf("select count(*) from %s where id = %s and vote_type = '%s'%s", $table_prefix."gdsr_moderate", $id, $vote_type, $users); return $wpdb->get_var($sql); } function get_moderation_count_joined($post_id, $vote_type = 'article', $user = 'all') { global $wpdb, $table_prefix; if ($user == "all") $users = ''; else if ($user == "users") $users = ' and m.user_id > 0'; else if ($user == "visitors") $users = ' and m.user_id = 0'; else $users = ' and m.user_id = '.$user; $sql = sprintf("select count(*) from %s c inner join %s m on m.id = c.comment_ID where c.comment_post_ID = %s and m.vote_type = '%s'%s", $wpdb->comments, $table_prefix."gdsr_moderate", $post_id, $vote_type, $users); return $wpdb->get_var($sql); } function get_moderation($post_id, $vote_type = 'article', $start = 0, $limit = 20, $user = 'all') { global $wpdb, $table_prefix; if ($user == "all") $users = ''; else if ($user == "users") $users = ' and user_id > 0'; else if ($user == "visitors") $users = ' and m.user_id = 0'; else $users = ' and m.user_id = '.$user; $sql = sprintf("select m.*, u.user_login as username from %s m left join %s u on u.id = m.user_id where m.id = %s and m.vote_type = '%s'%s order by m.voted desc LIMIT %s, %s", $table_prefix."gdsr_moderate", $wpdb->users, $post_id, $vote_type, $users, $start, $limit ); return $sql; } function get_moderation_joined($post_id, $start = 0, $limit = 20, $user = 'all') { global $wpdb, $table_prefix; if ($user == "all") $users = ''; else if ($user == "users") $users = ' and m.user_id > 0'; else if ($user == "visitors") $users = ' and m.user_id = 0'; else $users = ' and m.user_id = '.$user; $sql = sprintf("select m.*, u.user_login as username from %s c inner join %s m on m.id = c.comment_ID left join %s u on u.id = m.user_id where c.comment_post_ID = %s and m.vote_type = 'comment'%s order by m.voted desc LIMIT %s, %s", $wpdb->comments, $table_prefix."gdsr_moderate", $wpdb->users, $post_id, $users, $start, $limit ); return $sql; } // moderation // 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 // insert templates function install_all_templates() { gdsrAdmDB::insert_default_templates(STARRATING_PATH); gdsrAdmDB::insert_extras_templates(STARRATING_PATH); gdsrAdmDB::insert_extras_templates(STARRATING_XTRA_PATH, false); gdsrAdmDB::update_default_templates(STARRATING_PATH); gdsrAdmDB::update_extras_templates(STARRATING_PATH); } function insert_extras_templates($path, $default = true) { global $wpdb, $table_prefix; $templates = array(); if ($default) $path.= "install/data/gdsr_templates_xtra.txt"; else $path.= "data/gdsr_templates_cstm.txt"; $preinstalled = $default ? "2" : "0"; if (file_exists($path)) { $tpls = file($path); foreach ($tpls as $tpl) { $pipe = strpos($tpl, "|"); $tpl_check = substr($tpl, 0, $pipe); $tpl_section = substr($tpl, $pipe + 1, 3); $tpl_insert = substr($tpl, $pipe + 5); $sql = sprintf("select template_id from %s%s where name = '%s' and preinstalled = '%s'", $table_prefix, STARRATING_TPLT2_TABLE, $tpl_check, $preinstalled); $tpl_id = intval($wpdb->get_var($sql)); if ($tpl_id == 0) { $sql = str_replace("%s", $table_prefix, $tpl_insert); $wpdb->query($sql); $tpl_id = $wpdb->insert_id; } $templates[] = array("section" => $tpl_section, "tpl_id" => sprintf("%s", $tpl_id)); } } if (count($templates) > 0) { include(STARRATING_PATH.'code/t2/templates.php'); $depend = array(); foreach ($tpls->tpls as $tpl) { $section = $tpl->code; $sql = sprintf("select template_id from %s%s where section = '%s' and preinstalled = '1'", $table_prefix, STARRATING_TPLT2_TABLE, $section); $tpl_id = intval($wpdb->get_var($sql)); $depend[$section] = $tpl_id; } foreach ($templates as $tpl) { $dep = array(); $t = $tpls->get_list($tpl["section"]); foreach ($t->tpls as $tag) { $s = $tag->code; $dep[$s] = sprintf("%s", $depend[$s]); } if (count($dep) > 0) { $sql = sprintf("update %s%s set dependencies = '%s' where template_id = %s", $table_prefix, STARRATING_TPLT2_TABLE, serialize($dep), $tpl["tpl_id"]); $wpdb->query($sql); } } } } function insert_default_templates($path) { global $wpdb, $table_prefix; $templates = array(); $path.= "install/data/gdsr_templates_main.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 template_id from %s%s where section = '%s' and preinstalled = '1'", $table_prefix, STARRATING_TPLT2_TABLE, $tpl_check); $tpl_id = intval($wpdb->get_var($sql)); if ($tpl_id == 0) { $sql = str_replace("%s", $table_prefix, $tpl_insert); $wpdb->query($sql); $tpl_id = $wpdb->insert_id; } $templates[$tpl_check] = sprintf("%s", $tpl_id); } } if (count($templates) > 0) { include(STARRATING_PATH.'code/t2/templates.php'); foreach ($tpls->tpls as $tpl) { $depend = array(); foreach ($tpl->elements as $el) { if ($el->tpl > -1) { $section = $tpl->tpls[$el->tpl]->code; $depend[$section] = $templates[$section]; } } if (count($depend) > 0) { $sql = sprintf("update %s%s set dependencies = '%s' where template_id = %s", $table_prefix, STARRATING_TPLT2_TABLE, serialize($depend), $templates[$tpl->code]); $wpdb->query($sql); } } } } function update_default_templates($path) { global $wpdb, $table_prefix; $path.= "install/data/gdsr_templates_rplc.txt"; if (file_exists($path)) { $tpls = file($path); foreach ($tpls as $tpl) { $tpl_check = substr($tpl, 0, 3); $tpl_value = substr($tpl, 4); $sql = sprintf("update %s%s set elements = '%s' where section = '%s' and preinstalled = '1'", $table_prefix, STARRATING_TPLT2_TABLE, $tpl_value, $tpl_check); $wpdb->query($sql); } } } function update_extras_templates($path) { global $wpdb, $table_prefix; $path.= "install/data/gdsr_templates_xtrp.txt"; if (file_exists($path)) { $tpls = file($path); foreach ($tpls as $tpl) { $parts = explode("|", $tpl, 3); $sql = sprintf("update %s%s set elements = '%s' where section = '%s' and name = '%s' and preinstalled = '2'", $table_prefix, STARRATING_TPLT2_TABLE, $parts[2], $parts[1], $parts[0]); $wpdb->query($sql); } } } // insert 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 // conversion function convert_multi_row($row) { } function convert_row($row, $multis = array()) { $mur = $row->cmm_integration_mur; 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; } switch ($row->recc_moderate_articles) { case 'I': $row->recc_moderate_articles = __("articles", "gd-star-rating").': '.__("inherited", "gd-star-rating").''; break; case 'A': $row->recc_moderate_articles = __("articles", "gd-star-rating").': '.__("all", "gd-star-rating").''; break; case 'V': $row->recc_moderate_articles = __("articles", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->recc_moderate_articles = __("articles", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; case 'N': default: $row->recc_moderate_articles = __("articles", "gd-star-rating").': '.__("free", "gd-star-rating").''; break; } switch ($row->recc_moderate_comments) { case 'I': $row->recc_moderate_comments = __("comments", "gd-star-rating").': '.__("inherited", "gd-star-rating").''; break; case 'A': $row->recc_moderate_comments = __("comments", "gd-star-rating").': '.__("all", "gd-star-rating").''; break; case 'V': $row->recc_moderate_comments = __("comments", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->recc_moderate_comments = __("comments", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; case 'N': default: $row->recc_moderate_comments = __("comments", "gd-star-rating").': '.__("free", "gd-star-rating").''; break; } switch ($row->recc_rules_articles) { case 'I': $row->recc_rules_articles = __("articles", "gd-star-rating").': '.__("inherited", "gd-star-rating").''; break; case 'H': $row->recc_rules_articles = __("articles", "gd-star-rating").': '.__("hidden", "gd-star-rating").''; break; case 'N': $row->recc_rules_articles = __("articles", "gd-star-rating").': '.__("locked", "gd-star-rating").''; break; case 'V': $row->recc_rules_articles = __("articles", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->recc_rules_articles = __("articles", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; default: $row->recc_rules_articles = __("articles", "gd-star-rating").': '.__("everyone", "gd-star-rating").''; break; } switch ($row->recc_rules_comments) { case 'I': $row->recc_rules_comments = __("comments", "gd-star-rating").': '.__("inherited", "gd-star-rating").''; break; case 'H': $row->recc_rules_comments = __("comments", "gd-star-rating").': '.__("hidden", "gd-star-rating").''; break; case 'N': $row->recc_rules_comments = __("comments", "gd-star-rating").': '.__("locked", "gd-star-rating").''; break; case 'V': $row->recc_rules_comments = __("comments", "gd-star-rating").': '.__("visitors", "gd-star-rating").''; break; case 'U': $row->recc_rules_comments = __("comments", "gd-star-rating").': '.__("users", "gd-star-rating").''; break; default: $row->recc_rules_comments = __("comments", "gd-star-rating").': '.__("everyone", "gd-star-rating").''; break; } switch ($row->cmm_integration_std) { default: case 'I': $row->cmm_integration_std = ''.__("inherit from category", "gd-star-rating").''; break; case 'N': $row->cmm_integration_std = ''.__("force hidden", "gd-star-rating").''; break; case 'A': $row->cmm_integration_mur = ''.__("normal activity", "gd-star-rating"); break; } switch ($row->cmm_integration_mur) { default: case 'I': $row->cmm_integration_mur = ''.__("inherit from category", "gd-star-rating").''; break; case 'N': $row->cmm_integration_mur = ''.__("force hidden", "gd-star-rating").''; break; case 'A': $row->cmm_integration_mur = ''.__("normal activity", "gd-star-rating"); break; } $votes_v = $votes_u = $votes_t = '/'; $count_v = $count_u = $count_t = '[ 0 ] '; if ($row->visitor_voters > 0) { $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) { $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 == "/" ? "-" : "+").' ] '.__("review", "gd-star-rating").': '.$row->review.''; $total_votes = $row->visitor_votes + $row->user_votes; $total_voters = $row->visitor_voters + $row->user_voters; if ($total_voters > 0) { $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); } $cnt_thumb_v = $cnt_thumb_u = $cnt_thumb_t = '0'; $vts_thumb_v = $vts_thumb_u = $vts_thumb_t = '[ 0 ] '; if ($row->user_recc_plus > 0 || $row->user_recc_minus > 0) { $score = $row->user_recc_plus - $row->user_recc_minus; $votes = $row->user_recc_plus + $row->user_recc_minus; $cnt_thumb_u = ''.($score > 0 ? "+" : "").$score.''; $vts_thumb_u = sprintf('[ %s ] ', $row->pid, $votes); } if ($row->visitor_recc_plus > 0 || $row->visitor_recc_minus > 0) { $score = $row->visitor_recc_plus - $row->visitor_recc_minus; $votes = $row->visitor_recc_plus + $row->visitor_recc_minus; $cnt_thumb_v = ''.($score > 0 ? "+" : "").$score.''; $vts_thumb_v = sprintf('[ %s ] ', $row->pid, $votes); } if ($row->user_recc_plus > 0 || $row->user_recc_minus > 0 || $row->visitor_recc_plus > 0 || $row->visitor_recc_minus > 0) { $score = $row->user_recc_plus - $row->user_recc_minus + $row->visitor_recc_plus - $row->visitor_recc_minus; $votes = $row->user_recc_plus + $row->user_recc_minus + $row->visitor_recc_plus + $row->visitor_recc_minus; $cnt_thumb_t = ''.($score > 0 ? "+" : "").$score.''; $vts_thumb_t = sprintf('[ %s ] ', $row->pid, $votes); } $row->total = $count_t.__("rating", "gd-star-rating").': '.$votes_t.'
'; $row->total.= $row->review.'
'; $row->total.= $vts_thumb_t.__("rating", "gd-star-rating").': '.$cnt_thumb_t.''; $row->votes = $count_v.__("visitors", "gd-star-rating").': '.$votes_v.'
'.$count_u.__("users", "gd-star-rating").': '.$votes_u.''; $row->thumbs = $vts_thumb_v.__("visitors", "gd-star-rating").': '.$cnt_thumb_v.'
'.$vts_thumb_u.__("users", "gd-star-rating").': '.$cnt_thumb_u.''; if ($mur == "I" || $mur == "") $row->cmm_integration_mur.= "

"; else $row->cmm_integration_mur.= "
".$row->cmm_integration_set == 0 ? __("no multi set assigned", "gd-star-rating") : __("multi set", "gd-star-rating").': '.$multis["cmm_integration_set"].''; $row->cmm_integration_std.= "

"; $row->title = sprintf('%s', get_edit_post_link($row->pid), $row->post_title); $row->views = intval($row->views); return $row; } function convert_category_row($row) { switch ($row->moderate_articles) { case 'P': $row->moderate_articles = __("articles", "gd-star-rating").': '.__("parent", "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 'P': $row->moderate_comments = __("comments", "gd-star-rating").': '.__("parent", "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 'P': $row->rules_articles = __("articles", "gd-star-rating").': '.__("parent", "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; case 'A': default: $row->rules_articles = __("articles", "gd-star-rating").': '.__("everyone", "gd-star-rating").''; break; } switch ($row->rules_comments) { case 'P': $row->rules_comments = __("comments", "gd-star-rating").': '.__("parent", "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; case 'A': 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) { $votes_v = '/'; $count_v = '[ 0 ] '; if ($row->visitor_voters > 0) { $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); } $votes_u = '/'; $count_u = '[ 0 ] '; if ($row->user_voters > 0) { $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; $votes_t = '/'; $count_t = '[ 0 ] '; if ($total_voters > 0) { $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); } $cnt_thumb_v = $cnt_thumb_u = $cnt_thumb_t = '0'; $vts_thumb_v = $vts_thumb_u = $vts_thumb_t = '[ 0 ] '; if ($row->user_recc_plus > 0 || $row->user_recc_minus > 0) { $score = $row->user_recc_plus - $row->user_recc_minus; $votes = $row->user_recc_plus + $row->user_recc_minus; $cnt_thumb_u = ''.($score > 0 ? "+" : "").$score.''; $vts_thumb_u = sprintf('[ %s ] ', $row->comment_id, $votes); } if ($row->visitor_recc_plus > 0 || $row->visitor_recc_minus > 0) { $score = $row->visitor_recc_plus - $row->visitor_recc_minus; $votes = $row->visitor_recc_plus + $row->visitor_recc_minus; $cnt_thumb_v = ''.($score > 0 ? "+" : "").$score.''; $vts_thumb_v = sprintf('[ %s ] ', $row->comment_id, $votes); } if ($row->user_recc_plus > 0 || $row->user_recc_minus > 0 || $row->visitor_recc_plus > 0 || $row->visitor_recc_minus > 0) { $score = $row->user_recc_plus - $row->user_recc_minus + $row->visitor_recc_plus - $row->visitor_recc_minus; $votes = $row->user_recc_plus + $row->user_recc_minus + $row->visitor_recc_plus + $row->visitor_recc_minus; $cnt_thumb_t = ''.($score > 0 ? "+" : "").$score.''; $vts_thumb_t = sprintf('[ %s ] ', $row->comment_id, $votes); } $row->total = $count_t.__("votes", "gd-star-rating").': '.$votes_t.'
'.$vts_thumb_t.__("thumbs", "gd-star-rating").': '.$cnt_thumb_t.''; $row->votes = $count_v.__("visitors", "gd-star-rating").': '.$votes_v.'
'.$count_u.__("users", "gd-star-rating").': '.$votes_u.''; $row->thumbs = $vts_thumb_v.__("visitors", "gd-star-rating").': '.$cnt_thumb_v.'
'.$vts_thumb_u.__("users", "gd-star-rating").': '.$cnt_thumb_u.''; if ($row->review == -1) $row->review = "/"; $row->review = ''.$row->review.''; return $row; } // conversion function get_post_title($post_id) { global $wpdb; return $wpdb->get_var("select post_title from $wpdb->posts where ID = ".$post_id); } function get_user_votes_overview($user) { global $wpdb, $table_prefix; $sql = sprintf("select vote_type, count(*) as counter from %sgdsr_votes_log where user_id = %s group by vote_type", $table_prefix, $user); $results = $wpdb->get_results($sql); $data = array(); foreach ($results as $r) { $data[$r->vote_type] = intval($r->counter); } return $data; } function filter_votes_by_type($user, $filter = "'multis', 'artthumb', 'article'", $posts = true) { global $wpdb, $table_prefix; $select = "l.id, l.vote_type, l.voted, l.vote, l.ip, l.user_id, u.display_name, u.user_email"; $from = sprintf("%sgdsr_votes_log l left join %s u on u.ID = l.user_id", $table_prefix, $wpdb->users); if ($posts) { $select.= ", l.object, m.stars, m.weight, m.name"; $from.= sprintf(" left join %sgdsr_multis m on m.multi_id = l.multi_id", $table_prefix); $from.= sprintf(" inner join %sposts p on p.ID = l.id", $table_prefix); $where = " and p.post_author = ".$user; } else { $from.= sprintf(" inner join %scomments c on c.comment_ID = l.id", $table_prefix); $where = " and c.user_id = ".$user; } $sql = sprintf("select %s from %s where vote_type in (%s)%s order by l.voted desc limit 0, %s", $select, $from, $filter, $where, 100); return $wpdb->get_results($sql); } // 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") gdsrBlgDB::add_vote($row->id, $row->user_id, $row->ip, $row->user_agent, $row->vote); if ($row->vote_type == "comment") gdsrBlgDB::add_vote_comment($row->id, $row->user_id, $row->ip, $row->user_agent, $row->vote); } gdsrAdmDB::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 // combox function get_combo_post_types($selected = "0", $name = "gdsr_postype") { $ptypes = gdsr_get_public_post_types(); ?> posts WHERE post_type = 'post' ORDER BY post_date DESC"; $arc_result = $wpdb->get_results($arc_query); $month_count = count($arc_result); if ($month_count && !(1 == $month_count && 0 == $arc_result[0]->mmonth)) { ?> users"; $arc_result = $wpdb->get_results($arc_query); ?> __("All categories", "gd-star-rating"), 'hide_empty' => 0, 'hierarchical' => 1, 'show_count' => 0, 'echo' => 1, 'orderby' => 'name', 'selected' => $selected, 'name' => $name); wp_dropdown_categories($dropdown_options); } // combos } class gdsrTlsDB { function clean_invalid_log_articles() { global $wpdb, $table_prefix; $sql = sprintf("delete %s from %sgdsr_votes_log 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_log", $table_prefix) : "l", $table_prefix, $table_prefix); $wpdb->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_revision_articles() { global $wpdb, $table_prefix; $sql = sprintf("delete %s from %sgdsr_data_article l inner join %sposts o on o.ID = l.post_id where o.post_type = 'revision'", 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 gdsrAdmFunc { /** * Scans main and additional graphics folders for stars and trends sets. * * @return GDgfxLib scanned graphics object */ function gfx_scan() { $data = new GDgfxLib(); $stars_folders = gdFunctionsGDSR::get_folders(STARRATING_PATH."stars/"); foreach ($stars_folders as $f) { $gfx = new GDgfxStar($f); if ($gfx->imported) $data->stars[] = $gfx; } if (is_dir(STARRATING_XTRA_PATH."stars/")) { $stars_folders = gdFunctionsGDSR::get_folders(STARRATING_XTRA_PATH."stars/"); foreach ($stars_folders as $f) { $gfx = new GDgfxStar($f, false); if ($gfx->imported) $data->stars[] = $gfx; } } $trend_folders = gdFunctionsGDSR::get_folders(STARRATING_PATH."trends/"); foreach ($trend_folders as $f) { $gfx = new GDgfxTrend($f); if ($gfx->imported) $data->trend[] = $gfx; } if (is_dir(STARRATING_XTRA_PATH."trends/")) { $trend_folders = gdFunctionsGDSR::get_folders(STARRATING_XTRA_PATH."trends/"); foreach ($trend_folders as $f) { $gfx = new GDgfxTrend($f, false); if ($gfx->imported) $data->trend[] = $gfx; } } $thumbs_folders = gdFunctionsGDSR::get_folders(STARRATING_PATH."thumbs/"); foreach ($thumbs_folders as $f) { $gfx = new GDgfxThumb($f); if ($gfx->imported) $data->thumbs[] = $gfx; } if (is_dir(STARRATING_XTRA_PATH."thumbs/")) { $thumbs_folders = gdFunctionsGDSR::get_folders(STARRATING_XTRA_PATH."thumbs/"); foreach ($thumbs_folders as $f) { $gfx = new GDgfxThumb($f, false); if ($gfx->imported) $data->thumbs[] = $gfx; } } return $data; } /** * Full uninstall of plugin. */ function init_uninstall() { if (isset($_POST["gdsr_full_uninstall"]) && $_POST["gdsr_full_uninstall"] == __("UNINSTALL", "gd-star-rating")) { require_once(STARRATING_PATH."gdragon/gd_db_install.php"); delete_option('gd-star-rating'); delete_option('widget_gdstarrating'); delete_option('gd-star-rating-import'); delete_option('gd-star-rating-gfx'); delete_option('gd-star-rating-inc'); gdDBInstallGDSR::drop_tables(STARRATING_PATH); gdWPGDSR::deactivate_plugin("gd-star-rating/gd-star-rating.php"); update_option('recently_activated', array("gd-star-rating/gd-star-rating.php" => time()) + (array)get_option('recently_activated')); wp_redirect('index.php'); exit; } } /** * Templates operations. */ function init_templates() { if (isset($_GET["deltpl"])) { $del_id = $_GET["deltpl"]; gdTemplateDB::delete_template($del_id); $url = remove_query_arg("deltpl"); wp_redirect($url); exit; } if (isset($_POST["gdsr_save_tpl"])) { $general = array(); $general["name"] = stripslashes(htmlentities($_POST['tpl_gen_name'], ENT_QUOTES, STARRATING_ENCODING)); $general["desc"] = stripslashes(htmlentities($_POST['tpl_gen_desc'], ENT_QUOTES, STARRATING_ENCODING)); $general["section"] = $_POST["tpl_section"]; $general["dependencies"] = $_POST["tpl_tpl"]; $general["id"] = $_POST["tpl_id"]; $general["preinstalled"] = '0'; $tpl_input = $_POST["tpl_element"]; $elements = array(); foreach ($tpl_input as $key => $value) { $elements[$key] = stripslashes(htmlentities($value, ENT_QUOTES, STARRATING_ENCODING)); } if ($general["id"] == 0) { $general["id"] = gdTemplateDB::add_template($general, $elements); } else { gdTemplateDB::edit_template($general, $elements); } if (isset($_POST["tpl_dep_rewrite"])) gdTemplateDB::rewrite_dependencies($general["section"], $general["id"]); if (isset($_POST["tpl_default_rewrite"])) gdTemplateDB::rewrite_defaults($general["section"], $general["id"]); $url = remove_query_arg("tplid"); $url = remove_query_arg("mode", $url); wp_redirect($url); exit; } } } ?>