Shared user database for multiple forums, same server

[CyberRanger]

For version 3.5x+, please see https://vborg.vbsupport.ru/showthread.php?t=118473

This thread will detail how to have a single login for multiple forums. It makes the following assumptions:
A valid vbulletin license exists for each install
All forums will be on the same server
You already have one forum operational AND that forum uses a BLANK $tableprefix!
One database will contain all the tables

This thread is a follow-up from this discussion (http://www.vbulletin.com/forum/showthread.php?p=971124#post971124) over at vbulletin.com. Thanks to Brains for some pointers!

Here are the steps:

Copy your forum directories to a parallel directory (for example copy /www/forums to /www/new_forums)
In /includes/config.php, change $tableprefix (line 91) to a new prefix [for example $tableprefix = 'new_';]
Run the vb install from the new directory (/www/new_forums/install/install.php)
During the install, be sure NOT to empty the tables. If you have any doubt about what this means, stop NOW! If you empty the tables, you will lose all of your existing data from a prior install!
Download the files from these directories to your PC: /new_forums, /new_forums/admincp, /new_forums/archive, /new_forums/includes, /new_forums/modcp, /new_forums/subscriptions
We are now going to make global changes to the files in the folders (and subfolders) above. I used Dreamweaver's "edit-find and replace" function with "find in" set to "Entire Current Local Site". We are basically going to remove the "TABLE_PREFIX" from any code dealing with the user. (Note - if you are comfortable with unix command, you could do these changes from the command line on the server.)
Run the following find and replace operations:
Find [" . TABLE_PREFIX . "user] (find what's inside the brackets). Replace with [?.?user] This should find 562 instances of user, usergroup, userfield, and usertextfield
Find [" . TABLE_PREFIX . "strikes] (find what's inside the brackets). Replace with [?.?strikes] This should find 5 instances of strikes
Find [" . TABLE_PREFIX . "pm] (find what's inside the brackets). Replace with [?.?pm] This should find 61 instances of pm, pmtext, pmtextid, and pmreceipt.
Upload these directories back to the server.

We now need to do a little fine tuning
In /includes/functions.php: on line 1171 remove the table_prefix before $idname. In /includes/adminfunctions: modify print_choser_row (line 1161)to check for $tableid of user, usergroups

if ($tableid == "user" OR $tableid == "usergroup") {
$result = $DB_site->query("SELECT title, $tableid FROM "."$tablename $wherecondition ORDER BY title");
} else {
$result = $DB_site->query("SELECT title, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY title"); // existing code
}
In /includes/adminfunctions_user.php around line 116 (construct_style_chooser)

$tableid = $tablename . "id";

if ($tablename == "user" OR $tablename == "usergroupid") {
$result = $DB_site->query("
SELECT title, $tableid
FROM "."$tablename
WHERE userselect = 1
ORDER BY title
");

} else {
// existing code
$result = $DB_site->query("
SELECT title, $tableid
FROM " . TABLE_PREFIX . "$tablename
WHERE userselect = 1
ORDER BY title
");
}



Done! Both forums are now accessed by the same user table! PM's are unified across forums as is the user count.

[FleaBag]

Although I personally have no use for this I just wanted to say good work! I know a lot of people will be greatful. :)

[Corriewf]

Awww man you stole my idea!!!!! Its ok though cause I am just happy to see it!

[LICryptkeeper]

oh dear god I have waited for this for so long :S now port it to 3.5! I command you! (;) kidding, nice job)

I would love to get this working with the drupal CMS (I'm having a cookie issue at the moment)

[Nutz]

Very nice hack.
Very nice forums.

Thanks,
Mat

[GoTTi]

can u clear up number 8 for me. i dont understand what u mean...

before i start on a hack or modification i like to know exactly whats goin on...

this has nothing to do with posts right? just user login?

[Bad Bunny]

What transfers with the character to both forums? All of their setting and profile (including profile pic and avatar)? Some of it? None of it?

Ideally it would seem to me you would have password and email the same while everything was per site.

[boostedsti]

What about Subscriptions are those per user or per board?

Also is that a backup copy you are using or is it really live?
Reason I ask is

Stats: Armchairgeneral
Threads: 1, Posts: 1, Members: 7,631
Welcome to our newest member, vernon.miles

Stats:strategyzoneonline
Threads: 32,469, Posts: 421,417, Members: 7,637
Welcome to our newest member, josephhnewkirk

Either way I'm digging script.
Your sites are pretty sweet too.

[goyo]

Great hack...

Now only if we could use separate servers for this... :nervous:

[boostedsti]

Great hack...

Now only if we could use separate servers for this... :nervous:

By looking at the code it looks like you can as long as the database in shared between the boards..

The only thing bad I see is if you decide to expand and add another forum IE 3, 4, 5, 6 etc just imagine how many tables would be in that DB..

[CyberRanger]

What about Subscriptions are those per user or per board?Subscriptions to forums and threads would be by board. However, settings like always getting an email to a thread you start would be by user. The trick is looking at what is in the user table. That determines if the setting is by board or by user. For example, since the custom title is in the user table, it will be the same on both forums. (It cannot be different). Same for the user's signature. Since signature is in the usertextfield table (a shared table) it will be the same for both forums.

Also is that a backup copy you are using or is it really live?
Reason I ask is

Stats: Armchairgeneral
Threads: 1, Posts: 1, Members: 7,631
Welcome to our newest member, vernon.miles

Stats:strategyzoneonline
Threads: 32,469, Posts: 421,417, Members: 7,637
Welcome to our newest member, josephhnewkirk
Great question! It's live! Each forum has it's own stats table so one can see the threads and posts separately for each table. The user number will be off until the nightly cron runs that updates the user count. Some weird effects here but if you dig through the tables and the code it makes sense.
Either way I'm digging script.
Your sites are pretty sweet too.Thanks!

[CyberRanger]

Great hack...

Now only if we could use separate servers for this... :nervous:Yes, that would be great but ... that's an entirely different beast! :nervous:

[CyberRanger]

What transfers with the character to both forums? All of their setting and profile (including profile pic and avatar)? Some of it? None of it?

Ideally it would seem to me you would have password and email the same while everything was per site.Anything that is in the user* tables is shared between the sites. So, email, sig, custom title, etc. Avatars are trickier. Since the avatar field is in user, the user will have the same avatar number for each site. However, the avatar table is not shared so ... he could have a different avatar on each site. However, he could really only control what one of them looks like! If the user has a custom avatar, he could actually control what is displayed on each site. I guess ideally the avatar table should also be shared.

[CyberRanger]

can u clear up number 8 for me. i dont understand what u mean...

before i start on a hack or modification i like to know exactly whats goin on...

this has nothing to do with posts right? just user login?The posts and threads are not impacted at all. Only the user* tables, strike, and pm* tables are shared. (I'll clear up #8 in a bit!)

[Bad Bunny]

The only real use I would have for this is if it totally ran like 2 distinct forums that only shared the core user information (username, password, & email).

[CyberRanger]

The only real use I would have for this is if it totally ran like 2 distinct forums that only shared the core user information (username, password, & email).That would be very hard to do given the current database layout.

[Paul M]

I might be more useful if you actually created a second prefix (TABLE_PREFIX_USERS) and used this, rather than removing the prefix - most people use a prefix for a reason. :)

[CyberRanger]

I might be more useful if you actually created a second prefix (TABLE_PREFIX_USERS) and used this, rather than removing the prefix - most people use a prefix for a reason. :)Yes, absolutely. You may have noticed that in my "find and replace" commands I didn't totally remove TABLE_PREFIX. Instead, where the code reads " . TABLE_PREFIX . ", I replaced that with "." One could easily substitute anything else where the dot is between the quotes. Also, if you need to go back and replace TABLE_PREFIX, you could do a "find-replace" on say ["."user] replace with [". SHARED_TABLE_PREFIX . "user].

[lanas]

On a Linux/Unix machine, you can use this script

# !/bin/bash
# Replace a text inside all files of current dir
# Customize $a and $b variables

# text to search
a='TABLE_PREFIX . "user';

# text to replace
b='USER_PREFIX . TABLE_PREFIX . "user';

for i in `grep -lr $a`
do
echo $i;
mv $i $i~
sed -e "s/$a/$b/g" $i~ > $i
rm $i~
done

Run this script from the forum root 4 times: one for "user" (as above), one for "cp", one for "pm", and one for "custom".

Of course, you still need to manually modify the scripts that use a variable like $table instead of 'user[...]' (and stuff), as stated in first post, adding USER_PREFIX where needed, and insert somewhere your definition (I inserted it in class_core.php, just below the TABLE_PREFIX one).
I also noticed a lack in the first post: if you want to also keep avatar images, you should modify image.php in line 129, adding as usual "USER_PREFIX . " before TABLE_PREFIX.

[CyberRanger]

Handy little script. Note that when you run it you should be logged as the web server user. The file's owner and group will get changed to whoever you run the script as. Also, the files will have the permissions changed to whatever that users umask is set to, which will probably be 644 and okay.

I also had to change:
for i in `grep -lr $a`
to:
for i in `grep -lr $a *` for it to run on my Suse system.

[auz1111]

any idea if this will be ported over to 3.5?

And do you think there is a way to have a parent forum where all threads are shown, but in the seperate/child forums just threads/posts from that forum are shown.

maybe an extra field in the thread row that specifies if it belongs to one of the child forums or just the main...

[tscbh]

Hi westpointer,

I am wondering if you can put each forum on its own database. I have 3 sites and I am planning to add more in the future. This would be easier to backup and maintain the all the sites.

[CyberRanger]

Hi westpointer,

I am wondering if you can put each forum on its own database. I have 3 sites and I am planning to add more in the future. This would be easier to backup and maintain the all the sites.I'm not sure how one would do that. It's a much more complicated situation.

[CyberRanger]

any idea if this will be ported over to 3.5? I've just moved one of my sites to 3.5 so I'll check it out. I don't imagine it would be much different.

And do you think there is a way to have a parent forum where all threads are shown, but in the seperate/child forums just threads/posts from that forum are shown....That's a whole different creature. This hack doesn't impact threads or posts at all. Depending on exactly what you need, you may be able to achieve this through different styles. But, I'm not sure.

[Matthijs]

Hi westpointer,

I am wondering if you can put each forum on its own database. I have 3 sites and I am planning to add more in the future. This would be easier to backup and maintain the all the sites.

As long as they are on the same server, it shouldn't be a problem. You have to change the search-and-replace stuff, though.
The syntax for MySQL is "SELECT foo FROM database.table" so if you change the TABLE_PREFIX to include the database-name and give the db-user access to all databases, it should work without problems...

Edit: you might even put the shared tables in a separate database from the rest of the tables. There are no problems with JOINs and such across databases, I have done that many times...

[CyberRanger]

As long as they are on the same server, it shouldn't be a problem. You have to change the search-and-replace stuff, though.
The syntax for MySQL is "SELECT foo FROM database.table" so if you change the TABLE_PREFIX to include the database-name and give the db-user access to all databases, it should work without problems...

Edit: you might even put the shared tables in a separate database from the rest of the tables. There are no problems with JOINs and such across databases, I have done that many times...Duh ... you are exactly right. That would be a much cleaner solution.

[auz1111]

I've just moved one of my sites to 3.5 so I'll check it out. I don't imagine it would be much different.
That's a whole different creature. This hack doesn't impact threads or posts at all. Depending on exactly what you need, you may be able to achieve this through different styles. But, I'm not sure.


I would love to be able to do it with different style, but i want it to feel like a completely different forum. When working with styles the main forum in the breadcrumb is always the parent forum so it doesn't look like the sub forum is the main one. know what i mean?

[boostedsti]

I've just moved one of my sites to 3.5 so I'll check it out. I don't imagine it would be much different.
That's a whole different creature. This hack doesn't impact threads or posts at all. Depending on exactly what you need, you may be able to achieve this through different styles. But, I'm not sure.
I did the same it works but cant get registration to work correctly.. It still loads the data in the wrong table..

[hugojr]

here is the error I am getting
Invalid SQL:
SELECT username, userid, birthday
FROM ?.?user
WHERE (birthday LIKE '10-30-%' OR birthday LIKE '10-31-%')
AND usergroupid IN (0, 6, 7, 2, 5)


mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?.?user
WHERE (birthday LIKE '10-30-%' OR birthday LIKE '10-31-%')
AND use' at line 2

mysql error number: 1064

what does this mean?

[hugojr]

please help me bump

[CyberRanger]

here is the error I am getting
Invalid SQL:
SELECT username, userid, birthday
FROM ?.?user
WHERE (birthday LIKE '10-30-%' OR birthday LIKE '10-31-%')
AND usergroupid IN (0, 6, 7, 2, 5)


mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?.?user
WHERE (birthday LIKE '10-30-%' OR birthday LIKE '10-31-%')
AND use' at line 2

mysql error number: 1064

what does this mean?It looks like maybe you've created a a double-double quote in that sql statement. Something that looks like "".""user
I'll try to locate the exact spot where this sql is coded later today but if you can search in for "birthday" in the php files under includes.

[hugojr]

It looks like maybe you've created a a double-double quote in that sql statement. Something that looks like "".""user
I'll try to locate the exact spot where this sql is coded later today but if you can search in for "birthday" in the php files under includes.

I have look everywhere can't find nothing wrong, just incase I am using version 3.0.9

Please if you can clear up your explanation of #8 a little better..

Thank You..

[hugojr]

In /includes/functions.php: on line 1171 remove the table_prefix before $idname.
if (!$check = $DB_site->query_first("SELECT $selid FROM " . TABLE_PREFIX . "$idname WHERE $idname" . "id=$id"))

this is what it look like after according to your explination

if (!$check = $DB_site->query_first("SELECT $selid FROM " "$idname WHERE $idname" . "id=$id"))

is that correct?

[hugojr]

also In /includes/adminfunctions: modify print_choser_row (line 1161)to check for $tableid of user, usergroups

line 1161 before code change if (!is_array($GLOBALS["$cachename"]))

now what I want to know is where do I add your code before or after

also In /includes/adminfunctions_user.php around line 116 (construct_style_chooser)

line 116 before code change function construct_style_chooser($title, $name, $selvalue = -1, $extra = '')

is the code you are giving before or after the code that is there

[CyberRanger]

here is the error I am getting
Invalid SQL:
SELECT username, userid, birthday
FROM ?.?user
WHERE (birthday LIKE '10-30-%' OR birthday LIKE '10-31-%')
AND usergroupid IN (0, 6, 7, 2, 5)


mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?.?user
WHERE (birthday LIKE '10-30-%' OR birthday LIKE '10-31-%')
AND use' at line 2

mysql error number: 1064

what does this mean?Can you post what you have in includes/functions_databuild.php from line 840 to 846? It should look like this (assuming you've replaced " . TABLE_PREFIX . " with "."
$bdays = $DB_site->query("
SELECT username, userid, birthday
FROM "."user
WHERE (birthday LIKE '$todayneggmt-%' OR birthday LIKE '$todayposgmt-%')
AND usergroupid IN ($usergroupids)
$activitycut
"); What do you have there?

[CyberRanger]

In /includes/functions.php: on line 1171 remove the table_prefix before $idname.
if (!$check = $DB_site->query_first("SELECT $selid FROM " . TABLE_PREFIX . "$idname WHERE $idname" . "id=$id"))

this is what it look like after according to your explination

if (!$check = $DB_site->query_first("SELECT $selid FROM " "$idname WHERE $idname" . "id=$id"))

is that correct?Correct, you may want to do a "." just to help you find it in the future. To be honest, I don't know for sure what else is used by this query. This may need to be wrapped in an if statement instead. Can anyone else verify if this is only used for user type queries?

[hugojr]

Can you post what you have in includes/functions_databuild.php from line 840 to 846? It should look like this (assuming you've replaced " . TABLE_PREFIX . " with "."
$bdays = $DB_site->query("
SELECT username, userid, birthday
FROM "."user
WHERE (birthday LIKE '$todayneggmt-%' OR birthday LIKE '$todayposgmt-%')
AND usergroupid IN ($usergroupids)
$activitycut
"); What do you have there?

this is what I have from line 840 to 846
$bdays = $DB_site->query("
SELECT username, userid, birthday
FROM ?.?user
WHERE (birthday LIKE '$todayneggmt-%' OR birthday LIKE '$todayposgmt-%')
AND usergroupid IN ($usergroupids)
$activitycut
");

[CyberRanger]

this is what I have from line 840 to 846Could you post the URL of the problem page?

[hugojr]

Could you post the URL of the problem page?

Please check your pm's

Thank You

[hugojr]

Is there anyone else that has installed this hack that can help us out we are willing to pay $$$$ please pm us if you are intrested...

[CyberRanger]

Please check your pm's

Thank YouChecked! PM back to you. :D

[DieselDesigns]

I am very new to vbulleting and i don't know anything about php. but i would like to setup a 2 message boards and give same users access. can anyone help me?

[DieselDesigns]

hugojr or westpointer

PLEASE help

[DieselDesigns]

Can anyone please help out a newbie please come on what does it take some money that is ok by me. As you can tell I do not know nothing about php nor vbulletin so please help me.

[hugojr]

Can anyone please help out a newbie please come on what does it take some money that is ok by me. As you can tell I do not know nothing about php nor vbulletin so please help me.

OK I have done everthing but I am getting an error in the admincp now everytime I go to search for users I get this error
Fatal error: Call to a member function on a non-object in /home/hugojr/public_html/florida2/includes/adminfunctions.php on line 1156


what does this mean? here is what line 1156 looks like
$result = $DB_site->query("SELECT title, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY title");

please someone please help me..

[FamilyCorner]

I just posted this in a different forum before finding this thread. PLEASE first of all, reading my post below, am I understanding it correctly, that this hack will do what I am requesting below?

AND ALSO

will this work with 3.5.1?

I own a website that is "sister sites" with another. We intertwine quite a bit of content and our design is the same, other than the logos and colors. Before I ask this question it is important to note that I have NO PROBLEM and already PLAN to purchase a completely separate license for the second website.

What I would like to do is twofold:

1) I'd like to import my users into the forums that I install on the second site

2) I'd like to be able to have one sign in for both sites.

Does that make sense? So if MemberJoe signs in to "Site A" and browses around, posts a few times, then visits "Site B" he would automatically be signed in and wouldn't have to do it again.

Is there a way to do this??

Again, I'm going to purchase the second license, that is definitely not a problem

[FamilyCorner]

I should probably make sure that I point this out, the two different sites are on the same server but are completely different domains.

[CyberRanger]

I should probably make sure that I point this out, the two different sites are on the same server but are completely different domains.
I haven't tried this with ver 3.5.1 but the concept would be the same. It would take some slight tweaking (ie DB_site) is no longer the correct syntax, but you could probably figure it out.

This does look like what you'd want. You don't "import" the users into the second db, it simply reads the users from the same db.

[CyberRanger]

OK I have done everthing but I am getting an error in the admincp now everytime I go to search for users I get this error
Fatal error: Call to a member function on a non-object in /home/hugojr/public_html/florida2/includes/adminfunctions.php on line 1156


what does this mean? here is what line 1156 looks like
$result = $DB_site->query("SELECT title, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY title");

please someone please help me..

Hmm, that looks fine to me. The only function you are callind is $DB_site so I'm not sure why line 1156 would not work while 1154 does. What happens if you make the two the same? Does the query run then? (Obviously, don't leave it that way! Just for testing the code.) ;)

[CyberRanger]

will this work with 3.5.1?
A number of folks have ask me to do this. I'll tried to do a 3.5.1 example this week. :up:

[FamilyCorner]

A number of folks have ask me to do this. I'll tried to do a 3.5.1 example this week. :up:

Thank you so much!!

[lazyseller]

Looking forward for this......

[Revpolar]

I found a nice utility to do the string replacements with. Its called FSRU http://www.gammadyne.com/freplace.htm#download
Example of how well it worked for me.
OPERATION COMPLETE

Search string summary:
". TABLE_PREFIX . "user": 562

Number of files processed: 169
Number of lines processed: 94,729
Total number of occurrences: 562
Files with occurrences: 92
Lines with occurrences: 558

Elapsed time: 954 milliseconds
Processing speed: 99,296 lines per second.

[minzhong]

Do i need an individual license for each 'board' ?

[Fenriz]

A number of folks have ask me to do this. I'll tried to do a 3.5.1 example this week. :up:

I have 2 forums (3.5.2) on the same server and want to share user database from one forum to another. Is it the right hack for that? Could you make it for vbulletin 3.5.2?

Thank you!

[CyberRanger]

Do i need an individual license for each 'board' ?
Yes. Each install requires a separate license if you use this method.

[CyberRanger]

I have 2 forums (3.5.2) on the same server and want to share user database from one forum to another. Is it the right hack for that? Could you make it for vbulletin 3.5.2?

Thank you!I keep meaning to to that. Time is the enemy. (Yes, this is the right hack.)

[b65ran]

waiting for 3.5.2 release!

[boostedsti]

Westpointer any update on VB3.5.2?

[CyberRanger]

Westpointer any update on VB3.5.2?Sorry, I just haven't had the time to do this. Not forgotten. Maybe next week. :nervous:

[boostedsti]

Cool enjoy the holidays

[ekool]

Any update so this will work with 3.5.X?

[Eagle Creek]

Any update so this will work with 3.5.X?

Looking for this for ages!
Thankyou!

[IrPr]

Looking for this for ages!
Thankyou!
Same here !

[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!

[CyberRanger]

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]

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]

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

[psalzmann]

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]

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!

[Avalon111]

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!
i am looking forward to it!

thank you for your efforts!!!

[hugojr]

I am getting the following errors in the admincp once I try to change a users permission.





Warning: Invalid argument supplied for foreach() in /admincp/user.php on line 905



Warning: Invalid argument supplied for foreach() in /admincp/user.php on line 924





can someone please tell me what this means

[psalzmann]

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!

Sure,

One thing I can say that is not working as described in your how to, would be the Member Count. For some reason, after 2-3 days now, New Forum #2 is still only showing 1 user.... however is there something I can run to sync this up? You quickly mentioned something about waiting for Cron to refresh. Where exactly do I run this to refresh? and wouldn't it have done it already?

Regards,
Peter

[oldengine]

I'm looking forward to this on 3.5.3 so I can run a forum on one domain and classified ads on another.

[lanas]

Please help me, after applying this hack I can't login in the admincp!
Everything else seems working fine, but when I login in admincp I return to login form, maybe a session problem?

:ermm:

[oldengine]

This worked for me when I got locked out:

http://www.vbulletin.com/forum/showthread.php?t=73439

Post #23

[MSC]

Is this the same code for 3.5.2 or do I need to change anything.

Cheers,

Chris

[xlguy]

Westy: Any luck working out how do this for 3.5.x? I really need to have two installs of vB sharing the same user database and so far this is the nearest thing I've found. Cheers for your help so far.

[hbalagh1]

I too could use this for 3.5.x ;)

[psalzmann]

I don't think you guys realize... that this is a general hack that is not just for vb 3.. it can be used in ANY vb version, it's the "guts" behind the hack/info that defines how or what should be done.

Keep in mind, even with the proper info above for the "set" version he is writing this hack for, still does not work out of the box. Well, it does kinda, if you use the exact version the author is using. However, even the instructions I had to work with, I was missing some strikes table and a few others.. I just skipped them. No harm done.

The only problem I've had with this hack is very minor --

When you have a Running board, with say 1000 members or posts and then begin this hack to a fresh board, the new board statistics do not reflect the old board.

ie: 1 Thread, 1 Post, 1 Members

Then I made a tweak to at least show who's online (I made old board and the new board look at the same `sessions` table, so now if there are 5 users on the old board, there is 5 users + how many users are on the new board. That works.

The problem we have is the "new fresh board" member count. It's only showing 1 member - Admin. However, now I've got to find a way to refresh this stats.. if possible.. to reflect what both boards show. I think it's some serilized data somewhere in the db. I'll figure it out soon enough. :)

[justindwhite]

I don't think you guys realize... that this is a general hack that is not just for vb 3.. it can be used in ANY vb version, it's the "guts" behind the hack/info that defines how or what should be done.

Keep in mind, even with the proper info above for the "set" version he is writing this hack for, still does not work out of the box. Well, it does kinda, if you use the exact version the author is using. However, even the instructions I had to work with, I was missing some strikes table and a few others.. I just skipped them. No harm done.

The only problem I've had with this hack is very minor --

When you have a Running board, with say 1000 members or posts and then begin this hack to a fresh board, the new board statistics do not reflect the old board.

ie: 1 Thread, 1 Post, 1 Members

Then I made a tweak to at least show who's online (I made old board and the new board look at the same `sessions` table, so now if there are 5 users on the old board, there is 5 users + how many users are on the new board. That works.

The problem we have is the "new fresh board" member count. It's only showing 1 member - Admin. However, now I've got to find a way to refresh this stats.. if possible.. to reflect what both boards show. I think it's some serilized data somewhere in the db. I'll figure it out soon enough. :)

