0017_dualspec.sql

-- ================================
-- Dual Spec Switcher NPCs and Item
-- ================================

REPLACE INTO `item_template` VALUES (21967, 0, 0, -1, 'Magic Talent Switch Gemstone', 12310, 4, 524288+1, 1, 0, 0, 0, -1, -1, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18282, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, 'Forced logout after talent switch.', 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'item_custom_dualspec', 0, 0, 0, 0, 0, 0);
-- all custom items are flagged as such, costs 10,000g (GM only currently, not fully working)
UPDATE item_template SET ExtraFlags=ExtraFlags|2, BuyPrice=100000000 WHERE entry=21967;

-- Dual Specialization Crystal 100601
UPDATE `creature_template` SET GossipMenuId=50700, Scale=0.25 WHERE `Entry`=100601; 

DELETE FROM npc_text WHERE id IN (50700,507001);
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) VALUES
('50700','<The crystal hums with energy.>','','0','1','0','1','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50701','<The gem hums with energy.>','','0','1','0','1','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0');

DELETE FROM gossip_menu WHERE entry IN (50700);
INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES
('50700','50700','0','0');

REPLACE INTO `game_event` (`entry`, schedule_type, `occurence`, `length`, `holiday`, `description`) VALUES
('300',1,'201600','201600','0','Light''s Vengeance Dual Specialization');
DELETE FROM game_event_time WHERE entry=300;
INSERT INTO game_event_time VALUES
(300,'2019-12-31 00:00:00','2021-12-31 00:00:00');

DELETE FROM creature WHERE guid BETWEEN 180507 AND 180515;
INSERT INTO creature (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType) VALUES
(180507, 100601, 1, 1, 0, 0, -1385.57, -106.832, 158.935, 3.38884, 25, 25, 0, 0, 0, 0, 0, 0),
(180508, 100601, 530, 1, 0, 0, -3723.79, -11702.9, -105.649, 2.86278, 25, 25, 0, 0, 0, 0, 0, 0),
(180509, 100601, 0, 1, 0, 0, 1324.66, 297.563, -63.6997, 2.40582, 25, 25, 0, 0, 0, 0, 0, 0),
(180510, 100601, 1, 1, 0, 0, 1990.97, -4810.55, 56.7646, 1.94642, 25, 25, 0, 0, 0, 0, 0, 0),
(180511, 100601, 1, 1, 0, 0, 9975.38, 2316.57, 1330.79, 0.00543642, 25, 25, 0, 0, 0, 0, 0, 0),
(180512, 100601, 0, 1, 0, 0, -5046.49, -1276.33, 510.325, 1.31583, 25, 25, 0, 0, 0, 0, 0, 0),
(180513, 100601, 0, 1, 0, 0, -8381.34, 281.29, 120.887, 2.98957, 25, 25, 0, 0, 0, 0, 0, 0),
(180514, 100601, 530, 1, 0, 0, 9854.07, -7569.61, 19.2509, 2.41089, 25, 25, 0, 0, 0, 0, 0, 0),
(180515, 100601, 530, 1, 0, 0, -1973.52, 5168.77, -38.4893, 0.446048, 25, 25, 0, 0, 0, 0, 0, 0);

DELETE FROM game_event_creature WHERE event IN (300,-300);
INSERT INTO game_event_creature (event, guid)
SELECT 300, guid FROM creature WHERE id=100601;