I'm trying to run multiple installs off of one database. Mainly for user pooling, but also because I want some modules to be shared between them.

So far as I can tell, the easiest way to do this is to, rather than change the xoops prefix(which prevents me from sharing modules) change the table names for configuration.

Site name and layout should be different, and some modules will be installed twice(already did the module work to rename for the ones that need to be redone)

I can't find where the variables for what tables to query are defined, though.

The short of it is that I just want to change the below tables as such

config -> config_1
configcategory -> configcategory_1
configoption -> configoption_1

and then have site 1 check configuration from _1 and site 2 check config from _2.

I've spent the past several hours digging through the code and I can't seem to reliably track down which file is declaring the table names.

Thanks in advance for any help. I'm running version 2.4.3 on both sites.

ok I seem to have managed what I was trying to do. The important tables to change over, for control of layout also, are below. After each table is the name of all files that I was able to find which call it specifically rather than by variable.

configcategory
kernel/configcategory.php
configoption
kernel/configoption.php
config
kernel/configitem.php

block_module_link
class/xoopsblock.php
kernel/module.php
kernel/block.php
module/system/admin/blocksadmin/blocksadmin.php

newblocks
class/xoopsblock.php
kernel/block.php

modules
kernel/module.php

tplset
kernel/tplset.php

tplfile
kernel/tplfile.php

tplsource
kernel/tplfile.php