@@ -2,8 +2,7 @@ |
||
2 | 2 | |
3 | 3 | use Fleet\DbFleetStatic; |
4 | 4 | |
5 | -function flt_mission_hold(&$mission_data) |
|
6 | -{ |
|
5 | +function flt_mission_hold(&$mission_data) { |
|
7 | 6 | if($mission_data['fleet']['fleet_end_stay'] < SN_TIME_NOW) |
8 | 7 | { |
9 | 8 | DbFleetStatic::fleet_send_back($mission_data['fleet']); |
@@ -5,8 +5,7 @@ discard block |
||
5 | 5 | require_once('db_queries_users.php'); |
6 | 6 | |
7 | 7 | |
8 | -function db_planet_list_admin_list($table_parent_columns, $planet_active, $active_time, $planet_type) |
|
9 | -{ |
|
8 | +function db_planet_list_admin_list($table_parent_columns, $planet_active, $active_time, $planet_type) { |
|
10 | 9 | return doquery( |
11 | 10 | "SELECT p.*, u.username" . ($table_parent_columns ? ', p1.name AS parent_name' : '') . |
12 | 11 | " FROM {{planets}} AS p |
@@ -15,8 +14,7 @@ discard block |
||
15 | 14 | " WHERE " . ($planet_active ? "p.last_update >= {$active_time}" : "p.planet_type = {$planet_type}")); |
16 | 15 | } |
17 | 16 | |
18 | -function db_planet_list_search($searchtext) |
|
19 | -{ |
|
17 | +function db_planet_list_search($searchtext) { |
|
20 | 18 | return doquery( |
21 | 19 | "SELECT |
22 | 20 | p.galaxy, p.system, p.planet, p.planet_type, p.name as planet_name, |
@@ -36,8 +34,7 @@ discard block |
||
36 | 34 | |
37 | 35 | |
38 | 36 | |
39 | -function db_user_list_search($searchtext) |
|
40 | -{ |
|
37 | +function db_user_list_search($searchtext) { |
|
41 | 38 | return doquery( |
42 | 39 | "SELECT |
43 | 40 | pn.player_name, u.id as uid, u.username, u.ally_id, u.id_planet, u.total_points, u.total_rank, |
@@ -55,8 +52,7 @@ discard block |
||
55 | 52 | ); |
56 | 53 | } |
57 | 54 | |
58 | -function db_buddy_list_by_user($user_id) |
|
59 | -{ |
|
55 | +function db_buddy_list_by_user($user_id) { |
|
60 | 56 | // return ($user_id = intval($user_id)) ? doquery( |
61 | 57 | return ($user_id = idval($user_id)) ? doquery( |
62 | 58 | "SELECT |
@@ -86,8 +82,7 @@ discard block |
||
86 | 82 | |
87 | 83 | |
88 | 84 | |
89 | -function db_unit_records_sum($unit_id, $user_skip_list_unit) |
|
90 | -{ |
|
85 | +function db_unit_records_sum($unit_id, $user_skip_list_unit) { |
|
91 | 86 | return doquery ( |
92 | 87 | "SELECT unit_player_id, username, sum(unit_level) as unit_level |
93 | 88 | FROM {{unit}} JOIN {{users}} AS u ON u.id = unit_player_id |
@@ -98,8 +93,7 @@ discard block |
||
98 | 93 | , true); |
99 | 94 | } |
100 | 95 | |
101 | -function db_unit_records_plain($unit_id, $user_skip_list_unit) |
|
102 | -{ |
|
96 | +function db_unit_records_plain($unit_id, $user_skip_list_unit) { |
|
103 | 97 | return doquery ( |
104 | 98 | "SELECT unit_player_id, username, unit_level |
105 | 99 | FROM {{unit}} JOIN {{users}} AS u ON u.id = unit_player_id |
@@ -183,15 +177,13 @@ discard block |
||
183 | 177 | } |
184 | 178 | |
185 | 179 | |
186 | -function db_stat_list_delete_ally_player() |
|
187 | -{ |
|
180 | +function db_stat_list_delete_ally_player() { |
|
188 | 181 | return doquery('DELETE s FROM `{{statpoints}}` AS s JOIN `{{users}}` AS u ON u.id = s.id_owner WHERE s.id_ally IS NULL AND u.user_as_ally IS NOT NULL'); |
189 | 182 | } |
190 | 183 | |
191 | 184 | |
192 | 185 | |
193 | -function db_chat_player_list_online($chat_refresh_rate, $ally_add) |
|
194 | -{ |
|
186 | +function db_chat_player_list_online($chat_refresh_rate, $ally_add) { |
|
195 | 187 | $sql_date = SN_TIME_NOW - $chat_refresh_rate * 2; |
196 | 188 | |
197 | 189 | return doquery( |
@@ -205,13 +197,11 @@ discard block |
||
205 | 197 | ORDER BY authlevel DESC, `username`"); |
206 | 198 | } |
207 | 199 | |
208 | -function db_referrals_list_by_id($user_id) |
|
209 | -{ |
|
200 | +function db_referrals_list_by_id($user_id) { |
|
210 | 201 | return doquery("SELECT r.*, u.username, u.register_time FROM {{referrals}} AS r LEFT JOIN {{users}} AS u ON u.id = r.id WHERE id_partner = {$user_id}"); |
211 | 202 | } |
212 | 203 | |
213 | -function db_message_list_admin_by_type($int_type_selected, $StartRec) |
|
214 | -{ |
|
204 | +function db_message_list_admin_by_type($int_type_selected, $StartRec) { |
|
215 | 205 | return doquery("SELECT |
216 | 206 | message_id as `ID`, |
217 | 207 | message_from as `FROM`, |
@@ -230,8 +220,7 @@ discard block |
||
230 | 220 | } |
231 | 221 | |
232 | 222 | |
233 | -function db_message_insert_all($message_type, $from, $subject, $text) |
|
234 | -{ |
|
223 | +function db_message_insert_all($message_type, $from, $subject, $text) { |
|
235 | 224 | return doquery($QryInsertMessage = 'INSERT INTO {{messages}} (`message_owner`, `message_sender`, `message_time`, `message_type`, `message_from`, `message_subject`, `message_text`) ' . |
236 | 225 | "SELECT `id`, 0, unix_timestamp(now()), {$message_type}, '{$from}', '{$subject}', '{$text}' FROM {{users}}"); |
237 | 226 | } |