DBStaticUser::getOnlineTime() - Code Metrics - Inspection of "CODE-misc-41a50.60: Streamlined db_mysql class a b..." - supernova-ws/SuperNova - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — work-fleets ( 3cd948...da4c88 )

by SuperNova.WS

created 2016-07-24 16:43 UTC

DBStaticUser::getOnlineTime() A

↳ Parent: DBStaticUser::getLastRegisteredUserName()

Complexity

Conditions	2
Paths	2

Size

Total Lines	5
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	6

Importance

Changes	2
Bugs	0	Features	0

Metric	Value
cc	2
eloc	3
nc	2
nop	1
dl	0
loc	5
rs	9.4285
c	2
b	0
f	0
ccs	0
cts	4
cp	0
crap	6

<?php

/**
 * Class DBStaticUser
 */
class DBStaticUser extends DBStaticRecord {

  public static $_table = 'users';
  public static $_idField = 'id';


  // TODO - это вообще-то надо хранить в конфигурации
  /**
   * @return string
   */
  public static function getLastRegisteredUserName() {
    $query =
      static::buildDBQ()
        ->field('username')
        ->where('`user_as_ally` IS NULL')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
        ->orderBy(array('`id` DESC'));

    return (string)static::$dbStatic->doStmtSelectValue($query);
  }

  protected static function whereNotAlly() {

  }

  /**
   * @return DbResultIterator
   */
  public static function db_player_list_export_blitz_info() {
    return static::$dbStatic->doStmtSelectIterator(
      static::buildDBQ()
        ->fields(array('id', 'username', 'total_rank', 'total_points', 'onlinetime',))
        ->where('`user_as_ally` IS NULL')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
        ->orderBy(array('`id`'))
    );
  }

  /**
   * @return DbResultIterator
   */
  public static function db_user_list_non_bots() {
//    $query = doquery("SELECT `id` FROM {{users}} WHERE `user_as_ally` IS NULL AND `user_bot` = " . USER_BOT_PLAYER . " FOR UPDATE;");

    $query =
      static::buildDBQ()
        ->field('id')
        ->where("`user_as_ally` IS NULL")
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
        ->where("`user_bot` = " . USER_BOT_PLAYER)
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
        ->setForUpdate();

    return static::$dbStatic->doStmtSelectIterator($query);
  }

  public static function db_user_lock_with_target_owner_and_acs($user, $planet = array()) {
    $query = "SELECT 1 FROM `{{users}}` WHERE `id` = " . idval($user['id']) .
      (!empty($planet['id_owner']) ? ' OR `id` = ' . idval($planet['id_owner']) : '')
    . " FOR UPDATE"
    ;

    static::$dbStatic->doquery($query);
  }

  /**
   * @param bool $online
   *
   * @return int
   */
  public static function db_user_count($online = false) {
    return intval(static::$dbStatic->doQueryFetchValue(
      'SELECT COUNT(`id`) AS `user_count` FROM `{{users}}` WHERE `user_as_ally` IS NULL' . ($online ? ' AND `onlinetime` > ' . (SN_TIME_NOW - classSupernova::$config->game_users_online_timeout) : '')
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
    ));
  }

  public static function db_user_list_admin_sorted($sort, $online = false) {
//    $query = "SELECT

//          u.*, COUNT(r.id) AS referral_count, SUM(r.dark_matter) AS referral_dm
//      FROM
//          {{users}} as u
//          LEFT JOIN
//              {{referrals}} as r on r.id_partner = u.id
//      WHERE " .
//      ($online ? "`onlinetime` >= :onlineTime" : 'user_as_ally IS NULL') .
//      " GROUP BY u.id
//        ORDER BY user_as_ally, {$sort} ASC";

    $query = static::buildDBQ()
      ->setAlias('u')
      ->field('u.*')
      ->fieldCount('r.id', 'referral_count')
      ->fieldSingleFunction('sum', 'r.dark_matter', 'referral_dm')
      ->join('LEFT JOIN {{referrals}} as r on r.id_partner = u.id')
      ->where($online ? "`onlinetime` >= " . intval(SN_TIME_NOW - classSupernova::$config->game_users_online_timeout) : 'user_as_ally IS NULL')
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
      ->groupBy('u.id')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
      ->orderBy("user_as_ally, {$sort} ASC")
    ;

    $result = static::$dbStatic->doStmtSelectIterator($query);
    return $result;
  }

