Add user : AdminCP SQL error

[Zachariah]

When adding a user via AdminCP
Not sure whats up ..... users can Reg and it works.
Prob a hack I added =/

All i can think is a value being called is not there.

Edited PHP files:

showthread.php (quick reply box)
member.php (Remote hosted avatar)
functions.php (Remote hosted avatar)

Everything else is template hacks.



Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: INSERT INTO user (userid,usergroupid,username,password,email,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,showemail,invisible,usertitle,cu stomtitle,joindate,cookieuser,daysprune,lastvisit, lastactivity,lastpost,posts,timezoneoffset,emailno tification,receivepm,emailonpm,ipaddress,pmpopup,o ptions,birthday,height,width) VALUES (NULL,'2','Dad','439835bbc755914edcf3f5496bfc8609' ,'test@test.com','1','','0','http://www.yahoo.com','','','','','1','1','0','Contender' ,'0',1032560664,'1','-1',1032560664,1032560664,1032560664,'0','0','0','1 ','0','','1','15','1951-12-10',','')
mysql error: You have an error in your SQL syntax near '','')' at line 1

mysql error number: 1064

Date: Friday 20th of September 2002 06:24:24 PM
Script: http://192.168.0.1/forums/forums/admin/user.php
Referer: http://192.168.0.1/forums/admin/user.php?action=add

[Xenon]

you have forgotten one ' in your query at the end:
,'1951-12-10',','')

should be:
,'1951-12-10','','')

edit your user.php and apply the ' at the insert line.

just a question: why do you have the user table fields height & width?

it would be easier to just add custom profile fields

[Zachariah]

thanks for the info ill take a look .... the height width came from an Offline site avatar hosting hack. This way we don't host the avatars ... insted its a link to a remote site of the users choice. The "size" of the avatar is there in those 2 fields. (that way no matter the size they provide it will be no larger and X by X Size.


Ref: https://vborg.vbsupport.ru/showthread.php?s=&threadid=43268&highlight=Remote+Hosted+Avatar+Hack


If there is a better way to do this yell ..... i'm a "shade tree hacker" ... not a guru like yall :D


My fault:

I was trying
// +++++++ Offsite Avatar Hack by g-force2k2 +++++++

and found out it wasen't working I forgot to clean up ..... DOH!

Thanks bunches