vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Major Additions - Share users database among many forums (https://vborg.vbsupport.ru/showthread.php?t=185021)

gibgib 06-21-2009 07:00 AM

Great to see some activity in this thread.
After reading what has been posted I might attempt vb 3.8

webgroup 06-24-2009 04:27 AM

still need to know how not to share the user signatures

deepblue 06-29-2009 03:28 PM

Can anyone tell me where i can find what the name of the main forum prefix is for forums A? I am unsure where to look.

webgroup 06-30-2009 07:52 AM

Quote:

Originally Posted by deepblue (Post 1839642)
Can anyone tell me where i can find what the name of the main forum prefix is for forums A? I am unsure where to look.


look at your config.php file, where the DB info is, there you can see what prefix you are using.

deepblue 06-30-2009 03:52 PM

Quote:

Originally Posted by webgroup (Post 1840053)
look at your config.php file, where the DB info is, there you can see what prefix you are using.

Thanks, I was able to find that information. However i dont seem be able to get the mod working. I have 2 different licenses on the same server. They are using two different databases at the moment , neither of which have a table prefix on them, its just ''. Ive tried using the same name that the main forum uses for the slave forum, howver i get a database error when i try that. I think i may be doing something wrong. Any help would be great.
Thanks.

webgroup 07-01-2009 05:49 AM

for this to work, you need to use 1 DB
That 1 DB will contatin the 2(or whatever) forums, each forum with a different table prefix
So the DB will have a duplicate of each table, one for each forum.

If neither of your forums use table prefix, you must set one before, you can use the install/tableprefix.php script to change your prefixes on the vB table. Just run it from the browser.

Be sure to also make the appropriate change to config.php.

Then you will have to merge your 2 DB's into 1
Then you apply this hack.

webgroup 07-05-2009 04:58 PM

still waiting for an idea on how to avoid sharing the signatures.

thanks

Shadawg 07-12-2009 01:43 AM

Having one problem with this, if a user joins forum a, they are added to the total member list in forum b, but if a member joins forum b, they are not added to forum a.....

how can i fix this?

Wilfred1 07-19-2009 02:15 AM

This is a godsend and would like to do some testing firstly on the "mySQL Views" option so does anyone have any idea what the source_db syntax would be in the following code for the user table located in a separate db with a different IP Address, db name, dba_username and password but both db's on the same server?

Code:

CREATE VIEW user as
    SELECT * FROM source_db.user;

Secondly with the table prefix concept here would the addition of this mod:
https://vborg.vbsupport.ru/showthread.php?t=211100
help so a user doesn't have to login at both domains?

I can see a couple more vb license costs coming up if this works ok

MagicThemeParks 10-13-2009 12:09 PM

I just want to ask a basic question to make sure that I understand this modification. :)

This modification will allow me to take multiple forums (all with separate vB licenses, of course ;) ) and 'link' them with one single database which will allow for my members on Forum "A" to use their same username/password for Forum "B" and Forum "C" automatically?

What are the drawbacks, if any, for using this setup?

This is exactly what I'm looking for and would love for this to work properly for my network of forums that I'm setting up. :up:


All times are GMT. The time now is 02:44 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.01224 seconds
  • Memory Usage 1,740KB
  • 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)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete