Codice PHP:
<?php
/*
___________________________________________________
project : asn guestbook version 1.5
file : library.php
author : asn - [email]webmaster@tourdebali.com[/email]
date : 21st may 2002
note : copyright 2002 by asn
___________________________________________________
*/
mysql_connect($host, $user, $pass) or die("Error - Connection to database is not established !");
@mysql_select_db($db) or die("Error - Can't open the database !");
function judul($text) {
echo "<center><font face='verdana, arial, helvetica, sans-serif' size='3' color='$cc0000'>[b]$text[/b]</font><hr size='1' noshade></center>";
}
function pengumuman($text) {
echo "<center>
<font face='verdana, arial, helvetica, sans-serif' size='3' color='$cc0000'>[b]$text[/b]</font></center>";
}
function navigation($pagenumber, $page) {
echo "<table width='100%' border='0' cellspacing='0' cellpadding='5'>
<tr>
<td><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Page : ";
$udah_prev = 0;
$udah_next = 0;
if ($pagenumber == 1) {
echo "<font color='#ff0000'>1</font>";
} else {
if (($udah_prev == 0) and (($page-1) >0)) {
$hal = $page - 1;
$udah_prev = 1;
echo " [url='guestbook.php?page=$hal']<< PREV[/url] ";
}
for ($i=1; $i <= $pagenumber; $i++) {
if ($i == $page) {
echo " <font color='#ff0000'>$page</font> ";
} else {
echo " [url='guestbook.php?page=$i']$i[/url] ";
}
}
if (($udah_next == 0) and (($page + 1) <= $pagenumber)) {
$hal = $page + 1;
$udah_next = 1;
echo " [url='guestbook.php?page=$hal']NEXT >>[/url] ";
}
}
echo "</font>
</td>
</tr>
</table>
";
}
function check_email($email) {
if(!ereg("([[:alnum:]\.\-]+)(\@[[:alnum:]\.\-]+\.+)", $email)) {
erro("Invalid Email Address");
exit;
}
}
function erro($text) {
echo "<center><font face='verdana, arial, sans-serif'>
<font size='4'>[b]$text[/b]</font>
<font size='2'>[url='javascript:history.back()']back[/url]</font>
</center>";
exit;
}
function guestbook_nav() {
echo "
<center><table width='600' border='0' cellspacing='0' cellpadding='0' height='25'>
<tr align='right'>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#000000'>
[url='gbadmin.php?act=part']browse new entry only[/url] | [url='gbadmin.php?act=all']browse all[/url]
</font></td>
</tr>
</table></center>
";
}
function brow($tab) {
echo "
<form method='post' action='gbadmin.php?act=del'>
<center><table width='600' border='0' cellspacing='1' cellpadding='5' bgcolor='#dddddd'>
<tr>
<td align='center'></td>
<td align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#CC0000'>Date</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#CC0000'>Name</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#CC0000'>Gender</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#CC0000'>Email</font></td>
<td></td>
</tr>
";
$query = mysql_query("SELECT * FROM $tab WHERE reply='' ORDER BY id DESC");
$all = mysql_num_rows($query);
for ($i=0 ; $i<=($all - 1) ; $i++) {
$data = mysql_fetch_row($query);
$dt = date("d M Y", $data[0]);
echo "
<tr bgcolor='#FFFFFF'>
<td align='center'><input type=checkbox name=check[$i]><input type=hidden name=id[$i] value=$data[7]></td>
<td align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$dt</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$data[1]</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$data[4]</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$data[2]</font></td>
<td align='center'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>[url='gbadmin.php?act=jawab&id=$data[7]']reply[/url]</font></td>
</tr>
";
}
echo "
</table>
<table width='600' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td>
<input type='submit' value='Delete Checked Record'>
</td>
<td align='right' valign='top'>
<font size='1' face='Verdana, Arial, Helvetica, sans-serif'>total new entry : <font color='#ff0000'>$all</font></font>
</td>
</tr>
</table>
</center>
</form>
";
}
function brow_all($tab) {
echo "
<form method='post' action='gbadmin.php?act=delall'>
<center><table width='600' border='0' cellspacing='1' cellpadding='5' bgcolor='#dddddd'>
<tr>
<td align='center'></td>
<td align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#CC0000'>Date</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#CC0000'>Name</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#CC0000'>Gender</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#CC0000'>Status</font></td>
<td></td>
<td></td>
</tr>
";
$query = mysql_query("SELECT * FROM $tab ORDER BY id DESC");
$all = mysql_num_rows($query);
for ($i=0 ; $i<=($all - 1) ; $i++) {
$data = mysql_fetch_row($query);
$dt = date("d M Y", $data[0]);
if ($data[6] == "") $status = "new"; else $status = "replied";
echo "
<tr bgcolor='#FFFFFF'>
<td align='center'><input type=checkbox name=check[$i]><input type=hidden name=id[$i] value=$data[7]></td>
<td align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$dt</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$data[1]</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$data[4]</font></td>
<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$status</font></td>
<td align='center'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>[url='gbadmin.php?act=detil&id=$data[7]']detail[/url]</font></td>
<td align='center'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>";
if ($data[6] == "") echo "[url='gbadmin.php?act=jawab&id=$data[7]']reply[/url]";
echo "
</font></td>
</tr>
";
}
echo "
</table>
<table width='600' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td>
<input type='submit' value='Delete Checked Record'>
</td>
<td align='right' valign='top'>
<font size='1' face='Verdana, Arial, Helvetica, sans-serif'>total entry : <font color='#ff0000'>$all</font></font>
</td>
</tr>
</table>
</center>
</form>
";
}
function smile($message) {
global $url_smiles;
$message = ' ' . $message;
if ($getsmiles = mysql_query("SELECT *, length(code) as length FROM asnsmile ORDER BY length DESC"))
{
while ($smiles = mysql_fetch_array($getsmiles))
{
$smile_code = preg_quote($smiles[code]);
$smile_code = str_replace('/', '//', $smile_code);
$message = preg_replace("/([\n\\ \\.])$smile_code/si", '\1[img]' . $url_smiles . '/' . $smiles[url] . '[/img]', $message);
}
}
$message = substr($message, 1);
return($message);
}
function auto_url($text) {
$ret = " " . $text;
$ret = preg_replace("#([\n ])([a-z]+?)://([^, \n\r]+)#i", "\\1<a href=\"\\2://\\3\" target=\"_blank\">\\2://\\3</a>", $ret);
$ret = preg_replace("#([\n ])www\.([a-z0-9\-]+)\.([a-z0-9\-.\~]+)((?:/[^, \n\r]*)?)#i", "\\1<a href=\"http://www.\\2.\\3\\4\" target=\"_blank\">[url]www.\\2.\\3\\4[/url]</a>", $ret);
$ret = preg_replace("#([\n ])([a-z0-9\-_.]+?)@([^, \n\r]+)#i", "\\1<a href=\"mailto:\\2@\\3\">\\2@\\3</a>", $ret);
$ret = substr($ret, 1);
return($ret);
}
?>