Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-19-2008, 10:27 PM
ptmuldoon ptmuldoon is offline
 
Join Date: Feb 2005
Posts: 78
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Multi DB Register Mod/Plugin

I'm wondering if anyone has already made some type of multi registration mod/plugin for VB. What I'm thinking here is:

1. The user registers normally in VB.
2. After activating their registration, the user is then inserted into additional multiple DB tables.

I'm thinking that the plugin would maybe let the site admin be able to input a set of 4 or 5 fields for each database they want to have the user added to, such as the additional DB name and DB table. And then which fields to add the user to for that table.

This way, you can add as many new databases as you need, and the users would be registered into each one when activating their account. Working on checks for dual usernames would be later a project down the road.

I know I could probably create a hook to insert the user into each database. Maybe just store all the additional code in one file, and then call/include that file during the activation. But each time I added another game (set of tables), I would have to modify the hook code.

I currently have a simple gaming site that has separate tables for each game, along with the users records, scores, etc. So I can't really give up the existing set of tables.

This would currently just be a registration/insertion into multiple database. I would expect that the user would then have to modify the various code of their other non-vb info to enable a single login. But I think that could be done by just getting the vb_user info and passing the variables to the other non-vb info.
Reply With Quote
  #2  
Old 10-20-2008, 03:25 AM
Amenadiel's Avatar
Amenadiel Amenadiel is offline
 
Join Date: Sep 2006
Posts: 171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'd rather see the way of doing this with triggers, directly in the database. In other words, make a trigger so an insertion on vb_user spawns an intertion on game1_user, which can have it's own trigger to spawn an insertion on game2_user

for each game you add, you would chain link to the last table with a trigger. It's like a domino effect.
Reply With Quote
  #3  
Old 10-20-2008, 02:57 PM
ptmuldoon ptmuldoon is offline
 
Join Date: Feb 2005
Posts: 78
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Interesting.

I've been learning php on and off in my spare time. Triggers are whole new ball game for me, but look interesting indeed.

Would the initial trigger for VB to placed in a hook? I'm unsure if your allowed to actually modify any of the VB code or not.

I think you would also have to some kind of check during the login phase as well to add the user to each new games or additional table that comes along.

ie. You start with your VB database and 2 other DB's for 2 games you have going. The user first registered, and triggered each database to add them to DB's 2 and 3.

Now, you added a 3rd game (4th database). So on the login, it would roll through checking each database and insert the user into the 4th database. Another check for duplicate names or ID's would be useful too.

I'm still a rookie coder, but I may play around with the user of triggers this upcoming weekend when I get some extra time.
Reply With Quote
  #4  
Old 10-22-2008, 12:42 AM
darkforce114 darkforce114 is offline
 
Join Date: Apr 2004
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm also trying to do this. (Don't want the thread hi-jack, but maybe we can work on it together)

What I'm looking for is to copy

username from vb_username, copy it to login on kml_user
password from vb_username, copy it to pass on kml_user
email from vb_username, copy it to mail on kml_user

During registration.
Reply With Quote
  #5  
Old 10-22-2008, 06:27 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you had a look at MySQL views?
Reply With Quote
  #6  
Old 10-22-2008, 06:17 PM
darkforce114 darkforce114 is offline
 
Join Date: Apr 2004
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dismounted View Post
Have you had a look at MySQL views?
Can you explain a little more?, I've been in phpmyadmin looking at the tables.
Reply With Quote
  #7  
Old 10-22-2008, 06:57 PM
Adrian Schneider's Avatar
Adrian Schneider Adrian Schneider is offline
 
Join Date: Jul 2004
Posts: 2,528
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I explain it a little here,
https://vborg.vbsupport.ru/showpost....22&postcount=3
Reply With Quote
  #8  
Old 09-25-2009, 11:35 AM
thompson thompson is offline
 
Join Date: Jul 2007
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

old thread, but did you found a solution ?
Reply With Quote
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 01:28 AM.


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.04493 seconds
  • Memory Usage 2,227KB
  • Queries Executed 13 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)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