diff options
| -rw-r--r-- | sql/FULL/world_scripts_full.sql | 4 | ||||
| -rw-r--r-- | sql/updates/6782_world_scriptnames.sql | 1 | ||||
| -rw-r--r-- | sql/updates/6792_world_spell_proc_event.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6795_world_creature_template.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6799_world_spell_proc_event.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6840_world_spell_proc_event.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6857_world_scriptnames.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6877_world_script_waypoints.sql | 1 | ||||
| -rw-r--r-- | sql/updates/6877_world_scriptnames.sql | 1 | ||||
| -rw-r--r-- | sql/updates/6881_world_spell_proc_event.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6898_world_spell_proc_event.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6901_world_spell_proc_event.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6903_world_spell_proc_event.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6915_world_spell_proc_event.sql | 2 |
14 files changed, 14 insertions, 13 deletions
diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 7a1b301d953..191a2e94a4a 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -1,7 +1,11 @@ -- Up to TC2 6928 -- Cleanup first +UPDATE `instance_template` SET `Script`=''; +UPDATE `item_template` SET `ScriptName`=''; UPDATE `creature_template` SET `ScriptName`=''; +UPDATE `gameobject_template` SET `ScriptName`=''; + /* WORLD BOSS */ UPDATE `creature_template` SET `ScriptName`='boss_ysondre' WHERE `entry`=14887; diff --git a/sql/updates/6782_world_scriptnames.sql b/sql/updates/6782_world_scriptnames.sql index 81791ab24cd..4b35a3b59b9 100644 --- a/sql/updates/6782_world_scriptnames.sql +++ b/sql/updates/6782_world_scriptnames.sql @@ -1,2 +1 @@ UPDATE `creature_template` SET `ScriptName`='npc_risen_ghoul' WHERE `entry` IN (35545, 35564); - diff --git a/sql/updates/6792_world_spell_proc_event.sql b/sql/updates/6792_world_spell_proc_event.sql index feb0aac514b..b4c82e0f6ae 100644 --- a/sql/updates/6792_world_spell_proc_event.sql +++ b/sql/updates/6792_world_spell_proc_event.sql @@ -1 +1 @@ -UPDATE spell_proc_event SET SpellFamilyMask0 = 0x04000000, SpellFamilyMask1 = 0x10000000 WHERE entry IN (49208, 56834, 56835);
\ No newline at end of file +UPDATE spell_proc_event SET SpellFamilyMask0 = 0x04000000, SpellFamilyMask1 = 0x10000000 WHERE entry IN (49208, 56834, 56835); diff --git a/sql/updates/6795_world_creature_template.sql b/sql/updates/6795_world_creature_template.sql index f8b302a7e7d..f25af34eb68 100644 --- a/sql/updates/6795_world_creature_template.sql +++ b/sql/updates/6795_world_creature_template.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `mindmg` = '97', `maxdmg` = '195', `attackpower` = '35', `minrangedmg` = '72', `maxrangedmg` = '157' WHERE `entry` = 28017;
\ No newline at end of file +UPDATE `creature_template` SET `mindmg` = '97', `maxdmg` = '195', `attackpower` = '35', `minrangedmg` = '72', `maxrangedmg` = '157' WHERE `entry` = 28017; diff --git a/sql/updates/6799_world_spell_proc_event.sql b/sql/updates/6799_world_spell_proc_event.sql index ba127dbf22b..487099eb68b 100644 --- a/sql/updates/6799_world_spell_proc_event.sql +++ b/sql/updates/6799_world_spell_proc_event.sql @@ -1 +1 @@ -UPDATE spell_proc_event SET SchoolMask = 4, spellFamilyMask1 = 200776, spellFamilyMask0 = 146800663 WHERE entry = 11129;
\ No newline at end of file +UPDATE spell_proc_event SET SchoolMask = 4, spellFamilyMask1 = 200776, spellFamilyMask0 = 146800663 WHERE entry = 11129; diff --git a/sql/updates/6840_world_spell_proc_event.sql b/sql/updates/6840_world_spell_proc_event.sql index 7711683545f..76f8cfc0efd 100644 --- a/sql/updates/6840_world_spell_proc_event.sql +++ b/sql/updates/6840_world_spell_proc_event.sql @@ -2,4 +2,4 @@ -- Change max procs per minute (ppm) to be read from the dbc UPDATE spell_proc_event SET ppmRate = 0 -WHERE entry = 20375;
\ No newline at end of file +WHERE entry = 20375; diff --git a/sql/updates/6857_world_scriptnames.sql b/sql/updates/6857_world_scriptnames.sql index c24c640367d..23eaf24b35c 100644 --- a/sql/updates/6857_world_scriptnames.sql +++ b/sql/updates/6857_world_scriptnames.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName` = 'valiant_challenge' WHERE `entry` = 33518;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'valiant_challenge' WHERE `entry` = 33518; diff --git a/sql/updates/6877_world_script_waypoints.sql b/sql/updates/6877_world_script_waypoints.sql index 3e86967627d..428a5312f68 100644 --- a/sql/updates/6877_world_script_waypoints.sql +++ b/sql/updates/6877_world_script_waypoints.sql @@ -115,4 +115,3 @@ INSERT INTO `script_waypoint` VALUES (349,113,-9264.73,-2292.92,70.0089,0,''), (349,114,-9272.24,-2293.79,68.6096,0,''), (349,115,-9277.03,-2295.98,68.1135,10000,''); - diff --git a/sql/updates/6877_world_scriptnames.sql b/sql/updates/6877_world_scriptnames.sql index 6b665d35a57..8c57960b4b7 100644 --- a/sql/updates/6877_world_scriptnames.sql +++ b/sql/updates/6877_world_scriptnames.sql @@ -1,2 +1 @@ UPDATE `creature_template` SET `ScriptName`='npc_corporal_keeshan' WHERE `entry`=349; - diff --git a/sql/updates/6881_world_spell_proc_event.sql b/sql/updates/6881_world_spell_proc_event.sql index b31464804e0..f78a9735e9e 100644 --- a/sql/updates/6881_world_spell_proc_event.sql +++ b/sql/updates/6881_world_spell_proc_event.sql @@ -1 +1 @@ -UPDATE `spell_proc_event` SET procFlags=procFlags|4 WHERE `entry` in (53486,53488); -- Fix Art of War to only proc from Critical Hits
\ No newline at end of file +UPDATE `spell_proc_event` SET procFlags=procFlags|4 WHERE `entry` in (53486,53488); -- Fix Art of War to only proc from Critical Hits diff --git a/sql/updates/6898_world_spell_proc_event.sql b/sql/updates/6898_world_spell_proc_event.sql index 4751b9d29b4..bad7690badc 100644 --- a/sql/updates/6898_world_spell_proc_event.sql +++ b/sql/updates/6898_world_spell_proc_event.sql @@ -1,2 +1,2 @@ DELETE FROM spell_proc_event WHERE entry = 58387; -INSERT INTO spell_proc_event VALUES(58387, 0, 4, 16384, 64, 0, 16, 0, 0, 0, 0); -- Glyph of Sunder Armor
\ No newline at end of file +INSERT INTO spell_proc_event VALUES(58387, 0, 4, 16384, 64, 0, 16, 0, 0, 0, 0); -- Glyph of Sunder Armor diff --git a/sql/updates/6901_world_spell_proc_event.sql b/sql/updates/6901_world_spell_proc_event.sql index fab8748d36a..6d03c08ebf7 100644 --- a/sql/updates/6901_world_spell_proc_event.sql +++ b/sql/updates/6901_world_spell_proc_event.sql @@ -1,2 +1,2 @@ DELETE FROM spell_proc_event WHERE entry = 58375; -INSERT INTO spell_proc_event VALUES(58375, 0, 4, 0, 0x200, 0, 0x10, 0, 0, 0, 0); -- Glyph of Blocking
\ No newline at end of file +INSERT INTO spell_proc_event VALUES(58375, 0, 4, 0, 0x200, 0, 0x10, 0, 0, 0, 0); -- Glyph of Blocking diff --git a/sql/updates/6903_world_spell_proc_event.sql b/sql/updates/6903_world_spell_proc_event.sql index d405bfbb2bf..b15e41ead7d 100644 --- a/sql/updates/6903_world_spell_proc_event.sql +++ b/sql/updates/6903_world_spell_proc_event.sql @@ -1 +1 @@ -UPDATE spell_proc_event SET customChance = 100 WHERE entry = 33757;
\ No newline at end of file +UPDATE spell_proc_event SET customChance = 100 WHERE entry = 33757; diff --git a/sql/updates/6915_world_spell_proc_event.sql b/sql/updates/6915_world_spell_proc_event.sql index 5ef9121cc44..ed974e92fb2 100644 --- a/sql/updates/6915_world_spell_proc_event.sql +++ b/sql/updates/6915_world_spell_proc_event.sql @@ -1 +1 @@ -UPDATE spell_proc_event SET spellFamilyMask0 = spellFamilyMask0 | 0x100, customChance = 100 WHERE entry IN (16198, 16180, 16196);
\ No newline at end of file +UPDATE spell_proc_event SET spellFamilyMask0 = spellFamilyMask0 | 0x100, customChance = 100 WHERE entry IN (16198, 16180, 16196); |