<?php

$db->query('SELECT alliance_id,alliance_name,leader_id FROM alliance WHERE game_id=' . SmrSession::$game_id . ' AND alliance_id=' . $player->getAllianceID() . ' LIMIT 1');
$db->nextRecord();
$template->assign('PageTopic',stripslashes($db->getField('alliance_name')) . ' (' . $db->getField('alliance_id') . ')');
include(get_file_loc('menue.inc'));
create_alliance_menue($alliance_id,$db->getField('leader_id'));

$players = array();
$db->query('SELECT * FROM player WHERE game_id='.$db->escapeNumber($player->getGameID()).' AND alliance_id=0 AND account_id NOT IN (SELECT account_id FROM draft_leaders WHERE draft_leaders.account_id=player.account_id) AND sector_id!=1;');
while($db->nextRecord())
{
	$pickPlayer =& SmrPlayer::getPlayer($db->getRow(), $player->getGameID());
	$players[] = array('Player' => &$pickPlayer,
						'PlayerPickHREF' => SmrSession::get_new_href(create_container('alliance_pick_processing.php','',array('PickedAccountID'=>$pickPlayer->getAccountID()))));
}

$template->assignByRef('PickPlayers', $players);
?>
<?php

$db->query('SELECT alliance_id,alliance_name,leader_id FROM alliance WHERE game_id=' . SmrSession::$game_id . ' AND alliance_id=' . $player->getAllianceID() . ' LIMIT 1');
$db->nextRecord();
$template->assign('PageTopic',stripslashes($db->getField('alliance_name')) . ' (' . $db->getField('alliance_id') . ')');
include(get_file_loc('menue.inc'));
create_alliance_menue($alliance_id,$db->getField('leader_id'));

$players = array();
$db->query('SELECT * FROM player WHERE game_id='.$db->escapeNumber($player->getGameID()).' AND (alliance_id=0 OR alliance_id=302) AND account_id NOT IN (SELECT account_id FROM draft_leaders WHERE draft_leaders.account_id=player.account_id) AND sector_id!=1;');
while($db->nextRecord())
{
	$pickPlayer =& SmrPlayer::getPlayer($db->getRow(), $player->getGameID());
	$players[] = array('Player' => &$pickPlayer,
						'PlayerPickHREF' => SmrSession::get_new_href(create_container('alliance_pick_processing.php','',array('PickedAccountID'=>$pickPlayer->getAccountID()))));
}

$template->assignByRef('PickPlayers', $players);
?>
Allow picking people from NHA.
Allow picking people from NHA.
