Template questions...
 

My templates are a little worse for wear following about a years worth of constant editing and potching. I intend to delete them all, and start from the global template once more. Firstly, how do I revert the global template to it's default state - eg no extra or modified templates. Secondly how do I change vBulletin so any new templates use the default template set rather than the global one? Thanks in advance! :D

OK scratch the second question, I just found this. If anyone could help with the first question though, I'd appreciate it! :)

You want to delete all customized templates from all styles?

[sql]DELETE FROM template WHERE templatesetid NOT IN (-1, -2);[/sql]
Back your styles up before doing this.

Basically, I want the global template to be exactly as it is in a new installation of vBulletin. Will that query do it for me?

Yes, but it will also remove all custom templates you have added.

Thanks for the help yet again FireFly! :)

It hasn't worked FireFly. My template system is completely screwed up - I don't have ANY templates, styles or replacement sets. Because I don't have a default template to edit, my site is just using the global template set. How do I get my default style set back, i.e. the one that can't be deleted?

Running that query shouldn't have deleted your style, but delete all customized templates.

Anyway, if you want to start fresh (including replacement sets), make sure vbulletin.style is in the /admin folder, and create a new style.

I'm not sure what's going on, it wasn't your query that messed it up, it was messed up before. I don't have ANY styles, templates or replacement sets.

Why do I have a feeling I've done something I'm going to regret? :( I've tried searching through the tables manually in phpMyAdmin, I didn't see anything that would help at all. :(