Summoned creatures over spawning fixes 7.02

[eyerobot]

Lard lost his lunch fix 7.02

If you are using version 7.02 or lower of the server repack. Then you can use this single sql file to correct the multitude of over spawned summoned creatures, That are called via event_scripts.

Most scripts were summoning four times the required amount of creatures that the quests called for.
So I cleaned up the event_scripts database table.
This is a total replacement for your event_scripts table, And SHOULD NOT BE USED if you have added any event_scripts of your own since downloading the repack version 7.02 or lower.

If you have added event scripts to your server, Then you will need to export those as sql queries, And save them in a file, So you can INSERT them after installing this database fix.

Ok, That's the end of the warnings.

The file to run on your emucoach-world database is
View attachment event_scriptsnew.sql


If you used the single file installation, You can ignore every post that i made after this one.



Lard lost his lunch

Remove overspawned attackers

DELETE FROM `event_scripts` WHERE `id`=8605 AND `datalong`=14748;

add the correct amount of attackers

DELETE FROM `event_scripts` WHERE `id`=8605 AND `delay`=2 AND `command`=10 AND `datalong`=14748 AND `datalong2`=600000 AND `dataint`=0 AND `x`=421.52 AND `y`=-4811.76 AND `z`=12.03 AND `o`=4.35;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (8605, 2, 10, 14748, 600000, 0, 421.52, -4811.76, 12.03, 4.35);
DELETE FROM `event_scripts` WHERE `id`=8605 AND `delay`=2 AND `command`=10 AND `datalong`=14748 AND `datalong2`=600000 AND `dataint`=0 AND `x`=414.5 AND `y`=-4812.67 AND `z`=12.54 AND `o`=4.48;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (8605, 2, 10, 14748, 600000, 0, 414.5, -4812.67, 12.54, 4.48);
DELETE FROM `event_scripts` WHERE `id`=8605 AND `delay`=2 AND `command`=10 AND `datalong`=14748 AND `datalong2`=600000 AND `dataint`=0 AND `x`=417.09 AND `y`=-4817.01 AND `z`=12.06 AND `o`=4.58;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (8605, 2, 10, 14748, 600000, 0, 417.09, -4817.01, 12.06, 4.58);

 

[eyerobot]

Khan Hratha

As far as i can tell this quest isn't even used anymore, But it's still in the database and overspawned, So....

DELETE FROM `event_scripts` WHERE `id`=1033 AND `datalong`=5402;
DELETE FROM `event_scripts` WHERE `id`=1033 AND `datalong`=6070;
DELETE FROM `event_scripts` WHERE `id`=1033 AND `datalong`=6069;



DELETE FROM `event_scripts` WHERE `id`=1033 AND `delay`=100 AND `command`=10 AND `datalong`=5402 AND `datalong2`=3000000 AND `dataint`=0 AND `x`=-1129.9 AND `y`=2896.08 AND `z`=195.91 AND `o`=3.15;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1033, 100, 10, 5402, 3000000, 0, -1129.9, 2896.08, 195.91, 3.15);
DELETE FROM `event_scripts` WHERE `id`=1033 AND `delay`=100 AND `command`=10 AND `datalong`=6070 AND `datalong2`=3000000 AND `dataint`=0 AND `x`=-1130.26 AND `y`=2894.02 AND `z`=196.27 AND `o`=3.15;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1033, 100, 10, 6070, 3000000, 0, -1130.26, 2894.02, 196.27, 3.15);
DELETE FROM `event_scripts` WHERE `id`=1033 AND `delay`=100 AND `command`=10 AND `datalong`=6069 AND `datalong2`=3000000 AND `dataint`=0 AND `x`=-1134.43 AND `y`=2902.35 AND `z`=196.56 AND `o`=3.85;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1033, 100, 10, 6069, 3000000, 0, -1134.43, 2902.35, 196.56, 3.85);
DELETE FROM `event_scripts` WHERE `id`=1033 AND `delay`=100 AND `command`=10 AND `datalong`=6069 AND `datalong2`=3000000 AND `dataint`=0 AND `x`=-1131.98 AND `y`=2886.77 AND `z`=197.59 AND `o`=2.55;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1033, 100, 10, 6069, 3000000, 0, -1131.98, 2886.77, 197.59, 2.55);
DELETE FROM `event_scripts` WHERE `id`=1033 AND `delay`=40 AND `command`=10 AND `datalong`=6070 AND `datalong2`=3000000 AND `dataint`=0 AND `x`=-1129.04 AND `y`=2895.67 AND `z`=195.7 AND `o`=3.11;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1033, 40, 10, 6070, 3000000, 0, -1129.04, 2895.67, 195.7, 3.11);
DELETE FROM `event_scripts` WHERE `id`=1033 AND `delay`=40 AND `command`=10 AND `datalong`=6069 AND `datalong2`=3000000 AND `dataint`=0 AND `x`=-1130.01 AND `y`=2901.11 AND `z`=195.35 AND `o`=3.35;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1033, 40, 10, 6069, 3000000, 0, -1130.01, 2901.11, 195.35, 3.35);
DELETE FROM `event_scripts` WHERE `id`=1033 AND `delay`=40 AND `command`=10 AND `datalong`=6069 AND `datalong2`=3000000 AND `dataint`=0 AND `x`=-1125.46 AND `y`=2890.14 AND `z`=195.27 AND `o`=2.9;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1033, 40, 10, 6069, 3000000, 0, -1125.46, 2890.14, 195.27, 2.9);
DELETE FROM `event_scripts` WHERE `id`=1033 AND `delay`=0 AND `command`=10 AND `datalong`=6069 AND `datalong2`=3000000 AND `dataint`=0 AND `x`=-1126.97 AND `y`=2901.03 AND `z`=194.33 AND `o`=3.45;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1033, 0, 10, 6069, 3000000, 0, -1126.97, 2901.03, 194.33, 3.45);
DELETE FROM `event_scripts` WHERE `id`=1033 AND `delay`=0 AND `command`=10 AND `datalong`=6069 AND `datalong2`=3000000 AND `dataint`=0 AND `x`=-1123.14 AND `y`=2892.65 AND `z`=194.96 AND `o`=3.11;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1033, 0, 10, 6069, 3000000, 0, -1123.14, 2892.65, 194.96, 3.11);

 

[eyerobot]

Moonrage Darkrunners

DELETE FROM `event_scripts` WHERE `id`=259 AND `datalong`=1770;

DELETE FROM `event_scripts` WHERE `id`=259 AND `delay`=2 AND `command`=10 AND `datalong`=1770 AND `datalong2`=300000 AND `dataint`=0 AND `x`=881.63 AND `y`=1230.37 AND `z`=47.83 AND `o`=3.1;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (259, 2, 10, 1770, 300000, 0, 881.63, 1230.37, 47.83, 3.1);

 

[eyerobot]

Forlorn Spirit

DELETE FROM `event_scripts` WHERE `id`=264 AND `datalong`=2044;

DELETE FROM `event_scripts` WHERE `id`=264 AND `delay`=3 AND `command`=10 AND `datalong`=2044 AND `datalong2`=300000 AND `dataint`=0 AND `x`=-9548.42 AND `y`=-1440.2 AND `z`=62.29 AND `o`=2.19;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (264, 3, 10, 2044, 300000, 0, -9548.42, -1440.2, 62.29, 2.19);

 

[eyerobot]

Gazban

DELETE FROM `event_scripts` WHERE `id`=364 AND `delay`=5 AND `command`=10 AND `datalong`=2624;

DELETE FROM `event_scripts` WHERE `id`=364 AND `delay`=5 AND `command`=10 AND `datalong`=2624 AND `datalong2`=900000 AND `dataint`=0 AND `x`=-12179.4 AND `y`=644.22 AND `z`=-67.1 AND `o`=5.18;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (364, 5, 10, 2624, 900000, 0, -12179.4, 644.22, -67.1, 5.18);

 

