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

/me cries for help in desperation.

Phew, disaster averted! :D I dropped the style, template, templateid, replacement and replacementid tables from my database, then did a dump of the same tables from a fresh install on vB. I then applied this dump to my database, and it seems to have fixed all my problems.

[high]* GamerForums wipes the sweat from his brow.[/high]

Nice avatar ;)

Thanks LOL. Can't remember where I got it from. Anyway, I can't view showthread.php now, I get database errors. It seems for some reason rather than stating the path as root/forums it's stating it as root/forums/forums... Here's the error. Anyone able to help please? :(

...and under that...

Nevermind, looks like it was a hack causing the trouble. A LOT of problems to sort out here. :(

It's the "Users browsing this thread" hack, for some reason you dropped the inthread field from the user table.

Ah I see, thanks FireFly. :D Should have everything back up by the end of tonight, hopefully with at least 50 hacks and a new design. :)