include "include/newssearch.php";
$newquery="SELECT * FROM $sitetable WHERE datum > '" . date("Y-m-d", (time()-$timenew)) . "' AND active=1 ORDER BY datum DESC";
if (empty($offset)) $offset=0;
$current=$offset;
$query3=$newquery;
$result3=mysql_db_query($dbname,$query3,$conn);
$total=mysql_numrows($result3);
echo"
neue seiten ($total Neueinträge in den letzten 30 Tagen) |
|
";
$query=$newquery . " LIMIT $offset,$maxrows";
$result=mysql_db_query($dbname,$query,$conn);
$num = $offset+1;
if ($total!=0)
{
while($data2=mysql_fetch_row($result))
{
$indatum = $data2[9];
include("include/time.class.php");
echo"
$num. $data2[1] neu ($data2[7] Klicks) |
$data2[4] |
URL: $data2[2] Eingetrag: $pretty_time Link defekt? | ";
$num++;
}
}
else echo" Leider keine Neueinträge vorhanden.
| ";
echo"
Seite: [ ";
if ($total == 0 )
print " keine ";
elseif ($total > 0){
$zaehlblock = $maxrows;
$offset = 0 - $zaehlblock;
$maxrows = $zaehlblock;
$bloecke = $total / $zaehlblock;
$bloecke = $bloecke + 1;
$count =1;
while ( $count < $bloecke){
$offset = $offset + $zaehlblock;
print "$count ";
$count++;
}
}
echo " ] |
";
include "include/footer.inc";
?>
|
|
include "include/rechts.php"; ?> |