Are you sure your database has not been changed? The name? The mysql username and password?

How did the hacker hack your site?

And what version vB are you using? the latest?

Nope, the hacker didn't get into the database so its name/login/password are the same.

They got one of my admins accounts and got into the admin CP on site wherein they deleted the default templateset.

Running 2.3.0 RC, but even tried upgrading to a fresh 2.3.2 and that didn't work.

If it was just deleting a templateset, all you need to do is upload another templateset or style by overriding the default templateset with an import.

Are you sure he or she didn't do anything else? Do you have a database backup? If so, just restore you database, which will fix this.

I've tried that, but I got an error because the system isn't recognizing what version of vB is installed, even though it's set as 2.3.0 in the database's settings table. No variables are being loaded from the database, and I don't know why.

Look at the front page of my site:

http://www.comixfan.com/xfan/index.php?s=

See how it's got "Powered by: vbHome (lite) v4.2 and vBulletin v" - no mversion number for vB.

That, and I've modified the default templates but none of the modifications are showing - the default footer template with the HTML check is still loading even though I removed that in my modified footer template.

Most recent backup is a week old, so I'd lose all threads/posts/users since then. And being a news site that is updated daily, that's a lot of content to lose.

I did do a backup after the hack to save the latest posts/threads etc, but is there a way to combine them to get the templates back from the old update and content from the most recent?

Import ONLY the template table into your current database from your backup. You can do this. That may solve your problem.

Before you do this, backup your current database just in case.

And may I suggest, backing up your database AT LEAST DAILY. :) That's the least you can do in case your database gets corrupted or someone comes along like this and drops all your tables.

How do I do that, Erwin? I've never actually done a database restore before, let alone restoring a single table from a backup.

Did you backup to an SQL file?

If so, you can import specific tables in SSH using the command line.

The way I do it is using phpmyadmin, and importing the whole backup database into a NEW database, the exporting the TEMPLATES table as an SQL file, then importing that into the OLD database.