[Forum] Really big problem

[lucky89]

Ok i screwed up all the post icons in my forum.

I just wanted to delete the icons of the posts in the board, and i run some querys

UPDATE `prefix_forum` SET `lasticonid` = 0;
UPDATE `prefix_pmtext` SET `iconid` = 0; 
UPDATE `prefix_post` SET `iconid` = 0;
UPDATE `prefix_thread` SET `iconid` = 0; 

Then i run other querys to change the post icon ids:

UPDATE `prefix_icon` SET `iconid` = 14 WHERE `iconid` = 28
UPDATE `prefix_icon` SET `iconid` = 13 WHERE `iconid` = 27
UPDATE `prefix_icon` SET `iconid` = 12 WHERE `iconid` = 26
UPDATE `prefix_icon` SET `iconid` = 11 WHERE `iconid` = 25
UPDATE `prefix_icon` SET `iconid` = 10 WHERE `iconid` = 24
UPDATE `prefix_icon` SET `iconid` = 9 WHERE `iconid` = 23
UPDATE `prefix_icon` SET `iconid` = 8 WHERE `iconid` = 22
UPDATE `prefix_icon` SET `iconid` = 7 WHERE `iconid` = 21
UPDATE `prefix_icon` SET `iconid` = 6 WHERE `iconid` = 20
UPDATE `prefix_icon` SET `iconid` = 5 WHERE `iconid` = 19
UPDATE `prefix_icon` SET `iconid` = 4 WHERE `iconid` = 18
UPDATE `prefix_icon` SET `iconid` = 3 WHERE `iconid` = 17
UPDATE `prefix_icon` SET `iconid` = 2 WHERE `iconid` = 16
UPDATE `prefix_icon` SET `iconid` = 1 WHERE `iconid` = 15 

But it was a disaster... now the icons doesn't appear... and i don't know what to do...

PLEASSEEE I NEED HELP!!

[Winstone]

not sure if this will fix but have a look at maintenance menu under admincp, do recount recache etc..

and to restore it to default, make a fresh install on another location(another db), using phpMyAdmin or some other tool have a look at prefix_icon and prefix_forum etc.. tables, export them(only the tables you have changed) as an sql query
run it on your screwed up forum

Edit: and if you don't know much about queries and all, you better ask for a professional to fix it for you, it seem to be an easy/quick task anyway

[lucky89]

It's doesn't work please i need help!!

[lucky89]

Ok i fix it... i just reupload all the post icons... now other question how i can disable the post icons?

[Trevor Hannant]

This is done per forum here:

AdminCP > Forums & Moderators > [Edit Forum] > Enable / Disable Features > Allow Post Icons