[eyerobot]

Dagun The Ravenous

DELETE FROM `event_scripts` WHERE `id`=452 AND `delay`=0 AND `command`=10 AND `datalong`=2937;

DELETE FROM `event_scripts` WHERE `id`=452 AND `delay`=0 AND `command`=10 AND `datalong`=2937 AND `datalong2`=3000000 AND `dataint`=0 AND `x`=-2360.55 AND `y`=-4102.38 AND `z`=6.93 AND `o`=2.25;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (452, 0, 10, 2937, 3000000, 0, -2360.55, -4102.38, 6.93, 2.25);

 

[eyerobot]

Preistess Udum'bra

DELETE FROM `event_scripts` WHERE `id`=466 AND `delay`=0 AND `command`=9 AND `datalong`=46424;

DELETE FROM `event_scripts` WHERE `id`=466 AND `delay`=0 AND `command`=9 AND `datalong`=46424 AND `datalong2`=0 AND `dataint`=0 AND `x`=0 AND `y`=0 AND `z`=0 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (466, 0, 9, 46424, 0, 0, 0, 0, 0, 0);

 

[eyerobot]

Ramkahen Prisoner

DELETE FROM `event_scripts` WHERE `id`=467 AND `delay`=0 AND `command`=9 AND `datalong`=46425;

DELETE FROM `event_scripts` WHERE `id`=467 AND `delay`=0 AND `command`=9 AND `datalong`=46425 AND `datalong2`=0 AND `dataint`=0 AND `x`=0 AND `y`=0 AND `z`=0 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (467, 0, 9, 46425, 0, 0, 0, 0, 0, 0);

 

[eyerobot]

Does not exist in database

DELETE FROM `event_scripts` WHERE `id`=468 AND `delay`=0 AND `command`=9 AND `datalong`=46429;

DELETE FROM `event_scripts` WHERE `id`=468 AND `delay`=0 AND `command`=9 AND `datalong`=46429 AND `datalong2`=0 AND `dataint`=0 AND `x`=0 AND `y`=0 AND `z`=0 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (468, 0, 9, 46429, 0, 0, 0, 0, 0, 0);

 

[eyerobot]

Kul Tiras Marine

DELETE FROM `event_scripts` WHERE `id`=498 AND `delay`=3 AND `command`=10 AND `datalong`=3129;

DELETE FROM `event_scripts` WHERE `id`=498 AND `delay`=3 AND `command`=10 AND `datalong`=3129 AND `datalong2`=300000 AND `dataint`=0 AND `x`=-228.09 AND `y`=-5115.08 AND `z`=49.32 AND `o`=1.28;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (498, 3, 10, 3129, 300000, 0, -228.09, -5115.08, 49.32, 1.28);

 

[eyerobot]

Defias Overseer

DELETE FROM `event_scripts` WHERE `id`=619 AND `delay`=3 AND `command`=10 AND `datalong`=634;

DELETE FROM `event_scripts` WHERE `id`=619 AND `delay`=3 AND `command`=10 AND `datalong`=634 AND `datalong2`=300000 AND `dataint`=0 AND `x`=-18.44 AND `y`=-617.46 AND `z`=14.12 AND `o`=0.08;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (619, 3, 10, 634, 300000, 0, -18.44, -617.46, 14.12, 0.08);

 

[eyerobot]

Velinde Starsong

DELETE FROM `event_scripts` WHERE `id`=664 AND `delay`=3 AND `command`=10 AND `datalong`=3946;

DELETE FROM `event_scripts` WHERE `id`=664 AND `delay`=3 AND `command`=10 AND `datalong`=3946 AND `datalong2`=60000 AND `dataint`=0 AND `x`=-11142.5 AND `y`=-1151.78 AND `z`=43.61 AND `o`=5.28;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (664, 3, 10, 3946, 60000, 0, -11142.5, -1151.78, 43.61, 5.28);

 

[eyerobot]

Frostmaw

DELETE FROM `event_scripts` WHERE `id`=727 AND `delay`=0 AND `command`=10 AND `datalong`=4504;

