= $total) {
$limit = 0;
$start = 0;
$entries_to_get = $entries_per_page;
}
else if ($start == 1) {
$entries_to_get = ($total % $entries_per_page);
$limit = $total - $entries_to_get;
}
else {
$limit = ($total - $start) - $entries_per_page;
$entries_to_get = $entries_per_page;
}
}
if ($limit < 0) {
$limit = 0;
}
$offset = ($total % $entries_per_page);
$tpl = new FastTemplate($template_directory);
$tpl->define(array('main' => 'guestbook.tpl',
'entries' => 'entry.tpl',
'enter' => (isset($entered) ? 'entered.tpl' : 'enter.tpl')));
if (isset($post)) {
$view_result = mysql_query("SELECT display_int, name, email, date, entry
FROM $table
WHERE display_int = '$post'");
}else {
$view_result = mysqli_query($mysqli, "SELECT display_int, name, email, date, entry
FROM $table
WHERE moderated='N'
ORDER BY display_int DESC
LIMIT $entries_to_get OFFSET $limit");
}
$farts = array();
while ($row = mysqli_fetch_array($view_result)) {
if ($row['email'] != '') {
$name = '' . $row['name'] . '';
}
else {
$name = $row['name'];
}
$date = date("dS F Y - h:i:s A", $row['date']);
$farts[] = array('NAME' => $name,
'DATE' => $date,
'ENTER_MESSAGE' => $enter_message,
'ENTRY' => stripslashes($row['entry']),
'ENTRY_ID' => $row['display_int']);
}
$farts = array_reverse($farts);
foreach ($farts as $fart) {
$tpl->assign($fart);
$tpl->parse('ENTRIES', '.entries');
}
$indx = make_index ($total, $start, $entries_per_page, $offset);
$tpl->assign(array('FOOTING'=> $indx));
$tpl->parse('ENTER', 'enter');
$tpl->parse("FINAL", array("main"));
$tpl->FastPrint();
//
?>
print_time('page load'); ?>