[Guide-Fix] How to get stats visible [Mangos]

**Quagmire** · 05-14-2009

Hey there all.

Maybe some of you mangos users have been updating your 2.4.3 servers to Wotlk 3.0.9 servers. When udb released their db they added a new field in the item_template table called StatsCount. If you got custom items on your server this field isn't filled on any custom item. So the stats you saw on your 2.4.3 server won't show now.

But it's an easy fix for that!

Just use this sql query like one time each day. Or after everytime you added an item.

I tested this on my server and it works wonderfull

Code:

UPDATE item_template SET StatsCount = 10 WHERE stat_type10 <> 0 AND StatsCount = 0;  
UPDATE item_template SET StatsCount = 9 WHERE stat_type9 <> 0 AND StatsCount = 0;  
UPDATE item_template SET StatsCount = 8 WHERE stat_type8 <> 0 AND StatsCount = 0;  
UPDATE item_template SET StatsCount = 7 WHERE stat_type7 <> 0 AND StatsCount = 0;  
UPDATE item_template SET StatsCount = 6 WHERE stat_type6 <> 0 AND StatsCount = 0;  
UPDATE item_template SET StatsCount = 5 WHERE stat_type5 <> 0 AND StatsCount = 0;  
UPDATE item_template SET StatsCount = 4 WHERE stat_type4 <> 0 AND StatsCount = 0;  
UPDATE item_template SET StatsCount = 3 WHERE stat_type3 <> 0 AND StatsCount = 0;  
UPDATE item_template SET StatsCount = 2 WHERE stat_type2 <> 0 AND StatsCount = 0;  
UPDATE item_template SET StatsCount = 1 WHERE stat_type1 <> 0 AND StatsCount = 0;

Good luck and enjoy your smexy statz lololololozlzozlzlozl