DELETE FROM `event_scripts` WHERE `id`=727 AND `delay`=0 AND `command`=10 AND `datalong`=4504 AND `datalong2`=3000000 AND `dataint`=0 AND `x`=264.94 AND `y`=-264.13 AND `z`=145.03 AND `o`=3.41;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (727, 0, 10, 4504, 3000000, 0, 264.94, -264.13, 145.03, 3.41);

 

[eyerobot]

Marsh Murloc

DELETE FROM `event_scripts` WHERE `id`=747 AND `delay`=5 AND `command`=10 AND `datalong`=4490;

DELETE FROM `event_scripts` WHERE `id`=747 AND `delay`=5 AND `command`=10 AND `datalong`=4490 AND `datalong2`=900000 AND `dataint`=0 AND `x`=-5589.63 AND `y`=-1575.89 AND `z`=11.75 AND `o`=6.02;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (747, 5, 10, 4490, 900000, 0, -5589.63, -1575.89, 11.75, 6.02);

 

[eyerobot]

Summoned Voidwalker

DELETE FROM `event_scripts` WHERE `id`=1131 AND `delay`=0 AND `command`=10 AND `datalong`=5676;

DELETE FROM `event_scripts` WHERE `id`=1131 AND `delay`=0 AND `command`=10 AND `datalong`=5676 AND `datalong2`=180000 AND `dataint`=0 AND `x`=-8973.05 AND `y`=1043.72 AND `z`=52.8631 AND `o`=2;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1131, 0, 10, 5676, 180000, 0, -8973.05, 1043.72, 52.8631, 2);

 

[eyerobot]

Summoned Succubus

DELETE FROM `event_scripts` WHERE `id`=1134 AND `delay`=0 AND `command`=10 AND `datalong`=5677;

DELETE FROM `event_scripts` WHERE `id`=1134 AND `delay`=0 AND `command`=10 AND `datalong`=5677 AND `datalong2`=180000 AND `dataint`=0 AND `x`=-8973.05 AND `y`=1043.72 AND `z`=52.8631 AND `o`=2;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1134, 0, 10, 5677, 180000, 0, -8973.05, 1043.72, 52.8631, 2);

 

[eyerobot]

Cyclonian

DELETE FROM `event_scripts` WHERE `id`=1370 AND `delay`=0 AND `command`=10 AND `datalong`=6239;

DELETE FROM `event_scripts` WHERE `id`=1370 AND `delay`=0 AND `command`=10 AND `datalong`=6239 AND `datalong2`=300000 AND `dataint`=0 AND `x`=332.821 AND `y`=-1473.05 AND `z`=42.2658 AND `o`=3.99963;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1370, 0, 10, 6239, 300000, 0, 332.821, -1473.05, 42.2658, 3.99963);

 

[eyerobot]

Summoned Voidwalker

DELETE FROM `event_scripts` WHERE `id`=1785 AND `delay`=0 AND `command`=10 AND `datalong`=5676;

DELETE FROM `event_scripts` WHERE `id`=1785 AND `delay`=0 AND `command`=10 AND `datalong`=5676 AND `datalong2`=180000 AND `dataint`=0 AND `x`=1704.61 AND `y`=41.9147 AND `z`=-63.8433 AND `o`=0.435896;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1785, 0, 10, 5676, 180000, 0, 1704.61, 41.9147, -63.8433, 0.435896);

 

[eyerobot]

Summoned Succubus

DELETE FROM `event_scripts` WHERE `id`=1786 AND `delay`=0 AND `command`=10 AND `datalong`=5677;

DELETE FROM `event_scripts` WHERE `id`=1786 AND `delay`=0 AND `command`=10 AND `datalong`=5677 AND `datalong2`=180000 AND `dataint`=0 AND `x`=1704.61 AND `y`=41.9147 AND `z`=-63.8433 AND `o`=0.435896;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (1786, 0, 10, 5677, 180000, 0, 1704.61, 41.9147, -63.8433, 0.435896);