$tee = time(); ?>
Leave a message!
$sql = array(
"host" => "mmdsql01",
"user" => "dynabeat",
"pass" => "7KWXk7X2",
"db" => "dynabeat"
);
/*
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| i | bigint(20) | | PRI | NULL | auto_increment |
| timestamp | bigint(20) | | | 0 | |
| subject | varchar(255) | | | | |
| message | text | | | | |
| userdata | text | | | | |
| sender_name | varchar(255) | | | | |
| sender_email | varchar(255) | | | | |
| admin_ans | text | | | | |
| sender_www | varchar(255) | | | | |
+--------------+--------------+------+-----+---------+----------------+
*/
mysql_pconnect($sql["host"], $sql["user"], $sql["pass"]);
mysql_select_db($sql["db"]);
switch($a) {
case "write":
if (strtoupper($s_z) == "H4Z") {
if (md5($t."skeppi") == $tcheck) {
$sth = mysql_db_query($sql["db"], "select i from guestbook where timestamp=".$t);
if (!mysql_fetch_array($sth)) {
mysql_query("insert into guestbook (timestamp, message, userdata, sender_name, sender_email, sender_www) values ($t, '$message', '".$REMOTE_HOST." - ".$REMOTE_ADDR."', '$s_name', '$s_email', '".rawurlencode($s_www)."')");
}
}
} else {
}
$h = "list";
break;
default:
$h = "list";
break;
}
switch($h) {
default:
$tee = time();
?>
if ($q_limit == "no") {
$sth = mysql_db_query($sql["db"], "select i,timestamp,subject,message,sender_name,sender_email,admin_ans,sender_www from guestbook order by i desc");
} else {
$sth = mysql_db_query($sql["db"], "select i,timestamp,subject,message,sender_name,sender_email,admin_ans,sender_www from guestbook order by i desc limit 10");
}
while ($row = mysql_fetch_array($sth)) {
$m_msg = htmlspecialchars($row[3]);
$m_msg = eregi_replace(":)", " ", $m_msg);
$m_msg = eregi_replace(":-)", " ", $m_msg);
$m_msg = eregi_replace(":\(", " ", $m_msg);
$m_msg = eregi_replace(":-\(", " ", $m_msg);
$m_msg = eregi_replace(";)", " ", $m_msg);
$m_msg = eregi_replace(";-)", " ", $m_msg);
$m_msg = eregi_replace(":d", " ", $m_msg);
$m_msg = eregi_replace(":p", " ", $m_msg);
if ($row[5] != "") { $a1 = ""; $a2 = ""; }
print "".date("d M Y - H:i", $row[1])."";
print " ".$m_msg." ";
print "".htmlspecialchars($row[4])."";
if ($row[7] != "") {
print " | ".rawurldecode($row[7])."";
}
print " \n";
if ($row[6] != "") { print " ".$row[6]."
\n"; }
print " \n";
}
break;
}
?>
if ($q_limit == "no") {
?>
Showing all entries.
} else {
?>Only 10 latest entries shown. Click here to show all
entries.
}
?>

|