Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1324
  • Last Modified:

Database Query Error

Hi:

I installed a php guestbook, when I tried to add any entry as a guest, it shows the following error :

Database Query Error

Here is the database table structure :

------------------------------------------------
# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Oct 07, 2004 at 01:29 PM
# Server version: 4.0.20
# PHP Version: 4.2.3
#
# Database : `webtech_gb`
#

# --------------------------------------------------------

#
# Table structure for table `badwords`
#

CREATE TABLE `badwords` (
  `badword` varchar(25) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table `badwords`
#

INSERT INTO `badwords` VALUES ('****');
INSERT INTO `badwords` VALUES ('schweinehund');
INSERT INTO `badwords` VALUES ('****ing');
INSERT INTO `badwords` VALUES ('****');
INSERT INTO `badwords` VALUES ('piss');
INSERT INTO `badwords` VALUES ('kutta');

# --------------------------------------------------------

#
# Table structure for table `banned_ips`
#

CREATE TABLE `banned_ips` (
  `banned_ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`banned_ip`)
) TYPE=MyISAM;

#
# Dumping data for table `banned_ips`
#


# --------------------------------------------------------

#
# Table structure for table `guestbook`
#

CREATE TABLE `guestbook` (
  `id` int(5) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL default '',
  `email` varchar(35) NOT NULL default '',
  `icq` int(11) NOT NULL default '0',
  `http` varchar(50) NOT NULL default '',
  `message` mediumtext NOT NULL,
  `timestamp` int(11) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `location` varchar(35) NOT NULL default '',
  `browser` varchar(50) NOT NULL default '',
  `comment` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `guestbook`
#


# --------------------------------------------------------

#
# Table structure for table `smilies`
#

CREATE TABLE `smilies` (
  `code` char(3) NOT NULL default '',
  `file` varchar(15) NOT NULL default '',
  `name` varchar(25) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table `smilies`
#

INSERT INTO `smilies` VALUES (':)', 'smile.gif', 'Smile');
INSERT INTO `smilies` VALUES (':-)', 'smile.gif', 'Smile');
INSERT INTO `smilies` VALUES (':))', 'lol.gif', 'LOL');
INSERT INTO `smilies` VALUES (';)', 'wink.gif', 'Winkywinky');
INSERT INTO `smilies` VALUES (';-)', 'wink.gif', 'Winkywinky');
INSERT INTO `smilies` VALUES (':(', 'frown.gif', 'Frown');
INSERT INTO `smilies` VALUES (':-(', 'frown.gif', 'Frown');
INSERT INTO `smilies` VALUES (':[', 'mad.gif', 'Mad');
INSERT INTO `smilies` VALUES (':z)', 'grazy.gif', 'Grazy');
INSERT INTO `smilies` VALUES (':y)', 'crying.gif', 'Crying');
INSERT INTO `smilies` VALUES (':o)', 'sleepy.gif', 'Sleepy');
INSERT INTO `smilies` VALUES (':a)', 'alien.gif', 'Alien');
INSERT INTO `smilies` VALUES (':s)', 'smokie.gif', 'Smokie');
INSERT INTO `smilies` VALUES (':l)', 'love.gif', 'Loooove');
INSERT INTO `smilies` VALUES (':L)', 'love2.gif', 'Loooooooooove');
INSERT INTO `smilies` VALUES (':]', 'biggrin.gif', 'Big Smile');
INSERT INTO `smilies` VALUES (':-/', 'bounce.gif', 'Bounce');
INSERT INTO `smilies` VALUES (':b)', 'burnout.gif', 'Burnout');
INSERT INTO `smilies` VALUES (':&)', 'clown.gif', 'Clown');
INSERT INTO `smilies` VALUES (':?)', 'confused.gif', 'Confused');
INSERT INTO `smilies` VALUES (':c)', 'cool.gif', 'Cooooooool');
INSERT INTO `smilies` VALUES (':e)', 'eek.gif', 'Eeeeeeek');
INSERT INTO `smilies` VALUES (':f)', 'flash.gif', 'Flash');
INSERT INTO `smilies` VALUES (':g)', 'girl.gif', 'Girl');
INSERT INTO `smilies` VALUES (':i)', 'idee.gif', 'Idea');
INSERT INTO `smilies` VALUES (':r)', 'redface.gif', 'Redface');
INSERT INTO `smilies` VALUES (':8)', 'rolleyes.gif', 'RollEyes');
INSERT INTO `smilies` VALUES (':}', 'tongue.gif', 'Tongue');
INSERT INTO `smilies` VALUES (':t)', 'tasty.gif', 'Tasty');
INSERT INTO `smilies` VALUES (':1)', 'alien2.gif', 'invader');
INSERT INTO `smilies` VALUES (':2)', 'kitty.gif', 'Bastard Kitty');
INSERT INTO `smilies` VALUES (':3)', 'heart.gif', 'Heart1');
INSERT INTO `smilies` VALUES (':4)', 'rainbow.gif', 'tie died');
INSERT INTO `smilies` VALUES (':5)', 'el.gif', 'Embarrassed');
INSERT INTO `smilies` VALUES (':6)', 'pumpkin2.gif', 'Helloween');
INSERT INTO `smilies` VALUES (':7)', 'private.gif', 'Secret');
INSERT INTO `smilies` VALUES (':x)', 'xmas.gif', 'Christmas');
INSERT INTO `smilies` VALUES (':9)', 'kiss.gif', 'Kiss, Kiss');
INSERT INTO `smilies` VALUES (':1]', 'karate.gif', 'Karate');
INSERT INTO `smilies` VALUES (':2]', 'cold.gif', 'Cold');
INSERT INTO `smilies` VALUES (':3]', 'devil.gif', 'Devil');
INSERT INTO `smilies` VALUES (':4]', 'tongue2.gif', 'So Nyah!');
INSERT INTO `smilies` VALUES (':5]', 'redhot.gif', 'Red Hot');
INSERT INTO `smilies` VALUES (':6]', 'smash.gif', 'Smash!');
INSERT INTO `smilies` VALUES (':7]', 'frosty.gif', 'Frosty');
INSERT INTO `smilies` VALUES (':8]', 'confused2.gif', 'Confused again');
INSERT INTO `smilies` VALUES (':9]', 'kaioken.gif', 'KAI');
INSERT INTO `smilies` VALUES (':1}', 'vampire.gif', 'Vampire');
INSERT INTO `smilies` VALUES (':2}', 'splat.gif', 'Splat');
INSERT INTO `smilies` VALUES (':3}', 'rwb.gif', 'Flag Smiley');
INSERT INTO `smilies` VALUES (':4}', 'FRlol.gif', 'LOL2');
INSERT INTO `smilies` VALUES (':5}', 'goodbad.gif', 'Good / Bad');
INSERT INTO `smilies` VALUES (':6}', 'eek2.gif', 'EEEEK');
INSERT INTO `smilies` VALUES (':7}', 'dodgy.gif', 'Dodgy');
INSERT INTO `smilies` VALUES (':8}', 'bawling.gif', 'Bawling');
INSERT INTO `smilies` VALUES (':9}', 'party.gif', 'Party on, Garth!');
INSERT INTO `smilies` VALUES (':ni', 'nighty.gif', 'Nightey, Night!');
INSERT INTO `smilies` VALUES (':wa', 'wavey.gif', 'Wave!');
INSERT INTO `smilies` VALUES (':pa', 'patty.gif', 'Patty');
INSERT INTO `smilies` VALUES (':al', 'alarm.gif', 'Alarm');
INSERT INTO `smilies` VALUES (':ba', 'barf.gif', 'Barf!');
INSERT INTO `smilies` VALUES (':bd', 'birthday.gif', 'Birthday');
INSERT INTO `smilies` VALUES (':bu', 'bubble.gif', 'bubble');
INSERT INTO `smilies` VALUES (':ca', 'cat.gif', 'Kitty');
INSERT INTO `smilies` VALUES (':ce', 'censored.gif', 'Censor');
INSERT INTO `smilies` VALUES (':ch', 'cheers.gif', 'Cheers');
INSERT INTO `smilies` VALUES (':co', 'cowboy.gif', 'Cowboy');
INSERT INTO `smilies` VALUES (':da', 'dance.gif', 'Dancing');
INSERT INTO `smilies` VALUES (':gr', 'dance1.gif', 'Dancing Stick');
INSERT INTO `smilies` VALUES (':du', 'dunce.gif', 'Dunce');
INSERT INTO `smilies` VALUES (':fi', 'finger.gif', 'Bird');
INSERT INTO `smilies` VALUES (':fe', 'flame.gif', 'Flame');
INSERT INTO `smilies` VALUES (':fg', 'flaming.gif', 'Flaming');
INSERT INTO `smilies` VALUES (':fl', 'flower2.gif', 'Flower2');
INSERT INTO `smilies` VALUES (':hi', 'hippie.gif', 'Hippie');
INSERT INTO `smilies` VALUES (':jo', 'joker.gif', 'Jester');
INSERT INTO `smilies` VALUES (':kn', 'knight.gif', 'Knight');
INSERT INTO `smilies` VALUES (':ko', 'koolaid.gif', 'KoolAid');
INSERT INTO `smilies` VALUES (':lo', 'looney.gif', 'Looney');
INSERT INTO `smilies` VALUES (':pi', 'pimp.gif', 'Pimp');
INSERT INTO `smilies` VALUES (':fy', 'mfinger.gif', 'Monkey Bird');
INSERT INTO `smilies` VALUES (':pu', 'pukeface.gif', 'Puke');
INSERT INTO `smilies` VALUES (':no', 'no.gif', 'NO!');
INSERT INTO `smilies` VALUES (':ro', 'rosie.gif', 'Rosy Cheeks');
INSERT INTO `smilies` VALUES (':sh', 'shudder.gif', 'Shudder');
INSERT INTO `smilies` VALUES (':si', 'sick.gif', 'Sick');
INSERT INTO `smilies` VALUES (':sm', 'smoker.gif', 'Smokin');
INSERT INTO `smilies` VALUES (':se', 'sperm.gif', 'Sperm');
INSERT INTO `smilies` VALUES (':to', 'tomato.gif', 'tomato');
INSERT INTO `smilies` VALUES (':tu', 'tut.gif', 'King Tut');
INSERT INTO `smilies` VALUES (':ty', 'type.gif', 'Typing');
INSERT INTO `smilies` VALUES (':wh', 'whip.gif', 'Whip It!');
INSERT INTO `smilies` VALUES (':ja', 'whoa.gif', 'Jaw Dropping');

-------------------------------------

Any suggestion ?

rsdn
0
Sohel Rana
Asked:
Sohel Rana
  • 4
  • 3
2 Solutions
 
cLFlaVACommented:
Do you know what line your error is occurring on?

0
 
Sohel RanaAuthor Commented:
Hi:

I don't know which line is causing this error.

rsdn
0
 
cLFlaVACommented:
Also, what is the SQL statement you're using when you try to add an entry?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
cLFlaVACommented:
You say you're getting an error trying to add an entry, yet nowhere in the above do you show us how you're trying to add the entry.
0
 
Sohel RanaAuthor Commented:
>> Also, what is the SQL statement you're using when you try to add an entry?

Add an entry I mean when I try to submit a guest comment from guest submit form.
I am not sure about what SQL statement is using but here is the submit php script :

-----------------------------------------------
<?
#################################################################################################
#
#  project                 : phpBook
#  filename                : guestbook.php
#  last modified by        : Erich Fuchs
#  e-mail                  : office@smartisoft.com
#  purpose                 : Guestbook
#
#################################################################################################

$proctime_start=microtime();

#  Include Configs & Variables
#################################################################################################

require ("config.php");

if (strstr (getenv('HTTP_USER_AGENT'), 'MSIE')) { // Browser Detection
    $in_field_size="50";
    $text_field_size="31";
} else {
    $in_field_size="30";
    $text_field_size="24";
}


#  Connect DB
#################################################################################################
mysql_connect($server, $db_user, $db_pass) or died("Database Connect Error");


#  Process
#################################################################################################

if ($action=="submit") {                              // Add an action


  if (!$in && !$delid && !$delcommentid && !$commentid) {
    header("Location: $PHP_SELF");
    exit;
  } elseif ($delid && $admin==$adminpass) {
    mysql_db_query($database, "DELETE FROM guestbook WHERE id='$delid'") or died("Database Query Error");
    header("Location: $PHP_SELF?offset=$offset&poffset=$poffset&admin=$admin");
    exit;
  } elseif ($delcommentid && $admin==$adminpass) {
    mysql_db_query($database, "UPDATE guestbook SET comment='' where id='$delcommentid'") or died("Database Query Error");
    header("Location: $PHP_SELF?offset=$offset&poffset=$poffset&admin=$admin");
    exit;
  } elseif ($commentid && $admin==$adminpass) {
    if(isset($comment)){
      $action=changed;
      mysql_db_query($database, "UPDATE guestbook SET comment='".encode_msg($comment)."' where id='$commentid'") or died("Database Query Error");
        } else {
      $action="";
    }
    header("Location: $PHP_SELF?commentid=$commentid&action=$action&offset=$offset&poffset=$poffset&admin=$admin");
    exit;
  } else {
    if (isbanned()) {
      header("Location: $PHP_SELF");
        exit;
    }
    $add_date=time();
    $result=mysql_db_query($database, "SELECT * FROM guestbook WHERE ip='$REMOTE_ADDR' AND timestamp>($add_date-(60*$timelimit))") or died("Database Query Error");
    $query=mysql_fetch_array($result);
    if ($query) {
      header("Location: $PHP_SELF");
        exit;
    }
    $in = strip_array($in);
    $in['message'] = encode_msg($in['message']);    // Add SQL compatibilty & Smilie Convert
    $in['http']    = str_replace("http://", "", $in['http']);   // Remove http:// from URLs
    if ($in['name'] == "") { died("<html><head><title>$guestbook_head</title>$languagemetatag</head><body><center>$name_empty</center></body></html>"); }
    if ($in['icq'] != "" && ($in['icq'] < 1000 || $in['icq'] > 999999999)) { died("<html><head><title>$guestbook_head</title>$languagemetatag</head><body><center>$icq_wrong</center></body></html>"); }
    if (!eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}$",$in['email']) && $in['email'] != "") { died("<html><head><title>$guestbook_head</title>$languagemetatag</head><body><center>$non_valid_email</center></body></html>"); }
    if (strlen($in['message']) < $limit["0"] || strlen($in['message']) > $limit["1"]) { died("<html><head><title>$guestbook_head</title>$languagemetatag</head><body><center>$message_incorrect $limit[0] $and $limit[1] $characters.</center></body></html>"); }
    if ($in['email'] == "") { $in['email'] = "none"; }
    if ($in['icq'] == "") { $in['icq'] = 0; }
    if ($in['http'] == "") { $in['http'] = "none"; }
    if ($in['location'] == "0") { $in['location'] = "none"; }
    $in['browser'] = $HTTP_USER_AGENT;
    mysql_db_query($database, "INSERT INTO guestbook (name, email, http, icq, message, timestamp, ip, location, browser)
    VALUES('$in[name]', '$in[email]','$in[http]','$in[icq]','$in[message]','$add_date', '$REMOTE_ADDR','$in[location]','$in[browser]')")
    or died("Database Query Error");
    if ($gb_notify) {
        @mail("$gb_notify","$gb_notifysubj","$notify_text $in[name]\n\n".censor_msg($in[message]),"From: $gb_notify");
    }
    if ($timelimit) {
        setcookie("phpbookcookie","$guestbook_head", time()+(60*$timelimit),"/");
    }
    if ($admin) {$adminlink="?admin=$admin";}
    header("Location: $PHP_SELF$adminlink");
    exit;
  }

} else {                                       // Show the entries #####################

  #  Header
  #################################################################################################

  echo "<html>\n";
  echo " <head>\n";
  echo "  <title>$guestbook_head</title>\n";
  echo "  <link rel=\"stylesheet\" type=\"text/css\" href=\"style.css\">\n";
  echo "  $languagemetatag\n";
  echo "  <meta name=\"robots\" content=\"index, nofollow\">\n";
  echo "  <meta name=\"revisit-after\" content=\"20 days\">\n";
  echo "    <script language=\"Javascript\">\n";
  echo "       function floodprotect() {\n";
  echo "         alert(\"$banned\");\n";
  echo "       }\n";
  echo "    </script>\n";
  echo " </head>\n";
  echo "<body>\n";

  #  The Main-Section
  #################################################################################################

  echo" <table align=\"$table_align\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" margin=1 width=\"$table_width\" height=\"$table_height\">\n";
  echo"   <tr>\n";
  echo"    <td class=\"class1\">\n";
  echo"      <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\" width=\"100%\" height=\"$table_height\">\n";
  echo"       <tr>\n";
  echo"        <td class=\"class2\">\n";
  if ($action=="add") {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">$gb_link1head</div></div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    echo "      <div class=\"maintext\">\n";
    echo "       <br>\n";
    echo "       <table align=\"center\">\n";
    echo "       <Form action=\"$PHP_SELF?action=submit\" method=\"post\">\n";
    echo "           <tr>\n";
    echo "      <td><div class=\"maininputleft\">$gbadd_name</div></td>\n";
    echo "      <td><input type=\"text\" name=\"in[name]\" size=\"$in_field_size\" maxlength=\"35\"></td>\n";
    echo "           </tr>\n";
    echo "           <tr>\n";
    echo "      <td><div class=\"maininputleft\">$gbadd_location</div></td>\n";
    if ($location_text) {
      echo "  <td><input type=\"text\" name=\"in[location]\" size=\"$in_field_size\" maxlength=\"35\"></td>\n";
    } else {
      echo "      <td class=\"class_add2\"><select name=\"in[location]\">\n";
      echo "      <option value=\"0\" SELECTED>$location_sel</option>\n";
      include ("$loc_dir/$locations");
      echo "      </select></td>\n";
    }
    echo "     </tr>\n";
    echo "     <tr>\n";
    echo "             <td><div class=\"maininputleft\">$gbadd_email</div></td>\n";
    echo "             <td><input type=\"text\" name=\"in[email]\" size=\"$in_field_size\" maxlength=\"35\"></td>\n";
    echo "     </tr>\n";
    echo "     <tr>\n";
    echo "             <td><div class=\"maininputleft\">$gbadd_icq</div></td>\n";
    echo "             <td><input type=\"text\" name=\"in[icq]\" size=\"$in_field_size\" value=\"\" maxlength=\"12\"></td>\n";
    echo "     </tr>\n";
    echo "     <tr>\n";
    echo "             <td><div class=\"maininputleft\">$gbadd_url</div></td>\n";
    echo "             <td><input type=\"text\" name=\"in[http]\" size=\"$in_field_size\" maxlength=\"60\" value=\"http://\"></td>\n";
    echo "     </tr>\n";
    echo "     <tr>\n";
    echo "             <td valign=\"top\"><div class=\"maininputleft\">$gbadd_msg<br><br>\n";
    echo "            <div class=\"xsmallleft\"><a href=\"smiliehelp.php\"
                      onClick='enterWindow=window.open(\"smiliehelp.php\",\"Smilie\",
                      \"width=300,height=450,top=100,left=100,scrollbars=yes\"); return false'
                      onmouseover=\"window.status='$smiliehelp'; return true;\"
                      onmouseout=\"window.status=''; return true;\">$smiley_help</a></div>\n";
    echo "            <div class=\"xsmallleft\"><a href=\"urlcodehelp.php\"
                      onClick='enterWindow=window.open(\"urlcodehelp.php\",\"URLCode\",
                      \"width=550,height=450,top=100,left=100,scrollbars=yes\"); return false'
                      onmouseover=\"window.status='$urlcodehelp'; return true;\"
                      onmouseout=\"window.status=''; return true;\">$url_code_help</a></div>\n";
    echo "            </div></td>\n";
    echo "             <td><textarea rows=\"8\" name=\"in[message]\" cols=\"$text_field_size\"></textarea></td>\n";
    echo "     </tr>\n";
    echo "     <tr>\n";
    echo "             <td></td>\n";
    echo "             <td><br><input type=\"hidden\" name=\"admin\" value=\"$admin\"><input type=\"submit\" Value=\"$submit\"></td>\n";
    echo "     </tr>\n";
    echo " </table>\n";
    echo " </form>\n";
    echo "           </div>\n";
  } elseif ($action=="admin" && $admin==$adminpass) {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">";
    echo "            <a href=\"$PHP_SELF?admin=$admin\" onmouseover=\"window.status='$gb_link5desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link5</a> || ";
    echo "            $gb_link2head</div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    echo "      <div class=\"maintext\">\n";
    echo "       <br>\n";
    echo "       <a href=\"$PHP_SELF?action=badwords&admin=$admin\" onmouseover=\"window.status='$gb_link3desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link3</a><br>\n";
    echo "       <a href=\"$PHP_SELF?action=banned_ips&admin=$admin\" onmouseover=\"window.status='$gb_link4desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link4</a>\n";
    echo "      </div>\n";
  } elseif ($action == "badwords" && $admin==$adminpass) {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">";
    echo "            <a href=\"$PHP_SELF?admin=$admin\" onmouseover=\"window.status='$gb_link5desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link5</a> || ";
    echo "            <a href=\"$PHP_SELF?action=admin&admin=$admin\" onmouseover=\"window.status='$gb_link2desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link2</a> || ";
    echo "            $gb_link3head</div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    $count=0;
    $result = mysql_db_query($database, "select * from badwords") or die("Database Query Error");
    echo " <br><table align=\"center\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" width=\"100%\">\n";
    echo "   <tr>\n";
    echo "    <td class=\"class2\">\n";
    echo "      ";
    echo "    </td>\n";
    echo "    <td class=\"class1\" align=\"right\" width=\"90\">\n";
    echo "      <div class=\"smallleft\"><a href=\"$PHP_SELF?action=new_badword&admin=$admin\">New</a></div>\n";
    echo "    </td>\n";
    echo "  </tr>\n";
    echo "</table>\n";

    while ($db = mysql_fetch_array($result)) {
        echo " <table align=\"center\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" width=\"100%\">\n";
      echo "   <tr>\n";
        echo "    <td class=\"class1\">\n";
      echo "     <div class=\"smallleft\">$db[badword]</div>";
        echo "    </td>\n";
        echo "    <td class=\"class1\" align=\"right\" width=\"90\">\n";
      echo "         <div class=\"smallleft\"><a href=\"$PHP_SELF?action=edit_badword&admin=$admin&value=$db[badword]\">Edit</a> || \n";
      echo "         $menusep<a href=\"$PHP_SELF?action=delete_badword&admin=$admin&value=$db[badword]\">Delete</a></div>\n";
        echo "    </td>\n";
      echo "  </tr>\n";
        echo "</table>\n";
      $count++;
    }
    echo "<div class=\"smallleft\"><br>$count $gb_link3stat<br><br></div>\n";

  } elseif ($action == "edit_badword" || $action == "new_badword" && $admin==$adminpass) {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">";
    echo "            <a href=\"$PHP_SELF?admin=$admin\" onmouseover=\"window.status='$gb_link5desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link5</a> || ";
    echo "            <a href=\"$PHP_SELF?action=admin&admin=$admin\" onmouseover=\"window.status='$gb_link2desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link2</a> || ";
    echo "            $gb_link3head</div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    echo "<form action=\"$PHP_SELF\" method=\"GET\">\n";
    echo "<table align=\"center\" width=\"100%\">\n";
    if ($action == "edit_badword") {
      echo "<input type=\"hidden\" name=\"action\" value=\"save_edit_badword\">\n";
    } else {
        echo "<input type=\"hidden\" name=\"action\" value=\"save_new_badword\">\n";
    }
    echo "<input type=\"hidden\" name=\"value\" value=\"$value\">\n";
    echo "<input type=\"hidden\" name=\"admin\" value=\"$admin\">\n";
    echo "<tr>\n";
    echo "<td class=\"classadd1\"><div class=\"maininputleft\">$gb_link3text</div></td>\n";
    echo "<td class=\"classadd2\">\n";
    echo "<input type=text name=\"newvalue\" size=\"25\" maxlength=\"50\" value=\"$value\"></td>\n";
    echo "</tr>\n";
    echo "<tr>\n";
    echo "<td class=\"classadd2\"></td>\n";
    echo "<td class=\"classadd2\"><br><input type=submit value=Submit></td>\n";
    echo "</tr>\n";
    echo "</table>\n";
    echo "</form>\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 "<script language=javascript>location.replace('$PHP_SELF?action=badwords&admin=$admin');</script>\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 "<script language=javascript>location.replace('$PHP_SELF?action=badwords&admin=$admin');</script>\n";

  } elseif ($action == "delete_badword" && $admin==$adminpass) {
    $result = mysql_db_query($database, "DELETE FROM badwords WHERE badword='$value'") or die("Database Query Error");
    echo "<script language=javascript>location.replace('$PHP_SELF?action=badwords&admin=$admin');</script>\n";

  } elseif ($action == "banned_ips" && $admin==$adminpass) {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">";
    echo "            <a href=\"$PHP_SELF?admin=$admin\" onmouseover=\"window.status='$gb_link5desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link5</a> || ";
    echo "            <a href=\"$PHP_SELF?action=admin&admin=$admin\" onmouseover=\"window.status='$gb_link2desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link2</a> || ";
    echo "            $gb_link4head</div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    $count=0;
    $result = mysql_db_query($database, "select * from banned_ips") or die("Database Query Error");
    echo " <br><table align=\"center\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" width=\"100%\">\n";
    echo "   <tr>\n";
    echo "    <td class=\"class2\">\n";
    echo "      ";
    echo "    </td>\n";
    echo "    <td class=\"class1\" align=\"right\" width=\"90\">\n";
    echo "      <div class=\"smallleft\"><a href=\"$PHP_SELF?action=new_banned_ip&admin=$admin\">New</a></div>\n";
    echo "    </td>\n";
    echo "  </tr>\n";
    echo "</table>\n";

    while ($db = mysql_fetch_array($result)) {
        echo " <table align=\"center\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" width=\"100%\">\n";
      echo "   <tr>\n";
        echo "    <td class=\"class1\">\n";
      echo "     <div class=\"smallleft\">$db[0]</div>";
        echo "    </td>\n";
        echo "    <td class=\"class1\" align=\"right\" width=\"90\">\n";
      echo "         <div class=\"smallleft\"><a href=\"$PHP_SELF?action=edit_banned_ip&admin=$admin&value=$db[banned_ip]\">Edit</a> || \n";
      echo "         <a href=\"$PHP_SELF?action=delete_banned_ip&admin=$admin&value=$db[banned_ip]\">Delete</a></div>\n";
        echo "    </td>\n";
      echo "  </tr>\n";
        echo "</table>\n";
      $count++;
    }
    echo "<div class=\"smallleft\"><br>$count $gb_link4stat<br><br></div>\n";

  } elseif ($action == "edit_banned_ip" || $action == "new_banned_ip") {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">";
    echo "            <a href=\"$PHP_SELF?admin=$admin\" onmouseover=\"window.status='$gb_link5desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link5</a> || ";
    echo "            <a href=\"$PHP_SELF?action=admin&admin=$admin\" onmouseover=\"window.status='$gb_link2desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link2</a> || ";
    echo "            $gb_link4head</div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    echo "<form action=\"$PHP_SELF\" method=\"GET\">\n";
    echo "<table align=\"center\" width=\"100%\">\n";
    if ($action == "edit_banned_ip") {
      echo "<input type=\"hidden\" name=\"action\" value=\"save_edit_banned_ip\">\n";
    } else {
        echo "<input type=\"hidden\" name=\"action\" value=\"save_new_banned_ip\">\n";
    }
    echo "<input type=\"hidden\" name=\"value\" value=\"$value\">\n";
    echo "<input type=\"hidden\" name=\"admin\" value=\"$admin\">\n";
    echo "<tr>\n";
    echo "<td class=\"classadd1\"><div class=\"maininputleft\">$gb_link4text</div></td>\n";
    echo "<td class=\"classadd2\">\n";
    echo "<input type=text name=\"newvalue\" size=\"25\" maxlength=\"50\" value=\"$value\"></td>\n";
    echo "</tr>\n";
    echo "<tr>\n";
    echo "<td class=\"classadd2\"></td>\n";
    echo "<td class=\"classadd2\"><br><input type=submit value=Submit></td>\n";
    echo "</tr>\n";
    echo "</table>\n";
    echo "</form>\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 "<script language=javascript>location.replace('$PHP_SELF?action=banned_ips&admin=$admin');</script>\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 "<script language=javascript>location.replace('$PHP_SELF?action=banned_ips&admin=$admin');</script>\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 "<script language=javascript>location.replace('$PHP_SELF?action=banned_ips&admin=$admin');</script>\n";

  } else {

    if ($admin) {$adminlink="&admin=$admin";}

    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">\n";
    if ($admin==$adminpass) {
       echo "                 <a href=\"$PHP_SELF?action=admin&admin=$admin\" onmouseover=\"window.status='$gb_link2desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link2</a> || \n";
    }
    if ($phpbookcookie==$guestbook_head && $admin!=$adminpass) {
       echo "                 <a href=\"$PHP_SELF\" onclick=javascript:floodprotect() onmouseover=\"window.status='$gb_link1desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link1</a>\n";
    } else {
       echo "                 <a href=\"$PHP_SELF?action=add$adminlink\" onmouseover=\"window.status='$gb_link1desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link1</a>\n";
    }
    echo "              </div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    echo "           <div class=\"maintext\">\n";

    #  Start with Output
    #################################################################################################

    echo "<table align=\"center\"  cellspacing=\"0\" cellpadding=\"3\" width=\"100%\" border=\"0\">\n";
    echo "<tr><td><div class=\"maincatnav\">\n";
    echo "$gb_desc<br>\n";
    echo "</div></td>\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;
    $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 "<td><div class=\"mainpages\">\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 "[<a href=\"$PHP_SELF?offset=0&poffset=0$adminlink\"><<</a>] ";
          echo "[<a href=\"$PHP_SELF?offset=$noffset&poffset=$npoffset$adminlink\"><</a>] ";
          }
        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 "(<b>$actual</b>) ";
            } else {
             echo "[<a href=\"$PHP_SELF?offset=$noffset&poffset=$npoffset$adminlink\">$actual</a>] ";
          }
      }
      if ($offset+$perpage<$amount_array["0"]) {
              $noffset=$offset+$perpage;
              $npoffset = $noffset/$perpage-$middlepage;
              if ($npoffset<0) {$npoffset=0;}
              if ($npoffset>$maxpoffset) {$npoffset = $maxpoffset;}
          echo "[<a href=\"$PHP_SELF?offset=$noffset&poffset=$npoffset$adminlink\">></a>] ";
          echo "[<a href=\"$PHP_SELF?offset=$maxoffset&poffset=$maxpoffset$adminlink\">>></a>] ";
        }
    }
    echo "</div></td></tr>\n";
    echo "</table>\n";

    #  Start the Page
    #################################################################################################

    echo "<table align=\"center\"  cellspacing=\"1\" cellpadding=\"3\" width=\"100%\" border=\"0\">\n";
    echo "   <tr>\n";
    echo "     <td class=\"gbheader\">$gb_name</td>\n";
    echo "     <td class=\"gbheader\">$gb_comments</td>\n";
    echo "   </tr>\n";

    #  Get actions for current page
    #################################################################################################

    $result = mysql_db_query($database, "SELECT * FROM guestbook 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 = "<a href=\"mailto:".$db[email]."\"><img src=\"$image_dir/icons/email.gif\" alt=\"$send_email\" border=\"0\" align=\"right\"></a>";
      } else {
      $email = "";
      }
    if ($db[icq]     != 0)      {
      $icq = "<a href=\"http://wwp.icq.com/scripts/contact.dll?msgto=$db[icq]\"><img src=\"http://wwp.icq.com/scripts/online.dll?icq=" . $db[icq] . "&img=5\" alt=\"$icq_message\" border=\"0\" align=\"right\" height=\"17\"></a>";
      } else {
      $icq = "";
      }
    if ($db[http]    != "none") {
      $http = "<a href=\"http://$db[http]\" target=\"_blank\"><img src=\"$image_dir/icons/home.gif\" alt=\"$view_homepage\" border=\"0\" align=\"right\"></a>";
      } else {
      $http = "";
      }
    if ($db[ip]      != "none") {
       if ($admin==$adminpass) {
        $ip = "<img src=\"$image_dir/icons/ip.gif\" alt=\"".$db[ip]."\" align=\"left\">";
       } else {
        $ip = "<img src=\"$image_dir/icons/ip.gif\" alt=\"$ip_logged\" align=\"left\">";
       }
    } else {
      $ip = "";
    }
    if ($db[location]!= "none") {
      $location = "$gb_location<br>$db[location]<br>";
      } else {
      $location = "<br><br>";
      }
    if ($db[browser]      != "") {
      $browser = "<img src=\"$image_dir/icons/browser.gif\" alt=\"$db[browser]\" align=\"left\">";
      } else {
      $browser = "";
      }
    echo "  <tr>\n";
    echo "     <td class=\"gbtable1\">\n";
    echo "        <div class=\"mainname\">$db[name]</div><br>\n";
    echo "        <div class=\"smallleft\">$location<br></div>\n";
    echo "        <br>$icq $http $email $ip $browser\n";
    echo "     </td>\n";
    echo "        <td class=\"gbtable2\"><div class=\"smallleft\">\n";
    if ($admin==$adminpass) {
        echo "<a href=\"$PHP_SELF?action=submit&delid=$db[id]&offset=$offset&poffset=$poffset$adminlink\"><img src=\"$image_dir/icons/trash.gif\" alt=\"$moderator_del_action\" border=\"0\" align=\"right\"></a>";
        echo "<a href=\"$PHP_SELF?action=submit&delcommentid=$db[id]&offset=$offset&poffset=$poffset$adminlink\"><img src=\"$image_dir/icons/trashcomment.gif\" alt=\"$moderator_del_comment\" border=\"0\" align=\"right\"></a>";
        echo "<a href=\"$PHP_SELF?action=submit&commentid=$db[id]&offset=$offset&poffset=$poffset$adminlink\"><img src=\"$image_dir/icons/comment.gif\" alt=\"$moderator_edit_comment\" border=\"0\" align=\"right\"></a>";
                    echo "<div class=\"spaceleft\">&nbsp;</div>\n";
    }
    echo "        $gb_posted $when</div><hr><div class=\"mainleft\">".censor_msg($db[message],($admin==$adminpass))."</div>\n";
    if($commentid == $db[id] && $action!="changed" && $admin==$adminpass) {
      echo "  &nbsp;&nbsp\n";
      echo "  <form action=\"$PHP_SELF?action=submit\" method=\"post\">\n";
      echo "     <input type=\"hidden\" name=\"admin\" value=\"$admin\"><input type=\"hidden\" name=\"commentid\" value=\"$commentid\">\n";
      echo "     <input type=\"hidden\" name=\"offset\" value=\"$offset\"><input type=\"hidden\" name=\"poffset\" value=\"$poffset\">\n";
      echo "     <div class=\"comment\"><textarea name=\"comment\" cols=\"".($text_field_size-5)."\" rows=\"5\">".decode_msg($db[comment])."</textarea>\n<BR>";
      echo "     <input type=\"submit\">&nbsp;&nbsp;<a href=\"smiliehelp.php\"
                            onClick='enterWindow=window.open(\"smiliehelp.php\",\"Smilie\",
                            \"width=250,height=450,top=100,left=100,scrollbars=yes\"); return false'
                            onmouseover=\"window.status='$smiliehelp'; return true;\"
                            onmouseout=\"window.status=''; return true;\">$smiley_help</a></div>\n";
      echo "  </form>\n";
    } elseif(!empty($db[comment])) {
      echo "  &nbsp;&nbsp<div class=\"comment\">".$gb_modcomment.$db[comment]."</div>\n";
    }
    echo "      </td>\n  </tr>\n";
    }

    # End of Page reached
    #################################################################################################

    echo"</table>\n";
    echo"</div>\n";
  }
  echo"        </td>\n";
  echo"       </tr>\n";
  echo"      </table>\n";
  echo"    </td>\n";
  echo"   </tr>\n";
  echo"   <tr>\n";
  echo"    <td>\n";
  echo"<br>\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"<div class=\"footer\">Processingtime: ".substr($proctime,0,7)." sec., Entries: $countall, PHP Ver. ".phpversion()."</div>\n";
  }

  #  PLEASE DO NOT REMOVE OR EDIT THIS COPYRIGHT-NOTICE !!! THANKS !!! ################################################

  echo"<div class=\"footer\">phpBook Ver. $book_version &copy; 2001-".date("Y")." by <a href=\"http://www.smartisoft.com\" target=\"_blank\">SmartISoft</a></div>\n";
  #####################################################################################################################

  echo"    </td>\n";
  echo"   </tr>\n";
  echo" </table>\n";
  echo"</body>\n";
  echo"</html>\n";


}

#  Disconnect DB
#################################################################################################
mysql_close();

if ($support==$supportpwd && $supportpwd) {echo "<br><br>"; phpinfo();}

?>

--------------
rsdn




0
 
cLFlaVACommented:
This is a HUGE script.  There are about 10 separate instances of "Database Query Error."  What I suggest you do is search for "Database Query Error" in your script, and in each instance of the string, add a number.  For example, the first would be Database Query Error1, the second would be Database Query Error2 and so on.  This way, you'll be able to tell which query is being called that returns an error.

Which line do you get the error on after this?
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
Hi rsdn,

Add below line after the mysql_db_query() /mysql_query()
print mysql_error();  

This would show you the exact cause..

0
 
Sohel RanaAuthor Commented:
Hi cLFlaVA and ushastry:

Thanks for your help. I installed a different script and it's working perfect. I think the problem is with the previous guestbook script. I award points because I learn something from both of your about mql. :)

Thanks again.

rsdn
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now