From a55f00a2ad0ab094a0c97652e7a05f9c8553547a Mon Sep 17 00:00:00 2001 From: Nay Date: Sun, 12 Aug 2012 04:20:58 +0200 Subject: Update sql/base/auth_database.sql --- sql/base/auth_database.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'sql') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 14aaa4658e9..a052a74c837 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -143,6 +143,7 @@ CREATE TABLE `logs` ( `time` int(10) unsigned NOT NULL, `realm` int(10) unsigned NOT NULL, `type` tinyint(3) unsigned NOT NULL, + `level` tinyint(3) unsigned NOT NULL DEFAULT '0', `string` text CHARACTER SET latin1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- cgit v1.2.3 From da229008bb1e9c1c548cdc0052b978a1394a53d2 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sun, 12 Aug 2012 13:03:27 +0200 Subject: Scripts/The Culling of Stratholme: Fix quest credit for Mal'Ganis --- sql/updates/world/2012_08_12_00_world_conditions.sql | 3 +++ .../Kalimdor/CavernsOfTime/CullingOfStratholme/boss_mal_ganis.cpp | 5 +++-- 2 files changed, 6 insertions(+), 2 deletions(-) create mode 100644 sql/updates/world/2012_08_12_00_world_conditions.sql (limited to 'sql') diff --git a/sql/updates/world/2012_08_12_00_world_conditions.sql b/sql/updates/world/2012_08_12_00_world_conditions.sql new file mode 100644 index 00000000000..6e1fd0ac1db --- /dev/null +++ b/sql/updates/world/2012_08_12_00_world_conditions.sql @@ -0,0 +1,3 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=58124; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,58124,0,0,32,0,0x90,0,0,0,0,'','Mal''Ganis Kill Credit - Player target'); diff --git a/src/server/scripts/Kalimdor/CavernsOfTime/CullingOfStratholme/boss_mal_ganis.cpp b/src/server/scripts/Kalimdor/CavernsOfTime/CullingOfStratholme/boss_mal_ganis.cpp index d4359a100b4..88b2a766671 100644 --- a/src/server/scripts/Kalimdor/CavernsOfTime/CullingOfStratholme/boss_mal_ganis.cpp +++ b/src/server/scripts/Kalimdor/CavernsOfTime/CullingOfStratholme/boss_mal_ganis.cpp @@ -36,6 +36,7 @@ enum Spells SPELL_SLEEP = 52721, //Puts an enemy to sleep for up to 10 sec. Any damage caused will awaken the target. H_SPELL_SLEEP = 58849, SPELL_VAMPIRIC_TOUCH = 52723, //Heals the caster for half the damage dealt by a melee attack. + SPELL_MAL_GANIS_KILL_CREDIT = 58124, // Quest credit SPELL_KILL_CREDIT = 58630 // Non-existing spell as encounter credit, created in spell_dbc }; @@ -238,9 +239,9 @@ public: if (instance) { instance->SetData(DATA_MAL_GANIS_EVENT, DONE); - + DoCastAOE(SPELL_MAL_GANIS_KILL_CREDIT); // give achievement credit and LFG rewards to players. criteria use spell 58630 which doesn't exist, but it was created in spell_dbc - DoCast(me, SPELL_KILL_CREDIT); + DoCastAOE(SPELL_KILL_CREDIT); } } -- cgit v1.2.3 From bd37e73fdf61bae823bdc174b261f6f185ca0b12 Mon Sep 17 00:00:00 2001 From: Nay Date: Sun, 12 Aug 2012 17:19:47 +0100 Subject: SQL: Rename 2 PR'ed SQL files --- sql/updates/world/2012_02_02_01_world_spell_script_names.sql | 3 --- sql/updates/world/2012_05_15_00_world_spell_script_names.sql | 3 --- sql/updates/world/2012_08_12_01_world_spell_script_names.sql | 3 +++ sql/updates/world/2012_08_12_02_world_spell_script_names.sql | 3 +++ 4 files changed, 6 insertions(+), 6 deletions(-) delete mode 100644 sql/updates/world/2012_02_02_01_world_spell_script_names.sql delete mode 100644 sql/updates/world/2012_05_15_00_world_spell_script_names.sql create mode 100644 sql/updates/world/2012_08_12_01_world_spell_script_names.sql create mode 100644 sql/updates/world/2012_08_12_02_world_spell_script_names.sql (limited to 'sql') diff --git a/sql/updates/world/2012_02_02_01_world_spell_script_names.sql b/sql/updates/world/2012_02_02_01_world_spell_script_names.sql deleted file mode 100644 index 15ca9c43cc5..00000000000 --- a/sql/updates/world/2012_02_02_01_world_spell_script_names.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=-32379; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(-32379,'spell_pri_shadow_word_death'); diff --git a/sql/updates/world/2012_05_15_00_world_spell_script_names.sql b/sql/updates/world/2012_05_15_00_world_spell_script_names.sql deleted file mode 100644 index 980aceff519..00000000000 --- a/sql/updates/world/2012_05_15_00_world_spell_script_names.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=36554; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(36554,'spell_rog_shadowstep'); diff --git a/sql/updates/world/2012_08_12_01_world_spell_script_names.sql b/sql/updates/world/2012_08_12_01_world_spell_script_names.sql new file mode 100644 index 00000000000..980aceff519 --- /dev/null +++ b/sql/updates/world/2012_08_12_01_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=36554; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(36554,'spell_rog_shadowstep'); diff --git a/sql/updates/world/2012_08_12_02_world_spell_script_names.sql b/sql/updates/world/2012_08_12_02_world_spell_script_names.sql new file mode 100644 index 00000000000..15ca9c43cc5 --- /dev/null +++ b/sql/updates/world/2012_08_12_02_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-32379; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(-32379,'spell_pri_shadow_word_death'); -- cgit v1.2.3