vmangos / core Goto Github PK

How to add a custom script?
I want to add a custom NPC and use the menu options to achieve the functionality I want. . .

Current behavior:

Expected behavior:

Steps to reproduce:

1. Thank you very much for your help. Why is the game server always crashing between 12 hours and 22 hours?
2. I have been looking for logs, but I don't know which one is causing the program crash log.I hope I can get your help.

Client version:

Commit hash:

Operating system:

• Add Combat Abilities for Death Knight Darkreaver
• Add Spawn Text for Death Knight Darkreaver
• Core Script moved to Database EventAI (Core Script can be deleted)

Since the boss is combat grade and has no mana, the spell control and shadow bolt are set with flag triggered. I don't know if that's right?

-- Death Knight Darkreaver
UPDATE `creature_template` SET `spells_template` = 145160, `AIName` = "EventAI", `ScriptName` = "" WHERE entry = 14516;
DELETE FROM `creature_ai_events` WHERE `creature_id` = 14516;
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(1451601, 14516, 0, 6, 0, 100, 0, 0, 0, 0, 0, 1451601, 0, 0, 'Death Knight Darkreaver - Start Script On Death'),
(1451602, 14516, 0, 11, 0, 100, 0, 0, 0, 0, 0, 1451602, 0, 0, 'Death Knight Darkreaver - Start Script On Just Spawn');

