+- For-rum 3server.cz (http://for-rum.3server.cz)
+-- Forum: TEAM ONLY (http://for-rum.3server.cz/forumdisplay.php?fid=4)
+--- Forum: SQL (http://for-rum.3server.cz/forumdisplay.php?fid=6)
+---- Forum: Solved (http://for-rum.3server.cz/forumdisplay.php?fid=10)
+---- Thread: The Purification of Quel'Delar - Dočasná oprava (/showthread.php?tid=62)
The Purification of Quel'Delar - Dočasná oprava - doktorblazen - 01-21-2019
Tento quest je v fázi "dočasné opravy". Tzn. funguje, ale je potřeba DODĚLAT.
Věci k nahození:
Google disk -> 3Server -> Oprava Bugy -> The Purification of Quel'Delar -> Nahodit všechny soubory.
The Purification of Quel'Delar #4866
příkazy:
DELETE FROM `creature_template` WHERE entry IN (37781,36991,37746,37763,38056,37764,37765,37523);
DELETE FROM `creature` WHERE id IN (37781,36991,37746,37763,38056,37764,37765,37523);
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (37527,37523);
UPDATE `creature_template` SET `gossip_menu_id` = '65532' WHERE entry=37523;
UPDATE `creature_queststarter` SET `id` = '37764' WHERE quest=24796;
UPDATE `creature_queststarter` SET `id` = '37764' WHERE quest=24801;
UPDATE `creature_questender` SET `id` = '37764' WHERE quest=24553;
UPDATE `creature_questender` SET `id` = '37764' WHERE quest=24564;
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('14568563','36991','580','15','2','0','0','1739.09','717.696','71.1903','4.4777','300','0','0','84','0','0','0','0','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('14568564','36991','580','15','2','0','0','1761.82','707.575','71.1904','3.84232','300','0','0','84','0','0','0','0','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('14568565','36991','580','15','2','0','0','1778.09','692.973','71.1904','3.73393','300','0','0','84','0','0','0','0','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('14568567','36991','580','15','2','0','0','1653.57','634.692','28.0849','0.171978','300','0','0','84','0','0','0','0','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('14568568','36991','580','15','2','0','0','1693.99','674.897','28.0503','4.67702','300','0','0','84','0','0','0','0','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('14568569','36991','580','15','2','0','0','1745.8','622.226','28.0503','3.07638','300','0','0','84','0','0','0','0','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('14568570','36991','580','15','2','0','0','1704.76','583.796','28.1657','1.71842','300','0','0','84','0','0','0','0','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('14568571','36991','580','15','2','0','0','1612.32','606.707','33.3215','0.314329','300','0','0','84','0','0','0','0','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('14568572','36991','580','15','2','0','0','1621.18','584.858','33.3215','0.42507','300','0','0','84','0','0','0','0','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('14568573','36991','580','15','2','0','0','1634.67','563.787','33.3215','0.774572','300','0','0','84','0','0','0','0','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('14568574','36991','580','15','2','0','0','1651.28','548.805','33.3215','0.998411','300','0','0','84','0','0','0','0','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('14568590','37523','530','1','2','0','1','12556.5','-6779.04','15.047','0.0244971','300','0','0','12600','3994','0','0','0','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('14568591','37523','530','1','2','0','1','12556.5','-6770.14','15.1006','0.0340602','300','0','0','12600','3994','0','0','0','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('14568592','37523','530','1','2','0','1','12567','-6770.48','15.0904','6.22714','300','0','0','12600','3994','0','0','0','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('14568593','37523','530','1','2','0','1','12583.7','-6770.96','15.0904','6.26484','300','0','0','12600','3994','0','0','0','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('14568594','37523','530','1','2','0','1','12583.2','-6779.54','15.0904','0.132447','300','0','0','12600','3994','0','0','0','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('14568595','37523','530','1','2','0','1','12566.5','-6779.41','15.0915','0.00285489','300','0','0','12600','3994','0','0','0','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('14568559','37746','580','3','2','0','0','1698.45','628.03','28.1989','3.47949','300','0','0','42','0','0','0','33554432','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('14568576','37763','580','3','2','0','127','1662.56','622.758','28.0502','4.86257','300','0','0','8200','1200','0','0','0','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('14568578','37764','580','3','2','0','0','1665.9','624.107','28.0504','5.00237','300','0','0','16400','1800','0','0','0','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('14568579','37765','580','3','2','0','0','1703.85','602.353','28.0503','2.64381','300','0','0','42','0','0','0','0','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('14568560','37781','580','3','2','0','0','1720.53','615.576','28.0503','5.59377','300','0','0','126','0','0','0','0','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('14568561','37781','580','3','2','0','0','1686.59','644.382','28.1838','2.15293','300','0','0','126','0','0','0','0','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('14568562','37781','580','3','2','0','0','1658.78','629.876','28.3649','5.07855','300','0','0','126','0','0','0','0','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('463139','37781','580','3','2','0','0','1667','661','28','5.237','120','0','0','1','0','0','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('14568575','37781','580','3','2','0','0','1680.19','620.726','28.1394','3.53524','300','0','0','126','0','0','0','0','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('14568580','37781','580','3','2','0','0','1666.81','631.886','28.0502','4.56725','300','0','0','126','0','0','0','0','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('14568581','37781','580','3','2','0','0','1659.63','625.187','28.2451','1.65029','300','0','0','126','0','0','0','0','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('14568582','37781','580','3','2','0','0','1671.96','631.276','28.0503','4.46279','300','0','0','126','0','0','0','0','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('14568583','37781','580','3','2','0','0','1671.33','624.754','28.0503','1.472','300','0','0','126','0','0','0','0','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('14568584','37781','580','3','2','0','0','1696.11','608.161','28.1093','4.55154','300','0','0','126','0','0','0','0','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('463138','37781','580','3','2','0','0','1731','594','28','2.49','120','0','0','1','0','0','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('463137','37781','580','3','2','0','0','1736','598','28','2.49','120','0','0','1','0','0','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('463140','37781','580','3','2','0','0','1671','664','28','5.237','120','0','0','1','0','0','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('14568577','38056','580','3','2','0','0','1671.49','606.427','28.0504','3.83603','300','0','0','41','60','0','0','0','0','0','0','0','neni','neni','nemizi');
insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values('36991','0','0','0','0','0','21460','0','0','0','Sunwell Guardian','','','0','80','80','0','35','0','1','1.14286','1','0','0','0','0','0','1','0','0','1','0','0','0','0','0','0','0','0','0','0','0','9','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','3.45002','1','1','0','0','0','0','0','0','0','144','1','0','0','','0');
insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values('37523','0','0','0','0','0','30628','30629','30630','30631','Warden of the Sunwell','','','65532','80','80','2','35','1','1','1.14286','1','0','0','0','0','0','1','0','0','2','0','2048','0','0','0','0','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','SmartAI','0','3','1','1','1','1','0','0','0','0','0','0','0','0','1','0','0','','12340');
insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values('37746','0','0','0','0','0','20570','17612','0','0','Sunwell Caster Bunny','','','0','1','1','0','0','0','1','1.14286','0.72','0','0','0','0','0','1','0','0','1','33554432','0','0','0','0','0','0','0','0','0','0','10','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','1','1','0','0','0','0','0','0','0','0','1','0','130','','0');
insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values('37763','0','0','0','0','0','19706','0','0','0','Grand Magister Rommath','','','0','80','80','0','35','0','1','1.14286','1','3','0','0','0','0','1','0','0','2','0','0','0','0','0','0','0','0','0','0','0','7','4','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','261.78','15.8145','1','0','0','0','0','0','0','0','0','1','0','0','','0');
insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values('37764','0','0','0','0','0','17122','0','0','0','Lor\'themar Theron','Regent Lord of Quel\'Thalas','','0','80','80','0','35','2','1','1.14286','1','3','0','0','0','0','1','0','0','2','0','0','0','0','0','0','0','0','0','0','0','7','76','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1305.56','64.4067','1','1','0','0','0','0','0','0','0','1','0','0','','0');
insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values('37765','0','0','0','0','0','18146','0','0','0','Captain Auric Sunchaser','High Elf Representative','','0','80','80','0','35','0','1','1.14286','1','0','0','0','0','0','1','0','0','1','0','0','0','0','0','0','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','3.45002','1','1','0','0','0','0','0','0','0','0','1','0','0','','0');
insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values('37781','0','0','0','0','0','15511','0','0','0','Sunwell Honor Guard','','Directions','0','80','80','0','35','0','1','1.14286','1','1','0','0','0','0','1','0','0','1','0','0','0','0','0','0','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','7.076','1','1','0','0','0','0','0','0','0','144','1','0','0','','0');
insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values('38056','0','0','0','0','0','21008','0','0','0','Chamberlain Galiros','','','0','80','80','0','35','1','1','1.14286','1','0','0','0','0','0','1','0','0','2','0','0','0','0','0','0','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','2.94806','2','1','0','0','0','0','0','0','0','0','1','0','0','npc_queldelar_sunwell_plateau','0');
insert into `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) values('65532','1','0','I\'m ready to enter the Sunwell.','0','1','1','0','0','0','0',NULL,'0');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('37523','0','1','0','62','0','100','0','65532','1','0','0','62','580','0','0','0','0','0','7','0','0','0','1762','687','71','2.54708','Gossip teleport to Sunwell ');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('37527','0','1','0','19','0','100','0','24553','0','0','0','44','2','0','0','0','0','0','7','0','0','0','0','0','0','0','change phase to 2 ALIANCE');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('37527','0','2','0','19','0','100','0','24564','0','0','0','44','2','0','0','0','0','0','7','0','0','0','0','0','0','0','change phase to 2 HORDE');
RE: The Purification of Quel'Delar - Dočasná oprava - mirra - 01-21-2019
Code:
55 queries executed, 55 success, 0 errors, 0 warnings
Query: DELETE FROM `creature_template` WHERE entry IN (37781,36991,37746,37763,38056,37764,37765,37523)
8 row(s) affected
Execution Time : 0.331 sec
Transfer Time : 0 sec
Total Time : 0.332 sec
--------------------------------------------------
Query: DELETE FROM `creature` WHERE id IN (37781,36991,37746,37763,38056,37764,37765,37523)
0 row(s) affected
Execution Time : 0.156 sec
Transfer Time : 0 sec
Total Time : 0.157 sec
--------------------------------------------------
Query: UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (37527,37523)
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: UPDATE `creature_template` SET `gossip_menu_id` = '65532' WHERE entry=37523
0 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: UPDATE `creature_queststarter` SET `id` = '37764' WHERE quest=24796
1 row(s) affected
Execution Time : 0.041 sec
Transfer Time : 0.001 sec
Total Time : 0.042 sec
--------------------------------------------------
Query: UPDATE `creature_queststarter` SET `id` = '37764' WHERE quest=24801
1 row(s) affected
Execution Time : 0.029 sec
Transfer Time : 0 sec
Total Time : 0.029 sec
--------------------------------------------------
Query: UPDATE `creature_questender` SET `id` = '37764' WHERE quest=24553
1 row(s) affected
Execution Time : 0.074 sec
Transfer Time : 0 sec
Total Time : 0.074 sec
--------------------------------------------------
Query: UPDATE `creature_questender` SET `id` = '37764' WHERE quest=24564
1 row(s) affected
Execution Time : 0.017 sec
Transfer Time : 0 sec
Total Time : 0.018 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.065 sec
Transfer Time : 0 sec
Total Time : 0.066 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.041 sec
Transfer Time : 0 sec
Total Time : 0.042 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.074 sec
Transfer Time : 0 sec
Total Time : 0.075 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.017 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.017 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.045 sec
Transfer Time : 0 sec
Total Time : 0.045 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.017 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `p...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `Kill...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `Kill...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `Kill...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `Kill...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `Kill...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `Kill...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `Kill...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `Kill...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_opti...
1 row(s) affected
Execution Time : 0.031 sec
Transfer Time : 0 sec
Total Time : 0.032 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.097 sec
Transfer Time : 0 sec
Total Time : 0.098 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 secRE: The Purification of Quel'Delar - Dočasná oprava - doktorblazen - 01-22-2019
Ještě je potřeba přidat teleporty, zapomněl jsem na ně.
insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('463134','195682','580','3','2','1734','596','28','2.33','0','0','0','0','0','0','0','0','','','neni','neni','nemizi');
insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('463136','195682','580','3','2','1669','663','28','5.28','0','0','0','0','0','0','0','0','','','neni','neni','nemizi');
RE: The Purification of Quel'Delar - Dočasná oprava - leo - 01-22-2019
(01-22-2019, 05:03 PM)doktorblazen Wrote: Ještě je potřeba přidat teleporty, zapomněl jsem na ně.
insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('463134','195682','580','3','2','1734','596','28','2.33','0','0','0','0','0','0','0','0','','','neni','neni','nemizi');
insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`, `zoneId`, `areaId`, `nazev_guildhausu`, `nazev_balicku`, `nazev_balicek_co_zmizi`) values('463136','195682','580','3','2','1669','663','28','5.28','0','0','0','0','0','0','0','0','','','neni','neni','nemizi');
NAHODENÉ, 2 rows affected
RE: The Purification of Quel'Delar - Dočasná oprava - doktorblazen - 01-22-2019
Až na konci jsme si s Leem všimli toho, že i ty questy jsou špatně udělané a nesedí na horde a ali chary + ani na classy. Zde je oprava.
(ALI QUEST UPDATE) update quest_template set RequiredRaces = 690, RequiredClasses = 1104 where id=24595;
(HORDE QUEST UPDATE) update quest_template set RequiredRaces = 1101, RequiredClasses = 399 where id=24553;
(HORDE SMART SCRIPTS UPDATE) update smart_scripts set event_param1 = 24595 where entryorguid=37527 and id=2;
RE: The Purification of Quel'Delar - Dočasná oprava - leo - 01-22-2019
(01-22-2019, 06:01 PM)doktorblazen Wrote: Až na konci jsme si s Leem všimli toho, že i ty questy jsou špatně udělané a nesedí na horde a ali chary + ani na classy. Zde je oprava.
(ALI QUEST UPDATE) update quest_template set RequiredRaces = 690, RequiredClasses = 1104 where id=24595;
(HORDE QUEST UPDATE) update quest_template set RequiredRaces = 1101, RequiredClasses = 399 where id=24553;
(HORDE SMART SCRIPTS UPDATE) update smart_scripts set event_param1 = 24595 where entryorguid=37527 and id=2;
Nahodené
