/* Creature Menu conditions*/ 
REPLACE INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId,ElseGroup, ConditionTypeOrReference
, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName) VALUES 
(15, 50010, 1, 0, 0, 6, 0, 469, 0, 0, 0, 0, '', 'Stormwind'),
(15, 50010, 2, 0, 0, 6, 0, 469, 0, 0, 0, 0, '', 'Darnassus'),
(15, 50010, 3, 0, 0, 6, 0, 469, 0, 0, 0, 0, '', 'Ironforge'),
(15, 50010, 4, 0, 0, 6, 0, 469, 0, 0, 0, 0, '', 'Exodar'),
(15, 50010, 5, 0, 0, 6, 0, 67, 0, 0, 0, 0, '', 'Orgrimmar'),
(15, 50010, 6, 0, 0, 6, 0, 67, 0, 0, 0, 0, '', 'Thunderbluff'),
(15, 50010, 7, 0, 0, 6, 0, 67, 0, 0, 0, 0, '', 'Undercity'),
(15, 50010, 8, 0, 0, 6, 0, 67, 0, 0, 0, 0, '', 'Silvermoon'),
(15, 50010, 9, 0, 0, 27, 0, 58, 3, 0, 0, 0, '', 'Shattrath'),
(15, 50010, 10, 0, 0, 27, 0, 68, 3, 0, 0, 0, '', 'Dalaran');
 
/* Gameobject Menu conditions*/
REPLACE INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId,ElseGroup, ConditionTypeOrReference
, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName) VALUES 
(15, 50011, 1, 0, 0, 6, 0, 469, 0, 0, 0, 0, '', 'Stormwind'),
(15, 50011, 2, 0, 0, 6, 0, 469, 0, 0, 0, 0, '', 'Darnassus'),
(15, 50011, 3, 0, 0, 6, 0, 469, 0, 0, 0, 0, '', 'Ironforge'),
(15, 50011, 4, 0, 0, 6, 0, 469, 0, 0, 0, 0, '', 'Exodar'),
(15, 50011, 5, 0, 0, 6, 0, 67, 0, 0, 0, 0, '', 'Orgrimmar1'),
(15, 50011, 6, 0, 0, 6, 0, 67, 0, 0, 0, 0, '', 'Thunderbluff'),
(15, 50011, 7, 0, 0, 6, 0, 67, 0, 0, 0, 0, '', 'Undercity'),
(15, 50011, 8, 0, 0, 6, 0, 67, 0, 0, 0, 0, '', 'Silvermoon'),
(15, 50011, 9, 0, 0, 27, 0, 58, 3, 0, 0, 0, '', 'Shattrath'),
(15, 50011, 10, 0, 0, 27, 0, 68, 3, 0, 0, 0, '', 'Dalaran');
 

/* Creature erstellen*/ 
REPLACE 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_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `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`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (180000, 0, 0, 0, 0, 0, 29133, 29133, 29133, 29133, 'World Teleporter', '', '', 50010, 80, 80, 2, 35, 35, 1, 1, 1, 0.5, 1, 0, 0, 0, 0, 0, 0, 0, 1, 518, 8, 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, 'SmartAI', 0, 3, 1.98413, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 1);
 
/* Gameobject erstellen*/
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (600000, 2, 8632, 'World Teleporter', '', '', '', 35, 32, 0.5, 0, 0, 0, 0, 0, 0, -1, -1, 4, 50011, 0, 0, -1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartGameObjectAI', '', 1);
 

/* Creature Menu*/
REPLACE INTO gossip_menu (entry, text_id) VALUES
('50010', '50010');
/* Gameobject Menu*/
REPLACE INTO gossip_menu (entry, text_id) VALUES
('50011', '50011');
 
/* Creature Text*/
REPLACE INTO npc_text (ID, text0_0, em0_1) VALUES
('50010', 'Wohin moechtest du $N? $B', 6);
/* Gameobject Text*/
REPLACE INTO npc_text (ID, text0_0, em0_1) VALUES
('50011', 'Wohin moechtest du $N? $B', 6);
 

/* Creature Gossip*/
REPLACE INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, box_coded, box_money) VALUES
('50010', 1, 2, 'Sturmwind', 1, 1, 50010, 0, 0, 0),
('50010', 2, 2, 'Darnassus', 1, 1, 50010, 0, 0, 0),
('50010', 3, 2, 'Eisenschmiede', 1, 1, 50010, 0, 0, 0),
('50010', 4, 2, 'Exodar', 1, 1, 50010, 0, 0, 0),
('50010', 5, 2, 'Orgrimmar', 1, 1, 50010, 0, 0, 0),
('50010', 6, 2, 'Donnerfels', 1, 1, 50010, 0, 0, 0),
('50010', 7, 2, 'Unterstadt', 1, 1, 50010, 0, 0, 0),
('50010', 8, 2, 'Silbermond', 1, 1, 50010, 0, 0, 0),
('50010', 9, 2, 'Shattrath', 1, 1, 50010, 0, 0, 0),
('50010', 10, 2, 'Dalaran', 1, 1, 50010, 0, 0, 0);
 
