Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.31 KB | None | 0 0
  1. private function listServers()
  2.     {
  3.         if (isset($_GET['page']))
  4.             $page = (intval($_GET['page']) > 0) ? intval($_GET['page']) : 0;
  5.         else
  6.             $page = 0;
  7.        
  8.         $query = $this->db->execute('SELECT `id`, `name` FROM `<ezrpg>servers` ORDER BY `id` ASC LIMIT ?,2', array($page * 2));
  9.        
  10.         $servers = Array();
  11.         while ($m = $this->db->fetch($query))
  12.         {
  13.             $servers[] = $m;
  14.         }
  15.        
  16.         $query = $this->db->fetchRow('SELECT COUNT(`id`) AS `count` FROM `<ezrpg>servers`');
  17.         $total_servers = $query->count;
  18.        
  19.         $prevpage = (($page - 1) >= 0) ? ($page - 1) : 0;
  20.        
  21.         $this->tpl->assign('nextpage', ++$page);
  22.         $this->tpl->assign('prevpage', $prevpage);
  23.         $this->tpl->assign('serverscount', $total_servers);
  24.         $this->tpl->assign('servers', $servers);
  25.        
  26.         $this->tpl->display('serverlist.tpl');
  27.     }
  28.     private function getServer()
  29.     {
  30.     $query = $this->db->execute('SELECT * FROM `<ezrpg>servers` WHERE `id`=? LIMIT 1', array($_GET['id']));
  31.     $server = Array();
  32.         while ($m = $this->db->fetch($query))
  33.         {
  34.             $server[] = $m;
  35.         }
  36.     $this->tpl->assign('server', $server);
  37.     $this->tpl->display('server_description.tpl');
  38.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement