[FIX] 2.4 Buged creatures

[Algorithm]

Hello everyone!

Well after 2.4 was installed i am sure most of you seen creatures that fly around and buged , moving with wierd speed moving inside ground. which can actualy cause lag sometimes and even crashes.

i recently discovered this query that fixed most of the creature problems. Once you run this query it shall select all bugzor creatures in your database for your view. from there on you can delete what in your perception needs to be deleted.

-- Detect creature(s) with zero scale.
SELECT * FROM `creature_proto` WHERE `scale` = '0';

-- Detect creature(s) with zero faction.
SELECT * FROM `creature_proto` WHERE `faction` = '0';

-- Detect creature(s) with zero level.
SELECT * FROM `creature_proto` WHERE `minlevel` = '0' OR `maxlevel` = '0';

-- Detect creature(s) with zero health.
SELECT * FROM `creature_proto` WHERE `minhealth` = '0' OR `maxhealth` = '0';

-- Detect creature(s) with zero combat reach.
SELECT * FROM `creature_proto` WHERE `combat_reach` = '0';

-- Detect creature(s) with zero move speed.
SELECT * FROM `creature_proto` WHERE `walk_speed` = '0' OR `run_speed` = '0' OR `fly_speed` = '0';

-- Detect creature(s) with zero damage.
SELECT * FROM `creature_proto` WHERE (`mindamage` = '0' OR `maxdamage` = '0') AND `faction` NOT IN ('35','31','188','1872');

i am here only to provide usefull information, you can rep or not. as long as this helps someone i am happy with that.

thank you