DELETE FROM creature_spawns WHERE entry = 133338; DELETE FROM creature_proto WHERE entry = 133338; DELETE FROM creature_names WHERE entry = 133338;
INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) VALUES (''133338'',''Magtheridon Encounter Trigger'','''','''',''0'',''10'',''0'',''0'',''0'',''0'',169,0,0,0,''1'',''1'',''0'',0);
INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES (''133338'',''70'',''70'',''35'',''1000000'',''1000000'',''0'',''0'',''1758'',''1000'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',''1'',''1'',''0'',''0'',0,''0'',''0'',''2.5'',''8'',''14'',0);
INSERT INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`) VALUES (133338,544,''-16.6199'',''2.19251'',''-0.405228'',''2.98687'',0,''169'',35,33554432,0,0,0,0,0,0,0);
UPDATE gameobject_spawns SET Flags = 0 WHERE Entry = 181713 AND map = 544; |