ite was hacked - Database error in vBulletin 3.8.0

[ingdz.com]

My site was hacked & taken over,I have this problem

Database error in vBulletin 3.8.0:

Invalid SQL:

            SELECT title, template
            FROM template
            WHERE templateid IN (5166,6180,5260,6181,5262,5263,5264,5265,5266,5268,5269,5270,5271,5272,5267,5259,6186,6185,5661,5168,5167,5169,5164,5163,5440,6182,5392,5393,5394,5656,5659,5668,5413,5414,5415,5416,5610,5673,5672,5674,5677,5569,5571,5572,5786,5793,5795,6042,6044,6050,6051,6052,6053,6045,6046,6054,6055,6047,6043,6056,6048,6049,6057);

MySQL Error   : Table 'ifdzco_fdddz.template' doesn't exist
Error Number  : 1146
Request Date  : Sunday, February 15th 2009 @ 06:35:25 PM
Error Date    : Sunday, February 15th 2009 @ 06:35:25 PM
Script        : http://www.ingdz.com/vb/
Referrer      : 
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.67-community

[Steve Machol]

Are you using a table prefix? Have you checked the database?

[ingdz.com]

yes , and i have checked the database & no problems with it structure.
after that i create the table because i don't fond it

CREATE TABLE `template` (
`templateid` int(10) unsigned NOT NULL auto_increment,
`styleid` smallint(6) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` mediumtext,
`template_un` mediumtext,
`templatetype` enum('template','stylevar','css','replacement') NOT NULL default 'template',
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`version` varchar(30) NOT NULL default '',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`templateid`),
UNIQUE KEY `title` (`title`,`styleid`,`templatetype`)
) ENGINE=MyISAM AUTO_INCREMENT=2016 DEFAULT CHARSET=latin1;

[Steve Machol]

Yes to what? What does your database show?

[Lynne]

If you just ran that query and created a new template table, then you don't have any templates since you didn't also run a query to populate it. I'm thinking you may have to upload tools.php to create a new style to use. Do you have backups of any of your styles?

[ingdz.com]

I upgraded to 3.8.1 , & and the probleme disappeared

thanks a lot