Execute("SELECT * FROM $pntable[guestbook]"); $guest_num = $result->RecordCount(); // Show headers OpenTable(); echo "
"._GUESTWELCOME . "

" .""._GUESTTHANKS."

" ."
"; CloseTable(); echo "
"; // Show IP for administrator only OpenTable(); if ($ipcheck) { if(is_admin($admin)) { $column = &$pntable['guestbook_column']; $result = $dbconn->Execute("SELECT $column[ip] FROM $pntable[guestbook] WHERE $column[id_msg]='$id_msg'"); list($ip) = $result->fields; echo "
"._GUESTIP."

" ."$ip


" .""._GUESTBACK."
"; CloseTable(); include "footer.php"; die; } } // Delete message for administrator only OpenTable(); if ($delete) { if(is_admin($admin)) { $column = &$pntable['guestbook_column']; if (!$sure){ $result = $dbconn->Execute ("SELECT $column[id_msg],$column[name],$column[email],$column[ip],$column[message],$column[icq],$column[homepage],UNIX_TIMESTAMP($column[bdate]),$column[members],$column[private] FROM $pntable[guestbook] WHERE $column[id_msg]='$id_msg'"); while(list($id_msg,$name,$email,$ip,$message,$icq,$homepage,$bdate,$members,$private)=$result->fields) { $result->MoveNext(); $dcolor = ($a == 0 ? $dcolor_A : $dcolor_B); echo ""; $time = strftime(_GUESTDATETIME, $bdate); echo " $name"; echo "\"\" "._GUESTSIGNON." ".$time."
"; $message=nl2br($message); $message=stripslashes($message); $message=smile($message); echo "
$message" ."
"; echo _GUESTDELETE . "  [" . _GUESTYES . "]   " . _GUESTOR . "   [" . _GUESTNO . "]
"; CloseTable(); CloseTable(); include "footer.php"; die; } } else { $result = $dbconn->Execute ("DELETE FROM $pntable[guestbook] WHERE $column[id_msg]='$id_msg'"); echo "" . _GUESTDELETED . " " .""._GUESTBACK.""; CloseTable(); CloseTable(); include "footer.php"; die; } } } // Insert data into the database if (!$private) { $private=0; } $ip=$REMOTE_ADDR; $hote=gethostbyaddr($ip); $time = date("Y/m/d H:i"); if($gname){ if($email){ $email_tmp=ereg("^[_[:alnum:]-]+(\.[_[:alnum:]-]+)*@[[:alnum:]-]+(\.[[:alpha:]]+)+$",$email); if($email_tmp==0) { echo ""._GUESTBADEMAIL.""; die; } } if(!$message){ echo ""._GUESTERRMSG.""; die; } $column = &$pntable['guestbook_column']; $result = $dbconn->Execute("INSERT INTO $pntable[guestbook] ($column[name],$column[email],$column[ip],$column[message],$column[icq],$column[homepage],$column[bdate],$column[members],$column[private]) VALUES ('$gname','$email','$ip','$message','$icq','$homepage','$time','$members','$private')"); } // Sign Guestbook Forms if ($rub=="signer") { echo "" ."
" .""._GUESTVIEW."" ."
" ."" ."
" ."" ."" ."" ."
" ."" ."" .""; } else { echo ""._GUESTNAME."" .""; } echo "" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."
"; if ($user) { $userdata=cookiedecode($user); echo ""._GUESTNAME."$userdata[1]
"._GUESTEMAIL."
"._GUESTUIN."
"._GUESTWEBSITE."
"._GUESTMSG."
"._GUESTPRIVATE."
 
" ."
" ."
"; CloseTable(); CloseTable(); include("footer.php"); die; } else { echo "" ."
" .""._GUESTSIGN."" ."

"; } ?> " ."
"> Execute ("SELECT * FROM $pntable[guestbook]"); $total = $result->RecordCount(); } $a = 0; $dcolor_A = "$bgcolor2"; $dcolor_B = "$bgcolor1"; $debut = ($page - 1) * $nb; $result = $dbconn->Execute ("SELECT $column[id_msg],$column[name],$column[email],$column[ip],$column[message],$column[icq],$column[homepage],UNIX_TIMESTAMP($column[bdate]),$column[members],$column[private] FROM $pntable[guestbook] ORDER BY $column[id_msg] DESC LIMIT $debut,$nb"); while(list($id_msg,$name,$email,$ip,$message,$icq,$homepage,$bdate,$members,$private)=$result->fields) { $result->MoveNext(); $dcolor = ($a == 0 ? $dcolor_A : $dcolor_B); echo ""; echo "">"; } else { echo ""; } $a = ($dcolor == $dcolor_A ? 1 : 0); } echo "
"; $time = strftime(_GUESTDATETIME, $bdate); echo " $name\"\" "._GUESTSIGNON." ".$time."
"; if(is_admin($admin)) { $message=nl2br($message); $message=stripslashes($message); $message=smile($message); } else { if ($private) { $message = "
• "._GUESTPRV." •
"; } $message=nl2br($message); $message=stripslashes($message); $message=smile($message); } ?>
" ."\"$name"; } if($icq>0) { echo ""; } if($email!="") { echo "\"email\""; } if($homepage!="" && $homepage!="http://") { echo "\"HomePage\""; } if(is_admin($admin)) { echo " \"Delete \"Logged
" ."
" .'' ."" .'
'; $nbpages = ceil($total / $nb); echo "["; for($i = 1;$i <= $nbpages;$i ++){ if ($i==1) { echo " $i "; } else { echo " $i "; } if($i < $nbpages) { echo " . "; } } echo " ]
"; CloseTable(); CloseTable(); echo "
" . _GUESTTOTALREC." $guest_num"; include("footer.php"); ?>