  public static function db_user_list_to_celebrate($config_user_birthday_range) {
    $query = static::buildDBQ()
      ->field('id', 'username', 'user_birthday', 'user_birthday_celebrated')
      ->fieldLiteral('CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, \'-%m-%d\')) AS `current_birthday`')
      ->fieldLiteral('DATEDIFF(CURRENT_DATE, CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, \'-%m-%d\'))) AS `days_after_birthday`')
      ->where('`user_birthday` IS NOT NULL')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
      ->where('(`user_birthday_celebrated` IS NULL OR DATE_ADD(`user_birthday_celebrated`, INTERVAL 1 YEAR) < CURRENT_DATE)')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
      ->where('`user_as_ally` IS NULL')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
      ->having('`days_after_birthday` >= 0')
      ->having('`days_after_birthday` < ' . intval($config_user_birthday_range))
      ->setForUpdate()
    ;

    $result = static::$dbStatic->doStmtSelectIterator($query);
//

//    $query = "SELECT
//        `id`, `username`, `user_birthday`, `user_birthday_celebrated`,
//        CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, '-%m-%d')) AS `current_birthday`,
//        DATEDIFF(CURRENT_DATE, CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, '-%m-%d'))) AS `days_after_birthday`
//      FROM
//        `{{users}}`
//      WHERE
//        `user_birthday` IS NOT NULL
//        AND `user_as_ally` IS NULL
//        AND (`user_birthday_celebrated` IS NULL OR DATE_ADD(`user_birthday_celebrated`, INTERVAL 1 YEAR) < CURRENT_DATE)
//      HAVING
//        `days_after_birthday` >= 0 AND `days_after_birthday` < {$config_user_birthday_range} FOR UPDATE";
//
//    $result = static::$dbStatic->doQueryIterator($query);

    return $result;
  }

  /**
   * @return DbEmptyIterator|DbMysqliResultIterator
   */
  public static function db_user_list_admin_multiaccounts() {
    $query = "SELECT COUNT(*) AS `ip_count`, `user_lastip`
      FROM `{{users}}`
      WHERE `user_as_ally` IS NULL
      GROUP BY `user_lastip`
      HAVING COUNT(*) > 1";

    return static::$dbStatic->doQueryIterator($query);
  }

  public static function db_player_list_blitz_delete_players() {
    doquery("DELETE FROM `{{users}}` WHERE username LIKE 'Игрок%';");
  }

  public static function db_player_list_blitz_set_50k_dm() {
    doquery('UPDATE `{{users}}` SET dark_matter = 50000, dark_matter_total = 50000;');
  }


  /**
   * Выбирает записи игроков по списку их ID
   *
   * @param $user_id_list
   *
   * @return array
   */
  public static function db_user_list_by_id($user_id_list) {
    !is_array($user_id_list) ? $user_id_list = array($user_id_list) : false;

    $user_list = array();
    foreach ($user_id_list as $user_id_unsafe) {
      $user = DBStaticUser::db_user_by_id($user_id_unsafe);
      !empty($user) ? $user_list[$user_id_unsafe] = $user : false;
    }

    return $user_list;
  }


  public static function db_user_by_username($username_unsafe, $for_update = false, $fields = '*', $player = null, $like = false) {
    return classSupernova::db_get_user_by_username($username_unsafe, $for_update, $fields, $player, $like);
  }

  public static function db_user_list($user_filter = '', $for_update = false, $fields = '*') {

    return classSupernova::db_get_record_list(LOC_USER, $user_filter);
  }

  public static function db_user_set_by_id($user_id, $set) {
    return classSupernova::db_upd_record_by_id(LOC_USER, $user_id, $set);
  }

  public static function db_user_by_id($user_id_unsafe, $for_update = false, $fields = '*', $player = null) {
    return classSupernova::db_get_user_by_id($user_id_unsafe, $for_update, $fields, $player);
  }

  public static function db_user_list_set_mass_mail(&$owners_list, $set) {
    return classSupernova::db_upd_record_list(LOC_USER, !empty($owners_list) ? '`id` IN (' . implode(',', $owners_list) . ');' : '', $set);
  }

  public static function db_user_list_set_by_ally_and_rank($ally_id, $ally_rank_id, $set) {
    return classSupernova::db_upd_record_list(LOC_USER, "`ally_id`={$ally_id} AND `ally_rank_id` >= {$ally_rank_id}", $set);
  }

