<![CDATA[PunBB Forums - 4 forums in one database]]> 2009-03-24T08:00:31Z PunBB http://punbb.informer.com/forums/topic/8755/4-forums-in-one-database/ <![CDATA[Re: 4 forums in one database]]> I did nothing, i don't work them

]]> http://punbb.informer.com/forums/user/15148/ 2009-03-24T08:00:31Z http://punbb.informer.com/forums/post/126042/#p126042 <![CDATA[Re: 4 forums in one database]]> this works in the new version? (1.3)

]]> http://punbb.informer.com/forums/user/13378/ 2008-07-29T16:21:35Z http://punbb.informer.com/forums/post/117007/#p117007 <![CDATA[Re: 4 forums in one database]]> 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);

]]> http://punbb.informer.com/forums/user/12044/ 2008-06-25T03:48:31Z http://punbb.informer.com/forums/post/116066/#p116066 <![CDATA[Re: 4 forums in one database]]> flx wrote:

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

it's working ?

]]> http://punbb.informer.com/forums/user/10548/ 2007-06-07T05:05:53Z http://punbb.informer.com/forums/post/95852/#p95852 <![CDATA[Re: 4 forums in one database]]> Now that this has been dragged back up, big_smile just to double check, those str_replace lines would need to go after:

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

in the db script?


Cheers,

Matt

]]> http://punbb.informer.com/forums/user/9938/ 2007-06-03T19:31:40Z http://punbb.informer.com/forums/post/95620/#p95620 <![CDATA[Re: 4 forums in one database]]> Thank you.  I had not looked up the comand.  I understand.
Cheers,

]]> http://punbb.informer.com/forums/user/8442/ 2007-02-09T00:12:06Z http://punbb.informer.com/forums/post/86842/#p86842 <![CDATA[Re: 4 forums in one database]]> 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);
]]> http://punbb.informer.com/forums/user/3935/ 2007-02-08T22:03:24Z http://punbb.informer.com/forums/post/86837/#p86837 <![CDATA[Re: 4 forums in one database]]> 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,

]]> http://punbb.informer.com/forums/user/8442/ 2007-02-08T21:46:02Z http://punbb.informer.com/forums/post/86835/#p86835 <![CDATA[Re: 4 forums in one database]]> 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

]]> http://punbb.informer.com/forums/user/8931/ 2006-11-15T05:06:27Z http://punbb.informer.com/forums/post/81450/#p81450 <![CDATA[Re: 4 forums in one database]]> I did nothing. I had to change all my plans and work with only one forum.

]]> http://punbb.informer.com/forums/user/4977/ 2006-06-08T20:09:54Z http://punbb.informer.com/forums/post/70457/#p70457 <![CDATA[Re: 4 forums in one database]]> did u set the each config.php cookie to the same thing?
<?php

$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);

]]> http://punbb.informer.com/forums/user/6504/ 2006-06-05T20:33:41Z http://punbb.informer.com/forums/post/70201/#p70201 <![CDATA[Re: 4 forums in one database]]> 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?

]]> http://punbb.informer.com/forums/user/6194/ 2006-05-22T08:16:16Z http://punbb.informer.com/forums/post/68860/#p68860 <![CDATA[Re: 4 forums in one database]]> I tried the do what FLX said, but it was no help. I did not work...

]]> http://punbb.informer.com/forums/user/4977/ 2005-09-15T20:06:00Z http://punbb.informer.com/forums/post/51995/#p51995 <![CDATA[Re: 4 forums in one database]]> 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?

]]> http://punbb.informer.com/forums/user/4977/ 2005-09-15T02:05:56Z http://punbb.informer.com/forums/post/51952/#p51952 <![CDATA[Re: 4 forums in one database]]> You mean something like this?

]]> http://punbb.informer.com/forums/user/1209/ 2005-09-15T01:55:03Z http://punbb.informer.com/forums/post/51951/#p51951