DELETE FROM `creature_spells` WHERE `entry` = 145160;
INSERT INTO `creature_spells` (`entry`, `name`, `spellId_1`, `probability_1`, `castTarget_1`, `targetParam1_1`, `targetParam2_1`, `castFlags_1`, `delayInitialMin_1`, `delayInitialMax_1`, `delayRepeatMin_1`, `delayRepeatMax_1`, `scriptId_1`, `spellId_2`, `probability_2`, `castTarget_2`, `targetParam1_2`, `targetParam2_2`, `castFlags_2`, `delayInitialMin_2`, `delayInitialMax_2`, `delayRepeatMin_2`, `delayRepeatMax_2`, `scriptId_2`, `spellId_3`, `probability_3`, `castTarget_3`, `targetParam1_3`, `targetParam2_3`, `castFlags_3`, `delayInitialMin_3`, `delayInitialMax_3`, `delayRepeatMin_3`, `delayRepeatMax_3`, `scriptId_3`, `spellId_4`, `probability_4`, `castTarget_4`, `targetParam1_4`, `targetParam2_4`, `castFlags_4`, `delayInitialMin_4`, `delayInitialMax_4`, `delayRepeatMin_4`, `delayRepeatMax_4`, `scriptId_4`, `spellId_5`, `probability_5`, `castTarget_5`, `targetParam1_5`, `targetParam2_5`, `castFlags_5`, `delayInitialMin_5`, `delayInitialMax_5`, `delayRepeatMin_5`, `delayRepeatMax_5`, `scriptId_5`, `spellId_6`, `probability_6`, `castTarget_6`, `targetParam1_6`, `targetParam2_6`, `castFlags_6`, `delayInitialMin_6`, `delayInitialMax_6`, `delayRepeatMin_6`, `delayRepeatMax_6`, `scriptId_6`, `spellId_7`, `probability_7`, `castTarget_7`, `targetParam1_7`, `targetParam2_7`, `castFlags_7`, `delayInitialMin_7`, `delayInitialMax_7`, `delayRepeatMin_7`, `delayRepeatMax_7`, `scriptId_7`, `spellId_8`, `probability_8`, `castTarget_8`, `targetParam1_8`, `targetParam2_8`, `castFlags_8`, `delayInitialMin_8`, `delayInitialMax_8`, `delayRepeatMin_8`, `delayRepeatMax_8`, `scriptId_8`) VALUES
(145160, 'Scholomance - Death Knight Darkreaver', 22644, 100, 1, 0, 0, 0, 10, 12, 20, 25, 0, 15284, 100, 1, 0, 0, 0, 3, 4, 3, 6, 0, 7645, 100, 5, 0, 0, 2, 15, 17, 30, 40, 0, 17393, 100, 4, 0, 0, 2, 7, 9, 7, 9, 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 `creature_ai_scripts` WHERE `id` IN (1451601, 1451602, 1451603, 1451604, 1451605, 1451606);
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(1451601, 0, 15, 23261, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Darkreaver - Cast Spell \'Summon Darkreaver\'s Fallen Charger\''),
(1451602, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 9784, 0, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Darkreaver - Say Text');

ERROR:SQL: cannot execute 'INSERT INTO character_inventory (guid,bag,slot,item,item_template) VALUES (?, ?, ?, ?, ?)'
ERROR:SQL ERROR: When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.

I have noticed that when you login with a GM account (gmlevel 3), any interaction with liquids are neglected.

Current behavior:

Any character from a GM account will ignore any kind of liquid interaction, no damage for touching lava neither the need of air while swimming underwater.

Expected behavior:

GM characters should be able to interact with liquids (lava damage and air), I think this behavior should be neglected while on GM mode or GOD mode enabled

Steps to reproduce:

1. Login with a GM account, be sure GM mode and GOD mode are disabled.
2. Get into lava, swims without damage.
3. Get into water, swims underwater without time limitation.

Client version:

1.12.1

Commit hash:

006ae16

Current behavior:

To modify the supported client version, you need to edit SUPPORTED_CLIENT_BUILD directly

Enhancement suggestion:

To modify the supported client version, you need to add a cmake definition, ie:
-DSUPPORTED_CLIENT_BUILD=5086

Current behavior:
when I add a playerbot with .bot add or with any .bot command it connects and disconnects repetitively
(google traductor)
Operating system:
windows server 2008r2

Last commit

https://youtu.be/MU7znVlr66k

look this @ratkosrb thanks.

Add OOC Texts for creatures:

• Marshal Gryan Stoutmantle (Entry: 234)
• Protector Gariel (Entry: 490)
• Protector Bialon (Entry: 487)
• Captain Danuvin (Entry: 821)
• Barkeep Hann (Entry: 274)

Original commit TC

-- Marshal Gryan Stoutmantle, Protector Gariel, Protector Bialon, Captain Danuvin & Barkeep Hann
UPDATE `creature_template` SET `AIName` = "EventAI" WHERE `entry` IN (234, 490, 487, 821, 274);
DELETE FROM `creature_ai_events` WHERE `id` = 23401 AND `creature_id` = 234;
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(23401, 234, 0, 1, 0, 100, 1, 1000, 15000, 150000, 180000, 23401, 0, 0, "Marshal Gryan Stoutmantle - Random OOC Say");
DELETE FROM `creature_ai_scripts` WHERE `id` = 23401;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(23401, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 39, 40, 44, 0, 0, 0, 0, 0, 0, "Marshal Gryan Stoutmantle - Say Text");
UPDATE `broadcast_text` SET `EmoteId0` = 1 WHERE `ID` IN (39, 40, 44);

DELETE FROM `creature_ai_events` WHERE `id` = 49001 AND `creature_id` = 490;
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(49001, 490, 0, 1, 0, 100, 1, 30000, 45000, 150000, 180000, 49001, 0, 0, "Protector Gariel - Random OOC Say");
DELETE FROM `creature_ai_scripts` WHERE `id` = 49001;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(49001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 0, 0, "Protector Gariel - Say Text");
UPDATE `broadcast_text` SET `EmoteId0` = 1 WHERE `ID` = 41;

DELETE FROM `creature_ai_events` WHERE `id` = 48701 AND `creature_id` = 487;
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(48701, 487, 0, 1, 0, 100, 1, 75000, 90000, 150000, 180000, 48701, 0, 0, "Protector Bialon - Random OOC Say");
DELETE FROM `creature_ai_scripts` WHERE `id` = 48701;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(48701, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0, 0, "Protector Bialon - Say Text");
UPDATE `broadcast_text` SET `EmoteId0` = 1 WHERE `ID` = 42;

DELETE FROM `creature_ai_events` WHERE `id` = 82101 AND `creature_id` = 821;
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(82101, 821, 0, 1, 0, 100, 1, 120000, 135000, 150000, 180000, 82101, 0, 0, "Captain Danuvin - Random OOC Say");
DELETE FROM `creature_ai_scripts` WHERE `id` = 82101;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(82101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43, 0, 0, 0, 0, 0, 0, 0, 0, "Captain Danuvin - Say Text");
UPDATE `broadcast_text` SET `EmoteId0` = 1 WHERE `ID` = 43;

DELETE FROM `creature_ai_events` WHERE `id` = 27401 AND `creature_id` = 274;
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(27401, 274, 0, 1, 0, 40, 1, 1000, 15000, 150000, 180000, 27401, 0, 0, "Barkeep Hann - Random OOC Say");
DELETE FROM `creature_ai_scripts` WHERE `id` = 27401;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(27401, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 80, 81, 0, 0, 0, 0, 0, 0, 0, "Barkeep Hann - Say Text");
UPDATE `broadcast_text` SET `EmoteId0` = 1 WHERE `ID` IN (80, 81);

Pre-compiled successfully with the latest source code!
But there is a problem: in mangosd.exe, enter any command in the console, the program crashes!

Fixed gossip menu options for creatures:

• Flik (Entry: 14860)
• Lhara (Entry: 14846)
• Sylannia (Entry: 14844)
• Maxima Blastenheimer (Entry: 15303)
• Quartermaster Lewis (Entry: 491)

-- Add gossip menu for Flik
DELETE FROM `npc_gossip` WHERE `npc_guid` IN (54417, 56625);
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES
(6231, 0, 1, 'You mean to tell me you sell frogs?', 10186, 3, 4, 0, 0, 0, 0, NULL, 0);
UPDATE `creature_template` SET `gossip_menu_id` = 6231 WHERE `entry` = 14860;

-- Add gossip menu for Lhara
DELETE FROM `npc_gossip` WHERE `npc_guid` IN (54402, 56497);
INSERT INTO `gossip_menu` (`entry`, `text_id`, `condition_id`) VALUES
(6233, 7389, 0);
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES
(6233, 0, 1, 'What do you have for sale?', 10182, 3, 4, 0, 0, 0, 0, NULL, 0);
UPDATE `creature_template` SET `gossip_menu_id` = 6233 WHERE `entry` = 14846;

-- Add gossip menu for Sylannia
DELETE FROM `npc_gossip` WHERE `npc_guid` IN (54398, 56623);
INSERT INTO `gossip_menu` (`entry`, `text_id`, `condition_id`) VALUES
(6230, 7404, 0);
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES
(6230, 0, 1, 'Show me the drinks!', 10179, 3, 4, 0, 0, 0, 0, NULL, 0);
UPDATE `creature_template` SET `gossip_menu_id` = 6230 WHERE `entry` = 14844;

-- Add gossip menu & fix gossip text for Maxima Blastenheimer
DELETE FROM `npc_gossip` WHERE `npc_guid` IN (52415, 1182594);
INSERT INTO `gossip_menu` (`entry`, `text_id`, `condition_id`) VALUES
(6574, 7790, 0),
(6575, 7789, 0);
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES
(6575, 0, 0, 'How do I use the cannon?', 10769, 1, 1, 6574, 0, 0, 0, NULL, 0);
UPDATE `creature_template` SET `gossip_menu_id` = 6575 WHERE `entry` = 15303;

-- Add gossip menu for Quartermaster Lewis
DELETE FROM `npc_gossip` WHERE `npc_guid` = 48879;
UPDATE `creature_template` SET `gossip_menu_id` = 4107 WHERE `entry` = 491;

https://www.ownedcore.com/forums/world-of-warcraft/world-of-warcraft-emulator-servers/wow-emu-exploits-bugs/672883-vanilla-wow-1-12-1-dmg-exlpoit-mb-work-other-versions.html

@ratkosrb

Vanilla wow 1.12.1 dmg exlpoit (mb work on other versions )
Greetings!

Im find this exlpoit in september 2017 ,now it is Fixed on Light's Hope/Kronos/Nighthaven , but mb it is work on your server .
Step 1.
You need warrior or shaman or paladin(Because this class have talent which increases weapon damage) On warrior you need Two-handed weapon specialization talent (in arms spec) or One-Handed Weapon specialization (in prot spec) . On Shaman you need Weapon Mastery (talent in Enhancement spec). On Paladin you need One-hended weapon specialization talent ( in Protection spec) or Two-Handed weapon specialization ( in Retribution spec).
Step 2.
You must Find mobs, who can disarm you ( scorpid tail lasher in tanaris / Sunscale Lashtail in barrens/ Highland Lashtail in Wetlands and other )
Step 3.
You must move you weapon to your bag
Step 4.
Attack mob and get disarm without weapon, wait when disarm will end, and move your weapon back
Step 5.
Do 3-4 steps and enjoy=)

If it work on your server - pls write me your server =)

Current behavior:
最新core编译后获取角色列表会加载很久
Expected behavior:

Steps to reproduce:

1. 超过100人登陆，获取角色列表加载超过5分钟

Client version:

Commit hash:

Operating system:

@ratkosrb
I registered the vmangos.org domain name and currently .com / .net is not registered! Please register first.
I will use vmangos.org as a promotional vmangos and provide a vmangos pre-compiled download site.
If there are other needs, I can assign vmangos.org to the analysis you need.

Quest(ID:4975) can not be completed.
I'm not sure, because I only waited 24 hours.

Add Mogg and Pooka OOC event
Original TC commit

-- Mogg and Pooka
UPDATE `creature_template` SET `equipment_id` = 14908 WHERE `entry` = 14908;