  public static function db_user_list_set_ally_deprecated_convert_ranks($ally_id, $i, $rank_id) {
    return classSupernova::db_upd_record_list(LOC_USER, "`ally_id` = {$ally_id} AND `ally_rank_id`={$rank_id}", "`ally_rank_id` = {$i}");
  }

}


1			<?php
2
3			/**
4			* Class DBStaticUser
5			*/
6			class DBStaticUser extends DBStaticRecord {
7
8			public static $_table = 'users';
9			public static $_idField = 'id';
10
11
12			// TODO - это вообще-то надо хранить в конфигурации
13			/**
14			* @return string
15			*/
16			public static function getLastRegisteredUserName() {
17			$query =
18			static::buildDBQ()
19			->field('username')
20			->where('`user_as_ally` IS NULL')
			0 ignored issues – show Documentation introduced 2016-06-11 22:02 UTC by Report Bug Copy Issue Report '`user_as_ally` IS NULL' is of type `string`, but the function expects a `array`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
21			->orderBy(array('`id` DESC'));
22
23			return (string)static::$dbStatic->doStmtSelectValue($query);
24			}
25
26			protected static function whereNotAlly() {
27
28			}
29
30			/**
31			* @return DbResultIterator
32			*/
33			public static function db_player_list_export_blitz_info() {
34			return static::$dbStatic->doStmtSelectIterator(
35			static::buildDBQ()
36			->fields(array('id', 'username', 'total_rank', 'total_points', 'onlinetime',))
37			->where('`user_as_ally` IS NULL')
			0 ignored issues – show Documentation introduced 2016-06-11 22:02 UTC by Report Bug Copy Issue Report '`user_as_ally` IS NULL' is of type `string`, but the function expects a `array`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
38			->orderBy(array('`id`'))
39			);
40			}
41
42			/**
43			* @return DbResultIterator
44			*/
45			public static function db_user_list_non_bots() {
46			// $query = doquery("SELECT `id` FROM {{users}} WHERE `user_as_ally` IS NULL AND `user_bot` = " . USER_BOT_PLAYER . " FOR UPDATE;");
47
48			$query =
49			static::buildDBQ()
50			->field('id')
51			->where("`user_as_ally` IS NULL")
			0 ignored issues – show Documentation introduced 2016-06-11 22:02 UTC by Report Bug Copy Issue Report '`user_as_ally` IS NULL' is of type `string`, but the function expects a `array`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
52			->where("`user_bot` = " . USER_BOT_PLAYER)
			0 ignored issues – show Documentation introduced 2016-06-11 22:02 UTC by Report Bug Copy Issue Report '`user_bot` = ' . USER_BOT_PLAYER is of type `string`, but the function expects a `array`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
53			->setForUpdate();
54
55			return static::$dbStatic->doStmtSelectIterator($query);
56			}
57
58			public static function db_user_lock_with_target_owner_and_acs($user, $planet = array()) {
59			$query = "SELECT 1 FROM `{{users}}` WHERE `id` = " . idval($user['id']) .
60			(!empty($planet['id_owner']) ? ' OR `id` = ' . idval($planet['id_owner']) : '')
61			. " FOR UPDATE"
62			;
63
64			static::$dbStatic->doquery($query);
65			}
66
67			/**
68			* @param bool $online
69			*
70			* @return int
71			*/
72			public static function db_user_count($online = false) {
73			return intval(static::$dbStatic->doQueryFetchValue(
74			'SELECT COUNT(`id`) AS `user_count` FROM `{{users}}` WHERE `user_as_ally` IS NULL' . ($online ? ' AND `onlinetime` > ' . (SN_TIME_NOW - classSupernova::$config->game_users_online_timeout) : '')
			0 ignored issues – show Documentation introduced 2016-07-24 16:50 UTC by Report Bug Copy Issue Report The property `game_users_online_timeout` does not exist on `object<classConfig>`. Since you implemented `__get`, maybe consider adding a @property annotation. Since your code implements the magic getter `_get`, this function will be called for any read access on an undefined variable. You can add the `@property` annotation to your class or interface to document the existence of this variable. <?php /** * @property int $x * @property int $y * @property string $text */ class MyLabel { private $properties; private $allowedProperties = array('x', 'y', 'text'); public function __get($name) { if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) { return $properties[$name]; } else { return null; } } public function __set($name, $value) { if (in_array($name, $this->allowedProperties)) { $properties[$name] = $value; } else { throw new \LogicException("Property $name is not defined."); } } } If the property has read access only, you can use the @property-read annotation instead. Of course, you may also just have mistyped another name, in which case you should fix the error. See also the PhpDoc documentation for @property. Loading history...
75			));
76			}
77
78			public static function db_user_list_admin_sorted($sort, $online = false) {
79			// $query = "SELECT
			0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-28 13:39 UTC by Report Bug Copy Issue Report `53%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
80			// u.*, COUNT(r.id) AS referral_count, SUM(r.dark_matter) AS referral_dm
81			// FROM
82			// {{users}} as u
83			// LEFT JOIN
84			// {{referrals}} as r on r.id_partner = u.id
85			// WHERE " .
86			// ($online ? "`onlinetime` >= :onlineTime" : 'user_as_ally IS NULL') .
87			// " GROUP BY u.id
88			// ORDER BY user_as_ally, {$sort} ASC";
89
90			$query = static::buildDBQ()
91			->setAlias('u')
92			->field('u.*')
93			->fieldCount('r.id', 'referral_count')
94			->fieldSingleFunction('sum', 'r.dark_matter', 'referral_dm')
95			->join('LEFT JOIN {{referrals}} as r on r.id_partner = u.id')
96			->where($online ? "`onlinetime` >= " . intval(SN_TIME_NOW - classSupernova::$config->game_users_online_timeout) : 'user_as_ally IS NULL')
			0 ignored issues – show Documentation introduced 2016-07-24 16:50 UTC by Report Bug Copy Issue Report The property `game_users_online_timeout` does not exist on `object<classConfig>`. Since you implemented `__get`, maybe consider adding a @property annotation. Since your code implements the magic getter `_get`, this function will be called for any read access on an undefined variable. You can add the `@property` annotation to your class or interface to document the existence of this variable. <?php /** * @property int $x * @property int $y * @property string $text */ class MyLabel { private $properties; private $allowedProperties = array('x', 'y', 'text'); public function __get($name) { if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) { return $properties[$name]; } else { return null; } } public function __set($name, $value) { if (in_array($name, $this->allowedProperties)) { $properties[$name] = $value; } else { throw new \LogicException("Property $name is not defined."); } } } If the property has read access only, you can use the @property-read annotation instead. Of course, you may also just have mistyped another name, in which case you should fix the error. See also the PhpDoc documentation for @property. Loading history... Documentation introduced 2016-07-24 16:50 UTC by Report Bug Copy Issue Report $online ? '`onlinetime` ... 'user_as_ally IS NULL' is of type `string`, but the function expects a `array`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
97			->groupBy('u.id')
			0 ignored issues – show Documentation introduced 2016-05-28 13:39 UTC by Report Bug Copy Issue Report `'u.id'` is of type `string`, but the function expects a `array`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
98			->orderBy("user_as_ally, {$sort} ASC")
99			;
100
101			$result = static::$dbStatic->doStmtSelectIterator($query);
102			return $result;
103			}
104
105			public static function db_user_list_to_celebrate($config_user_birthday_range) {
106			$query = static::buildDBQ()
107			->field('id', 'username', 'user_birthday', 'user_birthday_celebrated')
108			->fieldLiteral('CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, \'-%m-%d\')) AS `current_birthday`')
109			->fieldLiteral('DATEDIFF(CURRENT_DATE, CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, \'-%m-%d\'))) AS `days_after_birthday`')
110			->where('`user_birthday` IS NOT NULL')
			0 ignored issues – show Documentation introduced 2016-05-28 13:39 UTC by Report Bug Copy Issue Report '`user_birthday` IS NOT NULL' is of type `string`, but the function expects a `array`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
111			->where('(`user_birthday_celebrated` IS NULL OR DATE_ADD(`user_birthday_celebrated`, INTERVAL 1 YEAR) < CURRENT_DATE)')
			0 ignored issues – show Documentation introduced 2016-05-28 13:39 UTC by Report Bug Copy Issue Report '(`user_birthday_celebra... YEAR) < CURRENT_DATE)' is of type `string`, but the function expects a `array`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
