Tweet
document.writeln("<?php dbEntries(); ?>");
<?php
function dbEntries() {
$database = "db";
$sqlhost = "localhost";
$sqluser = "user";
$sqlpass = "pw";
$serverid = @mysql_connect ( $sqlhost, $sqluser, $sqlpass) or die ("Konnte nicht zum MySQL-Server verbinden");
if (!mysql_select_db( $database)) { echo mysql_error($serverid); }
if ($action != '' && $action != 'none') {
$abfrage = "SELECT pid FROM forum_posts ORDER BY pid DESC";
$count = "0";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis)) {
$pid = $row->pid; $count++;
if ($count == "100") {
$loeschen = "DELETE FROM forum_posts WHERE pid = '$pid'";
$loesch = mysql_query($loeschen);
}
}
$abfrage = "SELECT pid FROM forum_posts";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis)) {
$pid = $row->pid;
}
if(empty($pid1)) {
$pid = " . ";
}
}
if ($history) { $abfrage = "SELECT pid FROM forum_posts"; }
else { $abfrage = "SELECT pid FROM forum_posts "; }
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis)) {
$timestamp = $row->timestamp;
$pid = $row->pid;
$timestamp = date('d.m.y - H:i', $timestamp);
echo "<table width=150 border=0 align=center cellpadding=3 cellspacing=0 class=table1><tr><td><div align=center>$name :: $timestamp<br><br></div><table width=100% border=0 cellpadding=1 cellspacing=0 class=table2><tr><td>$pid</td></tr></table></td></tr></table><br>";
}
mysql_close($serverid);
} ?>
<body bgcolor="#F7F9FB">
document.write('<? dbEntries(); ?>');
<?php
Moderator
Kommentar