We could not synchronize checks via GitHub's checks API since Scrutinizer's GitHub App is not installed for this repository.
Total Complexity | 266 |
Total Lines | 1248 |
Duplicated Lines | 0 % |
Changes | 3 | ||
Bugs | 0 | Features | 1 |
Complex classes like AbstractSmrAccount often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes.
Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.
While breaking up the class, it is a good idea to analyze how other classes use AbstractSmrAccount, and based on these observations, apply Extract Interface, too.
1 | <?php declare(strict_types=1); |
||
6 | abstract class AbstractSmrAccount { |
||
7 | const USER_RANKINGS_EACH_STAT_POW = .9; |
||
8 | const USER_RANKINGS_TOTAL_SCORE_POW = .3; |
||
9 | const USER_RANKINGS_RANK_BOUNDARY = 5.2; |
||
10 | protected const USER_RANKINGS_SCORE = array( |
||
11 | // [Stat, a, b] |
||
12 | // Used as: pow(Stat * a, USER_RANKINGS_EACH_STAT_POW) * b |
||
13 | array(array('Trade', 'Experience', 'Total'), .1, 0.5), |
||
14 | array(array('Trade', 'Money', 'Profit'), 0.00005, 0.5), |
||
15 | array(array('Killing', 'Kills'), 1000, 1) |
||
16 | ); |
||
17 | |||
18 | protected static $CACHE_ACCOUNTS = array(); |
||
19 | protected const DEFAULT_HOTKEYS = array( |
||
20 | 'MoveUp' => array('w', 'up'), |
||
21 | 'ScanUp' => array('shift+w', 'shift+up'), |
||
22 | 'MoveLeft' => array('a', 'left'), |
||
23 | 'ScanLeft' => array('shift+a', 'shift+left'), |
||
24 | 'MoveRight' => array('d', 'right'), |
||
25 | 'ScanRight' => array('shift+d', 'shift+right'), |
||
26 | 'MoveDown' => array('s', 'down'), |
||
27 | 'ScanDown' => array('shift+s', 'shift+down'), |
||
28 | 'MoveWarp' => array('e', '0'), |
||
29 | 'ScanWarp' => array('shift+e', 'shift+0'), |
||
30 | 'ScanCurrent' => array('shift+1'), |
||
31 | 'CurrentSector' => array('1'), |
||
32 | 'LocalMap' => array('2'), |
||
33 | 'PlotCourse' => array('3'), |
||
34 | 'CurrentPlayers' => array('4'), |
||
35 | 'EnterPort' => array('q'), |
||
36 | 'AttackTrader' => array('f') |
||
37 | ); |
||
38 | |||
39 | protected $db; |
||
40 | |||
41 | protected $account_id; |
||
42 | protected $login; |
||
43 | protected $passwordHash; |
||
44 | protected $email; |
||
45 | protected $validated; |
||
46 | protected $validation_code; |
||
47 | protected $last_login; |
||
48 | protected $hofName; |
||
49 | protected $discordId; |
||
50 | protected $ircNick; |
||
51 | protected $veteranForced; |
||
52 | protected $logging; |
||
53 | protected $offset; |
||
54 | protected $images; |
||
55 | protected $fontSize; |
||
56 | protected $passwordReset; |
||
57 | protected $points; |
||
58 | protected $useAJAX; |
||
59 | protected $mailBanned; |
||
60 | protected $HOF; |
||
61 | protected $individualScores; |
||
62 | protected $score; |
||
63 | protected $cssLink; |
||
64 | protected $defaultCSSEnabled; |
||
65 | protected $messageNotifications; |
||
66 | protected $centerGalaxyMapOnPlayer; |
||
67 | protected $oldAccountIDs = array(); |
||
68 | protected $maxRankAchieved; |
||
69 | protected $referrerID; |
||
70 | protected $credits; // SMR credits |
||
71 | protected $rewardCredits; // SMR reward credits |
||
72 | protected $dateShort; |
||
73 | protected $timeShort; |
||
74 | protected $template; |
||
75 | protected $colourScheme; |
||
76 | protected $hotkeys = array(); |
||
77 | protected $permissions; |
||
78 | protected $friendlyColour; |
||
79 | protected $neutralColour; |
||
80 | protected $enemyColour; |
||
81 | protected $SQL; |
||
82 | |||
83 | protected $npc; |
||
84 | |||
85 | protected $hasChanged; |
||
86 | |||
87 | public static function getDefaultHotkeys() { |
||
89 | } |
||
90 | |||
91 | public static function getAccount($accountID, $forceUpdate = false) { |
||
96 | } |
||
97 | |||
98 | public static function getAccountByName($login, $forceUpdate = false) { |
||
99 | if (empty($login)) { return null; } |
||
100 | $db = new SmrMySqlDatabase(); |
||
101 | $db->query('SELECT account_id FROM account WHERE login = ' . $db->escapeString($login) . ' LIMIT 1'); |
||
102 | if ($db->nextRecord()) { |
||
103 | return self::getAccount($db->getInt('account_id'), $forceUpdate); |
||
104 | } |
||
105 | $return = null; |
||
106 | return $return; |
||
107 | } |
||
108 | |||
109 | public static function getAccountByEmail($email, $forceUpdate = false) { |
||
110 | if (empty($email)) { return null; } |
||
111 | $db = new SmrMySqlDatabase(); |
||
112 | $db->query('SELECT account_id FROM account WHERE email = ' . $db->escapeString($email) . ' LIMIT 1'); |
||
113 | if ($db->nextRecord()) { |
||
114 | return self::getAccount($db->getInt('account_id'), $forceUpdate); |
||
115 | } else { |
||
116 | return null; |
||
117 | } |
||
118 | } |
||
119 | |||
120 | public static function getAccountByDiscordId($id, $forceUpdate = false) { |
||
121 | if (empty($id)) { return null; } |
||
122 | $db = new SmrMySqlDatabase(); |
||
123 | $db->query('SELECT account_id FROM account where discord_id = ' . $db->escapeString($id) . ' LIMIT 1'); |
||
124 | if ($db->nextRecord()) { |
||
125 | return self::getAccount($db->getInt('account_id'), $forceUpdate); |
||
126 | } else { |
||
127 | return null; |
||
128 | } |
||
129 | } |
||
130 | |||
131 | public static function getAccountByIrcNick($nick, $forceUpdate = false) { |
||
132 | if (empty($nick)) { return null; } |
||
133 | $db = new SmrMySqlDatabase(); |
||
134 | $db->query('SELECT account_id FROM account WHERE irc_nick = ' . $db->escapeString($nick) . ' LIMIT 1'); |
||
135 | if ($db->nextRecord()) { |
||
136 | return self::getAccount($db->getInt('account_id'), $forceUpdate); |
||
137 | } else { |
||
138 | return null; |
||
139 | } |
||
140 | } |
||
141 | |||
142 | public static function getAccountBySocialLogin(SocialLogin $social, $forceUpdate = false) { |
||
143 | if (!$social->isValid()) { return null; } |
||
144 | $db = new SmrMySqlDatabase(); |
||
145 | $db->query('SELECT account_id FROM account JOIN account_auth USING(account_id) |
||
146 | WHERE login_type = '.$db->escapeString($social->getLoginType()) . ' |
||
147 | AND auth_key = '.$db->escapeString($social->getUserID()) . ' LIMIT 1'); |
||
148 | if ($db->nextRecord()) { |
||
149 | return self::getAccount($db->getInt('account_id'), $forceUpdate); |
||
150 | } else { |
||
151 | return null; |
||
152 | } |
||
153 | } |
||
154 | |||
155 | public static function createAccount($login, $password, $email, $timez, $referral) { |
||
156 | if ($referral != 0) { |
||
157 | // Will throw if referral account doesn't exist |
||
158 | SmrAccount::getAccount($referral); |
||
159 | } |
||
160 | $db = new SmrMySqlDatabase(); |
||
161 | $passwordHash = password_hash($password, PASSWORD_DEFAULT); |
||
162 | $db->query('INSERT INTO account (login, password, email, validation_code, last_login, offset,referral_id,hof_name) VALUES(' . |
||
163 | $db->escapeString($login) . ', ' . $db->escapeString($passwordHash) . ', ' . $db->escapeString($email) . ', ' . |
||
164 | $db->escapeString(random_string(10)) . ',' . $db->escapeNumber(TIME) . ',' . $db->escapeNumber($timez) . ',' . $db->escapeNumber($referral) . ',' . $db->escapeString($login) . ')'); |
||
165 | return self::getAccountByName($login); |
||
166 | } |
||
167 | |||
168 | public static function getUserScoreCaseStatement($db) { |
||
169 | $userRankingTypes = array(); |
||
170 | $case = 'FLOOR(SUM(CASE type '; |
||
171 | foreach (self::USER_RANKINGS_SCORE as $userRankingScore) { |
||
172 | $userRankingType = $db->escapeArray($userRankingScore[0], false, false, ':', false); |
||
173 | $userRankingTypes[] = $userRankingType; |
||
174 | $case .= ' WHEN ' . $db->escapeString($userRankingType) . ' THEN POW(amount*' . $userRankingScore[1] . ',' . SmrAccount::USER_RANKINGS_EACH_STAT_POW . ')*' . $userRankingScore[2]; |
||
175 | } |
||
176 | $case .= ' END))'; |
||
177 | return array('CASE'=>$case, 'IN'=>$db->escapeArray($userRankingTypes)); |
||
178 | } |
||
179 | |||
180 | protected function __construct($accountID) { |
||
181 | $this->db = new SmrMySqlDatabase(); |
||
182 | $this->SQL = 'account_id = ' . $this->db->escapeNumber($accountID); |
||
183 | $this->db->query('SELECT * FROM account WHERE ' . $this->SQL . ' LIMIT 1'); |
||
184 | |||
185 | if ($this->db->nextRecord()) { |
||
186 | $row = $this->db->getRow(); |
||
187 | $this->account_id = $row['account_id']; |
||
188 | |||
189 | $this->login = $row['login']; |
||
190 | $this->passwordHash = $row['password']; |
||
191 | $this->email = $row['email']; |
||
192 | $this->validated = $this->db->getBoolean('validated'); |
||
193 | |||
194 | $this->last_login = $row['last_login']; |
||
195 | $this->validation_code = $row['validation_code']; |
||
196 | $this->veteranForced = $this->db->getBoolean('veteran'); |
||
197 | $this->logging = $this->db->getBoolean('logging'); |
||
198 | $this->offset = $row['offset']; |
||
199 | $this->images = $row['images']; |
||
200 | $this->fontSize = $row['fontsize']; |
||
201 | |||
202 | $this->passwordReset = $row['password_reset']; |
||
203 | $this->useAJAX = $this->db->getBoolean('use_ajax'); |
||
204 | $this->mailBanned = (int)$row['mail_banned']; |
||
205 | |||
206 | $this->friendlyColour = $row['friendly_colour']; |
||
207 | $this->neutralColour = $row['neutral_colour']; |
||
208 | $this->enemyColour = $row['enemy_colour']; |
||
209 | |||
210 | $this->cssLink = $row['css_link']; |
||
211 | $this->defaultCSSEnabled = $this->db->getBoolean('default_css_enabled'); |
||
212 | $this->centerGalaxyMapOnPlayer = $this->db->getBoolean('center_galaxy_map_on_player'); |
||
213 | |||
214 | $this->messageNotifications = $this->db->getObject('message_notifications'); |
||
215 | $this->hotkeys = $this->db->getObject('hotkeys'); |
||
216 | foreach (self::DEFAULT_HOTKEYS as $hotkey => $binding) { |
||
217 | if (!isset($this->hotkeys[$hotkey])) { |
||
218 | $this->hotkeys[$hotkey] = $binding; |
||
219 | } |
||
220 | } |
||
221 | |||
222 | foreach (Globals::getHistoryDatabases() as $databaseName => $oldColumn) { |
||
223 | $this->oldAccountIDs[$databaseName] = $row[$oldColumn]; |
||
224 | } |
||
225 | |||
226 | $this->referrerID = $row['referral_id']; |
||
227 | $this->maxRankAchieved = $row['max_rank_achieved']; |
||
228 | |||
229 | $this->hofName = $row['hof_name']; |
||
230 | $this->discordId = $row['discord_id']; |
||
231 | $this->ircNick = $row['irc_nick']; |
||
232 | |||
233 | $this->dateShort = $row['date_short']; |
||
234 | $this->timeShort = $row['time_short']; |
||
235 | |||
236 | $this->template = $row['template']; |
||
237 | $this->colourScheme = $row['colour_scheme']; |
||
238 | |||
239 | if (empty($this->hofName)) { |
||
240 | $this->hofName = $this->login; |
||
241 | } |
||
242 | } else { |
||
243 | throw new AccountNotFoundException('Account ID ' . $accountID . ' does not exist!'); |
||
244 | } |
||
245 | } |
||
246 | |||
247 | public function isDisabled() { |
||
248 | $this->db->query('SELECT * FROM account_is_closed JOIN closing_reason USING(reason_id) ' . |
||
249 | 'WHERE ' . $this->SQL . ' LIMIT 1'); |
||
250 | if ($this->db->nextRecord()) { |
||
251 | // get the expire time |
||
252 | $expireTime = $this->db->getInt('expires'); |
||
253 | |||
254 | // are we over this time? |
||
255 | if ($expireTime > 0 && $expireTime < TIME) { |
||
256 | // get rid of the expire entry |
||
257 | $this->unbanAccount(); |
||
258 | return false; |
||
259 | } |
||
260 | return array('Time' => $expireTime, |
||
261 | 'Reason' => $this->db->getField('reason'), |
||
262 | 'ReasonID' => $this->db->getInt('reason_id') |
||
263 | ); |
||
264 | } else { |
||
265 | return false; |
||
266 | } |
||
267 | } |
||
268 | |||
269 | public function update() { |
||
270 | $this->db->query('UPDATE account SET email = ' . $this->db->escapeString($this->email) . |
||
271 | ', validation_code = ' . $this->db->escapeString($this->validation_code) . |
||
272 | ', validated = ' . $this->db->escapeBoolean($this->validated) . |
||
273 | ', password = ' . $this->db->escapeString($this->passwordHash) . |
||
274 | ', images = ' . $this->db->escapeString($this->images) . |
||
275 | ', password_reset = ' . $this->db->escapeString($this->passwordReset) . |
||
276 | ', use_ajax=' . $this->db->escapeBoolean($this->useAJAX) . |
||
277 | ', mail_banned=' . $this->db->escapeNumber($this->mailBanned) . |
||
278 | ', max_rank_achieved=' . $this->db->escapeNumber($this->maxRankAchieved) . |
||
279 | ', default_css_enabled=' . $this->db->escapeBoolean($this->defaultCSSEnabled) . |
||
280 | ', center_galaxy_map_on_player=' . $this->db->escapeBoolean($this->centerGalaxyMapOnPlayer) . |
||
281 | ', message_notifications=' . $this->db->escapeObject($this->messageNotifications) . |
||
282 | ', hotkeys=' . $this->db->escapeObject($this->hotkeys) . |
||
283 | ', last_login = ' . $this->db->escapeNumber($this->last_login) . |
||
284 | ', logging = ' . $this->db->escapeBoolean($this->logging) . |
||
285 | ', time_short = ' . $this->db->escapeString($this->timeShort) . |
||
286 | ', date_short = ' . $this->db->escapeString($this->dateShort) . |
||
287 | ', discord_id = ' . $this->db->escapeString($this->discordId, true, true) . |
||
288 | ', irc_nick = ' . $this->db->escapeString($this->ircNick, true, true) . |
||
289 | ', hof_name = ' . $this->db->escapeString($this->hofName) . |
||
290 | ', template = ' . $this->db->escapeString($this->template) . |
||
291 | ', colour_scheme = ' . $this->db->escapeString($this->colourScheme) . |
||
292 | ', fontsize = ' . $this->db->escapeNumber($this->fontSize) . |
||
293 | ', css_link = ' . $this->db->escapeString($this->cssLink, true, true) . |
||
294 | ', friendly_colour = ' . $this->db->escapeString($this->friendlyColour, true, true) . |
||
295 | ', neutral_colour = ' . $this->db->escapeString($this->neutralColour, true, true) . |
||
296 | ', enemy_colour = ' . $this->db->escapeString($this->enemyColour, true, true) . |
||
297 | ' WHERE ' . $this->SQL . ' LIMIT 1'); |
||
298 | $this->hasChanged = false; |
||
299 | } |
||
300 | |||
301 | public function updateIP() { |
||
302 | $curr_ip = getIpAddress(); |
||
303 | $this->log(LOG_TYPE_LOGIN, 'logged in from ' . $curr_ip); |
||
304 | |||
305 | // more than 50 elements in it? |
||
306 | |||
307 | $this->db->query('SELECT time,ip FROM account_has_ip WHERE ' . $this->SQL . ' ORDER BY time ASC'); |
||
308 | if ($this->db->getNumRows() > 50 && $this->db->nextRecord()) { |
||
309 | $delete_time = $this->db->getInt('time'); |
||
310 | $delete_ip = $this->db->getField('ip'); |
||
311 | |||
312 | $this->db->query('DELETE FROM account_has_ip |
||
313 | WHERE '.$this->SQL . ' AND |
||
314 | time = '.$this->db->escapeNumber($delete_time) . ' AND |
||
315 | ip = '.$this->db->escapeString($delete_ip)); |
||
316 | } |
||
317 | list($fi, $se, $th, $fo) = preg_split('/[.\s,]/', $curr_ip, 4); |
||
318 | if ($curr_ip != 'unknown' && $curr_ip != 'unknown...' && $curr_ip != 'unknown, unknown') { |
||
319 | $curr_ip = $fi . '.' . $se . '.' . $th . '.' . $fo; |
||
320 | $host = gethostbyaddr($curr_ip); |
||
321 | } else { |
||
322 | $host = 'unknown'; |
||
323 | } |
||
324 | |||
325 | // save...first make sure there isn't one for these keys (someone could double click and get error) |
||
326 | $this->db->query('REPLACE INTO account_has_ip (account_id, time, ip, host) VALUES (' . $this->db->escapeNumber($this->account_id) . ', ' . $this->db->escapeNumber(TIME) . ', ' . $this->db->escapeString($curr_ip) . ', ' . $this->db->escapeString($host) . ')'); |
||
327 | } |
||
328 | |||
329 | public function updateLastLogin() { |
||
330 | if ($this->last_login == TIME) { |
||
331 | return; |
||
332 | } |
||
333 | $this->last_login = TIME; |
||
334 | $this->hasChanged = true; |
||
335 | $this->update(); |
||
336 | } |
||
337 | |||
338 | public function getLastLogin() { |
||
339 | return $this->last_login; |
||
340 | } |
||
341 | |||
342 | public function setLoggingEnabled($bool) { |
||
343 | if ($this->logging == $bool) { |
||
344 | return; |
||
345 | } |
||
346 | $this->logging = $bool; |
||
347 | $this->hasChanged = true; |
||
348 | } |
||
349 | |||
350 | public function isLoggingEnabled() { |
||
351 | return $this->logging; |
||
352 | } |
||
353 | |||
354 | public function isVeteranForced() { |
||
355 | return $this->veteranForced; |
||
356 | } |
||
357 | |||
358 | public function isVeteran() { |
||
359 | // Use maxRankAchieved to avoid a database call to get user stats. |
||
360 | // This saves a lot of time on the CPL, Rankings, Rosters, etc. |
||
361 | return $this->isVeteranForced() || $this->maxRankAchieved >= FLEDGLING; |
||
362 | } |
||
363 | |||
364 | public function isNPC() { |
||
365 | if(!isset($this->npc)) { |
||
366 | $this->db->query('SELECT login FROM npc_logins WHERE login = '.$this->db->escapeString($this->getLogin()).' LIMIT 1;'); |
||
367 | $this->npc = $this->db->nextRecord(); |
||
368 | } |
||
369 | return $this->npc; |
||
370 | } |
||
371 | |||
372 | protected function getHOFData() { |
||
373 | if(!isset($this->HOF)) { |
||
374 | //Get Player HOF |
||
375 | $this->db->query('SELECT type,sum(amount) as amount FROM player_hof WHERE ' . $this->SQL . ' AND game_id IN (SELECT game_id FROM game WHERE ignore_stats = \'FALSE\') GROUP BY type'); |
||
376 | $this->HOF = array(); |
||
377 | while($this->db->nextRecord()) { |
||
378 | $hof =& $this->HOF; |
||
379 | $typeList = explode(':',$this->db->getField('type')); |
||
380 | foreach($typeList as $type) { |
||
381 | if(!isset($hof[$type])) { |
||
382 | $hof[$type] = array(); |
||
383 | } |
||
384 | $hof =& $hof[$type]; |
||
385 | } |
||
386 | $hof = $this->db->getFloat('amount'); |
||
387 | } |
||
388 | } |
||
389 | } |
||
390 | |||
391 | public function getHOF(array $typeList = null) { |
||
392 | $this->getHOFData(); |
||
393 | if ($typeList == null) { |
||
394 | return $this->HOF; |
||
395 | } |
||
396 | $hof = $this->HOF; |
||
397 | foreach ($typeList as $type) { |
||
398 | if (!isset($hof[$type])) { |
||
399 | return 0; |
||
400 | } |
||
401 | $hof = $hof[$type]; |
||
402 | } |
||
403 | return $hof; |
||
404 | } |
||
405 | |||
406 | public function getRankName() { |
||
407 | $rankings = Globals::getUserRanking(); |
||
408 | if (isset($rankings[$this->getRank()])) { |
||
409 | return $rankings[$this->getRank()]; |
||
410 | } else { |
||
411 | return end($rankings); |
||
412 | } |
||
413 | } |
||
414 | |||
415 | public function getScore() { |
||
416 | if (!isset($this->score)) { |
||
417 | $score = 0; |
||
418 | foreach ($this->getIndividualScores() as $each) { |
||
419 | $score += $each['Score']; |
||
420 | } |
||
421 | $this->score = round($score); |
||
422 | } |
||
423 | return $this->score; |
||
424 | } |
||
425 | |||
426 | public function getIndividualScores(SmrPlayer $player = null) { |
||
427 | $gameID = 0; |
||
428 | if ($player != null) { |
||
429 | $gameID = $player->getGameID(); |
||
430 | } |
||
431 | if (!isset($this->individualScores[$gameID])) { |
||
432 | $this->individualScores[$gameID] = array(); |
||
433 | foreach (self::USER_RANKINGS_SCORE as $statScore) { |
||
434 | if ($player == null) { |
||
435 | $stat = $this->getHOF($statScore[0]); |
||
436 | } else { |
||
437 | $stat = $player->getHOF($statScore[0]); |
||
438 | } |
||
439 | $this->individualScores[$gameID][] = array('Stat'=>$statScore[0], 'Score'=>pow($stat * $statScore[1], self::USER_RANKINGS_EACH_STAT_POW) * $statScore[2]); |
||
440 | } |
||
441 | } |
||
442 | return $this->individualScores[$gameID]; |
||
443 | } |
||
444 | |||
445 | public function getRank() : int { |
||
446 | $rank = ICeil(pow($this->getScore(), self::USER_RANKINGS_TOTAL_SCORE_POW) / self::USER_RANKINGS_RANK_BOUNDARY); |
||
447 | if ($rank < 1) { |
||
448 | $rank = 1; |
||
449 | } |
||
450 | if ($rank > $this->maxRankAchieved) { |
||
451 | $this->updateMaxRankAchieved($rank); |
||
452 | } |
||
453 | return $rank; |
||
454 | } |
||
455 | |||
456 | protected function updateMaxRankAchieved($rank) { |
||
457 | if ($rank <= $this->maxRankAchieved) { |
||
458 | throw new Exception('Trying to set max rank achieved to a lower value: ' . $rank); |
||
459 | } |
||
460 | $delta = $rank - $this->maxRankAchieved; |
||
461 | if ($this->hasReferrer()) { |
||
462 | $this->getReferrer()->increaseSmrRewardCredits($delta * CREDITS_PER_DOLLAR); |
||
463 | } |
||
464 | $this->maxRankAchieved += $delta; |
||
465 | $this->hasChanged = true; |
||
466 | $this->update(); |
||
467 | } |
||
468 | |||
469 | public function getReferrerID() { |
||
470 | return $this->referrerID; |
||
471 | } |
||
472 | |||
473 | public function hasReferrer() { |
||
474 | return $this->referrerID > 0; |
||
475 | } |
||
476 | |||
477 | public function getReferrer() { |
||
478 | return SmrAccount::getAccount($this->getReferrerID()); |
||
479 | } |
||
480 | |||
481 | public function log($log_type_id, $msg, $sector_id = 0) { |
||
482 | if ($this->isLoggingEnabled()) { |
||
483 | $this->db->query('INSERT INTO account_has_logs ' . |
||
484 | '(account_id, microtime, log_type_id, message, sector_id) ' . |
||
485 | 'VALUES(' . $this->db->escapeNumber($this->account_id) . ', ' . $this->db->escapeMicrotime(MICRO_TIME) . ', ' . $this->db->escapeNumber($log_type_id) . ', ' . $this->db->escapeString($msg) . ', ' . $this->db->escapeNumber($sector_id) . ')'); |
||
486 | } |
||
487 | } |
||
488 | |||
489 | protected function getSmrCreditsData() { |
||
490 | if (!isset($this->credits) || !isset($this->rewardCredits)) { |
||
491 | $this->credits = 0; |
||
492 | $this->rewardCredits = 0; |
||
493 | $this->db->query('SELECT * FROM account_has_credits WHERE ' . $this->SQL . ' LIMIT 1'); |
||
494 | if ($this->db->nextRecord()) { |
||
495 | $this->credits = $this->db->getInt('credits_left'); |
||
496 | $this->rewardCredits = $this->db->getInt('reward_credits'); |
||
497 | } |
||
498 | } |
||
499 | } |
||
500 | |||
501 | public function getTotalSmrCredits() { |
||
502 | return $this->getSmrCredits() + $this->getSmrRewardCredits(); |
||
503 | } |
||
504 | |||
505 | public function decreaseTotalSmrCredits($totalCredits) { |
||
506 | if ($totalCredits == 0) { |
||
507 | return; |
||
508 | } |
||
509 | if ($totalCredits < 0) { |
||
510 | throw new Exception('You cannot use negative total credits'); |
||
511 | } |
||
512 | if ($totalCredits > $this->getTotalSmrCredits()) { |
||
513 | throw new Exception('You do not have that many credits in total to use'); |
||
514 | } |
||
515 | |||
516 | $rewardCredits = $this->rewardCredits; |
||
517 | $credits = $this->credits; |
||
518 | $rewardCredits -= $totalCredits; |
||
519 | if ($rewardCredits < 0) { |
||
520 | $credits += $rewardCredits; |
||
521 | $rewardCredits = 0; |
||
522 | } |
||
523 | if ($this->credits == 0 && $this->rewardCredits == 0) { |
||
524 | $this->db->query('REPLACE INTO account_has_credits (account_id, credits_left, reward_credits) VALUES(' . $this->db->escapeNumber($this->getAccountID()) . ', ' . $this->db->escapeNumber($credits) . ',' . $this->db->escapeNumber($rewardCredits) . ')'); |
||
525 | } else { |
||
526 | $this->db->query('UPDATE account_has_credits SET credits_left=' . $this->db->escapeNumber($credits) . ', reward_credits=' . $this->db->escapeNumber($rewardCredits) . ' WHERE ' . $this->SQL . ' LIMIT 1'); |
||
527 | } |
||
528 | $this->credits = $credits; |
||
529 | $this->rewardCredits = $rewardCredits; |
||
530 | } |
||
531 | |||
532 | public function getSmrCredits() { |
||
533 | $this->getSmrCreditsData(); |
||
534 | return $this->credits; |
||
535 | } |
||
536 | |||
537 | public function getSmrRewardCredits() { |
||
538 | $this->getSmrCreditsData(); |
||
539 | return $this->rewardCredits; |
||
540 | } |
||
541 | |||
542 | public function setSmrCredits($credits) { |
||
543 | if ($this->getSmrCredits() == $credits) { |
||
544 | return; |
||
545 | } |
||
546 | if ($this->credits == 0 && $this->rewardCredits == 0) { |
||
547 | $this->db->query('REPLACE INTO account_has_credits (account_id, credits_left) VALUES(' . $this->db->escapeNumber($this->getAccountID()) . ', ' . $this->db->escapeNumber($credits) . ')'); |
||
548 | } else { |
||
549 | $this->db->query('UPDATE account_has_credits SET credits_left=' . $this->db->escapeNumber($credits) . ' WHERE ' . $this->SQL . ' LIMIT 1'); |
||
550 | } |
||
551 | $this->credits = $credits; |
||
552 | } |
||
553 | |||
554 | public function increaseSmrCredits($credits) { |
||
555 | if ($credits == 0) { |
||
556 | return; |
||
557 | } |
||
558 | if ($credits < 0) { |
||
559 | throw new Exception('You cannot gain negative credits'); |
||
560 | } |
||
561 | $this->setSmrCredits($this->getSmrCredits() + $credits); |
||
562 | } |
||
563 | |||
564 | public function decreaseSmrCredits($credits) { |
||
565 | if ($credits == 0) { |
||
566 | return; |
||
567 | } |
||
568 | if ($credits < 0) { |
||
569 | throw new Exception('You cannot use negative credits'); |
||
570 | } |
||
571 | if ($credits > $this->getSmrCredits()) { |
||
572 | throw new Exception('You cannot use more credits than you have'); |
||
573 | } |
||
574 | $this->setSmrCredits($this->getSmrCredits() - $credits); |
||
575 | } |
||
576 | |||
577 | public function setSmrRewardCredits($credits) { |
||
578 | if ($this->getSmrRewardCredits() == $credits) { |
||
579 | return; |
||
580 | } |
||
581 | if ($this->credits == 0 && $this->rewardCredits == 0) { |
||
582 | $this->db->query('REPLACE INTO account_has_credits (account_id, reward_credits) VALUES(' . $this->db->escapeNumber($this->getAccountID()) . ', ' . $this->db->escapeNumber($credits) . ')'); |
||
583 | } else { |
||
584 | $this->db->query('UPDATE account_has_credits SET reward_credits=' . $this->db->escapeNumber($credits) . ' WHERE ' . $this->SQL . ' LIMIT 1'); |
||
585 | } |
||
586 | $this->rewardCredits = $credits; |
||
587 | } |
||
588 | |||
589 | public function increaseSmrRewardCredits($credits) { |
||
590 | if ($credits == 0) { |
||
591 | return; |
||
592 | } |
||
593 | if ($credits < 0) { |
||
594 | throw new Exception('You cannot gain negative reward credits'); |
||
595 | } |
||
596 | $this->setSmrRewardCredits($this->getSmrRewardCredits() + $credits); |
||
597 | } |
||
598 | |||
599 | public function sendMessageToBox($boxTypeID, $message) { |
||
602 | } |
||
603 | |||
604 | public static function doMessageSendingToBox($senderID, $boxTypeID, $message, $gameID = 0) { |
||
605 | $db = new SmrMySqlDatabase(); |
||
606 | // send him the message |
||
607 | $db->query('INSERT INTO message_boxes |
||
608 | (box_type_id,game_id,message_text, |
||
609 | sender_id,send_time) VALUES (' . |
||
610 | $db->escapeNumber($boxTypeID) . ',' . |
||
611 | $db->escapeNumber($gameID) . ',' . |
||
612 | $db->escapeString($message) . ',' . |
||
613 | $db->escapeNumber($senderID) . ',' . |
||
614 | $db->escapeNumber(TIME) . ')' |
||
615 | ); |
||
616 | } |
||
617 | |||
618 | public function getAccountID() { |
||
619 | return $this->account_id; |
||
620 | } |
||
621 | |||
622 | public function getOldAccountIDs() { |
||
623 | return $this->oldAccountIDs; |
||
624 | } |
||
625 | |||
626 | public function getOldAccountID($dbName) { |
||
627 | return $this->oldAccountIDs[$dbName] ?? 0; |
||
628 | } |
||
629 | |||
630 | public function hasOldAccountID($dbName = false) { |
||
635 | } |
||
636 | |||
637 | public function getLogin() { |
||
638 | return $this->login; |
||
639 | } |
||
640 | |||
641 | public function getEmail() { |
||
642 | return $this->email; |
||
643 | } |
||
644 | |||
645 | protected function setEmail($email) { |
||
646 | if ($this->email == $email) { |
||
647 | return; |
||
648 | } |
||
649 | $this->email = $email; |
||
650 | $this->hasChanged = true; |
||
651 | } |
||
652 | |||
653 | /** |
||
654 | * Change e-mail address, unvalidate the account, and resend validation code |
||
655 | */ |
||
656 | public function changeEmail($email) { |
||
657 | // get user and host for the provided address |
||
658 | list($user, $host) = explode('@', $email); |
||
659 | |||
660 | // check if the host got a MX or at least an A entry |
||
661 | if (!checkdnsrr($host, 'MX') && !checkdnsrr($host, 'A')) { |
||
662 | create_error('This is not a valid email address! The domain ' . $host . ' does not exist.'); |
||
663 | } |
||
664 | |||
665 | if (strstr($email, ' ')) { |
||
666 | create_error('The email is invalid! It cannot contain any spaces.'); |
||
667 | } |
||
668 | |||
669 | $this->db->query('SELECT 1 FROM account WHERE email = ' . $this->db->escapeString($email) . ' and account_id != ' . $this->db->escapeNumber($this->getAccountID()) . ' LIMIT 1'); |
||
670 | if ($this->db->getNumRows() > 0) { |
||
671 | create_error('This email address is already registered.'); |
||
672 | } |
||
673 | |||
674 | $this->setEmail($email); |
||
675 | $this->setValidationCode(random_string(10)); |
||
676 | $this->setValidated(false); |
||
677 | $this->sendValidationEmail(); |
||
678 | |||
679 | // Remove an "Invalid email" ban (may or may not have one) |
||
680 | if ($disabled = $this->isDisabled()) { |
||
681 | if ($disabled['Reason'] == CLOSE_ACCOUNT_INVALID_EMAIL_REASON) { |
||
682 | $this->unbanAccount($this); |
||
683 | } |
||
684 | } |
||
685 | } |
||
686 | |||
687 | public function sendValidationEmail() : void { |
||
688 | // remember when we sent validation code |
||
689 | $this->db->query('REPLACE INTO notification (notification_type, account_id, time) |
||
690 | VALUES(\'validation_code\', '.$this->db->escapeNumber($this->getAccountID()) . ', ' . $this->db->escapeNumber(TIME) . ')'); |
||
691 | |||
692 | $emailMessage = |
||
693 | 'Your validation code is: ' . $this->getValidationCode() . EOL . EOL . |
||
694 | 'The Space Merchant Realms server is on the web at ' . URL; |
||
695 | |||
696 | $mail = setupMailer(); |
||
697 | $mail->Subject = 'Space Merchant Realms Validation Code'; |
||
698 | $mail->setFrom('[email protected]', 'SMR Support'); |
||
699 | $mail->msgHTML(nl2br($emailMessage)); |
||
700 | $mail->addAddress($this->getEmail(), $this->getHofName()); |
||
701 | $mail->send(); |
||
702 | } |
||
703 | |||
704 | public function getOffset() { |
||
705 | return $this->offset; |
||
706 | } |
||
707 | |||
708 | public function getFontSize() { |
||
709 | return $this->fontSize; |
||
710 | } |
||
711 | |||
712 | public function setFontSize($size) { |
||
713 | if ($this->fontSize == $size) { |
||
714 | return; |
||
715 | } |
||
716 | $this->fontSize = $size; |
||
717 | $this->hasChanged = true; |
||
718 | } |
||
719 | |||
720 | // gets the extra CSS file linked in preferences |
||
721 | public function getCssLink() { |
||
723 | } |
||
724 | |||
725 | // sets the extra CSS file linked in preferences |
||
726 | public function setCssLink($link) { |
||
727 | if ($this->cssLink == $link) { |
||
728 | return; |
||
729 | } |
||
730 | $this->cssLink = $link; |
||
731 | $this->hasChanged = true; |
||
732 | } |
||
733 | |||
734 | public function getTemplate() { |
||
735 | return $this->template; |
||
736 | } |
||
737 | |||
738 | public function setTemplate($template) { |
||
739 | if ($this->template == $template) { |
||
740 | return; |
||
741 | } |
||
742 | if (!in_array($template, Globals::getAvailableTemplates())) { |
||
743 | throw new Exception('Template not allowed: ' . $template); |
||
744 | } |
||
745 | $this->template = $template; |
||
746 | $this->hasChanged = true; |
||
747 | } |
||
748 | |||
749 | public function getColourScheme() { |
||
750 | return $this->colourScheme; |
||
751 | } |
||
752 | |||
753 | public function setColourScheme($colourScheme) { |
||
754 | if ($this->colourScheme == $colourScheme) { |
||
755 | return; |
||
756 | } |
||
757 | if (!in_array($colourScheme, Globals::getAvailableColourSchemes($this->getTemplate()))) { |
||
758 | throw new Exception('Colour scheme not allowed: ' . $colourScheme); |
||
759 | } |
||
760 | $this->colourScheme = $colourScheme; |
||
761 | $this->hasChanged = true; |
||
762 | } |
||
763 | |||
764 | // gets the CSS URL based on the template name specified in preferences |
||
765 | public function getCssUrl() { |
||
766 | return CSS_URLS[$this->getTemplate()]; |
||
767 | } |
||
768 | |||
769 | // gets the CSS_COLOUR URL based on the template and color scheme specified in preferences |
||
770 | public function getCssColourUrl() { |
||
771 | return CSS_COLOUR_URLS[$this->getTemplate()][$this->getColourScheme()]; |
||
772 | } |
||
773 | |||
774 | /** |
||
775 | * The Hall Of Fame name is not html-escaped in the database, so to display |
||
776 | * it correctly we must escape html entities. |
||
777 | */ |
||
778 | public function getHofDisplayName($linked = false) { |
||
779 | $hofDisplayName = htmlspecialchars($this->getHofName()); |
||
780 | if ($linked) { |
||
781 | return '<a href="' . $this->getPersonalHofHREF() . '">' . $hofDisplayName . '</a>'; |
||
782 | } else { |
||
783 | return $hofDisplayName; |
||
784 | } |
||
785 | } |
||
786 | |||
787 | public function getHofName() { |
||
788 | return $this->hofName; |
||
789 | } |
||
790 | |||
791 | public function setHofName($name) { |
||
792 | if ($this->hofName == $name) { |
||
793 | return; |
||
794 | } |
||
795 | $this->hofName = $name; |
||
796 | $this->hasChanged = true; |
||
797 | } |
||
798 | |||
799 | public function getIrcNick() { |
||
800 | return $this->ircNick; |
||
801 | } |
||
802 | |||
803 | public function setIrcNick($nick) { |
||
804 | if ($this->ircNick == $nick) { |
||
805 | return; |
||
806 | } |
||
807 | $this->ircNick = $nick; |
||
808 | $this->hasChanged = true; |
||
809 | } |
||
810 | |||
811 | public function getDiscordId() { |
||
812 | return $this->discordId; |
||
813 | } |
||
814 | |||
815 | public function setDiscordId($id) { |
||
816 | if ($this->discordId == $id) { |
||
817 | return; |
||
818 | } |
||
819 | $this->discordId = $id; |
||
820 | $this->hasChanged = true; |
||
821 | } |
||
822 | |||
823 | public function getReferralLink() { |
||
824 | return URL . '/login_create.php?ref=' . $this->getAccountID(); |
||
825 | } |
||
826 | |||
827 | public function getShortDateFormat() { |
||
828 | return $this->dateShort; |
||
829 | } |
||
830 | |||
831 | public function setShortDateFormat($format) { |
||
832 | if ($this->dateShort == $format) { |
||
833 | return; |
||
834 | } |
||
835 | $this->dateShort = $format; |
||
836 | $this->hasChanged = true; |
||
837 | } |
||
838 | |||
839 | public function getShortTimeFormat() { |
||
840 | return $this->timeShort; |
||
841 | } |
||
842 | |||
843 | public function setShortTimeFormat($format) { |
||
844 | if ($this->timeShort == $format) { |
||
845 | return; |
||
846 | } |
||
847 | $this->timeShort = $format; |
||
848 | $this->hasChanged = true; |
||
849 | } |
||
850 | |||
851 | public function getValidationCode() { |
||
852 | return $this->validation_code; |
||
853 | } |
||
854 | |||
855 | protected function setValidationCode($code) { |
||
856 | if ($this->validation_code == $code) { |
||
857 | return; |
||
858 | } |
||
859 | $this->validation_code = $code; |
||
860 | $this->hasChanged = true; |
||
861 | } |
||
862 | |||
863 | public function setValidated($bool) { |
||
864 | if ($this->validated == $bool) { |
||
865 | return; |
||
866 | } |
||
867 | $this->validated = $bool; |
||
868 | $this->hasChanged = true; |
||
869 | } |
||
870 | |||
871 | public function isValidated() { |
||
872 | return $this->validated; |
||
873 | } |
||
874 | |||
875 | public function isLoggedIn() { |
||
876 | $this->db->query('SELECT 1 FROM active_session WHERE account_id = ' . $this->db->escapeNumber($this->getAccountID()) . ' LIMIT 1'); |
||
877 | return $this->db->nextRecord(); |
||
878 | } |
||
879 | |||
880 | /** |
||
881 | * Check if the given (plain-text) password is correct. |
||
882 | * Updates the password hash if necessary. |
||
883 | */ |
||
884 | public function checkPassword($password) { |
||
885 | // New (safe) password hashes will start with a $, but accounts logging |
||
886 | // in for the first time since the transition from md5 will still have |
||
887 | // hex-only hashes. |
||
888 | if (strpos($this->passwordHash, '$') === 0) { |
||
889 | $result = password_verify($password, $this->passwordHash); |
||
890 | } else { |
||
891 | $result = $this->passwordHash === md5($password); |
||
892 | } |
||
893 | |||
894 | // If password is correct, but hash algorithm has changed, update the hash. |
||
895 | // This will also update any obsolete md5 password hashes. |
||
896 | if ($result && password_needs_rehash($this->passwordHash, PASSWORD_DEFAULT)) { |
||
897 | $this->setPassword($password); |
||
898 | $this->update(); |
||
899 | } |
||
900 | |||
901 | return $result; |
||
902 | } |
||
903 | |||
904 | /** |
||
905 | * Set the (plain-text) password for this account. |
||
906 | */ |
||
907 | public function setPassword($password) { |
||
908 | $hash = password_hash($password, PASSWORD_DEFAULT); |
||
909 | if ($this->passwordHash === $hash) { |
||
910 | return; |
||
911 | } |
||
912 | $this->passwordHash = $hash; |
||
913 | $this->generatePasswordReset(); |
||
914 | $this->hasChanged = true; |
||
915 | } |
||
916 | |||
917 | public function addAuthMethod($loginType, $authKey) { |
||
918 | $this->db->query('SELECT account_id FROM account_auth WHERE login_type=' . $this->db->escapeString($loginType) . ' AND auth_key = ' . $this->db->escapeString($authKey) . ';'); |
||
919 | if ($this->db->nextRecord()) { |
||
920 | if ($this->db->getInt('account_id') != $this->getAccountID()) { |
||
921 | throw new Exception('Another account already uses this form of auth.'); |
||
922 | } |
||
923 | return true; |
||
924 | } |
||
925 | $this->db->query('INSERT INTO account_auth values (' . $this->db->escapeNumber($this->getAccountID()) . ',' . $this->db->escapeString($loginType) . ',' . $this->db->escapeString($authKey) . ');'); |
||
926 | return true; |
||
927 | } |
||
928 | |||
929 | public function generatePasswordReset() { |
||
930 | $this->setPasswordReset(random_string(32)); |
||
931 | } |
||
932 | |||
933 | public function getPasswordReset() { |
||
935 | } |
||
936 | |||
937 | protected function setPasswordReset($passwordReset) { |
||
938 | if ($this->passwordReset == $passwordReset) { |
||
939 | return; |
||
940 | } |
||
941 | $this->passwordReset = $passwordReset; |
||
942 | $this->hasChanged = true; |
||
943 | } |
||
944 | |||
945 | public function isDisplayShipImages() { |
||
946 | return $this->images == 'Yes'; |
||
947 | } |
||
948 | |||
949 | public function setDisplayShipImages($yesNo) { |
||
950 | if ($this->images == $yesNo) { |
||
951 | return; |
||
952 | } |
||
953 | $this->images = $yesNo; |
||
954 | $this->hasChanged = true; |
||
955 | } |
||
956 | |||
957 | public function isUseAJAX() { |
||
958 | return $this->useAJAX; |
||
959 | } |
||
960 | |||
961 | public function setUseAJAX($bool) { |
||
962 | if ($this->useAJAX == $bool) { |
||
963 | return; |
||
964 | } |
||
965 | $this->useAJAX = $bool; |
||
966 | $this->hasChanged = true; |
||
967 | } |
||
968 | |||
969 | public function isDefaultCSSEnabled() { |
||
970 | return $this->defaultCSSEnabled; |
||
971 | } |
||
972 | |||
973 | public function setDefaultCSSEnabled($bool) { |
||
974 | if ($this->defaultCSSEnabled == $bool) { |
||
975 | return; |
||
976 | } |
||
977 | $this->defaultCSSEnabled = $bool; |
||
978 | $this->hasChanged = true; |
||
979 | } |
||
980 | |||
981 | public function getHotkeys($hotkeyType = false) { |
||
982 | if ($hotkeyType !== false) { |
||
983 | if (isset($this->hotkeys[$hotkeyType])) { |
||
984 | return $this->hotkeys[$hotkeyType]; |
||
985 | } else { |
||
986 | return array(); |
||
987 | } |
||
988 | } |
||
989 | return $this->hotkeys; |
||
990 | } |
||
991 | |||
992 | public function setHotkey($hotkeyType, $binding) { |
||
993 | if ($this->getHotkeys($hotkeyType) == $binding) { |
||
994 | return; |
||
995 | } |
||
996 | $this->hotkeys[$hotkeyType] = $binding; |
||
997 | $this->hasChanged = true; |
||
998 | } |
||
999 | |||
1000 | public function isReceivingMessageNotifications($messageTypeID) { |
||
1001 | return $this->getMessageNotifications($messageTypeID) > 0; |
||
1002 | } |
||
1003 | |||
1004 | public function getMessageNotifications($messageTypeID) { |
||
1005 | return $this->messageNotifications[$messageTypeID] ?? 0; |
||
1006 | } |
||
1007 | |||
1008 | public function setMessageNotifications($messageTypeID, $num) { |
||
1009 | if ($this->getMessageNotifications($messageTypeID) == $num) { |
||
1010 | return; |
||
1011 | } |
||
1012 | $this->messageNotifications[$messageTypeID] = $num; |
||
1013 | $this->hasChanged = true; |
||
1014 | } |
||
1015 | |||
1016 | public function increaseMessageNotifications($messageTypeID, $num) { |
||
1017 | if ($num == 0) { |
||
1018 | return; |
||
1019 | } |
||
1020 | if ($num < 0) { |
||
1021 | throw new Exception('You cannot increase by a negative amount'); |
||
1022 | } |
||
1023 | $this->setMessageNotifications($messageTypeID, $this->getMessageNotifications($messageTypeID) + $num); |
||
1024 | } |
||
1025 | |||
1026 | public function decreaseMessageNotifications($messageTypeID, $num) { |
||
1027 | if ($num == 0) { |
||
1028 | return; |
||
1029 | } |
||
1030 | if ($num < 0) { |
||
1031 | throw new Exception('You cannot decrease by a negative amount'); |
||
1032 | } |
||
1033 | $this->setMessageNotifications($messageTypeID, $this->getMessageNotifications($messageTypeID) - $num); |
||
1034 | } |
||
1035 | |||
1036 | public function isCenterGalaxyMapOnPlayer() { |
||
1037 | return $this->centerGalaxyMapOnPlayer; |
||
1038 | } |
||
1039 | |||
1040 | public function setCenterGalaxyMapOnPlayer($bool) { |
||
1046 | } |
||
1047 | |||
1048 | public function getMailBanned() { |
||
1049 | return $this->mailBanned; |
||
1050 | } |
||
1051 | |||
1052 | public function isMailBanned() { |
||
1053 | return $this->mailBanned > TIME; |
||
1054 | } |
||
1055 | |||
1056 | public function setMailBanned($time) { |
||
1057 | if ($this->mailBanned == $time) { |
||
1058 | return; |
||
1059 | } |
||
1060 | $this->mailBanned = $time; |
||
1061 | $this->hasChanged = true; |
||
1062 | } |
||
1063 | |||
1064 | public function increaseMailBanned($increaseTime) { |
||
1065 | $time = max(TIME, $this->getMailBanned()); |
||
1066 | $this->setMailBanned($time + $increaseTime); |
||
1067 | } |
||
1068 | |||
1069 | public function getPermissions() { |
||
1070 | if (!isset($this->permissions)) { |
||
1071 | $this->permissions = array(); |
||
1072 | $this->db->query('SELECT permission_id FROM account_has_permission WHERE ' . $this->SQL); |
||
1073 | while ($this->db->nextRecord()) { |
||
1074 | $this->permissions[$this->db->getInt('permission_id')] = true; |
||
1075 | } |
||
1076 | } |
||
1077 | return $this->permissions; |
||
1078 | } |
||
1079 | |||
1080 | public function hasPermission($permissionID = false) { |
||
1081 | $permissions = $this->getPermissions(); |
||
1082 | if ($permissionID === false) { |
||
1083 | return count($permissions) > 0; |
||
1084 | } |
||
1085 | return $permissions[$permissionID] ?? false; |
||
1086 | } |
||
1087 | |||
1088 | public function getPoints() { |
||
1089 | if (!isset($this->points)) { |
||
1090 | $this->points = 0; |
||
1091 | $this->db->lockTable('account_has_points'); |
||
1092 | $this->db->query('SELECT * FROM account_has_points WHERE ' . $this->SQL . ' LIMIT 1'); |
||
1093 | if ($this->db->nextRecord()) { |
||
1094 | $this->points = $this->db->getInt('points'); |
||
1095 | $lastUpdate = $this->db->getInt('last_update'); |
||
1096 | //we are gonna check for reducing points... |
||
1097 | if ($this->points > 0 && $lastUpdate < TIME - (7 * 86400)) { |
||
1098 | $removePoints = 0; |
||
1099 | while ($lastUpdate < TIME - (7 * 86400)) { |
||
1100 | $removePoints++; |
||
1101 | $lastUpdate += (7 * 86400); |
||
1102 | } |
||
1103 | $this->removePoints($removePoints, $lastUpdate); |
||
1104 | } |
||
1105 | } |
||
1106 | $this->db->unlock(); |
||
1107 | } |
||
1108 | return $this->points; |
||
1109 | } |
||
1110 | |||
1111 | public function setPoints($numPoints, $lastUpdate = false) { |
||
1112 | $numPoints = max($numPoints, 0); |
||
1113 | if ($this->getPoints() == $numPoints) { |
||
1114 | return; |
||
1115 | } |
||
1116 | if ($this->points == 0) { |
||
1117 | $this->db->query('INSERT INTO account_has_points (account_id, points, last_update) VALUES (' . $this->db->escapeNumber($this->getAccountID()) . ', ' . $this->db->escapeNumber($numPoints) . ', ' . $this->db->escapeNumber($lastUpdate ? $lastUpdate : TIME) . ')'); |
||
1118 | } elseif ($numPoints <= 0) { |
||
1119 | $this->db->query('DELETE FROM account_has_points WHERE ' . $this->SQL . ' LIMIT 1'); |
||
1120 | } else { |
||
1121 | $this->db->query('UPDATE account_has_points SET points = ' . $this->db->escapeNumber($numPoints) . ($lastUpdate ? ', last_update = ' . $this->db->escapeNumber(TIME) : '') . ' WHERE ' . $this->SQL . ' LIMIT 1'); |
||
1122 | } |
||
1123 | $this->points = $numPoints; |
||
1124 | } |
||
1125 | |||
1126 | public function removePoints($numPoints, $lastUpdate = false) { |
||
1127 | if ($numPoints > 0) { |
||
1128 | $this->setPoints($this->getPoints() - $numPoints, $lastUpdate); |
||
1129 | } |
||
1130 | } |
||
1131 | |||
1132 | public function addPoints($numPoints, SmrAccount $admin, $reasonID, $suspicion) { |
||
1168 | } |
||
1169 | |||
1170 | public function getFriendlyColour() { |
||
1171 | return $this->friendlyColour; |
||
1172 | } |
||
1173 | public function setFriendlyColour($colour) { |
||
1174 | $this->friendlyColour = $colour; |
||
1175 | $this->hasChanged = true; |
||
1176 | } |
||
1177 | public function getNeutralColour() { |
||
1178 | return $this->neutralColour; |
||
1179 | } |
||
1180 | public function setNeutralColour($colour) { |
||
1181 | $this->neutralColour = $colour; |
||
1182 | $this->hasChanged = true; |
||
1183 | } |
||
1184 | public function getEnemyColour() { |
||
1185 | return $this->enemyColour; |
||
1186 | } |
||
1187 | public function setEnemyColour($colour) { |
||
1190 | } |
||
1191 | |||
1192 | public function banAccount($expireTime, SmrAccount $admin, $reasonID, $suspicion, $removeExceptions = false) { |
||
1193 | $this->db->query('REPLACE INTO account_is_closed |
||
1219 | } |
||
1220 | } |
||
1221 | |||
1222 | public function unbanAccount(SmrAccount $admin = null, $currException = false) { |
||
1240 | } |
||
1241 | } |
||
1242 | |||
1243 | public function getToggleAJAXHREF() { |
||
1244 | global $var; |
||
1245 | return SmrSession::getNewHREF(create_container('toggle_processing.php', '', array('toggle'=>'AJAX', 'referrer'=>$var['body']))); |
||
1246 | } |
||
1247 | |||
1248 | public function getUserRankingHREF() { |
||
1249 | return SmrSession::getNewHREF(create_container('skeleton.php', 'rankings_view.php')); |
||
1250 | } |
||
1251 | |||
1252 | public function getPersonalHofHREF() { |
||
1253 | return SmrSession::getNewHREF(create_container('skeleton.php', 'hall_of_fame_player_detail.php', array('account_id' => $this->getAccountID()))); |
||
1254 | } |
||
1255 | } |
||
1256 |