// -*- tab-width: 3; indent-tabs-mode: 1; -*- /* * $Id: admin.php 554 2006-04-12 10:37:20Z buddhafly $ * Authors: András Micsik */ require "init.inc.php"; $smarty->assign('PAGETITLE', $page->getlocalized('AdminPage')); $page->forceLogin(); //$page->errorURL = "admin.php"; checkPerm('node', 'change'); if (sotf_Utils::getParameter('del')) { $uid = sotf_Utils::getParameter('uid'); $user = new sotf_User($uid); debug("Deleting user {$uid}", $user->username); $user->delete(); $page->redirect('adminUsers.php'); $page->logRequest(); exit; } $pattern = sotf_Utils::getParameter('pattern'); $count = sotf_User::countUsers($pattern); $limit = $page->splitList($count, $scriptUrl . "?pattern=" . urlencode($pattern)); $users = sotf_User::listUsers($limit["from"], $limit["maxresults"], $pattern); foreach ($users as $user) { $user['groups'] = join(', ', sotf_Group::getGroupNames($user['id'])); $ulist[] = $user; } $smarty->assign('USERS', $ulist); $smarty->assign('PATTERN', $pattern); $page->send();
<?php // -*- tab-width: 3; indent-tabs-mode: 1; -*- /* * $Id: admin.php 554 2006-04-12 10:37:20Z buddhafly $ * Authors: András Micsik */ require "init.inc.php"; $smarty->assign('PAGETITLE', $page->getlocalized('AdminPage')); $page->forceLogin(); //$page->errorURL = "admin.php"; checkPerm('node', 'change'); $actionsToCount = "'listens','downloads'"; $sql = "SELECT u.id, u.username, d.contact_person, count(distinct h.object_id) as count FROM sotf_users u LEFT JOIN sotf_user_data d ON d.user_id=u.id, sotf_user_history h WHERE u.id=h.user_id AND h.action IN ({$actionsToCount}) GROUP BY u.id, u.username, d.contact_person ORDER BY count DESC"; $count = $db->getOne("SELECT COUNT(*) FROM ({$sql}) s"); $limit = $page->splitList($count, $scriptUrl); $res = $db->limitQuery($sql, $limit["from"], $limit["maxresults"]); if (DB::isError($res)) { raiseError($res); } $results = null; while (DB_OK === $res->fetchInto($row)) { $row['groups'] = sotf_Group::getGroupNames($row['id']); $results[] = $row; } $smarty->assign('TOPLIST', $results); $page->send();