stoneharry

INSERT  INTO `creature_spawns`(`id`,`entry`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`movetype`,`displayid`,`faction`,`flags`,`bytes0`,`bytes1`,`bytes2`,`emote_state`,`npc_respawn_link`,`channel_spell`,`channel_target_sqlid`,`channel_target_sqlid_creature`,`standstate`,`death_state`,`mountdisplayid`,`slot1item`,`slot2item`,`slot3item`,`CanFly`,`phase`) VALUES (138,100000,0,-2354.9,-2462.11,561.814,2.40191,0,25885,21,524288,0,0,1,333,0,0,0,0,0,0,6374,36962,0,0,0,1);

INSERT  INTO `creature_names`(`entry`,`name`,`subname`,`info_str`,`flags1`,`type`,`family`,`rank`,`killcredit1`,`killcredit2`,`male_displayid`,`female_displayid`,`male_displayid2`,`female_displayid2`,`unknown_float1`,`unknown_float2`,`leader`,`questitem1`,`questitem2`,`questitem3`,`questitem4`,`questitem5`,`questitem6`,`waypointid`) VALUES (100004,'Black Drake','Blackhand\'s Pet','',108,0,0,3,0,0,6374,0,0,0,1,1,0,0,0,0,0,0,0,0),(100003,'Fire Orb','','',0,0,0,1,0,0,11686,0,0,0,1,1,0,0,0,0,0,0,0,0),(100002,'Charged Orb','','',0,0,0,1,0,0,11686,0,0,0,1,1,0,0,0,0,0,0,0,0),(100001,'','','',0,0,0,1,0,0,11686,0,0,0,1,1,0,0,0,0,0,0,0,0),(100000,'\"Futile\" Blackhand','','',2156,7,0,3,0,0,25885,0,0,0,1,1,1,0,0,0,0,0,0,0);

INSERT  INTO `creature_proto`(`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`mana`,`scale`,`npcflags`,`attacktime`,`attacktype`,`mindamage`,`maxdamage`,`can_ranged`,`rangedattacktime`,`rangedmindamage`,`rangedmaxdamage`,`respawntime`,`armor`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`combat_reach`,`bounding_radius`,`auras`,`boss`,`money`,`invisibility_type`,`walk_speed`,`run_speed`,`fly_speed`,`extra_a9_flags`,`spell1`,`spell2`,`spell3`,`spell4`,`spell_flags`,`modImmunities`,`isTrainingDummy`,`guardtype`,`summonguard`) VALUES (100002,83,83,21,55500,55500,3508353,1,0,10000,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,'0',0,0,0,2.5,8,14,0,0,0,0,0,0,0,0,0,0),(100001,83,83,21,55500,55500,3553563,1,0,10000,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,'0',0,0,0,2.5,8,14,0,0,0,0,0,0,0,0,0,0),(100000,83,83,15,8000000,9000000,98000000,2,0,2100,0,18000,25000,0,0,0,0,0,12000,25,25,25,25,25,25,1.3,4,'0',1,0,0,2.5,7.6,14,0,0,0,0,0,0,0,0,0,0),(100003,83,83,21,100000,100000,500000,1,0,10000,0,1,1,0,0,0,0,0,20000,30,30,30,30,30,30,1,1,'0',0,0,0,2.5,8,14,0,0,0,0,0,0,0,0,0,0),(100004,83,83,21,2000000,3000000,0,1,0,2400,0,12000,14000,0,0,0,0,0,11000,20,20,20,20,20,20,1.3,4,'0',1,0,0,2.5,8,14,0,0,0,0,0,0,0,0,0,0);

INSERT INTO `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `Category`, `CastBarText`, `UnkStr`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`, `Size`, `QuestItem1`, `QuestItem2`, `QuestItem3`, `QuestItem4`, `QuestItem5`, `QuestItem6`) VALUES('1930701','33','8387','Boss Platform (DESTRUCTABLE)','','','','100','0','0','0','8387','0','0','0','0','0','8386','1','0','0','0','0','0','0','50','0','0','0','0','1','1','0','0','0','0','0','0');