vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   PM Hack - 1.1.5 (Ed plz look) (https://vborg.vbsupport.ru/showthread.php?t=6404)

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.
Code:

  $DB_site->query("INSERT INTO user (userid,username,password,email,parentemail,coppauser,homepage,icq,aim,yahoo,biography,signature,adminemail,showemail,invisible,usertitle,joindate,canpost,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification,receivepm,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:
Code:

Database error in vBulletin: Invalid SQL: INSERT INTO user (userid,username,password,email,parentemail,coppauser,homepage,icq,aim,yahoo,biography,signature,adminemail,showemail,invisible,usertitle,joindate,canpost,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification,receivepm,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.


All times are GMT. The time now is 07:08 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00975 seconds
  • Memory Usage 1,715KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete