supernova-ws / SuperNova

includes/functions/sys_user.php

<?php

use DBAL\db_mysql;
use Planet\DBStaticPlanet;

/**
 * Created by PhpStorm.
 * User: Gorlum
 * Date: 17.04.2015
 * Time: 6:37
 */

function sys_user_vacation($user) {
  global $config;

  if (sys_get_param_str('vacation') == 'leave') {
    if ($user['vacation'] < SN_TIME_NOW) {
      $user['vacation']      = 0;
      $user['vacation_next'] = SN_TIME_NOW + $config->player_vacation_timeout;
      db_user_set_by_id($user['id'], "`vacation` = {$user['vacation']}, `vacation_next` = {$user['vacation_next']}");

The function db_user_set_by_id() has been deprecated.

    }
  }

  if ($user['vacation']) {
    // sn_sys_logout(false, true);
    // core_auth::logout(false, true);

    $template = SnTemplate::gettemplate('vacation', true);

true of type true is incompatible with the type null|template expected by parameter $template of SnTemplate::gettemplate().

    $template->assign_vars(array(
      'MENU'   => false,
      'NAVBAR' => false,

      'NAME'         => $user['username'],
      'VACATION_END' => date(FMT_DATE_TIME, $user['vacation']),
      'CAN_LEAVE'    => $user['vacation'] <= SN_TIME_NOW,
      'RANDOM'       => mt_rand(1, 2),
    ));

    SnTemplate::display($template);
  }

  return false;
}

function sys_is_multiaccount($user1, $user2) {
  global $config;

  return $user1['user_lastip'] == $user2['user_lastip'] && !$config->game_multiaccount_enabled;
}

/**
 * @param        $banner
 * @param        $banned
 * @param        $term
 * @param bool   $is_vacation
 * @param string $reason
 */
