From 007461b6d8112a36b792aef990e05a94c192637d Mon Sep 17 00:00:00 2001 From: Gacko Date: Thu, 27 Dec 2012 22:11:25 +0100 Subject: DB/Quest: The Shadow's Vault questline. Thx @Exodius --- .../world/2012_12_27_00_world_the_shadows_vault.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/2012_12_27_00_world_the_shadows_vault.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_27_00_world_the_shadows_vault.sql b/sql/updates/world/2012_12_27_00_world_the_shadows_vault.sql new file mode 100644 index 00000000000..96d176d6d1b --- /dev/null +++ b/sql/updates/world/2012_12_27_00_world_the_shadows_vault.sql @@ -0,0 +1,18 @@ +-- If He Cannot Be Turned (12896 + 12897) +UPDATE `quest_template` SET `PrevQuestId`=12893 WHERE `Id` IN (12896,12897); +-- Get the Key (12949) +UPDATE `quest_template` SET `PrevQuestId`=12939 WHERE `Id`=12949; +-- Leave Our Mark (12995) +UPDATE `quest_template` SET `PrevQuestId`=13084 WHERE `Id`=12995; +-- Vandalizing Jotunheim (13084) / Crush Dem Vrykuls! (12992) +UPDATE `quest_template` SET `NextQuestId`=13085,`ExclusiveGroup`=-13085 WHERE `Id` IN (13084,12992); +-- Intelligence Gathering (12838) / From Their Corpses, Rise! (12813) +UPDATE `quest_template` SET `PrevQuestId`=12807 WHERE `Id` IN (12838,12813); +-- No Fly Zone (12815) +UPDATE `quest_template` SET `PrevQuestId`=12814 WHERE `Id`=12815; +-- Eliminate the Competition (12955) +UPDATE `quest_template` SET `PrevQuestId`=12938 WHERE `Id`=12955; +-- Deep in the Bowels of The Underhalls (13042) +UPDATE `quest_template` SET `PrevQuestId`=12999 WHERE `Id`=13042; +-- Battle at Valhalas: Fallen Heroes (13214) +UPDATE `quest_template` SET `PrevQuestId`=13213 WHERE `Id`=13214; -- cgit v1.2.3 From a29ec679aed4bc186f70cd3bba1a07226f5de39f Mon Sep 17 00:00:00 2001 From: Gacko Date: Thu, 27 Dec 2012 22:15:30 +0100 Subject: Rename SQL --- .../world/2012_12_27_00_world_the_shadows_vault.sql | 18 ------------------ .../world/2012_12_27_04_world_the_shadows_vault.sql | 18 ++++++++++++++++++ 2 files changed, 18 insertions(+), 18 deletions(-) delete mode 100644 sql/updates/world/2012_12_27_00_world_the_shadows_vault.sql create mode 100644 sql/updates/world/2012_12_27_04_world_the_shadows_vault.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_27_00_world_the_shadows_vault.sql b/sql/updates/world/2012_12_27_00_world_the_shadows_vault.sql deleted file mode 100644 index 96d176d6d1b..00000000000 --- a/sql/updates/world/2012_12_27_00_world_the_shadows_vault.sql +++ /dev/null @@ -1,18 +0,0 @@ --- If He Cannot Be Turned (12896 + 12897) -UPDATE `quest_template` SET `PrevQuestId`=12893 WHERE `Id` IN (12896,12897); --- Get the Key (12949) -UPDATE `quest_template` SET `PrevQuestId`=12939 WHERE `Id`=12949; --- Leave Our Mark (12995) -UPDATE `quest_template` SET `PrevQuestId`=13084 WHERE `Id`=12995; --- Vandalizing Jotunheim (13084) / Crush Dem Vrykuls! (12992) -UPDATE `quest_template` SET `NextQuestId`=13085,`ExclusiveGroup`=-13085 WHERE `Id` IN (13084,12992); --- Intelligence Gathering (12838) / From Their Corpses, Rise! (12813) -UPDATE `quest_template` SET `PrevQuestId`=12807 WHERE `Id` IN (12838,12813); --- No Fly Zone (12815) -UPDATE `quest_template` SET `PrevQuestId`=12814 WHERE `Id`=12815; --- Eliminate the Competition (12955) -UPDATE `quest_template` SET `PrevQuestId`=12938 WHERE `Id`=12955; --- Deep in the Bowels of The Underhalls (13042) -UPDATE `quest_template` SET `PrevQuestId`=12999 WHERE `Id`=13042; --- Battle at Valhalas: Fallen Heroes (13214) -UPDATE `quest_template` SET `PrevQuestId`=13213 WHERE `Id`=13214; diff --git a/sql/updates/world/2012_12_27_04_world_the_shadows_vault.sql b/sql/updates/world/2012_12_27_04_world_the_shadows_vault.sql new file mode 100644 index 00000000000..96d176d6d1b --- /dev/null +++ b/sql/updates/world/2012_12_27_04_world_the_shadows_vault.sql @@ -0,0 +1,18 @@ +-- If He Cannot Be Turned (12896 + 12897) +UPDATE `quest_template` SET `PrevQuestId`=12893 WHERE `Id` IN (12896,12897); +-- Get the Key (12949) +UPDATE `quest_template` SET `PrevQuestId`=12939 WHERE `Id`=12949; +-- Leave Our Mark (12995) +UPDATE `quest_template` SET `PrevQuestId`=13084 WHERE `Id`=12995; +-- Vandalizing Jotunheim (13084) / Crush Dem Vrykuls! (12992) +UPDATE `quest_template` SET `NextQuestId`=13085,`ExclusiveGroup`=-13085 WHERE `Id` IN (13084,12992); +-- Intelligence Gathering (12838) / From Their Corpses, Rise! (12813) +UPDATE `quest_template` SET `PrevQuestId`=12807 WHERE `Id` IN (12838,12813); +-- No Fly Zone (12815) +UPDATE `quest_template` SET `PrevQuestId`=12814 WHERE `Id`=12815; +-- Eliminate the Competition (12955) +UPDATE `quest_template` SET `PrevQuestId`=12938 WHERE `Id`=12955; +-- Deep in the Bowels of The Underhalls (13042) +UPDATE `quest_template` SET `PrevQuestId`=12999 WHERE `Id`=13042; +-- Battle at Valhalas: Fallen Heroes (13214) +UPDATE `quest_template` SET `PrevQuestId`=13213 WHERE `Id`=13214; -- cgit v1.2.3 From 8272affe92fce922ffc898930bcc8d1ce8476bf3 Mon Sep 17 00:00:00 2001 From: secharles Date: Fri, 28 Dec 2012 01:05:30 +0000 Subject: Script/Commands: New command: lookup spell id #spellid Command to allow to know spell names based on id Example: lookup spell id 686: 686 - [Shadow Bolt rank 1 esES] [know] Closes #8800 Signed-off-by: Nay --- sql/updates/world/2012_12_28_00_world_command.sql | 3 + src/server/scripts/Commands/cs_lookup.cpp | 99 ++++++++++++++++++++++- 2 files changed, 101 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/2012_12_28_00_world_command.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_28_00_world_command.sql b/sql/updates/world/2012_12_28_00_world_command.sql new file mode 100644 index 00000000000..6de970d3b81 --- /dev/null +++ b/sql/updates/world/2012_12_28_00_world_command.sql @@ -0,0 +1,3 @@ +DELETE FROM `command` WHERE `name` LIKE 'lookup spell id'; +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('lookup spell id', '3', 'Syntax: .lookup spell id #spellid\n\nLooks up a spell by #spellid, and returns the match with its spell name.'); diff --git a/src/server/scripts/Commands/cs_lookup.cpp b/src/server/scripts/Commands/cs_lookup.cpp index c265cd1faa5..13ee91884d0 100644 --- a/src/server/scripts/Commands/cs_lookup.cpp +++ b/src/server/scripts/Commands/cs_lookup.cpp @@ -46,6 +46,14 @@ public: { "email", SEC_GAMEMASTER, true, &HandleLookupPlayerEmailCommand, "", NULL }, { NULL, 0, false, NULL, "", NULL } }; + + static ChatCommand lookupSpellCommandTable[] = + { + { "id", SEC_ADMINISTRATOR, true, &HandleLookupSpellIdCommand, "", NULL }, + { "", SEC_ADMINISTRATOR, true, &HandleLookupSpellCommand, "", NULL }, + { NULL, 0, false, NULL, "", NULL } + }; + static ChatCommand lookupCommandTable[] = { { "area", SEC_MODERATOR, true, &HandleLookupAreaCommand, "", NULL }, @@ -58,13 +66,14 @@ public: { "quest", SEC_ADMINISTRATOR, true, &HandleLookupQuestCommand, "", NULL }, { "player", SEC_GAMEMASTER, true, NULL, "", lookupPlayerCommandTable }, { "skill", SEC_ADMINISTRATOR, true, &HandleLookupSkillCommand, "", NULL }, - { "spell", SEC_ADMINISTRATOR, true, &HandleLookupSpellCommand, "", NULL }, + { "spell", SEC_ADMINISTRATOR, true, NULL, "", lookupSpellCommandTable }, { "taxinode", SEC_ADMINISTRATOR, true, &HandleLookupTaxiNodeCommand, "", NULL }, { "tele", SEC_MODERATOR, true, &HandleLookupTeleCommand, "", NULL }, { "title", SEC_GAMEMASTER, true, &HandleLookupTitleCommand, "", NULL }, { "map", SEC_ADMINISTRATOR, true, &HandleLookupMapCommand, "", NULL }, { NULL, 0, false, NULL, "", NULL } }; + static ChatCommand commandTable[] = { { "lookup", SEC_ADMINISTRATOR, true, NULL, "", lookupCommandTable }, @@ -943,6 +952,94 @@ public: return true; } + static bool HandleLookupSpellIdCommand(ChatHandler* handler, char const* args) + { + if (!*args) + return false; + + // can be NULL at console call + Player* target = handler->getSelectedPlayer(); + + uint32 id = atoi((char*)args); + + bool found = false; + uint32 count = 0; + uint32 maxResults = 1; + + SpellInfo const* spellInfo = sSpellMgr->GetSpellInfo(id); + if (spellInfo) + { + int locale = handler->GetSessionDbcLocale(); + std::string name = spellInfo->SpellName[locale]; + if (name.empty()) + { + handler->SendSysMessage(LANG_COMMAND_NOSPELLFOUND); + return true; + } + + if (locale < TOTAL_LOCALES) + { + if (maxResults && count++ == maxResults) + { + handler->PSendSysMessage(LANG_COMMAND_LOOKUP_MAX_RESULTS, maxResults); + return true; + } + + bool known = target && target->HasSpell(id); + bool learn = (spellInfo->Effects[0].Effect == SPELL_EFFECT_LEARN_SPELL); + + SpellInfo const* learnSpellInfo = sSpellMgr->GetSpellInfo(spellInfo->Effects[0].TriggerSpell); + + uint32 talentCost = GetTalentSpellCost(id); + + bool talent = (talentCost > 0); + bool passive = spellInfo->IsPassive(); + bool active = target && target->HasAura(id); + + // unit32 used to prevent interpreting uint8 as char at output + // find rank of learned spell for learning spell, or talent rank + uint32 rank = talentCost ? talentCost : learn && learnSpellInfo ? learnSpellInfo->GetRank() : spellInfo->GetRank(); + + // send spell in "id - [name, rank N] [talent] [passive] [learn] [known]" format + std::ostringstream ss; + if (handler->GetSession()) + ss << id << " - |cffffffff|Hspell:" << id << "|h[" << name; + else + ss << id << " - " << name; + + // include rank in link name + if (rank) + ss << handler->GetTrinityString(LANG_SPELL_RANK) << rank; + + if (handler->GetSession()) + ss << ' ' << localeNames[locale] << "]|h|r"; + else + ss << ' ' << localeNames[locale]; + + if (talent) + ss << handler->GetTrinityString(LANG_TALENT); + if (passive) + ss << handler->GetTrinityString(LANG_PASSIVE); + if (learn) + ss << handler->GetTrinityString(LANG_LEARN); + if (known) + ss << handler->GetTrinityString(LANG_KNOWN); + if (active) + ss << handler->GetTrinityString(LANG_ACTIVE); + + handler->SendSysMessage(ss.str().c_str()); + + if (!found) + found = true; + } + } + + if (!found) + handler->SendSysMessage(LANG_COMMAND_NOSPELLFOUND); + + return true; + } + static bool HandleLookupTaxiNodeCommand(ChatHandler* handler, const char * args) { if (!*args) -- cgit v1.2.3 From 718313f1b8aeb9d1b0ef9776387a68550aae9188 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Fri, 28 Dec 2012 16:11:04 +0100 Subject: DB/Startups: apparently we had some creatures with wrong movementtype... --- sql/updates/world/2012_12_28_01_world_misc.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2012_12_28_01_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_28_01_world_misc.sql b/sql/updates/world/2012_12_28_01_world_misc.sql new file mode 100644 index 00000000000..44501390d9e --- /dev/null +++ b/sql/updates/world/2012_12_28_01_world_misc.sql @@ -0,0 +1,2 @@ +-- fix startups +UPDATE `creature` SET `MovementType`=0 WHERE `id`=3939 AND `guid` BETWEEN 48823 AND 45831; -- cgit v1.2.3 From 52f7a7b224151f67320e3e069816ba66494a6b1b Mon Sep 17 00:00:00 2001 From: nelgalno Date: Fri, 28 Dec 2012 16:17:20 +0100 Subject: DB/Quest: add some SAI for The Moment of Truth (10201) Closes #1108 --- sql/updates/world/2012_12_28_02_world_sai.sql | 32 +++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 sql/updates/world/2012_12_28_02_world_sai.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_28_02_world_sai.sql b/sql/updates/world/2012_12_28_02_world_sai.sql new file mode 100644 index 00000000000..7a518449fde --- /dev/null +++ b/sql/updates/world/2012_12_28_02_world_sai.sql @@ -0,0 +1,32 @@ +-- And Now, the Moment of Truth (10201) quest fix +SET @ENTRY := 19606; +-- texts +DELETE FROM `creature_ai_texts` WHERE `entry` IN (-247,-246,-245,-244); +DELETE FROM `creature_text` WHERE `entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(@ENTRY,0,0,"Someone come read this wanted poster to Grek. Grek can't read.",12,0,100,18,0,6941,"Grek1"), +(@ENTRY,1,0,"Grek get a drink.",12,0,100,7,0,0,"Grek2"), +(@ENTRY,2,0,"Grek try!",12,0,100,5,0,0,"Grek - Quest1"), +(@ENTRY,3,0,"This oil no good for Grek! What Grek look like to you, some weakling in robes?",12,0,100,6,0,0,"Grek - Quest2"); +-- gossips +UPDATE `creature_template` SET `gossip_menu_id` = 7999 WHERE `entry` = @ENTRY; -- YTDB value (should work fine until someone can sniff/verify) +DELETE FROM `gossip_menu` WHERE `entry`=7999 AND `text_id`=9853; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7999,9853); -- YTDB value (should work fine until someone can sniff/verify) +DELETE FROM `gossip_menu_option` WHERE `menu_id`=7999; +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES +(7999,0,0,"Grek, will you try out this new weapon oil Rakoria made?",1,1,0,0,0,0,''); -- YTDB value (should work fine until someone can sniff/verify) +-- SAI +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` = @ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,120000,120000,120000,120000,1,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,"Grek - OOC - Say Grek1"), +(@ENTRY,0,1,0,1,0,100,0,420000,420000,420000,420000,1,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,"Grek - OOC - Say Grek2"), +(@ENTRY,0,2,3,62,0,100,0,7999,0,0,0,1,2,3000,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,"Grek - On gossip select - Say Quest1"), +(@ENTRY,0,3,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,"Grek - Link - Close gossip"), +(@ENTRY,0,4,5,52,0,100,0,2,@ENTRY,0,0,1,3,10000,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,"Grek - On text_over - Say Quest2"), +(@ENTRY,0,5,0,61,0,100,0,0,0,0,0,33,@ENTRY,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,"Grek - Link - Give quest credit"); +-- conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=7999 AND `SourceEntry`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,7999,0,0,0,9,0,10201,0,0,0,0,'',"Display gossip only if quest taken"); -- cgit v1.2.3 From 4065b17c94859a7e7e312c0db621d9990095201e Mon Sep 17 00:00:00 2001 From: Trista Date: Fri, 28 Dec 2012 16:21:29 +0100 Subject: DB/Quest: remove deprecated version of Ally of the Netherwing Closes #2841 --- sql/updates/world/2012_12_28_03_world_disables.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/2012_12_28_03_world_disables.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_28_03_world_disables.sql b/sql/updates/world/2012_12_28_03_world_disables.sql new file mode 100644 index 00000000000..017e3aea8c1 --- /dev/null +++ b/sql/updates/world/2012_12_28_03_world_disables.sql @@ -0,0 +1,3 @@ +-- Remove deprecated older version of "Ally of the Netherwing" +DELETE FROM `disables` WHERE `entry`=10871 AND `sourceType`=1; +INSERT INTO `disables` (`sourceType`,`entry`,`comment`) VALUES (1,10871, 'Deprecated quest - Ally of the Netherwing (first version - when it was for alliance only, reworked after 3.3.0)'); -- cgit v1.2.3