Exemplo n.º 1
0
 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);
 }