Радиус атаки

Этой проблеме уже год, и все никто не соизволит поправить. Половина лучников до сих пор в упор стреляет. Пофиксил большинство:

id;name;attackrange1;attackrange2
784;"Tasaba Lizardman";40;500
826;"Platinum Tribe Archer";40;500
855;"Kel Mahum Archer";40;500
920;"Maille Lizardman Scout";40;500
1013;"Ol Mahum Van Archer";40;500
1019;"Fallen Orc Archer";40;500
1133;"Dead Pit Skeleton Archer";40;500
1354;"Varka Silenos Hunter";40;500
1605;"Zaken's Archer";40;500
1606;"Zaken's Archer";40;500
1607;"Zaken's Elite Archer";40;500
1639;"Tasaba Lizardman";40;500
1642;"Tasaba Lizardman Sniper";40;500
1643;"Tasaba Lizardman Sniper";40;500
1661;"Otherworldly Invader Archer";40;500
1684;"Dimension Invader Archer";40;500
1707;"Purgatory Invader Archer";40;500
1730;"Forbidden Path Invader Archer";40;500
1753;"Dark Omen Invader Archer";40;500
1776;"Messenger Invader Archer";40;500
10005;"Turek Mercenary Archer";40;500
10042;"Remmel's Archer";40;500
10107;"Lidia's Archer";40;500
10150;"Evil Spirit Archer";40;500
10171;"Hellion's Archers";40;500
10257;"Arak's Archer";40;500
10261;"Totem Guard Archer";0;500
10364;"Sharuk's Marksman";40;500
10389;"Red Eye Archer";40;500
10413;"Necrosentinel Archer";40;500
10446;"Shooter of Enmity";40;500
10477;"Kabed's Archer";40;500
12567;"Doom Archer";40;500


attackrange1 - то что было (и сейчас есть) в npc таблице фортреса.
attackrange2 - так как надо

Всех до одного проверял вручную, данные верные.

Для самых ленивых


UPDATE `npc` SET `attackrange`=500 WHERE `id`=784;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=826;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=855;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=920;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1013;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1019;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1133;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1354;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1605;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1606;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1607;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1639;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1642;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1643;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1661;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1684;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1707;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1730;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1753;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=1776;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10005;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10042;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10107;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10150;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10171;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10257;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10261;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10364;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10389;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10413;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10446;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=10477;
UPDATE `npc` SET `attackrange`=500 WHERE `id`=12567;