URGENT! Major template problems - not loading modified ones, some disappearing!

[X-Fan]

I need some urgent help here, please. I just went to check my Web site for the first time this morning...

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

...and I'm getting this error:

Database error in vbHome :

Invalid SQL:
SELECT COUNT(*) AS total
FROM thread
WHERE forumid IN( ) AND dateline>1065927913

mysql error: You have an error in your SQL syntax near ') AND dateline>1065927913
' at line 4

mysql error number: 1064

Date: Saturday 11th of October 2003 10:05:15 PM
Script: /xfan/index.php?s=
Referer:

The site was working fine around 8 hours ago, and no code has been edited/added/deleted since then but now all of a sudden it's stopped because of this error.

What could the problem be?

[X-Fan]

Addendum: I've just discovered my site has been hacked, as the board was turned off in the admin and there was a rather rude message posted as the close reason.

The database appears to be intact, it's just that mysql error with every instance of dateline that's causing problems from what I can see.

Any help would be appreciated, thanks!

[X-Fan]

Update 2: My templates aren't listing in my site admin. They're still in the database, but when I go to modify them nothing shows up in the list.

How do I fix that?

[X-Fan]

Okay, I managed to get the default templateset back, however now I get a bare bones forum front page with a blank message box in the middle of the screen:

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

I've tried editing the forumhome template, but for some reason the system is using only the default template and none of my modified ones.

In fact, the system isn't reading any of the stored variables, such as $hometitle, $bburl, etc. Not even $versionnumber is being read so currently my vB is null version!

I've also tried upgrading to 2.3.2, but even that causes a problem as no version number shows up for vBulletin. I re-uploaded vbulletin.style to the FTP and went to import it, but got this error:

The version of the style file does not match your version of vBulletin. Please obtain an updated version of vBulletin and/or the style file.

Your template version:

Style file template version: 2.3.2

I've checked my database, and all posts, threads, forums, users etc are still there. I've checked all the settings in the admin and the board is open, forums are visible, usergroups are established and permissions as they were before the hack attack, but just nothing is showing up on the index page.

Please, can someone help, as my site is my livelihood and every minute it's down is lost revenue for me!

[Lesane]

I have no idea at this moment, but check your database if the table 'setting' contains all the settings(it will probably) and run the repair.php and upload the original global.php/functions.php/index.php again.

[X-Fan]

Did all that, Lesane, and still no go. vBHome isn't working properly either since the hacker attack:

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

For some reason it's only reading the default templates. Any template modifications I make aren't being displayed.

[X-Fan]

I think the root problem is that the PHP code isn't getting the variable info from the database. I think that's why it's using the master templateset to display the pages because it's not getting passed the id of the default templateset. It's also why there's no version number being displayed, or any other variables like $hometitle and the like.

What could be causing that problem, though, when the DB settings in config.php are correct?

[X-Fan]

Someone, anyone, please, I desperately need help here!

[Erwin]

Reupload all the PHP files and see if that helps.

[X-Fan]

I have done, Erwin, twice, to no avail.

Thanks for helping, btw. I've been freaking out here as my site is my livelihood!