$anzahl = 5;
if ($_REQUEST['page'] == "") {
$page = 1;
}
$limit = ($page - 1) * $anzahl;
$db->query("SELECT author, text, UNIX_TIMESTAMP(date) AS datum\n\t\t\tFROM guestbook\n\t\t\tORDER BY date DESC\n\t\t\tLIMIT {$limit},{$anzahl}");
while ($db->next_record()) {
echo "<table>";
echo "<tr><td>";
echo "User: <span style=\"font-style: italic; font-weight: bold;\">" . htmlentities($db->record['author']) . "</span>";
echo "</tr><tr><td>";
echo "Date: " . date("d.m.Y \\u\\m H:i", $db->record['datum']);
echo "</td></tr><tr><td>";
echo nl2br(htmlentities($db->record['text']));
echo "</td></tr>";
echo "</table>";
echo "<hr>";
}
echo '<form action="gb_input.php"><input type="submit" value="Hab auch was zu sagen"></form><br>';
if ($page != 1) {
echo '<a href="gb_output.php?page=' . ($page - 1) . '">Back</a> ';
}
$db->query('SELECT count(*) FROM guestbook');
$rows = $db->result();
if ($rows - ($page * $anzahl + $anzahl - $rows % $anzahl) >= 0) {
echo '<a href="gb_output.php?page=' . ($page + 1) . '">Forward</a><br>';
}
echo "\$limit: " . $limit . "<br>";
echo "\$rows: " . $rows . "<br>";
echo "\$page * \$anzahl: " . $page * $anzahl . "<br>";
echo 3 % 5;
$album[$i] = ucfirst($album[$i]);
}
}
$album = implode(' ', $album);
//check for typos in album name so we don't insert a new album by mistake
if ($_POST['usefromdb']) {
$album = $album_db;
}
if (!isset($_POST['confirmed']) || $_POST['confirmed'] != 1) {
$firstletter = substr($album, 0, 1);
$db->query("SELECT id, name FROM catalbums WHERE name LIKE '{$firstletter}%'");
$db2 = new db_local();
while ($db->next_record()) {
$db2->query("SELECT artist FROM catfiles WHERE album='" . $db->record['id'] . "'");
$distance = levenshtein($album, $db->record['name']);
if ($distance > 0 && $distance < 4 && $db2->result() == $artist) {
printf("<form action=\"{$PHP_SELF}\" method=\"POST\">\r\n\t\t\t\t\t<p align=\"center\">" . $lang['add2']['spellcheckerinfo'] . "</p>\r\n\t\t\t\t\t<p align=\"center\"><b>" . $db->record['name'] . "</b><br>\r\n\t\t\t\t\t<input type=\"submit\" name=\"usefromdb\" value=\"" . $lang['add2']['usethisalbum'] . "\">\r\n\t\t\t\t\t</p>", $artist);
echo '<p align="center">
<input type="hidden" name="artist" value="' . htmlentities($artist) . '">
<input type="hidden" name="title" value="' . htmlentities($title) . '">
<input type="text" name="album" size="' . (strlen($album) + 5) . '" maxlength="60" value="' . htmlentities($album) . '">
<input type="hidden" name="album_db" value="' . htmlentities($db->record['name']) . '">
<input type="hidden" name="content" value="' . htmlentities($content) . '">
<input type="hidden" name="addedby" value="' . htmlentities($addedby) . '">
<input type="hidden" name="confirmed" value="1"><br>
<input type="submit" name="usefromuser" value="' . $lang['add2']['confirmnewalbum'] . '">
</p>
</form>
';
$design->addVar("basic", "PAGECONTENT", $design->getParsedTemplate(""));
$design->displayParsedTemplate("basic");
