WHERE alliance_id=' . $db->escapeNumber($alliance->getAllianceID()) . '
AND game_id = ' . $db->escapeNumber($alliance->getGameID()) . '
GROUP BY alliance_id');
$db->nextRecord();
$template->assign('AllianceExp', $db->getInt('alliance_xp'));
$template->assign('AllianceAverageExp', $db->getInt('alliance_avg'));
if ($account->getAccountID() == $alliance->getLeaderID() || $account->hasPermission(PERMISSION_EDIT_ALLIANCE_DESCRIPTION)) {
$container = create_container('skeleton.php', 'alliance_stat.php');
$container['alliance_id'] = $alliance->getAllianceID();
$template->assign('EditAllianceDescriptionHREF', SmrSession::getNewHREF($container));
}
$db->query('SELECT 1 FROM alliance_has_roles WHERE alliance_id = ' . $db->escapeNumber($alliance->getAllianceID()) . ' AND game_id = ' . $db->escapeNumber($alliance->getGameID()) . '
AND role_id = ' . $db->escapeNumber($player->getAllianceRole()) . ' AND change_roles = \'TRUE\'');
$allowed = $db->nextRecord();
$template->assign('CanChangeRoles', $allowed);
$alliancePlayers =& SmrPlayer::getAlliancePlayers($player->getGameID(), $alliance->getAllianceID());
$template->assignByRef('AlliancePlayers', $alliancePlayers);
if ($alliance->getAllianceID() == $player->getAllianceID()) {
// Alliance members get to see active/inactive status of members
$template->assign('ActiveIDs', $alliance->getActiveIDs());
$container = create_container('skeleton.php', 'alliance_roster.php');
if ($showRoles) {
$container['action'] = 'Hide Alliance Roles';
} else {
$container['action'] = 'Show Alliance Roles';
}
$template->assign('ToggleRolesHREF', SmrSession::getNewHREF($container));
}
$canJoin = $alliance->canJoinAlliance($player);
$template->assign('CanJoin', $canJoin);
if ($canJoin === true) {
