PDA

View Full Version : PM Hack - 1.1.5 (Ed plz look)


01-05-2001, 02:17 PM
It will be great if someone could give me instructions for installing the PM hack to vB 1.1.5. Actually I'm upgrading and the only part that doesn't work is member.php

Any help will be appreciated

Thanks

01-05-2001, 03:03 PM
The reason is probably because they changed the file to use the addslashes() function when submitting the user info. If you search for the first part of the string i.e. $DB_site->query("UPDATE user

Then you should be able to find it. If that doesn't help list the specific line you are having trouble with.

01-06-2001, 05:12 AM
Actually the problem is not with finding the line. Should I add the addslashes() function to the PM values?

I think the problem is here but since I don't know php, I can't fix it.

$DB_site->query("INSERT INTO user (userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,biography,signature,adm inemail,showemail,invisible,usertitle,joindate,can post,cookieuser,daysprune,lastvisit,lastactivity,u sergroupid,timezoneoffset,emailnotification,receiv epm,emailonpm) VALUES (NULL,'".addslashes($username)."','".addslashes($password)."','".addslashes($email)."','".addslashes($parentemail)."',$coppauser,'".addslashes($homepage)."','".addslashes($icq)."','".addslashes($aim)."','".addslashes($yahoo)."','".addslashes($biography)."','".addslashes($signature)."',".addslashes($adminemail).",".addslashes($showemail).",".addslashes($invisible).",'".addslashes($usertitle)."',".time().",1,".addslashes($cookieuser).",".addslashes($prunedays).",".time().",".time().",".addslashes($newusergroupid).",".addslashes($timezoneoffset).",".addslashes($emailnotification)."),".addslashes($receivepm).",".addslashes($emailonpm)."");


When I register a new user, I get this db error:

Database error in vBulletin: Invalid SQL: INSERT INTO user (userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,biography,signature,adm inemail,showemail,invisible,usertitle,joindate,can post,cookieuser,daysprune,lastvisit,lastactivity,u sergroupid,timezoneoffset,emailnotification,receiv epm,emailonpm) VALUES (NULL,'deneme','pff','dostluk2000@hotmail.com','', 0,'http://','','','','','',1,1,0,'Newbie',978764903,1,1,-1,978764903,978764903,3,0,1),1,0
mysql error: You have an error in your SQL syntax near '1,0' at line 1

Thanks

01-06-2001, 02:02 PM
Add in side the parentheses.