hey guys,

in my database I've got a table called _tplsource with templates content in it. I guess it's been left from when I used xoops 2.2. is it ok to delete all of it's content or is it needed somewhere?

Do not delete. It is still being used by XOOPS.

Please explain the function of the 3 tables used for templates: tplset, tplsource, ??

I have a fresh installation of XOOPS, and the _tplsource table is populated with info from individual modules, so it cannot be something coming form XOOPS 2.2.

It seems like it stores template info from the modules. How it does exactly, that would have to be explained by the Core team as I am not a Core expert.

Yes. they are vitally important. DO NOT EMPTY or DROP them.

XOOPS uses this tables to read the templates of your modules.

I mean the templates files for each module are in the modules/YOUR_MODULE/templates and you can customize them in your themes/YOUR_THEME/modules/YOUR_MODULE by just copy and paste them

but XOOPS will store them in the database for better performance and caching.

Then if you change/alter your templates (customization) they will replace in the database too.
There is an option in system -> preferences general preferences that said "Check templates for modifications ?" it should be No in a running website.
But if you set it to YES it will store new templates in the database.


btw, i should state that if you mistakenly EMPTY those tables you still could force XOOPS to store them in the database again.
just need to update your modules one by one. but you can not see anything (you will be blind) and you should know the direct URL for them:
eg for system module:

modules/system/admin.php?fct=modulesadmin&op=update&module=system

Hope i could explain that but as Mamba said core team can tell you the best explanation.

TABLEPREFIX_tplsource table store templates content of system and modules - files from 'templates' folder. When you update a module, in this table changes take place.

TABLEPREFIX_tplfile store info about templates also but not it's contents.

So, please do not delete it.