$admin['web_group'] = $userbank->GetProperty("group_name", $admin['aid']); $admin['server_group'] = $userbank->GetProperty("srv_groups", $admin['aid']); if (empty($admin['web_group']) || $admin['web_group'] == " ") { $admin['web_group'] = "No Group/Individual Permissions"; } if (empty($admin['server_group']) || $admin['server_group'] == " ") { $admin['server_group'] = "No Group/Individual Permissions"; } $num = $GLOBALS['db']->GetRow("SELECT count(authid) AS num FROM `" . DB_PREFIX . "_bans` WHERE aid = '" . $admin['aid'] . "'"); $admin['bancount'] = $num['num']; $nodem = $GLOBALS['db']->GetRow("SELECT count(B.bid) AS num FROM `" . DB_PREFIX . "_bans` AS B WHERE aid = '" . $admin['aid'] . "' AND NOT EXISTS (SELECT D.demid FROM `" . DB_PREFIX . "_demos` AS D WHERE D.demid = B.bid)"); $admin['aid'] = $admin['aid']; $admin['nodemocount'] = $nodem['num']; $admin['name'] = stripslashes($admin['user']); $admin['server_flag_string'] = SmFlagsToSb($userbank->GetProperty("srv_flags", $admin['aid'])); $admin['web_flag_string'] = BitToString($userbank->GetProperty("extraflags", $admin['aid'])); $lastvisit = $userbank->GetProperty("lastvisit", $admin['aid']); if (!$lastvisit) { $admin['lastvisit'] = "Never"; } else { $admin['lastvisit'] = SBDate($dateformat, $userbank->GetProperty("lastvisit", $admin['aid'])); } array_push($admin_list, $admin); } if ($page > 1) { $prev = CreateLinkR('<img border="0" alt="prev" src="images/left.gif" style="vertical-align:middle;" /> prev', "index.php?p=admin&c=admins&page=" . ($page - 1) . $advSearchString); } else { $prev = ""; } if ($AdminsEnd < $admin_count) { $next = CreateLinkR('next <img border="0" alt="prev" src="images/right.gif" style="vertical-align:middle;" />', "index.php?p=admin&c=admins&page=" . ($page + 1) . $advSearchString);
* @package SourceBans * @link http://www.sourcebans.net * * @version $Id: admin.groups.php 190 2008-12-30 02:06:27Z peace-maker $ * ============================================================================= */ if (!defined("IN_SB")) { echo "You should not be here. Only follow links!"; die; } global $userbank, $theme; echo '<div id="admin-page-content">'; // web groups $web_group_list = $GLOBALS['db']->GetAll("SELECT * FROM `" . DB_PREFIX . "_groups` WHERE type != '3'"); for ($i = 0; $i < count($web_group_list); $i++) { $web_group_list[$i]['permissions'] = BitToString($web_group_list[$i]['flags'], $web_group_list[$i]['type']); $query = $GLOBALS['db']->GetRow("SELECT COUNT(gid) AS cnt FROM `" . DB_PREFIX . "_admins` WHERE gid = '" . $web_group_list[$i]['gid'] . "'"); $web_group_count[$i] = $query['cnt']; $web_group_admins[$i] = $GLOBALS['db']->GetAll("SELECT aid, user, authid FROM `" . DB_PREFIX . "_admins` WHERE gid = '" . $web_group_list[$i]['gid'] . "'"); } // Server admin groups $server_admin_group_list = $GLOBALS['db']->GetAll("SELECT * FROM `" . DB_PREFIX . "_srvgroups`"); for ($i = 0; $i < count($server_admin_group_list); $i++) { $server_admin_group_list[$i]['permissions'] = SmFlagsToSb($server_admin_group_list[$i]['flags']); $srvGroup = $GLOBALS['db']->qstr($server_admin_group_list[$i]['name']); $query = $GLOBALS['db']->GetRow("SELECT COUNT(aid) AS cnt FROM `" . DB_PREFIX . "_admins` WHERE srv_group = {$srvGroup};"); $server_admin_group_count[$i] = $query['cnt']; $server_admin_group_admins[$i] = $GLOBALS['db']->GetAll("SELECT aid, user, authid FROM `" . DB_PREFIX . "_admins` WHERE srv_group = {$srvGroup};"); $server_admin_group_overrides[$i] = $GLOBALS['db']->GetAll("SELECT type, name, access FROM `" . DB_PREFIX . "_srvgroups_overrides` WHERE group_id = ?", array($server_admin_group_list[$i]['id'])); } // server groups
* @version $Id: page.youraccount.php 200 2008-12-31 12:33:17Z peace-maker $ * ============================================================================= */ global $userbank, $theme; if (!defined("IN_SB")) { echo "You should not be here. Only follow links!"; die; } if ($userbank->GetAid() == -1) { echo "You shoudnt be here. looks like we messed up ><"; die; } $groupsTabMenu = new CTabsMenu(); $groupsTabMenu->addMenuItem("Просмотр прав", 0); $groupsTabMenu->addMenuItem("Сменить пароль", 1); $groupsTabMenu->addMenuItem("Пароль сервера", 2); $groupsTabMenu->addMenuItem("Сменить e-mail", 3); $groupsTabMenu->outputMenu(); $res = $GLOBALS['db']->Execute("SELECT `srv_password`, `email` FROM `" . DB_PREFIX . "_admins` WHERE `aid` = '" . $userbank->GetAid() . "'"); $srvpwset = !empty($res->fields['srv_password']) ? true : false; $theme->assign('srvpwset', $srvpwset); $theme->assign('email', $res->fields['email']); $theme->assign('user_aid', $userbank->GetAid()); $theme->assign('web_permissions', BitToString($userbank->GetProperty("extraflags"))); $theme->assign('server_permissions', SmFlagsToSb($userbank->GetProperty("srv_flags"))); $theme->assign('min_pass_len', MIN_PASS_LENGTH); $theme->left_delimiter = "-{"; $theme->right_delimiter = "}-"; $theme->display('page_youraccount.tpl'); $theme->left_delimiter = "{"; $theme->right_delimiter = "}";