function save_vote($id, $user, $ip, $ua, $vote) { global $wpdb, $table_prefix; $ua = str_replace("'", "''", $ua); $ua = substr($ua, 0, 250); $articles = $table_prefix . 'gdsr_data_article'; $moderate = $table_prefix . 'gdsr_moderate'; $sql = sprintf("SELECT * FROM %s WHERE post_id = %s", $articles, $id); $post_data = $wpdb->get_row($sql); wp_gdsr_dump("SAVEVOTE_post_data_sql", $sql); wp_gdsr_dump("SAVEVOTE_post_data_sql_error", $wpdb->last_error); wp_gdsr_dump("SAVEVOTE_post_data", $post_data); if ($post_data->moderate_articles == "" || $post_data->moderate_articles == "N" || $post_data->moderate_articles == "V" && $user > 0 || $post_data->moderate_articles == "U" && $user == 0) { GDSRDatabase::add_vote($id, $user, $ip, $ua, $vote); } else { $modsql = sprintf("INSERT INTO %s (id, vote_type, user_id, vote, voted, ip, user_agent) VALUES (%s, 'article', %s, %s, '%s', '%s', '%s')", $moderate, $id, $user, $vote, str_replace("'", "''", current_time('mysql')), $ip, $ua); $wpdb->query($modsql); wp_gdsr_dump("SAVEVOTE_moderate_sql", $modsql); wp_gdsr_dump("SAVEVOTE_moderate_sql_error", $wpdb->last_error); wp_gdsr_dump("SAVEVOTE_moderate_row_id", $wpdb->insert_id); } wp_gdsr_dump("SAVEVOTE_completed", '', 'end'); }
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); }