= 10) {
?>
|
|
|
|
' . mysql_error() . '';
else $table_exists = true;
}
else if($create == 'no') {
echo ' Operation cancelled. ';
}
else {
echo '';
echo ' ';
}
}
else $table_exists = true;
if($table_exists) {
if($admin && $admin != $_SESSION['gb_admin']) $error = $msg['wrongPass'];
else if($_SESSION['gb_admin'] && $_SESSION['gb_admin'] == $adminPass && $delete) {
$sql = "DELETE FROM $tbl_name WHERE $fld_id='$delete'";
if(!mysql_query($sql)) $error = mysql_error();
}
else if($sign == 2) {
if(!$gbSubject || !$gbText) $error = $msg['required'];
else if(checkSpam($gbID, $tstamp, $gbName, $gbEMail, $gbSubject, $gbText, $gbSignature)) $error = $msg['noSpam'];
else {
if(!get_magic_quotes_gpc()) {
$gbName = addslashes($gbName);
$gbEMail = addslashes($gbEMail);
$gbSubject = addslashes($gbSubject);
$gbText = addslashes($gbText);
}
if($enableSignature) $_SESSION['secCode'] = rand(100000, 999999);
$timestamp = date('YmdHis', time() - 60 * 60);
$sql = "SELECT $fld_id FROM $tbl_name WHERE $fld_timestamp>$timestamp AND $fld_name='$gbName' ";
$sql .= "AND $fld_email='$gbEMail' AND $fld_subject='$gbSubject' AND $fld_text='$gbText' LIMIT 1";
if(mysql_num_rows(mysql_query($sql))) {
$sign = 0;
$start = ($messageOrder == 'ASC') ? -1 : 0;
}
else {
$timestamp = date('YmdHis');
$sql = "INSERT INTO $tbl_name ($fld_timestamp, $fld_name, $fld_email, $fld_subject, $fld_text) ";
$sql .= "VALUES ('$timestamp', '$gbName', '$gbEMail', '$gbSubject', '$gbText')";
if(!mysql_query($sql)) $error = mysql_error();
else {
$sign = 0;
$start = ($messageOrder == 'ASC') ? -1 : 0;
if($maxEntries > 0) {
$sql = "SELECT $fld_id FROM $tbl_name ORDER BY $fld_timestamp DESC LIMIT $maxEntries, 1";
if($result = mysql_query($sql)) {
if(mysql_num_rows($result)) {
if($row = mysql_fetch_row($result)) {
$sql = "DELETE FROM $tbl_name WHERE $fld_id<=$row[0]";
if(!mysql_query($sql)) $error = mysql_error();
}
}
}
}
if(preg_match($valid_mail, $mailNotify)) {
$text = $msg['date'] . ": $timestamp\n";
$text .= $msg['name'] . ": $gbName\n";
$text .= $msg['eMail'] . ": $gbEMail\n\n";
$text .= "$gbSubject\n\n$gbText";
$headers = "Return-Path: <$mailNotify>\n";
$headers .= "From: $bookTitle <$mailNotify>\n";
$headers .= "X-Sender: <$mailNotify>\n";
$headers .= "X-Mailer: PHP " . phpversion();
@mail($mailNotify, $msg['new'], stripslashes($text), $headers);
}
}
}
}
}
if($error) {
?>
)">
No messages.
|
||||||||||||