public static function db_query($query, $fetch = false, $skip_lock = false) { $select = strpos(strtoupper($query), 'SELECT') !== false; $query .= $select && $fetch ? ' LIMIT 1' : ''; $query .= $select && !$skip_lock && static::db_transaction_check(false) ? ' FOR UPDATE' : ''; $result = self::$db->doquery($query, $fetch); return $result; }
public function metamatter_change($change_type, $metamatter, $comment = false, $already_changed = false) { global $debug, $mm_change_legit, $config; if (!$this->is_exists || !($metamatter = round(floatval($metamatter)))) { $debug->error('Ошибка при попытке манипуляции с ММ'); return false; } $account_id_safe = $this->db->db_escape($this->account_id); $mm_change_legit = true; // $sn_data_metamatter_db_name = pname_resource_name(RES_METAMATTER); if ($already_changed) { $metamatter_total_delta = 0; $result = -1; } else { $metamatter_total_delta = $metamatter > 0 ? $metamatter : 0; $result = $this->db->doquery("UPDATE {{account}}\n SET\n `account_metamatter` = `account_metamatter` + '{$metamatter}'" . ($metamatter_total_delta ? ", `account_immortal` = IF(`account_metamatter_total` + '{$metamatter_total_delta}' >= {$config->player_metamatter_immortal}, NOW(), `account_immortal`), `account_metamatter_total` = `account_metamatter_total` + '{$metamatter_total_delta}'" : '') . " WHERE `account_id` = {$account_id_safe}"); if (!$result) { $debug->error("Error adjusting Metamatter for player ID {$this->account_id} (Player Not Found?) with {$metamatter}. Reason: {$comment}", 'Metamatter Change', 402); } $result = classSupernova::$db->db_affected_rows(); } if (empty(core_auth::$user['id'])) { $user_list = PlayerToAccountTranslate::db_translate_get_users_from_account_list(core_auth::$main_provider->provider_id, $this->account_id); reset($user_list); $user_id_unsafe = key($user_list); } else { $user_id_unsafe = core_auth::$user['id']; } $user_id_safe = $this->db->db_escape($user_id_unsafe); if (!$result) { $debug->error("Error adjusting Metamatter for player ID {$this->account_id} (Player Not Found?) with {$metamatter}. Reason: {$comment}", 'Metamatter Change', 402); } if (!$already_changed) { $this->account_metamatter += $metamatter; $this->account_metamatter_total += $metamatter_total_delta; } if (is_array($comment)) { $comment = call_user_func_array('sprintf', $comment); } $result = $this->db_mm_log_insert($comment, $change_type, $metamatter, $user_id_unsafe); if ($metamatter > 0 && !empty($user_id_safe)) { $old_referral = doquery("SELECT * FROM {{referrals}} WHERE `id` = {$user_id_safe} LIMIT 1 FOR UPDATE;", '', true); if ($old_referral['id']) { $dark_matter_from_metamatter = $metamatter * AFFILIATE_MM_TO_REFERRAL_DM; doquery("UPDATE {{referrals}} SET dark_matter = dark_matter + '{$dark_matter_from_metamatter}' WHERE `id` = {$user_id_safe} LIMIT 1;"); $new_referral = doquery("SELECT * FROM {{referrals}} WHERE `id` = {$user_id_safe} LIMIT 1;", '', true); $partner_bonus = floor($new_referral['dark_matter'] / $config->rpg_bonus_divisor) - ($old_referral['dark_matter'] >= $config->rpg_bonus_minimum ? floor($old_referral['dark_matter'] / $config->rpg_bonus_divisor) : 0); if ($partner_bonus > 0 && $new_referral['dark_matter'] >= $config->rpg_bonus_minimum) { rpg_points_change($new_referral['id_partner'], RPG_REFERRAL_BOUGHT_MM, $partner_bonus, "Incoming MM From Referral ID {$user_id_safe}"); } } } $mm_change_legit = false; return $result; }
public function db_confirmation_get_by_type_and_code($confirmation_type_safe, $confirmation_code_unsafe) { $confirmation_code_safe = $this->db->db_escape($confirmation_code_unsafe); return $this->db->doquery("SELECT * FROM {{confirmations}} WHERE\n `type` = {$confirmation_type_safe} AND `code` = '{$confirmation_code_safe}' ORDER BY create_time DESC LIMIT 1 FOR UPDATE", true); }
public static function db_translate_unregister_user($user_id_unsafe) { static::init(); $user_id_safe = static::$db->db_escape($user_id_unsafe); return static::$db->doquery("DELETE FROM `{{account_translate}}` WHERE `user_id` = {$user_id_safe});"); }
protected function db_get_by_id($payment_id_unsafe) { $payment_id_internal_safe = $this->db->db_escape($payment_id_unsafe); $payment = $this->db->doquery("SELECT * FROM {{payment}} WHERE `payment_module_name` = '{$this->manifest['name']}' AND `payment_id` = '{$payment_id_internal_safe}' LIMIT 1 FOR UPDATE;", true); return $this->db_assign_payment($payment); }