Completed
Push — work-fleets ( da4c88...99e92e )
by SuperNova.WS
05:42
created
includes/includes/flt_flying_fleet_handler2.php 2 patches
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -10,7 +10,7 @@
 block discarded – undo
10 10
  *
11 11
  * @param Fleet $objFleet
12 12
  * @param bool  $start
13
- * @param null  $result
13
+ * @param integer  $result
14 14
  *
15 15
  * @return mixed
16 16
  */
Please login to merge, or discard this patch.
Spacing   +7 added lines, -11 removed lines patch added patch discarded remove patch
@@ -19,15 +19,11 @@  discard block
 block discarded – undo
19 19
 // ------------------------------------------------------------------
20 20
 function flt_flyingFleetsSort($a, $b) {
21 21
   // Сравниваем время флотов - кто раньше, тот и первый обрабатывается
22
-  return $a['fleet_time'] > $b['fleet_time'] ? 1 : ($a['fleet_time'] < $b['fleet_time'] ? -1 :
23
-    // Если время - одинаковое, сравниваем события флотов
22
+  return $a['fleet_time'] > $b['fleet_time'] ? 1 : ($a['fleet_time'] < $b['fleet_time'] ? -1 : // Если время - одинаковое, сравниваем события флотов
24 23
     // Если события - одинаковые, то флоты равны
25
-    ($a['fleet_event'] == $b['fleet_event'] ? 0 :
26
-      // Если события разные - первыми считаем прибывающие флоты
27
-      ($a['fleet_event'] == EVENT_FLT_ARRIVE ? 1 : ($b['fleet_event'] == EVENT_FLT_ARRIVE ? -1 :
28
-        // Если нет прибывающих флотов - дальше считаем флоты, которые закончили миссию
29
-        ($a['fleet_event'] == EVENT_FLT_ACOMPLISH ? 1 : ($b['fleet_event'] == EVENT_FLT_ACOMPLISH ? -1 :
30
-          // Если нет флотов, закончивших задание - остались возвращающиеся флоты, которые равны между собой
24
+    ($a['fleet_event'] == $b['fleet_event'] ? 0 : // Если события разные - первыми считаем прибывающие флоты
25
+      ($a['fleet_event'] == EVENT_FLT_ARRIVE ? 1 : ($b['fleet_event'] == EVENT_FLT_ARRIVE ? -1 : // Если нет прибывающих флотов - дальше считаем флоты, которые закончили миссию
26
+        ($a['fleet_event'] == EVENT_FLT_ACOMPLISH ? 1 : ($b['fleet_event'] == EVENT_FLT_ACOMPLISH ? -1 : // Если нет флотов, закончивших задание - остались возвращающиеся флоты, которые равны между собой
31 27
           // TODO: Добавить еще проверку по ID флота и/или времени запуска - что бы обсчитывать их в порядке запуска
32 28
           (
33 29
           0 // Вообще сюда доходить не должно - будет отсекаться на равенстве событий
@@ -45,13 +41,13 @@  discard block
 block discarded – undo
45 41
     $handler = fopen('event.log', 'a+');
46 42
   }
47 43
 
48
-  fwrite($handler, date(FMT_DATE_TIME_SQL, time()) . ' ' . $msg . "\r\n");
44
+  fwrite($handler, date(FMT_DATE_TIME_SQL, time()).' '.$msg."\r\n");
49 45
 }
50 46
 
51 47
 // ------------------------------------------------------------------
52 48
 function flt_flying_fleet_handler($skip_fleet_update = false) {
53 49
   if (true) {
54
-    if(!defined('IN_AJAX')) {
50
+    if (!defined('IN_AJAX')) {
55 51
       print('<div style="color: red; font-size: 300%">Fleet handler is disabled</div>');
56 52
       pdump('Fleet handler is disabled');
57 53
     }
@@ -177,7 +173,7 @@  discard block
 block discarded – undo
177 173
     MT_EXPLORE   => 'flt_mission_explore',
178 174
   );
179 175
   foreach ($missions_used as $mission_id => $cork) {
180
-    require_once(SN_ROOT_PHYSICAL . "includes/includes/{$mission_files[$mission_id]}" . DOT_PHP_EX);
176
+    require_once(SN_ROOT_PHYSICAL."includes/includes/{$mission_files[$mission_id]}".DOT_PHP_EX);
181 177
   }
182 178
 
183 179
 //log_file('Обработка миссий');
Please login to merge, or discard this patch.
includes/classes/core_auth.php 2 patches
Doc Comments   +7 added lines, -1 removed lines patch added patch discarded remove patch
@@ -286,7 +286,6 @@  discard block
 block discarded – undo
286 286
   /**
287 287
    * Функция пытается залогиниться по всем известным провайдерам
288 288
    *
289
-   * @param null $result
290 289
    */
291 290
   public function login() {
292 291
     if(empty(sn_module::$sn_module_list['auth'])) {
@@ -823,10 +822,17 @@  discard block
 block discarded – undo
823 822
 
824 823
   // OK v4.5
825 824
   // TODO - REMEMBER_ME
825
+
826
+  /**
827
+   * @param integer $period
828
+   */
826 829
   protected static function cookie_set($value, $impersonate = false, $period = null) {
827 830
     sn_setcookie($impersonate ? SN_COOKIE_U_I : SN_COOKIE_U, $value, $period === null ? SN_TIME_NOW + PERIOD_YEAR : $period, SN_ROOT_RELATIVE);
828 831
   }
829 832
 
833
+  /**
834
+   * @param string $message
835
+   */
830 836
   protected static function flog($message, $die = false) {
831 837
     if(!defined('DEBUG_AUTH') || !DEBUG_AUTH) {
832 838
       return;
Please login to merge, or discard this patch.
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -224,7 +224,7 @@  discard block
 block discarded – undo
224 224
       // Проверить наличие такого имени в истории имён
225 225
       do {
226 226
         sn_db_transaction_rollback();
227
-        $this->player_suggested_name = 'Emperor ' . mt_rand($max_user_id + 1, $max_user_id + 1000);
227
+        $this->player_suggested_name = 'Emperor '.mt_rand($max_user_id + 1, $max_user_id + 1000);
228 228
         sn_db_transaction_start();
229 229
       } while (db_player_name_exists($this->player_suggested_name));
230 230
 
@@ -233,7 +233,7 @@  discard block
 block discarded – undo
233 233
     if ($player_name_submitted) {
234 234
       $this->register_player_db_create($this->player_suggested_name); // OK 4.5
235 235
       if ($this->register_status == LOGIN_SUCCESS) {
236
-        sys_redirect(SN_ROOT_VIRTUAL . 'overview.php');
236
+        sys_redirect(SN_ROOT_VIRTUAL.'overview.php');
237 237
       } elseif ($this->register_status == REGISTER_ERROR_PLAYER_NAME_EXISTS && $original_suggest == $this->player_suggested_name) {
238 238
         // self::$player_suggested_name .= ' ' . $this->account->account_id;
239 239
       }
@@ -259,8 +259,8 @@  discard block
 block discarded – undo
259 259
       );
260 260
 
261 261
     if ($this->register_status == LOGIN_ERROR_USERNAME_RESTRICTED_CHARACTERS) {
262
-      $prohibited_characters = array_map(function ($value) {
263
-        return "'" . htmlentities($value, ENT_QUOTES, 'UTF-8') . "'";
262
+      $prohibited_characters = array_map(function($value) {
263
+        return "'".htmlentities($value, ENT_QUOTES, 'UTF-8')."'";
264 264
       }, str_split(LOGIN_REGISTER_CHARACTERS_PROHIBITED));
265 265
       $template_result[F_PLAYER_REGISTER_MESSAGE] .= implode(', ', $prohibited_characters);
266 266
     }
@@ -307,7 +307,7 @@  discard block
 block discarded – undo
307 307
 
308 308
     foreach ($this->providers as $provider_id => $provider) {
309 309
       $login_status = $provider->login(); // OK v4.5
310
-      self::flog(($provider->manifest['name'] . '->' . 'login_try - ') . (empty($provider->account->account_id) ? classLocale::$lang['sys_login_messages'][$provider->account_login_status] : dump($provider)));
310
+      self::flog(($provider->manifest['name'].'->'.'login_try - ').(empty($provider->account->account_id) ? classLocale::$lang['sys_login_messages'][$provider->account_login_status] : dump($provider)));
311 311
       if ($login_status == LOGIN_SUCCESS && is_object($provider->account) && $provider->account instanceof Account && $provider->account->account_id) {
312 312
         $this->providers_authorised[$provider_id] = &$this->providers[$provider_id];
313 313
 
@@ -347,7 +347,7 @@  discard block
 block discarded – undo
347 347
         if (!$this->is_player_register) {
348 348
           // Нет - отправляем на процесс регистрации
349 349
           $partner_id = sys_get_param_int('id_ref', sys_get_param_int('partner_id'));
350
-          sys_redirect(SN_ROOT_VIRTUAL . 'index.php?page=player_register&player_register=1' . ($partner_id ? '&id_ref=' . $partner_id : ''));
350
+          sys_redirect(SN_ROOT_VIRTUAL.'index.php?page=player_register&player_register=1'.($partner_id ? '&id_ref='.$partner_id : ''));
351 351
         }
352 352
       } else {
353 353
         // Да, есть доступные игроки, которые так же прописаны в базе
@@ -407,7 +407,7 @@  discard block
 block discarded – undo
407 407
     }
408 408
 
409 409
     if ($redirect === true) {
410
-      sys_redirect(SN_ROOT_RELATIVE . (empty($_COOKIE[SN_COOKIE_U]) ? 'login.php' : 'admin/overview.php'));
410
+      sys_redirect(SN_ROOT_RELATIVE.(empty($_COOKIE[SN_COOKIE_U]) ? 'login.php' : 'admin/overview.php'));
411 411
     } elseif ($redirect !== false) {
412 412
       sys_redirect($redirect);
413 413
     }
@@ -702,7 +702,7 @@  discard block
 block discarded – undo
702 702
         $user['vacation'] = SN_TIME_NOW;
703 703
       }
704 704
 
705
-      $user['user_lastip'] = self::$device->ip_v4_string;// $ip['ip'];
705
+      $user['user_lastip'] = self::$device->ip_v4_string; // $ip['ip'];
706 706
       $user['user_proxy'] = self::$device->ip_v4_proxy_chain; //$ip['proxy_chain'];
707 707
 
708 708
       $result[F_BANNED_STATUS] = $user['banaday'];
@@ -710,9 +710,9 @@  discard block
 block discarded – undo
710 710
 
711 711
       $proxy_safe = static::$db->db_escape(self::$device->ip_v4_proxy_chain);
712 712
 
713
-      DBStaticUser::db_user_set_by_id($user['id'], "`onlinetime` = " . SN_TIME_NOW . ",
714
-      `banaday` = " . static::$db->db_escape($user['banaday']) . ", `vacation` = " . static::$db->db_escape($user['vacation']) . ",
715
-      `user_lastip` = '" . static::$db->db_escape($user['user_lastip']) . "', `user_last_proxy` = '{$proxy_safe}', `user_last_browser_id` = " . self::$device->browser_id
713
+      DBStaticUser::db_user_set_by_id($user['id'], "`onlinetime` = ".SN_TIME_NOW.",
714
+      `banaday` = " . static::$db->db_escape($user['banaday']).", `vacation` = ".static::$db->db_escape($user['vacation']).",
715
+      `user_lastip` = '" . static::$db->db_escape($user['user_lastip'])."', `user_last_proxy` = '{$proxy_safe}', `user_last_browser_id` = ".self::$device->browser_id
716 716
       );
717 717
     }
718 718
 
@@ -805,7 +805,7 @@  discard block
 block discarded – undo
805 805
    */
806 806
   // OK v4
807 807
   public static function password_encode($password, $salt) {
808
-    return md5($password . $salt);
808
+    return md5($password.$salt);
809 809
   }
810 810
   /**
811 811
    * Генерирует соль
@@ -831,10 +831,10 @@  discard block
 block discarded – undo
831 831
     }
832 832
     list($called, $caller) = debug_backtrace(false);
833 833
     $caller_name =
834
-      (!empty($caller['class']) ? $caller['class'] : '') .
835
-      (!empty($caller['type']) ? $caller['type'] : '') .
836
-      (!empty($caller['function']) ? $caller['function'] : '') .
837
-      (!empty($called['line']) ? ':' . $called['line'] : '');
834
+      (!empty($caller['class']) ? $caller['class'] : '').
835
+      (!empty($caller['type']) ? $caller['type'] : '').
836
+      (!empty($caller['function']) ? $caller['function'] : '').
837
+      (!empty($called['line']) ? ':'.$called['line'] : '');
838 838
 
839 839
     $_SERVER['SERVER_NAME'] == 'localhost' ? print("<div class='debug'>$message - $caller_name\r\n</div>") : false;
840 840
 
@@ -842,7 +842,7 @@  discard block
 block discarded – undo
842 842
     if ($die) {
843 843
       // pdump($caller);
844 844
       // pdump(debug_backtrace(false));
845
-      $die && die("<div class='negative'>СТОП! Функция {$caller_name} при вызове в " . get_called_class() . " (располагается в " . get_class() . "). СООБЩИТЕ АДМИНИСТРАЦИИ!</div>");
845
+      $die && die("<div class='negative'>СТОП! Функция {$caller_name} при вызове в ".get_called_class()." (располагается в ".get_class()."). СООБЩИТЕ АДМИНИСТРАЦИИ!</div>");
846 846
     }
847 847
   }
848 848
 
Please login to merge, or discard this patch.
admin/includes/admin_planet_edit.inc.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -21,12 +21,12 @@  discard block
 block discarded – undo
21 21
 
22 22
 function sn_admin_planet_edit_template(&$template, $edit_planet_row, $mode) {
23 23
   $unit_list = sn_get_groups($mode);
24
-  if(empty($unit_list)) {
24
+  if (empty($unit_list)) {
25 25
     return;
26 26
   }
27 27
   $name_list = classLocale::$lang['tech'];
28 28
 
29
-  foreach($unit_list as $unit_id) {
29
+  foreach ($unit_list as $unit_id) {
30 30
     $template->assign_block_vars('unit', array(
31 31
       'ID'    => $unit_id,
32 32
       'NAME'  => $name_list[$unit_id],
@@ -39,7 +39,7 @@  discard block
 block discarded – undo
39 39
 function admin_planet_edit_query_string($unit_id, $unit_amount, $mode) { return sn_function_call(__FUNCTION__, array($unit_id, $unit_amount, $mode)); }
40 40
 
41 41
 function sn_admin_planet_edit_query_string($unit_id, $unit_amount, $mode) {
42
-  if($unit_amount && in_array($unit_id, sn_get_groups($mode))) {
42
+  if ($unit_amount && in_array($unit_id, sn_get_groups($mode))) {
43 43
     $unit_amount = round($unit_amount);
44 44
     $unit_name = get_unit_param($unit_id, P_NAME);
45 45
     $result = "{$unit_name} = GREATEST(0, {$unit_name} + ({$unit_amount}))";
Please login to merge, or discard this patch.
includes/functions/uni_functions.php 2 patches
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -253,9 +253,11 @@
 block discarded – undo
253 253
   }
254 254
 
255 255
   // Если новая планета не найдена или было переключения - проверяем текущую выбранную планету
256
-  if(!isset($planet_row['id'])) // || $planet_row['id'] != $user['current_planet']
256
+  if(!isset($planet_row['id'])) {
257
+    // || $planet_row['id'] != $user['current_planet']
257 258
   {
258 259
     $planet_row = db_planet_by_id_and_owner($user['current_planet'], $user['id'], false, 'id');
260
+  }
259 261
     // Если текущей планеты не существует - выставляем Столицу
260 262
     if(!isset($planet_row['id'])) {
261 263
       $planet_row = db_planet_by_id_and_owner($user['id_planet'], $user['id'], false, 'id');
Please login to merge, or discard this patch.
Spacing   +39 added lines, -39 removed lines patch added patch discarded remove patch
@@ -7,12 +7,12 @@  discard block
 block discarded – undo
7 7
 
8 8
   $possible_cores = array();
9 9
   $probability = 0;
10
-  foreach($density_list as $possible_core_id => $core_data) {
11
-    if(!$core_data[UNIT_PLANET_DENSITY_RARITY]) {
10
+  foreach ($density_list as $possible_core_id => $core_data) {
11
+    if (!$core_data[UNIT_PLANET_DENSITY_RARITY]) {
12 12
       continue;
13 13
     }
14 14
 
15
-    if(
15
+    if (
16 16
       // Core type exists
17 17
       in_array($possible_core_id, $position_data['core_types'])
18 18
       // Limit core type with planet sector count
@@ -33,8 +33,8 @@  discard block
 block discarded – undo
33 33
 
34 34
   $random = mt_rand(1, $probability);
35 35
   $selected_core = null;
36
-  foreach($possible_cores as $core_type => $core_info) {
37
-    if($random <= $core_info[UNIT_PLANET_DENSITY_RARITY]) {
36
+  foreach ($possible_cores as $core_type => $core_info) {
37
+    if ($random <= $core_info[UNIT_PLANET_DENSITY_RARITY]) {
38 38
       $selected_core = $core_info;
39 39
       break;
40 40
     }
@@ -57,7 +57,7 @@  discard block
 block discarded – undo
57 57
 function uni_create_planet($Galaxy, $System, $Position, $PlanetOwnerID, $planet_name_unsafe = '', $HomeWorld = false, $options = array()) {
58 58
   $Position = intval($Position);
59 59
 
60
-  if(!isset($options['skip_check']) && DBStaticPlanet::db_planet_by_gspt($Galaxy, $System, $Position, PT_PLANET, true, '`id`')) {
60
+  if (!isset($options['skip_check']) && DBStaticPlanet::db_planet_by_gspt($Galaxy, $System, $Position, PT_PLANET, true, '`id`')) {
61 61
     return false;
62 62
   }
63 63
 
@@ -66,11 +66,11 @@  discard block
 block discarded – undo
66 66
 
67 67
   $planet_generator = sn_get_groups('planet_generator');
68 68
 
69
-  if($HomeWorld) {
69
+  if ($HomeWorld) {
70 70
     $position_data = $planet_generator[0];
71 71
   } else {
72 72
     $position_data = $planet_generator[$Position >= UNIVERSE_RANDOM_PLANET_START || $Position < 1 ? UNIVERSE_RANDOM_PLANET_START : $Position];
73
-    if($Position >= UNIVERSE_RANDOM_PLANET_START) {
73
+    if ($Position >= UNIVERSE_RANDOM_PLANET_START) {
74 74
       // Корректируем температуру для планеты-странника
75 75
       $position_data['t_max_max'] -= UNIVERSE_RANDOM_PLANET_TEMPERATURE_DECREASE * ($Position - UNIVERSE_RANDOM_PLANET_START);
76 76
     }
@@ -78,7 +78,7 @@  discard block
 block discarded – undo
78 78
 
79 79
   $planet_images = sn_get_groups('planet_images');
80 80
   $planet_image = $position_data['planet_images'][mt_rand(0, count($position_data['planet_images']) - 1)];
81
-  $planet_image .= 'planet' . $planet_images[$planet_image][mt_rand(0, count($planet_images[$planet_image]) - 1)];
81
+  $planet_image .= 'planet'.$planet_images[$planet_image][mt_rand(0, count($planet_images[$planet_image]) - 1)];
82 82
 
83 83
   $t_max = sn_rand_gauss_range($position_data['t_max_min'], $position_data['t_max_max'], true, 1.3, true);
84 84
   $t_min = $t_max - sn_rand_gauss_range($position_data['t_delta_min'], $position_data['t_delta_max'], true, 1.3, true);
@@ -89,7 +89,7 @@  discard block
 block discarded – undo
89 89
 
90 90
   $core_info = uni_create_planet_get_density($position_data, $user_row, $planet_sectors);
91 91
 
92
-  $planet_name_unsafe = $user_row['username'] . ' ' . ($planet_name_unsafe ? $planet_name_unsafe : classLocale::$lang['sys_colo_defaultname']);
92
+  $planet_name_unsafe = $user_row['username'].' '.($planet_name_unsafe ? $planet_name_unsafe : classLocale::$lang['sys_colo_defaultname']);
93 93
 
94 94
   $planet['name'] = db_escape(strip_tags(trim($planet_name_unsafe)));
95 95
   $planet['id_owner'] = $PlanetOwnerID;
@@ -170,15 +170,15 @@  discard block
 block discarded – undo
170 170
   $moon_name = '';
171 171
   $moon_row = array();
172 172
   $moon = DBStaticPlanet::db_planet_by_gspt($pos_galaxy, $pos_system, $pos_planet, PT_MOON, false, 'id');
173
-  if(!$moon['id']) {
173
+  if (!$moon['id']) {
174 174
     $moon_planet = DBStaticPlanet::db_planet_by_gspt($pos_galaxy, $pos_system, $pos_planet, PT_PLANET, true, '`id`, `temp_min`, `temp_max`, `name`, `debris_metal`, `debris_crystal`');
175 175
 
176
-    if($moon_planet['id']) {
176
+    if ($moon_planet['id']) {
177 177
       $base_storage_size = BASE_STORAGE_SIZE;
178 178
 
179
-      if(!$moon_chance) {
179
+      if (!$moon_chance) {
180 180
         $size = mt_rand(1100, 8999);
181
-      } elseif($moon_chance <= 100) {
181
+      } elseif ($moon_chance <= 100) {
182 182
         $size = mt_rand($moon_chance * 100 + 1000, $moon_chance * 200 + 2999);
183 183
       } else {
184 184
         $size = $moon_chance;
@@ -194,22 +194,22 @@  discard block
 block discarded – undo
194 194
 
195 195
       $field_max = ceil($size / 1000);
196 196
 
197
-      if(isset($options['image']) && $options['image']) {
197
+      if (isset($options['image']) && $options['image']) {
198 198
         $moon_image = $options['image'];
199 199
       } else {
200 200
         $moon_image = 'mond';
201 201
       }
202 202
 
203 203
       $moon_row = classSupernova::db_ins_record(LOC_PLANET,
204
-        "`id_owner` = '{$user_id}', `parent_planet` = '{$moon_planet['id']}', `name` = '{$moon_name_safe}', `last_update` = " . SN_TIME_NOW . ", `image` = '{$moon_image}',
205
-          `galaxy` = '{$pos_galaxy}', `system` = '{$pos_system}', `planet` = '{$pos_planet}', `planet_type` = " . PT_MOON . ",
204
+        "`id_owner` = '{$user_id}', `parent_planet` = '{$moon_planet['id']}', `name` = '{$moon_name_safe}', `last_update` = ".SN_TIME_NOW.", `image` = '{$moon_image}',
205
+          `galaxy` = '{$pos_galaxy}', `system` = '{$pos_system}', `planet` = '{$pos_planet}', `planet_type` = ".PT_MOON.",
206 206
           `diameter` = '{$size}', `field_max` = '{$field_max}', `density` = 2500, `density_index` = 2, `temp_min` = '{$temp_min}', `temp_max` = '{$temp_max}',
207 207
           `metal` = '0', `metal_perhour` = '0', `metal_max` = '{$base_storage_size}',
208 208
           `crystal` = '0', `crystal_perhour` = '0', `crystal_max` = '{$base_storage_size}',
209 209
           `deuterium` = '0', `deuterium_perhour` = '0', `deuterium_max` = '{$base_storage_size}'"
210 210
       );
211 211
 
212
-      if($update_debris) {
212
+      if ($update_debris) {
213 213
         $debris_spent = $moon_chance * 1000000;
214 214
         $metal_spent = round(min($moon_planet['debris_metal'], $debris_spent * mt_rand(50, 75) / 100));
215 215
         $crystal_spent = min($moon_planet['debris_crystal'], $debris_spent - $metal_spent);
@@ -244,28 +244,28 @@  discard block
 block discarded – undo
244 244
   $planet_row['id'] = $user['current_planet'];
245 245
 
246 246
   // Пытаемся переключить на новую планету
247
-  if(($selected_planet = sys_get_param_id('cp')) && $selected_planet != $user['current_planet']) {
247
+  if (($selected_planet = sys_get_param_id('cp')) && $selected_planet != $user['current_planet']) {
248 248
     $planet_row = DBStaticPlanet::db_planet_by_id_and_owner($selected_planet, $user['id'], false, 'id');
249 249
   } else {
250 250
     $planet_row = DBStaticPlanet::db_planet_by_id($planet_row['id']);
251 251
   }
252 252
 
253 253
   // Если новая планета не найдена или было переключения - проверяем текущую выбранную планету
254
-  if(!isset($planet_row['id'])) // || $planet_row['id'] != $user['current_planet']
254
+  if (!isset($planet_row['id'])) // || $planet_row['id'] != $user['current_planet']
255 255
   {
256 256
     $planet_row = DBStaticPlanet::db_planet_by_id_and_owner($user['current_planet'], $user['id'], false, 'id');
257 257
     // Если текущей планеты не существует - выставляем Столицу
258
-    if(!isset($planet_row['id'])) {
258
+    if (!isset($planet_row['id'])) {
259 259
       $planet_row = DBStaticPlanet::db_planet_by_id_and_owner($user['id_planet'], $user['id'], false, 'id');
260 260
       // Если и столицы не существует - значит что-то очень не так с записью пользователя
261
-      if(!isset($planet_row['id'])) {
261
+      if (!isset($planet_row['id'])) {
262 262
         classSupernova::$debug->error("User ID {$user['id']} has Capital planet {$user['id_planet']} but this planet does not exists", 'User record error', 502);
263 263
       }
264 264
     }
265 265
   }
266 266
 
267 267
   // Если производилось переключение планеты - делаем запись в юзере
268
-  if($user['current_planet'] != $planet_row['id']) {
268
+  if ($user['current_planet'] != $planet_row['id']) {
269 269
     DBStaticUser::db_user_set_by_id($user['id'], "`current_planet` = '{$planet_row['id']}'");
270 270
     $user['current_planet'] = $planet_row['id'];
271 271
   }
@@ -282,7 +282,7 @@  discard block
 block discarded – undo
282 282
 
283 283
 // ----------------------------------------------------------------------------------------------------------------
284 284
 function uni_render_coordinates($from, $prefix = '') {
285
-  return "[{$from[$prefix . 'galaxy']}:{$from[$prefix . 'system']}:{$from[$prefix . 'planet']}]";
285
+  return "[{$from[$prefix.'galaxy']}:{$from[$prefix.'system']}:{$from[$prefix.'planet']}]";
286 286
 }
287 287
 
288 288
 function uni_render_planet($from) {
@@ -290,17 +290,17 @@  discard block
 block discarded – undo
290 290
 }
291 291
 
292 292
 function uni_render_planet_full($from, $prefix = '', $html_safe = true, $include_id = false) {
293
-  if(!$from['id']) {
293
+  if (!$from['id']) {
294 294
     $result = classLocale::$lang['sys_planet_expedition'];
295 295
   } else {
296 296
     $from_planet_id = $include_id ? (
297
-      'ID {' . ($from['id'] ? $from['id'] : ($from[$prefix . 'planet_id'] ? $from[$prefix . 'planet_id'] : 0)) . '} '
297
+      'ID {'.($from['id'] ? $from['id'] : ($from[$prefix.'planet_id'] ? $from[$prefix.'planet_id'] : 0)).'} '
298 298
     ) : '';
299 299
 
300
-    $from_planet_type = $from['planet_type'] ? $from['planet_type'] : ($from[$prefix . 'type'] ? $from[$prefix . 'type'] : 0);
301
-    $from_planet_type = ($from_planet_type ? ' ' . classLocale::$lang['sys_planet_type_sh'][$from_planet_type] : '');
300
+    $from_planet_type = $from['planet_type'] ? $from['planet_type'] : ($from[$prefix.'type'] ? $from[$prefix.'type'] : 0);
301
+    $from_planet_type = ($from_planet_type ? ' '.classLocale::$lang['sys_planet_type_sh'][$from_planet_type] : '');
302 302
 
303
-    $result = $from_planet_id . uni_render_coordinates($from, $prefix) . $from_planet_type . ($from['name'] ? ' ' . $from['name'] : '');
303
+    $result = $from_planet_id.uni_render_coordinates($from, $prefix).$from_planet_type.($from['name'] ? ' '.$from['name'] : '');
304 304
     $result = $html_safe ? str_replace(' ', '&nbsp;', htmlentities($result, ENT_COMPAT, 'UTF-8')) : $result;
305 305
   }
306 306
 
@@ -308,11 +308,11 @@  discard block
 block discarded – undo
308 308
 }
309 309
 
310 310
 function uni_render_coordinates_url($from, $prefix = '', $page = 'galaxy.php') {
311
-  return $page . (strpos($page, '?') === false ? '?' : '&') . "galaxy={$from[$prefix . 'galaxy']}&system={$from[$prefix . 'system']}&planet={$from[$prefix . 'planet']}";
311
+  return $page.(strpos($page, '?') === false ? '?' : '&')."galaxy={$from[$prefix.'galaxy']}&system={$from[$prefix.'system']}&planet={$from[$prefix.'planet']}";
312 312
 }
313 313
 
314 314
 function uni_render_coordinates_href($from, $prefix = '', $mode = 0, $fleet_type = '') {
315
-  return '<a href="' . uni_render_coordinates_url($from, $prefix, "galaxy.php?mode={$mode}") . '"' . ($fleet_type ? " {$fleet_type}" : '') . '>' . uni_render_coordinates($from, $prefix) . '</a>';
315
+  return '<a href="'.uni_render_coordinates_url($from, $prefix, "galaxy.php?mode={$mode}").'"'.($fleet_type ? " {$fleet_type}" : '').'>'.uni_render_coordinates($from, $prefix).'</a>';
316 316
 }
317 317
 
318 318
 function uni_get_time_to_jump($moon_row) {
@@ -340,30 +340,30 @@  discard block
 block discarded – undo
340 340
   $coordinates["{$prefix}planet"] = intval($coordinates["{$prefix}planet"]);
341 341
 
342 342
   return
343
-    isset($coordinates["{$prefix}galaxy"]) && $coordinates["{$prefix}galaxy"] > 0 && $coordinates["{$prefix}galaxy"] <= Vector::$knownGalaxies&&
344
-    isset($coordinates["{$prefix}system"]) && $coordinates["{$prefix}system"] > 0 && $coordinates["{$prefix}system"] <= Vector::$knownSystems&&
343
+    isset($coordinates["{$prefix}galaxy"]) && $coordinates["{$prefix}galaxy"] > 0 && $coordinates["{$prefix}galaxy"] <= Vector::$knownGalaxies &&
344
+    isset($coordinates["{$prefix}system"]) && $coordinates["{$prefix}system"] > 0 && $coordinates["{$prefix}system"] <= Vector::$knownSystems &&
345 345
     isset($coordinates["{$prefix}planet"]) && $coordinates["{$prefix}planet"] > 0 && $coordinates["{$prefix}planet"] <= Vector::$knownPlanets;
346 346
 }
347 347
 
348 348
 function uni_planet_teleport_check($user, $planetrow, $new_coordinates = null) {
349 349
   try {
350
-    if($planetrow['planet_teleport_next'] && $planetrow['planet_teleport_next'] > SN_TIME_NOW) {
350
+    if ($planetrow['planet_teleport_next'] && $planetrow['planet_teleport_next'] > SN_TIME_NOW) {
351 351
       throw new exception(classLocale::$lang['ov_teleport_err_cooldown'], ERR_ERROR);
352 352
     }
353 353
 
354
-    if(mrc_get_level($user, null, RES_DARK_MATTER) < classSupernova::$config->planet_teleport_cost) {
354
+    if (mrc_get_level($user, null, RES_DARK_MATTER) < classSupernova::$config->planet_teleport_cost) {
355 355
       throw new exception(classLocale::$lang['ov_teleport_err_no_dark_matter'], ERR_ERROR);
356 356
     }
357 357
 
358 358
     // TODO: Replace quick-check with using gathered flying fleet data
359
-    if(FleetList::fleet_count_incoming($planetrow['galaxy'], $planetrow['system'], $planetrow['planet'])) {
359
+    if (FleetList::fleet_count_incoming($planetrow['galaxy'], $planetrow['system'], $planetrow['planet'])) {
360 360
       throw new exception(classLocale::$lang['ov_teleport_err_fleet'], ERR_ERROR);
361 361
     }
362 362
 
363
-    if(is_array($new_coordinates)) {
363
+    if (is_array($new_coordinates)) {
364 364
       $new_coordinates['planet_type'] = PT_PLANET;
365 365
       $incoming = DBStaticPlanet::db_planet_by_vector($new_coordinates, '', true, 'id');
366
-      if($incoming['id']) {
366
+      if ($incoming['id']) {
367 367
         throw new exception(classLocale::$lang['ov_teleport_err_destination_busy'], ERR_ERROR);
368 368
       }
369 369
     }
@@ -372,7 +372,7 @@  discard block
 block discarded – undo
372 372
       'result'  => ERR_NONE,
373 373
       'message' => '',
374 374
     );
375
-  } catch(exception $e) {
375
+  } catch (exception $e) {
376 376
     $response = array(
377 377
       'result'  => $e->getCode(),
378 378
       'message' => $e->getMessage(),
Please login to merge, or discard this patch.
includes/pages/contact.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -16,7 +16,7 @@
 block discarded – undo
16 16
   $query = db_user_list("`authlevel` > 0 ORDER BY `authlevel` ASC");
17 17
 
18 18
   // while($row = db_fetch($query))
19
-  foreach($query as $row) {
19
+  foreach ($query as $row) {
20 20
     $template_result['.']['contact'][] = array(
21 21
       'NAME'  => $row['username'],
22 22
       'LEVEL' => classLocale::$lang['user_level'][$row['authlevel']],
Please login to merge, or discard this patch.
includes/classes/Account.php 2 patches
Doc Comments   +21 added lines patch added patch discarded remove patch
@@ -171,6 +171,10 @@  discard block
 block discarded – undo
171 171
    * @return bool
172 172
    */
173 173
   // OK v4.5
174
+
175
+  /**
176
+   * @param string $account_name_unsafe
177
+   */
174 178
   public function db_get_by_name($account_name_unsafe) {
175 179
     $this->reset();
176 180
 
@@ -207,6 +211,11 @@  discard block
 block discarded – undo
207 211
    *
208 212
    */
209 213
   // OK v4.5
214
+
215
+  /**
216
+   * @param string $account_name_unsafe
217
+   * @param string $email_unsafe
218
+   */
210 219
   public function db_get_by_name_or_email($account_name_unsafe, $email_unsafe) {
211 220
     $this->reset();
212 221
 
@@ -223,6 +232,13 @@  discard block
 block discarded – undo
223 232
    * @throws Exception
224 233
    */
225 234
   // OK v4.5
235
+
236
+  /**
237
+   * @param string $account_name_unsafe
238
+   * @param string $password_raw
239
+   * @param string $email_unsafe
240
+   * @param string $language_unsafe
241
+   */
226 242
   public function db_create($account_name_unsafe, $password_raw, $email_unsafe, $language_unsafe = null, $salt_unsafe = null) {
227 243
     $this->reset();
228 244
 
@@ -317,6 +333,11 @@  discard block
 block discarded – undo
317 333
    * @return int|string
318 334
    */
319 335
   // OK 4.8
336
+
337
+  /**
338
+   * @param integer $change_type
339
+   * @param double $metamatter
340
+   */
320 341
   protected function db_mm_log_insert($comment, $change_type, $metamatter, $user_id_unsafe) {
321 342
     $provider_id_safe = intval(core_auth::$main_provider->provider_id);
322 343
     //$account_id_safe = $this->db->db_escape($this->account_id);
Please login to merge, or discard this patch.
Spacing   +19 added lines, -19 removed lines patch added patch discarded remove patch
@@ -79,8 +79,8 @@  discard block
 block discarded – undo
79 79
     $this->reset();
80 80
     $this->db = is_object($db) ? $db : classSupernova::$db;
81 81
 
82
-    foreach($this->table_check as $table_name) {
83
-      if(empty($this->db->table_list[$table_name])) {
82
+    foreach ($this->table_check as $table_name) {
83
+      if (empty($this->db->table_list[$table_name])) {
84 84
         die('Если вы видите это сообщение первый раз после обновления релиза - просто перегрузите страницу.<br />
85 85
               В противном случае - сообщите Администрации сервера об ошибке.<br/>
86 86
               Не хватает таблицы для работы системы авторизации: ' . $table_name);
@@ -104,7 +104,7 @@  discard block
 block discarded – undo
104 104
    */
105 105
   // OK v4.6
106 106
   public function password_change($old_password_unsafe, $new_password_unsafe, $salt_unsafe = null) {
107
-    if(!$this->password_check($old_password_unsafe)) {
107
+    if (!$this->password_check($old_password_unsafe)) {
108 108
       return false;
109 109
     }
110 110
 
@@ -125,7 +125,7 @@  discard block
 block discarded – undo
125 125
   // OK v4.5
126 126
   public function assign_from_db_row($row) {
127 127
     $this->reset();
128
-    if(empty($row) || !is_array($row)) {
128
+    if (empty($row) || !is_array($row)) {
129 129
       return false;
130 130
     }
131 131
     $this->account_id = $row['account_id'];
@@ -242,11 +242,11 @@  discard block
 block discarded – undo
242 242
         `account_email` = LOWER('{$email_safe}'),
243 243
         `account_language` = '{$language_safe}'"
244 244
     );
245
-    if(!$result) {
245
+    if (!$result) {
246 246
       throw new Exception(REGISTER_ERROR_ACCOUNT_CREATE, ERR_ERROR);
247 247
     }
248 248
 
249
-    if(!($account_id = $this->db->db_insert_id())) {
249
+    if (!($account_id = $this->db->db_insert_id())) {
250 250
       throw new Exception(REGISTER_ERROR_ACCOUNT_CREATE, ERR_ERROR);
251 251
     }
252 252
 
@@ -276,7 +276,7 @@  discard block
 block discarded – undo
276 276
       WHERE `account_id` = '{$account_id_safe}'"
277 277
     ) ? true : false;
278 278
 
279
-    if($result) {
279
+    if ($result) {
280 280
       $result = $this->db_get_by_id($this->account_id);
281 281
     }
282 282
 
@@ -363,7 +363,7 @@  discard block
 block discarded – undo
363 363
   public function metamatter_change($change_type, $metamatter, $comment = '', $already_changed = false) {
364 364
     global $mm_change_legit;
365 365
 
366
-    if(!$this->is_exists || !($metamatter = round(floatval($metamatter)))) {
366
+    if (!$this->is_exists || !($metamatter = round(floatval($metamatter)))) {
367 367
       classSupernova::$debug->error('Ошибка при попытке манипуляции с ММ');
368 368
 
369 369
       return false;
@@ -373,7 +373,7 @@  discard block
 block discarded – undo
373 373
 
374 374
     $mm_change_legit = true;
375 375
     // $sn_data_metamatter_db_name = pname_resource_name(RES_METAMATTER);
376
-    if($already_changed) {
376
+    if ($already_changed) {
377 377
       $metamatter_total_delta = 0;
378 378
       $result = -1;
379 379
     } else {
@@ -383,17 +383,17 @@  discard block
 block discarded – undo
383 383
       $result = $this->db->doquery(
384 384
         "UPDATE {{account}}
385 385
         SET
386
-          `account_metamatter` = `account_metamatter` + '{$metamatter}'" .
387
-        ($metamatter_total_delta ? ", `account_immortal` = IF(`account_metamatter_total` + '{$metamatter_total_delta}' >= {$classConfig->player_metamatter_immortal}, NOW(), `account_immortal`), `account_metamatter_total` = `account_metamatter_total` + '{$metamatter_total_delta}'" : '') .
386
+          `account_metamatter` = `account_metamatter` + '{$metamatter}'".
387
+        ($metamatter_total_delta ? ", `account_immortal` = IF(`account_metamatter_total` + '{$metamatter_total_delta}' >= {$classConfig->player_metamatter_immortal}, NOW(), `account_immortal`), `account_metamatter_total` = `account_metamatter_total` + '{$metamatter_total_delta}'" : '').
388 388
         " WHERE `account_id` = {$account_id_safe}"
389 389
       );
390
-      if(!$result) {
390
+      if (!$result) {
391 391
         classSupernova::$debug->error("Error adjusting Metamatter for player ID {$this->account_id} (Player Not Found?) with {$metamatter}. Reason: {$comment}", 'Metamatter Change', 402);
392 392
       }
393 393
       $result = classSupernova::$db->db_affected_rows();
394 394
     }
395 395
 
396
-    if(empty(core_auth::$user['id'])) {
396
+    if (empty(core_auth::$user['id'])) {
397 397
       $user_list = PlayerToAccountTranslate::db_translate_get_users_from_account_list(core_auth::$main_provider->provider_id, $this->account_id);
398 398
       reset($user_list);
399 399
       $user_id_unsafe = key($user_list);
@@ -402,30 +402,30 @@  discard block
 block discarded – undo
402 402
     }
403 403
     $user_id_safe = $this->db->db_escape($user_id_unsafe);
404 404
 
405
-    if(!$result) {
405
+    if (!$result) {
406 406
       classSupernova::$debug->error("Error adjusting Metamatter for player ID {$this->account_id} (Player Not Found?) with {$metamatter}. Reason: {$comment}", 'Metamatter Change', 402);
407 407
     }
408 408
 
409
-    if(!$already_changed) {
409
+    if (!$already_changed) {
410 410
       $this->account_metamatter += $metamatter;
411 411
       $this->account_metamatter_total += $metamatter_total_delta;
412 412
     }
413 413
 
414
-    if(is_array($comment)) {
414
+    if (is_array($comment)) {
415 415
       $comment = call_user_func_array('sprintf', $comment);
416 416
     }
417 417
 
418 418
     $result = $this->db_mm_log_insert($comment, $change_type, $metamatter, $user_id_unsafe);
419 419
 
420
-    if($metamatter > 0 && !empty($user_id_safe)) {
420
+    if ($metamatter > 0 && !empty($user_id_safe)) {
421 421
       $old_referral = db_referral_get_by_id($user_id_safe);
422
-      if($old_referral['id']) {
422
+      if ($old_referral['id']) {
423 423
         $dark_matter_from_metamatter = $metamatter * AFFILIATE_MM_TO_REFERRAL_DM;
424 424
         db_referral_update_dm($user_id_safe, $dark_matter_from_metamatter);
425 425
         $new_referral = db_referral_get_by_id($user_id_safe);
426 426
 
427 427
         $partner_bonus = floor($new_referral['dark_matter'] / classSupernova::$config->rpg_bonus_divisor) - ($old_referral['dark_matter'] >= classSupernova::$config->rpg_bonus_minimum ? floor($old_referral['dark_matter'] / classSupernova::$config->rpg_bonus_divisor) : 0);
428
-        if($partner_bonus > 0 && $new_referral['dark_matter'] >= classSupernova::$config->rpg_bonus_minimum) {
428
+        if ($partner_bonus > 0 && $new_referral['dark_matter'] >= classSupernova::$config->rpg_bonus_minimum) {
429 429
           rpg_points_change($new_referral['id_partner'], RPG_REFERRAL_BOUGHT_MM, $partner_bonus, "Incoming MM From Referral ID {$user_id_safe}");
430 430
         }
431 431
       }
Please login to merge, or discard this patch.
includes/db/db_queries.php 2 patches
Doc Comments   +20 added lines, -15 removed lines patch added patch discarded remove patch
@@ -188,6 +188,11 @@  discard block
 block discarded – undo
188 188
  */
189 189
 // OK v4
190 190
 // TODO - вынести в отдельный класс
191
+/**
192
+ * @param string $db_id_field_name
193
+ * @param string $db_table_name
194
+ * @param string $db_value_field_name
195
+ */
191 196
 function db_get_set_unique_id_value($current_value_unsafe, $db_id_field_name, $db_table_name, $db_value_field_name) {
192 197
   $current_value_safe = db_escape($current_value_unsafe);
193 198
   $value_id = doquery("SELECT `{$db_id_field_name}` AS id_field FROM {{{$db_table_name}}} WHERE `{$db_value_field_name}` = '{$current_value_safe}' LIMIT 1 FOR UPDATE", true);
@@ -220,7 +225,7 @@  discard block
 block discarded – undo
220 225
 
221 226
 /**
222 227
  * @param $user
223
- * @param $username_safe
228
+ * @param string $username_safe
224 229
  */
225 230
 function db_player_name_history_replace($user, $username_safe) {
226 231
   doquery("REPLACE INTO {{player_name_history}} SET `player_id` = {$user['id']}, `player_name` = '{$username_safe}'");
@@ -228,7 +233,7 @@  discard block
 block discarded – undo
228 233
 
229 234
 
230 235
 /**
231
- * @param $username_safe
236
+ * @param string $username_safe
232 237
  *
233 238
  * @return array|bool|mysqli_result|null
234 239
  */
@@ -485,12 +490,12 @@  discard block
 block discarded – undo
485 490
 
486 491
 
487 492
 /**
488
- * @param $user_id
489
- * @param $change_type
493
+ * @param integer $user_id
494
+ * @param integer $change_type
490 495
  * @param $dark_matter
491
- * @param $comment
496
+ * @param string $comment
492 497
  * @param $row
493
- * @param $page_url
498
+ * @param string $page_url
494 499
  */
495 500
 function db_log_dark_matter_insert($user_id, $change_type, $dark_matter, $comment, $row, $page_url) {
496 501
   doquery(
@@ -506,7 +511,7 @@  discard block
 block discarded – undo
506 511
 /**
507 512
  * @param $user_id_safe
508 513
  *
509
- * @return array|bool|mysqli_result|null
514
+ * @return integer
510 515
  */
511 516
 function db_referral_get_by_id($user_id_safe) {
512 517
   $old_referral = doquery("SELECT * FROM {{referrals}} WHERE `id` = {$user_id_safe} LIMIT 1 FOR UPDATE;", true);
@@ -534,9 +539,9 @@  discard block
 block discarded – undo
534 539
 
535 540
 // Quests ***********************************************************************************************************
536 541
 /**
537
- * @param $query_add_select
542
+ * @param string $query_add_select
538 543
  * @param $query_add_from
539
- * @param $query_add_where
544
+ * @param string $query_add_where
540 545
  *
541 546
  * @return array|bool|mysqli_result|null
542 547
  */
@@ -580,11 +585,11 @@  discard block
 block discarded – undo
580 585
 }
581 586
 
582 587
 /**
583
- * @param $quest_name
584
- * @param $quest_type
585
- * @param $quest_description
588
+ * @param string $quest_name
589
+ * @param integer $quest_type
590
+ * @param string $quest_description
586 591
  * @param $quest_conditions
587
- * @param $quest_rewards
592
+ * @param string $quest_rewards
588 593
  * @param $quest_id
589 594
  */
590 595
 function db_quest_update($quest_name, $quest_type, $quest_description, $quest_conditions, $quest_rewards, $quest_id) {
@@ -607,7 +612,7 @@  discard block
 block discarded – undo
607 612
 /**
608 613
  * @param $banner
609 614
  * @param $banned
610
- * @param $reason
615
+ * @param string $reason
611 616
  * @param $ban_until
612 617
  */
613 618
 function db_ban_insert($banner, $banned, $reason, $ban_until) {
@@ -630,7 +635,7 @@  discard block
 block discarded – undo
630 635
 /**
631 636
  * @param $banner
632 637
  * @param $banned
633
- * @param $reason
638
+ * @param string $reason
634 639
  */
635 640
 function db_ban_insert_unset($banner, $banned, $reason) {
636 641
   doquery(
Please login to merge, or discard this patch.
Spacing   +14 added lines, -14 removed lines patch added patch discarded remove patch
@@ -17,11 +17,11 @@  discard block
 block discarded – undo
17 17
 
18 18
 function db_planet_list_admin_list($table_parent_columns, $planet_active, $active_time, $planet_type) {
19 19
   return doquery(
20
-    "SELECT p.*, u.username" . ($table_parent_columns ? ', p1.name AS parent_name' : '') .
20
+    "SELECT p.*, u.username".($table_parent_columns ? ', p1.name AS parent_name' : '').
21 21
     " FROM {{planets}} AS p
22 22
       LEFT JOIN {{users}} AS u ON u.id = p.id_owner" .
23
-    ($table_parent_columns ? ' LEFT JOIN {{planets}} AS p1 ON p1.id = p.parent_planet' : '') .
24
-    " WHERE " . ($planet_active ? "p.last_update >= {$active_time}" : "p.planet_type = {$planet_type}"));
23
+    ($table_parent_columns ? ' LEFT JOIN {{planets}} AS p1 ON p1.id = p.parent_planet' : '').
24
+    " WHERE ".($planet_active ? "p.last_update >= {$active_time}" : "p.planet_type = {$planet_type}"));
25 25
 }
26 26
 
27 27
 function db_planet_list_search($searchtext) {
@@ -121,7 +121,7 @@  discard block
 block discarded – undo
121 121
     ORDER BY
122 122
       sp.`{$Rank}_rank`, subject.{$source['id']}
123 123
     LIMIT
124
-      " . $start . ",100;";
124
+      ".$start.",100;";
125 125
     } else { // , UNIX_TIMESTAMP(CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, '-%m-%d'))) AS `nearest_birthday`
126 126
       $query_str =
127 127
         "SELECT
@@ -134,7 +134,7 @@  discard block
 block discarded – undo
134 134
     ORDER BY
135 135
       subject.{$Rank} DESC, subject.{$source['id']}
136 136
     LIMIT
137
-      " . $start . ",100;";
137
+      ".$start.",100;";
138 138
     }
139 139
   } else {
140 140
     // TODO
@@ -151,7 +151,7 @@  discard block
 block discarded – undo
151 151
   ORDER BY
152 152
     sp.`{$Rank}_rank`, subject.id
153 153
   LIMIT
154
-    " . $start . ",100;";
154
+    ".$start.",100;";
155 155
   }
156 156
 
157 157
   return doquery($query_str);
@@ -374,9 +374,9 @@  discard block
 block discarded – undo
374 374
  */
375 375
 function db_payment_list_get($flt_payer, $flt_status, $flt_test, $flt_module) {
376 376
   $extra_conditions =
377
-    ($flt_payer > 0 ? "AND payment_user_id = {$flt_payer} " : '') .
378
-    ($flt_status >= 0 ? "AND payment_status = {$flt_status} " : '') .
379
-    ($flt_test >= 0 ? "AND payment_test = {$flt_test} " : '') .
377
+    ($flt_payer > 0 ? "AND payment_user_id = {$flt_payer} " : '').
378
+    ($flt_status >= 0 ? "AND payment_status = {$flt_status} " : '').
379
+    ($flt_test >= 0 ? "AND payment_test = {$flt_test} " : '').
380 380
     ($flt_module ? "AND payment_module_name = '{$flt_module}' " : '');
381 381
   $query = doquery("SELECT * FROM `{{payment}}` WHERE 1 {$extra_conditions} ORDER BY payment_id DESC;");
382 382
 
@@ -404,7 +404,7 @@  discard block
 block discarded – undo
404 404
 
405 405
 // Log Online *************************************************************************************************************
406 406
 function db_log_online_insert() {
407
-  doquery("INSERT IGNORE INTO {{log_users_online}} SET online_count = " . classSupernova::$config->var_online_user_count);
407
+  doquery("INSERT IGNORE INTO {{log_users_online}} SET online_count = ".classSupernova::$config->var_online_user_count);
408 408
 }
409 409
 
410 410
 // Log *************************************************************************************************************
@@ -612,7 +612,7 @@  discard block
 block discarded – undo
612 612
       `ban_user_id` = '{$banned['id']}',
613 613
       `ban_user_name` = '{$banned['username']}',
614 614
       `ban_reason` = '{$reason}',
615
-      `ban_time` = " . SN_TIME_NOW . ",
615
+      `ban_time` = ".SN_TIME_NOW.",
616 616
       `ban_until` = {$ban_until},
617 617
       `ban_issuer_id` = '{$banner['id']}',
618 618
       `ban_issuer_name` = '{$banner['username']}',
@@ -634,7 +634,7 @@  discard block
 block discarded – undo
634 634
       `ban_user_name` = '{$banned['username']}',
635 635
       `ban_reason` = '{$reason}',
636 636
       `ban_time` = 0,
637
-      `ban_until` = " . SN_TIME_NOW . ",
637
+      `ban_until` = ".SN_TIME_NOW.",
638 638
       `ban_issuer_id` = '{$banner['id']}',
639 639
       `ban_issuer_name` = '{$banner['username']}',
640 640
       `ban_issuer_email` = '{$banner['email']}'
@@ -693,9 +693,9 @@  discard block
 block discarded – undo
693 693
 function db_ube_report_get_best_battles() {
694 694
   $query = doquery("SELECT *
695 695
       FROM {{ube_report}}
696
-      WHERE `ube_report_time_process` <  DATE(DATE_SUB(NOW(), INTERVAL " . MODULE_INFO_BEST_BATTLES_LOCK_DAYS . " DAY))
696
+      WHERE `ube_report_time_process` <  DATE(DATE_SUB(NOW(), INTERVAL " . MODULE_INFO_BEST_BATTLES_LOCK_DAYS." DAY))
697 697
       ORDER BY `ube_report_debris_total_in_metal` DESC, `ube_report_id` ASC
698
-      LIMIT " . MODULE_INFO_BEST_BATTLES_REPORT_VIEW . ";");
698
+      LIMIT " . MODULE_INFO_BEST_BATTLES_REPORT_VIEW.";");
699 699
 
700 700
   return $query;
701 701
 }
Please login to merge, or discard this patch.
includes/update.php 2 patches
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -756,9 +756,11 @@
 block discarded – undo
756 756
         !empty($strings) ? doquery($query_string . implode(',', $strings)) : false;
757 757
       }
758 758
 
759
-      if(isset($update_tables['counter']['page'])) // TODO REMOVE
759
+      if(isset($update_tables['counter']['page'])) {
760
+        // TODO REMOVE
760 761
       {
761 762
         update_security_url("SELECT DISTINCT `page` AS url FROM {{counter}}");
763
+      }
762 764
         update_security_url("SELECT DISTINCT `url` AS url FROM {{counter}}");
763 765
       }
764 766
     }
Please login to merge, or discard this patch.
Spacing   +108 added lines, -108 removed lines patch added patch discarded remove patch
@@ -23,7 +23,7 @@  discard block
 block discarded – undo
23 23
 
24 24
 use Vector\Vector;
25 25
 
26
-if(!defined('INIT')) {
26
+if (!defined('INIT')) {
27 27
 //  include_once('init.php');
28 28
   die('Unauthorized access');
29 29
 }
@@ -41,8 +41,8 @@  discard block
 block discarded – undo
41 41
 classSupernova::$config->debug = 0;
42 42
 
43 43
 
44
-if(classSupernova::$config->db_version == DB_VERSION) {
45
-} elseif(classSupernova::$config->db_version > DB_VERSION) {
44
+if (classSupernova::$config->db_version == DB_VERSION) {
45
+} elseif (classSupernova::$config->db_version > DB_VERSION) {
46 46
   classSupernova::$config->db_saveItem('var_db_update_end', SN_TIME_NOW);
47 47
   die(
48 48
   'Internal error! Auotupdater detects DB version greater then can be handled!<br />
@@ -51,7 +51,7 @@  discard block
 block discarded – undo
51 51
   );
52 52
 }
53 53
 
54
-if(classSupernova::$config->db_version < 26) {
54
+if (classSupernova::$config->db_version < 26) {
55 55
   $sys_log_disabled = true;
56 56
 }
57 57
 
@@ -70,20 +70,20 @@  discard block
 block discarded – undo
70 70
 $update_tables = array();
71 71
 $update_indexes = array();
72 72
 $query = upd_do_query('SHOW TABLES;', true);
73
-while($row = classSupernova::$db->db_fetch_row($query)) {
73
+while ($row = classSupernova::$db->db_fetch_row($query)) {
74 74
   upd_load_table_info($row[0]);
75 75
 }
76 76
 upd_log_message('Table info loaded. Now looking DB for upgrades...');
77 77
 
78 78
 upd_do_query('SET FOREIGN_KEY_CHECKS=0;', true);
79 79
 
80
-if($new_version < 37) {
80
+if ($new_version < 37) {
81 81
   require_once('update_old.php');
82 82
 }
83 83
 
84 84
 ini_set('memory_limit', '1024M');
85 85
 
86
-switch($new_version) {
86
+switch ($new_version) {
87 87
   case 37:
88 88
     upd_log_version_update();
89 89
 
@@ -98,7 +98,7 @@  discard block
 block discarded – undo
98 98
 
99 99
     upd_check_key('payment_currency_exchange_mm_', 2500, !classSupernova::$config->payment_currency_exchange_mm_);
100 100
 
101
-    if(!$update_tables['log_metamatter']) {
101
+    if (!$update_tables['log_metamatter']) {
102 102
       upd_create_table('log_metamatter',
103 103
         "(
104 104
           `id` SERIAL,
@@ -123,7 +123,7 @@  discard block
 block discarded – undo
123 123
       "ADD `payment_test` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is this a test payment?'",
124 124
     ), !$update_tables['payment']['payment_test']);
125 125
 
126
-    if($update_tables['payment']['payment_test']['Default'] == 1) {
126
+    if ($update_tables['payment']['payment_test']['Default'] == 1) {
127 127
       upd_alter_table('payment', array(
128 128
         "MODIFY COLUMN `payment_test` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is this a test payment?'",
129 129
       ));
@@ -139,15 +139,15 @@  discard block
 block discarded – undo
139 139
       "MODIFY COLUMN `metamatter` BIGINT(20) NOT NULL DEFAULT 0 COMMENT 'Metamatter amount'",
140 140
     ), $update_tables['users']['metamatter']['Type'] == 'int(20)');
141 141
 
142
-    $query = upd_do_query("SELECT * FROM {{que}} WHERE `que_type` = " . QUE_RESEARCH . " AND que_unit_id IN (" . TECH_EXPEDITION . "," . TECH_COLONIZATION . ") FOR UPDATE");
143
-    while($row = db_fetch($query)) {
142
+    $query = upd_do_query("SELECT * FROM {{que}} WHERE `que_type` = ".QUE_RESEARCH." AND que_unit_id IN (".TECH_EXPEDITION.",".TECH_COLONIZATION.") FOR UPDATE");
143
+    while ($row = db_fetch($query)) {
144 144
       $planet_id = ($row['que_planet_id_origin'] ? $row['que_planet_id_origin'] : $row['que_planet_id']);
145 145
       upd_do_query("SELECT id FROM {{planets}} WHERE id = {$planet_id} FOR UPDATE");
146 146
       $price = sys_unit_str2arr($row['que_unit_price']);
147
-      upd_do_query("UPDATE {{planets}} SET " .
148
-        "`metal` = `metal` + " . ($price[RES_METAL] ? $price[RES_METAL] : 0) . "," .
149
-        "`crystal` = `crystal` + " . ($price[RES_CRYSTAL] ? $price[RES_CRYSTAL] : 0) . "," .
150
-        "`deuterium` = `deuterium` + " . ($price[RES_DEUTERIUM] ? $price[RES_DEUTERIUM] : 0) .
147
+      upd_do_query("UPDATE {{planets}} SET ".
148
+        "`metal` = `metal` + ".($price[RES_METAL] ? $price[RES_METAL] : 0).",".
149
+        "`crystal` = `crystal` + ".($price[RES_CRYSTAL] ? $price[RES_CRYSTAL] : 0).",".
150
+        "`deuterium` = `deuterium` + ".($price[RES_DEUTERIUM] ? $price[RES_DEUTERIUM] : 0).
151 151
         " WHERE id = {$planet_id}"
152 152
       );
153 153
       upd_do_query("DELETE FROM {{que}} WHERE que_id = {$row['que_id']}");
@@ -156,10 +156,10 @@  discard block
 block discarded – undo
156 156
     $query = upd_do_query("SELECT unit_id, unit_snid, unit_level, id_planet FROM {{unit}} AS un
157 157
     LEFT JOIN {{users}} AS u ON u.id = un.unit_player_id
158 158
     LEFT JOIN {{planets}} AS p ON p.id = u.id_planet
159
-    WHERE unit_snid IN (" . TECH_EXPEDITION . "," . TECH_COLONIZATION . ")
159
+    WHERE unit_snid IN (" . TECH_EXPEDITION.",".TECH_COLONIZATION.")
160 160
     FOR UPDATE");
161
-    while($row = db_fetch($query)) {
162
-      if(!$row['id_planet']) {
161
+    while ($row = db_fetch($query)) {
162
+      if (!$row['id_planet']) {
163 163
         continue;
164 164
       }
165 165
 
@@ -167,14 +167,14 @@  discard block
 block discarded – undo
167 167
       $unit_level = $row['unit_level'];
168 168
       $price = get_unit_param($unit_id, P_COST);
169 169
       $factor = $price['factor'];
170
-      foreach($price as $resource_id => &$resource_amount) {
170
+      foreach ($price as $resource_id => &$resource_amount) {
171 171
         $resource_amount = $resource_amount * (pow($factor, $unit_level) - 1) / ($factor - 1);
172 172
       }
173 173
       // upd_do_query
174
-      upd_do_query($q = "UPDATE {{planets}} SET " .
175
-        "`metal` = `metal` + " . ($price[RES_METAL] ? $price[RES_METAL] : 0) . "," .
176
-        "`crystal` = `crystal` + " . ($price[RES_CRYSTAL] ? $price[RES_CRYSTAL] : 0) . "," .
177
-        "`deuterium` = `deuterium` + " . ($price[RES_DEUTERIUM] ? $price[RES_DEUTERIUM] : 0) .
174
+      upd_do_query($q = "UPDATE {{planets}} SET ".
175
+        "`metal` = `metal` + ".($price[RES_METAL] ? $price[RES_METAL] : 0).",".
176
+        "`crystal` = `crystal` + ".($price[RES_CRYSTAL] ? $price[RES_CRYSTAL] : 0).",".
177
+        "`deuterium` = `deuterium` + ".($price[RES_DEUTERIUM] ? $price[RES_DEUTERIUM] : 0).
178 178
         " WHERE id = {$row['id_planet']}"
179 179
       );
180 180
       upd_do_query("DELETE FROM {{unit}} WHERE unit_id = {$row['unit_id']}");
@@ -186,14 +186,14 @@  discard block
 block discarded – undo
186 186
     // Вернуть ресы за уже исследованную Экспедиционную технологию
187 187
     upd_check_key('player_max_colonies', -1, classSupernova::$config->player_max_colonies >= 0);
188 188
 
189
-    if(!isset($update_tables['users']['player_rpg_explore_xp'])) {
189
+    if (!isset($update_tables['users']['player_rpg_explore_xp'])) {
190 190
       upd_alter_table('users', array(
191 191
         "ADD COLUMN `player_rpg_explore_level` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 AFTER `dark_matter`",
192 192
         "ADD COLUMN `player_rpg_explore_xp` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 AFTER `dark_matter`",
193 193
       ), !isset($update_tables['users']['player_rpg_explore_xp']));
194 194
     }
195 195
 
196
-    if(!$update_tables['log_users_online']) {
196
+    if (!$update_tables['log_users_online']) {
197 197
       upd_create_table('log_users_online', "(
198 198
         `online_timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Measure time',
199 199
         `online_count` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Users online',
@@ -208,11 +208,11 @@  discard block
 block discarded – undo
208 208
       "ADD `user_time_measured` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'When was time diff measured last time' AFTER `onlinetime`",
209 209
     ), !$update_tables['users']['user_time_measured']);
210 210
 
211
-    if($update_tables['rw']) {
211
+    if ($update_tables['rw']) {
212 212
       upd_do_query("DROP TABLE IF EXISTS {{rw}};");
213 213
     }
214 214
 
215
-    if(!$update_tables['player_award']) {
215
+    if (!$update_tables['player_award']) {
216 216
       upd_create_table('player_award', "(
217 217
         `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
218 218
         `award_type_id` int(11) DEFAULT NULL COMMENT 'Award type i.e. order, medal, pennant, rank etc',
@@ -254,14 +254,14 @@  discard block
 block discarded – undo
254 254
     upd_log_version_update();
255 255
 
256 256
 
257
-    if(!isset($update_tables['planets']['que_processed'])) {
257
+    if (!isset($update_tables['planets']['que_processed'])) {
258 258
       upd_alter_table('planets', array(
259 259
         "ADD COLUMN `que_processed` INT(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `last_update`",
260 260
       ), true);
261 261
       upd_do_query("UPDATE {{planets}} SET que_processed = last_update;");
262 262
     }
263 263
 
264
-    if(!isset($update_tables['users']['que_processed'])) {
264
+    if (!isset($update_tables['users']['que_processed'])) {
265 265
       upd_alter_table('users', array(
266 266
         "ADD COLUMN `que_processed` INT(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `onlinetime`",
267 267
       ), true);
@@ -269,7 +269,7 @@  discard block
 block discarded – undo
269 269
     }
270 270
 
271 271
 
272
-    if(isset($update_tables['planets']['que'])) {
272
+    if (isset($update_tables['planets']['que'])) {
273 273
       $sn_data_aux = array(
274 274
         SHIP_SMALL_FIGHTER_WRATH    => array(
275 275
           'name' => 'ship_fighter_wrath',
@@ -354,20 +354,20 @@  discard block
 block discarded – undo
354 354
       $unit_data = array();
355 355
       $planets = array();
356 356
 
357
-      foreach($planet_unit_list as $unit_id) {
358
-        if(!($unit_name = get_unit_param($unit_id, P_NAME))) {
357
+      foreach ($planet_unit_list as $unit_id) {
358
+        if (!($unit_name = get_unit_param($unit_id, P_NAME))) {
359 359
           $unit_name = $sn_data_aux[$unit_id][P_NAME];
360 360
         }
361
-        if(isset($update_tables['planets'][$unit_name])) {
361
+        if (isset($update_tables['planets'][$unit_name])) {
362 362
           $drop[] = "DROP COLUMN `{$unit_name}`";
363 363
 
364
-          if(isset($aux_group[$unit_id])) {
364
+          if (isset($aux_group[$unit_id])) {
365 365
             $units_info[$unit_id] = $sn_data_aux[$unit_id];
366 366
             $units_info[$unit_id]['que'] = QUE_HANGAR;
367 367
           } else {
368 368
             $units_info[$unit_id] = get_unit_param($unit_id);
369
-            foreach($ques_info as $que_id => $que_data1) {
370
-              if(in_array($unit_id, $que_data1['unit_list'])) {
369
+            foreach ($ques_info as $que_id => $que_data1) {
370
+              if (in_array($unit_id, $que_data1['unit_list'])) {
371 371
                 $units_info[$unit_id]['que'] = $que_id;
372 372
                 break;
373 373
               }
@@ -377,7 +377,7 @@  discard block
 block discarded – undo
377 377
       }
378 378
 
379 379
       $query = upd_do_query("SELECT * FROM {{planets}} FOR UPDATE");
380
-      while($row = db_fetch($query)) {
380
+      while ($row = db_fetch($query)) {
381 381
         $user_id = $row['id_owner'];
382 382
         $planet_id = $row['id'];
383 383
 
@@ -385,25 +385,25 @@  discard block
 block discarded – undo
385 385
 
386 386
         // Конвертируем юниты
387 387
         $units_levels = array();
388
-        foreach($planet_unit_list as $unit_id) {
388
+        foreach ($planet_unit_list as $unit_id) {
389 389
           $unit_name = &$units_info[$unit_id][P_NAME];
390
-          if(!isset($row[$unit_name]) || !$row[$unit_name]) {
390
+          if (!isset($row[$unit_name]) || !$row[$unit_name]) {
391 391
             continue;
392 392
           }
393 393
           $units_levels[$unit_id] = $row[$unit_name];
394
-          $unit_data[] = "({$user_id}," . LOC_PLANET . ",{$planet_id},{$units_info[$unit_id][P_UNIT_TYPE]},{$unit_id},{$units_levels[$unit_id]})";
395
-          if(count($unit_data) > 30) {
394
+          $unit_data[] = "({$user_id},".LOC_PLANET.",{$planet_id},{$units_info[$unit_id][P_UNIT_TYPE]},{$unit_id},{$units_levels[$unit_id]})";
395
+          if (count($unit_data) > 30) {
396 396
             $unit_data_max = strlen(implode(',', $unit_data)) > $unit_data_max ? strlen(implode(',', $unit_data)) : $unit_data_max;
397
-            upd_do_query('REPLACE INTO {{unit}} (`unit_player_id`, `unit_location_type`, `unit_location_id`, `unit_type`, `unit_snid`, `unit_level`) VALUES ' . implode(',', $unit_data) . ';');
397
+            upd_do_query('REPLACE INTO {{unit}} (`unit_player_id`, `unit_location_type`, `unit_location_id`, `unit_type`, `unit_snid`, `unit_level`) VALUES '.implode(',', $unit_data).';');
398 398
             $unit_data = array();
399 399
           }
400 400
         }
401 401
 
402 402
         // Конвертируем очередь построек
403
-        if($row['que']) {
403
+        if ($row['que']) {
404 404
           $que = explode(';', $row['que']);
405
-          foreach($que as $que_item) {
406
-            if(!$que_item) {
405
+          foreach ($que as $que_item) {
406
+            if (!$que_item) {
407 407
               continue;
408 408
             }
409 409
 
@@ -418,8 +418,8 @@  discard block
 block discarded – undo
418 418
             $unit_factor = $unit_cost[P_FACTOR] ? $unit_cost[P_FACTOR] : 1;
419 419
             $price_increase = pow($unit_factor, $unit_level);
420 420
             // $unit_time = 0;
421
-            foreach($unit_cost as $resource_id => &$resource_amount) {
422
-              if(!in_array($resource_id, $group_resource_loot)) {
421
+            foreach ($unit_cost as $resource_id => &$resource_amount) {
422
+              if (!in_array($resource_id, $group_resource_loot)) {
423 423
                 unset($unit_cost[$resource_id]);
424 424
                 continue;
425 425
               }
@@ -433,39 +433,39 @@  discard block
 block discarded – undo
433 433
         }
434 434
 
435 435
         // Конвертируем очередь верфи
436
-        if($row['b_hangar_id']) {
436
+        if ($row['b_hangar_id']) {
437 437
           $return_resources = array(RES_METAL => 0, RES_CRYSTAL => 0, RES_DEUTERIUM => 0,);
438 438
           $hangar_units = sys_unit_str2arr($row['b_hangar_id']);
439
-          foreach($hangar_units as $unit_id => $unit_count) {
440
-            if($unit_count <= 0) {
439
+          foreach ($hangar_units as $unit_id => $unit_count) {
440
+            if ($unit_count <= 0) {
441 441
               continue;
442 442
             }
443
-            foreach($units_info[$unit_id][P_COST] as $resource_id => $resource_amount) {
444
-              if(!in_array($resource_id, $group_resource_loot)) {
443
+            foreach ($units_info[$unit_id][P_COST] as $resource_id => $resource_amount) {
444
+              if (!in_array($resource_id, $group_resource_loot)) {
445 445
                 continue;
446 446
               }
447 447
               $return_resources[$resource_id] += $unit_count * $resource_amount;
448 448
             }
449 449
           }
450
-          if(array_sum($return_resources) > 0) {
450
+          if (array_sum($return_resources) > 0) {
451 451
             upd_do_query("UPDATE {{planets}} SET `metal` = `metal` + {$return_resources[RES_METAL]}, `crystal` = `crystal` + {$return_resources[RES_CRYSTAL]}, `deuterium` = `deuterium` + {$return_resources[RES_DEUTERIUM]} WHERE `id` = {$planet_id} LIMIT 1");
452 452
           }
453 453
         }
454 454
 
455 455
 
456
-        if(count($que_data) > 10) {
456
+        if (count($que_data) > 10) {
457 457
           $que_data_max = strlen(implode(',', $que_data)) > $que_data_max ? strlen(implode(',', $que_data)) : $que_data_max;
458
-          upd_do_query('INSERT INTO {{que}} (`que_player_id`, `que_planet_id`, `que_planet_id_origin`, `que_type`, `que_time_left`, `que_unit_id`, `que_unit_amount`, `que_unit_mode`, `que_unit_level`, `que_unit_time`, `que_unit_price`) VALUES ' . implode(',', $que_data) . ';');
458
+          upd_do_query('INSERT INTO {{que}} (`que_player_id`, `que_planet_id`, `que_planet_id_origin`, `que_type`, `que_time_left`, `que_unit_id`, `que_unit_amount`, `que_unit_mode`, `que_unit_level`, `que_unit_time`, `que_unit_price`) VALUES '.implode(',', $que_data).';');
459 459
           $que_data = array();
460 460
         }
461 461
       }
462 462
 
463
-      if(!empty($unit_data)) {
464
-        upd_do_query('REPLACE INTO {{unit}} (`unit_player_id`, `unit_location_type`, `unit_location_id`, `unit_type`, `unit_snid`, `unit_level`) VALUES ' . implode(',', $unit_data) . ';');
463
+      if (!empty($unit_data)) {
464
+        upd_do_query('REPLACE INTO {{unit}} (`unit_player_id`, `unit_location_type`, `unit_location_id`, `unit_type`, `unit_snid`, `unit_level`) VALUES '.implode(',', $unit_data).';');
465 465
       }
466 466
 
467
-      if(!empty($que_data)) {
468
-        upd_do_query('INSERT INTO {{que}} (`que_player_id`, `que_planet_id`, `que_planet_id_origin`, `que_type`, `que_time_left`, `que_unit_id`, `que_unit_amount`, `que_unit_mode`, `que_unit_level`, `que_unit_time`, `que_unit_price`) VALUES ' . implode(',', $que_data) . ';');
467
+      if (!empty($que_data)) {
468
+        upd_do_query('INSERT INTO {{que}} (`que_player_id`, `que_planet_id`, `que_planet_id_origin`, `que_type`, `que_time_left`, `que_unit_id`, `que_unit_amount`, `que_unit_mode`, `que_unit_level`, `que_unit_time`, `que_unit_price`) VALUES '.implode(',', $que_data).';');
469 469
       }
470 470
 
471 471
       upd_alter_table('planets', $drop, true);
@@ -475,7 +475,7 @@  discard block
 block discarded – undo
475 475
       JOIN `{{users}}` AS u ON a.`id` = u.`user_as_ally` AND `user_as_ally` IS NOT NULL AND `username` = ''
476 476
       SET u.`username` = CONCAT('[', a.`ally_tag`, ']');");
477 477
 
478
-    if($update_indexes['statpoints']['I_stats_id_ally'] != 'id_ally,stat_type,stat_code,') {
478
+    if ($update_indexes['statpoints']['I_stats_id_ally'] != 'id_ally,stat_type,stat_code,') {
479 479
       upd_do_query("SET FOREIGN_KEY_CHECKS=0;");
480 480
       upd_alter_table('statpoints', "DROP FOREIGN KEY `FK_stats_id_ally`", $update_foreigns['statpoints']['FK_stats_id_ally']);
481 481
       upd_alter_table('statpoints', "DROP KEY `I_stats_id_ally`", $update_indexes['statpoints']['I_stats_id_ally']);
@@ -571,7 +571,7 @@  discard block
 block discarded – undo
571 571
       "ADD CONSTRAINT `FK_users_browser_id` FOREIGN KEY (`user_last_browser_id`) REFERENCES `{{security_browser}}` (`browser_id`) ON DELETE SET NULL ON UPDATE CASCADE",
572 572
     ), !isset($update_tables['users']['user_last_proxy']));
573 573
 
574
-    if(!isset($update_tables['notes']['planet_type'])) {
574
+    if (!isset($update_tables['notes']['planet_type'])) {
575 575
       upd_alter_table('notes', array(
576 576
         "ADD COLUMN `galaxy` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0 AFTER `title`",
577 577
         "ADD COLUMN `system` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0 AFTER `galaxy`",
@@ -589,7 +589,7 @@  discard block
 block discarded – undo
589 589
     upd_alter_table('users', "ADD COLUMN `user_bot` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0", !isset($update_tables['users']['user_bot']));
590 590
     upd_alter_table('unit', "ADD KEY `I_unit_type_snid` (unit_type, unit_snid) USING BTREE", !$update_indexes['unit']['I_unit_type_snid']);
591 591
 
592
-    if($update_tables['users']['settings_tooltiptime']['Type'] != 'smallint(5) unsigned') {
592
+    if ($update_tables['users']['settings_tooltiptime']['Type'] != 'smallint(5) unsigned') {
593 593
       upd_alter_table('users', array(
594 594
         "MODIFY COLUMN `settings_tooltiptime` smallint(5) unsigned NOT NULL DEFAULT '500'",
595 595
       ), $update_tables['users']['settings_tooltiptime']['Type'] != 'smallint');
@@ -597,7 +597,7 @@  discard block
 block discarded – undo
597 597
       upd_do_query("UPDATE `{{users}}` SET settings_tooltiptime = 500;");
598 598
     }
599 599
 
600
-    if(!isset($update_tables['log_users_online']['online_aggregated'])) {
600
+    if (!isset($update_tables['log_users_online']['online_aggregated'])) {
601 601
       upd_alter_table('log_users_online', "ADD COLUMN `online_aggregated` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0", !isset($update_tables['log_users_online']['online_aggregated']));
602 602
       upd_alter_table('log_users_online', array(
603 603
         "DROP PRIMARY KEY",
@@ -605,13 +605,13 @@  discard block
 block discarded – undo
605 605
       ), $update_indexes['log_users_online']['PRIMARY'] != 'online_timestamp,online_aggregated,');
606 606
     }
607 607
 
608
-    if(!isset($update_tables['users']['gender'])) {
609
-      upd_alter_table('users', "ADD COLUMN `gender` TINYINT(1) UNSIGNED NOT NULL DEFAULT " . GENDER_UNKNOWN, !isset($update_tables['users']['gender']));
610
-      upd_do_query("UPDATE {{users}} SET `gender` = IF(UPPER(`sex`) = 'F', " . GENDER_FEMALE . ", IF(UPPER(`sex`) = 'M', " . GENDER_MALE . ", " . GENDER_UNKNOWN . "));");
608
+    if (!isset($update_tables['users']['gender'])) {
609
+      upd_alter_table('users', "ADD COLUMN `gender` TINYINT(1) UNSIGNED NOT NULL DEFAULT ".GENDER_UNKNOWN, !isset($update_tables['users']['gender']));
610
+      upd_do_query("UPDATE {{users}} SET `gender` = IF(UPPER(`sex`) = 'F', ".GENDER_FEMALE.", IF(UPPER(`sex`) = 'M', ".GENDER_MALE.", ".GENDER_UNKNOWN."));");
611 611
     }
612 612
     upd_alter_table('users', "DROP COLUMN `sex`", isset($update_tables['users']['sex']));
613 613
 
614
-    if(!$update_tables['users']['dark_matter_total']) {
614
+    if (!$update_tables['users']['dark_matter_total']) {
615 615
       upd_alter_table('users', "ADD `dark_matter_total` BIGINT(20) NOT NULL DEFAULT 0 COMMENT 'Total Dark Matter amount ever gained' AFTER `dark_matter`", !$update_tables['users']['dark_matter_total']);
616 616
       upd_do_query(
617 617
         "UPDATE `{{users}}` AS u
@@ -624,7 +624,7 @@  discard block
 block discarded – undo
624 624
     }
625 625
 
626 626
     upd_check_key('player_metamatter_immortal', 100000, !isset(classSupernova::$config->player_metamatter_immortal));
627
-    if(!$update_tables['users']['metamatter_total']) {
627
+    if (!$update_tables['users']['metamatter_total']) {
628 628
       upd_alter_table('users', "ADD `metamatter_total` BIGINT(20) NOT NULL DEFAULT 0 COMMENT 'Total Metamatter amount ever bought'", !$update_tables['users']['metamatter_total']);
629 629
 
630 630
       upd_do_query(
@@ -636,11 +636,11 @@  discard block
 block discarded – undo
636 636
             (SELECT IF(sum(amount) IS NULL, 0, sum(amount)) FROM {{log_metamatter}} AS mm WHERE mm.user_id = u.id AND mm.amount > 0)
637 637
           );");
638 638
     }
639
-    if(!isset($update_tables['users']['immortal'])) {
639
+    if (!isset($update_tables['users']['immortal'])) {
640 640
       upd_alter_table('users', "ADD COLUMN `immortal` TIMESTAMP NULL", !isset($update_tables['users']['immortal']));
641 641
       upd_do_query("UPDATE {{users}} SET `immortal` = NOW() WHERE `metamatter_total` > 0;");
642 642
     }
643
-    if(isset($update_tables['player_award'])) {
643
+    if (isset($update_tables['player_award'])) {
644 644
       upd_do_query(
645 645
         "UPDATE {{users}} AS u JOIN {{player_award}} AS pa ON u.id = pa.player_id
646 646
           SET metamatter_total = 1, immortal = NOW()
@@ -667,7 +667,7 @@  discard block
 block discarded – undo
667 667
       CONSTRAINT `FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `{{users}}` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
668 668
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
669 669
 
670
-    if(empty($update_tables['blitz_statpoints'])) {
670
+    if (empty($update_tables['blitz_statpoints'])) {
671 671
       upd_create_table('blitz_statpoints', " (
672 672
         `stat_date` int(11) NOT NULL DEFAULT '0',
673 673
         `id_owner` bigint(20) unsigned DEFAULT NULL,
@@ -735,7 +735,7 @@  discard block
 block discarded – undo
735 735
       CONSTRAINT `FK_survey_votes_survey_parent_id` FOREIGN KEY (`survey_parent_id`) REFERENCES `{{survey}}` (`survey_id`) ON DELETE CASCADE ON UPDATE CASCADE
736 736
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;");
737 737
 
738
-    if(empty($update_tables['security_url'])) {
738
+    if (empty($update_tables['security_url'])) {
739 739
       upd_create_table('security_url', " (
740 740
         `url_id` int unsigned NOT NULL AUTO_INCREMENT,
741 741
         `url_string` VARCHAR(250) NOT NULL DEFAULT '',
@@ -748,17 +748,17 @@  discard block
 block discarded – undo
748 748
 
749 749
         $strings = array();
750 750
         $query = doquery($query);
751
-        while($row = db_fetch($query)) {
752
-          $strings[] = '("' . db_escape($row['url']) . '")';
753
-          if(count($strings) > 100) {
754
-            doquery($query_string . implode(',', $strings));
751
+        while ($row = db_fetch($query)) {
752
+          $strings[] = '("'.db_escape($row['url']).'")';
753
+          if (count($strings) > 100) {
754
+            doquery($query_string.implode(',', $strings));
755 755
             $strings = array();
756 756
           }
757 757
         }
758
-        !empty($strings) ? doquery($query_string . implode(',', $strings)) : false;
758
+        !empty($strings) ? doquery($query_string.implode(',', $strings)) : false;
759 759
       }
760 760
 
761
-      if(isset($update_tables['counter']['page'])) // TODO REMOVE
761
+      if (isset($update_tables['counter']['page'])) // TODO REMOVE
762 762
       {
763 763
         update_security_url("SELECT DISTINCT `page` AS url FROM {{counter}}");
764 764
         update_security_url("SELECT DISTINCT `url` AS url FROM {{counter}}");
@@ -783,7 +783,7 @@  discard block
 block discarded – undo
783 783
       "ADD CONSTRAINT `FK_counter_page_url_id` FOREIGN KEY (`page_url_id`) REFERENCES `{{security_url}}` (`url_id`) ON DELETE CASCADE ON UPDATE CASCADE",
784 784
       "ADD CONSTRAINT `FK_counter_plain_url_id` FOREIGN KEY (`plain_url_id`) REFERENCES `{{security_url}}` (`url_id`) ON DELETE CASCADE ON UPDATE CASCADE",
785 785
     ), !isset($update_tables['counter']['device_id']));
786
-    if(isset($update_tables['counter']['ip'])) {
786
+    if (isset($update_tables['counter']['ip'])) {
787 787
       // upd_do_query('UPDATE `{{counter}}` SET `user_ip` = INET_ATON(`ip`), `user_proxy` = `proxy`, `visit_time` = FROM_UNIXTIME(`time`)');
788 788
       upd_do_query('UPDATE `{{counter}}` SET `user_ip` = INET_ATON(`ip`), `visit_time` = FROM_UNIXTIME(`time`)');
789 789
       upd_do_query('UPDATE `{{counter}}` AS c JOIN {{security_url}} AS u ON u.url_string = c.page SET c.page_url_id = u.url_id');
@@ -834,7 +834,7 @@  discard block
 block discarded – undo
834 834
 
835 835
     upd_check_key('stats_history_days', 14, !classSupernova::$config->stats_history_days);
836 836
 
837
-    if(classSupernova::$config->payment_currency_default != 'USD') {
837
+    if (classSupernova::$config->payment_currency_default != 'USD') {
838 838
       upd_check_key('payment_currency_default', 'USD', true);
839 839
       upd_check_key('payment_currency_exchange_dm_', 20000, true);
840 840
       upd_check_key('payment_currency_exchange_mm_', 20000, true);
@@ -891,7 +891,7 @@  discard block
 block discarded – undo
891 891
 
892 892
     $virtual_exploded = explode('/', SN_ROOT_VIRTUAL_PARENT);
893 893
     // TODO - переделать всё на db_loadItem... НАВЕРНОЕ
894
-    upd_check_key('server_email', 'root@' . $virtual_exploded[2], !classSupernova::$config->db_loadItem('server_email'));
894
+    upd_check_key('server_email', 'root@'.$virtual_exploded[2], !classSupernova::$config->db_loadItem('server_email'));
895 895
 
896 896
     upd_alter_table('survey_votes', array(
897 897
       "DROP FOREIGN KEY `FK_survey_votes_user`",
@@ -917,12 +917,12 @@  discard block
 block discarded – undo
917 917
     function propagade_player_options($old_option_name, $new_option_id) {
918 918
       global $update_tables;
919 919
 
920
-      if(!empty($update_tables['users'][$old_option_name])) {
920
+      if (!empty($update_tables['users'][$old_option_name])) {
921 921
         upd_do_query(
922 922
           "REPLACE INTO {{player_options}} (`player_id`, `option_id`, `value`)
923 923
           SELECT `id`, {$new_option_id}, `{$old_option_name}`
924 924
           FROM {{users}}
925
-          WHERE `user_as_ally` is null and `user_bot` = " . USER_BOT_PLAYER);
925
+          WHERE `user_as_ally` is null and `user_bot` = ".USER_BOT_PLAYER);
926 926
         // TODO - UNCOMMENT !!!
927 927
         upd_alter_table('users', array("DROP COLUMN `{$old_option_name}`",));
928 928
       }
@@ -951,7 +951,7 @@  discard block
 block discarded – undo
951 951
 
952 952
 
953 953
     // 2015-08-03 15:05:26 40a6.0
954
-    if(empty($update_tables['planets']['position_original'])) {
954
+    if (empty($update_tables['planets']['position_original'])) {
955 955
       upd_alter_table('planets', array(
956 956
         "ADD COLUMN `position_original` smallint NOT NULL DEFAULT 0",
957 957
         "ADD COLUMN `field_max_original` smallint NOT NULL DEFAULT 0",
@@ -966,7 +966,7 @@  discard block
 block discarded – undo
966 966
       upd_do_query('UPDATE {{planets}} SET `position_original` = `planet`, `field_max_original` = `field_max`, `temp_min_original` = `temp_min`, `temp_max_original` = `temp_max`;');
967 967
 
968 968
       // Миграция тяжмета в оливин
969
-      upd_do_query('UPDATE {{planets}} SET `density_index` = ' . PLANET_DENSITY_METAL_PERIDOT . ' WHERE `density_index` = 7'); // deprecated define('PLANET_DENSITY_METAL_HEAVY', 7);
969
+      upd_do_query('UPDATE {{planets}} SET `density_index` = '.PLANET_DENSITY_METAL_PERIDOT.' WHERE `density_index` = 7'); // deprecated define('PLANET_DENSITY_METAL_HEAVY', 7);
970 970
 
971 971
       // Добавляем планету-странника
972 972
       upd_check_key('game_maxPlanet', 16, Vector::$knownPlanets == 15);
@@ -979,12 +979,12 @@  discard block
 block discarded – undo
979 979
 
980 980
     // 2015-08-27 19:14:05 40a10.0
981 981
     // Старая версия таблицы
982
-    if(!empty($update_tables['account']['account_is_global']) || empty($update_tables['account']['account_immortal'])) {
982
+    if (!empty($update_tables['account']['account_is_global']) || empty($update_tables['account']['account_immortal'])) {
983 983
       upd_drop_table('account');
984 984
       upd_drop_table('account_translate');
985 985
     }
986 986
 
987
-    if(empty($update_tables['account'])) {
987
+    if (empty($update_tables['account'])) {
988 988
       upd_create_table('account', " (
989 989
           `account_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
990 990
           `account_name` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '',
@@ -1003,7 +1003,7 @@  discard block
 block discarded – undo
1003 1003
         ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;");
1004 1004
 
1005 1005
       upd_create_table('account_translate', " (
1006
-          `provider_id` tinyint unsigned NOT NULL DEFAULT " . ACCOUNT_PROVIDER_LOCAL . " COMMENT 'Account provider',
1006
+          `provider_id` tinyint unsigned NOT NULL DEFAULT " . ACCOUNT_PROVIDER_LOCAL." COMMENT 'Account provider',
1007 1007
           `provider_account_id` bigint(20) unsigned NOT NULL COMMENT 'Account ID on provider',
1008 1008
           `user_id` bigint(20) unsigned NOT NULL COMMENT 'User ID',
1009 1009
           `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
@@ -1018,12 +1018,12 @@  discard block
 block discarded – undo
1018 1018
             (`account_id`, `account_name`, `account_password`, `account_salt`, `account_email`, `account_register_time`, `account_language`, `account_metamatter`, `account_metamatter_total`, `account_immortal`)
1019 1019
           SELECT
1020 1020
             `id`, `username`, `password`, `salt`, `email_2`, FROM_UNIXTIME(register_time), `lang`, `metamatter`, `metamatter_total`, `immortal`
1021
-          FROM {{users}} WHERE `user_as_ally` IS NULL AND `user_bot` = " . USER_BOT_PLAYER . ";"
1021
+          FROM {{users}} WHERE `user_as_ally` IS NULL AND `user_bot` = " . USER_BOT_PLAYER.";"
1022 1022
       );
1023 1023
 
1024 1024
       upd_do_query(
1025 1025
         "REPLACE INTO {{account_translate}} (`provider_id`, `provider_account_id`, `user_id`, `timestamp`)
1026
-          SELECT " . ACCOUNT_PROVIDER_LOCAL . ", a.account_id, u.id, a.`account_register_time`
1026
+          SELECT " . ACCOUNT_PROVIDER_LOCAL.", a.account_id, u.id, a.`account_register_time`
1027 1027
             FROM {{users}} AS u
1028 1028
             JOIN {{account}} AS a ON
1029 1029
               a.account_name = u.username
@@ -1038,7 +1038,7 @@  discard block
 block discarded – undo
1038 1038
 
1039 1039
 
1040 1040
     // 2015-09-05 17:07:15 40a10.17
1041
-    upd_alter_table('ube_report', "ADD COLUMN `ube_report_capture_result` tinyint unsigned NOT NULL DEFAULT " . UBE_CAPTURE_DISABLED, empty($update_tables['ube_report']['ube_report_capture_result']));
1041
+    upd_alter_table('ube_report', "ADD COLUMN `ube_report_capture_result` tinyint unsigned NOT NULL DEFAULT ".UBE_CAPTURE_DISABLED, empty($update_tables['ube_report']['ube_report_capture_result']));
1042 1042
 
1043 1043
 
1044 1044
     // 2015-09-07 21:11:48 40a10.19
@@ -1046,18 +1046,18 @@  discard block
 block discarded – undo
1046 1046
 
1047 1047
 
1048 1048
     // 2015-09-24 11:39:37 40a10.25
1049
-    if(empty($update_tables['log_metamatter']['provider_id'])) {
1049
+    if (empty($update_tables['log_metamatter']['provider_id'])) {
1050 1050
       upd_alter_table('log_metamatter', array(
1051
-        "ADD COLUMN `provider_id` tinyint unsigned NOT NULL DEFAULT " . ACCOUNT_PROVIDER_LOCAL . " COMMENT 'Account provider'",
1051
+        "ADD COLUMN `provider_id` tinyint unsigned NOT NULL DEFAULT ".ACCOUNT_PROVIDER_LOCAL." COMMENT 'Account provider'",
1052 1052
         "ADD COLUMN `account_id` bigint(20) unsigned NOT NULL DEFAULT 0",
1053 1053
         "ADD COLUMN `account_name` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT ''",
1054
-        "ADD COLUMN `server_name` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '" . SN_ROOT_VIRTUAL . "'",
1054
+        "ADD COLUMN `server_name` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '".SN_ROOT_VIRTUAL."'",
1055 1055
       ), empty($update_tables['log_metamatter']['provider_id']));
1056 1056
 
1057 1057
       upd_do_query("UPDATE {{log_metamatter}} SET `account_id` = `user_id`, `account_name` = `username`");
1058 1058
 
1059 1059
       upd_alter_table('payment', array(
1060
-        "ADD COLUMN `payment_provider_id` tinyint unsigned NOT NULL DEFAULT " . ACCOUNT_PROVIDER_LOCAL . " COMMENT 'Payment account provider'",
1060
+        "ADD COLUMN `payment_provider_id` tinyint unsigned NOT NULL DEFAULT ".ACCOUNT_PROVIDER_LOCAL." COMMENT 'Payment account provider'",
1061 1061
         "ADD COLUMN `payment_account_id` bigint(20) unsigned NOT NULL",
1062 1062
         "ADD COLUMN `payment_account_name` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT ''",
1063 1063
       ), !$update_tables['payment']['payment_account_id']);
@@ -1098,7 +1098,7 @@  discard block
 block discarded – undo
1098 1098
     upd_check_key('event_halloween_2015_code', '', !isset(classSupernova::$config->event_halloween_2015_code));
1099 1099
     upd_check_key('event_halloween_2015_timestamp', SN_TIME_SQL, !isset(classSupernova::$config->event_halloween_2015_timestamp));
1100 1100
     upd_check_key('event_halloween_2015_units_used', serialize(array()), !isset(classSupernova::$config->event_halloween_2015_units_used));
1101
-    if(empty($update_tables['log_halloween_2015'])) {
1101
+    if (empty($update_tables['log_halloween_2015'])) {
1102 1102
       upd_create_table('log_halloween_2015', " (
1103 1103
       `log_hw2015_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1104 1104
       `player_id` bigint(20) unsigned NOT NULL COMMENT 'User ID',
@@ -1113,7 +1113,7 @@  discard block
 block discarded – undo
1113 1113
 
1114 1114
 
1115 1115
     // 2015-11-28 06:30:27 40a19.21
1116
-    if(!isset($update_tables['ube_report']['ube_report_debris_total_in_metal'])) {
1116
+    if (!isset($update_tables['ube_report']['ube_report_debris_total_in_metal'])) {
1117 1117
       upd_alter_table('ube_report', array(
1118 1118
         "ADD COLUMN `ube_report_debris_total_in_metal` DECIMAL(65,0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Total debris in metal'",
1119 1119
         "ADD KEY `I_ube_report_time_debris_id` (`ube_report_time_process` DESC, `ube_report_debris_total_in_metal` DESC, `ube_report_id` ASC)", // For Best Battles module
@@ -1128,7 +1128,7 @@  discard block
 block discarded – undo
1128 1128
 
1129 1129
 
1130 1130
     // 2015-12-06 15:10:58 40b1.0
1131
-    if(!empty($update_indexes['planets']['I_metal_mine'])) {
1131
+    if (!empty($update_indexes['planets']['I_metal_mine'])) {
1132 1132
       upd_alter_table('planets', "DROP KEY `I_metal`", $update_indexes['planets']['I_metal']);
1133 1133
       upd_alter_table('planets', "DROP KEY `I_ship_sattelite_sloth`", $update_indexes['planets']['I_ship_sattelite_sloth']);
1134 1134
       upd_alter_table('planets', "DROP KEY `I_ship_bomber_envy`", $update_indexes['planets']['I_ship_bomber_envy']);
@@ -1191,7 +1191,7 @@  discard block
 block discarded – undo
1191 1191
   case 40:
1192 1192
     upd_log_version_update();
1193 1193
 
1194
-    if(empty($update_tables['festival'])) {
1194
+    if (empty($update_tables['festival'])) {
1195 1195
       upd_create_table('festival', " (
1196 1196
           `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
1197 1197
           `start` datetime NOT NULL COMMENT 'Festival start datetime',
@@ -1232,7 +1232,7 @@  discard block
 block discarded – undo
1232 1232
       );
1233 1233
     }
1234 1234
 
1235
-    if(empty($update_tables['festival_unit'])) {
1235
+    if (empty($update_tables['festival_unit'])) {
1236 1236
       upd_create_table('festival_unit', " (
1237 1237
           `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1238 1238
           `highspot_id` int(10) unsigned DEFAULT NULL,
@@ -1249,7 +1249,7 @@  discard block
 block discarded – undo
1249 1249
     }
1250 1250
 
1251 1251
     // 2015-12-21 06:06:09 41a0.12
1252
-    if(empty($update_tables['festival_unit_log'])) {
1252
+    if (empty($update_tables['festival_unit_log'])) {
1253 1253
       upd_create_table('festival_unit_log', " (
1254 1254
           `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1255 1255
           `highspot_id` int(10) unsigned DEFAULT NULL,
@@ -1279,19 +1279,19 @@  discard block
 block discarded – undo
1279 1279
       $update_tables['security_browser']['browser_user_agent']['Collation'] == 'latin1_bin'
1280 1280
     );
1281 1281
 
1282
-    if($update_indexes_full['security_browser']['I_browser_user_agent']['browser_user_agent']['Index_type'] == 'BTREE') {
1282
+    if ($update_indexes_full['security_browser']['I_browser_user_agent']['browser_user_agent']['Index_type'] == 'BTREE') {
1283 1283
       upd_alter_table('security_browser', "DROP KEY `I_browser_user_agent`", true);
1284 1284
       upd_alter_table('security_browser', "ADD KEY `I_browser_user_agent` (`browser_user_agent`) USING HASH", true);
1285 1285
     }
1286 1286
 
1287
-    if(!empty($update_tables['fleets']['fleet_array'])) {
1287
+    if (!empty($update_tables['fleets']['fleet_array'])) {
1288 1288
       $query = upd_do_query("SELECT * FROM {{fleets}}");
1289
-      while($row = db_fetch($query)) {
1289
+      while ($row = db_fetch($query)) {
1290 1290
         $unit_list = sys_unit_str2arr($row['fleet_array']);
1291
-        foreach($unit_list as $unit_id => $unit_count) {
1291
+        foreach ($unit_list as $unit_id => $unit_count) {
1292 1292
           upd_do_query(
1293 1293
             "REPLACE INTO {{unit}} (`unit_player_id`,`unit_location_type`,`unit_location_id`,`unit_type`,`unit_snid`,`unit_level`) VALUES
1294
-              ({$row['fleet_owner']}, " . LOC_FLEET . ", {$row['fleet_id']}, 200, {$unit_id}, {$unit_count});",
1294
+              ({$row['fleet_owner']}, ".LOC_FLEET.", {$row['fleet_id']}, 200, {$unit_id}, {$unit_count});",
1295 1295
 //              ({$row['fleet_owner']}, " . LOC_FLEET . ", {$row['fleet_id']}, " . get_unit_param($unit_id, P_UNIT_TYPE) . ", {$unit_id}, {$unit_count});",
1296 1296
             true
1297 1297
           );
@@ -1325,11 +1325,11 @@  discard block
 block discarded – undo
1325 1325
 
1326 1326
 classSupernova::$cache->unset_by_prefix('lng_');
1327 1327
 
1328
-if($new_version) {
1328
+if ($new_version) {
1329 1329
   classSupernova::$config->db_saveItem('db_version', $new_version);
1330 1330
   upd_log_message("<font color=green>DB version is now {$new_version}</font>");
1331 1331
 } else {
1332
-  upd_log_message("DB version didn't changed from " . classSupernova::$config->db_version);
1332
+  upd_log_message("DB version didn't changed from ".classSupernova::$config->db_version);
1333 1333
 }
1334 1334
 
1335 1335
 classSupernova::$config->db_loadAll();
Please login to merge, or discard this patch.
ajax_version_check.php 2 patches
Switch Indentation   +8 added lines, -8 removed lines patch added patch discarded remove patch
@@ -13,15 +13,15 @@
 block discarded – undo
13 13
   . '&id=' . urlencode(classSupernova::$config->server_updater_id);
14 14
 
15 15
 switch($mode) {
16
-  case SNC_MODE_REGISTER:
17
-    if(classSupernova::$config->server_updater_key || classSupernova::$config->server_updater_id) {
18
-      if($ajax) {
19
-        print(SNC_VER_REGISTER_ERROR_REGISTERED);
16
+    case SNC_MODE_REGISTER:
17
+      if(classSupernova::$config->server_updater_key || classSupernova::$config->server_updater_id) {
18
+        if($ajax) {
19
+          print(SNC_VER_REGISTER_ERROR_REGISTERED);
20
+        }
21
+        die();
20 22
       }
21
-      die();
22
-    }
23
-    $url .= "&name=" . urlencode(classSupernova::$config->game_name) . "&url=" . urlencode(SN_ROOT_VIRTUAL);
24
-  break;
23
+      $url .= "&name=" . urlencode(classSupernova::$config->game_name) . "&url=" . urlencode(SN_ROOT_VIRTUAL);
24
+    break;
25 25
 }
26 26
 
27 27
 $check_result = sn_get_url_contents($url);
Please login to merge, or discard this patch.
Spacing   +16 added lines, -16 removed lines patch added patch discarded remove patch
@@ -1,42 +1,42 @@  discard block
 block discarded – undo
1 1
 <?php
2 2
 
3
-require_once('includes/init.' . substr(strrchr(__FILE__, '.'), 1));
3
+require_once('includes/init.'.substr(strrchr(__FILE__, '.'), 1));
4 4
 
5 5
 $mode = sys_get_param_int('mode');
6 6
 $ajax = sys_get_param_int('ajax');
7 7
 
8
-$url = 'http://supernova.ws/version_check.php?mode=' . $mode
9
-  . '&db=' . DB_VERSION
10
-  . '&release=' . SN_RELEASE
11
-  . '&version=' . SN_VERSION
12
-  . '&key=' . urlencode(classSupernova::$config->server_updater_key)
13
-  . '&id=' . urlencode(classSupernova::$config->server_updater_id);
8
+$url = 'http://supernova.ws/version_check.php?mode='.$mode
9
+  . '&db='.DB_VERSION
10
+  . '&release='.SN_RELEASE
11
+  . '&version='.SN_VERSION
12
+  . '&key='.urlencode(classSupernova::$config->server_updater_key)
13
+  . '&id='.urlencode(classSupernova::$config->server_updater_id);
14 14
 
15
-switch($mode) {
15
+switch ($mode) {
16 16
   case SNC_MODE_REGISTER:
17
-    if(classSupernova::$config->server_updater_key || classSupernova::$config->server_updater_id) {
18
-      if($ajax) {
17
+    if (classSupernova::$config->server_updater_key || classSupernova::$config->server_updater_id) {
18
+      if ($ajax) {
19 19
         print(SNC_VER_REGISTER_ERROR_REGISTERED);
20 20
       }
21 21
       die();
22 22
     }
23
-    $url .= "&name=" . urlencode(classSupernova::$config->game_name) . "&url=" . urlencode(SN_ROOT_VIRTUAL);
23
+    $url .= "&name=".urlencode(classSupernova::$config->game_name)."&url=".urlencode(SN_ROOT_VIRTUAL);
24 24
   break;
25 25
 }
26 26
 
27 27
 $check_result = sn_get_url_contents($url);
28
-if(!$check_result) {
28
+if (!$check_result) {
29 29
   $version_check = SNC_VER_ERROR_CONNECT;
30
-} elseif(($version_check = intval($check_result)) && $version_check == $check_result) {
30
+} elseif (($version_check = intval($check_result)) && $version_check == $check_result) {
31 31
   $version_check = $check_result;
32 32
 } else {
33 33
   // JSON decode if string
34 34
   $check_result = json_decode($check_result, true);
35 35
   $version_check = $check_result === null ? SNC_VER_UNKNOWN_RESPONSE : $check_result['version_check'];
36 36
 
37
-  switch($mode) {
37
+  switch ($mode) {
38 38
     case SNC_MODE_REGISTER:
39
-      if($check_result['site']['site_key'] && $check_result['site']['site_id'] && $check_result['site']['result'] == SNC_VER_REGISTER_REGISTERED) {
39
+      if ($check_result['site']['site_key'] && $check_result['site']['site_id'] && $check_result['site']['result'] == SNC_VER_REGISTER_REGISTERED) {
40 40
         classSupernova::$config->db_saveItem('server_updater_key', $check_result['site']['site_key']);
41 41
         classSupernova::$config->db_saveItem('server_updater_id', $check_result['site']['site_id']);
42 42
       }
@@ -49,7 +49,7 @@  discard block
 block discarded – undo
49 49
 classSupernova::$config->db_saveItem('server_updater_check_last', SN_TIME_NOW);
50 50
 classSupernova::$config->db_saveItem('server_updater_check_result', $version_check);
51 51
 
52
-if($ajax) {
52
+if ($ajax) {
53 53
   define('IN_AJAX', true);
54 54
   print($version_check);
55 55
 }
Please login to merge, or discard this patch.