template questions

[hotnuts21]

Ive put together a mod for vbulletin but it requires I alter three areas of the template table.
navbar,
standard_error
standard_error_lite

now i patched the template, but I only patched the template field not the template_un too. When i made some cosmetic changes in the admincp my changes didnt show up, and the new changes did.

So my question is quite simple, if I want to patch the template fields mentioned above, what is the best way to do it, do I have to fill in all the fields, or can I just change an existing one? I need it so that if any alterations are made in the admincp they are made in our revised edition and do not create a new table entry.

Thanks and i hope I have made myself clear :)

[Andreas]

You should not edit the tempaltes in the database directly.
Use Styles Manager to do so (Admin CP / Styles & Templates)

[Zachery]

You should not edit the tempaltes in the database directly.
Use Styles Manager to do so (Admin CP / Styles & Templates)
Infact its really never best to edit any of vB's data directly in the database...

[Andreas]

Well, depends ;)

If, for example, I want to mass-close all polls there AFAIK isn't a straight-forward way to do so (without a query).

[Zachery]

Well, depends ;)

If, for example, I want to mass-close all polls there AFAIK isn't a straight-forward way to do so (without a query).
Well right, I am talking more about chaging certin bits of data though somthing like phpmyadmin, like editing options or forum permissions ect.

[hotnuts21]

Thanks for that guys, but as the changes requested above are only a small part of the changes, a lot of which require database changes, during the installation of the hack. Its an automated process which runs on a php script. So we have to alter the database, or at least alter it the same way you would if you edited it from admincp.

So what info do i need to input, currently we only change the template field, as our data is raw, but we have not changed the template_un table. Up untill now its worked fine, however one person who has changed the layout of his site using the admincp our changes have dissapeared. So I need to know the answers to the questions above.

If i have to patch the sql directly, and its just the template table, what info do i need to enter in and whats the difference between the info in template and template_un

thnx

[Andreas]

template is the compiled template, template_un is the original template code (used for editing, etc.)
There is no template_un table, only a column template_un in table template.

... and I still don't understand why you want to modify the DB directly.