Big DB Problem Error 1146

[Davez]

Hello all.

I got a big problem. I uninstalled a Hack , and after it i got this problem , i can?t enter in my board, and i can?t enter in the admincp.
Everywhere i got a Database problem.

PHP Code:

Database error in vBulletin 3.0.1: 

Invalid SQL: 
        SELECT 
        userfield.*, useraward.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, 
        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, 
            language.phrasegroup_holiday AS phrasegroup_holiday, 
            language.phrasegroup_global AS phrasegroup_global, 
            language.options AS lang_options, 
            language.languagecode AS lang_code, 
            language.charset AS lang_charset, 
            language.locale AS lang_locale, 
            language.imagesoverride AS lang_imagesoverride, 
            language.dateoverride AS lang_dateoverride, 
            language.timeoverride AS lang_timeoverride, 
            language.registereddateoverride AS lang_registereddateoverride, 
            language.calformat1override AS lang_calformat1override, 
            language.calformat2override AS lang_calformat2override, 
            language.logdateoverride AS lang_logdateoverride, 
            language.decimalsep AS lang_decimalsep, 
            language.thousandsep AS lang_thousandsep 
        FROM user AS user 
        INNER JOIN userfield AS userfield ON (user.userid = userfield.userid) 
        INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
        LEFT JOIN useraward AS useraward ON (useraward.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
        WHERE user.userid = 1 
     
mysql error: Table 'dffcars_vBulletin.useraward' doesn't exist 

mysql error number: 1146 


Please can someone help me ? I have no idea what i can do.

Many thanks for help.

[rake]

You didn't uninstall the hack properly, and now vbulletin is trying to query a table in the database that doesn't exist. Retrace your steps and do the uninstall again. Basically, you need to remove anything that has to do with the useraward table from the above query, but there might be other references in other files.

[Davez]

Sorry, but i can´t follow you.
Where i have to remove this ? I checked my phpmyadmin, and seems that all looks for the table useraward .. and the table don´t exist anymore .. now i wanted to know where i have to change the useraward request.

I am not good with sql , and it would be fine, if someone can help me to fix this error, because i want my board back ;(

Many thanks

[Reeve of shinra]

You undid the database part of the hack, but you need to delete the edits you made to the php files and templates.

[Davez]

Many thanks !
I changed the files , now works .. i hope all works fine without any errors
/;