SetLinksFormat( 'Back', ' | ', 'Next' ); $pagination->SetItemsPerPage(51); $pagination->SetLinksToDisplay(10); if (isset($_GET['page']) && is_numeric($_GET['page'])) { $pagination->SetCurrentPage($_GET['page']); } else { $pagination->SetCurrentPage(1); } $breadcrumb['Page ' . $pagination->currentPage] = "/viewAllCelebs.wik?page=" . $pagination->currentPage; $pagination->setItemCount($database->oneField($database->prepareSql("SELECT COUNT(*) FROM authentication WHERE emailVerified=1 AND type='v'"))); $sqlId = $database->prepareSql("SELECT DISTINCT users.id, authentication.profileName, authentication.displayName, users.country, authentication.lastLogin FROM authentication JOIN users ON users.id=authentication.userId WHERE authentication.emailVerified=1 AND authentication.type='v' ORDER BY authentication.displayName ASC " . $pagination->GetSqlLimit()); $users = $database->multipleRows($sqlId); $nav = << TXT; if (!$users) { $errorDisplay = new displayManager('error2'); $errorDisplay->addPlaceHolder('ERROR', "There are no celebs."); $itemTypeDisplay->addPlaceHolder('CONTENT', '' . $errorDisplay->outputHtml(true) . '
'); } else { $content = $pagination->GetPageLinks(); foreach ($users as $user) { $avatar = getAvatar($user['id'], 45); $profileName = stripslashes($user['profileName']); $displayName = stripslashes($user['displayName']); $online = 'no'; if ($user['lastLogin'] > time() - 300) { $online = 'yes'; } $content .= <<
Country: {$user['country']}
Online: $online
TXT; } $content .= $pagination->GetPageLinks(); $itemTypeDisplay->addPlaceHolder('CONTENT', $content); } $itemTypeDisplay->addPlaceHolder('NAV', $nav); $content = $itemTypeDisplay->outputHtml(true); $display->addPlaceHolder('CONTENT', $content); /******** LOGIN PANEL *+* 0000181 20070531 4:41 ********/ require_once("./loginBox.inc.wik"); /******** LOGIN STATUS *+* 0000191 20070709 1:58P ********/ require_once("./loginStatus.inc.wik"); outputTemplate(&$display); ?>