01-02-2019, 01:23 AM
Quest Item ID - 38659 Stefan's Steel Toed Boot nefungoval. spell nahrazen za funkční.
NPC ID - 28523 Nass Target KC Bunny byly jen dva z potřebných 10 na Quest ,přidal jsem další v místě daného výskytu.
Opraveno společně z Leem.
Dík Leo za další zkušenost.
UPDATE `91_world`.`item_template` SET `spellid_1` = '51870' WHERE `entry` = '38659';
UPDATE `91_world`.`smart_scripts` SET `action_type` = '33' , `action_param1` = '28523' WHERE `entryorguid` = '28523' AND `source_type` = '0' AND `id` = '0' AND `link` = '1';
UPDATE `91_world`.`smart_scripts` SET `event_param1` = '51870' WHERE `entryorguid` = '28523' AND `source_type` = '0' AND `id` = '0' AND `link` = '1';
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395197','28523','571','1','1','21342','0','5324.95','-1388.97','241.255','3.69124','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395408','28523','571','1','1','21342','0','5344.29','-1400.73','238.216','1.75756','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395409','28523','571','1','1','21342','0','5361.34','-1406.67','236.955','1.22977','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395410','28523','571','1','1','21342','0','5357.12','-1369.96','236.955','4.19465','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395411','28523','571','1','1','21342','0','5368.36','-1349.2','236.955','0.9431','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395412','28523','571','1','1','21342','0','5356.5','-1431.96','237.048','1.58712','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395413','28523','571','1','1','21342','0','5378.26','-1433.64','237.033','3.42652','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395414','28523','571','1','1','21342','0','5370.78','-1456.03','238.175','4.10982','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395415','28523','571','1','1','21342','0','5350.94','-1459.07','240.207','1.32166','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395416','28523','571','1','1','21342','0','5365.22','-1479.84','240.07','1.96175','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395417','28523','571','1','1','21342','0','5391.45','-1473.33','239.382','0.757739','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395418','28523','571','1','1','21342','0','5390.54','-1503.73','239.544','2.12041','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395419','28523','571','1','1','21342','0','5372.63','-1516.85','241.231','4.63368','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395420','28523','571','1','1','21342','0','5325.59','-1502.56','235.355','2.86261','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395421','28523','571','1','1','21342','0','5325.36','-1463.21','239.886','1.19756','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395422','28523','571','1','1','21342','0','5322.1','-1441.26','237.76','1.92405','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395423','28523','571','1','1','21342','0','5313.47','-1418.43','241.901','2.15967','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395424','28523','571','1','1','21342','0','5337.78','-1351.65','237.516','1.03655','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
NPC ID - 28523 Nass Target KC Bunny byly jen dva z potřebných 10 na Quest ,přidal jsem další v místě daného výskytu.
Opraveno společně z Leem.
Dík Leo za další zkušenost.
UPDATE `91_world`.`item_template` SET `spellid_1` = '51870' WHERE `entry` = '38659';
UPDATE `91_world`.`smart_scripts` SET `action_type` = '33' , `action_param1` = '28523' WHERE `entryorguid` = '28523' AND `source_type` = '0' AND `id` = '0' AND `link` = '1';
UPDATE `91_world`.`smart_scripts` SET `event_param1` = '51870' WHERE `entryorguid` = '28523' AND `source_type` = '0' AND `id` = '0' AND `link` = '1';
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395197','28523','571','1','1','21342','0','5324.95','-1388.97','241.255','3.69124','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395408','28523','571','1','1','21342','0','5344.29','-1400.73','238.216','1.75756','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395409','28523','571','1','1','21342','0','5361.34','-1406.67','236.955','1.22977','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395410','28523','571','1','1','21342','0','5357.12','-1369.96','236.955','4.19465','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395411','28523','571','1','1','21342','0','5368.36','-1349.2','236.955','0.9431','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395412','28523','571','1','1','21342','0','5356.5','-1431.96','237.048','1.58712','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395413','28523','571','1','1','21342','0','5378.26','-1433.64','237.033','3.42652','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395414','28523','571','1','1','21342','0','5370.78','-1456.03','238.175','4.10982','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395415','28523','571','1','1','21342','0','5350.94','-1459.07','240.207','1.32166','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395416','28523','571','1','1','21342','0','5365.22','-1479.84','240.07','1.96175','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395417','28523','571','1','1','21342','0','5391.45','-1473.33','239.382','0.757739','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395418','28523','571','1','1','21342','0','5390.54','-1503.73','239.544','2.12041','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395419','28523','571','1','1','21342','0','5372.63','-1516.85','241.231','4.63368','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395420','28523','571','1','1','21342','0','5325.59','-1502.56','235.355','2.86261','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395421','28523','571','1','1','21342','0','5325.36','-1463.21','239.886','1.19756','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395422','28523','571','1','1','21342','0','5322.1','-1441.26','237.76','1.92405','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395423','28523','571','1','1','21342','0','5313.47','-1418.43','241.901','2.15967','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('2395424','28523','571','1','1','21342','0','5337.78','-1351.65','237.516','1.03655','300','5','0','4979','0','1','0','0','0','0','','','neni','neni','nemizi');