Ok, if some newbies are interested, here goes the little script I wrote that will do the job.
Follow the steps below:
1) Obtain the
id of the
Template you want to work with. Execute:
select * from modx_site_templates where templatename='TheTemplateNameInTheModxManager';
2) Create a backup of the
modx_site_tmplvar_templates table (so you can revert if anything goes wrong):
create table modx_site_tmplvar_templates_bk as
select * from modx_site_tmplvar_templates;
3) Finally, insert the new values on table
modx_site_tmplvar_templates. Suppose the
id you obtained in step 1) is
9. The following command will give
template 9 access to
ALL existing Template Variables (You should modify it if you want to restrict it to only some TVs).
insert into modx_site_tmplvar_templates
select id, 9, 0 from modx_site_tmplvars;
4) Check all TVs in Content Manager and verify that they all have access to the
Template 9.
Hope it helps.
Mc
