mě by zajímalo co dělá ve scriptu na katapult želva
http://www.wowhead.com/?npc=31740
navíc bez úpravy to ani nefunguje: píše error že už to tam mám takže by to mělo vypadat nějak takhle: (tu želvu sem tam nechal...)
DELETE FROM `creature_template` WHERE `entry` = 27881; //SQLog bez vymazání píše Duplicate entry '27881' for key 1 proto ta uprava
INSERT INTO `creature_template` (`entry`, `heroic_entry`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `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`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES ('27881', '0', '0', '0', '23884', '0', '23884', '0', 'Wintergrasp Catapult', NULL, 'vehichleCursor', '80', '80', '30000', '30000', '0', '0', '9730', '35', '35', '0', '2.0', '1.0', '0', '531.0', '578.0', '0', '256', '1.0', '2000', '1500', '0', '0', '0', '0', '0', '0', '0', '0', '0.0', '0.0', '0', '9', '393256', '0', '0', '0', '0', '0', '0', '0', '0', '0', '50025', '50989', '0', '0', '0', '0', '0', '0', '0', '36', '4706', '4706', '', '0', '3', '6.55185', '1.0', '0', '0', '0', '0', '0', '164', '1', '0', '0', '0', '');
DELETE FROM `creature_template` WHERE `entry` = 31740;
INSERT INTO `creature_template` (`entry`, `heroic_entry`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `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`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES ('31740', '0', '0', '0', '27881', '27883', '27882', '0', 'Cosmetic Turtle', NULL, NULL, '1', '1', '42', '42', '0', '0', '17', '35', '35', '0', '1.0', '1.0', '0', '1.0', '2.0', '0', '0', '1.0', '2000', '2000', '1', '2181300736', '0', '0', '0', '0', '0', '0', '2.0', '2.0', '1', '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.0', '1.0', '0', '0', '0', '0', '0', '121', '1', '0', '0', '0', '');