vB + LinksSQL user reg. problem...
 

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)http://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