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); }