PunBB Forums - 4 forums in one database

Re: 4 forums in one database

dummy@example.com (lovekieu) — Tue, 24 Mar 2009 08:00:31 +0000

I did nothing, i don't work them

Re: 4 forums in one database

dummy@example.com (Xavier77) — Tue, 29 Jul 2008 16:21:35 +0000

this works in the new version? (1.3)

Re: 4 forums in one database

dummy@example.com (xsdmx) — Wed, 25 Jun 2008 03:48:31 +0000

How would I do this, if I have two seperate databases, i.e.

mudkips1

mudkips2

mudkips1(main)

Would I do this?

$sql = str_replace($this->prefix ."users", "mudkips1_users", $sql);

Re: 4 forums in one database

dummy@example.com (cedced) — Thu, 07 Jun 2007 05:05:53 +0000

flx wrote:

you have to search your whole punbb folder for
$db->prefix.'users
then change the prefixes

it's working ?

Re: 4 forums in one database

dummy@example.com (MattF) — Sun, 03 Jun 2007 19:31:40 +0000

Now that this has been dragged back up, just to double check, those str_replace lines would need to go after:

function query($sql, $unbuffered = false)
{

in the db script?

Cheers,

Matt

Re: 4 forums in one database

dummy@example.com (twohawks) — Fri, 09 Feb 2007 00:12:06 +0000

Thank you. I had not looked up the comand. I understand.
Cheers,

Re: 4 forums in one database

dummy@example.com (elbekko) — Thu, 08 Feb 2007 22:03:24 +0000

If you're replacing a set string, ditch the ereg. Really.

$sql = str_replace($this->prefix ."users", "MAINFORUMPREFIXusers", $sql);
$sql = str_replace($this->prefix ."groups", "MAINFORUMPREFIXgroups", $sql);
$sql = str_replace($this->prefix ."online", "MAINFORUMPREFIXonline", $sql);
$sql = str_replace($this->prefix ."forum_perms", "MAINFORUMPREFIXforum_perms", $sql);
$sql = str_replace($this->prefix ."reports", "MAINFORUMPREFIXreports", $sql);

Re: 4 forums in one database

dummy@example.com (twohawks) — Thu, 08 Feb 2007 21:46:02 +0000

Followup to Tobi's method:
I am working on an archive method (or two, see here: http://www.punres.org/viewtopic.php?pid=13630 )
and using Tobi's method for utilizing the "main" forum's user database for the "archive" forum.

I found it works most completely if I add the following lines at Line 76:

        $sql = ereg_replace($this->prefix ."users", "MAINFORUMPREFIXusers", $sql);
        $sql = ereg_replace($this->prefix ."groups", "MAINFORUMPREFIXgroups", $sql);
        $sql = ereg_replace($this->prefix ."online", "MAINFORUMPREFIXonline", $sql);
        $sql = ereg_replace($this->prefix ."forum_perms", "MAINFORUMPREFIXforum_perms", $sql);
        $sql = ereg_replace($this->prefix ."reports", "MAINFORUMPREFIXreports", $sql);

I am sure it can be re-written to be less code, but the idea is it allows for seemingly unequivocal (comprehensive) management of the users and their permissions from a single (the main) forum.

Since I am using the code I thought it would be useful to post this here.
Cheers,

Re: 4 forums in one database

dummy@example.com (zemond) — Wed, 15 Nov 2006 05:06:27 +0000

Gday all,

Tobi you posted this,

Something like
Code:
$sql = ereg_replace($this->prefix ."users", "YOURTABLEusers", $sql);
Should work .
It must be placed in line 76 of include/dblayers/mysql.php
Replace YOURTABLE with the prefix of the usertable that you want to use.

dbplyers dosnt exist on my installation, im running the latest version, any solution?

Cheers, james

Re: 4 forums in one database

dummy@example.com (erinther) — Thu, 08 Jun 2006 20:09:54 +0000

I did nothing. I had to change all my plans and work with only one forum.

Re: 4 forums in one database

dummy@example.com (quaker) — Mon, 05 Jun 2006 20:33:41 +0000

did u set the each config.php cookie to the same thing?

$db_type = 'mysql';
$db_host = 'localhost';
$db_name = 'name_forum';
$db_username = 'name_forum';
$db_password = 'bigmama';
$db_prefix = '';
$p_connect = false;

$cookie_name = 'punbb_cookie';
$cookie_domain = '';
$cookie_path = '/';
$cookie_secure = 0;
$cookie_seed = '275be39a'; <---------------------------did u set then all to the same thing?

define('PUN', 1);

Re: 4 forums in one database

dummy@example.com (FhdQa) — Mon, 22 May 2006 08:16:16 +0000

I know that this is an old topic, but could you tell us what happened with you forums?
u got all the users registered for all forums but still thye have to login for each is that right?

Re: 4 forums in one database

dummy@example.com (erinther) — Thu, 15 Sep 2005 20:06:00 +0000

I tried the do what FLX said, but it was no help. I did not work...

Re: 4 forums in one database

dummy@example.com (erinther) — Thu, 15 Sep 2005 02:05:56 +0000

yes. I mean that mod. But if we had some mod for creating sub-category, then I was possible to include all my forums in only one.By the way, is there any sub-category mod for punbb?

Re: 4 forums in one database

dummy@example.com (Smartys) — Thu, 15 Sep 2005 01:55:03 +0000

You mean something like this?