$players[$db->getInt('account_id')] = SmrPlayer::getPlayer($db->getInt('account_id'), $player->getGameID())->getLinkedDisplayName(false); } $db->query('SELECT mb_messages FROM player_has_alliance_role JOIN alliance_has_roles USING(game_id,alliance_id,role_id) WHERE account_id = ' . $db->escapeNumber($player->getAccountID()) . ' AND game_id = ' . $db->escapeNumber($player->getGameID()) . ' AND alliance_id=' . $db->escapeNumber($alliance->getAllianceID()) . ' LIMIT 1'); $db->nextRecord(); $thread['CanDelete'] = $db->getBoolean('mb_messages'); $db->query('SELECT text, sender_id, time, reply_id FROM alliance_thread WHERE game_id=' . $db->escapeNumber($player->getGameID()) . ' AND alliance_id=' . $db->escapeNumber($alliance->getAllianceID()) . ' AND thread_id=' . $db->escapeNumber($thread_id) . ' ORDER BY reply_id LIMIT ' . $var['thread_replies'][$thread_index]); $thread['CanDelete'] = $db->getNumRows() > 1 && $thread['CanDelete']; $thread['Replies'] = array(); $container = create_container('alliance_message_delete_processing.php', '', $var); $container['thread_id'] = $thread_id; while ($db->nextRecord()) { $thread['Replies'][$db->getInt('reply_id')] = array('Sender' => $players[$db->getInt('sender_id')], 'Message' => $db->getField('text'), 'SendTime' => $db->getInt('time')); if ($thread['CanDelete']) { $container['reply_id'] = $db->getInt('reply_id'); $thread['Replies'][$db->getInt('reply_id')]['DeleteHref'] = SmrSession::getNewHREF($container); } } if ($mbWrite || in_array($player->getAccountID(), Globals::getHiddenPlayers())) { $container = create_container('alliance_message_add_processing.php', '', $var); $container['thread_index'] = $thread_index; $thread['CreateThreadReplyFormHref'] = SmrSession::getNewHREF($container); } $template->assignByRef('Thread', $thread); if (isset($var['preview'])) { $template->assign('Preview', $var['preview']); }
<?php $template->assign('PageTopic', 'Examine Planet'); $planet =& $player->getSectorPlanet(); $template->assignByRef('ThisPlanet', $planet); $planetLand = !$planet->hasOwner() || $planet->getOwner()->sameAlliance($player) || in_array($player->getAccountID(), Globals::getHiddenPlayers()); if (!$planetLand) { // Only check treaties if we can't otherwise land. $ownerAllianceID = 0; if ($planet->hasOwner()) { $ownerAllianceID = $planet->getOwner()->getAllianceID(); } $db->query(' SELECT planet_land FROM alliance_treaties WHERE (alliance_id_1 = ' . $db->escapeNumber($ownerAllianceID) . ' OR alliance_id_1 = ' . $db->escapeNumber($player->getAllianceID()) . ') AND (alliance_id_2 = ' . $db->escapeNumber($ownerAllianceID) . ' OR alliance_id_2 = ' . $db->escapeNumber($player->getAllianceID()) . ') AND game_id = ' . $db->escapeNumber($player->getGameID()) . ' AND planet_land = 1 AND official = ' . $db->escapeBoolean(true)); $planetLand = $db->nextRecord(); } $template->assign('PlanetLand', $planetLand);