well do you mind sharing how you got yours to work? I have tried many times and failed.

[Rahjeir]

I went another route. I replaced TABLE_PREFIX with MERGE_PREFIX and defined it. Though I merged alot more tables then the ones defined here.

For 3.5.X I had to edit the class_dm.php. These are the two stock lines I needed to edit for a 3.5.X. My forums have been running merged for 1 1/2 years now. Only minor issues come up.

class_dm.php(rewrite with your merged value.)
Search for
$return = $this->db_insert(TABLE_PREFIX, $this->table, $doquery);

Search for
$return = $this->db_update(TABLE_PREFIX, $this->table, $this->condition, $doquery, $delayed);

Other then that, the above hack should work.

[lovevn]

I could pay if anyone can do this for me. I am using 3.5.x

Thanks

[john_robot]

Hi, This is really good info , I want to do something different , I want to to get all the forum posts categories and what ever it has except the skin template , can you please guide me on this. the idea is I want to have a different skin on one of my forum.

[Fenriz]

westpointer is dead

[CyberRanger]

hehe ... no, not dead. I think the one poster summed it up well. This is more a concept than an easy to install mod. If you aren't versed in php, I really don't recommend trying this.

:banana: :banana:

[dicb]

I'm about to try this for 3.5.4 right now. I have a site ready to launch, and I'm this is all I need for it. Just to let you know, I assumed I would have to figure this out myself untill I googled "vbulletin same login on multiple forums".