UPDATE `creature` SET `spawndist` = 0, `MovementType` = 2 WHERE `guid` = 13964 AND `id` = 14908;
DELETE FROM `creature_movement` WHERE `id` = 13964;

DELETE FROM `creature_equip_template` WHERE `entry` = 14908;
INSERT INTO `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) VALUES
(14908, 3350, 0, 0);

DELETE FROM `creature_movement_template` WHERE `entry` = 14908;
INSERT INTO `creature_movement_template` (`entry`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`script_id`,`textid1`) VALUES 
(14908,1,1022.24,-2235.11,93.3114, 0, 0, 0, 0),
(14908,2,1023.37,-2238.18,92.3744, 0, 0, 0, 0),
(14908,3,1024.2,-2243.96,92.4697, 0, 0, 0, 0),
(14908,4,1022.05,-2244.86,92.3385, 0, 0, 0, 0),
(14908,5,1020.21,-2242.92,92.2321, 2.642854, 8000, 1490801, 0),
(14908,6,1034.19,-2250.56,92.8656, 5.423162, 6000, 1490802, 0),
(14908,7,1033.85,-2258.61,93.6338, 5.976867, 5000, 1490803, 0),
(14908,8,1037.68,-2262.02,93.8145, 0, 0, 0, 0),
(14908,9,1036.96,-2269.7,93.7554, 0, 0, 0, 10297),
(14908,10,1042,-2273.46,93.6932, 0, 0, 0, 0),
(14908,11,1042.7,-2275.52,93.5781, 0, 0, 0, 0),
(14908,12,1046.52,-2274.46,93.6045, 0, 0, 0, 0),
(14908,13,1050.26,-2270.44,93.4986, 0, 0, 0, 0),
(14908,14,1049.74,-2266.86,93.3475, 0, 0, 0, 0),
(14908,15,1048.05,-2263.53,93.2249, 0, 0, 0, 0),
(14908,16,1041.05,-2258.77,93.4525, 0, 0, 0, 0),
(14908,17,1039.14,-2253.68,92.9611, 100, 6000, 1490804, 0),
(14908,18,1032.8,-2253.55,93.3633, 0, 0, 0, 0),
(14908,19,1025.83,-2258.54,93.1641, 0, 0, 0, 0),
(14908,20,1021.94,-2266.24,92.8306, 0, 0, 0, 0),
(14908,21,1022.81,-2272.14,92.6617, 0, 0, 0, 0),
(14908,22,1027.02,-2277.89,92.6709, 0, 0, 0, 0),
(14908,23,1036.56,-2280.12,93.1197, 0, 0, 0, 0),
(14908,24,1046.66,-2275.73,93.5356, 0, 0, 0, 0),
(14908,25,1049.61,-2269.77,93.5509, 0, 0, 0, 0),
(14908,26,1045.76,-2261.03,93.2522, 0, 0, 0, 0),
(14908,27,1038.3,-2254.31,93.1039, 100, 6000, 1490805, 0),
(14908,28,1028.89,-2245.04,92.4171, 2.151978, 14000, 1490806, 0),
(14908,29,1016.87,-2225.77,93.1025, 100, 80000, 1490807, 0);

DELETE FROM `creature_movement_scripts` WHERE `id` IN (1490801, 1490802, 1490803, 1490804, 1490805, 1490806, 1490807);
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(1490801, 1, 20, 1, 1, 0, 1, 13980, 0, 9, 2, 0, 0, 0, 0, 5, 0, 0, 0, 0, 'Mogg - Set Random Movement 5 Yards (Pooka)'),
(1490801, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10293, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Say Text'),
(1490801, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10294, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Say Text'),

(1490802, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10295, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Say Text'),
(1490802, 5, 25, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Set Run On'),

(1490803, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10296, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Say Text'),

(1490804, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10298, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Say Text'),

(1490805, 2, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Set Run Off'),
(1490805, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10299, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Say Text'),

(1490806, 0, 20, 0, 0, 0, 1, 13980, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Stop Random Movement (Pooka)'),
(1490806, 2, 3, 0, 0, 2, 1, 13980, 0, 9, 2, 0, 0, 0, 0, 1021.28, -2233.42, 93.33, 5.05, 0, 'Mogg - Move To Position (Pooka)'),
(1490806, 6, 0, 0, 0, 0, 0, 13980, 0, 9, 2, 10300, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Say Text (Pooka)'),
(1490806, 8, 3, 0, 0, 2, 1, 13980, 0, 9, 2, 0, 0, 0, 0, 1013.24, -2221.47, 92.9837, 2.5, 0, 'Mogg - Move To Position (Pooka)'),
(1490806, 12, 3, 0, 0, 2, 1, 13980, 0, 9, 2, 0, 0, 0, 0, 1017.95, -2224.33, 93.08, 4.7, 0, 'Mogg - Move To Position (Pooka)'),
(1490806, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10301, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Say Text'),
(1490806, 16, 20, 1, 1, 0, 1, 13980, 0, 9, 2, 0, 0, 0, 0, 5, 0, 0, 0, 0, 'Mogg - Set Random Movement 5 Yards (Pooka)'),

(1490807, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10303, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Say Text'),
(1490807, 4, 0, 0, 0, 0, 0, 13980, 0, 9, 2, 10304, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Say Text (Pooka)'),
(1490807, 5, 60, 3, 0, 0, 0, 13980, 0, 9, 2, 0, 14909, 0, 0, 0, 0, 0, 0, 0, 'Mogg - Start Waypoints (Pooka)');

DELETE FROM creature_movement_special WHERE id = 14909;
INSERT INTO creature_movement_special (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(14909, 1, 1025.19, -2239.77, 92.4462, 0, 0, 0),
(14909, 2, 1032.77, -2242.09, 92.1655, 0, 0, 0),
(14909, 3, 1040.45, -2241.81, 91.9457, 0, 0, 0),
(14909, 4, 1040.65, -2233.18, 91.735, 0, 0, 0),
(14909, 5, 1037.72, -2227.49, 91.8037, 0, 0, 0),
(14909, 6, 1035.65, -2224.96, 91.9576, 3.011992, 12000, 1490901),
(14909, 7, 1039.38, -2231.71, 91.7299, 0, 0, 0),
(14909, 8, 1041.05, -2240.78, 91.9556, 0, 0, 0),
(14909, 9, 1031.51, -2241.51, 92.1757, 0, 0, 0),
(14909, 10, 1025.37, -2240.84, 92.4583, 0, 0, 0),
(14909, 11, 1020.98, -2232.5, 93.3069, 0, 0, 0),
(14909, 12, 1014.45, -2225.92, 93.0579, 100, 1000, 1490902);

DELETE FROM `creature_movement_scripts` WHERE `id` IN (1490901, 1490902);
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(1490901, 1, 1, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Pooka - Play Emote'),
(1490901, 6, 1, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Pooka - Play Emote'),

(1490902, 0, 20, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 'Pooka - Set Random Movement 5 Yards');

Add Missed White Kitten spawn
White Kitten was follows to Little Timmy
Used Free GUID
Data taken from cmangos classic

-- White Kitten
DELETE FROM `creature_groups` WHERE `leader_guid` = 45501;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES 
(45501, 45501, 0, 0, 1),
(45501, 53705, 2, 155, 1);
DELETE FROM creature WHERE guid = 53705 AND id = 7386;
INSERT INTO creature (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType) VALUES
(53705, 7386, 0, 0, 0, -8650, 903.817, 98.421, 3.768, 180, 180, 0, 0, 64, 0, 0, 0);

Add pool & Random MovementType for creature: Vultros (Entry: 462)
Data taken from cmangos classic
Used free GUIDs

-- Vultros
UPDATE `creature` SET `spawndist` = 20, `MovementType` = 1 WHERE `guid` = 28407 AND `id` = 462;
DELETE FROM `creature` WHERE `guid` IN (99118, 99119, 99120, 99121, 99122, 99123, 99124, 99125, 99126, 99127, 99128, 99129, 99130, 99131, 99132) AND `id` = 462;
INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(99118, 462, 0, 507, 0, -10812.2, 1594.89, 40.5767, 3.77027, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99119, 462, 0, 507, 0, -10858.9, 1729.85, 34.0217, 5.03084, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99120, 462, 0, 507, 0, -10746.1, 1402.35, 31.2243, 5.6843, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99121, 462, 0, 507, 0, -10801.9, 1418.7, 33.4624, 1.94188, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99122, 462, 0, 507, 0, -10477.4, 1471.47, 48.6513, 5.2162, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99123, 462, 0, 507, 0, -10425.4, 1426.25, 44.2233, 2.22619, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99124, 462, 0, 507, 0, -10431.2, 1378.46, 65.494, 0.722943, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99125, 462, 0, 507, 0, -9955.56, 1228.82, 42.7644, 3.27077, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99126, 462, 0, 507, 0, -9941.29, 1098.53, 35.6962, 2.56156, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99127, 462, 0, 507, 0, -10730.7, 802.78, 37.7118, 3.13019, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99128, 462, 0, 507, 0, -10757.4, 779.167, 35.7259, 4.05696, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99129, 462, 0, 507, 0, -10770.2, 723.453, 37.2173, 1.87277, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99130, 462, 0, 507, 0, -11161.7, 845.012, 39.2314, 0.226577, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99131, 462, 0, 507, 0, -11124.4, 863.032, 40.5566, 0.620062, 108000, 108000, 20, 0, 920, 0, 0, 1),
(99132, 462, 0, 507, 0, -11131.2, 826.004, 35.7787, 5.17773, 108000, 108000, 20, 0, 920, 0, 0, 1);
DELETE FROM `pool_template` WHERE `entry` = 462;
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(462, 1, "Vultros (462)");
DELETE FROM `pool_creature_template` WHERE `id` = 462;
INSERT INTO `pool_creature_template` (`id`, `pool_entry`, `chance`, `description`) VALUES
(462, 462, 0, "Vultros (462)");

This script is unable to realize the transmission function after clicking.

I'm noticing the slow-cast speed values are way off. For example, Holy Light -- a 2.5-second cast, with a 60% increase to that cast (1.5 seconds) should be 4 seconds. Instead, the cast speed is 6.25 seconds. A 50% increase to cast speed (from, say, Mind-numbing Poison) is 5 seconds -- 100% increase in cast speed, double what it should be.

Current behavior:
disenchant item
Expected behavior:

Steps to reproduce:

1. learn disenchant.
2. disenchant item
   Items cannot be picked up, items are automatically acquired into the bag.

Console error log information.
None (Guid: 0) is unsupported for looking. (Player Jack (Guid: 2)

Client version:
1.12.1
Commit hash:
high
Operating system:
win 10

Current behavior:
Using the GM command will cause the server to crash, for example: .npc
Use the latest core
Expected behavior:

Steps to reproduce:

1. Using the GM command will cause the server to crash, for example: .npc
2. Use the latest core

Client version:

Commit hash:

Operating system:

@ratkosrb

Add Trok OOC event
(!) I dont known why the movement is switched to RUN only at three identical points WP with script 11.

Original commit TC

-- Trok
UPDATE `creature` SET `spawndist` = 0, `MovementType` = 0, `position_x` = 180.182, `position_y` = -2862.82, `position_z` = 93.2346 WHERE `guid` IN (13589, 13588, 13587, 13586);
DELETE FROM `creature_movement` WHERE `id` IN (13589, 13588, 13587, 13586);
DELETE FROM `creature_groups` WHERE `leader_guid` = 13178;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES 
(13178, 13178, 0, 0, 1),
(13178, 13589, 3, 30, 1),
(13178, 13588, 3, 60, 1),
(13178, 13587, 3, 330, 1),
(13178, 13586, 3, 300, 1);
UPDATE `creature_template` SET `speed_run` = 1.257143 WHERE `entry` = 14894;
DELETE FROM `creature_movement` WHERE `id` = 13178;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES
(13178, 1, 178.499, -2857.34, 93.849, 0, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 2, 178.499, -2857.34, 93.849, 0, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 3, 178.499, -2857.34, 93.849, 0, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 4, 184.597, -2835.96, 93.453, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 5, 198.418, -2819.86, 93.8766, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 6, 220.168, -2814.64, 93.2075, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 7, 243.385, -2830.24, 91.6692, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 8, 261.819, -2827.79, 91.6677, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 9, 254.995, -2812.46, 91.6677, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 10, 232.858, -2803.37, 92.7026, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 11, 209.538, -2795.58, 92.5157, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 12, 187.199, -2796.61, 92.2436, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 13, 168.673, -2810.94, 92.0277, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 14, 161.353, -2831.43, 92.3402, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 15, 163.975, -2853.26, 94.2934, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 16, 166.283, -2869.9, 93.1487, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 17, 172.251, -2894.95, 92.069, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 18, 183.756, -2910.68, 93.3137, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 19, 199.554, -2910.93, 92.5125, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 20, 208.087, -2924.7, 92.2502, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 21, 193.876, -2931.1, 93.1867, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 22, 189.428, -2912.61, 93.323, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 23, 185.647, -2895.12, 92.5841, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 24, 206.266, -2883.81, 92.2722, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 25, 176.803, -2870.31, 92.9238, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13178, 26, 166.825, -2871.93, 92.9655, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
UPDATE `creature_template` SET `AIName` = "EventAI" WHERE `entry` = 14872;
DELETE FROM `creature_ai_events` WHERE `id` = 1487201 AND `creature_id` = 14872;
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(1487201, 14872, 0, 1, 0, 100, 1, 10000, 20000, 10000, 20000, 1487201, 0, 0, "Trok - Random OOC Say");
DELETE FROM `creature_ai_scripts` WHERE `id` = 1487201;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(1487201, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10259, 10260, 10261, 10262, 0, 0, 0, 0, 0, "Trok - Say Text");

Hi.
Can not summon the Urok in Blackrock Spire.

This is the new server after LH-SERVER? Ahhaha, a new era!

Add OOC event for creatures: Grub & Duhng
Data taken from cmangos classic

-- Grub & Duhng
UPDATE creature SET MovementType = 2, spawndist = 0 WHERE guid = 14390 AND id = 3443; 
DELETE FROM creature_movement WHERE id = 14390;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`,`script_id`,`orientation`) VALUES
(14390, 1, -534.982, -2982.22, 93.0775, 90000, 344301, 1.3439);
DELETE FROM `creature_movement_scripts` WHERE `id` = 344301;
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(344301, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grub - Play Emote'),
(344301, 4, 1, 0, 0, 0, 0, 14389, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grub - Play Emote (Duhng)'),
(344301, 7, 35, 1, 0, 0, 0, 14389, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 4.583168, 0, 'Grub - Set Orientation (Duhng)'),
(344301, 10, 1, 1, 0, 0, 0, 14389, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grub - Play Emote (Duhng)'),
(344301, 14, 35, 1, 0, 0, 0, 14389, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 5.91667, 0, 'Grub - Set Orientation (Duhng)'),
(344301, 16, 1, 173, 0, 0, 0, 14389, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grub - Play Emote (Duhng)');

There's a problem that's been bothering me.
In the era of LH-Server, it exists!

Start mangosd.exe, enter the game! Sometimes the chat window will prompt: the server will restart after 10 minutes!

This operation happens by accident, not every time.
why~~? @ratkosrb

Add Gossip for creature Gann Stonespire.
This option available only to shamans.
Original TC Commit

-- Gann Stonespire
UPDATE `creature_template` SET `gossip_menu_id` = 445 WHERE `entry` = 3341;
DELETE FROM `npc_gossip` WHERE `npc_guid` = 13173;

DELETE FROM `gossip_menu` WHERE `entry` IN (445, 446);
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
(445, 942),
(446, 943);

DELETE FROM `gossip_menu_option` WHERE `menu_id`=445;
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`, `condition_id`) VALUES
(445,0,0,"Can you tell me where Brine is?",3013,1,1,446,0,0,0,"",0,92);

quest:310
If the first task fails, this task will never be completed.

Current behavior:
Compile the latest code，Unable to start server，program crash。
Expected behavior:

Steps to reproduce:

2018-11-23 11:23:15 ERROR:SQL: SELECT entry, mask FROM spell_elixir WHERE 5875 BETWEEN build_min AND build_max
2018-11-23 11:23:15 ERROR:[1054] Unknown column 'build_min' in 'where clause'
2018-11-23 11:23:15 ERROR:Your database structure is not up to date. Please make sure you have executed all the queries in the sql/updates folders.
2.
3.

Client version:

Commit hash:

Operating system:

Current behavior:
Building the source on centos 7 using devtoolset-7 fails when building game/Camera.cpp

Expected behavior:
The build completes without errors.

Steps to reproduce:

1. clone the repo
   git clone https://github.com/vmangos/core.git
2. make a directory for out of source building
   mkdir build
   cd build
3. call cmake to make the makefiles
   cmake3 ../core
4. call cmake to build the project
   cmake3 --build .

Operating system:
centos 7 using devtoolset-7

Current behavior:
Database currently has some item entries with late vanilla displayids and names.
Expected behavior:
Items should use the accurate displayid and name for the difrerent patches.

I've made a list of all items that uses newer displayids or names than they are supposed to. List stretches from 1.3 to 1.10.
It includes the old displayids and when it was updated to newer item displayid currently used in DB. What's left to do is add it to item_template. Syntax is entry, name, displayid, itemset.
https://drive.google.com/uc?export=download&id=1UsfhWRsdubRuzpUKnnPTjCPc8GXRHfL8

Sources: Allakhazam, Blackstorm v1 (WoWemu 4222.2.x) and Brotalias DBC versions sql.

Current behavior:
If I enter a cave or tunnel, the mobs seem to be glued to the spot. They do not patrol or move at all

I can initiate a ranged attack. This causes damage, however the mob goes into evade and the attack is reset. If I get into melee distance, the mob will attack me, however it will still not move.

Expected behavior:
Mobs in caves will behave like mobs outside of caves.

Steps to reproduce:
I am pretty sure it is a problem with my install, but I am not sure how to localise the problem.
I am not sure what is wrong. I tried recreating my database, however that did not seem to help.

Add OOC script for Horde Laborers
Relied on scripts with cmangos classic (commit unfortunately I do not remember), but still thanks to them.

-- Horde Laborers
UPDATE `creature` SET `MovementType` = 2, `spawndist` = 0 WHERE `guid` IN (14429, 14431, 14432, 14430, 14428) AND `id` = 14718; 
DELETE FROM `creature_movement` WHERE `id` IN (14429, 14431, 14432, 14430, 14428);
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(14429, 1, 1029.83, -2154.75, 123.049, 180000, 1471801, 1.19849),
(14431, 1, 1019.54, -2142.49, 124.767, 174000, 1471802, 0.882199),
(14432, 1, 1015.51, -2138.34, 125.82, 166000, 1471803, 0.753775),
(14430, 1, 1010.26, -2134.29, 126.945, 170000, 1471804, 0.612264),
(14428, 1, 1034.29, -2112.98, 122.946, 0, 0, 0),
(14428, 2, 1034.5, -2115.07, 122.946, 0, 0, 0),
(14428, 3, 1034.06, -2125.55, 122.953, 0, 0, 0),
(14428, 4, 1033.47, -2136.03, 122.94, 0, 0, 0),
(14428, 5, 1033.66, -2148.56, 122.9, 0, 0, 0),
(14428, 6, 1032.68, -2152.52, 122.948, 0, 0, 0),
(14428, 7, 1030.98, -2152.07, 122.97, 0, 0, 0),
(14428, 8, 1029.92, -2150.68, 123.052, 20000, 1471805, 2.228497),
(14428, 9, 1033.3, -2150.87, 122.922, 0, 0, 0),
(14428, 10, 1035.12, -2146.2, 122.907, 0, 0, 0),
(14428, 11, 1034.46, -2142.76, 122.858, 0, 0, 0),
(14428, 12, 1033.41, -2135.26, 122.941, 0, 0, 0),
(14428, 13, 1039.67, -2130.72, 123.491, 0, 0, 0),
(14428, 14, 1044.52, -2130.13, 124.082, 32000, 1471806, 0),
(14428, 15, 1044.52, -2130.13, 124.082, 0, 0, 0),
(14428, 16, 1034.41, -2128.47, 122.967, 0, 0, 0),
(14428, 17, 1034.34, -2124.97, 122.987, 0, 0, 0),
(14428, 18, 1034.2, -2114.47, 122.947, 0, 0, 0),
(14428, 19, 1032.9, -2106.12, 122.947, 0, 0, 0),
(14428, 20, 1029.66, -2104.47, 122.947, 60000, 1471807, 3.104217);

DELETE FROM `creature_movement_scripts` WHERE `id` IN (1471801, 1471802, 1471803, 1471804, 1471805, 1471806, 1471807);
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(1471801, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.39941, 0, 'Horde Laborer - Set Orientation'),
(1471801, 3, 1, 173, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471801, 121, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471801, 122, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.19849, 0, 'Horde Laborer - Set Orientation'),
(1471802, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.17085, 0, 'Horde Laborer - Set Orientation'),
(1471802, 3, 1, 173, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471802, 124, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471802, 125, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.882199, 0, 'Horde Laborer - Set Orientation'),
(1471803, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.137014, 0, 'Horde Laborer - Set Orientation'),
(1471803, 3, 1, 173, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471803, 127, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471803, 128, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.753775, 0, 'Horde Laborer - Set Orientation'),
(1471804, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3.943022, 0, 'Horde Laborer - Set Orientation'),
(1471804, 3, 1, 173, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471804, 119, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471804, 120, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.612264, 0, 'Horde Laborer - Set Orientation'),
(1471805, 3, 1, 69, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471805, 16, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471805, 18, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471806, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.08029, 0, 'Horde Laborer - Set Orientation'),
(1471806, 3, 1, 69, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471806, 14, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471806, 16, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.8455, 0, 'Horde Laborer - Set Orientation'),
(1471806, 18, 1, 69, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471806, 28, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471806, 29, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471807, 3, 1, 69, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471807, 8, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote'),
(1471807, 9, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Laborer - Play Emote');

Add end event script for quest "Operation Recombobulation"
Original script: script link

-- Quest: Operation Recombobulation (ID: 412)
UPDATE `quest_template` SET `CompleteScript` = 412 WHERE `entry` = 412;

DELETE FROM `quest_end_scripts` WHERE `id` = 412;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(412, 0, 4, 147, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Operation Recombobulation - Razzle Sprysprocket: npc_flag questgiver removed'),
(412, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 'Operation Recombobulation - Razzle Sprysprocket: Say Text'),
(412, 2, 60, 3, 1, 0, 0, 0, 0, 0, 0, 0, 1269, 0, 0, 0, 0, 0, 0, 0, 'Operation Recombobulation - Razzle Sprysprocket: Start Waypoints');

DELETE FROM `creature_movement_special` WHERE `id` = 1269;
INSERT INTO `creature_movement_special` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`) VALUES
(1269, 1, -5496.54, -455.453, 395.439, 1000, 0),
(1269, 2, -5496.54, -455.453, 395.439, 12000, 126901),
(1269, 3, -5499.83, -454.55, 395.439, 1000, 0),
(1269, 4, -5499.83, -454.55, 395.439, 15000, 126902),
(1269, 5, -5497.94, -455.835, 395.438, 1000, 0),
(1269, 6, -5497.94, -455.835, 395.438, 8000, 126903);

DELETE FROM `creature_movement_scripts` WHERE `id` IN (126901, 126902, 126903);
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(126901, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.31425, 0, 'Razzle Sprysprocket - Set Orientation'),
(126901, 2, 1, 69, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Play Emote'),
(126901, 10, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Play Emote'),
(126901, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1884, 0, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Say Text'),

(126902, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.27153, 0, 'Razzle Sprysprocket - Set Orientation'),
(126902, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1885, 0, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Say Text'),
(126902, 6, 1, 69, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Play Emote'),
(126902, 7, 15, 7344, 2, 0, 0, 5568, 25, 8, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Cast Spell \'Recombobulate\' (Captured Leper Gnome)'),
(126902, 7, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Play Emote'),
(126902, 9, 0, 0, 0, 0, 0, 186, 0, 9, 2, 1886, 0, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Say Text (Captured Leper Gnome)'),
(126902, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1887, 0, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Say Text'),

(126903, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.63683, 0, 'Razzle Sprysprocket - Set Orientation'),
(126903, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1888, 1889, 1890, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Say Text'),
(126903, 6, 14, 7344, 0, 0, 0, 5568, 25, 8, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Remove Aura \'Recombobulate\' (Captured Leper Gnome)'),
(126903, 6, 39, 126801, 126802, 0, 0, 1268, 25, 8, 2, 50, 50, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - Start Random Script (Ozzie Togglevolt)'),
(126903, 7, 4, 147, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Razzle Sprysprocket - npc_flag questgiver added');

DELETE FROM `event_scripts` WHERE `id` IN (126801, 126802);
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(126801, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1891, 1892, 1893, 0, 0, 0, 0, 0, 0, 'Ozzie Togglevolt - Say Random Text'),
(126802, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1895, 0, 0, 0, 0, 0, 0, 0, 'Ozzie Togglevolt - Say Random Text');

UPDATE `broadcast_text` SET `EmoteId0` = 5 WHERE `ID` = 1885;
UPDATE `broadcast_text` SET `EmoteId0` = 1 WHERE `ID` IN (1888, 1889, 1890);
UPDATE `broadcast_text` SET `EmoteId0` = 273 WHERE `ID` IN (1891, 1892, 1893, 1894, 1895);

i dont know how to add the scriptname now

The core is very unstable and crashes occur frequently.

** Problem description **
The wording of some (or maybe all) gossip_menu_options is incorrect. Compared to cmangos looks something like this (Example - CreatureID: 14845 (Stamp Thunderhorn "Darkmoon Faire Food Vendor")):

vMaNGOS:

cMaNGOS classic:

Tested on the newest revisions of both emulators.

Faced with the problem of displaying ranged weapons in their hands.
Take the creature as an example: Sergeant Major Skyshadow (Entry: 12780).

Result with vmangos:

Result with wowhead classic:
Link

Data from table 'creature_template_addon' is correct.

Interrupting data from the table 'creature_addon' no.

The Equipment table 'creature_equip_template' is present.

And tied to the creature itself.

This problem is present in all creatures with the sheath flag '2'.

Add OOC Texts for creature: Yarlyn Amberstill (Entry: 1263)
Part from here

-- Yarlyn Amberstill
UPDATE `creature_template` SET `AIName` = "EventAI" WHERE `entry` = 1263;
DELETE FROM `creature_ai_events` WHERE `id` = 126301 AND `creature_id` = 1263;
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(126301, 1263, 0, 1, 0, 100, 3, 1000, 15000, 30000, 45000, 126301, 126302, 126303, 'Yarlyn Amberstill - OOC Random Script');
DELETE FROM `creature_ai_scripts` WHERE `id` IN (126301, 126302, 126303);
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(126301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 159, 160, 0, 0, 0, 0, 0, 0, 0, 'Yarlyn Amberstill - Say Text'),
(126302, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 161, 162, 0, 0, 0, 0, 0, 0, 0, 'Yarlyn Amberstill - Say Text'),
(126303, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 164, 165, 0, 0, 0, 0, 0, 0, 0, 'Yarlyn Amberstill - Say Text');

Current behavior:
Database currently has patch 1.6.0+ itemdisplayids for all PvP items.
Expected behavior:
R14 PvP weapons and epic PvP leather/mail item displayids got updated in patch 1.6.0 and PvP epic cloth was updated in patch 1.8.0
The post 1.6.0/1.8.0 displayids won't load on clients released before those two patches, since the new displayids do not exist in older clients.

The list has all PvP itemdisplayids set to its original 1.4 state. It also includes notes when itemdisplayids got changed and a small comment on two items which should have a name change in older patches. All that is left to do is add it to item_template.

DL link for the list in SQL syntax:
https://drive.google.com/uc?export=download&id=1hr3q3uGFF0IQpPz4oykYTBCInRiTDJJQ

Patch notes:

Patch 1.6.0 (12-Jul-2005):

• Grand Marshal and High Warlord PvP Honor rewards have been updated
  with improved statistics and new unique art.
• The Alliance Mail and Horde Leather and Mail Epic PvP Honor reward
  armor sets have received art updates.

Patch 1.8.0 (10-Oct-2005):

• The PvP Tier2 Alliance and Horde Cloth armor sets have new updated
  textures.

Sources:
For the old diplayids the old WoWemu releases were used: Blackstorm v1 (WoWemu 4222.2.x) and Blackstorm WoWemu 4442.1.1. The latter was only used to find items not included in Blackstorm v1.
Also wanna thank Brotalia for providing the displayid versions DB which helped confirm that the new displayids did not exist before 1.6.0/1.8.0.

Hello dude.

Cmake "USE_ANTİCHEAT " enable not working.
core/src/game/Anticheat there are two files.
How we can add?

Client version: 1.12

Commit hash: f9e8c3d

Operating system: Windows 7 Sp1

Fix Erk & Fang event
Added OOC event for Horde Guards

Relied on scripts with cmangos classic (commit unfortunately I do not remember), but still thanks to them.

-- Erk & Fang
UPDATE `creature` SET `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 13578;
UPDATE `creature` SET `spawndist` = 0, `MovementType` = 2 WHERE `guid` = 13166;
DELETE FROM `creature_movement` WHERE `id` IN (13578, 13166);

DELETE FROM `creature_movement_template` WHERE `entry` = 14857;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `orientation`) VALUES 
(14857, 1, -29.461918, -2615.942383, 97.156921, 2000, 1485701, 0, 5.923830),
(14857, 2, -25.871311, -2613.071777, 97.237740, 10000, 1485702, 10249, 0.440972),
(14857, 3, -19.149178, -2619.644287, 97.206207, 0, 0, 0, 0),
(14857, 4, -11.761329, -2621.954346, 95.720047, 0, 0, 0, 0),
(14857, 5, -9.085948, -2621.673340, 94.958389, 0, 0, 0, 0),
(14857, 6, -3.633063, -2621.637939, 92.131180, 0, 0, 0, 0),
(14857, 7, 3.790725, -2621.660400, 89.812195, 35000, 1485703, 0, 6.159449),
(14857, 8, -0.125211, -2621.110107, 91.288040, 0, 0, 0, 0),
(14857, 9, -4.097071, -2636.676514, 91.979828, 0, 0, 0, 0),
(14857, 10, -9.720197, -2640.140869, 95.660744, 0, 0, 0, 0),
(14857, 11, -21.905458, -2647.225098, 95.833397, 0, 0, 0, 0),
(14857, 12, -29.928484, -2641.602295, 96.080391, 0, 0, 0, 0),
(14857, 13, -33.601181, -2638.687256, 96.445763, 0, 0, 0, 0),
(14857, 14, -33.754395, -2634.782715, 96.275017, 0, 0, 0, 0),
(14857, 15, -31.780426, -2631.539307, 95.990501, 0, 0, 0, 0),
(14857, 16, -30.316862, -2631.180908, 95.940948, 0, 0, 0, 0),
(14857, 17, -29.142475, -2632.012695, 95.948257, 10000, 0, 0, 5.829583),
(14857, 18, -29.142475, -2632.012695, 95.948257, 1000, 0, 10196, 5.829583),
(14857, 19, -32.082474, -2632.893555, 96.072723, 0, 0, 0, 0),
(14857, 20, -32.984558, -2638.700439, 96.384636, 0, 0, 0, 0),
(14857, 21, -31.521265, -2644.058350, 96.142921, 0, 0, 0, 0),
(14857, 22, -24.469679, -2646.372070, 95.832581, 0, 0, 0, 0),
(14857, 23, -18.641375, -2646.821289, 95.832581, 0, 0, 0, 0),
(14857, 24, -9.770051, -2641.352539, 95.589363, 0, 0, 0, 0),
(14857, 25, -8.478262, -2640.574463, 95.227699, 0, 0, 0, 0),
(14857, 26, -3.890227, -2637.855713, 92.000694, 0, 0, 0, 0),
(14857, 27, 4.778752, -2632.607178, 89.837997, 20000, 1485704, 0, 0.488875),
(14857, 28, 4.778752, -2632.607178, 89.837997, 0, 1485701, 0, 0.488875),
(14857, 29, 4.568168, -2635.551270, 90.447380, 0, 0, 0, 0),
(14857, 30, 10.748284, -2640.516846, 90.386475, 0, 0, 0, 0),
(14857, 31, 34.780556, -2655.085938, 91.912651, 0, 0, 0, 0),
(14857, 32, 53.316978, -2671.718994, 91.666901, 0, 0, 0, 0),
(14857, 33, 63.588814, -2689.054932, 92.944565, 0, 0, 0, 0),
(14857, 34, 60.226498, -2698.291016, 92.096138, 0, 0, 0, 0),
(14857, 35, 55.970112, -2699.551270, 91.900703, 0, 0, 0, 0),
(14857, 36, 55.045853, -2698.405762, 91.944672, 0, 1485702, 0, 2.487714),
(14857, 37, 55.045853, -2698.405762, 91.944672, 20000, 1485705, 0, 2.487714),
(14857, 38, 45.898525, -2702.470947, 91.700233, 0, 0, 0, 0),
(14857, 39, 31.040888, -2703.291992, 91.667572, 0, 0, 0, 0),
(14857, 40, 23.505503, -2699.469482, 91.734627, 0, 0, 0, 0),
(14857, 41, 10.482596, -2681.701416, 91.750694, 0, 0, 0, 0),
(14857, 42, -0.678281, -2668.660645, 91.921181, 0, 0, 0, 0),
(14857, 43, -8.814530, -2659.541016, 95.559288, 0, 0, 0, 0),
(14857, 44, -14.487419, -2643.521729, 95.831528, 0, 0, 0, 0),
(14857, 45, -17.088795, -2620.453125, 96.330254, 0, 0, 0, 0),
(14857, 46, -19.107914, -2619.602539, 97.197205, 0, 0, 0, 0),
(14857, 47, -29.461918, -2615.942383, 97.156921, 0, 0, 0, 0),
(14857, 48, -29.461918, -2615.942383, 97.156921, 120000, 0, 0, 5.923830);

DELETE FROM `creature_groups` WHERE `leader_guid` = 13166;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES 
(13166, 13166, 0, 0, 1),
(13166, 13578, 3, 180, 1);

DELETE FROM `creature_movement_scripts` WHERE `id` IN (1485701, 1485702, 1485703, 1485704, 1485705);
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `comments`) VALUES
(1485701, 0, 25, 1, 0, "Erk - Run On"),
(1485702, 0, 25, 0, 0, "Erk - Run Off");

INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(1485703, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10250, 0, 0, 0, 0, 0, 0, 0, 0, "Erk - Say Text"),
(1485703, 31, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10195, 0, 0, 0, 0, 0, 0, 0, 0, "Erk - Say Text"),
(1485704, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10205, 0, 0, 0, 0, 0, 0, 0, 0, "Erk - Say Text"),
(1485705, 3, 35, 0, 0, 0, 0, 13579, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Erk - Set Orientation'),
(1485705, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10198, 0, 0, 0, 0, 0, 0, 0, 0, 'Erk - Say Text'),
(1485705, 9, 0, 0, 0, 0, 0, 13579, 0, 9, 2, 10223, 0, 0, 0, 0, 0, 0, 0, 0, 'Erk - Say Text (Guard Kurall)'),
(1485705, 10, 1, 21, 0, 0, 0, 13579, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Erk - Play Emote (Guard Kurall)'),
(1485705, 15, 1, 7, 0, 0, 0, 19412, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Erk - Play Emote (Horde Guard)'),
(1485705, 15, 1, 7, 0, 0, 0, 13579, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Erk - Play Emote (Guard Kurall)'),
(1485705, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10206, 0, 0, 0, 0, 0, 0, 0, 0, 'Erk - Say Text');

UPDATE `creature` SET `MovementType` = 2, `spawndist` = 0 WHERE `guid` IN (19361, 19402);
DELETE FROM `creature_movement` WHERE `id` IN (19361, 19402);
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`,`script_id`,`orientation`) VALUES
(19361,1,-39.0541,-2612.88,97.6059,2000,0,0.314159),
(19361,2,-39.0541,-2612.88,97.6059,2600,1936101,0.314159),
(19361,3,-39.0541,-2612.88,97.6059,6000,0,0.314159),
(19402,1,-36.9096,-2614.24,97.1546,4000,0,2.58309),
(19402,2,-36.9096,-2614.24,97.1546,2600,1940201,2.58309),
(19402,3,-36.9096,-2614.24,97.1546,4000,0,2.58309);

DELETE FROM `creature_movement_scripts` WHERE `id` IN (1936101, 1940201);
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `comments`) VALUES
(1936101, 0, 1, 11, 7, 6, 1, "Horde Guard - Random Emote (11, 7, 6, 1)"),
(1940201, 0, 1, 273, 274, 6, 1, "Horde Guard - Random Emote (273, 274, 6, 1)");

UPDATE `creature` SET `MovementType` = 2, `spawndist` = 0 WHERE `guid` IN (19412, 13579);
DELETE FROM `creature_movement` WHERE `id` IN (19412, 13579);
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`,`script_id`,`orientation`) VALUES
(19412,1,55.2058,-2695.69,92.1666,2000,0,4.34587),
(19412,2,55.2058,-2695.69,92.1666,2600,1941201,4.34587),
(19412,3,55.2058,-2695.69,92.1666,6000,0,4.34587),
(13579,1,52.7833,-2696.62,92.0416,4000,0,6.04953),
(13579,2,52.7833,-2696.62,92.0416,2600,1357901,6.04953),
(13579,3,52.7833,-2696.62,92.0416,4000,0,6.04953);

DELETE FROM `creature_movement_scripts` WHERE `id` IN (1941201, 1357901);
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `comments`) VALUES
(1941201, 0, 1, 11, 7, 6, 1, "Horde Guard - Random Emote (11, 7, 6, 1)"),
(1357901, 0, 1, 273, 274, 6, 1, "Horde Guard - Random Emote (273, 274, 6, 1)");

5. Configuring the project with CMake
It tells to create a "build" directory next to a "server" directory, but there is no "server" directory.

Fix gossip menu of creatures:

• Darkmoon Faire Carnie (Entry: 14849)
• Bankers (Entry: 2455, 2456, 2457, 4155, 3309)

-- Add gossip menu for Darkmoon Faire Carnie
UPDATE `creature_template` SET `npcflag` = 1 WHERE `entry` = 14849;

-- Gossip menu for Bankers
UPDATE `creature_template` SET `npcflag` = 257 WHERE `entry` IN (2455, 2456, 2457);
UPDATE `creature_template` SET `npcflag` = 259 WHERE `entry` IN (4155, 3309);

hi
int Player::DestroyItem

        for (int i = 0; i < MAX_BAG_SIZE; ++i)
            DestroyItem(slot, i, update);    // Here may cause coredump.

when bag's containerslots > 18 and destroy bag in your bag.

in Cmakelists file we have (https://github.com/vmangos/core/blob/development/CMakeLists.txt).
lines 23-27.

# CMake policies (can not be handled elsewhere) cmake_policy(SET CMP0026 OLD) if(POLICY CMP0043) cmake_policy(SET CMP0043 OLD) # Disable 'Ignore COMPILE_DEFINITIONS_<Config> properties' endif()

why is this using the OLD policy and can it work without ?(haven't tried tbh but wondering what is the purpose of using OLD)?

The reason i ask is because Cmake gives me warnings saying that this selecting this policy is to be deprecated in coming versions of Cmake (or something like that). Can we simply remove those lines? or are they there for a reason that still remains valid (stability etc.), ty

How do I use playerbot? How do I fill out the MYSQL playerbot form?

At testing Judgment and Redemption quest i found some shortcomings in the battle with Death Knight Darkreaver. Namely the fight with summoned spirits and use them against the seals.
Currently, spirits only use combat spells. In them shortcomings not detected.

Detailed information I received here (Notes):
Click "Gamepedia"

Example of script:
Click "Github"