1 ranks database, multiple forums |
Description: Shows you how to have 1 ranks database for you multiple forums! |
Author: kip2001 |
Date: Sun Feb 02, 2003 5:06 pm |
Type: Tutorial |
Keywords: ranks, databases, multiple |
Category: MODifications |
|
Please follow the following instructions if you want to have 1 ranks database for more than 1 forum (very useful if you have already followed this tutorial! (note: i'm following a similar pattern as used in the other tutorial)
1) You'll have to install all boards into seperate directories and preferrably in the same database, using different table prefixes (I will use master, slave1, slave2, ..., slaveN).
2) Designate one board as the MASTER install, this one will act as the user-database for all other forums. The rest will be called SLAVES from now.
3) For consistency, rename the MASTERS shared tables to not use the prefix (using a tool like phpMyAdmin f.i.):
Code: |
ALTER TABLE master_ranks RENAME ranks; |
4) Delete the unused tables of the SLAVE installs (for each slave repeat this step):
Code: |
DROP TABLE slave1_ranks; |
5) Change for all installs (MASTER and SLAVES) the entries in includes/constants.php to (remove the $table_prefix):
Code: |
define('RANKS_TABLE', 'ranks'); |
6) Thats all you have to do, just upload "includes/constants.php" to there correct place, and all your forums are sharing the same ranks database! |
|
|