\n";
echo" \n";
echo" \n";
echo" \n";
echo" \n";
if ($action=="add") {
echo " \n";
echo " \n";
echo " \n";
echo " ";
echo "  | ";
echo " | ";
echo " ";
echo " | ";
genheader($username,$password,$imgnow);
echo " | \n";
echo " \n";
echo " $gb_link1head \n";
echo " | \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " ";
echo " | ";
echo " | ";
echo " ";
echo " | ";
genheader($username,$password,$imgnow);
echo " | \n";
echo " \n";
echo " ";
echo " $gb_link5 || ";
echo " $gb_link2head | \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " $gb_link3\n";
echo " $gb_link4\n";
echo " $gb_link6\n";
echo " \n";
echo " \n";
echo " | \n";
echo " $guestbook_head \n";
echo " | \n";
echo " \n";
echo " ";
echo " $gb_link5 || ";
echo " $gb_link2 || ";
echo " $gb_link3head | \n";
echo " \n";
echo " \n";
$count=0;
$result = mysql_db_query($database, "select * from badwords") or die("Database Query Error");
echo "
\n";
echo " \n";
echo " | \n";
echo " ";
echo " | \n";
echo " \n";
echo " \n";
echo " | \n";
echo " \n";
echo " \n";
while ($db = mysql_fetch_array($result)) {
echo " \n";
echo " \n";
echo " | \n";
echo " $db[badword] ";
echo " | \n";
echo " \n";
echo " \n";
echo " | \n";
echo " \n";
echo " \n";
$count++;
}
echo "
$count $gb_link4stat
\n";
} elseif ($action == "edit_badword" || $action == "new_badword" && $admin==$adminpass) {
echo " \n";
echo " \n";
echo " \n";
echo " ";
echo " | ";
echo " | ";
echo " ";
echo " | ";
genheader($username,$password,$imgnow);
echo " | \n";
echo " \n";
echo " ";
echo " $gb_link5 || ";
echo " $gb_link2 || ";
echo " $gb_link3head | \n";
echo " \n";
echo " \n";
echo "\n";
} elseif ($action == "save_edit_badword" && $admin==$adminpass) {
$result = mysql_db_query($database, "UPDATE badwords SET badword='$newvalue' WHERE badword='$value'") or die("Database Query Error");
echo "\n";
} elseif ($action == "save_new_badword" && $admin==$adminpass) {
$result = mysql_db_query($database, "INSERT INTO badwords (badword) VALUES('$newvalue')") or die("Database Query Error");
echo "\n";
} elseif ($action == "delete_badword" && $admin==$adminpass) {
$result = mysql_db_query($database, "DELETE FROM badwords WHERE badword='$value'") or die("Database Query Error");
echo "\n";
} elseif ($action == "banned_ips" && $admin==$adminpass) {
echo " \n";
echo " \n";
echo " \n";
echo " ";
echo " | ";
echo " | ";
echo " ";
echo " | ";
genheader($username,$password,$imgnow);
echo " | \n";
echo " \n";
echo " ";
echo " $gb_link5 || ";
echo " $gb_link2 || ";
echo " $gb_link4head | \n";
echo " \n";
echo " \n";
$count=0;
$result = mysql_db_query($database, "select * from banned_ips") or die("Database Query Error");
echo "
\n";
echo " \n";
echo " | \n";
echo " ";
echo " | \n";
echo " \n";
echo " \n";
echo " | \n";
echo " \n";
echo " \n";
while ($db = mysql_fetch_array($result)) {
echo " \n";
echo " \n";
echo " | \n";
echo " $db[0] ";
echo " | \n";
echo " \n";
echo " \n";
echo " | \n";
echo " \n";
echo " \n";
$count++;
}
echo "
$count $gb_link4stat
\n";
} elseif ($action == "edit_banned_ip" || $action == "new_banned_ip") {
echo " \n";
echo " \n";
echo " \n";
echo " ";
echo " | ";
echo " | ";
echo " ";
echo " | ";
genheader($username,$password,$imgnow);
echo " | \n";
echo " \n";
echo " ";
echo " $gb_link5 || ";
echo " $gb_link2 || ";
echo " $gb_link4head | \n";
echo " \n";
echo " \n";
echo "\n";
} elseif ($action == "save_edit_banned_ip" && $admin==$adminpass) {
$result = mysql_db_query($database, "UPDATE banned_ips SET banned_ip='$newvalue' WHERE banned_ip='$value'") or die("Database Query Error");
echo "\n";
} elseif ($action == "save_new_banned_ip" && $admin==$adminpass) {
$result = mysql_db_query($database, "INSERT INTO banned_ips (banned_ip) VALUES('$newvalue')") or die("Database Query Error");
echo "\n";
} elseif ($action == "delete_banned_ip" && $admin==$adminpass) {
$result = mysql_db_query($database, "DELETE FROM banned_ips WHERE banned_ip='$value'") or die("Database Query Error");
echo "\n";
} elseif ($action == "bookusers" && $admin==$adminpass) {
echo " \n";
echo " \n";
echo " | \n";
echo " $guestbook_head \n";
echo " | \n";
echo " \n";
echo " ";
echo " $gb_link5 || ";
echo " $gb_link2 || ";
echo " $gb_link6head | \n";
echo " \n";
echo " \n";
$count=0;
$result = mysql_db_query($database, "select * from bookuser") or die("Database Query Error");
echo "
\n";
echo " \n";
echo "username | \n";
echo "password | \n";
echo "usergroup | \n";
echo "power | \n";
echo " \n";
echo " \n";
echo " | \n";
echo " \n";
echo " \n";
while ($db = mysql_fetch_array($result)) {
echo " \n";
echo " \n";
echo " | \n";
echo " $db[username] ";
echo " | \n";
echo " \n";
echo " $db[passwd] ";
echo " | \n";
echo " \n";
echo " $db[usergroup] ";
echo " | \n";
echo " \n";
echo " $db[power] ";
echo " | \n";
echo " \n";
echo " \n";
echo " | \n";
echo " \n";
echo " \n";
$count++;
}
echo "
$count $gb_link6stat
\n";
} elseif ($action == "edit_bookuser" || $action == "new_bookuser" && $admin==$adminpass) {
echo " \n";
echo " \n";
echo " \n";
echo " ";
echo " | ";
echo " | ";
echo " ";
echo " | ";
genheader($username,$password,$imgnow);
echo " | \n";
echo " \n";
echo " ";
echo " $gb_link5 || ";
echo " $gb_link2 || ";
echo " $gb_link6head | \n";
echo " \n";
echo " \n";
echo "\n";
} elseif ($action == "save_edit_bookuser" && $admin==$adminpass) {
$result = mysql_db_query($database, "UPDATE bookuser SET username='$newvalue1',passwd='$newvalue2',usergroup='$newvalue3',power='$newvalue4' WHERE username='$value1' and passwd='$value2'") or die("Database Query Error");
echo "\n";
} elseif ($action == "save_new_bookuser" && $admin==$adminpass) {
$result = mysql_db_query($database, "INSERT INTO bookuser (username,passwd,usergroup,power) VALUES('$newvalue1','$newvalue2','$newvalue3','$newvalue4')") or die("Database Query Error");
echo "\n";
} elseif ($action == "delete_bookuser" && $admin==$adminpass) {
$result = mysql_db_query($database, "DELETE FROM bookuser WHERE username='$value1' and passwd='$value2'") or die("Database Query Error");
echo "\n";
} else {
if ($admin) {$adminlink="&admin=$admin";}
echo " \n";
echo " \n";
echo " \n";
echo " ";
echo " | ";
echo " | ";
echo " ";
echo " | ";
genheader($username,$password,$imgnow);
echo " | \n";
echo " \n";
echo " \n";
if ($admin==$adminpass) {
echo " $gb_link2 || \n";
}
if ($phpbookcookie==$guestbook_head && $admin!=$adminpass) {
echo " $gb_link1\n";
} else {
echo " $gb_link1\n";
}
echo " | \n";
echo " \n";
echo " \n";
echo " \n";
# Start with Output
#################################################################################################
echo " \n";
echo "\n";
if ($imgnow == 2){
echo "$gbboard2
\n";
} elseif ($imgnow == 3){
echo "$gbboard3
\n";
} else {
echo "$gbboard1
\n";
}
echo " | \n";
# Calculate Page-Numbers
#################################################################################################
if (empty($perpage)) $perpage = 1;
if (empty($pperpage)) $pperpage = 9; //!!! ONLY 5,7,9,11,13 !!!!
if (empty($sort)) $sort = "desc";
if (empty($offset)) $offset = 0;
if (empty($poffset)) $poffset = 0;
if ($imgnow == 2){
if ($admin == $adminpass){
$amount = mysql_db_query($database, "SELECT count(*) FROM guestbook WHERE usergroup = 2");
} else {
$amount = mysql_db_query($database, "SELECT count(*) FROM guestbook WHERE usergroup = 2 AND username = '$username' AND passwd = '$password'");
}
} elseif ($imgnow == 3){
$amount = mysql_db_query($database, "SELECT count(*) FROM guestbook WHERE usergroup = 3");
} else {
$amount = mysql_db_query($database, "SELECT count(*) FROM guestbook WHERE usergroup < 2");
}
$amount = mysql_db_query($database, "SELECT count(*) FROM guestbook");
$amount_array = mysql_fetch_array($amount);
$pages = ceil($amount_array["0"] / $perpage);
$actpage = ($offset+$perpage)/$perpage;
$maxoffset = ($pages-1)*$perpage;
$maxpoffset = $pages-$pperpage;
$middlepage=($pperpage-1)/2;
if ($maxpoffset<0) {$maxpoffset=0;}
echo "\n";
if ($pages) { // print only when pages > 0
echo "$ad_pages\n";
if ($offset) {
$noffset=$offset-$perpage;
$npoffset = $noffset/$perpage-$middlepage;
if ($npoffset<0) {$npoffset=0;}
if ($npoffset>$maxpoffset) {$npoffset = $maxpoffset;}
echo "[ <<] ";
echo "[ <] ";
}
for($i = $poffset; $i< $poffset+$pperpage && $i < $pages; $i++) {
$noffset = $i * $perpage;
$npoffset = $noffset/$perpage-$middlepage;
if ($npoffset<0) {$npoffset = 0;}
if ($npoffset>$maxpoffset) {$npoffset = $maxpoffset;}
$actual = $i + 1;
if ($actual==$actpage) {
echo "( $actual) ";
} else {
echo "[ $actual] ";
}
}
if ($offset+$perpage<$amount_array["0"]) {
$noffset=$offset+$perpage;
$npoffset = $noffset/$perpage-$middlepage;
if ($npoffset<0) {$npoffset=0;}
if ($npoffset>$maxpoffset) {$npoffset = $maxpoffset;}
echo "[ >] ";
echo "[ >>] ";
}
}
echo " | \n";
echo " \n";
# Start the Page
#################################################################################################
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
# Get actions for current page
#################################################################################################
if ($imgnow == 2){
if ($admin == $adminpass){
$result = mysql_db_query($database, "SELECT * FROM guestbook WHERE usergroup = 2 ORDER by id $sort LIMIT $offset, $perpage");
} else {
$result = mysql_db_query($database, "SELECT * FROM guestbook WHERE usergroup = 2 AND username = '$username' AND passwd = '$password' ORDER by id $sort LIMIT $offset, $perpage");
}
} elseif ($imgnow == 3){
$result = mysql_db_query($database, "SELECT * FROM guestbook WHERE usergroup = 3 ORDER by id $sort LIMIT $offset, $perpage");
} else {
$result = mysql_db_query($database, "SELECT * FROM guestbook WHERE usergroup < 2 ORDER by id $sort LIMIT $offset, $perpage");
}
while ($db = mysql_fetch_array($result)) {
if ($dateformat=="eu")
{ // European Date & Timeformat
$when = strftime("%d.%m.%Y %H:%M", $db["timestamp"]);
} else { // US Date & Timeformat
$when = strftime("%m/%d/%Y %I:%M %p", $db["timestamp"]);
}
if ($db[email] != "none") {
$email = "![\"$send_email\"](\"$image_dir/icons/email.gif\") ";
} else {
$email = "";
}
if ($db[icq] != 0) {
$icq = "![\"$icq_message\"](\"http://wwp.icq.com/scripts/online.dll?icq=") ";
} else {
$icq = "";
}
if ($db[http] != "none") {
$http = "![\"$view_homepage\"](\"$image_dir/icons/home.gif\") ";
} else {
$http = "";
}
if ($db[ip] != "none") {
if ($admin==$adminpass) {
$ip = "![\"".$db[ip]."\"](\"$image_dir/icons/ip.gif\") ";
} else {
$ip = "";
}
} else {
$ip = "";
}
if ($db[location]!= "none") {
$location = "$gb_location
$db[location]
";
} else {
$location = "
";
}
if ($db[browser] != "") {
$browser = "![\"$db[browser]\"](\"$image_dir/icons/browser.gif\") ";
} else {
$browser = "";
}
echo " \n";
echo " | \n";
echo " $db[name]
\n";
echo " $location
\n";
echo "
$icq $http $email $ip $browser\n";
echo " | \n";
echo " \n";
if ($admin==$adminpass) {
echo " ![\"$moderator_del_entry\"](\"$image_dir/icons/trash.gif\") ";
echo " ![\"$moderator_del_comment\"](\"$image_dir/icons/trashcomment.gif\") ";
echo " ![\"$moderator_edit_comment\"](\"$image_dir/icons/comment.gif\") ";
echo " \n";
}
echo " $gb_posted $when ¡@¡¹$db[ip]
".censor_msg($db[message],($admin==$adminpass))." \n";
if($commentid == $db[id] && $action!="changed" && $admin==$adminpass) {
echo " \n";
echo " \n";
} elseif(!empty($db[comment])) {
echo " \n";
}
echo " | \n \n";
}
# End of Page reached
#################################################################################################
echo" \n";
echo" | \n";
echo" \n";
echo" \n";
echo" | \n";
echo" \n";
echo" \n";
echo" \n";
echo"
\n";
if ($show_sysinfo) {
list($usec, $sec) = explode(" ",$proctime_start);
$proctime_start = $usec+$sec;
list($usec, $sec) = explode(" ",microtime());
$proctime_end = $usec+$sec;
$proctime = $proctime_end-$proctime_start;
$query = mysql_db_query($database, "SELECT id FROM guestbook");
$countall=mysql_num_rows($query);
echo"\n";
}
# PLEASE DO NOT REMOVE OR EDIT THIS COPYRIGHT-NOTICE !!! THANKS !!! ################################################
echo"\n";
#####################################################################################################################
echo"\n";
echo" | \n";
echo" \n";
echo" \n";
echo"\n";
echo"\n";
}
# Disconnect DB
#################################################################################################
mysql_close();
if ($support==$supportpwd && $supportpwd) {echo "
"; phpinfo();}
?> | | | | | | |