$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);
