// -*- 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();
