We could not synchronize checks via GitHub's checks API since Scrutinizer's GitHub App is not installed for this repository.
| Total Complexity | 324 |
| Total Lines | 1767 |
| Duplicated Lines | 0 % |
| Changes | 6 | ||
| Bugs | 0 | Features | 0 |
Complex classes like SmrPlayer 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 SmrPlayer, and based on these observations, apply Extract Interface, too.
| 1 | <?php declare(strict_types=1); |
||
| 6 | class SmrPlayer extends AbstractSmrPlayer { |
||
| 7 | const TIME_FOR_FEDERAL_BOUNTY_ON_PR = 10800; |
||
| 8 | const TIME_FOR_ALLIANCE_SWITCH = 0; |
||
| 9 | protected static $CACHE_SECTOR_PLAYERS = array(); |
||
| 10 | protected static $CACHE_PLANET_PLAYERS = array(); |
||
| 11 | protected static $CACHE_ALLIANCE_PLAYERS = array(); |
||
| 12 | protected static $CACHE_PLAYERS = array(); |
||
| 13 | |||
| 14 | protected $db; |
||
| 15 | protected $SQL; |
||
| 16 | |||
| 17 | protected $newbieWarning; |
||
| 18 | protected $tickers; |
||
| 19 | protected $lastTurnUpdate; |
||
| 20 | protected $lastNewsUpdate; |
||
| 21 | protected $attackColour; |
||
| 22 | // protected $pastKnowledge; |
||
| 23 | protected $allianceJoinable; |
||
| 24 | protected $lastPort; |
||
| 25 | protected $bank; |
||
| 26 | protected $zoom; |
||
| 27 | protected $displayMissions; |
||
| 28 | protected $displayWeapons; |
||
| 29 | protected $ignoreGlobals; |
||
| 30 | protected $plottedCourse; |
||
| 31 | protected $plottedCourseFrom; |
||
| 32 | protected $nameChanged; |
||
| 33 | protected $combatDronesKamikazeOnMines; |
||
| 34 | protected $customShipName; |
||
| 35 | protected $storedDestinations; |
||
| 36 | |||
| 37 | |||
| 38 | public static function refreshCache() { |
||
| 42 | } |
||
| 43 | } |
||
| 44 | } |
||
| 45 | |||
| 46 | public static function clearCache() { |
||
| 47 | self::$CACHE_PLAYERS = array(); |
||
| 48 | self::$CACHE_SECTOR_PLAYERS = array(); |
||
| 49 | } |
||
| 50 | |||
| 51 | public static function savePlayers() { |
||
| 55 | } |
||
| 56 | } |
||
| 57 | } |
||
| 58 | |||
| 59 | public static function getSectorPlayersByAlliances($gameID, $sectorID, array $allianceIDs, $forceUpdate = false) { |
||
| 60 | $players = self::getSectorPlayers($gameID, $sectorID, $forceUpdate); // Don't use & as we do an unset |
||
| 61 | foreach ($players as $accountID => $player) { |
||
| 62 | if (!in_array($player->getAllianceID(), $allianceIDs)) { |
||
| 63 | unset($players[$accountID]); |
||
| 64 | } |
||
| 65 | } |
||
| 66 | return $players; |
||
| 67 | } |
||
| 68 | |||
| 69 | /** |
||
| 70 | * Returns the same players as getSectorPlayers (e.g. not on planets), |
||
| 71 | * but for an entire galaxy rather than a single sector. This is useful |
||
| 72 | * for reducing the number of queries in galaxy-wide processing. |
||
| 73 | */ |
||
| 74 | public static function getGalaxyPlayers($gameID, $galaxyID, $forceUpdate = false) { |
||
| 75 | $db = new SmrMySqlDatabase(); |
||
| 76 | $db->query('SELECT player.*, sector_id FROM sector LEFT JOIN player USING(game_id, sector_id) WHERE game_id = ' . $db->escapeNumber($gameID) . ' AND land_on_planet = ' . $db->escapeBoolean(false) . ' AND (last_cpl_action > ' . $db->escapeNumber(TIME - TIME_BEFORE_INACTIVE) . ' OR newbie_turns = 0) AND galaxy_id = ' . $db->escapeNumber($galaxyID)); |
||
| 77 | $galaxyPlayers = []; |
||
| 78 | while ($db->nextRecord()) { |
||
| 79 | $sectorID = $db->getInt('sector_id'); |
||
| 80 | if (!$db->hasField('account_id')) { |
||
| 81 | self::$CACHE_SECTOR_PLAYERS[$gameID][$sectorID] = []; |
||
| 82 | } else { |
||
| 83 | $accountID = $db->getInt('account_id'); |
||
| 84 | $player = self::getPlayer($accountID, $gameID, $forceUpdate, $db); |
||
| 85 | self::$CACHE_SECTOR_PLAYERS[$gameID][$sectorID][$accountID] = $player; |
||
| 86 | $galaxyPlayers[$sectorID][$accountID] = $player; |
||
| 87 | } |
||
| 88 | } |
||
| 89 | return $galaxyPlayers; |
||
| 90 | } |
||
| 91 | |||
| 92 | public static function getSectorPlayers($gameID, $sectorID, $forceUpdate = false) { |
||
| 93 | if ($forceUpdate || !isset(self::$CACHE_SECTOR_PLAYERS[$gameID][$sectorID])) { |
||
| 94 | $db = new SmrMySqlDatabase(); |
||
| 95 | $db->query('SELECT * FROM player WHERE sector_id = ' . $db->escapeNumber($sectorID) . ' AND game_id=' . $db->escapeNumber($gameID) . ' AND land_on_planet = ' . $db->escapeBoolean(false) . ' AND (last_cpl_action > ' . $db->escapeNumber(TIME - TIME_BEFORE_INACTIVE) . ' OR newbie_turns = 0) AND account_id NOT IN (' . $db->escapeArray(Globals::getHiddenPlayers()) . ') ORDER BY last_cpl_action DESC'); |
||
| 96 | $players = array(); |
||
| 97 | while ($db->nextRecord()) { |
||
| 98 | $accountID = $db->getInt('account_id'); |
||
| 99 | $players[$accountID] = self::getPlayer($accountID, $gameID, $forceUpdate, $db); |
||
| 100 | } |
||
| 101 | self::$CACHE_SECTOR_PLAYERS[$gameID][$sectorID] = $players; |
||
| 102 | } |
||
| 103 | return self::$CACHE_SECTOR_PLAYERS[$gameID][$sectorID]; |
||
| 104 | } |
||
| 105 | |||
| 106 | public static function getPlanetPlayers($gameID, $sectorID, $forceUpdate = false) { |
||
| 118 | } |
||
| 119 | |||
| 120 | public static function getAlliancePlayers($gameID, $allianceID, $forceUpdate = false) { |
||
| 132 | } |
||
| 133 | |||
| 134 | public static function getPlayer($accountID, $gameID, $forceUpdate = false, $db = null) { |
||
| 139 | } |
||
| 140 | |||
| 141 | public static function getPlayerByPlayerID($playerID, $gameID, $forceUpdate = false) { |
||
| 148 | } |
||
| 149 | |||
| 150 | public static function getPlayerByPlayerName($playerName, $gameID, $forceUpdate = false) { |
||
| 151 | $db = new SmrMySqlDatabase(); |
||
| 152 | $db->query('SELECT * FROM player WHERE game_id = ' . $db->escapeNumber($gameID) . ' AND player_name = ' . $db->escapeString($playerName) . ' LIMIT 1'); |
||
| 153 | if ($db->nextRecord()) { |
||
| 154 | return self::getPlayer($db->getInt('account_id'), $gameID, $forceUpdate, $db); |
||
| 155 | } |
||
| 156 | throw new PlayerNotFoundException('Player Name not found.'); |
||
| 157 | } |
||
| 158 | |||
| 159 | protected function __construct($gameID, $accountID, $db = null) { |
||
| 214 | } |
||
| 215 | } |
||
| 216 | |||
| 217 | /** |
||
| 218 | * Insert a new player into the database. Returns the new player object. |
||
| 219 | */ |
||
| 220 | public static function createPlayer($accountID, $gameID, $playerName, $raceID, $isNewbie, $npc=false) { |
||
| 221 | // Put the player in a sector with an HQ |
||
| 222 | $startSectorID = self::getHome($gameID, $raceID); |
||
| 223 | |||
| 224 | $db = new SmrMySqlDatabase(); |
||
| 225 | $db->lockTable('player'); |
||
| 226 | |||
| 227 | // Escape html elements so the name displays correctly |
||
| 228 | $playerName = htmlentities($playerName); |
||
| 229 | |||
| 230 | // Player names must be unique within each game |
||
| 231 | $db->query('SELECT 1 FROM player WHERE game_id = ' . $db->escapeNumber($gameID) . ' AND player_name = ' . $db->escapeString($playerName) . ' LIMIT 1'); |
||
| 232 | if ($db->nextRecord() > 0) { |
||
| 233 | $db->unlock(); |
||
| 234 | create_error('The player name already exists.'); |
||
| 235 | } |
||
| 236 | |||
| 237 | // get last registered player id in that game and increase by one. |
||
| 238 | $db->query('SELECT MAX(player_id) FROM player WHERE game_id = ' . $db->escapeNumber($gameID)); |
||
| 239 | if ($db->nextRecord()) { |
||
| 240 | $playerID = $db->getInt('MAX(player_id)') + 1; |
||
| 241 | } else { |
||
| 242 | $playerID = 1; |
||
| 243 | } |
||
| 244 | |||
| 245 | $db->query('INSERT INTO player (account_id, game_id, player_id, player_name, race_id, sector_id, last_cpl_action, last_active, npc, newbie_status) |
||
| 246 | VALUES(' . $db->escapeNumber($accountID) . ', ' . $db->escapeNumber($gameID) . ', ' . $db->escapeNumber($playerID) . ', ' . $db->escapeString($playerName) . ', ' . $db->escapeNumber($raceID) . ', ' . $db->escapeNumber($startSectorID) . ', ' . $db->escapeNumber(TIME) . ', ' . $db->escapeNumber(TIME) . ',' . $db->escapeBoolean($npc) . ',' . $db->escapeBoolean($isNewbie) . ')'); |
||
| 247 | |||
| 248 | $db->unlock(); |
||
| 249 | |||
| 250 | return SmrPlayer::getPlayer($accountID, $gameID); |
||
| 251 | } |
||
| 252 | |||
| 253 | // Get array of players whose info can be accessed by this player. |
||
| 254 | // Skips players who are not in the same alliance as this player. |
||
| 255 | public function getSharingPlayers($forceUpdate = false) { |
||
| 256 | $results = array($this); |
||
| 257 | |||
| 258 | // Only return this player if not in an alliance |
||
| 259 | if (!$this->hasAlliance()) { |
||
| 260 | return $results; |
||
| 261 | } |
||
| 262 | |||
| 263 | // Get other players who are sharing info for this game. |
||
| 264 | // NOTE: game_id=0 means that player shares info for all games. |
||
| 265 | $this->db->query('SELECT from_account_id FROM account_shares_info WHERE to_account_id=' . $this->db->escapeNumber($this->getAccountID()) . ' AND (game_id=0 OR game_id=' . $this->db->escapeNumber($this->getGameID()) . ')'); |
||
| 266 | while ($this->db->nextRecord()) { |
||
| 267 | try { |
||
| 268 | $otherPlayer = SmrPlayer::getPlayer($this->db->getInt('from_account_id'), |
||
| 269 | $this->getGameID(), $forceUpdate); |
||
| 270 | } catch (PlayerNotFoundException $e) { |
||
| 271 | // Skip players that have not joined this game |
||
| 272 | continue; |
||
| 273 | } |
||
| 274 | |||
| 275 | // players must be in the same alliance |
||
| 276 | if ($this->sameAlliance($otherPlayer)) { |
||
| 277 | $results[] = $otherPlayer; |
||
| 278 | } |
||
| 279 | } |
||
| 280 | return $results; |
||
| 281 | } |
||
| 282 | |||
| 283 | public function getShip($forceUpdate = false) { |
||
| 284 | return SmrShip::getShip($this, $forceUpdate); |
||
| 285 | } |
||
| 286 | |||
| 287 | public function getAccount() { |
||
| 288 | return SmrAccount::getAccount($this->getAccountID()); |
||
| 289 | } |
||
| 290 | |||
| 291 | public function getZoom() { |
||
| 292 | return $this->zoom; |
||
| 293 | } |
||
| 294 | |||
| 295 | protected function setZoom($zoom) { |
||
| 296 | // Set the zoom level between [1, 9] |
||
| 297 | $zoom = max(1, min(9, $zoom)); |
||
| 298 | if ($this->zoom == $zoom) { |
||
| 299 | return; |
||
| 300 | } |
||
| 301 | $this->zoom = $zoom; |
||
| 302 | $this->hasChanged = true; |
||
| 303 | // $this->db->query('UPDATE player SET zoom = ' . $zoom . ' WHERE ' . $this->SQL . ' LIMIT 1'); |
||
| 304 | } |
||
| 305 | |||
| 306 | public function increaseZoom($zoom) { |
||
| 307 | if ($zoom < 0) { |
||
| 308 | throw new Exception('Trying to increase negative zoom.'); |
||
| 309 | } |
||
| 310 | $this->setZoom($this->getZoom() + $zoom); |
||
| 311 | } |
||
| 312 | |||
| 313 | public function decreaseZoom($zoom) { |
||
| 318 | } |
||
| 319 | |||
| 320 | public function setSectorID($sectorID) { |
||
| 321 | $port = SmrPort::getPort($this->getGameID(), $this->getSectorID()); |
||
| 322 | $port->addCachePort($this->getAccountID()); //Add port of sector we were just in, to make sure it is left totally up to date. |
||
| 323 | |||
| 324 | parent::setSectorID($sectorID); |
||
| 325 | |||
| 326 | $port = SmrPort::getPort($this->getGameID(), $sectorID); |
||
| 327 | $port->addCachePort($this->getAccountID()); //Add the port of sector we are now in. |
||
| 328 | } |
||
| 329 | |||
| 330 | public function setLastSectorID($lastSectorID) { |
||
| 336 | // $this->db->query('UPDATE player SET last_sector_id = '.$this->lastSectorID.' WHERE '.$this->SQL.' LIMIT 1'); |
||
| 337 | } |
||
| 338 | |||
| 339 | public function leaveAlliance(AbstractSmrPlayer $kickedBy = null) { |
||
| 361 | } |
||
| 362 | } |
||
| 363 | |||
| 364 | /** |
||
| 365 | * Join an alliance (used for both Leader and New Member roles) |
||
| 366 | */ |
||
| 367 | public function joinAlliance($allianceID) { |
||
| 368 | $this->setAllianceID($allianceID); |
||
| 369 | $alliance = $this->getAlliance(); |
||
| 370 | |||
| 371 | if (!$this->isAllianceLeader()) { |
||
| 372 | // Do not throw an exception if the NHL account doesn't exist. |
||
| 373 | try { |
||
| 374 | $this->sendMessage($alliance->getLeaderID(), MSG_PLAYER, 'I joined your alliance!', false); |
||
| 375 | } catch (AccountNotFoundException $e) { |
||
| 376 | if ($alliance->getLeaderID() != ACCOUNT_ID_NHL) { |
||
| 377 | throw $e; |
||
| 378 | } |
||
| 379 | } |
||
| 380 | |||
| 381 | $roleID = ALLIANCE_ROLE_NEW_MEMBER; |
||
| 382 | } else { |
||
| 383 | $roleID = ALLIANCE_ROLE_LEADER; |
||
| 384 | } |
||
| 385 | $this->db->query('INSERT INTO player_has_alliance_role (game_id, account_id, role_id, alliance_id) VALUES (' . $this->db->escapeNumber($this->getGameID()) . ', ' . $this->db->escapeNumber($this->getAccountID()) . ', ' . $this->db->escapeNumber($roleID) . ',' . $this->db->escapeNumber($this->getAllianceID()) . ')'); |
||
| 386 | |||
| 387 | $this->actionTaken('JoinAlliance', array('Alliance' => $alliance)); |
||
| 388 | } |
||
| 389 | |||
| 390 | public function getAllianceJoinable() { |
||
| 391 | return $this->allianceJoinable; |
||
| 392 | } |
||
| 393 | |||
| 394 | private function setAllianceJoinable($time) { |
||
| 395 | if ($this->allianceJoinable == $time) { |
||
| 396 | return; |
||
| 397 | } |
||
| 398 | $this->allianceJoinable = $time; |
||
| 399 | $this->hasChanged = true; |
||
| 400 | } |
||
| 401 | |||
| 402 | /** |
||
| 403 | * Invites player with $accountID to this player's alliance. |
||
| 404 | */ |
||
| 405 | public function sendAllianceInvitation(int $accountID, string $message, int $expires) : void { |
||
| 406 | if (!$this->hasAlliance()) { |
||
| 407 | throw new Exception('Must be in an alliance to send alliance invitations'); |
||
| 408 | } |
||
| 409 | // Send message to invited player |
||
| 410 | $messageID = $this->sendMessage($accountID, MSG_PLAYER, $message, false, true, $expires, true); |
||
| 411 | SmrInvitation::send($this->getAllianceID(), $this->getGameID(), $accountID, $this->getAccountID(), $messageID, $expires); |
||
| 412 | } |
||
| 413 | |||
| 414 | public function getAttackColour() { |
||
| 415 | return $this->attackColour; |
||
| 416 | } |
||
| 417 | |||
| 418 | public function setAttackColour($colour) { |
||
| 419 | if ($this->attackColour == $colour) { |
||
| 420 | return; |
||
| 421 | } |
||
| 422 | $this->attackColour = $colour; |
||
| 423 | $this->hasChanged = true; |
||
| 424 | // $this->db->query('UPDATE player SET attack_warning = ' . $this->db->escapeString($this->attackColour) . ' WHERE ' . $this->SQL . ' LIMIT 1'); |
||
| 425 | } |
||
| 426 | |||
| 427 | public function getBank() { |
||
| 428 | return $this->bank; |
||
| 429 | } |
||
| 430 | |||
| 431 | public function increaseBank($credits) { |
||
| 432 | if ($credits < 0) { |
||
| 433 | throw new Exception('Trying to increase negative credits.'); |
||
| 434 | } |
||
| 435 | if ($credits == 0) { |
||
| 436 | return; |
||
| 437 | } |
||
| 438 | $credits += $this->bank; |
||
| 439 | $this->setBank($credits); |
||
| 440 | } |
||
| 441 | public function decreaseBank($credits) { |
||
| 442 | if ($credits < 0) { |
||
| 443 | throw new Exception('Trying to decrease negative credits.'); |
||
| 444 | } |
||
| 445 | if ($credits == 0) { |
||
| 446 | return; |
||
| 447 | } |
||
| 448 | $credits = $this->bank - $credits; |
||
| 449 | $this->setBank($credits); |
||
| 450 | } |
||
| 451 | public function setBank($credits) { |
||
| 452 | if ($this->bank == $credits) { |
||
| 453 | return; |
||
| 454 | } |
||
| 455 | if ($credits < 0) { |
||
| 456 | throw new Exception('Trying to set negative credits.'); |
||
| 457 | } |
||
| 458 | if ($credits > MAX_MONEY) { |
||
| 459 | throw new Exception('Trying to set more than max credits.'); |
||
| 460 | } |
||
| 461 | $this->bank = $credits; |
||
| 462 | $this->hasChanged = true; |
||
| 463 | // $this->db->query('UPDATE player SET bank = '.$this->bank.' WHERE '.$this->SQL.' LIMIT 1'); |
||
| 464 | } |
||
| 465 | |||
| 466 | public function getLastNewsUpdate() { |
||
| 467 | return $this->lastNewsUpdate; |
||
| 468 | } |
||
| 469 | |||
| 470 | private function setLastNewsUpdate($time) { |
||
| 471 | if ($this->lastNewsUpdate == $time) { |
||
| 472 | return; |
||
| 473 | } |
||
| 474 | $this->lastNewsUpdate = $time; |
||
| 475 | $this->hasChanged = true; |
||
| 476 | // $this->db->query('UPDATE player SET last_news_update = ' . $time . ' WHERE ' . $this->SQL . ' LIMIT 1'); |
||
| 477 | } |
||
| 478 | |||
| 479 | public function updateLastNewsUpdate() { |
||
| 480 | $this->setLastNewsUpdate(TIME); |
||
| 481 | } |
||
| 482 | |||
| 483 | // function getPastKnowledge() { |
||
| 484 | // return $this->pastKnowledge; |
||
| 485 | // } |
||
| 486 | |||
| 487 | /** |
||
| 488 | * Calculate the time in seconds between the given time and when the |
||
| 489 | * player will be at max turns. |
||
| 490 | */ |
||
| 491 | public function getTimeUntilMaxTurns($time, $forceUpdate = false) { |
||
| 492 | $timeDiff = $time - $this->getLastTurnUpdate(); |
||
| 493 | $turnsDiff = $this->getMaxTurns() - $this->getTurns(); |
||
| 494 | $ship = $this->getShip($forceUpdate); |
||
| 495 | $maxTurnsTime = ICeil(($turnsDiff * 3600 / $ship->getRealSpeed())) - $timeDiff; |
||
| 496 | // If already at max turns, return 0 |
||
| 497 | return max(0, $maxTurnsTime); |
||
| 498 | } |
||
| 499 | |||
| 500 | /** |
||
| 501 | * Grant the player their starting turns. |
||
| 502 | */ |
||
| 503 | public function giveStartingTurns() { |
||
| 504 | $startTurns = IFloor($this->getShip()->getRealSpeed() * $this->getGame()->getStartTurnHours()); |
||
| 505 | $this->giveTurns($startTurns); |
||
| 506 | $this->setLastTurnUpdate($this->getGame()->getStartTime()); |
||
| 507 | } |
||
| 508 | |||
| 509 | // Turns only update when player is active. |
||
| 510 | // Calculate turns gained between given time and the last turn update |
||
| 511 | public function getTurnsGained($time, $forceUpdate = false) : int { |
||
| 512 | $timeDiff = $time - $this->getLastTurnUpdate(); |
||
| 513 | $ship = $this->getShip($forceUpdate); |
||
| 514 | $extraTurns = IFloor($timeDiff * $ship->getRealSpeed() / 3600); |
||
| 515 | return $extraTurns; |
||
| 516 | } |
||
| 517 | |||
| 518 | public function updateTurns() { |
||
| 519 | // is account validated? |
||
| 520 | if (!$this->getAccount()->isValidated()) { |
||
| 521 | return; |
||
| 522 | } |
||
| 523 | |||
| 524 | // how many turns would he get right now? |
||
| 525 | $extraTurns = $this->getTurnsGained(TIME); |
||
| 526 | |||
| 527 | // do we have at least one turn to give? |
||
| 528 | if ($extraTurns > 0) { |
||
| 529 | // recalc the time to avoid rounding errors |
||
| 530 | $newLastTurnUpdate = $this->getLastTurnUpdate() + ICeil($extraTurns * 3600 / $this->getShip()->getRealSpeed()); |
||
| 531 | $this->setLastTurnUpdate($newLastTurnUpdate); |
||
| 532 | $this->giveTurns($extraTurns); |
||
| 533 | } |
||
| 534 | } |
||
| 535 | |||
| 536 | public function isIgnoreGlobals() { |
||
| 537 | return $this->ignoreGlobals; |
||
| 538 | } |
||
| 539 | |||
| 540 | public function setIgnoreGlobals($bool) { |
||
| 541 | if ($this->ignoreGlobals == $bool) { |
||
| 542 | return; |
||
| 543 | } |
||
| 544 | $this->ignoreGlobals = $bool; |
||
| 545 | $this->hasChanged = true; |
||
| 546 | // $this->db->query('UPDATE player SET ignore_globals = '.$this->db->escapeBoolean($bool).' WHERE '.$this->SQL.' LIMIT 1'); |
||
| 547 | } |
||
| 548 | |||
| 549 | |||
| 550 | public function getLastPort() { |
||
| 551 | return $this->lastPort; |
||
| 552 | } |
||
| 553 | |||
| 554 | public function setLastPort($lastPort) { |
||
| 555 | if ($this->lastPort == $lastPort) { |
||
| 556 | return; |
||
| 557 | } |
||
| 558 | $this->lastPort = $lastPort; |
||
| 559 | $this->hasChanged = true; |
||
| 560 | // $this->db->query('UPDATE player SET last_port = ' . $this->lastPort . ' WHERE ' . $this->SQL . ' LIMIT 1'); |
||
| 561 | } |
||
| 562 | |||
| 563 | public function isDisplayMissions() { |
||
| 564 | return $this->displayMissions; |
||
| 565 | } |
||
| 566 | |||
| 567 | public function setDisplayMissions($bool) { |
||
| 568 | if ($this->displayMissions == $bool) { |
||
| 569 | return; |
||
| 570 | } |
||
| 571 | $this->displayMissions = $bool; |
||
| 572 | $this->hasChanged = true; |
||
| 573 | } |
||
| 574 | |||
| 575 | public function isDisplayWeapons() { |
||
| 576 | return $this->displayWeapons; |
||
| 577 | } |
||
| 578 | |||
| 579 | /** |
||
| 580 | * Should weapons be displayed in the right panel? |
||
| 581 | * This updates the player database directly because it is used with AJAX, |
||
| 582 | * which does not acquire a sector lock. |
||
| 583 | */ |
||
| 584 | public function setDisplayWeapons($bool) { |
||
| 585 | if ($this->displayWeapons == $bool) { |
||
| 586 | return; |
||
| 587 | } |
||
| 588 | $this->displayWeapons = $bool; |
||
| 589 | $this->db->query('UPDATE player SET display_weapons=' . $this->db->escapeBoolean($this->displayWeapons) . ' WHERE ' . $this->SQL); |
||
| 590 | } |
||
| 591 | |||
| 592 | public function isForceDropMessages() { |
||
| 593 | return $this->forceDropMessages; |
||
| 594 | } |
||
| 595 | |||
| 596 | public function setForceDropMessages($bool) { |
||
| 597 | if ($this->forceDropMessages == $bool) { |
||
| 598 | return; |
||
| 599 | } |
||
| 600 | $this->forceDropMessages = $bool; |
||
| 601 | $this->hasChanged = true; |
||
| 602 | } |
||
| 603 | |||
| 604 | public function getScoutMessageGroupLimit() { |
||
| 605 | if ($this->groupScoutMessages == 'ALWAYS') { |
||
| 606 | return 0; |
||
| 607 | } elseif ($this->groupScoutMessages == 'AUTO') { |
||
| 608 | return MESSAGES_PER_PAGE; |
||
| 609 | } elseif ($this->groupScoutMessages == 'NEVER') { |
||
| 610 | return PHP_INT_MAX; |
||
| 611 | } |
||
| 612 | } |
||
| 613 | |||
| 614 | public function getGroupScoutMessages() { |
||
| 615 | return $this->groupScoutMessages; |
||
| 616 | } |
||
| 617 | |||
| 618 | public function setGroupScoutMessages($setting) { |
||
| 619 | if ($this->groupScoutMessages == $setting) { |
||
| 620 | return; |
||
| 621 | } |
||
| 622 | $this->groupScoutMessages = $setting; |
||
| 623 | $this->hasChanged = true; |
||
| 624 | } |
||
| 625 | |||
| 626 | public function getLastTurnUpdate() { |
||
| 627 | return $this->lastTurnUpdate; |
||
| 628 | } |
||
| 629 | |||
| 630 | public function setLastTurnUpdate($time) { |
||
| 631 | if ($this->lastTurnUpdate == $time) { |
||
| 632 | return; |
||
| 633 | } |
||
| 634 | $this->lastTurnUpdate = $time; |
||
| 635 | $this->hasChanged = true; |
||
| 636 | // $sql = $this->db->query('UPDATE player SET last_turn_update = ' . $this->lastTurnUpdate . ' WHERE '. $this->SQL . ' LIMIT 1'); |
||
| 637 | } |
||
| 638 | |||
| 639 | protected function getPureRelationsData() { |
||
| 640 | if (!isset($this->pureRelations)) { |
||
| 641 | //get relations |
||
| 642 | $RACES = Globals::getRaces(); |
||
| 643 | $this->pureRelations = array(); |
||
| 644 | foreach ($RACES as $raceID => $raceName) { |
||
| 645 | $this->pureRelations[$raceID] = 0; |
||
| 646 | } |
||
| 647 | $this->db->query('SELECT race_id,relation FROM player_has_relation WHERE ' . $this->SQL . ' LIMIT ' . count($RACES)); |
||
| 648 | while ($this->db->nextRecord()) { |
||
| 649 | $this->pureRelations[$this->db->getInt('race_id')] = $this->db->getInt('relation'); |
||
| 650 | } |
||
| 651 | } |
||
| 652 | } |
||
| 653 | |||
| 654 | /** |
||
| 655 | * Increases personal relations from trading $numGoods units with the race |
||
| 656 | * of the port given by $raceID. |
||
| 657 | */ |
||
| 658 | public function increaseRelationsByTrade($numGoods, $raceID) { |
||
| 659 | $relations = ICeil(min($numGoods, 300) / 30); |
||
| 660 | //Cap relations to a max of 1 after 500 have been reached |
||
| 661 | if ($this->getPureRelation($raceID) + $relations >= 500) { |
||
| 662 | $relations = max(1, min($relations, 500 - $this->getPureRelation($raceID))); |
||
| 663 | } |
||
| 664 | $this->increaseRelations($relations, $raceID); |
||
| 665 | } |
||
| 666 | |||
| 667 | public function decreaseRelationsByTrade($numGoods, $raceID) { |
||
| 668 | $relations = ICeil(min($numGoods, 300) / 30); |
||
| 669 | $this->decreaseRelations($relations, $raceID); |
||
| 670 | } |
||
| 671 | |||
| 672 | public function increaseRelations($relations, $raceID) { |
||
| 673 | if ($relations < 0) { |
||
| 674 | throw new Exception('Trying to increase negative relations.'); |
||
| 675 | } |
||
| 676 | if ($relations == 0) { |
||
| 677 | return; |
||
| 678 | } |
||
| 679 | $relations += $this->getPureRelation($raceID); |
||
| 680 | $this->setRelations($relations, $raceID); |
||
| 681 | } |
||
| 682 | public function decreaseRelations($relations, $raceID) { |
||
| 683 | if ($relations < 0) { |
||
| 684 | throw new Exception('Trying to decrease negative relations.'); |
||
| 685 | } |
||
| 686 | if ($relations == 0) { |
||
| 687 | return; |
||
| 688 | } |
||
| 689 | $relations = $this->getPureRelation($raceID) - $relations; |
||
| 690 | $this->setRelations($relations, $raceID); |
||
| 691 | } |
||
| 692 | public function setRelations($relations, $raceID) { |
||
| 693 | $this->getRelations(); |
||
| 694 | if ($this->pureRelations[$raceID] == $relations) { |
||
| 695 | return; |
||
| 696 | } |
||
| 697 | if ($relations < MIN_RELATIONS) { |
||
| 698 | $relations = MIN_RELATIONS; |
||
| 699 | } |
||
| 700 | $relationsDiff = IRound($relations - $this->pureRelations[$raceID]); |
||
| 701 | $this->pureRelations[$raceID] = $relations; |
||
| 702 | $this->relations[$raceID] += $relationsDiff; |
||
| 703 | $this->db->query('REPLACE INTO player_has_relation (account_id,game_id,race_id,relation) values (' . $this->db->escapeNumber($this->getAccountID()) . ',' . $this->db->escapeNumber($this->getGameID()) . ',' . $this->db->escapeNumber($raceID) . ',' . $this->db->escapeNumber($this->pureRelations[$raceID]) . ')'); |
||
| 704 | } |
||
| 705 | |||
| 706 | /** |
||
| 707 | * Use this method when the player is changing their own name. |
||
| 708 | * This will flag the player as having used their free name change. |
||
| 709 | */ |
||
| 710 | public function setPlayerNameByPlayer($playerName) { |
||
| 711 | $this->playerName = $playerName; |
||
| 712 | $this->setNameChanged(true); |
||
| 713 | $this->hasChanged = true; |
||
| 714 | } |
||
| 715 | |||
| 716 | public function isNameChanged() { |
||
| 717 | return $this->nameChanged; |
||
| 718 | } |
||
| 719 | |||
| 720 | public function setNameChanged($bool) { |
||
| 721 | $this->nameChanged = $bool; |
||
| 722 | $this->hasChanged = true; |
||
| 723 | } |
||
| 724 | |||
| 725 | public function hasCustomShipName() { |
||
| 726 | return $this->getCustomShipName() !== false; |
||
| 727 | } |
||
| 728 | |||
| 729 | public function getCustomShipName() { |
||
| 730 | if (!isset($this->customShipName)) { |
||
| 731 | $this->db->query('SELECT * FROM ship_has_name WHERE ' . $this->SQL . ' LIMIT 1'); |
||
| 732 | if ($this->db->nextRecord()) { |
||
| 733 | $this->customShipName = $this->db->getField('ship_name'); |
||
| 734 | } else { |
||
| 735 | $this->customShipName = false; |
||
| 736 | } |
||
| 737 | } |
||
| 738 | return $this->customShipName; |
||
| 739 | } |
||
| 740 | |||
| 741 | public function setCustomShipName(string $name) { |
||
| 742 | $this->db->query('REPLACE INTO ship_has_name (game_id, account_id, ship_name) |
||
| 743 | VALUES (' . $this->db->escapeNumber($this->getGameID()) . ', ' . $this->db->escapeNumber($this->getAccountID()) . ', ' . $this->db->escapeString($name) . ')'); |
||
| 744 | } |
||
| 745 | |||
| 746 | public function getKnowledge($knowledgeType = false) { |
||
| 747 | if (!isset($this->knowledge)) { |
||
| 748 | //get players faction knowledge |
||
| 749 | $this->db->query('SELECT * FROM player_knows_faction WHERE ' . $this->SQL . ' LIMIT 1'); |
||
| 750 | if ($this->db->nextRecord()) { |
||
| 751 | $this->knowledge['Erebus'] = $this->db->getInt('erebus'); |
||
| 752 | $this->knowledge['Aether'] = $this->db->getInt('aether'); |
||
| 753 | $this->knowledge['Tartarus'] = $this->db->getInt('tartarus'); |
||
| 754 | $this->knowledge['Nyx'] = $this->db->getInt('nyx'); |
||
| 755 | $this->knowledge['Federation'] = 0; |
||
| 756 | $this->knowledge['Underground'] = 0; |
||
| 757 | } else { |
||
| 758 | $this->knowledge['Erebus'] = 0; |
||
| 759 | $this->knowledge['Aether'] = 0; |
||
| 760 | $this->knowledge['Tartarus'] = 0; |
||
| 761 | $this->knowledge['Nyx'] = 0; |
||
| 762 | $this->knowledge['Federation'] = 0; |
||
| 763 | $this->knowledge['Underground'] = 0; |
||
| 764 | } |
||
| 765 | } |
||
| 766 | if ($knowledgeType === false) { |
||
| 767 | return $this->knowledge; |
||
| 768 | } |
||
| 769 | if (isset($this->knowledge[$knowledgeType])) { |
||
| 770 | return $this->knowledge[$knowledgeType]; |
||
| 771 | } |
||
| 772 | return false; |
||
| 773 | } |
||
| 774 | |||
| 775 | public function killPlayer($sectorID) { |
||
| 776 | $sector = SmrSector::getSector($this->getGameID(), $sectorID); |
||
| 777 | //msg taken care of in trader_att_proc.php |
||
| 778 | // forget plotted course |
||
| 779 | $this->deletePlottedCourse(); |
||
| 780 | |||
| 781 | $sector->diedHere($this); |
||
| 782 | |||
| 783 | // if we are in an alliance we increase their deaths |
||
| 784 | if ($this->hasAlliance()) { |
||
| 785 | $this->db->query('UPDATE alliance SET alliance_deaths = alliance_deaths + 1 |
||
| 786 | WHERE game_id = ' . $this->db->escapeNumber($this->getGameID()) . ' AND alliance_id = ' . $this->db->escapeNumber($this->getAllianceID()) . ' LIMIT 1'); |
||
| 787 | } |
||
| 788 | |||
| 789 | // record death stat |
||
| 790 | $this->increaseHOF(1, array('Dying', 'Deaths'), HOF_PUBLIC); |
||
| 791 | //record cost of ship lost |
||
| 792 | $this->increaseHOF($this->getShip()->getCost(), array('Dying', 'Money', 'Cost Of Ships Lost'), HOF_PUBLIC); |
||
| 793 | // reset turns since last death |
||
| 794 | $this->setHOF(0, array('Movement', 'Turns Used', 'Since Last Death'), HOF_ALLIANCE); |
||
| 795 | |||
| 796 | // 1/4 of ship value -> insurance |
||
| 797 | $newCredits = IRound($this->getShip()->getCost() / 4); |
||
| 798 | $old_speed = $this->getShip()->getSpeed(); |
||
| 799 | |||
| 800 | if ($newCredits < 100000) { |
||
| 801 | $newCredits = 100000; |
||
| 802 | } |
||
| 803 | $this->setCredits($newCredits); |
||
| 804 | |||
| 805 | $this->setSectorID($this::getHome($this->getGameID(), $this->getRaceID())); |
||
| 806 | $this->increaseDeaths(1); |
||
| 807 | $this->setLandedOnPlanet(false); |
||
| 808 | $this->setDead(true); |
||
| 809 | $this->setNewbieWarning(true); |
||
| 810 | $this->getShip()->getPod($this->hasNewbieStatus()); |
||
| 811 | |||
| 812 | // Update turns due to ship change |
||
| 813 | $new_speed = $this->getShip()->getSpeed(); |
||
| 814 | $this->setTurns(IRound($this->turns / $old_speed * $new_speed)); |
||
| 815 | $this->setNewbieTurns(100); |
||
| 816 | } |
||
| 817 | |||
| 818 | static public function getHome($gameID, $raceID) { |
||
| 819 | // get his home sector |
||
| 820 | $hq_id = GOVERNMENT + $raceID; |
||
| 821 | $raceHqSectors = SmrSector::getLocationSectors($gameID, $hq_id); |
||
| 822 | if (!empty($raceHqSectors)) { |
||
| 823 | // If race has multiple HQ's for some reason, use the first one |
||
| 824 | return key($raceHqSectors); |
||
| 825 | } else { |
||
| 826 | return 1; |
||
| 827 | } |
||
| 828 | } |
||
| 829 | |||
| 830 | public function incrementAllianceVsKills($otherID) { |
||
| 831 | $values = [$this->getGameID(), $this->getAllianceID(), $otherID, 1]; |
||
| 832 | $this->db->query('INSERT INTO alliance_vs_alliance (game_id, alliance_id_1, alliance_id_2, kills) VALUES (' . $this->db->escapeArray($values) . ') ON DUPLICATE KEY UPDATE kills = kills + 1'); |
||
| 833 | } |
||
| 834 | |||
| 835 | public function incrementAllianceVsDeaths($otherID) { |
||
| 836 | $values = [$this->getGameID(), $otherID, $this->getAllianceID(), 1]; |
||
| 837 | $this->db->query('INSERT INTO alliance_vs_alliance (game_id, alliance_id_1, alliance_id_2, kills) VALUES (' . $this->db->escapeArray($values) . ') ON DUPLICATE KEY UPDATE kills = kills + 1'); |
||
| 838 | } |
||
| 839 | |||
| 840 | public function &killPlayerByPlayer(AbstractSmrPlayer $killer) { |
||
| 841 | $return = array(); |
||
| 842 | $msg = $this->getBBLink(); |
||
| 843 | |||
| 844 | if ($this->hasCustomShipName()) { |
||
| 845 | $named_ship = strip_tags($this->getCustomShipName(), '<font><span><img>'); |
||
| 846 | $msg .= ' flying <span class="yellow">' . $named_ship . '</span>'; |
||
| 847 | } |
||
| 848 | $msg .= ' was destroyed by ' . $killer->getBBLink(); |
||
| 849 | if ($killer->hasCustomShipName()) { |
||
| 850 | $named_ship = strip_tags($killer->getCustomShipName(), '<font><span><img>'); |
||
| 851 | $msg .= ' flying <span class="yellow">' . $named_ship . '</span>'; |
||
| 852 | } |
||
| 853 | $msg .= ' in Sector ' . Globals::getSectorBBLink($this->getSectorID()); |
||
| 854 | $this->getSector()->increaseBattles(1); |
||
| 855 | $this->db->query('INSERT INTO news (game_id,time,news_message,type,killer_id,killer_alliance,dead_id,dead_alliance) VALUES (' . $this->db->escapeNumber($this->getGameID()) . ',' . $this->db->escapeNumber(TIME) . ',' . $this->db->escapeString($msg, true) . ',\'regular\',' . $this->db->escapeNumber($killer->getAccountID()) . ',' . $this->db->escapeNumber($killer->getAllianceID()) . ',' . $this->db->escapeNumber($this->getAccountID()) . ',' . $this->db->escapeNumber($this->getAllianceID()) . ')'); |
||
| 856 | |||
| 857 | self::sendMessageFromFedClerk($this->getGameID(), $this->getAccountID(), 'You were <span class="red">DESTROYED</span> by ' . $killer->getBBLink() . ' in sector ' . Globals::getSectorBBLink($this->getSectorID())); |
||
| 858 | self::sendMessageFromFedClerk($this->getGameID(), $killer->getAccountID(), 'You <span class="red">DESTROYED</span> ' . $this->getBBLink() . ' in sector ' . Globals::getSectorBBLink($this->getSectorID())); |
||
| 859 | |||
| 860 | // Dead player loses between 5% and 25% experience |
||
| 861 | $expLossPercentage = 0.15 + 0.10 * ($this->getLevelID() - $killer->getLevelID()) / $this->getMaxLevel(); |
||
| 862 | $return['DeadExp'] = max(0, IFloor($this->getExperience() * $expLossPercentage)); |
||
| 863 | $this->decreaseExperience($return['DeadExp']); |
||
| 864 | |||
| 865 | // Killer gains 50% of the lost exp |
||
| 866 | $return['KillerExp'] = max(0, ICeil(0.5 * $return['DeadExp'])); |
||
| 867 | $killer->increaseExperience($return['KillerExp']); |
||
| 868 | |||
| 869 | $return['KillerCredits'] = $this->getCredits(); |
||
| 870 | $killer->increaseCredits($return['KillerCredits']); |
||
| 871 | |||
| 872 | // The killer may change alignment |
||
| 873 | $relations = Globals::getRaceRelations($this->getGameID(), $this->getRaceID()); |
||
| 874 | $relation = $relations[$killer->getRaceID()]; |
||
| 875 | |||
| 876 | $alignChangePerRelation = 0.1; |
||
| 877 | if ($relation >= RELATIONS_PEACE || $relation <= RELATIONS_WAR) { |
||
| 878 | $alignChangePerRelation = 0.04; |
||
| 879 | } |
||
| 880 | |||
| 881 | $return['KillerAlign'] = -$relation * $alignChangePerRelation; //Lose relations when killing a peaceful race |
||
| 882 | if ($return['KillerAlign'] > 0) { |
||
| 883 | $killer->increaseAlignment($return['KillerAlign']); |
||
| 884 | } else { |
||
| 885 | $killer->decreaseAlignment(-$return['KillerAlign']); |
||
| 886 | } |
||
| 887 | // War setting gives them military pay |
||
| 888 | if ($relation <= RELATIONS_WAR) { |
||
| 889 | $killer->increaseMilitaryPayment(-IFloor($relation * 100 * pow($return['KillerExp'] / 2, 0.25))); |
||
| 890 | } |
||
| 891 | |||
| 892 | //check for federal bounty being offered for current port raiders; |
||
| 893 | $this->db->query('DELETE FROM player_attacks_port WHERE time < ' . $this->db->escapeNumber(TIME - self::TIME_FOR_FEDERAL_BOUNTY_ON_PR)); |
||
| 894 | $query = 'SELECT 1 |
||
| 895 | FROM player_attacks_port |
||
| 896 | JOIN port USING(game_id, sector_id) |
||
| 897 | JOIN player USING(game_id, account_id) |
||
| 898 | WHERE armour > 0 AND ' . $this->SQL . ' LIMIT 1'; |
||
| 899 | $this->db->query($query); |
||
| 900 | if ($this->db->nextRecord()) { |
||
| 901 | $bounty = IFloor(DEFEND_PORT_BOUNTY_PER_LEVEL * $this->getLevelID()); |
||
| 902 | $this->increaseCurrentBountyAmount('HQ', $bounty); |
||
| 903 | } |
||
| 904 | |||
| 905 | // Killer get marked as claimer of podded player's bounties even if they don't exist |
||
| 906 | $this->setBountiesClaimable($killer); |
||
| 907 | |||
| 908 | // If the alignment difference is greater than 200 then a bounty may be set |
||
| 909 | $alignmentDiff = abs($this->getAlignment() - $killer->getAlignment()); |
||
| 910 | $return['BountyGained'] = array( |
||
| 911 | 'Type' => 'None', |
||
| 912 | 'Amount' => 0 |
||
| 913 | ); |
||
| 914 | if ($alignmentDiff >= 200) { |
||
| 915 | // If the podded players alignment makes them deputy or member then set bounty |
||
| 916 | if ($this->getAlignment() >= 100) { |
||
| 917 | $return['BountyGained']['Type'] = 'HQ'; |
||
| 918 | } elseif ($this->getAlignment() <= 100) { |
||
| 919 | $return['BountyGained']['Type'] = 'UG'; |
||
| 920 | } |
||
| 921 | |||
| 922 | if ($return['BountyGained']['Type'] != 'None') { |
||
| 923 | $return['BountyGained']['Amount'] = IFloor(pow($alignmentDiff, 2.56)); |
||
| 924 | $killer->increaseCurrentBountyAmount($return['BountyGained']['Type'], $return['BountyGained']['Amount']); |
||
| 925 | } |
||
| 926 | } |
||
| 927 | |||
| 928 | if ($this->isNPC()) { |
||
| 929 | $killer->increaseHOF($return['KillerExp'], array('Killing', 'NPC', 'Experience', 'Gained'), HOF_PUBLIC); |
||
| 930 | $killer->increaseHOF($this->getExperience(), array('Killing', 'NPC', 'Experience', 'Of Traders Killed'), HOF_PUBLIC); |
||
| 931 | |||
| 932 | $killer->increaseHOF($return['DeadExp'], array('Killing', 'Experience', 'Lost By NPCs Killed'), HOF_PUBLIC); |
||
| 933 | |||
| 934 | $killer->increaseHOF($return['KillerCredits'], array('Killing', 'NPC', 'Money', 'Lost By Traders Killed'), HOF_PUBLIC); |
||
| 935 | $killer->increaseHOF($return['KillerCredits'], array('Killing', 'NPC', 'Money', 'Gain'), HOF_PUBLIC); |
||
| 936 | $killer->increaseHOF($this->getShip()->getCost(), array('Killing', 'NPC', 'Money', 'Cost Of Ships Killed'), HOF_PUBLIC); |
||
| 937 | |||
| 938 | if ($return['KillerAlign'] > 0) { |
||
| 939 | $killer->increaseHOF($return['KillerAlign'], array('Killing', 'NPC', 'Alignment', 'Gain'), HOF_PUBLIC); |
||
| 940 | } else { |
||
| 941 | $killer->increaseHOF(-$return['KillerAlign'], array('Killing', 'NPC', 'Alignment', 'Loss'), HOF_PUBLIC); |
||
| 942 | } |
||
| 943 | |||
| 944 | $killer->increaseHOF($return['BountyGained']['Amount'], array('Killing', 'NPC', 'Money', 'Bounty Gained'), HOF_PUBLIC); |
||
| 945 | |||
| 946 | $killer->increaseHOF(1, array('Killing', 'NPC Kills'), HOF_PUBLIC); |
||
| 947 | } else { |
||
| 948 | $killer->increaseHOF($return['KillerExp'], array('Killing', 'Experience', 'Gained'), HOF_PUBLIC); |
||
| 949 | $killer->increaseHOF($this->getExperience(), array('Killing', 'Experience', 'Of Traders Killed'), HOF_PUBLIC); |
||
| 950 | |||
| 951 | $killer->increaseHOF($return['DeadExp'], array('Killing', 'Experience', 'Lost By Traders Killed'), HOF_PUBLIC); |
||
| 952 | |||
| 953 | $killer->increaseHOF($return['KillerCredits'], array('Killing', 'Money', 'Lost By Traders Killed'), HOF_PUBLIC); |
||
| 954 | $killer->increaseHOF($return['KillerCredits'], array('Killing', 'Money', 'Gain'), HOF_PUBLIC); |
||
| 955 | $killer->increaseHOF($this->getShip()->getCost(), array('Killing', 'Money', 'Cost Of Ships Killed'), HOF_PUBLIC); |
||
| 956 | |||
| 957 | if ($return['KillerAlign'] > 0) { |
||
| 958 | $killer->increaseHOF($return['KillerAlign'], array('Killing', 'Alignment', 'Gain'), HOF_PUBLIC); |
||
| 959 | } else { |
||
| 960 | $killer->increaseHOF(-$return['KillerAlign'], array('Killing', 'Alignment', 'Loss'), HOF_PUBLIC); |
||
| 961 | } |
||
| 962 | |||
| 963 | $killer->increaseHOF($return['BountyGained']['Amount'], array('Killing', 'Money', 'Bounty Gained'), HOF_PUBLIC); |
||
| 964 | |||
| 965 | if ($this->getShip()->getAttackRatingWithMaxCDs() <= MAX_ATTACK_RATING_NEWBIE && $this->hasNewbieStatus() && !$killer->hasNewbieStatus()) { //Newbie kill |
||
| 966 | $killer->increaseHOF(1, array('Killing', 'Newbie Kills'), HOF_PUBLIC); |
||
| 967 | } else { |
||
| 968 | $killer->increaseKills(1); |
||
| 969 | $killer->increaseHOF(1, array('Killing', 'Kills'), HOF_PUBLIC); |
||
| 970 | |||
| 971 | if ($killer->hasAlliance()) { |
||
| 972 | $this->db->query('UPDATE alliance SET alliance_kills=alliance_kills+1 WHERE alliance_id=' . $this->db->escapeNumber($killer->getAllianceID()) . ' AND game_id=' . $this->db->escapeNumber($killer->getGameID()) . ' LIMIT 1'); |
||
| 973 | } |
||
| 974 | |||
| 975 | // alliance vs. alliance stats |
||
| 976 | $this->incrementAllianceVsDeaths($killer->getAllianceID()); |
||
| 977 | } |
||
| 978 | } |
||
| 979 | |||
| 980 | $this->increaseHOF($return['BountyGained']['Amount'], array('Dying', 'Players', 'Money', 'Bounty Gained By Killer'), HOF_PUBLIC); |
||
| 981 | $this->increaseHOF($return['KillerExp'], array('Dying', 'Players', 'Experience', 'Gained By Killer'), HOF_PUBLIC); |
||
| 982 | $this->increaseHOF($return['DeadExp'], array('Dying', 'Experience', 'Lost'), HOF_PUBLIC); |
||
| 983 | $this->increaseHOF($return['DeadExp'], array('Dying', 'Players', 'Experience', 'Lost'), HOF_PUBLIC); |
||
| 984 | $this->increaseHOF($return['KillerCredits'], array('Dying', 'Players', 'Money Lost'), HOF_PUBLIC); |
||
| 985 | $this->increaseHOF($this->getShip()->getCost(), array('Dying', 'Players', 'Money', 'Cost Of Ships Lost'), HOF_PUBLIC); |
||
| 986 | $this->increaseHOF(1, array('Dying', 'Players', 'Deaths'), HOF_PUBLIC); |
||
| 987 | |||
| 988 | $this->killPlayer($this->getSectorID()); |
||
| 989 | return $return; |
||
| 990 | } |
||
| 991 | |||
| 992 | public function &killPlayerByForces(SmrForce $forces) { |
||
| 993 | $return = array(); |
||
| 994 | $owner = $forces->getOwner(); |
||
| 995 | // send a message to the person who died |
||
| 996 | self::sendMessageFromFedClerk($this->getGameID(), $owner->getAccountID(), 'Your forces <span class="red">DESTROYED </span>' . $this->getBBLink() . ' in sector ' . Globals::getSectorBBLink($forces->getSectorID())); |
||
| 997 | self::sendMessageFromFedClerk($this->getGameID(), $this->getAccountID(), 'You were <span class="red">DESTROYED</span> by ' . $owner->getBBLink() . '\'s forces in sector ' . Globals::getSectorBBLink($this->getSectorID())); |
||
| 998 | |||
| 999 | $news_message = $this->getBBLink(); |
||
| 1000 | if ($this->hasCustomShipName()) { |
||
| 1001 | $named_ship = strip_tags($this->getCustomShipName(), '<font><span><img>'); |
||
| 1002 | $news_message .= ' flying <span class="yellow">' . $named_ship . '</span>'; |
||
| 1003 | } |
||
| 1004 | $news_message .= ' was destroyed by ' . $owner->getBBLink() . '\'s forces in sector ' . Globals::getSectorBBLink($forces->getSectorID()); |
||
| 1005 | // insert the news entry |
||
| 1006 | $this->db->query('INSERT INTO news (game_id, time, news_message,killer_id,killer_alliance,dead_id,dead_alliance) |
||
| 1007 | VALUES(' . $this->db->escapeNumber($this->getGameID()) . ', ' . $this->db->escapeNumber(TIME) . ', ' . $this->db->escapeString($news_message) . ',' . $this->db->escapeNumber($owner->getAccountID()) . ',' . $this->db->escapeNumber($owner->getAllianceID()) . ',' . $this->db->escapeNumber($this->getAccountID()) . ',' . $this->db->escapeNumber($this->getAllianceID()) . ')'); |
||
| 1008 | |||
| 1009 | // Player loses 15% experience |
||
| 1010 | $expLossPercentage = .15; |
||
| 1011 | $return['DeadExp'] = IFloor($this->getExperience() * $expLossPercentage); |
||
| 1012 | $this->decreaseExperience($return['DeadExp']); |
||
| 1013 | |||
| 1014 | $return['LostCredits'] = $this->getCredits(); |
||
| 1015 | |||
| 1016 | // alliance vs. alliance stats |
||
| 1017 | $this->incrementAllianceVsDeaths(ALLIANCE_VS_FORCES); |
||
| 1018 | $owner->incrementAllianceVsKills(ALLIANCE_VS_FORCES); |
||
| 1019 | |||
| 1020 | $this->increaseHOF($return['DeadExp'], array('Dying', 'Experience', 'Lost'), HOF_PUBLIC); |
||
| 1021 | $this->increaseHOF($return['DeadExp'], array('Dying', 'Forces', 'Experience Lost'), HOF_PUBLIC); |
||
| 1022 | $this->increaseHOF($return['LostCredits'], array('Dying', 'Forces', 'Money Lost'), HOF_PUBLIC); |
||
| 1023 | $this->increaseHOF($this->getShip()->getCost(), array('Dying', 'Forces', 'Cost Of Ships Lost'), HOF_PUBLIC); |
||
| 1024 | $this->increaseHOF(1, array('Dying', 'Forces', 'Deaths'), HOF_PUBLIC); |
||
| 1025 | |||
| 1026 | $this->killPlayer($forces->getSectorID()); |
||
| 1027 | return $return; |
||
| 1028 | } |
||
| 1029 | |||
| 1030 | public function &killPlayerByPort(SmrPort $port) { |
||
| 1031 | $return = array(); |
||
| 1032 | // send a message to the person who died |
||
| 1033 | self::sendMessageFromFedClerk($this->getGameID(), $this->getAccountID(), 'You were <span class="red">DESTROYED</span> by the defenses of ' . $port->getDisplayName()); |
||
| 1034 | |||
| 1035 | $news_message = $this->getBBLink(); |
||
| 1036 | if ($this->hasCustomShipName()) { |
||
| 1037 | $named_ship = strip_tags($this->getCustomShipName(), '<font><span><img>'); |
||
| 1038 | $news_message .= ' flying <span class="yellow">' . $named_ship . '</span>'; |
||
| 1039 | } |
||
| 1040 | $news_message .= ' was destroyed while invading ' . $port->getDisplayName() . '.'; |
||
| 1041 | // insert the news entry |
||
| 1042 | $this->db->query('INSERT INTO news (game_id, time, news_message,killer_id,dead_id,dead_alliance) |
||
| 1043 | VALUES(' . $this->db->escapeNumber($this->getGameID()) . ', ' . $this->db->escapeNumber(TIME) . ', ' . $this->db->escapeString($news_message) . ',' . $this->db->escapeNumber(ACCOUNT_ID_PORT) . ',' . $this->db->escapeNumber($this->getAccountID()) . ',' . $this->db->escapeNumber($this->getAllianceID()) . ')'); |
||
| 1044 | |||
| 1045 | // Player loses between 15% and 20% experience |
||
| 1046 | $expLossPercentage = .20 - .05 * ($port->getLevel() - 1) / ($port->getMaxLevel() - 1); |
||
| 1047 | $return['DeadExp'] = max(0, IFloor($this->getExperience() * $expLossPercentage)); |
||
| 1048 | $this->decreaseExperience($return['DeadExp']); |
||
| 1049 | |||
| 1050 | $return['LostCredits'] = $this->getCredits(); |
||
| 1051 | |||
| 1052 | // alliance vs. alliance stats |
||
| 1053 | $this->incrementAllianceVsDeaths(ALLIANCE_VS_PORTS); |
||
| 1054 | |||
| 1055 | $this->increaseHOF($return['DeadExp'], array('Dying', 'Experience', 'Lost'), HOF_PUBLIC); |
||
| 1056 | $this->increaseHOF($return['DeadExp'], array('Dying', 'Ports', 'Experience Lost'), HOF_PUBLIC); |
||
| 1057 | $this->increaseHOF($return['LostCredits'], array('Dying', 'Ports', 'Money Lost'), HOF_PUBLIC); |
||
| 1058 | $this->increaseHOF($this->getShip()->getCost(), array('Dying', 'Ports', 'Cost Of Ships Lost'), HOF_PUBLIC); |
||
| 1059 | $this->increaseHOF(1, array('Dying', 'Ports', 'Deaths'), HOF_PUBLIC); |
||
| 1060 | |||
| 1061 | $this->killPlayer($port->getSectorID()); |
||
| 1062 | return $return; |
||
| 1063 | } |
||
| 1064 | |||
| 1065 | public function &killPlayerByPlanet(SmrPlanet $planet) { |
||
| 1066 | $return = array(); |
||
| 1067 | // send a message to the person who died |
||
| 1068 | $planetOwner = $planet->getOwner(); |
||
| 1069 | self::sendMessageFromFedClerk($this->getGameID(), $planetOwner->getAccountID(), 'Your planet <span class="red">DESTROYED</span> ' . $this->getBBLink() . ' in sector ' . Globals::getSectorBBLink($planet->getSectorID())); |
||
| 1070 | self::sendMessageFromFedClerk($this->getGameID(), $this->getAccountID(), 'You were <span class="red">DESTROYED</span> by the planetary defenses of ' . $planet->getCombatName()); |
||
| 1071 | |||
| 1072 | $news_message = $this->getBBLink(); |
||
| 1073 | if ($this->hasCustomShipName()) { |
||
| 1074 | $named_ship = strip_tags($this->getCustomShipName(), '<font><span><img>'); |
||
| 1075 | $news_message .= ' flying <span class="yellow">' . $named_ship . '</span>'; |
||
| 1076 | } |
||
| 1077 | $news_message .= ' was destroyed by ' . $planet->getCombatName() . '\'s planetary defenses in sector ' . Globals::getSectorBBLink($planet->getSectorID()) . '.'; |
||
| 1078 | // insert the news entry |
||
| 1079 | $this->db->query('INSERT INTO news (game_id, time, news_message,killer_id,killer_alliance,dead_id,dead_alliance) |
||
| 1080 | VALUES(' . $this->db->escapeNumber($this->getGameID()) . ', ' . $this->db->escapeNumber(TIME) . ', ' . $this->db->escapeString($news_message) . ',' . $this->db->escapeNumber($planetOwner->getAccountID()) . ',' . $this->db->escapeNumber($planetOwner->getAllianceID()) . ',' . $this->db->escapeNumber($this->getAccountID()) . ',' . $this->db->escapeNumber($this->getAllianceID()) . ')'); |
||
| 1081 | |||
| 1082 | // Player loses between 15% and 20% experience |
||
| 1083 | $expLossPercentage = .20 - .05 * $planet->getLevel() / $planet->getMaxLevel(); |
||
| 1084 | $return['DeadExp'] = max(0, IFloor($this->getExperience() * $expLossPercentage)); |
||
| 1085 | $this->decreaseExperience($return['DeadExp']); |
||
| 1086 | |||
| 1087 | $return['LostCredits'] = $this->getCredits(); |
||
| 1088 | |||
| 1089 | // alliance vs. alliance stats |
||
| 1090 | $this->incrementAllianceVsDeaths(ALLIANCE_VS_PLANETS); |
||
| 1091 | $planetOwner->incrementAllianceVsKills(ALLIANCE_VS_PLANETS); |
||
| 1092 | |||
| 1093 | $this->increaseHOF($return['DeadExp'], array('Dying', 'Experience', 'Lost'), HOF_PUBLIC); |
||
| 1094 | $this->increaseHOF($return['DeadExp'], array('Dying', 'Planets', 'Experience Lost'), HOF_PUBLIC); |
||
| 1095 | $this->increaseHOF($return['LostCredits'], array('Dying', 'Planets', 'Money Lost'), HOF_PUBLIC); |
||
| 1096 | $this->increaseHOF($this->getShip()->getCost(), array('Dying', 'Planets', 'Cost Of Ships Lost'), HOF_PUBLIC); |
||
| 1097 | $this->increaseHOF(1, array('Dying', 'Planets', 'Deaths'), HOF_PUBLIC); |
||
| 1098 | |||
| 1099 | $this->killPlayer($planet->getSectorID()); |
||
| 1100 | return $return; |
||
| 1101 | } |
||
| 1102 | |||
| 1103 | public function save() { |
||
| 1104 | if ($this->hasChanged === true) { |
||
| 1105 | $this->db->query('UPDATE player SET player_name=' . $this->db->escapeString($this->playerName) . |
||
| 1106 | ', player_id=' . $this->db->escapeNumber($this->playerID) . |
||
| 1107 | ', sector_id=' . $this->db->escapeNumber($this->sectorID) . |
||
| 1108 | ', last_sector_id=' . $this->db->escapeNumber($this->lastSectorID) . |
||
| 1109 | ', turns=' . $this->db->escapeNumber($this->turns) . |
||
| 1110 | ', last_turn_update=' . $this->db->escapeNumber($this->lastTurnUpdate) . |
||
| 1111 | ', newbie_turns=' . $this->db->escapeNumber($this->newbieTurns) . |
||
| 1112 | ', last_news_update=' . $this->db->escapeNumber($this->lastNewsUpdate) . |
||
| 1113 | ', attack_warning=' . $this->db->escapeString($this->attackColour) . |
||
| 1114 | ', dead=' . $this->db->escapeBoolean($this->dead) . |
||
| 1115 | ', newbie_status=' . $this->db->escapeBoolean($this->newbieStatus) . |
||
| 1116 | ', land_on_planet=' . $this->db->escapeBoolean($this->landedOnPlanet) . |
||
| 1117 | ', last_active=' . $this->db->escapeNumber($this->lastActive) . |
||
| 1118 | ', last_cpl_action=' . $this->db->escapeNumber($this->lastCPLAction) . |
||
| 1119 | ', race_id=' . $this->db->escapeNumber($this->raceID) . |
||
| 1120 | ', credits=' . $this->db->escapeNumber($this->credits) . |
||
| 1121 | ', experience=' . $this->db->escapeNumber($this->experience) . |
||
| 1122 | ', alignment=' . $this->db->escapeNumber($this->alignment) . |
||
| 1123 | ', military_payment=' . $this->db->escapeNumber($this->militaryPayment) . |
||
| 1124 | // ', past_knowledge='.$this->db->escapeString($this->pastKnowledge). |
||
| 1125 | ', alliance_id=' . $this->db->escapeNumber($this->allianceID) . |
||
| 1126 | ', alliance_join=' . $this->db->escapeNumber($this->allianceJoinable) . |
||
| 1127 | ', ship_type_id=' . $this->db->escapeNumber($this->shipID) . |
||
| 1128 | ', kills=' . $this->db->escapeNumber($this->kills) . |
||
| 1129 | ', deaths=' . $this->db->escapeNumber($this->deaths) . |
||
| 1130 | ', assists=' . $this->db->escapeNumber($this->assists) . |
||
| 1131 | ', last_port=' . $this->db->escapeNumber($this->lastPort) . |
||
| 1132 | ', bank=' . $this->db->escapeNumber($this->bank) . |
||
| 1133 | ', zoom=' . $this->db->escapeNumber($this->zoom) . |
||
| 1134 | ', display_missions=' . $this->db->escapeBoolean($this->displayMissions) . |
||
| 1135 | ', force_drop_messages=' . $this->db->escapeBoolean($this->forceDropMessages) . |
||
| 1136 | ', group_scout_messages=' . $this->db->escapeString($this->groupScoutMessages) . |
||
| 1137 | ', ignore_globals=' . $this->db->escapeBoolean($this->ignoreGlobals) . |
||
| 1138 | ', newbie_warning = ' . $this->db->escapeBoolean($this->newbieWarning) . |
||
| 1139 | ', name_changed = ' . $this->db->escapeBoolean($this->nameChanged) . |
||
| 1140 | ', combat_drones_kamikaze_on_mines = ' . $this->db->escapeBoolean($this->combatDronesKamikazeOnMines) . |
||
| 1141 | ' WHERE ' . $this->SQL . ' LIMIT 1'); |
||
| 1142 | $this->hasChanged = false; |
||
| 1143 | } |
||
| 1144 | foreach ($this->hasBountyChanged as $key => &$bountyChanged) { |
||
| 1145 | if ($bountyChanged === true) { |
||
| 1146 | $bountyChanged = false; |
||
| 1147 | $bounty = $this->getBounty($key); |
||
| 1148 | if ($bounty['New'] === true) { |
||
| 1149 | if ($bounty['Amount'] > 0 || $bounty['SmrCredits'] > 0) { |
||
| 1150 | $this->db->query('INSERT INTO bounty (account_id,game_id,type,amount,smr_credits,claimer_id,time) VALUES (' . $this->db->escapeNumber($this->getAccountID()) . ',' . $this->db->escapeNumber($this->getGameID()) . ',' . $this->db->escapeString($bounty['Type']) . ',' . $this->db->escapeNumber($bounty['Amount']) . ',' . $this->db->escapeNumber($bounty['SmrCredits']) . ',' . $this->db->escapeNumber($bounty['Claimer']) . ',' . $this->db->escapeNumber($bounty['Time']) . ')'); |
||
| 1151 | } |
||
| 1152 | } else { |
||
| 1153 | if ($bounty['Amount'] > 0 || $bounty['SmrCredits'] > 0) { |
||
| 1154 | $this->db->query('UPDATE bounty |
||
| 1155 | SET amount=' . $this->db->escapeNumber($bounty['Amount']) . ', |
||
| 1156 | smr_credits=' . $this->db->escapeNumber($bounty['SmrCredits']) . ', |
||
| 1157 | type=' . $this->db->escapeString($bounty['Type']) . ', |
||
| 1158 | claimer_id=' . $this->db->escapeNumber($bounty['Claimer']) . ', |
||
| 1159 | time=' . $this->db->escapeNumber($bounty['Time']) . ' |
||
| 1160 | WHERE bounty_id=' . $this->db->escapeNumber($bounty['ID']) . ' AND ' . $this->SQL . ' LIMIT 1'); |
||
| 1161 | } else { |
||
| 1162 | $this->db->query('DELETE FROM bounty WHERE bounty_id=' . $this->db->escapeNumber($bounty['ID']) . ' AND ' . $this->SQL . ' LIMIT 1'); |
||
| 1163 | } |
||
| 1164 | } |
||
| 1165 | } |
||
| 1166 | } |
||
| 1167 | $this->saveHOF(); |
||
| 1168 | } |
||
| 1169 | |||
| 1170 | public function saveHOF() { |
||
| 1171 | if ($this->hasHOFChanged !== false) { |
||
| 1172 | $this->doHOFSave($this->hasHOFChanged); |
||
| 1173 | } |
||
| 1174 | if (!empty(self::$hasHOFVisChanged)) { |
||
| 1175 | foreach (self::$hasHOFVisChanged as $hofType => $changeType) { |
||
| 1176 | if ($changeType == self::HOF_NEW) { |
||
| 1177 | $this->db->query('INSERT INTO hof_visibility (type, visibility) VALUES (' . $this->db->escapeString($hofType) . ',' . $this->db->escapeString(self::$HOFVis[$hofType]) . ')'); |
||
| 1178 | } else { |
||
| 1179 | $this->db->query('UPDATE hof_visibility SET visibility = ' . $this->db->escapeString(self::$HOFVis[$hofType]) . ' WHERE type = ' . $this->db->escapeString($hofType) . ' LIMIT 1'); |
||
| 1180 | } |
||
| 1181 | unset(self::$hasHOFVisChanged[$hofType]); |
||
| 1182 | } |
||
| 1183 | } |
||
| 1184 | } |
||
| 1185 | protected function doHOFSave(array &$hasChangedList, array $typeList = array()) { |
||
| 1186 | foreach ($hasChangedList as $type => &$hofChanged) { |
||
| 1187 | $tempTypeList = $typeList; |
||
| 1188 | $tempTypeList[] = $type; |
||
| 1189 | if (is_array($hofChanged)) { |
||
| 1190 | $this->doHOFSave($hofChanged, $tempTypeList); |
||
| 1191 | } else { |
||
| 1192 | $amount = $this->getHOF($tempTypeList); |
||
| 1193 | if ($hofChanged == self::HOF_NEW) { |
||
| 1194 | if ($amount > 0) { |
||
| 1195 | $this->db->query('INSERT INTO player_hof (account_id,game_id,type,amount) VALUES (' . $this->db->escapeNumber($this->getAccountID()) . ',' . $this->db->escapeNumber($this->getGameID()) . ',' . $this->db->escapeArray($tempTypeList, false, true, ':', false) . ',' . $this->db->escapeNumber($amount) . ')'); |
||
| 1196 | } |
||
| 1197 | } elseif ($hofChanged == self::HOF_CHANGED) { |
||
| 1198 | // if($amount > 0) |
||
| 1199 | $this->db->query('UPDATE player_hof |
||
| 1200 | SET amount=' . $this->db->escapeNumber($amount) . ' |
||
| 1201 | WHERE ' . $this->SQL . ' AND type = ' . $this->db->escapeArray($tempTypeList, false, true, ':', false) . ' LIMIT 1'); |
||
| 1202 | // else |
||
| 1203 | // $this->db->query('DELETE FROM player_hof WHERE account_id=' . $this->getAccountID() . ' AND game_id = ' . $this->getGameID() . ' AND type = ' . $this->db->escapeArray($tempTypeList,false,true,':',false) . ' LIMIT 1'); |
||
| 1204 | // } |
||
| 1205 | } |
||
| 1206 | $hofChanged = false; |
||
| 1207 | } |
||
| 1208 | } |
||
| 1209 | } |
||
| 1210 | |||
| 1211 | protected function getHOFData() { |
||
| 1212 | if (!isset($this->HOF)) { |
||
| 1213 | //Get Player HOF |
||
| 1214 | $this->db->query('SELECT type,amount FROM player_hof WHERE ' . $this->SQL); |
||
| 1215 | $this->HOF = array(); |
||
| 1216 | while ($this->db->nextRecord()) { |
||
| 1217 | $hof =& $this->HOF; |
||
| 1218 | $typeList = explode(':', $this->db->getField('type')); |
||
| 1219 | foreach ($typeList as $type) { |
||
| 1220 | if (!isset($hof[$type])) { |
||
| 1221 | $hof[$type] = array(); |
||
| 1222 | } |
||
| 1223 | $hof =& $hof[$type]; |
||
| 1224 | } |
||
| 1225 | $hof = $this->db->getFloat('amount'); |
||
| 1226 | } |
||
| 1227 | self::getHOFVis(); |
||
| 1228 | } |
||
| 1229 | } |
||
| 1230 | |||
| 1231 | public static function getHOFVis() { |
||
| 1232 | if (!isset(self::$HOFVis)) { |
||
| 1233 | //Get Player HOF Vis |
||
| 1234 | $db = new SmrMySqlDatabase(); |
||
| 1235 | $db->query('SELECT type,visibility FROM hof_visibility'); |
||
| 1236 | self::$HOFVis = array(); |
||
| 1237 | while ($db->nextRecord()) { |
||
| 1238 | self::$HOFVis[$db->getField('type')] = $db->getField('visibility'); |
||
| 1239 | } |
||
| 1240 | } |
||
| 1241 | } |
||
| 1242 | |||
| 1243 | protected function getBountiesData() { |
||
| 1244 | if (!isset($this->bounties)) { |
||
| 1245 | $this->bounties = array(); |
||
| 1246 | $this->db->query('SELECT * FROM bounty WHERE ' . $this->SQL); |
||
| 1247 | while ($this->db->nextRecord()) { |
||
| 1248 | $this->bounties[$this->db->getInt('bounty_id')] = array( |
||
| 1249 | 'Amount' => $this->db->getInt('amount'), |
||
| 1250 | 'SmrCredits' => $this->db->getInt('smr_credits'), |
||
| 1251 | 'Type' => $this->db->getField('type'), |
||
| 1252 | 'Claimer' => $this->db->getInt('claimer_id'), |
||
| 1253 | 'Time' => $this->db->getInt('time'), |
||
| 1254 | 'ID' => $this->db->getInt('bounty_id'), |
||
| 1255 | 'New' => false); |
||
| 1256 | } |
||
| 1257 | } |
||
| 1258 | } |
||
| 1259 | |||
| 1260 | // Get bounties that can be claimed by this player |
||
| 1261 | // Type must be 'HQ' or 'UG' |
||
| 1262 | public function getClaimableBounties($type) { |
||
| 1263 | $bounties = array(); |
||
| 1264 | $this->db->query('SELECT * FROM bounty WHERE claimer_id=' . $this->db->escapeNumber($this->getAccountID()) . ' AND game_id=' . $this->db->escapeNumber($this->getGameID()) . ' AND type=' . $this->db->escapeString($type)); |
||
| 1265 | while ($this->db->nextRecord()) { |
||
| 1266 | $bounties[] = array( |
||
| 1267 | 'player' => SmrPlayer::getPlayer($this->db->getInt('account_id'), $this->getGameID()), |
||
| 1268 | 'bounty_id' => $this->db->getInt('bounty_id'), |
||
| 1269 | 'credits' => $this->db->getInt('amount'), |
||
| 1270 | 'smr_credits' => $this->db->getInt('smr_credits'), |
||
| 1271 | ); |
||
| 1272 | } |
||
| 1273 | return $bounties; |
||
| 1274 | } |
||
| 1275 | |||
| 1276 | /** |
||
| 1277 | * Has this player been designated as the alliance flagship? |
||
| 1278 | */ |
||
| 1279 | public function isFlagship() { |
||
| 1280 | return $this->hasAlliance() && $this->getAlliance()->getFlagshipID() == $this->getAccountID(); |
||
| 1281 | } |
||
| 1282 | |||
| 1283 | public function isPresident() { |
||
| 1284 | return Council::getPresidentID($this->getGameID(), $this->getRaceID()) == $this->getAccountID(); |
||
| 1285 | } |
||
| 1286 | |||
| 1287 | public function isOnCouncil() { |
||
| 1288 | return Council::isOnCouncil($this->getGameID(), $this->getRaceID(), $this->getAccountID()); |
||
| 1289 | } |
||
| 1290 | |||
| 1291 | public function setNewbieWarning($bool) { |
||
| 1292 | if ($this->newbieWarning == $bool) { |
||
| 1293 | return; |
||
| 1294 | } |
||
| 1295 | $this->newbieWarning = $bool; |
||
| 1296 | $this->hasChanged = true; |
||
| 1297 | } |
||
| 1298 | |||
| 1299 | public function getNewbieWarning() { |
||
| 1300 | return $this->newbieWarning; |
||
| 1301 | } |
||
| 1302 | |||
| 1303 | public function getTickers() { |
||
| 1304 | if (!isset($this->tickers)) { |
||
| 1305 | $this->tickers = array(); |
||
| 1306 | //get ticker info |
||
| 1307 | $this->db->query('SELECT type,time,expires,recent FROM player_has_ticker WHERE ' . $this->SQL . ' AND expires > ' . $this->db->escapeNumber(TIME)); |
||
| 1308 | while ($this->db->nextRecord()) { |
||
| 1309 | $this->tickers[$this->db->getField('type')] = array('Type' => $this->db->getField('type'), |
||
| 1310 | 'Time' => $this->db->getInt('time'), |
||
| 1311 | 'Expires' => $this->db->getInt('expires'), |
||
| 1312 | 'Recent' => $this->db->getField('recent')); |
||
| 1313 | } |
||
| 1314 | } |
||
| 1315 | return $this->tickers; |
||
| 1316 | } |
||
| 1317 | |||
| 1318 | public function hasTickers() { |
||
| 1319 | return count($this->getTickers()) > 0; |
||
| 1320 | } |
||
| 1321 | |||
| 1322 | public function getTicker($tickerType) { |
||
| 1323 | $tickers = $this->getTickers(); |
||
| 1324 | if (isset($tickers[$tickerType])) { |
||
| 1325 | return $tickers[$tickerType]; |
||
| 1326 | } |
||
| 1327 | return false; |
||
| 1328 | } |
||
| 1329 | |||
| 1330 | public function hasTicker($tickerType) { |
||
| 1331 | return $this->getTicker($tickerType) !== false; |
||
| 1332 | } |
||
| 1333 | |||
| 1334 | public function getTurnsLevel() { |
||
| 1335 | if (!$this->hasTurns()) { |
||
| 1336 | return 'NONE'; |
||
| 1337 | } |
||
| 1338 | if ($this->getTurns() <= 25) { |
||
| 1339 | return 'LOW'; |
||
| 1340 | } |
||
| 1341 | if ($this->getTurns() <= 75) { |
||
| 1342 | return 'MEDIUM'; |
||
| 1343 | } |
||
| 1344 | return 'HIGH'; |
||
| 1345 | } |
||
| 1346 | |||
| 1347 | /** |
||
| 1348 | * Returns the CSS class color to use when displaying the player's turns |
||
| 1349 | */ |
||
| 1350 | public function getTurnsColor() { |
||
| 1351 | switch ($this->getTurnsLevel()) { |
||
| 1352 | case 'NONE': |
||
| 1353 | case 'LOW': |
||
| 1354 | return 'red'; |
||
| 1355 | break; |
||
| 1356 | case 'MEDIUM': |
||
| 1357 | return 'yellow'; |
||
| 1358 | break; |
||
| 1359 | default: |
||
| 1360 | return 'green'; |
||
| 1361 | } |
||
| 1362 | } |
||
| 1363 | |||
| 1364 | public function update() { |
||
| 1365 | $this->save(); |
||
| 1366 | } |
||
| 1367 | |||
| 1368 | protected static function doMessageSending($senderID, $receiverID, $gameID, $messageTypeID, $message, $expires, $senderDelete = false, $unread = true) { |
||
| 1369 | $message = trim($message); |
||
| 1370 | $db = new SmrMySqlDatabase(); |
||
| 1371 | // send him the message |
||
| 1372 | $db->query('INSERT INTO message |
||
| 1373 | (account_id,game_id,message_type_id,message_text, |
||
| 1374 | sender_id,send_time,expire_time,sender_delete) VALUES(' . |
||
| 1375 | $db->escapeNumber($receiverID) . ',' . |
||
| 1376 | $db->escapeNumber($gameID) . ',' . |
||
| 1377 | $db->escapeNumber($messageTypeID) . ',' . |
||
| 1378 | $db->escapeString($message) . ',' . |
||
| 1379 | $db->escapeNumber($senderID) . ',' . |
||
| 1380 | $db->escapeNumber(TIME) . ',' . |
||
| 1381 | $db->escapeNumber($expires) . ',' . |
||
| 1382 | $db->escapeBoolean($senderDelete) . ')' |
||
| 1383 | ); |
||
| 1384 | // Keep track of the message_id so it can be returned |
||
| 1385 | $insertID = $db->getInsertID(); |
||
| 1386 | |||
| 1387 | if ($unread === true) { |
||
| 1388 | // give him the message icon |
||
| 1389 | $db->query('REPLACE INTO player_has_unread_messages (game_id, account_id, message_type_id) VALUES |
||
| 1390 | (' . $db->escapeNumber($gameID) . ', ' . $db->escapeNumber($receiverID) . ', ' . $db->escapeNumber($messageTypeID) . ')'); |
||
| 1391 | } |
||
| 1392 | |||
| 1393 | switch ($messageTypeID) { |
||
| 1394 | case MSG_PLAYER: |
||
| 1395 | $receiverAccount = SmrAccount::getAccount($receiverID); |
||
| 1396 | if ($receiverAccount->isValidated() && $receiverAccount->isReceivingMessageNotifications($messageTypeID) && !$receiverAccount->isLoggedIn()) { |
||
| 1397 | require_once(get_file_loc('message.functions.inc')); |
||
| 1398 | $sender = getMessagePlayer($senderID, $gameID, $messageTypeID); |
||
| 1399 | if ($sender instanceof SmrPlayer) { |
||
| 1400 | $sender = $sender->getDisplayName(); |
||
| 1401 | } |
||
| 1402 | $mail = setupMailer(); |
||
| 1403 | $mail->Subject = 'Message Notification'; |
||
| 1404 | $mail->setFrom('[email protected]', 'SMR Notifications'); |
||
| 1405 | $bbifiedMessage = 'From: ' . $sender . ' Date: ' . date($receiverAccount->getShortDateFormat() . ' ' . $receiverAccount->getShortTimeFormat(), TIME) . "<br/>\r\n<br/>\r\n" . bbifyMessage($message, true); |
||
| 1406 | $mail->msgHTML($bbifiedMessage); |
||
| 1407 | $mail->AltBody = strip_tags($bbifiedMessage); |
||
| 1408 | $mail->addAddress($receiverAccount->getEmail(), $receiverAccount->getHofName()); |
||
| 1409 | $mail->send(); |
||
| 1410 | $receiverAccount->decreaseMessageNotifications($messageTypeID, 1); |
||
| 1411 | } |
||
| 1412 | break; |
||
| 1413 | } |
||
| 1414 | |||
| 1415 | return $insertID; |
||
| 1416 | } |
||
| 1417 | |||
| 1418 | public function sendMessageToBox($boxTypeID, $message) { |
||
| 1419 | // send him the message |
||
| 1420 | SmrAccount::doMessageSendingToBox($this->getAccountID(), $boxTypeID, $message, $this->getGameID()); |
||
| 1421 | } |
||
| 1422 | |||
| 1423 | public function sendGlobalMessage($message, $canBeIgnored = true) { |
||
| 1424 | if ($canBeIgnored) { |
||
| 1425 | if ($this->getAccount()->isMailBanned()) { |
||
| 1426 | create_error('You are currently banned from sending messages'); |
||
| 1427 | } |
||
| 1428 | } |
||
| 1429 | $this->sendMessageToBox(BOX_GLOBALS, $message); |
||
| 1430 | |||
| 1431 | // send to all online player |
||
| 1432 | $db = new SmrMySqlDatabase(); |
||
| 1433 | $db->query('SELECT account_id |
||
| 1434 | FROM active_session |
||
| 1435 | JOIN player USING (game_id, account_id) |
||
| 1436 | WHERE active_session.last_accessed >= ' . $db->escapeNumber(TIME - SmrSession::TIME_BEFORE_EXPIRY) . ' |
||
| 1437 | AND game_id = ' . $db->escapeNumber($this->getGameID()) . ' |
||
| 1438 | AND ignore_globals = \'FALSE\' |
||
| 1439 | AND account_id != ' . $db->escapeNumber($this->getAccountID())); |
||
| 1440 | |||
| 1441 | while ($db->nextRecord()) { |
||
| 1442 | $this->sendMessage($db->getInt('account_id'), MSG_GLOBAL, $message, $canBeIgnored); |
||
| 1443 | } |
||
| 1444 | $this->sendMessage($this->getAccountID(), MSG_GLOBAL, $message, $canBeIgnored, false); |
||
| 1445 | } |
||
| 1446 | |||
| 1447 | public function sendMessage($receiverID, $messageTypeID, $message, $canBeIgnored = true, $unread = true, $expires = false, $senderDelete = false) { |
||
| 1502 | } |
||
| 1503 | |||
| 1504 | public function sendMessageFromOpAnnounce($receiverID, $message, $expires = false) { |
||
| 1505 | // get expire time if not set |
||
| 1506 | if ($expires === false) { |
||
| 1507 | $expires = TIME + 86400 * 14; |
||
| 1508 | } |
||
| 1509 | self::doMessageSending(ACCOUNT_ID_OP_ANNOUNCE, $receiverID, $this->getGameID(), MSG_ALLIANCE, $message, $expires); |
||
| 1510 | } |
||
| 1511 | |||
| 1512 | public function sendMessageFromAllianceCommand($receiverID, $message) { |
||
| 1513 | $expires = TIME + 86400 * 365; |
||
| 1514 | self::doMessageSending(ACCOUNT_ID_ALLIANCE_COMMAND, $receiverID, $this->getGameID(), MSG_PLAYER, $message, $expires); |
||
| 1515 | } |
||
| 1516 | |||
| 1517 | public static function sendMessageFromPlanet($gameID, $receiverID, $message) { |
||
| 1518 | //get expire time |
||
| 1519 | $expires = TIME + 86400 * 31; |
||
| 1520 | // send him the message |
||
| 1521 | self::doMessageSending(ACCOUNT_ID_PLANET, $receiverID, $gameID, MSG_PLANET, $message, $expires); |
||
| 1522 | } |
||
| 1523 | |||
| 1524 | public static function sendMessageFromPort($gameID, $receiverID, $message) { |
||
| 1525 | //get expire time |
||
| 1526 | $expires = TIME + 86400 * 31; |
||
| 1527 | // send him the message |
||
| 1528 | self::doMessageSending(ACCOUNT_ID_PORT, $receiverID, $gameID, MSG_PLAYER, $message, $expires); |
||
| 1529 | } |
||
| 1530 | |||
| 1531 | public static function sendMessageFromFedClerk($gameID, $receiverID, $message) { |
||
| 1532 | $expires = TIME + 86400 * 365; |
||
| 1533 | self::doMessageSending(ACCOUNT_ID_FED_CLERK, $receiverID, $gameID, MSG_PLAYER, $message, $expires); |
||
| 1534 | } |
||
| 1535 | |||
| 1536 | public static function sendMessageFromAdmin($gameID, $receiverID, $message, $expires = false) { |
||
| 1537 | //get expire time |
||
| 1538 | if ($expires === false) { |
||
| 1539 | $expires = TIME + 86400 * 365; |
||
| 1540 | } |
||
| 1541 | // send him the message |
||
| 1542 | self::doMessageSending(ACCOUNT_ID_ADMIN, $receiverID, $gameID, MSG_ADMIN, $message, $expires); |
||
| 1543 | } |
||
| 1544 | |||
| 1545 | public static function sendMessageFromAllianceAmbassador($gameID, $receiverID, $message, $expires = false) { |
||
| 1546 | //get expire time |
||
| 1547 | if ($expires === false) { |
||
| 1548 | $expires = TIME + 86400 * 31; |
||
| 1549 | } |
||
| 1550 | // send him the message |
||
| 1551 | self::doMessageSending(ACCOUNT_ID_ALLIANCE_AMBASSADOR, $receiverID, $gameID, MSG_ALLIANCE, $message, $expires); |
||
| 1552 | } |
||
| 1553 | |||
| 1554 | public static function sendMessageFromCasino($gameID, $receiverID, $message, $expires = false) { |
||
| 1555 | //get expire time |
||
| 1556 | if ($expires === false) { |
||
| 1557 | $expires = TIME + 86400 * 7; |
||
| 1558 | } |
||
| 1559 | // send him the message |
||
| 1560 | self::doMessageSending(ACCOUNT_ID_CASINO, $receiverID, $gameID, MSG_CASINO, $message, $expires); |
||
| 1561 | } |
||
| 1562 | |||
| 1563 | public static function sendMessageFromRace($raceID, $gameID, $receiverID, $message, $expires = false) { |
||
| 1564 | //get expire time |
||
| 1565 | if ($expires === false) { |
||
| 1566 | $expires = TIME + 86400 * 5; |
||
| 1567 | } |
||
| 1568 | // send him the message |
||
| 1569 | self::doMessageSending(ACCOUNT_ID_GROUP_RACES + $raceID, $receiverID, $gameID, MSG_POLITICAL, $message, $expires); |
||
| 1570 | } |
||
| 1571 | |||
| 1572 | public function setMessagesRead($messageTypeID) { |
||
| 1573 | $this->db->query('DELETE FROM player_has_unread_messages |
||
| 1574 | WHERE '.$this->SQL . ' AND message_type_id = ' . $this->db->escapeNumber($messageTypeID)); |
||
| 1575 | } |
||
| 1576 | |||
| 1577 | public function getPlottedCourse() { |
||
| 1578 | if (!isset($this->plottedCourse)) { |
||
| 1579 | // check if we have a course plotted |
||
| 1580 | $this->db->query('SELECT course FROM player_plotted_course WHERE ' . $this->SQL . ' LIMIT 1'); |
||
| 1581 | |||
| 1582 | if ($this->db->nextRecord()) { |
||
| 1583 | // get the course back |
||
| 1584 | $this->plottedCourse = unserialize($this->db->getField('course')); |
||
| 1585 | } else { |
||
| 1586 | $this->plottedCourse = false; |
||
| 1587 | } |
||
| 1588 | } |
||
| 1589 | |||
| 1590 | // Update the plotted course if we have moved since the last query |
||
| 1591 | if ($this->plottedCourse !== false && (!isset($this->plottedCourseFrom) || $this->plottedCourseFrom != $this->getSectorID())) { |
||
| 1592 | $this->plottedCourseFrom = $this->getSectorID(); |
||
| 1593 | |||
| 1594 | if ($this->plottedCourse->getNextOnPath() == $this->getSectorID()) { |
||
| 1595 | // We have walked into the next sector of the course |
||
| 1596 | $this->plottedCourse->followPath(); |
||
| 1597 | $this->setPlottedCourse($this->plottedCourse); |
||
| 1598 | } elseif ($this->plottedCourse->isInPath($this->getSectorID())) { |
||
| 1599 | // We have skipped to some later sector in the course |
||
| 1600 | $this->plottedCourse->skipToSector($this->getSectorID()); |
||
| 1601 | $this->setPlottedCourse($this->plottedCourse); |
||
| 1602 | } |
||
| 1603 | } |
||
| 1604 | return $this->plottedCourse; |
||
| 1605 | } |
||
| 1606 | |||
| 1607 | public function setPlottedCourse(Distance $plottedCourse) { |
||
| 1608 | $hadPlottedCourse = $this->hasPlottedCourse(); |
||
| 1609 | $this->plottedCourse = $plottedCourse; |
||
| 1610 | if ($this->plottedCourse->getTotalSectors() > 0) { |
||
| 1611 | $this->db->query('REPLACE INTO player_plotted_course |
||
| 1612 | (account_id, game_id, course) |
||
| 1613 | VALUES(' . $this->db->escapeNumber($this->getAccountID()) . ', ' . $this->db->escapeNumber($this->getGameID()) . ', ' . $this->db->escapeBinary(serialize($this->plottedCourse)) . ')'); |
||
| 1614 | } elseif ($hadPlottedCourse) { |
||
| 1615 | $this->deletePlottedCourse(); |
||
| 1616 | } |
||
| 1617 | } |
||
| 1618 | |||
| 1619 | public function hasPlottedCourse() { |
||
| 1620 | return $this->getPlottedCourse() !== false; |
||
| 1621 | } |
||
| 1622 | |||
| 1623 | public function isPartOfCourse($sectorOrSectorID) { |
||
| 1624 | if (!$this->hasPlottedCourse()) { |
||
| 1625 | return false; |
||
| 1626 | } |
||
| 1627 | if ($sectorOrSectorID instanceof SmrSector) { |
||
| 1628 | $sectorID = $sectorOrSectorID->getSectorID(); |
||
| 1629 | } else { |
||
| 1630 | $sectorID = $sectorOrSectorID; |
||
| 1631 | } |
||
| 1632 | return $this->getPlottedCourse()->isInPath($sectorID); |
||
| 1633 | } |
||
| 1634 | |||
| 1635 | public function deletePlottedCourse() { |
||
| 1636 | $this->plottedCourse = false; |
||
| 1637 | $this->db->query('DELETE FROM player_plotted_course WHERE ' . $this->SQL . ' LIMIT 1'); |
||
| 1638 | } |
||
| 1639 | |||
| 1640 | // Computes the turn cost and max misjump between current and target sector |
||
| 1641 | public function getJumpInfo(SmrSector $targetSector) { |
||
| 1642 | $path = Plotter::findDistanceToX($targetSector, $this->getSector(), true); |
||
| 1643 | if ($path === false) { |
||
| 1644 | create_error('Unable to plot from ' . $this->getSectorID() . ' to ' . $targetSector->getSectorID() . '.'); |
||
| 1645 | } |
||
| 1646 | $distance = $path->getRelativeDistance(); |
||
| 1647 | |||
| 1648 | $turnCost = max(TURNS_JUMP_MINIMUM, IRound($distance * TURNS_PER_JUMP_DISTANCE)); |
||
| 1649 | $maxMisjump = max(0, IRound(($distance - $turnCost) * MISJUMP_DISTANCE_DIFF_FACTOR / (1 + $this->getLevelID() * MISJUMP_LEVEL_FACTOR))); |
||
| 1650 | return array('turn_cost' => $turnCost, 'max_misjump' => $maxMisjump); |
||
| 1651 | } |
||
| 1652 | |||
| 1653 | public function __sleep() { |
||
| 1654 | return array('accountID', 'gameID', 'sectorID', 'alignment', 'playerID', 'playerName'); |
||
| 1655 | } |
||
| 1656 | |||
| 1657 | public function &getStoredDestinations() { |
||
| 1658 | if (!isset($this->storedDestinations)) { |
||
| 1659 | $this->storedDestinations = array(); |
||
| 1660 | $this->db->query('SELECT * FROM player_stored_sector WHERE ' . $this->SQL); |
||
| 1661 | while ($this->db->nextRecord()) { |
||
| 1662 | $this->storedDestinations[] = array( |
||
| 1663 | 'Label' => $this->db->getField('label'), |
||
| 1664 | 'SectorID' => $this->db->getInt('sector_id'), |
||
| 1665 | 'OffsetTop' => $this->db->getInt('offset_top'), |
||
| 1666 | 'OffsetLeft' => $this->db->getInt('offset_left') |
||
| 1667 | ); |
||
| 1668 | } |
||
| 1669 | } |
||
| 1670 | return $this->storedDestinations; |
||
| 1671 | } |
||
| 1672 | |||
| 1673 | |||
| 1674 | public function moveDestinationButton($sectorID, $offsetTop, $offsetLeft) { |
||
| 1675 | |||
| 1676 | if (!is_numeric($offsetLeft) || !is_numeric($offsetTop)) { |
||
| 1677 | create_error('The position of the saved sector must be numeric!.'); |
||
| 1678 | } |
||
| 1679 | $offsetTop = round($offsetTop); |
||
| 1680 | $offsetLeft = round($offsetLeft); |
||
| 1681 | |||
| 1682 | if ($offsetLeft < 0 || $offsetLeft > 500 || $offsetTop < 0 || $offsetTop > 300) { |
||
| 1683 | create_error('The saved sector must be in the box!'); |
||
| 1684 | } |
||
| 1685 | |||
| 1686 | $storedDestinations =& $this->getStoredDestinations(); |
||
| 1687 | foreach ($storedDestinations as &$sd) { |
||
| 1688 | if ($sd['SectorID'] == $sectorID) { |
||
| 1689 | $sd['OffsetTop'] = $offsetTop; |
||
| 1690 | $sd['OffsetLeft'] = $offsetLeft; |
||
| 1691 | $this->db->query(' |
||
| 1692 | UPDATE player_stored_sector |
||
| 1693 | SET offset_left = ' . $this->db->escapeNumber($offsetLeft) . ', offset_top=' . $this->db->escapeNumber($offsetTop) . ' |
||
| 1694 | WHERE ' . $this->SQL . ' AND sector_id = ' . $this->db->escapeNumber($sectorID) |
||
| 1695 | ); |
||
| 1696 | return true; |
||
| 1697 | } |
||
| 1698 | } |
||
| 1699 | |||
| 1700 | create_error('You do not have a saved sector for #' . $sectorID); |
||
| 1701 | } |
||
| 1702 | |||
| 1703 | public function addDestinationButton($sectorID, $label) { |
||
| 1704 | |||
| 1705 | if (!is_numeric($sectorID) || !SmrSector::sectorExists($this->getGameID(), $sectorID)) { |
||
| 1706 | create_error('You want to add a non-existent sector?'); |
||
| 1707 | } |
||
| 1708 | |||
| 1709 | // sector already stored ? |
||
| 1710 | foreach ($this->getStoredDestinations() as $sd) { |
||
| 1711 | if ($sd['SectorID'] == $sectorID) { |
||
| 1712 | create_error('Sector already stored!'); |
||
| 1713 | } |
||
| 1714 | } |
||
| 1715 | |||
| 1716 | $this->storedDestinations[] = array( |
||
| 1717 | 'Label' => $label, |
||
| 1718 | 'SectorID' => (int)$sectorID, |
||
| 1719 | 'OffsetTop' => 1, |
||
| 1720 | 'OffsetLeft' => 1 |
||
| 1721 | ); |
||
| 1722 | |||
| 1723 | $this->db->query(' |
||
| 1724 | INSERT INTO player_stored_sector (account_id, game_id, sector_id, label, offset_top, offset_left) |
||
| 1725 | VALUES (' . $this->db->escapeNumber($this->getAccountID()) . ', ' . $this->db->escapeNumber($this->getGameID()) . ', ' . $this->db->escapeNumber($sectorID) . ',' . $this->db->escapeString($label, true) . ',1,1)' |
||
| 1726 | ); |
||
| 1727 | } |
||
| 1728 | |||
| 1729 | public function deleteDestinationButton($sectorID) { |
||
| 1730 | if (!is_numeric($sectorID) || $sectorID < 1) { |
||
| 1731 | create_error('You want to remove a non-existent sector?'); |
||
| 1732 | } |
||
| 1733 | |||
| 1734 | foreach ($this->getStoredDestinations() as $key => $sd) { |
||
| 1735 | if ($sd['SectorID'] == $sectorID) { |
||
| 1736 | $this->db->query(' |
||
| 1737 | DELETE FROM player_stored_sector |
||
| 1738 | WHERE ' . $this->SQL . ' |
||
| 1739 | AND sector_id = ' . $this->db->escapeNumber($sectorID) |
||
| 1740 | ); |
||
| 1741 | unset($this->storedDestinations[$key]); |
||
| 1742 | return true; |
||
| 1743 | } |
||
| 1744 | } |
||
| 1745 | return false; |
||
| 1746 | } |
||
| 1747 | |||
| 1748 | public function getExperienceRank() { |
||
| 1749 | return $this->computeRanking('experience', $this->getExperience()); |
||
| 1750 | } |
||
| 1751 | public function getKillsRank() { |
||
| 1752 | return $this->computeRanking('kills', $this->getKills()); |
||
| 1753 | } |
||
| 1754 | public function getDeathsRank() { |
||
| 1755 | return $this->computeRanking('deaths', $this->getDeaths()); |
||
| 1756 | } |
||
| 1757 | public function getAssistsRank() { |
||
| 1759 | } |
||
| 1760 | private function computeRanking($dbField, $playerAmount) { |
||
| 1761 | $this->db->query('SELECT count(*) FROM player |
||
| 1762 | WHERE game_id = ' . $this->db->escapeNumber($this->getGameID()) . ' |
||
| 1763 | AND ( |
||
| 1764 | '.$dbField . ' > ' . $this->db->escapeNumber($playerAmount) . ' |
||
| 1765 | OR ( |
||
| 1766 | '.$dbField . ' = ' . $this->db->escapeNumber($playerAmount) . ' |
||
| 1767 | AND player_name <= ' . $this->db->escapeString($this->getPlayerName()) . ' |
||
| 1768 | ) |
||
| 1769 | )'); |
||
| 1770 | $this->db->nextRecord(); |
||
| 1771 | $rank = $this->db->getInt('count(*)'); |
||
| 1772 | return $rank; |
||
| 1773 | } |
||
| 1774 | } |
||
| 1775 |