vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Shared user database for multiple forums, same server (https://vborg.vbsupport.ru/showthread.php?t=98233)

boostedsti 12-23-2005 02:34 AM

Cool enjoy the holidays

ekool 01-03-2006 10:54 PM

Any update so this will work with 3.5.X?

Eagle Creek 01-12-2006 09:30 PM

Quote:

Originally Posted by ekool
Any update so this will work with 3.5.X?

Looking for this for ages!
Thankyou!

IrPr 01-19-2006 10:47 AM

Quote:

Originally Posted by Eagle Creek
Looking for this for ages!
Thankyou!

Same here !

Bluestrike2 01-24-2006 12:54 AM

Hi west!

Anyhow, once you figure out how to do this with 3.5.3, I, and numerous others, will be extremely grateful.

Only question with that is this - will I be able to still "merge" the databases if both forums are already setup, but not large at all?

Thanks!

CyberRanger 01-24-2006 01:22 PM

Quote:

Originally Posted by Bluestrike2
Hi west!

Anyhow, once you figure out how to do this with 3.5.3, I, and numerous others, will be extremely grateful.

Only question with that is this - will I be able to still "merge" the databases if both forums are already setup, but not large at all?

Thanks!

Under the current setup, merging would be difficult. I'm going to modify the install instructions (eventually :disappointed: ) so that instead of each install being in the same db, they have a different db's with the user's linked view a "shared_prefix" when calling tables.

Has anyone tried doing this with 3.5.x? The concept is identical; there may just be other places where if statements need to be used instead of a straight find and replace.

psalzmann 01-30-2006 09:03 AM

One of the things I thought I'd see present in this hack would be the ability to show all users logged in from all sites in the form of one big who's online.

For example, if I have 5 users on site 1, and 10 users on site 2, I would be looking at a list of 15 users total.

Why doesn't the who's online feature show all members on both sites? I guess it's because the "session" table is unique on site 1 and site 2. Is this possible to show all logged in users from both active sites?

Would it be a matter of modifying the whos online for the 2nd install to use Site 1's session table? would there be any problems sharing the 'session' table?

Regards,
Peter

Avalon111 01-30-2006 01:11 PM

it seems that part 8 is out of date. its no longer working. how could we get this working again?

psalzmann 01-30-2006 06:20 PM

There is nothing wrong with any of the instructions. Not only this, but I was able to share the 'sessions' table and now all users are actively shown on both sites. :)

The good news is it's working.. just like I thought it would.. the bad news is it's way to early to tell if anything will or can go wrong. :)

Also, since I'm not having a problem, and I'm also on a way older version of VB than described in this hack, just to let you know.... #8 the $idname hack info above for a certain function didn't even exist!

Not only this, my search and replace couldn't find any " . TABLE_PREFIX . "strikes either. When in doubt, the only thing really required is review of your SQL statement. When the author says replace " . TABLE_PREFIX ."user with "."user he really means replace it just like that.

I will mention another thing that puzzled me, if you notice, the author is using some special "quote" around his periods in the tutorial above. In my case, it appeared like block characters in my Search and Replace function so I just replaced the funky `` quotes into single double quotes surrounded by the period. ie: "."

Regards,
Peter

CyberRanger 01-30-2006 06:34 PM

Peter - thanks for explaining some of the above. Yes, this is for vb3.0.x. The concept is the same for vb 3.5.x but you will need to make changes, especially for #8. I keep saying I intend to update this but between RL, helping with ecDownloads, finishing up a new extension I'm about to release ... not enough time in the day!


All times are GMT. The time now is 01:51 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.01386 seconds
  • Memory Usage 1,739KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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