function insert_result_in_db($result) { global $wpdb; $response['success'] = ""; $response['error'] = ""; $sql = $wpdb->query($wpdb->prepare("\r\r\n\t\t\t\tINSERT INTO {$wpdb->yop_poll_results} (\r\r\n\t\t\t\tpoll_id,\r\r\n\t\t\t\tvote_id,\r\r\n\t\t\t\tip ,\r\r\n\t\t\t\tuser_id,\r\r\n\t\t\t\tuser_type,\r\r\n\t\t\t\ttr_id,\r\r\n\t\t\t\tresult_details,\r\r\n\t\t\t\tuser_details,\r\r\n\t\t\t\tcountry,\r\r\n\t\t\t\tvote_date\r\r\n\t\t\t\t) VALUES ( %d, %s, %s, %s, %s, %s, %s, %s,%s, %s)", $result['poll_id'], $result['vote_id'], $result['ip'], $result['user_id'], $result['user_type'], $result['tr_id'], $result['vote_details'], $result['user_details'], $result['country'], isset($result['vote_date']) ? $result['vote_date'] : YOP_POLL_Poll_Model::get_mysql_curent_date())); if ($sql) { $response['success'] = __yop_poll('Votes added'); $response['insert_id'] = $wpdb->insert_id; } else { $response['error'] = __yop_poll('Could not insert log into database!'); } return $response; }