Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vB + LinksSQL user reg. problem... Details »»
vB + LinksSQL user reg. problem...
Version: , by nocturnix123 nocturnix123 is offline
Developer Last Online: Sep 2008 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 03-27-2003 Last Update: Never Installs: 0
 
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:35 PM.


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.05037 seconds
  • Memory Usage 2,195KB
  • Queries Executed 16 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete