vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   MySQL Table Update when a user registers for the forum? (https://vborg.vbsupport.ru/showthread.php?t=33062)

shellx 12-09-2001 02:48 AM

Hello,
I added some custom code of mine to one of the signup php scripts that a user would fill out when they wanted to signup to be a member on our vB board. The trouble was was that it would update my "login" mySQL table in another datbase, however it would then return an error to the user, and not update them in the vBulletin membership tables (it partially adds them). If anyone has done this succesfully and would be able to tell me where i should place my code (which file, which area, etc), it'd be helpful.

I get the following error when I try to update:

Invalid SQL: INSERT INTO userfield (userid,field1,field2,field3,field4) VALUES (46,'','','','')

Thanks

Mark Hensler 12-09-2001 05:06 AM

Isn't there more to that mySQL error?

shellx 12-09-2001 06:21 AM

Well that is what vB emails me. In register.php, it exists somewhere in the add member IF statement before it updates the database. Then when I start adding my own DB_site2-> (I made a new DB_Sql_vb class declaration) calls, it then busts parts and doesn't let it update all the records in vBulletin's tables, yet it updates my tables. Basically looking to go error free :).

Admin 12-09-2001 10:20 AM

shellx, please go to this page and enter your username, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.

shellx 12-09-2001 12:03 PM

I just went to that page and added my username (shellx).

shellx 12-09-2001 04:16 PM

Someone has to have done this!!!!! I think I am editing the right file (global.php won't work from what i've analyzed), but it simply is the fact of trying to get the thing to update my database and not mess up when it tries to update vB's database. It may be in the function calls; I first tried using functions such as mysql_fetch_array, but then I used vB's own class in db_mysql.php to see if that'd fix things. I feel as if I am very close, just need that silver bullet to get this going.


All times are GMT. The time now is 04:59 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.00946 seconds
  • Memory Usage 1,718KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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