112			->where('`user_as_ally` IS NULL')
			0 ignored issues – show Documentation introduced 2016-05-28 13:39 UTC by Report Bug Copy Issue Report '`user_as_ally` IS NULL' is of type `string`, but the function expects a `array`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
113			->having('`days_after_birthday` >= 0')
114			->having('`days_after_birthday` < ' . intval($config_user_birthday_range))
115			->setForUpdate()
116			;
117
118			$result = static::$dbStatic->doStmtSelectIterator($query);
119			//
			0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-21 21:57 UTC by Report Bug Copy Issue Report `66%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
120			// $query = "SELECT
121			// `id`, `username`, `user_birthday`, `user_birthday_celebrated`,
122			// CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, '-%m-%d')) AS `current_birthday`,
123			// DATEDIFF(CURRENT_DATE, CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, '-%m-%d'))) AS `days_after_birthday`
124			// FROM
125			// `{{users}}`
126			// WHERE
127			// `user_birthday` IS NOT NULL
128			// AND `user_as_ally` IS NULL
129			// AND (`user_birthday_celebrated` IS NULL OR DATE_ADD(`user_birthday_celebrated`, INTERVAL 1 YEAR) < CURRENT_DATE)
130			// HAVING
131			// `days_after_birthday` >= 0 AND `days_after_birthday` < {$config_user_birthday_range} FOR UPDATE";
132			//
133			// $result = static::$dbStatic->doQueryIterator($query);
134
135			return $result;
136			}
137
138			/**
139			* @return DbEmptyIterator\|DbMysqliResultIterator
140			*/
141			public static function db_user_list_admin_multiaccounts() {
142			$query = "SELECT COUNT(*) AS `ip_count`, `user_lastip`
143			FROM `{{users}}`
144			WHERE `user_as_ally` IS NULL
145			GROUP BY `user_lastip`
146			HAVING COUNT(*) > 1";
147
148			return static::$dbStatic->doQueryIterator($query);
149			}
150
151			public static function db_player_list_blitz_delete_players() {
152			doquery("DELETE FROM `{{users}}` WHERE username LIKE 'Игрок%';");
153			}
154
155			public static function db_player_list_blitz_set_50k_dm() {
156			doquery('UPDATE `{{users}}` SET dark_matter = 50000, dark_matter_total = 50000;');
157			}
158
159
160			/**
161			* Выбирает записи игроков по списку их ID
162			*
163			* @param $user_id_list
164			*
165			* @return array
166			*/
167			public static function db_user_list_by_id($user_id_list) {
168			!is_array($user_id_list) ? $user_id_list = array($user_id_list) : false;
169
170			$user_list = array();
171			foreach ($user_id_list as $user_id_unsafe) {
172			$user = DBStaticUser::db_user_by_id($user_id_unsafe);
173			!empty($user) ? $user_list[$user_id_unsafe] = $user : false;
174			}
175
176			return $user_list;
177			}
178
179
180			public static function db_user_by_username($username_unsafe, $for_update = false, $fields = '*', $player = null, $like = false) {
181			return classSupernova::db_get_user_by_username($username_unsafe, $for_update, $fields, $player, $like);
182			}
183
184			public static function db_user_list($user_filter = '', $for_update = false, $fields = '*') {
			0 ignored issues – show Unused Code introduced 2016-03-23 16:50 UTC by Report Bug Copy Issue Report The parameter `$for_update` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history... Unused Code introduced 2016-03-23 16:50 UTC by Report Bug Copy Issue Report The parameter `$fields` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
185			return classSupernova::db_get_record_list(LOC_USER, $user_filter);
186			}
187
188			public static function db_user_set_by_id($user_id, $set) {
189			return classSupernova::db_upd_record_by_id(LOC_USER, $user_id, $set);
190			}
191
192			public static function db_user_by_id($user_id_unsafe, $for_update = false, $fields = '*', $player = null) {
193			return classSupernova::db_get_user_by_id($user_id_unsafe, $for_update, $fields, $player);
194			}
195
196			public static function db_user_list_set_mass_mail(&$owners_list, $set) {
197			return classSupernova::db_upd_record_list(LOC_USER, !empty($owners_list) ? '`id` IN (' . implode(',', $owners_list) . ');' : '', $set);
198			}
199
200			public static function db_user_list_set_by_ally_and_rank($ally_id, $ally_rank_id, $set) {
201			return classSupernova::db_upd_record_list(LOC_USER, "`ally_id`={$ally_id} AND `ally_rank_id` >= {$ally_rank_id}", $set);
202			}
203
204			public static function db_user_list_set_ally_deprecated_convert_ranks($ally_id, $i, $rank_id) {
205			return classSupernova::db_upd_record_list(LOC_USER, "`ally_id` = {$ally_id} AND `ally_rank_id`={$rank_id}", "`ally_rank_id` = {$i}");
206			}
207
208			}
209

supernova-ws / SuperNova

Push — work-fleets ( 3cd948...da4c88 )

DBStaticUser::getOnlineTime() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like