Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Mar 2002
Posts: 574
Likes: 1
C
UGN GFX Whore
OP Offline
UGN GFX Whore
C
Joined: Mar 2002
Posts: 574
Likes: 1
I have a post comments feature on my site for different essays or short stories. The problem is, instead of adding what you typed for Name, Email, Site, and Comment, it adds a 0 to the db. Everything else works, stuff that you can't change in the form like ip address, timestamp, and the id of the article you are commenting on. Any idea why it does this? I'll give you more info if you want. Thanks for any help, I've spent so much time trying to figure this [censored] out.

Here is the code for the page that does the adding, which is seperate from the page you post from:
Code
<?PHP
include("dbconnect.php");

IF($nraktion == "ssub") {

    IF ($wc_name == "name") {
        $wc_name = "A Stranger";
    } ELSEIF ($wc_name == "" ) {
            $wc_name = "A Stranger";
}
    IF ($wc_email == "email") {
        $wc_email = "none";
    } ELSEIF ($wc_email == "" ) {
            $wc_email = "none";
}
    IF ($wc_site == "http://") {
        $wc_site = "none";
    } ELSEIF ($wc_site == "" ) {
            $wc_site = "none";
}

IF ($wc_content == "") {
    echo ("You radge, you left the message box blank and should be banned from the internet entirely.");
} ELSE {
$ip = getenv("REMOTE_ADDR");
mysql_query("INSERT INTO writcomments (ip,nid,name,email,site,content,timestamp) VALUES ('$ip','$nid','$wc_name','$wc_email','$wc_site','$wc_content',".time().")");
ECHO ("<img src=main/post/posting.gif alt=\"Posting\">");
} //END ELSE FOR CONTENT
} //END IF NRAKTIOn == SSUB
?>
And yes, I know. include is dying and require is the way to go. I know. Whatever.

Joined: Mar 2002
Posts: 256
Likes: 1
UGN Security Staff
Offline
UGN Security Staff
Joined: Mar 2002
Posts: 256
Likes: 1
Code
<?PHP
 require "dbconnect.php";
 IF($nraktion == "ssub") {    
  $wc_name = ($wc_name == "name" &#0124;&#0124; $wc_name == "" ? "A Stranger" : $wc_name);
  $wc_site = ($wc_site == "http://" &#0124;&#0124; $wc_site == "" ? "none" : $wc_site);
  IF ($wc_content == "") {
   echo ("You radge, you left the message box blank and should be banned from the internet entirely.");
  } ELSE {
   $ip = getenv("REMOTE_ADDR");
   mysql_query("INSERT INTO `writcomments` (`ip`,`nid`,`name`,`email`,`site`,`content`,`timestamp`) VALUES ('$ip','$nid','$wc_name','$wc_email','$wc_site','$wc_content','".time()."');") 
               or die(mysql_error());
   ECHO ("<img src=main/post/posting.gif alt=\"Posting\">");
  }
 }
?>
Thats some nice rewritten code wink /e shakes [censored].

--edited--

Joined: Mar 2002
Posts: 574
Likes: 1
C
UGN GFX Whore
OP Offline
UGN GFX Whore
C
Joined: Mar 2002
Posts: 574
Likes: 1
All I have to say is:

You have an error in your SQL syntax near '\'1057292661\')' at line 1

Joined: Mar 2002
Posts: 574
Likes: 1
C
UGN GFX Whore
OP Offline
UGN GFX Whore
C
Joined: Mar 2002
Posts: 574
Likes: 1
Basically, all the information needed gets to the page with the code above. What is happening, is the mysql table is a closet homosexual. I'm going to try making a new table and hope it's straight this time.

Joined: Mar 2002
Posts: 574
Likes: 1
C
UGN GFX Whore
OP Offline
UGN GFX Whore
C
Joined: Mar 2002
Posts: 574
Likes: 1
I created a new table and changed some code, now it works. It works like it should have worked the first time, but that would be too easy. The people at MySQL know that no one likes things to go smoothly which is why cars have shock-absorbers and why condoms are made of latex and prelubricated. Another thing that know is that I love taking it in the [censored] along with wasting like 4 hours on a problem that can't even decide it's sexuality.


Link Copied to Clipboard
Member Spotlight
Posts: 30
Joined: June 2002
Forum Statistics
Forums41
Topics33,840
Posts68,858
Average Daily Posts1
Members2,176
Most Online3,253
Jan 13th, 2020
Latest Postings
Where and how do you torrent?
by danni75 - 03/01/24 05:58 AM
Animation,
by JohanKaariainen - 08/15/19 01:18 AM
Blackbeard.....
by Gremelin - 10/03/18 07:02 PM
my old account still exists!
by Crime - 08/10/18 02:47 PM
Okay WTF?
by HenryMiring - 09/27/17 01:45 AM
The History Thread...
by Gremelin - 08/11/17 12:11 PM
My friend NEEDS your HELP!
by Lena01 - 07/21/17 12:06 AM
I'm having fun with this guy.
by gabithompson730 - 07/20/17 01:50 AM
I want to upgrade my phone
by gabithompson730 - 07/20/17 01:49 AM
Doom 3
by Cyrez - 09/11/14 08:58 PM
Amazon Gift Card Generator/KeyGen?te
by Gecko666 - 08/22/14 09:21 AM
AIM scene 99-03
by lavos - 09/02/13 08:06 AM
Planetside 2
by Crime - 03/04/13 07:10 AM
Beta Testers Wanted
by Crime - 03/04/13 06:55 AM
Hello Everyone
by Gremelin - 02/12/12 06:01 PM
Tracfone ESN Generator
by Zanvin Green - 01/18/12 01:31 PM
Python 3 issue
by Testing - 12/17/11 09:28 PM
tracfone airtime
by Drache86 - 07/30/11 03:37 AM
Backdoors and the Infinite
by ZeroCoolStar - 07/10/11 03:52 AM
HackThisZIne #12 Releaseed!
by Pipat2 - 04/28/11 09:20 PM
gang wars? l33t-wars?
by Gremelin - 04/28/11 05:56 AM
Consolidate Forums
by diggin2deep - 04/21/11 10:02 AM
LAN Hacking Noob
by Gremelin - 03/12/11 12:42 AM
Top Posters
UGN Security 41,392
Gremelin 7,203
§intå× 3,255
SilentRage 1,273
Ice 1,146
pergesu 1,136
Infinite 1,041
jonconley 955
Girlie 908
unreal 860
Top Likes Received
Ghost 2
Crime 1
Ice 1
Dartur 1
Cyrez 1
Powered by UBB.threads™ PHP Forum Software 7.7.5