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