<?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';