URGENT - Ran a uninstall script and now my board is unacessable

[Wolffman]

When I used the uninstall script for this (https://vborg.vbsupport.ru/showthread.php?t=61108) hack ([HTL] & [TXT] Awards/Medals/Cards Hack [vB3]), I got this error:


Invalid SQL:
SELECT
userfield.*, usertextfield.*, useraward.*, 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 = 14

mysql error: Table 'afceyri_forums.useraward' doesn't exist

mysql error number: 1146

I don't know where this is comming from, and I'm very lost. Help is needed VERY badly, because this forced my forums to go down.

[Zachery]

Looks like you still have a query in there in global.php or init.php look for

useraward

Looks like you didnt remove all the file edits :)

[Wolffman]

I looked through init.php and global.php, and didnt find a thing. I also removed all the codes, that I know of, from the edited files. I still have a database error. :disappointed:

[assassingod]

Did you delete the database records of userawards?

[Xenon]

well, you surely have not removed everything, as the query above still uses a join for the useraward table.

actually iirc the code is located in functions.php fetch_userinfo function

[Wolffman]

I deleted a query in functions.php, and this happened:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/afceyri/public_html/forums/includes/functions.php on line 912

[Zachery]

I deleted a query in functions.php, and this happened:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/afceyri/public_html/forums/includes/functions.php on line 912Well, you shouldnt delete a whole query, that could generelay mess things up.

[Xenon]

actually reverting that query with it'S original one would have been needed, as it fetches the userinfo from the db, and was just modified for that hack, but not written for the hack itself.