| Server IP : 27.254.152.13 / Your IP : 216.73.217.38 Web Server : Apache/2 System : Linux ns1-252017.dragonhispeed.com 5.2.0 #1 SMP Fri Mar 29 22:50:14 MSK 2024 x86_64 User : coloflew ( 1072) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/coloflew/public_html/rehelp/ |
Upload File : |
<?php
require 'inc/mysqli.inc.php';
$PAGE = empty($_GET['page'])
? 1
: (int)$_GET['page'];
$ITEMS_PER_PAGE = 100;
$START_OFFSET = ($PAGE - 1) * $ITEMS_PER_PAGE;
$result = $mysqli->query(
"
SELECT
`id`,
`created`,
`last_commented`,
`title`,
`name`,
`num_comments`,
`last_commented_name`
FROM `re_topic`
ORDER BY `last_commented` DESC
LIMIT {$START_OFFSET}, {$ITEMS_PER_PAGE}
"
);
$ITEMS = array();
while ($item = $result->fetch_assoc()) {
$ITEMS[] = $item;
}
$result->free();
$result = $mysqli->query('SELECT COUNT(*) FROM `re_topic`');
$FOUND_ROWS = current($result->fetch_row());
$result->free();
$NUM_PAGES = ceil($FOUND_ROWS / $ITEMS_PER_PAGE);
$PAGE_TEMPLATE = 'inc/index.inc.php';
require 'inc/main.inc.php';