<?php
include("witze_inc.php");
open_database();
if (!isset($page))
$page=1;
$previous_page = $page - 1;
$next_page = $page + 1;
$jokes_per_page = 20;
// ermitteln der Anzahl der verfügbaren Witze
$sql_result = sql("SELECT count(*) FROM witze");
$sql_row = mysql_fetch_array($sql_result, MYSQL_NUM);
$joke_count = $sql_row[0];
$jumping_jokes = ($page - 1) * $jokes_per_page;
// Anzahl der Seiten berechnen
$page_count = (int)(($jokes_per_page + $joke_count - 1) / $jokes_per_page);
// lade Witze für die Seite aus der Datenbank
$sql_jokes = sql("SELECT id, name, hits FROM witze");
function print_link($name, $url, $frame, $available)
{
if ($available)
{
print("<a href=\"$url\" target=\"$frame\">$name</a>");
} // end if
else
{
print($name);
} // end else
} // end function
?>
<html>
<head>
<script language="JavaScript"><!--
function ClickReturn () {
var bAgent = window.navigator.userAgent;
var bAppName = window.navigator.appName;
if ((bAppName.indexOf("Explorer") >= 0) && (bAgent.indexOf("Mozilla/3") >= 0) && (bAgent.indexOf("Mac") >= 0))
return true; // dont follow link
else return false; // dont follow link
}
function OpenWindow(url, width, height) {
var screenX = (screen.width - width) / 2;
var screenY = (screen.height - height) / 2;
var wf = "";
wf = wf + "width=" + width;
wf = wf + ",height=" + height;
wf = wf + ",resizable=no";
wf = wf + ",scrollbars=yes";
wf = wf + ",menubar=no";
wf = wf + ",toolbar=no";
wf = wf + ",directories=no";
wf = wf + ",location=no";
wf = wf + ",status=no";
wf = wf + ",left=" + screenX;
wf = wf + ",top=" + screenY;
window.open(url,'',wf);
}
// --></script>
<title>Sprücheseite Nr. <?= $page ?></title>
</head>
<p align="center"><strong><font size="2"
face="Comic Sans MS">
<?php print_link("Anfang", "witze.php?page=1", "_self", $page!=1); ?>
</font></strong></p>
<div align="center"><center>
<table border="0" width="80%" cellspacing="0" cellpadding="0">
<tr>
<td width="25%" align="center"><p align="left">
<strong><font size="3" face="Comic Sans MS">
<?php print_link("<< zurück", "witze.php?page=$previous_page", "_self", $previous_page>0); ?>
</font></strong>
</td>
<td width="50%" align="center">
<p align="center"><font size="2" face="Comic Sans MS">
<?php
for ($i = 1; $i<=$page_count; $i++)
{
print_link("[$i]", "witze.php?page=$i", "_self", $i != $page);
} // end for
?>
</font></td>
<td width="25%" align="center"><p align="right"><strong><font size="3" face="Comic Sans MS">
<?php print_link("weiter >>", "witze.php?page=$next_page", "_self", $next_page<=$page_count); ?>
</font></strong></td>
</tr>
</table>
</center></div>
<p align="center"> </p>
<div align="center"><center>
<table width="75%" border="1">
<tr>
<td width="9%"><strong><font size="1" face="Comic Sans MS"></font></strong></td>
<td width="81%"><p align="center"><strong><font size="3" face="Comic Sans MS">Sprüche</font></strong></td>
<td width="10%"><p align="center"><font size="2" face="Comic Sans MS"><strong>Besucher</strong></font></td>
</tr>
<?php
for ($i=0; $i<$jumping_jokes; $i++)
{
$sql_row = mysql_fetch_array($sql_jokes, MYSQL_ASSOC);
}
for ($i=0; $i < $jokes_per_page; $i++)
{
if ($sql_row = mysql_fetch_array($sql_jokes, MYSQL_ASSOC))
{
$id = $sql_row[id];
$name = $sql_row[name];
$hits = $sql_row[hits];
} // end if
else
{
break;
} // end else
?>
<tr>
<td><strong><font size="1" face="Comic Sans MS">
<?= $id ?>
</font></strong></td>
<td><strong><font size="1" face="Comic Sans MS">
<a href="#" onclick="OpenWindow('witz.php?id=<?= $id?>',200,200);return ClickReturn();">
<?= $name ?>
</a>
</font></strong></td>
<td><p align="right"><strong><font size="1" face="Comic Sans MS">
<?= $hits ?>
</font></strong></td>
</tr>
<?php } ?>
</table>
</center></div>
<p align="center"> </p>
<p align="center"><strong><font size="2" face="Comic Sans MS">
<?php print_link("Anfang", "witze.php?page=1", "_self", $page!=1); ?>
</font></strong></p>
<div align="center"><center>
<table border="0" width="80%" cellspacing="0" cellpadding="0">
<tr>
<td width="25%" align="center"><p align="left">
<strong><font size="3" face="Comic Sans MS">
<?php print_link("<< zurück", "witze.php?page=$previous_page", "_self", $previous_page>0); ?>
</font></strong>
</td>
<td width="50%" align="center">
<p align="center"><font size="2" face="Comic Sans MS">
<?php
for ($i = 1; $i<=$page_count; $i++)
{
print_link("[$i]", "witze.php?page=$i", "_self", $i != $page);
} // end for
?>
</font></td>
<td width="25%" align="center"><p align="right"><strong><font size="3" face="Comic Sans MS">
<?php print_link("weiter >>", "witze.php?page=$next_page", "_self", $next_page<=$page_count); ?>
</font></strong></td>
</tr>
</table>
</center></div>
</body>
</html>