Help Parse Error!!

PHP Code:

$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,NP,allowsmilie,showsignature,ipaddress,iconid,visible,usermoodid,usermoodpath,usermoodmessage) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes($postusername))."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','".addslashes($nowplaying)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible','$usermoodid','$usermoodpath','".addslashes(htmlspecialchars($usermoodmessage))."')"); 


Can anyone tell me where the error is in this please ???

Its been driving me crazy

error I am getting is Parse error: parse error, unexpected ')' in /home/ravescen/public_html/newreply.php on line 336

[chad777]

nevermind i found it the above error now I am getting another error about wrong syntax can anyone look at this and see if they see anything wrong thanks

[g-force2k2]

the query looks okay to me...what kind of sytax error is it giving you? regards...

g-force2k2

[chad777]

well i fixed that one. now I am having a problem with newtread after installing the sticky thing.

at around line 287:

PHP Code:

$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach,sticky) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$forumid','1','0','".addslashes($postusername)."','$bbuserinfo[userid]','".addslashes($postusername)."','".time()."','$iconid','$visible','$attachcount','$stickynow')"); 


everytime i try to start a new tread (push the submit buttom) I get this database error:

Database error in vBulletin 2.2.6:

Invalid SQL: select uid, newthread from storepoint where uid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

[g-force2k2]

thats because the uid value that you're trying to select either is getting the wrong variable or doesn't exist... it doesn't have to do with the INSERT INTO thread query... regards...

g-force2k2

[chad777]

Have any idea what I should look for to check if it is right like [userid]

The reason I was looking at the query is because there was a database error before the one above before that, that said that line.....then i fixed or atleast I thought and now i get that error

[chad777]

The only things that have uid= in them are:

PHP Code:

$gettotalpoint=mysql_query("SELECT uid, newthread, reply, admin_mod, morereply from storepoint where uid=$bbuserinfo[userid]"); 


PHP Code:

$result=$DB_site->query("select uid, newthread from storepoint where uid=$postuserid"); 


PHP Code:

$DB_site->query("UPDATE storepoint SET newthread=$newpoints where uid=$postuserid"); 


[g-force2k2]

chad open the file that the error was in and find that select query and post it here so i can see whats up with it... regards...

g-force2k2

[chad777]

here is the whole newthread.php file

[g-force2k2]

first of chad please remove the file you can't post full vb files just don't want you to get in trouble second find this:

PHP Code:

                                $gettotalpoint=mysql_query("SELECT uid, newthread, reply, admin_mod, morereply from storepoint where uid=$bbuserinfo[userid]"); 


replace it with this:

PHP Code:

                                $gettotalpoint = $DB_site->query_first("SELECT uid, newthread, reply, admin_mod, morereply FROM storepoint WHERE uid='$bbuserinfo[userid]'"); 


see if that works regards...

g-force2k2