Whether this works or not, I want to thank Westpointer for this BEFORE I start cursing and screaming.

Here goes. I'm not optomistic. If you don't hear back from me shortly assume the worst and don't try it on 3.5.4.

[dicb]

I should note, I backedup the entire new forum directory, so my numbers may be off here, especially since I see them replacing things in the install dir. I just thought better safe than sorry since their may be more things that needed changes made in them than 3.0.8 did.

First replace... 597 replaced in 315 documents.

Second replace... 8 replaced in 315.

Third replace... 77 replaced in 315.

#8 - changed [ . TABLE_PREFIX . $idname] to [. "$idname] on line 1242 of /includes/functions.php

print_chooser_row (with two o's) starts on line 1497 of /includes/adminfunctions.php. started replacement at 1506, but I'm not sure I did it right. I replaced if (!is_array($GLOBALS["$cachename"]))
{
$GLOBALS["$cachename"] = array();
$result = $vbulletin->db->query_read("SELECT title, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY title");
while ($currow = $vbulletin->db->fetch_array($result))
{
$GLOBALS["$cachename"]["$currow[$tableid]"] = $currow['title'];
}
unset($currow);
$vbulletin->db->free_result($result);
} with if ($tableid == "user" OR $tableid == "usergroup") {
$result = $DB_site->query("SELECT title, $tableid FROM "."$tablename $wherecondition ORDER BY title");
} else {
$result = $DB_site->query("SELECT title, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY title"); // existing code
}


Once again, I have no idea if that's right.

construct_style_choose starts on line 166. Replaced on line 175, $tableid = $tablename . "id";
with...
$tableid = $tablename . "id";

if ($tablename == "user" OR $tablename == "usergroupid") {
$result = $DB_site->query("
SELECT title, $tableid
FROM "."$tablename
WHERE userselect = 1
ORDER BY title
");

} else {
// existing code
$result = $DB_site->query("
SELECT title, $tableid
FROM " . TABLE_PREFIX . "$tablename
WHERE userselect = 1
ORDER BY title
");
}

I'm not sure I did everything right, or if there is more that needs to be done, however that is what I did. I am uploading them now, but don't have time to test it. Timestamp should give an idea of how long it took, but subtract one cig break for sanity.

[dicb]

whhew, I'm glad I documented that... cause it worked.... er, almost.
The PM's are screwed up. I can compose and send them... but I can't read them. Even if I send one, I can't view it in my sent items folder. When I switch between the forums they both show the same thing (2 messages in inbox) and when I go to my PM folder the space where the PM title should be is blank. There are still two rows in the table (one for each message) and there is even that little check box on the right to mark them for deletion. Only problem is with no title to the message, I can't view the message.

Bottom line, everyone has been bugging to get this ported to 3.5.x, but nobody just went through it to see if it would work. It almost did. All you have to do is follow the directions carefully. Westpoint - excellent job here on this hack. Your time and efforts are greatly appreciated by everyone here, regardless of how they express it. Hopefully you or someone here will be able to get the PM issue fixed. It looks like something small, cause I'm not getting any error messages. Unfortunatly I don't know how vb works well enough to figure it out myself.

[dicb]

Well, I spoke too soon. Registration is completely jacked up. Depending on which forum you register in, you'll have different problems. Undoing all the work.

Cheers, and hopefully someone will have more sucess than I, and maybe my experiment will help a little.

[dicb]

I found more details, but it doesnt' seem like anyone cares... Anyway, if you register in the forum that doesn't use the prefix, everything is find. If you register in any of the other forums, things get very squirrly.

[Fenriz]

dicb, is it work properly in 3.5.4 now?

[tyfoon]

I 've managed it working in 3.54 now trying to make it work whith the users in a special user database.

[e2s]

I have everything working as well except when registering a new user from the new forums. It is still adding it to the new database user table instead of the old existing. Does anyone have any helpfull tips on where to find the insert statement that adds in a new user.

Any help is appreciated

Thanks

[e2s]

Ok got past the previous post problem. The current issue is in the Private Messaging. Whe I send a PM from the new site I get no error message and the message shows in my sent items however does not show in my inbox. I looked in the database and in table pmtext I can see the PM inside of table PM I see one entry which would be what shows in my PM box. What I don't see is the second entry that would allow it to show in my inbox.

I have been over the code way to many times and I think I am just missing it somewhere any help would be appreciated. It is really hard to find problems when there is no errors.

Thanks

[e2s]

Ok not sure if anyone is interested or how I could distribute this but I have the entire program working just I didn't keep track of the changes needed to make it work. Can I just remove my license key from all files and zip all the files together? I don't know what the rules are and how to go about this. I have it working on V3.5.

Any help would be great, Thanks

[lovevn]

Could you please show me the demo?
Thanks

[e2s]

The demo would be

forums.everything2stroke.com
and
forums.everythingmx.com

I am still looking into how I can package this to make it easy to distribute

[Steve F]

Works great, just signed up on both *well, just on 1 ;)*

I hope you'll find your way around re-packaging the mod, really looking forward to test it on my board(s)

[CyberRanger]

Ok not sure if anyone is interested or how I could distribute this but I have the entire program working just I didn't keep track of the changes needed to make it work. Can I just remove my license key from all files and zip all the files together? I don't know what the rules are and how to go about this. I have it working on V3.5.

Any help would be great, Thanks
First, great work! Thanks for keeping this concept alive. I've simply not had the appropriate amount of time to devote to it. How to package it is the tough thing. I'm fairly certain that you are NOT allowed to distribute entire vb replacement files here. You have to just show the hacks. I'm not positive about that but I think that's true.

[Kirk Y]

Yeah you're not allowed to display full source code, good luck with repackaging it -- it'd be an excellent hack!

[e2s]

Yeah I asked a Moderator and that is what they told me. I am however still going to work on getting instructions setup to make this work. They led me to a compare program so I am going thru and comparing the files and seeing what all that I changed.

I promise I will get this up soon as possible. I know this was a huge thing for me to be able to get another site up and running. I did successfully take the code off the second site and install it to a now third site with very little work so once you get it done once I think the sky is the limit on creating new sites.

I will post links to the directions once I get them up

[e2s]

Ok guys here it is

https://vborg.vbsupport.ru/showthread.php?t=118473

westpointer I hope you don't mind i used bits and pieces of your directions to save time. I did give credit so I hope that is ok

If you have any questions about this modification please post in the new thread above.

Thanks

[CyberRanger]

Ok guys here it is

https://vborg.vbsupport.ru/showthread.php?t=118473

westpointer I hope you don't mind i used bits and pieces of your directions to save time. I did give credit so I hope that is ok

If you have any questions about this modification please post in the new thread above.

Thanks

Excellent! I'll add your link to the top of this thread.

[Ahsin1]

im using 3.6.x can some do this for me? pm me please.. THANKS

[CyberRanger]

im using 3.6.x can some do this for me? pm me please.. THANKS
Sorry, I just don't have the time for any additional projects now.

[massiveblack]

is it possible to run something like this across multiple servers?

I run a big board (90k members, 1.5 million posts and 1.3 million visits a month) and am wanting to expand into multiple other forums. Basically setting up about thirty other forums (when it is all done) and having each current user being automatically registered, and all new members being able to auto register across all forums no matter which one they sign up on. Since my site allows image uploads and is art heavy, I do not think a single server is possible when it is all said and done. I will need many servers eventually.

If anyone can assist me with this, please let me know at jmanley@massiveblack.com The site is called conceptart.org and you can find the forums link atop the page. We are making a photography forums, a fine art forums and some other areas.

Please advise...just talented artists here, not many programmers.


Jason

[CyberRanger]

I'm experimenting with that right now with vb 3.6.8. I "think" that it's possible given all the right conditions. I'll post back here in a week or so with my results.

[TundraSoul]

I'm experimenting with that right now with vb 3.6.8. I "think" that it's possible given all the right conditions. I'll post back here in a week or so with my results.

Great, let everyone know if it works. vB totally needs to implement this kind of feature into their software.

[CyberRanger]

Great, let everyone know if it works. vB totally needs to implement this kind of feature into their software.
oh man, I forgot I posted this! I've done it and it works great. Create an account at www.armchairgeneral.com/forums then go over to http://www.armchairhq.com/forums/ (nothing really in that forum, it's a test area.)

Those two forums are on the same server ... but if you really want to see the potential, go to www.brentandmary.net/vb36 (login is acg, 99acg99). Now that rocks! That's three databases on two different servers tied into the same vb user login.

Now ... I just gotta find the time to document how to do it. For those who can get a command line, I think I can do a unix script that would all the changes automagically in seconds!

Why vb doesn't support this is a mystery to me. The easily could.

[TundraSoul]

I don't mind doing the edits, I just need to know what to do. (drool)...

[geckofrog]

me too, I need this!

[massiveblack]

Is there any more information on this?

Much appreciated...truly.

JM

[Reeve of shinra]

I would really like this as well.

[glaird]

Cross-server is just what I'm looking for! :D :D Have you had a chance to document it yet?

thanks!

[superthang]

any up for this on 3.6.8 or 3.7 ?

cyberranger your my hero! please share!

[Sean James]

Is this available?

[sv1cec]

I know this is a very old thread, but I am still running 3.0.xx and I need to build a second site which will use the user tables of my first one, so here I am.

I would like to know how the "sessions" are handled. I have some questions here and I would appreciate if someone can answer them for me.

Let's assume two sites, A and B. With this hack, all user information is kept in the "user" table in database A.

A member of site A logs in Site B. Obviously, since the last login time is stored in the shared user table, the last login time entered in the table, will be common for both sites, correct? So if the member comes back after two days and logs in site A, the last login time will be the last login time from his visit in site B. That means that if the user asks to see the new posts since his last visit (for example), the posts shown to him will not be correct, he will miss the posts between the last time he visited site A and the time he visited site B. Am I correct on this? It is of course possible to alter the user table to have separate columns for these time parameters for site A and site B.

Another question: again, let's suppose that a member logs in site B, does some work there and then follows a link to site A. Will he still be logged in in site A or will he need to re-log in in the other site? In other words, how are cookies handled? And what difference will it make if someone uses the "Remember me" checkbox in one site?

Finally a code question: the author suggests that we use a new table prefix for the new database "new_". The changes suggested show an empty table prefix though, for the old database. Shall I assume that wherever it is suggested to replace " . TABLE_PREFIX . " with ".", if one uses a prefix in the old database, he should replace " . TABLE_PREFIX . " with whatever his old table prefix is? I guess one could define something like "USER_TABLE_PREFIX" with the value of the table prefix used in the first site, and do the find and replace operations you suggest?

Again, I am aware this is an old hack, which has already been ported to later vB releases, but since I do not plan to use later releases, and this thing is pressing me, I would certainly appreciate any help you can give me.