nocturnix123
03-27-2003, 04:01 PM
Okay, I have hired a coder to merge the registration process of vbulletin and links SQL at two seperate domains and using a third as a hub for the registration process.
He is having problems with his script in that when a user is created and you try to login you get errors either when you login or when you try and use a certain function like usercp.
Here is what he wanted me to post for him:
-------------------------------------------------------------------------------
Hi. I'm trying to make an intermediary between a program called Link SQL, and the famous vBulliten. The below is a sample user, where I am having this problem;
INSERT INTO user VALUES('300','2','andytest','2ab0004f3b95132507719 3a8f9baa8f2','webmaster@ace-installer.com','1','','0','(Link: http://www.clanice.org','','','','','1','0','0','Junior)h ttp://www.clanice.org','','','','','1','0','0','Junior Member','0','1048763638','1','1000','1048763638',' 1048768616','0','0','0','1','','','','1','1','1',' 0','15','0000-00-00','40','1','218.145.25.11','0','1','0');
Basically, my script will give the user one form, to signup to vBulliten, and Links SQL. The way it works, is;
+ User fills out form
+ They get sent a validation email.... data is held in val_user.
+ Once they vaslidate it, the users details are copied inrto the Links SQL table, and the 'users' table for vBulliten.
+ They can then login at either of the scripts with the same details. The problem I am having, is that when you log in, it accepts you....but then whenever you try and go to modify your account, delete a post, or anything like that....it asks you to re-login. I am able to make posts, but literally nothing else :(
Does anyone know if there are any other tables I should be populating, with users details, to allow vBulliten to accept externaly entered users?
-------------------------------------------------------------------------------
Also, I recieved THIS email when I tried to login using his test account...
========================
Database error in vBulletin 2.2.8:
Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Thursday 27th of March 2003 05:05:40 PM
Script: http://www.forum-forum.com/forum/forum/index.php?
Referer:
========================
Lastly if youd like to try logging in with the test user it is:
andytest/Newby2k
Thanks, hope its something simple like a missing table or something.
Regards,
-Nocturnix
He is having problems with his script in that when a user is created and you try to login you get errors either when you login or when you try and use a certain function like usercp.
Here is what he wanted me to post for him:
-------------------------------------------------------------------------------
Hi. I'm trying to make an intermediary between a program called Link SQL, and the famous vBulliten. The below is a sample user, where I am having this problem;
INSERT INTO user VALUES('300','2','andytest','2ab0004f3b95132507719 3a8f9baa8f2','webmaster@ace-installer.com','1','','0','(Link: http://www.clanice.org','','','','','1','0','0','Junior)h ttp://www.clanice.org','','','','','1','0','0','Junior Member','0','1048763638','1','1000','1048763638',' 1048768616','0','0','0','1','','','','1','1','1',' 0','15','0000-00-00','40','1','218.145.25.11','0','1','0');
Basically, my script will give the user one form, to signup to vBulliten, and Links SQL. The way it works, is;
+ User fills out form
+ They get sent a validation email.... data is held in val_user.
+ Once they vaslidate it, the users details are copied inrto the Links SQL table, and the 'users' table for vBulliten.
+ They can then login at either of the scripts with the same details. The problem I am having, is that when you log in, it accepts you....but then whenever you try and go to modify your account, delete a post, or anything like that....it asks you to re-login. I am able to make posts, but literally nothing else :(
Does anyone know if there are any other tables I should be populating, with users details, to allow vBulliten to accept externaly entered users?
-------------------------------------------------------------------------------
Also, I recieved THIS email when I tried to login using his test account...
========================
Database error in vBulletin 2.2.8:
Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Thursday 27th of March 2003 05:05:40 PM
Script: http://www.forum-forum.com/forum/forum/index.php?
Referer:
========================
Lastly if youd like to try logging in with the test user it is:
andytest/Newby2k
Thanks, hope its something simple like a missing table or something.
Regards,
-Nocturnix