function HandleAuthor()
{
$db = JFactory::getDBO();
$mainframe = JFactory::getApplication();
if (!FSS_Permission::auth("core.edit.state", $this->getAsset())) {
exit;
}
$asset = $this->getAsset();
$users = SupportUsers::usersWithPerm($asset, "core.edit.own");
$users2 = SupportUsers::usersWithPerm($asset, "core.edit");
$uids = array();
foreach ($users as $uid => $user) {
$uids[$uid] = (int) $uid;
}
foreach ($users2 as $uid => $user) {
$uids[$uid] = (int) $uid;
}
// build query
$qry = "SELECT * FROM #__users";
$where = array();
$where[] = "id IN (" . implode(", ", $uids) . ")";
$limitstart = FSS_Input::getInt('limitstart', 0);
$mainframe = JFactory::getApplication();
$limit = $mainframe->getUserStateFromRequest('users.limit', 'limit', 10, 'int');
$search = FSS_Input::getString('search', '');
$db = JFactory::getDBO();
if ($search != "") {
$where[] = "(username LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%' OR name LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%' OR email LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%')";
}
if (count($where) > 0) {
$qry .= " WHERE " . implode(" AND ", $where);
}
// Sort ordering
$qry .= " ORDER BY name ";
// get max items
//echo $qry."<br>";
$db->setQuery($qry);
$db->query();
$maxitems = $db->getNumRows();
// select picked items
$db->setQuery($qry, $limitstart, $limit);
$this->users = $db->loadObjectList();
// build pagination
$this->pagination = new JPaginationEx($maxitems, $limitstart, $limit);
$this->search = $search;
include $this->tmplpath . DS . "user.php";
}
