template questions
 

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 :)

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...

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.

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

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.