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)

CyberRanger 11-03-2005 12:16 AM

Quote:

Originally Posted by hugojr
Please check your pm's

Thank You

Checked! PM back to you. :D

DieselDesigns 11-10-2005 09:22 PM

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 11-12-2005 02:17 PM

hugojr or westpointer

PLEASE help

DieselDesigns 11-13-2005 07:45 PM

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 11-26-2005 03:48 PM

Quote:

Originally Posted by 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.

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
PHP Code:

Fatal errorCall 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
PHP Code:

$result $DB_site->query("SELECT title, $tableid FROM " TABLE_PREFIX "$tablename $wherecondition ORDER BY title"); 

please someone please help me..

FamilyCorner 11-26-2005 06:58 PM

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?

Quote:

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 11-26-2005 07:04 PM

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 11-27-2005 10:53 AM

Quote:

Originally Posted by 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.

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 11-27-2005 10:59 AM

Quote:

Originally Posted by hugojr
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
PHP Code:

Fatal errorCall 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
PHP Code:

$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 11-27-2005 11:00 AM

Quote:

Originally Posted by FamilyCorner
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 11-27-2005 01:03 PM

Quote:

Originally Posted by westpointer
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 11-28-2005 02:32 PM

Looking forward for this......

Revpolar 12-08-2005 04:03 AM

I found a nice utility to do the string replacements with. Its called FSRU
Code:

http://www.gammadyne.com/freplace.htm#download
Example of how well it worked for me.
Code:

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 12-08-2005 04:13 AM

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

Fenriz 12-08-2005 07:40 AM

Quote:

Originally Posted by westpointer
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 12-08-2005 11:27 AM

Quote:

Originally Posted by minzhong
Do i need an individual license for each 'board' ?

Yes. Each install requires a separate license if you use this method.

CyberRanger 12-08-2005 11:28 AM

Quote:

Originally Posted by Fenriz
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 12-13-2005 07:54 AM

waiting for 3.5.2 release!

boostedsti 12-22-2005 07:21 PM

Westpointer any update on VB3.5.2?

CyberRanger 12-23-2005 12:28 AM

Quote:

Originally Posted by boostedsti
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 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!

Avalon111 01-31-2006 10:54 AM

Quote:

Originally Posted by westpointer
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 02-01-2006 02:09 AM

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



Code:


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 02-01-2006 03:10 AM

Quote:

Originally Posted by westpointer
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 02-01-2006 12:01 PM

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 02-07-2006 06:54 AM

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 02-09-2006 12:02 AM

This worked for me when I got locked out:

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

Post #23

MSC 02-12-2006 08:30 PM

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

Cheers,

Chris

xlguy 02-26-2006 11:44 AM

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 02-26-2006 02:54 PM

I too could use this for 3.5.x ;)

psalzmann 02-26-2006 09:59 PM

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. :)


All times are GMT. The time now is 04:21 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.01735 seconds
  • Memory Usage 1,840KB
  • 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_code_printable
  • (4)bbcode_php_printable
  • (16)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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