/* Gameobject Gossip*/
REPLACE INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, box_coded, box_money) VALUES
('50011', 1, 2, 'Sturmwind', 1, 1, 50011, 0, 0, 0),
('50011', 2, 2, 'Darnassus', 1, 1, 50011, 0, 0, 0),
('50011', 3, 2, 'Eisenschmiede', 1, 1, 50011, 0, 0, 0),
('50011', 4, 2, 'Exodar', 1, 1, 50011, 0, 0, 0),
('50011', 5, 2, 'Orgrimmar', 1, 1, 50011, 0, 0, 0),
('50011', 6, 2, 'Donnerfels', 1, 1, 50011, 0, 0, 0),
('50011', 7, 2, 'Unterstadt', 1, 1, 50011, 0, 0, 0),
('50011', 8, 2, 'Silbermond', 1, 1, 50011, 0, 0, 0),
('50011', 9, 2, 'Shattrath', 1, 1, 50011, 0, 0, 0),
('50011', 10, 2, 'Dalaran', 1, 1, 50011, 0, 0, 0);
 

/* Creature Smart Scripts*/
REPLACE 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 
('180000', 0, 1, 0, 62, 0, 100, 0, '50010', 1, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -8882.5, 577.619, 93, 0.724785, 'Sturmwind'),
('180000', 0, 2, 0, 62, 0, 100, 0, '50010', 2, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9949.56, 2284.21, 1342, 1.59587, 'Darnassus'),
('180000', 0, 3, 0, 62, 0, 100, 0, '50010', 3, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -4918.88, -940.406, 502, 5.42347, 'Eisenschmiede'),
('180000', 0, 4, 0, 62, 0, 100, 0, '50010', 4, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, -3965.7, -11653.6, -138, 0.852154, 'Exodar'),
('180000', 0, 5, 0, 62, 0, 100, 0, '50010', 5, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1629.36, -4373.39, 32, 3.54839, 'Orgrimmar'),
('180000', 0, 6, 0, 62, 0, 100, 0, '50010', 6, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1277.37, 124.804, 132, 5.22274, 'Donnerfels'),
('180000', 0, 7, 0, 62, 0, 100, 0, '50010', 7, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1584.07, 241.987, -51, 1.73354, 'Unterstadt'),
('180000', 0, 8, 0, 62, 0, 100, 0, '50010', 8, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9483.86, -7282.43, 15, 5.88804, 'Silbermond'),
('180000', 0, 9, 0, 62, 0, 100, 0, '50010', 9, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1838.16, 5301.79, -12, 5.9517, 'Shattrath'),
('180000', 0, 10, 0, 62, 0, 100, 0, '50010', 10, 0, 0,62, 571, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5804.15, 624.771, 649, 1.64, 'Dalaran');
 
/* Gameobject Smart Scripts*/
REPLACE 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 
('600000', 1, 1, 0, 62, 0, 100, 0, '50011', 1, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -8882.5, 577.619, 93, 0.724785, 'Sturmwind'),
('600000', 1, 2, 0, 62, 0, 100, 0, '50011', 2, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9949.56, 2284.21, 1342, 1.59587, 'Darnassus'),
('600000', 1, 3, 0, 62, 0, 100, 0, '50011', 3, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -4918.88, -940.406, 502, 5.42347, 'Eisenschmiede'),
('600000', 1, 4, 0, 62, 0, 100, 0, '50011', 4, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, -3965.7, -11653.6, -138, 0.852154, 'Exodar'),
('600000', 1, 5, 0, 62, 0, 100, 0, '50011', 5, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1629.36, -4373.39, 32, 3.54839, 'Orgrimmar'),
('600000', 1, 6, 0, 62, 0, 100, 0, '50011', 6, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1277.37, 124.804, 132, 5.22274, 'Donnerfels'),
('600000', 1, 7, 0, 62, 0, 100, 0, '50011', 7, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1584.07, 241.987, -51, 1.73354, 'Unterstadt'),
('600000', 1, 8, 0, 62, 0, 100, 0, '50011', 8, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9483.86, -7282.43, 15, 5.88804, 'Silbermond'),
('600000', 1, 9, 0, 62, 0, 100, 0, '50011', 9, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1838.16, 5301.79, -12, 5.9517, 'Shattrath'),
('600000', 1,10, 0, 62, 0, 100, 0, '50011', 10, 0, 0,62, 571, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5804.15, 624.771, 649, 1.64, 'Dalaran');