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) {