echo '<pre>' . $img->getTem()->printTem() . '</pre>';
*/
echo "<h3>Users</h3>";
$q = new myQuery(array('CREATE TEMPORARY TABLE tmp_users
SELECT user.id,
IF((lastname = "" OR lastname IS NULL), email, CONCAT(lastname, ", ", firstname)) as user,
MAX(logintime) as last_login,
COUNT(*) as logins
FROM user
LEFT JOIN login ON login.user_id=user.id
GROUP BY user.id', 'SELECT tmp_users.*, COUNT(*) as images
FROM tmp_users
LEFT JOIN img ON tmp_users.id=img.user_id
GROUP BY tmp_users.id
ORDER BY last_login DESC;'));
echo '<div id="usertable">' . $q->get_result_as_table() . '</div>';
echo "<h3>My Image Base Dir</h3>";
class VisibleOnlyFilter extends RecursiveFilterIterator
{
public function accept()
{
$fileName = $this->getInnerIterator()->current()->getFileName();
$firstChar = $fileName[0];
return $firstChar !== '.';
}
}
class FilesOnlyFilter extends RecursiveFilterIterator
{
public function accept()
{
$iterator = $this->getInnerIterator();
