| For all search/replace operations be sure to match case.
|
|
|
| In db/tiki.sql replace:
|
| -"DROP TABLE IF EXISTS " with "DROP TABLE IF EXISTS ##PREFIX##"
|
| -"CREATE TABLE " with "CREATE TABLE ##PREFIX##"
|
| -"INSERT IGNORE INTO " with "INSERT IGNORE INTO ##PREFIX##"
|
| -"INSERT INTO " with "INSERT INTO ##PREFIX##"
|
| -"UPDATE " with "UPDATE ##PREFIX##"
|
| +"DROP TABLE IF EXISTS " with "DROP TABLE IF EXISTS ##PREFIX##" |
| +"CREATE TABLE " with "CREATE TABLE ##PREFIX##" |
| +"INSERT IGNORE INTO " with "INSERT IGNORE INTO ##PREFIX##" |
| +"INSERT INTO " with "INSERT INTO ##PREFIX##" |
| +"UPDATE " with "UPDATE ##PREFIX##" |
|
|
| Save as db/prefix_tiki.sql.
|
|
|
| -In db/prefix_tiki.sql replace "##PREFIX##" with your chosen prefix. In this example we'll use "photon_" as the prefix. Save this file under a new name like "photon_tiki.sql". Now use "photon_tiki.sql" to add and configure the tables in your shared DB.
|
| +In db/prefix_tiki.sql replace "##PREFIX##" with your chosen prefix. In this example we'll use "photon_" as the prefix. Save this file under a new name like "photon_tiki.sql". Now use "photon_tiki.sql" to add and configure the tables in your shared DB. |
|
|
| You now have a prefixed DB to run your tiki site. Next we need to change the php source to use the prefixed site. This will once again use a masive set of search and replace operations.
|
| Note that ` is the carret not the single quote '! This is usually on the same key as the tilde (~) on US keyboards. For all files matching *.php or *.inc in all subdirectories replace:
|
|
|
| || Replace this | With This
|
| -`tiki_|`".$GLOBALS[["db_prefix_tiki"]."tiki_
|
| -`users_|`".$GLOBALS[["db_prefix_tiki"]."users_
|
| -`messu_|`".$GLOBALS[["db_prefix_tiki"]."messu_
|
| -'sessions'|$GLOBALS[["db_prefix_tiki"].'sessions'
|
| -'galaxia_'|$GLOBALS[["db_prefix_tiki"].'galaxia_'||
|
| +`tiki_|`".$GLOBALS[["db_prefix_tiki"]."tiki_ |
| +`users_|`".$GLOBALS[["db_prefix_tiki"]."users_ |
| +`messu_|`".$GLOBALS[["db_prefix_tiki"]."messu_ |
| +'sessions'|$GLOBALS[["db_prefix_tiki"].'sessions' |
| +'galaxia_'|$GLOBALS[["db_prefix_tiki"].'galaxia_'|| |
|
|
| At the top of the file lib\galaxia\config.php change:
|
|
|