vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Multiple Forums using a single user table (https://vborg.vbsupport.ru/showthread.php?t=118473)

e2s 06-14-2006 09:04 AM

Quote:

Originally Posted by RMS-Chef
How are paid subscriptions effected by this if at all?
If they buy a subscription on the slave site, does it effect anything on the existing main site?

That is a great question but I don't have the answer. I know in the current setup all the usergroups are used by the slave sites so if a member is a paid member in the master site they will also be a paid member in the slave.

I will look into what it will take to get the subscription to work on the slave sites.

e2s 06-14-2006 09:05 AM

Quote:

Originally Posted by Steve F
This must be one of the most sought after hacks, great work e2s, thank you for sharing with us and thanks Westpointer for the original idea :)!

lovevn: I am sure it would work

Thanks Steve, hopefully it will help some people out.

TheComputerGuy 06-14-2006 11:13 AM

awesome hack e2s!

e2s 06-14-2006 11:37 AM

Quote:

Originally Posted by RMS-Chef
How are paid subscriptions effected by this if at all?
If they buy a subscription on the slave site, does it effect anything on the existing main site?

Looks like this can be taken care of real easy I am going to try this today and if all works well i will post up the instructions. It should just be a mass Search and replace on table subscriptions and subscriptionlog


Thanks ComputerGuy

utw-Mephisto 06-14-2006 12:57 PM

Quote:

Originally Posted by e2s
I have no experiance in doing this so I am not sure I could be of much help

Can't you use Impex ? just wondering .

lovevn 06-14-2006 02:26 PM

Thanks for your reply @e2s

BTW I have one question:

Quote:

Search for [" . TABLE_PREFIX . "user] Replace with [" . "vb3_user] where "vb3_" is the prefix to your master site. 110 Files modified
If in my master site I do not user prefix so which one is correct?

1. [" . "_user]

2. [" . "user]

Thanks

e2s 06-14-2006 03:25 PM

Number 2 if you have nothing for a prefix.

Snake 06-14-2006 04:57 PM

Great idea!

e2s 06-15-2006 03:46 PM

Ok I have the paid subscriptions working but it is not perfect and kind of wierd how you have to go about getting it to work on the slave sites.

Here are the directions

1.) Search for [" . TABLE_PREFIX . "payment] Replace with [" . "vb3_payment] where "vb3_" is the prefix to your master site. 16 Files modified 36 Total Changes

2.) Search for [" . TABLE_PREFIX . "subscription] Replace with [" . "vb3_subscription] where "vb3_" is the prefix to your master site. 20 Files modified 68 Total Changes

IMPORTANT: This next change is needed regardless if you want to manage users from the slave site Admin console. This will make the Primary Usergroup list correct when editing a user or setting up a new subscription.

admincp/adminfunctions.php
Search for
PHP Code:

                $result $vbulletin->db->query_read("SELECT title, $tableid FROM " TABLE_PREFIX "$tablename $wherecondition ORDER BY title"); 

Replace with
PHP Code:

if ($tablename == "usergroup")
                {
                
$result $vbulletin->db->query_read("SELECT title, $tableid FROM " "vb3_$tablename $wherecondition ORDER BY title");
                }
                else
                {
                
$result $vbulletin->db->query_read("SELECT title, $tableid FROM " TABLE_PREFIX "$tablename $wherecondition ORDER BY title");
                } 

Now to get Subscriptions to appear on your slave site you have to log into the slave site Admin console and create a dummy subscription which seems to activate paid subscriptions. The subscriptions from your Master site will be the only options your members will have however. You must create and edit your subscriptions from the Master site only.

I looked at the code for a long time and just don't understand enough of it to find out what it works the way it does. However I have tested the paid subscription and everything works perfect.

futuredood 06-20-2006 07:15 PM

if i were to click "find more posts by user a", would it be able to come up with threads and posts by that user in both forums? that way, i can follow "user a" between both forums?

i was searching for a hack that this one kind of fulfills.. https://vborg.vbsupport.ru/showthread.php?t=119107


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.01261 seconds
  • Memory Usage 1,749KB
  • 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
  • (2)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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