function sys_admin_player_ban($banner, $banned, $term, $is_vacation = true, $reason = '') {
  $ban_current = db_user_by_id($banned['id'], false);

The function db_user_by_id() has been deprecated.

  $ban_until   = ($ban_current['banaday'] ? $ban_current['banaday'] : SN_TIME_NOW) + $term;

  db_user_set_by_id($banned['id'], "`banaday` = {$ban_until} " . ($is_vacation ? ", `vacation` = '{$ban_until}' " : ''));

The function db_user_set_by_id() has been deprecated.

  $banned['username'] = SN::$db->db_escape($banned['username']);
  $banner['username'] = SN::$db->db_escape($banner['username']);
  doquery(

The function doquery() has been deprecated.

    "INSERT INTO
      `{{banned}}`
    SET
      `ban_user_id` = '{$banned['id']}',
      `ban_user_name` = '{$banned['username']}',
      `ban_reason` = '{$reason}',
      `ban_time` = " . SN_TIME_NOW . ",
      `ban_until` = {$ban_until},
      `ban_issuer_id` = '{$banner['id']}',
      `ban_issuer_name` = '{$banner['username']}',
      `ban_issuer_email` = '{$banner['email']}'
  ");

  DBStaticPlanet::db_planet_set_by_owner($banned['id'],
    "`metal_mine_porcent` = 0, `crystal_mine_porcent` = 0, `deuterium_sintetizer_porcent` = 0, `solar_plant_porcent` = 0,
    `fusion_plant_porcent` = 0, `solar_satelit_porcent` = 0, `ship_sattelite_sloth_porcent` = 0"
  );
}

/**
 * @param        $banner
 * @param        $banned
 * @param string $reason
 */
function sys_admin_player_ban_unset($banner, $banned, $reason = '') {
  db_user_set_by_id($banned['id'], "`banaday` = 0, `vacation` = " . SN_TIME_NOW . "");

The function db_user_set_by_id() has been deprecated.

  $banned['username'] = SN::$db->db_escape($banned['username']);
  $banner['username'] = SN::$db->db_escape($banner['username']);
  $reason             = SN::$db->db_escape($reason);
  doquery(

The function doquery() has been deprecated.

    "INSERT INTO `{{banned}}`
    SET
      `ban_user_id` = '{$banned['id']}',
      `ban_user_name` = '{$banned['username']}',
      `ban_reason` = '{$reason}',
      `ban_time` = 0,
      `ban_until` = " . SN_TIME_NOW . ",
      `ban_issuer_id` = '{$banner['id']}',
      `ban_issuer_name` = '{$banner['username']}',
      `ban_issuer_email` = '{$banner['email']}'
  ");
}

/**
 * @param string $username_unsafe
 * @param string $email_unsafe
 * @param array  $options
 *   [
 *   'user_bot'                 => (int),
 *   'total_points'             => (float),
 *   'language_iso'             => (string),
 *   'options'                  => (string),
 *   'options_extra'            => (string),
 *   'salt'                     => (string),
 *   'password_encoded_unsafe'  => md5(string),
 *   'partner_id'               => (id),
 *   'galaxy'                   => (int),
 *   'system'                   => (int),
 *   'planet'                   => (int),
 *   'planet_options'           => (array),
 *   ]
 *
 * @return array|false
 */
function player_create($username_unsafe, $email_unsafe, $options) {
  db_mysql::db_transaction_check(true);

  static $player_options_string = 'opt_mnl_spy^1|opt_email_mnl_spy^0|opt_email_mnl_joueur^0|opt_email_mnl_alliance^0|opt_mnl_attaque^1|opt_email_mnl_attaque^0|opt_mnl_exploit^1|opt_email_mnl_exploit^0|opt_mnl_transport^1|opt_email_mnl_transport^0|opt_email_msg_admin^1|opt_mnl_expedition^1|opt_email_mnl_expedition^0|opt_mnl_buildlist^1|opt_email_mnl_buildlist^0|opt_int_navbar_resource_force^1|';

  empty($options['planet_options']) ? $options['planet_options'] = [] : false;

  $field_set = array(
    'server_name'   => SN_ROOT_VIRTUAL,
    'register_time' => SN_TIME_NOW,
    'news_lastread' => SN_TIME_NOW,
    'user_bot'      => $options['user_bot'] = empty($options['user_bot']) ? USER_BOT_PLAYER : $options['user_bot'],

    'username' => $username_unsafe,
    'email'    => $email_unsafe,
    'email_2'  => $email_unsafe,

    'lang' => $options['language_iso'] ? $options['language_iso'] : DEFAULT_LANG,
    'skin' => DEFAULT_SKIN_NAME,

    'total_points' => $options['total_points'] = empty($options['total_points']) ? 0 : $options['total_points'],

    'options' => (empty($options['options']) ? $player_options_string : $options['options']) . (empty($options['options_extra']) ? '' : $options['options_extra']),

    'galaxy' => $options['galaxy'] = intval($options['galaxy'] ? $options['galaxy'] : 0),
    'system' => $options['system'] = intval($options['system'] ? $options['system'] : 0),
    'planet' => $options['planet'] = intval($options['planet'] ? $options['planet'] : 0),
  );

  !empty($options['salt']) ? $field_set['salt'] = $options['salt'] : false;
  !empty($options['password_encoded_unsafe']) ? $field_set['password'] = $options['password_encoded_unsafe'] : false;
  \DBAL\DbQuery::build()->setTable('users')->setValues($field_set)->doInsert();
  $user_new = db_user_by_id(SN::$db->db_insert_id());

The function db_user_by_id() has been deprecated.

  if (!($options['galaxy'] && $options['system'] && $options['planet'])) {
    $options['galaxy'] = SN::$config->LastSettedGalaxyPos;
    $options['system'] = SN::$config->LastSettedSystemPos;
    $segment_size      = floor(SN::$config->game_maxPlanet / 3);
    $segment           = floor(SN::$config->LastSettedPlanetPos / $segment_size);
    $segment++;
    $options['planet'] = mt_rand(1 + $segment * $segment_size, ($segment + 1) * $segment_size);

    while (true) {
      if ($options['planet'] > SN::$config->game_maxPlanet) {
        $options['planet'] = mt_rand(0, $segment_size - 1) + 1;
        $options['system']++;
      }
      if ($options['system'] > SN::$config->game_maxSystem) {
        $options['system'] = 1;
        $options['galaxy']++;
      }
      $options['galaxy'] > SN::$config->game_maxGalaxy ? $options['galaxy'] = 1 : false;

      $galaxy_row = DBStaticPlanet::db_planet_by_gspt($options['galaxy'], $options['system'], $options['planet'], PT_PLANET);
      if (!$galaxy_row['id']) {
        SN::$config->db_saveItem(array(
          'LastSettedGalaxyPos' => $options['galaxy'],
          'LastSettedSystemPos' => $options['system'],
          'LastSettedPlanetPos' => $options['planet'],
        ));
        break;
      }
      $options['planet'] += 3;
    }
  }
  $new_planet_id = uni_create_planet($options['galaxy'], $options['system'], $options['planet'], $user_new['id'], '', true, $options['planet_options']);

  db_user_set_by_id($user_new['id'],

The function db_user_set_by_id() has been deprecated.

    "`id_planet` = '{$new_planet_id}', `current_planet` = '{$new_planet_id}',
    `galaxy` = '{$options['galaxy']}', `system` = '{$options['system']}', `planet` = '{$options['planet']}'"
  );

  $username_safe = SN::$db->db_escape($username_unsafe);
  doquery("REPLACE INTO `{{player_name_history}}` SET `player_id` = {$user_new['id']}, `player_name` = '{$username_safe}'");

The function doquery() has been deprecated.

  if (!empty($options['partner_id']) && ($referral_row = db_user_by_id($options['partner_id'], true))) {

The function db_user_by_id() has been deprecated.

    doquery("INSERT INTO `{{referrals}}` SET `id` = {$user_new['id']}, `id_partner` = {$options['partner_id']}");

The function doquery() has been deprecated.

  }

  sys_player_new_adjust($user_new['id'], $new_planet_id);

  dbUpdateUsersCount(SN::$config->pass()->users_amount + 1);

  return $result = db_user_by_id($user_new['id']);

The function db_user_by_id() has been deprecated.

}