Sebagai langkah awal demi kemajuan server kita bersama dan proses fixing bisa berjalan lebih cepat mengingat keterbatasan waktu kami sebagai GM dan sesuai dengan thread http://forum.indogamers.com/showthread.php?t=529413 maka kami mengundang siapapun yang mempunyai kemampuan scripting untuk berpartisipasi.
Thread ini hanya berisi FIX dari sisi Script mengenai Quest, spell, achiev, dsb dan apabila setelah diperiksa Script berjalan dengan baik maka akan segera kami apply ke server. Oleh karena itu, dengan bantuan kita semua proses fixing dapat bekerja lebih cepat demi kenyamanan kita bersama.
============================================= This is Open
for Everyone to Join
=============================================
Spoiler untuk Format Penulisan :
Nama Error (spell/Quest/achiev dsb):
Referensi:
Kondisi:
Code:
Silakan berpartisipasi dan gunakan thread ini sebaik-baiknya demi kemajuan server kita bersama. Posting diluar ketentuan akan saya delete. Thread ini akan kami awasi sesering mungkin..
Terima Kasih
04-11-12, 05:22
Anz69
Ulduar Achievements
Boss yang berfungsi dengan baik dengan achievement penuh yaitu Boss Razorscale & Auriaya
Berikut beberapa hasil survey dan searching buat script Ulduar
Referensi :Here
General Script before Boss Script:
Ulduar.sql
Spoiler untuk Ulduar.sql :
Code:
-- Ignis
UPDATE `creature_template` SET `mechanic_immune_mask` = 650854235, `flags_extra` = 9, `vehicleId` = 342 WHERE `entry` = 33118;
UPDATE `creature_template` SET `mechanic_immune_mask` = 650854235, `flags_extra` = 9 WHERE `entry` = 33190;
DELETE FROM creature WHERE id = 33121;
DELETE FROM conditions WHERE SourceEntry = 62343;
INSERT INTO `conditions` VALUES
('13','0','62343','0','18','1','33121','0','0','',NULL);
-- Razorscale
UPDATE `creature_template` SET `speed_run` = 0.00001 WHERE `entry` IN (34188, 34189);
-- XT-002
UPDATE `creature_template` SET `VehicleId` = 335 WHERE `entry` = 33293;
-- Assembly of Iron
UPDATE `creature_template` SET `mechanic_immune_mask` = 650854235 WHERE `entry` IN (32867, 32927, 33693, 33692);
UPDATE `creature_template` SET `mechanic_immune_mask` = 617299803 WHERE `entry` IN (32857, 33694);
UPDATE `creature_template` SET `ScriptName` = 'npc_rune_of_power' WHERE `entry` = 33705;
UPDATE `creature_template` SET `difficulty_entry_1` = 33691, `ScriptName` = 'npc_rune_of_summoning' WHERE `entry` = 33051;
UPDATE `creature_template` SET `ScriptName` = 'npc_lightning_elemental' WHERE `entry` = 32958;
-- Runemaster Molgeim
UPDATE `creature_model_info` SET `bounding_radius` = 0.45, `combat_reach` = 4 WHERE `modelid` = 28381;
-- Steelbreaker
UPDATE `creature_model_info` SET `bounding_radius` = 0.45, `combat_reach` = 8 WHERE `modelid` = 28344;
-- Kologarn
UPDATE `creature_template` SET `baseattacktime` = 1800, `mechanic_immune_mask` = 650854235, `flags_extra` = 1 WHERE `entry` IN (32930, 33909);
UPDATE `creature_model_info` SET `bounding_radius` = 1, `combat_reach` = 15 WHERE `modelid` = 28638;
UPDATE `creature_model_info` SET `bounding_radius` = 0.465, `combat_reach` = 15 WHERE `modelid` = 28821;
-- Left Arm
UPDATE `creature_template` SET `mechanic_immune_mask` = 650854235, `ScriptName` = 'npc_left_arm' WHERE `entry` = 32933;
UPDATE `creature_model_info` SET `bounding_radius` = 0.465, `combat_reach` = 15 WHERE `modelid` = 28821;
-- Right Arm
UPDATE `creature_template` SET `mechanic_immune_mask` = 650854235, `ScriptName` = 'npc_right_arm' WHERE `entry` = 32934;
UPDATE `creature_template` SET `mechanic_immune_mask` = 650854235 WHERE `entry` IN (33910, 33911);
UPDATE `creature_model_info` SET `bounding_radius` = 0.465, `combat_reach` = 15 WHERE `modelid` = 28822;
-- Focused Eyebeam
UPDATE `creature_template` SET `ScriptName` = 'npc_focused_eyebeam' WHERE `entry` IN (33632, 33802);
DELETE FROM conditions WHERE SourceEntry IN (63676, 63702);
INSERT INTO `conditions` VALUES
('13','0','63676','0','18','1','32930','0','0','',"Focused Eyebeam (Kologarn)"),
('13','0','63702','0','18','1','32930','0','0','',"Focused Eyebeam (Kologarn)");
-- Cleanup
DELETE FROM `creature` WHERE `id` IN (33632, 33802, 34297, 32933, 32934, 33809, 33661, 33742);
DELETE FROM vehicle_accessory WHERE entry = 32930;
-- Auriaya
UPDATE `creature_template` SET `baseattacktime` = 1500, `equipment_id` = 2422, `mechanic_immune_mask` = 617299807, `flags_extra` = 1 WHERE `entry` = 33515;
UPDATE `creature_template` SET `baseattacktime` = 1500, `equipment_id` = 2422, `mechanic_immune_mask` = 617299807, `flags_extra` = 1 WHERE `entry` = 34175;
UPDATE `creature_model_info` SET `bounding_radius` = 0.775, `combat_reach` = 5 WHERE `modelid` = 28651;
-- Sanctum Sentry
UPDATE `creature_template` SET `speed_walk` = 1.66667, `mechanic_immune_mask` = 536870912, `flags_extra` = 1, `ScriptName` = 'npc_sanctum_sentry' WHERE `entry` = 34014;
UPDATE `creature_template` SET `baseattacktime` = 1500, `speed_walk` = 1.66667, `mechanic_immune_mask` = 536870912, `flags_extra` = 1 WHERE `entry` = 34166;
-- Feral Defender
UPDATE `creature_template` SET `speed_walk` = 2, `dmg_multiplier` = 3.5, `flags_extra` = 1, `ScriptName` = 'npc_feral_defender' WHERE `entry` = 34035;
UPDATE `creature_template` SET `speed_walk` = 2, `dmg_multiplier` = 5, `flags_extra` = 1, `baseattacktime` = 1500 WHERE `entry` = 34171;
UPDATE `creature_template` SET `unit_flags` = 33554432, `ScriptName` = 'npc_seeping_trigger' WHERE `entry` = 34098;
UPDATE `creature_template` SET `unit_flags` = 33554432 WHERE `entry` = 34174;
UPDATE `creature_template` SET `dmg_multiplier` = 1.5, `baseattacktime` = 1500 WHERE `entry` = 34169;
UPDATE `creature_template` SET `ScriptName` = 'npc_feral_defender_trigger' WHERE `entry` = 34096;
-- Mace equip
DELETE FROM `creature_equip_template` WHERE entry = 2422;
INSERT INTO `creature_equip_template` VALUES ('2422','45315','0','0');
-- Cleanup
DELETE FROM `creature` WHERE `id` = 34014;
-- Auriaya movement path
DELETE FROM `creature_addon` WHERE guid = 137496;
INSERT INTO `creature_addon` VALUES ('137496','1033515','0','0','0','0','0');
UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 137496;
DELETE FROM `waypoint_data` WHERE id = 1033515;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_flag`, `action`, `action_chance`, `wpguid`) VALUES
('1033515','1','1968.46','51.75','417.72','0','0','0','100','0'),
('1033515','2','1956.75','49.22','411.35','0','0','0','100','0'),
('1033515','3','1938.90','42.09','411.35','3000','0','0','100','0'),
('1033515','4','1956.75','49.22','411.35','0','0','0','100','0'),
('1033515','5','1968.46','51.75','417.72','0','0','0','100','0'),
('1033515','6','2011.43','44.91','417.72','0','0','0','100','0'),
('1033515','7','2022.65','37.74','411.36','0','0','0','100','0'),
('1033515','8','2046.65','9.61','411.36','0','0','0','100','0'),
('1033515','9','2053.4','-8.65','421.68','0','0','0','100','0'),
('1033515','10','2053.14','-39.8','421.66','0','0','0','100','0'),
('1033515','11','2046.26','-57.96','411.35','0','0','0','100','0'),
('1033515','12','2022.42','-86.39','411.35','0','0','0','100','0'),
('1033515','13','2011.26','-92.95','417.71','0','0','0','100','0'),
('1033515','14','1969.43','-100.02','417.72','0','0','0','100','0'),
('1033515','15','1956.66','-97.4','411.35','0','0','0','100','0'),
('1033515','16','1939.18','-90.90','411.35','3000','0','0','100','0'),
('1033515','17','1956.66','-97.4','411.35','0','0','0','100','0'),
('1033515','18','1969.43','-100.02','417.72','0','0','0','100','0'),
('1033515','19','2011.26','-92.95','417.71','0','0','0','100','0'),
('1033515','20','2022.42','-86.39','411.35','0','0','0','100','0'),
('1033515','21','2046.26','-57.96','411.35','0','0','0','100','0'),
('1033515','22','2053.14','-39.8','421.66','0','0','0','100','0'),
('1033515','23','2053.4','-8.65','421.68','0','0','0','100','0'),
('1033515','24','2046.65','9.61','411.36','0','0','0','100','0'),
('1033515','25','2022.65','37.74','411.36','0','0','0','100','0'),
('1033515','26','2011.43','44.91','417.72','0','0','0','100','0');
-- Hodir
UPDATE `creature_template` SET `mechanic_immune_mask` = 650854239, `flags_extra` = 1, `ScriptName` = 'boss_hodir' WHERE `entry` = 32845;
UPDATE `creature_template` SET `equipment_id` = 1843, `mechanic_immune_mask` = 650854239, `flags_extra` = 1 WHERE `entry` = 32846;
-- Hodir npcs
UPDATE `creature_template` SET `ScriptName` = 'npc_hodir_priest' WHERE `entry` IN (32897, 33326, 32948, 33330);
UPDATE `creature_template` SET `ScriptName` = 'npc_hodir_shaman' WHERE `entry` IN (33328, 32901, 33332, 32950);
UPDATE `creature_template` SET `ScriptName` = 'npc_hodir_druid' WHERE `entry` IN (33325, 32900, 32941, 33333);
UPDATE `creature_template` SET `ScriptName` = 'npc_hodir_mage' WHERE `entry` IN (32893, 33327, 33331, 32946);
UPDATE `creature_template` SET `ScriptName` = 'npc_toasty_fire' WHERE `entry` = 33342;
UPDATE `creature_template` SET `ScriptName` = 'npc_icicle' WHERE `entry` = 33169;
UPDATE `creature_template` SET `ScriptName` = 'npc_icicle_snowdrift' WHERE `entry` = 33173;
UPDATE `creature_template` SET `ScriptName` = 'npc_snowpacked_icicle' WHERE `entry` = 33174;
UPDATE `creature_template` SET `difficulty_entry_1` = 33352, `mechanic_immune_mask` = 612597599, `ScriptName` = 'npc_flash_freeze' WHERE `entry` = 32926;
UPDATE `creature_template` SET `difficulty_entry_1` = 33353, `mechanic_immune_mask` = 612597599, `ScriptName` = 'npc_flash_freeze' WHERE `entry` = 32938;
UPDATE `creature_template` SET `mechanic_immune_mask` = 612597599 WHERE `entry` IN (33352, 33353);
UPDATE `gameobject_template` SET `flags` = 4 WHERE `entry` = 194173;
-- Cleanup
DELETE FROM `creature` WHERE `id` IN (32950, 32941, 32948, 32946, 32938);
UPDATE `creature_template` SET `equipment_id` = 1849 WHERE `entry` = 32885;
UPDATE `creature_template` SET `equipment_id` = 1850 WHERE `entry` = 32908;
UPDATE `creature_template` SET `equipment_id` = 1849 WHERE `entry` = 32885;
UPDATE `creature_template` SET `equipment_id` = 1850 WHERE `entry` = 32908;
-- Enslaved Fire Elemental
UPDATE `creature_template` SET `spell1` = 38064, `spell2` = 63778, `mechanic_immune_mask` = 33554513, `AIName` = 'SmartAI' WHERE `entry` = 33838;
DELETE FROM `smart_scripts` WHERE (`entryorguid`=33838);
INSERT INTO `smart_scripts` VALUES
(33838, 0, 0, 0, 0, 0, 100, 0, 4000, 8000, 10000, 14000, 11, 38064, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Enslaved Fire Elemental - Cast Blast Wave'),
(33838, 0, 1, 0, 4, 0, 100, 0, 0, 0, 0, 0, 75, 63778, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Enslaved Fire Elemental - Cast Fire Shield on aggro');
-- Boom Bot
UPDATE `creature_template` SET `spell1` = 63801, `AIName` = 'SmartAI' WHERE `entry` = 33836;
UPDATE `creature_template` SET `spell1` = 63801 WHERE `entry` = 34218;
DELETE FROM `smart_scripts` WHERE (`entryorguid`=33836);
INSERT INTO `smart_scripts` VALUES
(33836, 0, 0, 0, 9, 0, 100, 0, 0, 2, 1000, 1000, 11, 63801, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Boom Bot - Explode');
-- Rubble
UPDATE `creature_template` SET `spell1` = 38064, `AIName` = 'SmartAI' WHERE `entry` = 33768;
UPDATE `creature_template` SET `spell1` = 63978 WHERE `entry` = 33908;
DELETE FROM `smart_scripts` WHERE (`entryorguid`=33768);
INSERT INTO `smart_scripts` VALUES
(33768, 0, 0, 0, 0, 0, 100, 2, 4000, 8000, 10000, 12000, 11, 38064, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Rubble - Cast Stone Nova 10'),
(33768, 0, 1, 0, 0, 0, 100, 4, 4000, 8000, 10000, 12000, 11, 63978, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Rubble - Cast Stone Nova 25');
ScriptLoader.cpp , see Ulduar boss line
Spoiler untuk ScriptLoader.cpp :
Code:
/*
* Copyright (C) 2008-2010 TrinityCore <http://www.trinitycore.org/>
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation; either version 2 of the License, or (at your
* option) any later version.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
* more details.
*
* You should have received a copy of the GNU General Public License along
* with this program. If not, see <http://www.gnu.org/licenses/>.
*/
/*
* Copyright (C) 2008-2010 TrinityCore <http://www.trinitycore.org/>
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation; either version 2 of the License, or (at your
* option) any later version.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
* more details.
*
* You should have received a copy of the GNU General Public License along
* with this program. If not, see <http://www.gnu.org/licenses/>.
*/
/* ScriptData
SDName: Assembly of Iron
Author: PrinceCreed
SD%Complete: 100%
SDComment:
EndScriptData */
#include "ScriptPCH.h"
#include "ulduar.h"
enum Spells
{
// Any boss
SPELL_SUPERCHARGE = 61920,
SPELL_BERSERK = 47008, // Hard enrage, don't know the correct ID.
for (uint8 i = 0; i < 3; ++i)
{
uint64 guid = pInstance->GetData64(DATA_STEELBREAKER+i);
if (!guid)
return false;
if (Creature *boss = Unit::GetCreature(*me, guid))
{
if (boss->isAlive())
return false;
}
else
return false;
}
return true;
}
// Avoid killing bosses one to one
void CallBosses(InstanceScript* pInstance, uint32 caller, Unit *who)
{
// Respawn if dead
if (Creature* Steelbreaker = who->GetCreature(*who, pInstance->GetData64(DATA_STEELBREAKER)))
if (Steelbreaker->isDead())
{
Steelbreaker->Respawn(true);
Steelbreaker->GetMotionMaster()->MoveTargetedHome();
}
if (Creature* Brundir = who->GetCreature(*who, pInstance->GetData64(DATA_BRUNDIR)))
if (Brundir->isDead())
{
Brundir->Respawn(true);
Brundir->GetMotionMaster()->MoveTargetedHome();
}
if (Creature* Molgeim = who->GetCreature(*who, pInstance->GetData64(DATA_MOLGEIM)))
if (Molgeim->isDead())
{
Molgeim->Respawn(true);
Molgeim->GetMotionMaster()->MoveTargetedHome();
}
for (uint8 i = 0; i < 3; ++i)
{
if (caller == DATA_STEELBREAKER+i) continue;
uint64 guid = pInstance->GetData64(DATA_STEELBREAKER+i);
if (!guid) return;
if (Creature* m_boss = pInstance->instance->GetCreature(guid))
{
if (m_boss->isAlive())
{
m_boss->AddThreat(who, 100.0f);
m_boss->AI()->AttackStart(who);
}
}
}
}
class boss_steelbreaker : public CreatureScript
{
public:
boss_steelbreaker() : CreatureScript("boss_steelbreaker") { }
CreatureAI* GetAI(Creature* pCreature) const
{
return new boss_steelbreakerAI (pCreature);
}
if (Creature* Brundir = me->GetCreature(*me, pInstance->GetData64(DATA_BRUNDIR)))
if (Brundir->isAlive())
Brundir->AI()->DoAction(ACTION_BRUNDIR);
if (Creature* Steelbreaker = me->GetCreature(*me, pInstance->GetData64(DATA_STEELBREAKER)))
if (Steelbreaker->isAlive())
Steelbreaker->AI()->DoAction(ACTION_STEELBREAKER);
}
if (IsEncounterComplete(pInstance, me) && pInstance)
{
pInstance->SetBossState(BOSS_ASSEMBLY, DONE);
pInstance->DoCompleteAchievement(ACHIEVEMENT_CHOOSE_BRUNDIR);
pInstance->DoUpdateAchievementCriteria(ACHIEVEMENT_CRITERIA_TYPE_BE_SPELL_TARGET, 65195);
if (me->GetPositionZ() > 428)
me->GetMotionMaster()->MoveFall(427.28f);
}
else me->SetLootRecipient(NULL);
if (Creature* Molgeim = me->GetCreature(*me, pInstance->GetData64(DATA_MOLGEIM)))
if (Molgeim->isAlive())
Molgeim->AI()->DoAction(ACTION_MOLGEIM);
if (Creature* Steelbreaker = me->GetCreature(*me, pInstance->GetData64(DATA_STEELBREAKER)))
if (Steelbreaker->isAlive())
Steelbreaker->AI()->DoAction(ACTION_STEELBREAKER);
}
void MovePos()
{
switch(Position)
{
case 0:
me->GetMotionMaster()->MovePoint(0, 1587.28f, 97.030f, 427.28f);
break;
case 1:
me->GetMotionMaster()->MovePoint(0, 1587.18f, 121.03f, 427.28f);
break;
case 2:
me->GetMotionMaster()->MovePoint(0, 1587.34f, 142.58f, 427.28f);
break;
case 3:
me->GetMotionMaster()->MovePoint(0, 1587.18f, 121.03f, 427.28f);
break;
}
Position++;
if (Position > 3)
{
Position = 0;
}
}
};
};
void AddSC_boss_assembly_of_iron()
{
new boss_steelbreaker();
new boss_runemaster_molgeim();
new boss_stormcaller_brundir();
new npc_lightning_elemental();
new npc_rune_of_summoning();
new npc_rune_of_power();
}
/*
* Copyright (C) 2008-2010 TrinityCore <http://www.trinitycore.org/>
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation; either version 2 of the License, or (at your
* option) any later version.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
* more details.
*
* You should have received a copy of the GNU General Public License along
* with this program. If not, see <http://www.gnu.org/licenses/>.
*/
#define EMOTE_TYMPANIC "XT-002 Deconstructor begins to cause the earth to quake."
#define EMOTE_HEART "XT-002 Deconstructor's heart is exposed and leaking energy."
#define EMOTE_REPAIR "XT-002 Deconstructor consumes a scrap bot to repair himself!"
// Needed if is killed during the Heart-phase
me->RemoveFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE | UNIT_FLAG_NOT_SELECTABLE | UNIT_FLAG_DISABLE_MOVE);
if (instance)
{
// Heartbreaker
if (hardMode)
instance->DoCompleteAchievement(ACHIEVEMENT_HEARTBREAKER);
// Nerf Engineering
if (achievement_nerf)
instance->DoCompleteAchievement(ACHIEVEMENT_NERF_ENG);
}
}
void UpdateAI(const uint32 diff)
{
if (!UpdateVictim())
return;
if (enterHardMode)
{
SetPhaseOne();
enterHardMode = false;
}
// Handles spell casting. These spells only occur during phase 1 and hard mode
if (phase == 1 || hardMode)
{
if (uiSearingLightTimer <= diff)
{
if (Unit* pTarget = SelectUnit(SELECT_TARGET_RANDOM, 0))
{
me->AddAura(RAID_MODE(SPELL_SEARING_LIGHT_10, SPELL_SEARING_LIGHT_25), pTarget);
uiSearingLightTarget = pTarget->GetGUID();
}
uiSpawnLifeSparkTimer = TIMER_SPAWN_LIFE_SPARK;
if (hardMode)
searing_light_active = true;
uiSearingLightTimer = TIMER_SEARING_LIGHT;
} else uiSearingLightTimer -= diff;
void JustDied(Unit* /*victim*/)
{
if (m_pInstance)
if (Creature* pXT002 = me->GetCreature(*me, m_pInstance->GetData64(DATA_XT002)))
if (pXT002->AI())
pXT002->AI()->DoAction(ACTION_ENTER_HARD_MODE);
void AddSC_boss_xt002()
{
new mob_xt002_heart();
new mob_scrapbot();
new mob_pummeller();
new mob_boombot();
new mob_void_zone();
new mob_life_spark();
new boss_xt002();
if (VehicleSeatEntry* vehSeat = const_cast<VehicleSeatEntry*>(sVehicleSeatStore.LookupEntry(3004)))
vehSeat->m_flags |= 0x400;
}
/*
* Copyright (C) 2008-2010 TrinityCore <http://www.trinitycore.org/>
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation; either version 2 of the License, or (at your
* option) any later version.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
* more details.
*
* You should have received a copy of the GNU General Public License along
* with this program. If not, see <http://www.gnu.org/licenses/>.
*/
if (instance)
{
// Kill credit
instance->DoUpdateAchievementCriteria(ACHIEVEMENT_CRITERIA_TYPE_BE_SPELL_TARGET2, 64899);
// Getting Cold in Here
if (!bMoreThanTwoIntenseCold)
instance->DoCompleteAchievement(ACHIEVEMENT_COLD_IN_HERE);
// Cheese the Freeze
if (CheeseTheFreeze)
instance->DoCompleteAchievement(ACHIEVEMENT_CHEESE_THE_FREEZE);
// I Have the Coolest Friends
if (CoolestFriends)
instance->DoCompleteAchievement(ACHIEVEMENT_COOLEST_FRIENDS);
// I Could Say That This Cache Was Rare
if (RareCache)
{
instance->DoCompleteAchievement(ACHIEVEMENT_THIS_CACHE_WAS_RARE);
instance->SetData(DATA_HODIR_RARE_CHEST, GO_STATE_READY);
}
if (DispelTimer < uiDiff)
{
std::list<Player*> players;
Trinity::AnyPlayerInObjectRangeCheck checker(me, 30);
Trinity::PlayerListSearcher<Trinity::AnyPlayerInObjectRangeCheck> searcher(me, players, checker);
me->VisitNearbyWorldObject(30, searcher);
if (!players.empty())
{
for (std::list<Player*>::iterator iter = players.begin(); iter != players.end(); ++iter)
{
if ((*iter)->HasAura(SPELL_FREEZE))
{
DoCast((*iter),SPELL_DISPEL_MAGIC, true);
DispelTimer = urand(25000,30000);
return;
}
}
}
DispelTimer = 5000;
}
else DispelTimer -= uiDiff;
DoSpellAttackIfReady(SPELL_SMITE);
}
void JustDied(Unit* /*victim*/)
{
// I Have the Coolest Friends
if (Creature* pHodir = me->FindNearestCreature(NPC_HODIR,60,true))
pHodir->AI()->DoAction(ACTION_FAILED_COOLEST_FRIENDS);
}
};
};
class npc_hodir_shaman : public CreatureScript
{
public:
npc_hodir_shaman() : CreatureScript("npc_hodir_shaman") { }
CreatureAI* GetAI(Creature* pCreature) const
{
return new npc_hodir_shamanAI (pCreature);
}
void JustDied(Unit* /*victim*/)
{
// I Have the Coolest Friends
if (Creature* pHodir = me->FindNearestCreature(NPC_HODIR,60,true))
pHodir->AI()->DoAction(ACTION_FAILED_COOLEST_FRIENDS);
}
};
};
class npc_hodir_druid : public CreatureScript
{
public:
npc_hodir_druid() : CreatureScript("npc_hodir_druid") { }
CreatureAI* GetAI(Creature* pCreature) const
{
return new npc_hodir_druidAI (pCreature);
}
void JustDied(Unit* /*victim*/)
{
// I Have the Coolest Friends
if (Creature* pHodir = me->FindNearestCreature(NPC_HODIR,60,true))
pHodir->AI()->DoAction(ACTION_FAILED_COOLEST_FRIENDS);
}
};
};
class npc_hodir_mage : public CreatureScript
{
public:
npc_hodir_mage() : CreatureScript("npc_hodir_mage") { }
CreatureAI* GetAI(Creature* pCreature) const
{
return new npc_hodir_mageAI (pCreature);
}
void JustDied(Unit* /*victim*/)
{
// I Have the Coolest Friends
if (Creature* pHodir = me->FindNearestCreature(NPC_HODIR,60,true))
pHodir->AI()->DoAction(ACTION_FAILED_COOLEST_FRIENDS);
}
};
};
class npc_toasty_fire : public CreatureScript
{
public:
npc_toasty_fire() : CreatureScript("npc_toasty_fire") { }
CreatureAI* GetAI(Creature* pCreature) const
{
return new npc_toasty_fireAI (pCreature);
}
void AddSC_boss_hodir()
{
new boss_hodir();
new npc_icicle();
new npc_icicle_snowdrift();
new npc_snowpacked_icicle();
new npc_hodir_priest();
new npc_hodir_shaman();
new npc_hodir_druid();
new npc_hodir_mage();
new npc_toasty_fire();
new npc_flash_freeze();
}
/*
* Copyright (C) 2008-2010 TrinityCore <http://www.trinitycore.org/>
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation; either version 2 of the License, or (at your
* option) any later version.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
* more details.
*
* You should have received a copy of the GNU General Public License along
* with this program. If not, see <http://www.gnu.org/licenses/>.
*/
// Respawn Mini Bosses
for (uint8 i = DATA_RUNIC_COLOSSUS; i <= DATA_RUNE_GIANT; i++)
if (Creature* pMiniBoss = me->GetCreature(*me, instance->GetData64(i)))
pMiniBoss->Respawn(true);
// Spawn Pre-Phase Adds
for (uint8 i = 0; i < 6; i++)
me->SummonCreature(preAddLocations[i].entry,preAddLocations[i].x,preAddLocations[i].y,preAddLocations[i].z,preAddLocations[i].o,TEMPSUMMON_CORPSE_TIMED_DESPAWN,3000);
}
void KilledUnit(Unit * /*victim*/)
{
if (!(rand()%5))
DoScriptText(RAND(SAY_SLAY_1,SAY_SLAY_2), me);
}
void spawnAdd()
{
switch(spawnedAdds)
{
case 0:
for (uint8 n = 0; n < 3; n++)
me->SummonCreature(ARENA_PHASE_ADD[n], Pos[rand()%7], TEMPSUMMON_CORPSE_TIMED_DESPAWN, 3000);
break;
case 1:
for (uint8 n = 0; n < 7; n++)
me->SummonCreature(ARENA_PHASE_ADD[3], Pos[n], TEMPSUMMON_CORPSE_TIMED_DESPAWN, 3000);
break;
}
// Runed Door closed
if (pInstance)
pInstance->SetData(DATA_RUNIC_DOOR, GO_STATE_READY);
// Spawn trashes
summons.DespawnAll();
for (uint8 i = 0; i < 6; i++)
me->SummonCreature(colossusAddLocations[i].entry,colossusAddLocations[i].x,colossusAddLocations[i].y,colossusAddLocations[i].z,colossusAddLocations[i].o,TEMPSUMMON_CORPSE_TIMED_DESPAWN,3000);
}
// Stone Door closed
if (pInstance)
pInstance->SetData(DATA_STONE_DOOR, GO_STATE_READY);
// Spawn trashes
summons.DespawnAll();
for (uint8 i = 0; i < 5; i++)
me->SummonCreature(giantAddLocations[i].entry,giantAddLocations[i].x,giantAddLocations[i].y,giantAddLocations[i].z,giantAddLocations[i].o,TEMPSUMMON_CORPSE_TIMED_DESPAWN,3000);
}
void AddSC_boss_thorim()
{
new boss_thorim();
new npc_thorim_pre_phase();
new npc_thorim_arena_phase();
new npc_runic_colossus();
new npc_ancient_rune_giant();
new npc_sif();
}
/*
* Copyright (C) 2008-2010 TrinityCore <http://www.trinitycore.org/>
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation; either version 2 of the License, or (at your
* option) any later version.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
* more details.
*
* You should have received a copy of the GNU General Public License along
* with this program. If not, see <http://www.gnu.org/licenses/>.
*/
/* ScriptData
SDName: Mimiron
SDAuthor: PrinceCreed
SD%Complete: 95
SDComments: P3Wx2 Laser Barrage not works in phase 4 due to core limits.
EndScriptData */
void UpdateAI(const uint32 diff)
{
if (!UpdateVictim())
return;
if (EnrageTimer<= diff && !Enraged)
{
DoScriptText(SAY_BERSERK, me);
for (uint8 data = DATA_LEVIATHAN_MK_II; data <= DATA_AERIAL_UNIT; ++data)
{
if (Creature *pCreature = me->GetCreature(*me, instance->GetData64(data)))
pCreature->AI()->DoAction(DO_ENTER_ENRAGE);
}
Enraged = true;
}
else EnrageTimer -= diff;
if (MimironHardMode)
{
if (FlameTimer <= diff)
{
for (uint8 i = 0; i < 3; ++i)
if (Unit *pTarget = SelectTarget(SELECT_TARGET_RANDOM, 0, 100, true))
if (Creature* Flame = me->SummonCreature(NPC_FLAME, pTarget->GetPositionX() + irand(-6,6), pTarget->GetPositionY() + irand(-6,6), pTarget->GetPositionZ(), 0, TEMPSUMMON_MANUAL_DESPAWN))
Flame->AI()->AttackStart(pTarget);
FlameTimer = 30000;
}
else FlameTimer -= diff;
}
// All sections need to die within 10 seconds, else they respawn
if (checkBotAlive)
uiBotTimer = 0;
else
{
uiBotTimer += diff;
if (uiBotTimer > 10000)
{
if (Creature *pLeviathan = me->GetCreature(*me, instance->GetData64(DATA_LEVIATHAN_MK_II)))
pLeviathan->AI()->DoAction(DO_LEVIATHAN_ASSEMBLED);
if (Creature *pVX_001 = me->GetCreature(*me, instance->GetData64(DATA_VX_001)))
pVX_001->AI()->DoAction(DO_VX001_ASSEMBLED);
if (Creature *pAerialUnit = me->GetCreature(*me, instance->GetData64(DATA_AERIAL_UNIT)))
pAerialUnit->AI()->DoAction(DO_AERIAL_ASSEMBLED);
checkBotAlive = true;
}
else
{
if (Creature *pLeviathan = me->GetCreature(*me, instance->GetData64(DATA_LEVIATHAN_MK_II)))
if (Creature *pVX_001 = me->GetCreature(*me, instance->GetData64(DATA_VX_001)))
if (Creature *pAerialUnit = me->GetCreature(*me, instance->GetData64(DATA_AERIAL_UNIT)))
if (pLeviathan->getStandState() == UNIT_STAND_STATE_DEAD)
if (pVX_001->getStandState() == UNIT_STAND_STATE_DEAD)
if (pAerialUnit->getStandState() == UNIT_STAND_STATE_DEAD)
{
pLeviathan->DisappearAndDie();
pVX_001->DisappearAndDie();
pAerialUnit->DisappearAndDie();
DespawnCreatures(NPC_ROCKET, 100);
me->Kill(me, false);
checkBotAlive = true;
}
}
}
if (phase == PHASE_INTRO)
{
if (uiPhase_timer <= diff)
{
switch (uiStep)
{
case 1:
if (MimironHardMode)
DoScriptText(SAY_HARDMODE_ON, me);
else
DoScriptText(SAY_AGGRO, me);
JumpToNextStep(10000);
break;
case 2:
if (instance)
{
if (Creature *pLeviathan = me->GetCreature(*me, instance->GetData64(DATA_LEVIATHAN_MK_II)))
me->EnterVehicle(pLeviathan->GetVehicleKit(), 4);
}
JumpToNextStep(2000);
break;
case 3:
me->ChangeSeat(2);
JumpToNextStep(2000);
break;
case 4:
me->ChangeSeat(5);
me->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_STAND);
JumpToNextStep(2500);
break;
case 5:
DoScriptText(SAY_MKII_ACTIVATE, me);
me->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_TALK);
JumpToNextStep(6000);
break;
case 6:
me->ChangeSeat(6);
JumpToNextStep(2000);
break;
case 7:
if (instance)
{
if (Creature *pLeviathan = me->GetCreature(*me, instance->GetData64(DATA_LEVIATHAN_MK_II)))
{
me->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_STAND);
pLeviathan->AI()->DoAction(DO_START_ENCOUNTER);
phase = PHASE_COMBAT;
}
}
break;
default:
break;
}
}
else
uiPhase_timer -= diff;
}
if (phase == PHASE_VX001_ACTIVATION)
{
if (uiPhase_timer <= diff)
{
switch (uiStep)
{
case 1:
DoScriptText(SAY_MKII_DEATH, me);
JumpToNextStep(10000);
break;
case 2:
me->ChangeSeat(1);
JumpToNextStep(2000);
break;
case 3:
if (instance)
instance->SetData(DATA_MIMIRON_ELEVATOR, GO_STATE_READY);
JumpToNextStep(5000);
break;
case 4:
if (instance)
{
if (Creature *pVX_001 = me->SummonCreature(NPC_VX_001, 2744.65f, 2569.46f, 364.397f, 3.14159f, TEMPSUMMON_CORPSE_TIMED_DESPAWN, 10000))
{
instance->SetData(DATA_MIMIRON_ELEVATOR, GO_STATE_ACTIVE_ALTERNATIVE);
pVX_001->SetVisible(true);
for (uint8 n = 5; n < 7; n++)
{
if (Creature* Rocket = me->SummonCreature(NPC_ROCKET, me->GetPositionX(), me->GetPositionY(), me->GetPositionZ(), 0, TEMPSUMMON_MANUAL_DESPAWN))
{
Rocket->SetReactState(REACT_PASSIVE);
Rocket->EnterVehicle(pVX_001->GetVehicleKit(), n);
}
}
}
}
JumpToNextStep(8000);
break;
case 5:
if (instance)
{
if (Creature *pVX_001 = me->GetCreature(*me, instance->GetData64(DATA_VX_001)))
me->EnterVehicle(pVX_001->GetVehicleKit(), 0);
}
JumpToNextStep(3500);
break;
case 6:
me->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_TALK);
DoScriptText(SAY_VX001_ACTIVATE, me);
JumpToNextStep(10000);
break;
case 7:
me->ChangeSeat(1);
me->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_SIT);
JumpToNextStep(2000);
break;
case 8:
if (instance)
{
if (Creature *pVX_001 = me->GetCreature(*me, instance->GetData64(DATA_VX_001)))
pVX_001->HandleEmoteCommand(EMOTE_ONESHOT_EMERGE);
}
JumpToNextStep(3500);
break;
case 9:
if (instance)
if (Creature *pVX_001 = me->GetCreature(*me, instance->GetData64(DATA_VX_001)))
{
pVX_001->AddAura(SPELL_HOVER, pVX_001); // Hover
pVX_001->AI()->DoAction(DO_START_VX001);
phase = PHASE_COMBAT;
}
break;
default:
break;
}
}
else
uiPhase_timer -= diff;
}
if (phase == PHASE_AERIAL_ACTIVATION)
{
if (uiPhase_timer <= diff)
{
switch (uiStep)
{
case 1:
me->ChangeSeat(4);
me->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_STAND);
JumpToNextStep(2500);
break;
case 2:
DoScriptText(SAY_VX001_DEATH, me);
me->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_TALK);
JumpToNextStep(5000);
break;
case 3:
me->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_STAND);
if (instance)
{
if (Creature *pAerialUnit = me->SummonCreature(NPC_AERIAL_UNIT, 2744.65f, 2569.46f, 380, 3.14159f, TEMPSUMMON_CORPSE_TIMED_DESPAWN, 10000))
pAerialUnit->SetVisible(true);
}
JumpToNextStep(5000);
break;
case 4:
me->ExitVehicle();
me->GetMotionMaster()->MoveJump(2745.06f, 2569.36f, 379.90f, 10, 15);
JumpToNextStep(2000);
break;
case 5:
me->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_TALK);
DoScriptText(SAY_AERIAL_ACTIVATE, me);
JumpToNextStep(8000);
break;
case 6:
me->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_STAND);
me->SetVisible(false);
if (instance)
{
if (Creature *pAerialUnit = me->GetCreature(*me, instance->GetData64(DATA_AERIAL_UNIT)))
{
pAerialUnit->AI()->DoAction(DO_START_AERIAL);
phase = PHASE_COMBAT;
}
}
break;
default:
break;
}
}
else
uiPhase_timer -= diff;
}
if (phase == PHASE_V0L7R0N_ACTIVATION)
{
if (uiPhase_timer <= diff)
{
switch (uiStep)
{
case 1:
if (instance)
{
//me->SetVisible(true);
if (Creature *pLeviathan = me->GetCreature(*me, instance->GetData64(DATA_LEVIATHAN_MK_II)))
pLeviathan->GetMotionMaster()->MovePoint(0, 2744.65f, 2569.46f, 364.397f);
if (Creature *pVX_001 = me->GetCreature(*me, instance->GetData64(DATA_VX_001)))
{
me->EnterVehicle(pVX_001->GetVehicleKit(), 1);
me->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_STAND);
DoScriptText(SAY_AERIAL_DEATH, me);
}
}
JumpToNextStep(5000);
break;
case 2:
if (instance)
if (Creature *pVX_001 = me->GetCreature(*me, instance->GetData64(DATA_VX_001)))
if (Creature *pLeviathan = me->GetCreature(*me, instance->GetData64(DATA_LEVIATHAN_MK_II)))
{
pVX_001->SetStandState(UNIT_STAND_STATE_STAND);
pVX_001->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_CUSTOM_SPELL_01);
pVX_001->EnterVehicle(pLeviathan->GetVehicleKit(), 7);
}
JumpToNextStep(2000);
break;
case 3:
if (instance)
if (Creature *pVX_001 = me->GetCreature(*me, instance->GetData64(DATA_VX_001)))
if (Creature *pAerialUnit = me->GetCreature(*me, instance->GetData64(DATA_AERIAL_UNIT)))
{
pAerialUnit->SetFlying(false);
pAerialUnit->EnterVehicle(pVX_001->GetVehicleKit(), 3);
DoScriptText(SAY_V07TRON_ACTIVATE, me);
}
JumpToNextStep(10000);
break;
case 4:
if (instance)
{
if (Creature *pLeviathan = me->GetCreature(*me, instance->GetData64(DATA_LEVIATHAN_MK_II)))
pLeviathan->AI()->DoAction(DO_LEVIATHAN_ASSEMBLED);
if (Creature *pVX_001 = me->GetCreature(*me, instance->GetData64(DATA_VX_001)))
pVX_001->AI()->DoAction(DO_VX001_ASSEMBLED);
if (Creature *pAerialUnit = me->GetCreature(*me, instance->GetData64(DATA_AERIAL_UNIT)))
pAerialUnit->AI()->DoAction(DO_AERIAL_ASSEMBLED);
phase = PHASE_COMBAT;
}
break;
default:
break;
}
}
else
uiPhase_timer -= diff;
}
}
void UpdateAI(const uint32 diff)
{
if (uiFrostTimer <= diff)
{
DoCastAOE(SPELL_FLAME_SUPPRESSANT_2);
for (int8 n = 0; n < 2; n++)
{
uint32 npc;
if (n == 0)
npc = NPC_FLAME;
else
npc = NPC_FLAME_SPREAD;
std::list<Creature*> m_pCreatures;
GetCreatureListWithEntryInGrid(m_pCreatures, me, npc, 25);
if (!m_pCreatures.empty())
for(std::list<Creature*>::iterator iter = m_pCreatures.begin(); iter != m_pCreatures.end(); ++iter)
(*iter)->ForcedDespawn(1000);
}
uiFrostTimer = 10000;
}
else uiFrostTimer -= diff;
}
};
};
void AddSC_boss_mimiron()
{
new boss_mimiron();
new boss_leviathan_mk();
new boss_leviathan_mk_turret();
new npc_proximity_mine();
new boss_vx_001();
new npc_rocket_strike();
new boss_aerial_unit();
new npc_magnetic_core();
new npc_assault_bot();
new npc_emergency_bot();
new go_not_push_button();
new npc_mimiron_flame_trigger();
new npc_mimiron_flame_spread();
new npc_frost_bomb();
}
/*
* Copyright (C) 2008-2010 TrinityCore <http://www.trinitycore.org/>
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation; either version 2 of the License, or (at your
* option) any later version.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
* more details.
*
* You should have received a copy of the GNU General Public License along
* with this program. If not, see <http://www.gnu.org/licenses/>.
*/
if (instance)
{
// Rubble and Roll
if (RubbleCount > 4)
instance->DoCompleteAchievement(ACHIEVEMENT_RUBBLE_AND_ROLL);
// With Open Arms
if (RubbleCount == 0)
instance->DoCompleteAchievement(ACHIEVEMENT_WITH_OPEN_ARMS);
// Remove Stone Grip from players
Map::PlayerList const &players = instance->instance->GetPlayers();
for (Map::PlayerList::const_iterator itr = players.begin(); itr != players.end(); ++itr)
{
Player* pPlayer = itr->getSource();
Problem: Ga bisa di target/hit, tapi tetep aggro. Kesalahan pada table creature & creature_template, 'unit_flags' nya berunsur [33554432 = UNIT_FLAG_NOT_SELECTABLE = Can't be selected by mouse or with /target {name} command.] Bisa di cek di http://www.trinitycore.info/Creature...tc2#unit_flags
Referensi: Test sendiri menggunakan core trinity terbaru.
SQL Fixes:
Code:
-- Fix untuk table creature_template
UPDATE creature_template SET type_flags=0, dynamicflags=0 ,unit_flags=64 WHERE entry IN (26620,26638,26425);
-- Fix untuk table creature
UPDATE creature SET unit_flags=64 WHERE id IN (26620,26638,26425);
Keterangan tambahan: unit_flags=64 di dasari dari entry yg digunakan pada creature Drakkari Commander ( jadi disamakan saja dengan yg tidak error,a bit hacky but working ).
07-11-12, 03:18
heaven1st
[SQL] Fix Unhittable Socrethar & Deathblow to the Legion Quest (Aldor side)
Socrethar ga bisa di hit. Dikarenakan memiliki unit_flags=33088 (33088 = 32768 + 64 + 256)[256 = UNIT_FLAG_IMMUNE_TO_PC = disables combat/assistance with PlayerCharacters (PC)]
Setelah di fix , ternyata setelah di kill Socretharnya, quest Deathblow to the Legion tidak complete. Dikarenakan kekosongan entry RequiredNpcOrGo di table quest_template.
Referensi: Test sendiri menggunakan core trinity terbaru.
SQL Fixes:
Code:
-- Fix Socrethar
UPDATE creature_template SET unit_flags=0 WHERE entry=20132;
-- Fix DttL Quest
UPDATE quest_template SET SpecialFlags=0, RequiredNpcOrGo1= 20132, RequiredNpcOrGoCount1=1, ObjectiveText1='Deathblow to the Legion' WHERE id=10409;
08-11-12, 10:36
Tonggos
Nama Error : The End of the Line Quest
Referensi : Here
Kondisi : Quest tidak Complete saat item quest digunakan pada tempatnya & pada saat melewati area azure dragon
Code : Quest Item
Spoiler untuk 2012_03_12_00_world_misc.sql :
Code:
SET @LEY_LINE_BEAM := 47334; -- Ley Line Beam (No kit)
SET @BUNNY_BEAM := 47635; -- The End of the Line: Ley Line Focus Bunny Beam
SET @TALISMAN_EFFECT := 50548; -- The End of the Line: Ley Line Focus Control Talisman Effect
-- ELM General Purpose Bunny (Scale x0.01) SAI
-- This is pure ****, those NPCs target some other NPCs with the same DB id, based on their GUIDs.
DELETE FROM `smart_scripts` WHERE `entryorguid`=-116051 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=-116053 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=-116054 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=-116055 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=-116056 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=-116057 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=-116058 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=-116059 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=-116060 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=-116061 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=-116065 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
(-116051,0,0,0,1,0,100,0,1000,1000,1000,2500,11,@LEY_LINE_BEAM,0,0,0,0,0,10,115958,24021,0,0,0,0,0, 'ELM General Purpose Bunny (Scale x0.01) - On update OOC - Cast Ley Line Beam (No kit) on ELM General Purpose Bunny (Scale x0.01)'),
(-116053,0,0,0,1,0,100,0,1000,1000,1000,2500,11,@LEY_LINE_BEAM,0,0,0,0,0,10,115976,24021,0,0,0,0,0, 'ELM General Purpose Bunny (Scale x0.01) - On update OOC - Cast Ley Line Beam (No kit) on ELM General Purpose Bunny (Scale x0.01)'),
(-116054,0,0,0,1,0,100,0,1000,1000,1000,2500,11,@LEY_LINE_BEAM,0,0,0,0,0,10,115973,24021,0,0,0,0,0, 'ELM General Purpose Bunny (Scale x0.01) - On update OOC - Cast Ley Line Beam (No kit) on ELM General Purpose Bunny (Scale x0.01)'),
(-116055,0,0,0,1,0,100,0,1000,1000,1000,3500,11,@LEY_LINE_BEAM,0,0,0,0,0,10,115976,24021,0,0,0,0,0, 'ELM General Purpose Bunny (Scale x0.01) - On update OOC - Cast Ley Line Beam (No kit) on ELM General Purpose Bunny (Scale x0.01)'),
(-116056,0,0,0,1,0,100,0,1000,1000,1000,3500,11,@LEY_LINE_BEAM,0,0,0,0,0,10,115958,24021,0,0,0,0,0, 'ELM General Purpose Bunny (Scale x0.01) - On update OOC - Cast Ley Line Beam (No kit) on ELM General Purpose Bunny (Scale x0.01)'),
(-116057,0,0,0,1,0,100,0,1000,1000,1000,3500,11,@LEY_LINE_BEAM,0,0,0,0,0,10,115975,24021,0,0,0,0,0, 'ELM General Purpose Bunny (Scale x0.01) - On update OOC - Cast Ley Line Beam (No kit) on ELM General Purpose Bunny (Scale x0.01)'),
(-116058,0,0,0,1,0,100,0,1000,1000,1000,4500,11,@LEY_LINE_BEAM,0,0,0,0,0,10,115959,24021,0,0,0,0,0, 'ELM General Purpose Bunny (Scale x0.01) - On update OOC - Cast Ley Line Beam (No kit) on ELM General Purpose Bunny (Scale x0.01)'),
(-116059,0,0,0,1,0,100,0,1000,1000,1000,2500,11,@LEY_LINE_BEAM,0,0,0,0,0,10,115976,24021,0,0,0,0,0, 'ELM General Purpose Bunny (Scale x0.01) - On update OOC - Cast Ley Line Beam (No kit) on ELM General Purpose Bunny (Scale x0.01)'),
(-116060,0,0,0,1,0,100,0,1000,1000,1000,3000,11,@LEY_LINE_BEAM,0,0,0,0,0,10,115973,24021,0,0,0,0,0, 'ELM General Purpose Bunny (Scale x0.01) - On update OOC - Cast Ley Line Beam (No kit) on ELM General Purpose Bunny (Scale x0.01)'),
(-116061,0,0,0,1,0,100,0,1000,1000,1000,2500,11,@LEY_LINE_BEAM,0,0,0,0,0,10,115976,24021,0,0,0,0,0, 'ELM General Purpose Bunny (Scale x0.01) - On update OOC - Cast Ley Line Beam (No kit) on ELM General Purpose Bunny (Scale x0.01)'),
(-116065,0,0,0,1,0,100,0,1000,1000,1000,2500,11,@LEY_LINE_BEAM,0,0,0,0,0,10,115959,24021,0,0,0,0,0, 'ELM General Purpose Bunny (Scale x0.01) - On update OOC - Cast Ley Line Beam (No kit) on ELM General Purpose Bunny (Scale x0.01)');
-- ELM General Purpose Bunny SAI
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=24021;
SET @ENTRY := -98564;
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,8,0,100,0x1,@TALISMAN_EFFECT,0,0,0,11,@BUNNY_BEAM,0,0,0,0,0,7,0,0,0,0,0,0,0, 'ELM General Purpose Bunny - On The End of the Line: Ley Line Focus Control Talisman Effect hit - Cast The End of the Line: Ley Line Focus Bunny Beam on action invoker');
-- ELM General Purpose Bunny SAI
SET @ENTRY := -98617;
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,8,0,100,0x1,@TALISMAN_EFFECT,0,0,0,11,@BUNNY_BEAM,0,0,0,0,0,7,0,0,0,0,0,0,0, 'ELM General Purpose Bunny - On The End of the Line: Ley Line Focus Control Talisman Effect hit - Cast The End of the Line: Ley Line Focus Bunny Beam on action invoker');
-- Wrong conditions
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=47634;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=@TALISMAN_EFFECT;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(13,0x1,47634,0,0,31,3,23837,0,0, '', 'Ley Line Focus Control Talisman only targets ELM General Purpose Bunny'),
(13,0x1,@TALISMAN_EFFECT,0,0,31,1,23837,0,0, '', 'The End of the Line: Ley Line Focus Control Talisman Effect only targets ELM General Purpose Bunny');
-- Areatrigger script
DELETE FROM `areatrigger_scripts` WHERE `entry`=4956;
INSERT INTO `areatrigger_scripts` VALUES (4956, 'at_azure_dragons_sanctuary');
-- Quest: The Back Knights Orders (13663)
-- Black Knights Camp Spawns
SET @OGUID=xxxxxx; -- Need 10
SET @CGUID=xxxxxx; -- Need 3
DELETE FROM gameobject WHERE guid BETWEEN @OGUID+0 AND @OGUID+9;
INSERT INTO gameobject (guid,id,map,spawnMask,phaseMask,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state) VALUES
(@OGUID+0,194357,571,1,1,9070.324,2050.733,67.21755,0,0,0,0,1,0,0,0),
(@OGUID+1,194357,571,1,1,9073.764,2050.12,68.15718,0,0,0,0,1,0,0,0),
(@OGUID+2,194357,571,1,1,9074.699,2050.709,68.17049,0,0,0,0,1,0,0,0),
(@OGUID+3,194357,571,1,1,9069.595,2050.349,67.21755,0,0,0,0,1,0,0,0),
(@OGUID+4,194394,571,1,1,9083.578,2041.696,67.81812,0,0,0,0,1,0,0,0),
(@OGUID+5,194357,571,1,1,9069.961,2050.538,67.21755,0,0,0,0,1,0,0,0),
(@OGUID+6,194357,571,1,1,9072.077,2049.292,67.78963,0,0,0,0,1,0,0,0),
(@OGUID+7,195011,571,1,1,9078.471,2057.547,67.21606,0,0,0,0.9981346,0.06105176,0,0,0),
(@OGUID+8,194357,571,1,1,9065.68,2052.618,67.28638,3.019413,0,0,0,1,0,0,0),
(@OGUID+9,300007,571,1,1,8523.900,566.635010,552.921,0,0,0,0,0,0,0,0); -- Is this GO used anywhere?
DELETE FROM creature WHERE id=33537;
INSERT INTO creature (guid,id,map,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags) VALUES
(@CGUID+0,33537,571,1,1,0,0,9071.043,2075.388,67.21542,4.93598,120,0,0,1,0,0,0,0,0),
(@CGUID+1,33537,571,1,1,0,0,9074.414,2049.259,67.34636,2.181662,120,0,0,1,0,0,0,0,0),
(@CGUID+2,33537,571,1,1,0,0,9081.28,2058.925,67.38979,3.612832,120,0,0,1,0,0,0,0,0);
-- Template updates
UPDATE creature_template SET unit_flags=unit_flags|8,speed_run=4, InhabitType=5 WHERE entry=33519; -- Black Knight's Gryphon
UPDATE creature_template SET faction_A=2080,faction_H=2080,unit_flags=unit_flags|32768,equipment_id=823 WHERE entry=33537; -- Cult Conspirator
-- Addon data
DELETE FROM creature_template_addon WHERE entry IN (33519,33537);
INSERT INTO creature_template_addon (entry,mount,bytes1,bytes2,emote,auras) VALUES
(33519,0,0,2049,0,NULL),-- Black Knight's Gryphon
(33537,0,1,1,0,NULL); -- Cult Conspirator
-- SAI for Black Knight's Gryphon
SET @entry :=33519;
UPDATE creature_template SET AIName='SmartAI' WHERE entry=@entry;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@entry;
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,27,0,100,0,0,0,0,0,53,0,@entry,0,13663,0,0,1,0,0,0,0,0,0,0,'Black Knight''s Gryphon - On Passenger - Start WP movement'),
(@entry,0,1,0,40,0,100,0,40,@entry,0,0,33,33519,0,0,0,0,0,7,0,0,0,0,0,0,0,'Black Knight''s Gryphon - Quest Credit'),
(@entry,0,2,0,40,0,100,0,43,@entry,0,0,11,50630,0,0,0,0,0,7,0,0,0,0,0,0,0,'Black Knight''s Gryphon - Dismount Spell'),
(@entry,0,3,0,40,0,100,0,44,@entry,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Black Knight''s Gryphon - Despawn');
Nama Error (spell/Quest/achiev dsb) : Gluttonous Lurkers
Referensi : Quest : Gluttonous Lurkers (12527) SAI Convertion
Kondisi : Loot Zul'drak Rat dari tikus2 di daerah Drak'Agal... Lalu menggunakan Item Quest 5 buah "Zul'drak Rat" pada Lurking Basilisk hingga basilisk menjadi "pacify" lalu loot Basilisk Crystals..
Kenyataan nya disini setelah melempar 1 Zul'drak rat pada NPC Lurking Basilisk.. Basiliks menjadi "Pacify" dan ketika di loot NPC hilang dan tidak drop Basilisk Crystal..
Code:
Spoiler untuk code :
Code:
-- Quest: Gluttonous Lurkers (12527)
-- SAI for Zul'Drak Rat
SET @ENTRY :=28202;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY;
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,8,0,100,0,50926,0,1000,1000,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Zul''Drak Rat - Despawn on Spell Dummy');
-- Remove EAI Scripts
DELETE FROM creature_ai_scripts WHERE creature_id IN (28145,28203);
-- SAI for Gorged Lurking Basilisk
SET @ENTRY :=28203;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY;
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,8,0,100,0,50918,0,1000,1000,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Gorged Lurking Basilisk - Despawn on Spell Dummy');
-- SAI for Lurking Basilisk
SET @ENTRY :=28145;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@ENTRY*100;
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,0,0,100,0,5000,5000,17000,27000,11,54470,1,0,0,0,0,2,0,0,0,0,0,0,0, 'Lurking Basilisk - Cast Venemous Bite'),
(@ENTRY,0,1,0,23,0,100,0,50894,5,0,0,80,@ENTRY*100,0,2,0,0,0,1,0,0,0,0,0,0,0, 'Lurking Basilisk - Start Script'),
(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Lurking Basilisk - Gorged Lurking Basilisk'),
(@ENTRY*100,9,1,0,0,0,100,0,0,0,0,0,12,28203,1,30000,0,0,0,1,0,0,0,0,0,0,0, 'Lurking Basilisk - Gorged Lurking Basilisk'),
(@ENTRY*100,9,2,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Lurking Basilisk - Despawn');
29-04-13, 12:05
Achernar_Altair
[SQL]Fix for Uldum NPC Spawn, Quest, Obsidium Spawn, Mobs damage, Tolvir and Hall of Origination
Saya Mau Share 7 SQL Script buat berbagai Fix
Description :
This SQL script allows the player to do all the quests without error, some of them are simply hacked to be auto completed. This script also spawns all the missing NPCs that are managed by phases. It gives damage to all the mobs that didn’t do any damage before (The damage is probably not exact but it’s a start). It also allows you to complete the Lost City dungeon and the Halls of origination dungeon and do the quests in those dungeons. Since Uldum is the only zone that really works now for levels 80 to 84, I’ve reduced the quest requirement level to 80 so any players 80 and + can go there and do the quests. I’ve also added many obsidium mines everywhere in Uldum because none of them are spawned anywhere right now in 4.3.4. None of those fixes were sent to Trinity because they are not Blizzlike so you are the only ones to get them.
-- Fix quest 27923: Smoke in their eyes
SET @SPELL := 88646;
SET @GAMEOBJ_REWARD := 206682;
SET @GAMEOBJ := 206682;
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry` = @GAMEOBJ;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @GAMEOBJ AND `source_type`=1;
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
(@GAMEOBJ,1,0,1,8,0,100,1,@SPELL,0,0,0,33,@GAMEOBJ_REWARD,0,0,0,0,0,7,0,0,0,0,0,0,0,'Bale of Hay - On Spell Hit - Give credit for quest 27923'),
(@GAMEOBJ,1,1,0,61,0,100,1,0,0,0,0,41,2000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Bale of Hay - Despawn after 2 second');
-- Sand Covered Heiroglyphs
UPDATE gameobject_template SET flags = 0 WHERE entry = 205874;
-- Uldum Survivor
UPDATE creature_template SET type = 4, type_flags = 0, faction_A = 834, faction_H = 834, IconName = '' WHERE entry = 45715;
-- Trooper Uniform
DELETE FROM `creature_loot_template` WHERE `entry` = 47220 AND `item` = 62789;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(47220, 62789, -100, 1, 0, 1, 1);
-- Quest - 27905 - Tailgunner! - Autocomplete
update quest_template set flags = 8, RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0 WHERE id = 27905;
-- Quest - 27993 - Take it to 'Em! - Autocomplete
update quest_template set flags = 8, RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0 WHERE id = 27993;
-- Quest - 27922 - Traitors! - Autocomplete
update quest_template set flags = 65536 WHERE id = 27922;
-- Quest - 28501 - The Defense of Nahom - Autocomplete
update quest_template set flags = 65536 WHERE id = 28501;
-- Quest 28612 Harrison Jones and the temple of Uldum
update quest_template set RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0, RequiredNpcOrGo2 = 0, RequiredNpcOrGoCount2 = 0, RequiredNpcOrGo3 = 0, RequiredNpcOrGoCount3 = 0 WHERE id = 28612;
-- Quest 28622 Three if by Air
update quest_template set RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0, RequiredNpcOrGo2 = 0, RequiredNpcOrGoCount2 = 0, RequiredNpcOrGo3 = 0, RequiredNpcOrGoCount3 = 0 WHERE id = 28622;
-- Quest 28633 The Coffer of Promises
update quest_template set RequiredItemId1 = 0, RequiredItemCount1 = 0 WHERE id = 28633;
-- Quest 27707 Neferset Prison
update quest_template set RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0, RequiredNpcOrGo2 = 0, RequiredNpcOrGoCount2 = 0, RequiredNpcOrGo3 = 0, RequiredNpcOrGoCount3 = 0 WHERE id = 27707;
DELETE FROM creature_involvedrelation WHERE id = 46136 AND quest = 27707;
INSERT INTO creature_involvedrelation (id, quest) VALUES (46136, 27707);
-- Tahet, needs to be hostile
UPDATE creature_template SET faction_A = 834, faction_H = 834, gossip_menu_id = 0, npcflag = 0, unit_flags = 0, unit_flags2 = 0, dynamicflags = 0, type = 6, type_flags = 0, lootid = 46496, VehicleId = 0 WHERE entry = 46496;
-- All the Scarabs from Obelish of the Stars
update creature_template_addon set auras = '' where entry = 46129;
update creature_template_addon set auras = '' where entry = 46128;
update creature_template_addon set auras = '' where entry = 46127;
update creature_template_addon set auras = '' where entry = 46126;
update creature_template_addon set auras = '' where entry = 46129;
update creature_template_addon set auras = '' where entry = 46128;
update creature_template_addon set auras = '' where entry = 46127;
delete from creature_loot_template where entry IN (46126, 46127, 46128, 46129);
update creature_template set lootid = 0 where entry IN (46126, 46127, 46128, 46129);
-- Quest 27627 - Just a fancy coackroaches
DELETE FROM creature_involvedrelation WHERE id = 45296 AND quest = 27627;
INSERT INTO creature_involvedrelation (id, quest) VALUES (45296, 27627);
DELETE FROM creature_questrelation WHERE id = 45296 AND quest = 27627;
INSERT INTO creature_questrelation (id, quest) VALUES (45296, 27627);
UPDATE quest_template SET flags = 8 WHERE id = 27627;
-- Quest 28486 Salhet's Gambit
update quest_template set RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0, RequiredNpcOrGo2 = 0, RequiredNpcOrGoCount2 = 0, RequiredNpcOrGo3 = 0, RequiredNpcOrGoCount3 = 0 WHERE id = 28486;
-- Quest 27940 - Dirty Birds
DELETE FROM creature_involvedrelation WHERE id = 49248 AND quest = 27940;
INSERT INTO creature_involvedrelation (id, quest) VALUES (49248, 27940);
DELETE FROM creature_questrelation WHERE id = 49248 AND quest = 27940;
INSERT INTO creature_questrelation (id, quest) VALUES (49248, 27940);
UPDATE quest_template SET flags = 8 WHERE id = 27940;
-- Quest 27187 - Mangy Hiena
DELETE FROM creature_involvedrelation WHERE id = 47959 AND quest = 27187;
INSERT INTO creature_involvedrelation (id, quest) VALUES (47959, 27187);
DELETE FROM creature_questrelation WHERE id = 47959 AND quest = 27187;
INSERT INTO creature_questrelation (id, quest) VALUES (47959, 27187);
UPDATE quest_template SET flags = 8 WHERE id = 27187;
-- Quest 27003 Easy Money
update quest_template set RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0, RequiredNpcOrGo2 = 0, RequiredNpcOrGoCount2 = 0, RequiredNpcOrGo3 = 0, RequiredNpcOrGoCount3 = 0 WHERE id = 27003;
-- Instance mobs needs to be selectable, no script so they can fight correctly and no vehicle so they move ok
UPDATE creature_template SET unit_flags = 32832, ScriptName = '', VehicleId = 0 WHERE entry = 40808;
UPDATE creature_template SET unit_flags = 32832, ScriptName = '', VehicleId = 0 WHERE entry = 40787;
UPDATE creature_template SET unit_flags = 32832, ScriptName = '', VehicleId = 0 WHERE entry = 40311;
UPDATE creature_template SET unit_flags = 32832, ScriptName = '', VehicleId = 0 WHERE entry = 39788;
UPDATE creature_template SET unit_flags = 32832, ScriptName = '', VehicleId = 0 WHERE entry = 39731;
UPDATE creature_template SET unit_flags = 32832, ScriptName = '', VehicleId = 0 WHERE entry = 44577;
UPDATE creature_template SET unit_flags = 32832, ScriptName = '', VehicleId = 0 WHERE entry = 39378;
-- Quest Penetrating their defenses
update quest_template set RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0, RequiredNpcOrGo2 = 0, RequiredNpcOrGoCount2 = 0, RequiredNpcOrGo3 = 0, RequiredNpcOrGoCount3 = 0 WHERE id = 28746;
Status : Tested by Me for NPC Harrison Jones Spawn
Code2 yang saya kasih ini masih belom Final, masih akan diupdate lagi sama creatornya, tapi untuk sementara membantu banget buat leveling di Uldum, secara available Cata Zone cuma Uldum, dan banyak yang stuck di 84 karena quest di Uldum udah abis, sisa yang bug2 dan quest dengan loot
29-04-13, 12:34
Achernar_Altair
[SQL]Cataclysm Mobs Loot
Description :
It’s a script that gives loot to all mobs for Cataclysm, which many of those don’t have in the latest trinity core. It’s currently being reviewed by the trinity team but since it’s so big it might take a lot of time for them to test it. It fixes tons of drop quests.
Kode Panjang banget jadi g ane paste disini, ud berapa kali tak paste cuma jadi error, bkin ngehang Chrome ane --'a
Status : Tested di repack saya, and work nice
29-04-13, 12:51
Achernar_Altair
[SQL]Various Fixes From Trinity Forum
Desciption :
Many fixes are posted on the trinity forums but not all of them are pushed into the master build. These are a few that I’ve kept that are quite useful, especially the one to prevent crashes in the Argent Tournament zone.
-- Sentinel Hill Guard - Remove incorrect auras
UPDATE creature_template_addon SET auras = '' WHERE entry = 42407;
-- Argent Tournament Emotes
UPDATE `creature_addon` SET `emote`=010 WHERE `emote`=094; -- STATE_DANCE
UPDATE `creature_addon` SET `emote`=027 WHERE `emote`=044; -- STATE_READYUNARMED
UPDATE `creature_addon` SET `emote`=029 WHERE `emote`=025; -- STATE_POINT(DNR)
UPDATE `creature_addon` SET `emote`=064 WHERE `emote`=462; -- STATE_STUN
UPDATE `creature_addon` SET `emote`=068 WHERE `emote`=016; -- STATE_KNEEL
UPDATE `creature_addon` SET `emote`=069 WHERE `emote`=432; -- STATE_USESTANDING
UPDATE `creature_addon` SET `emote`=193 WHERE `emote`=050; -- STATE_SPELLPRECAST
UPDATE `creature_addon` SET `emote`=214 WHERE `emote`=213; -- STATE_READYRIFLE
UPDATE `creature_addon` SET `emote`=233 WHERE `emote`=467; -- STATE_WORK_MINING
UPDATE `creature_addon` SET `emote`=234 WHERE `emote`=466; -- STATE_WORK_CHOPWOOD
UPDATE `creature_addon` SET `emote`=253 WHERE `emote`=021; -- STATE_APPLAUD
UPDATE `creature_addon` SET `emote`=333 WHERE `emote`=045; -- STATE_READY1H
UPDATE `creature_addon` SET `emote`=376 WHERE `emote`=048; -- STATE_READYBOW
UPDATE `creature_addon` SET `emote`=379 WHERE `emote`=380; -- STATE_FISHING
UPDATE `creature_addon` SET `emote`=392 WHERE `emote`=011; -- STATE_LAUGH
UPDATE `creature_addon` SET `emote`=400 WHERE `emote`=401; -- STATE_DANCESPECIAL
UPDATE `creature_addon` SET `emote`=416 WHERE `emote`=402; -- STATE_CUSTOM_SPELL_01
UPDATE `creature_addon` SET `emote`=417 WHERE `emote`=403; -- STATE_CUSTOM_SPELL_02
UPDATE `creature_addon` SET `emote`=418 WHERE `emote`=007; -- STATE_EAT
UPDATE `creature_addon` SET `emote`=419 WHERE `emote`=405; -- STATE_CUSTOM_SPELL_04
UPDATE `creature_addon` SET `emote`=420 WHERE `emote`=404; -- STATE_CUSTOM_SPELL_03
UPDATE `creature_addon` SET `emote`=421 WHERE `emote`=406; -- STATE_CUSTOM_SPELL_05
UPDATE `creature_addon` SET `emote`=428 WHERE `emote`=381; -- STATE_LOOT
UPDATE `creature_addon` SET `emote`=451 WHERE `emote`=477; -- STATE_SPECIALUNARMED
UPDATE `creature_template_addon` SET `emote`=010 WHERE `emote`=094; -- STATE_DANCE
UPDATE `creature_template_addon` SET `emote`=027 WHERE `emote`=044; -- STATE_READYUNARMED
UPDATE `creature_template_addon` SET `emote`=029 WHERE `emote`=025; -- STATE_POINT(DNR)
UPDATE `creature_template_addon` SET `emote`=064 WHERE `emote`=462; -- STATE_STUN
UPDATE `creature_template_addon` SET `emote`=068 WHERE `emote`=016; -- STATE_KNEEL
UPDATE `creature_template_addon` SET `emote`=069 WHERE `emote`=432; -- STATE_USESTANDING
UPDATE `creature_template_addon` SET `emote`=193 WHERE `emote`=050; -- STATE_SPELLPRECAST
UPDATE `creature_template_addon` SET `emote`=214 WHERE `emote`=213; -- STATE_READYRIFLE
UPDATE `creature_template_addon` SET `emote`=233 WHERE `emote`=467; -- STATE_WORK_MINING
UPDATE `creature_template_addon` SET `emote`=234 WHERE `emote`=466; -- STATE_WORK_CHOPWOOD
UPDATE `creature_template_addon` SET `emote`=253 WHERE `emote`=021; -- STATE_APPLAUD
UPDATE `creature_template_addon` SET `emote`=333 WHERE `emote`=045; -- STATE_READY1H
UPDATE `creature_template_addon` SET `emote`=376 WHERE `emote`=048; -- STATE_READYBOW
UPDATE `creature_template_addon` SET `emote`=379 WHERE `emote`=380; -- STATE_FISHING
UPDATE `creature_template_addon` SET `emote`=392 WHERE `emote`=011; -- STATE_LAUGH
UPDATE `creature_template_addon` SET `emote`=400 WHERE `emote`=401; -- STATE_DANCESPECIAL
UPDATE `creature_template_addon` SET `emote`=416 WHERE `emote`=402; -- STATE_CUSTOM_SPELL_01
UPDATE `creature_template_addon` SET `emote`=417 WHERE `emote`=403; -- STATE_CUSTOM_SPELL_02
UPDATE `creature_template_addon` SET `emote`=418 WHERE `emote`=007; -- STATE_EAT
UPDATE `creature_template_addon` SET `emote`=419 WHERE `emote`=405; -- STATE_CUSTOM_SPELL_04
UPDATE `creature_template_addon` SET `emote`=420 WHERE `emote`=404; -- STATE_CUSTOM_SPELL_03
UPDATE `creature_template_addon` SET `emote`=421 WHERE `emote`=406; -- STATE_CUSTOM_SPELL_05
UPDATE `creature_template_addon` SET `emote`=428 WHERE `emote`=381; -- STATE_LOOT
UPDATE `creature_template_addon` SET `emote`=451 WHERE `emote`=477; -- STATE_SPECIALUNARMED
Status : Tested for Argent Tournament only in my repack, work nice, sisanya blom
29-04-13, 13:23
Achernar_Altair
[SQL]Fix For Main Quests
Description :
This script fixes lots of quests everywhere but mostly in the Dun Morogh, Loch Modan, Wetlands, Arathi Highlands, The Hinterlands, Dustwallow Marsh, Westfall, Dusk Woods, Winterspring, Tanaris and Ice Crown. Most of the fixes are legit but some of them simply hack the quest so it can be completed. More than half of those fixes are already posted or being reviewed by the trinity team.
-- Quest #24475 fix : All the Other Stuff. Add the quest loot to the timber wolf, young wolf and boar
DELETE FROM `creature_loot_template` WHERE `entry` = 708 AND `item` = 49747;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (708, 49747, -39, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry` = 705 AND `item` = 49748;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (705, 49748, -64, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry` = 704 AND `item` = 49748;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (704, 49748, -70, 1, 0, 1, 1);
-- Quest #24486 fix : Make Hay While the Sun Shines. Add the Priceless Rockjaw Artifact loot to the Rockjaw Scavenger so you can complete the quest
DELETE FROM `creature_loot_template` WHERE `entry` = 37105 AND `item` = 49751;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (37105, 49751, -90, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 37105 WHERE `entry` = 37105;
-- Quest #384 fix: Adding the tender boar meat to the crag boar, the 41% rate is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 1125 AND `item` = 60496;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (1125, 60496, -41, 1, 0, 1, 1);
-- Quest #384 fix: Last gossip_menu_id was 1297 but it was preventing players from trading with the innkeeper and setting their heartstone in that region
UPDATE `creature_template` SET `gossip_menu_id` = 0 WHERE `entry` = 1247;
-- Quest #25997 fix: Adding Dark Iron Attack Plans
DELETE FROM `creature_loot_template` WHERE `entry` = 6124 AND `item` = 56264;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (6124, 56264, -100, 1, 0, 1, 1);
-- Quest #412 Operation Recombobulation - fix: Adding the Gyromechanic Gear, the drop rate is from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 41146 AND `item` = 3084;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(41146, 3084, -91, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 41146 WHERE `entry` = 41146;
-- *** FIXES FOR LOCH MODAN ***
-- Quest #26845 fix: Adding the Foreman Sharpsneer's Head
DELETE FROM `creature_loot_template` WHERE `entry` = 44198 AND `item` = 60404;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (44198, 60404, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 44198 WHERE `entry` = 44198;
-- Quest #26842 fix: Adding Mosshide Ear
DELETE FROM `creature_loot_template` WHERE `entry` = 44162 AND `item` = 60402;
DELETE FROM `creature_loot_template` WHERE `entry` = 44161 AND `item` = 60402;
DELETE FROM `creature_loot_template` WHERE `entry` = 45384 AND `item` = 60402;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(44162, 60402, -100, 1, 0, 1, 1),
(44161, 60402, -100, 1, 0, 1, 1),
(45384, 60402, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 44162 WHERE `entry` = 44162;
UPDATE `creature_template` SET `lootid` = 44161 WHERE `entry` = 44161;
UPDATE `creature_template` SET `lootid` = 45384 WHERE `entry` = 45384;
-- Quest #26928 fix: Adding Murloc Scent Gland, the drop rates are from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 44176 AND `item` = 60511;
DELETE FROM `creature_loot_template` WHERE `entry` = 44292 AND `item` = 60511;
DELETE FROM `creature_loot_template` WHERE `entry` = 45401 AND `item` = 60511;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(44176, 60511, -45, 1, 0, 1, 1),
(44292, 60511, -38, 1, 0, 1, 1),
(45401, 60511, -30, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 44176 WHERE `entry` = 44176;
UPDATE `creature_template` SET `lootid` = 44292 WHERE `entry` = 44292;
UPDATE `creature_template` SET `lootid` = 45401 WHERE `entry` = 45401;
-- Quest #26929 fix: Adding Intact Crocolisk Jaw, the 44% drop rates is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 1693 AND `item` = 57131;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(1693, 57131, -44, 1, 0, 1, 1);
-- Quest #26860 fix: Adding Bear Rump, the 56% drop rates is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 1186 AND `item` = 60497;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(1186, 60497, -56, 1, 0, 1, 1);
-- Quest #27031 Wing Nut - fix: Adding the Pristine Flight Feather, the 34% drop rate is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 44628 AND `item` = 60792;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`)
VALUES (44628, 60792, -34, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 44628 WHERE `entry` = 44628;
-- Quest #27028 Hornet Hunting - fix: Adding the Glassy Hornet Wing, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 44620 AND `item` = 60754;
DELETE FROM `creature_loot_template` WHERE `entry` = 45402 AND `item` = 60754;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(44620, 60754, -41, 1, 0, 1, 1),
(45402, 60754, -32, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 44620 WHERE `entry` = 44620;
UPDATE `creature_template` SET `lootid` = 45402 WHERE `entry` = 45402;
-- Quest #27030 Foxtails by the handful - fix: Adding the Fluffy Fox Tail, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 44635 AND `item` = 60755;
DELETE FROM `creature_loot_template` WHERE `entry` = 45380 AND `item` = 60755;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(44635, 60755, -81, 1, 0, 1, 1),
(45380, 60755, -53, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 44635 WHERE `entry` = 44635;
UPDATE `creature_template` SET `lootid` = 45380 WHERE `entry` = 45380;
-- *** FIXES FOR THE WETLANDS ***
-- Quest #25800 When Life Gives You Crabs - fix: Adding the Meaty Crawler Claw, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 44116 AND `item` = 56013;
DELETE FROM `creature_loot_template` WHERE `entry` = 41295 AND `item` = 56013;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(44116, 56013, -43, 1, 0, 1, 1),
(41295, 56013, -36, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 44116 WHERE `entry` = 44116;
UPDATE `creature_template` SET `lootid` = 41295 WHERE `entry` = 41295;
-- Quest #25723 Thresh Out of Luck - fix: Adding the Threshadon Chunk, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 41137 AND `item` = 55232;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(41137, 55232, -94, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 41137 WHERE `entry` = 41137;
-- Quest #25849 When Archaeology Attacks - fix: Adding the Fossilized Bone, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 41388 AND `item` = 56083;
DELETE FROM `creature_loot_template` WHERE `entry` = 44226 AND `item` = 56083;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(41388, 56083, -68, 1, 0, 1, 3),
(44226, 56083, -5, 1, 0, 1, 3);
UPDATE `creature_template` SET `lootid` = 41388 WHERE `entry` = 41388;
UPDATE `creature_template` SET `lootid` = 44226 WHERE `entry` = 44226;
-- Quest #25853 Tooling Around - fix: Adding the Archaeologist's Tools
DELETE FROM `gameobject_loot_template` WHERE `entry` = 29626 AND `item` = 56082;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(29626, 56082, -100, 1, 0, 1, 1);
-- *** FIXES FOR THE HINTERLANDS ***
-- Quest #26490 (Alliance) & #26283 (Horde) Prime Slime - fix: Adding the Direglob Sample
DELETE FROM `creature_loot_template` WHERE `entry` = 42592 AND `item` = 58082;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(42592, 58082, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 42592 WHERE `entry` = 42592;
-- *** FIXES FOR NPC TRAINERS ***
-- Fix the fishing trainers so the players can train beyond 75. 356 is the correct skill ID for fishing.
UPDATE `npc_trainer` SET `reqskill` = 356 WHERE `reqskill` = 365 AND `entry` = 200302;
-- *** FIXES FOR DARKSHORE ***
-- Quest #13521 Buzzbox 413 - fix: Adding the Corrupted Tide Crawler Flesh, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 32935 AND `item` = 44863;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(32935, 44863, -40, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 32935 WHERE `entry` = 32935;
-- Quest #13521 Buzzbox 413 - fix: create the quest reward giver, the Buzzbox 413
DELETE FROM `gameobject_template` WHERE `entry` = 194105;
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `size`, `data1`) VALUES (194105, 2, 356, 'Buzzbox 413', 1, 9477);
DELETE FROM `gameobject` WHERE `guid` = 194105 AND `id` = 2040;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`,
`orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(194105, 2040, 0, 1, 1, -935.522, -3939.23, 147.561, 2.60444, 0, 0, 0.96415, 0.265358, 300, 0, 1);
-- Quest #13528 Buzzbox 723 - fix: Adding the Corrupted Thistle Bear Guts, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 33905 AND `item` = 44913;
DELETE FROM `creature_loot_template` WHERE `entry` = 33009 AND `item` = 44913;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(33905, 44913, -35, 1, 0, 1, 1),
(33009, 44913, -32, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 33905 WHERE `entry` = 33905;
UPDATE `creature_template` SET `lootid` = 33009 WHERE `entry` = 33009;
-- Quest #13513 On the Brink - fix: Adding the Shatterspear Amulet, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 32860 AND `item` = 44942;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(32860, 44942, -83, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 32860 WHERE `entry` = 32860;
-- Quest #13844 The Looting of Althalaxx - fix: create the Charred Book game object and its loot
DELETE FROM `gameobject_template` WHERE `entry` = 194787;
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `castBarCaption`, `flags`, `size`, `questItem1`, `data0`, `data1`) VALUES
(194787, 3, 2530, 'Charred Book', 'Examining', 4, 1, 45944, 43, 24124);
DELETE FROM `gameobject_loot_template` WHERE `entry` = 24124 AND `item` = 45944;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(24124, 45944, -100, 1, 0, 1, 1);
-- Quest #13554 A Cure In The Dark - fix: Adding the Foul Ichor, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 33021 AND `item` = 44966;
DELETE FROM `creature_loot_template` WHERE `entry` = 33022 AND `item` = 44966;
DELETE FROM `creature_loot_template` WHERE `entry` = 33020 AND `item` = 44966;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(33021, 44966, -35, 1, 0, 1, 1),
(33022, 44966, -34, 1, 0, 1, 1),
(33020, 44966, -20, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 33021 WHERE `entry` = 33021;
UPDATE `creature_template` SET `lootid` = 33022 WHERE `entry` = 33022;
UPDATE `creature_template` SET `lootid` = 33020 WHERE `entry` = 33020;
-- *** FIXES FOR DUN MOROGH - GNOME STARTING ZONE ***
-- Change the NPC: Torben Zapblast for SmartAI so he can use scripts like teleports, change the Icon and Flag so he can speak single gossip
UPDATE creature_template SET AIName = 'SmartAI', IconName = 'Speak', type_flags = 134221824 WHERE entry = 46293;
-- Assign the gossip menu to Torben Zapblast
DELETE FROM gossip_menu WHERE entry = 12104 AND text_id = 16995;
INSERT INTO gossip_menu (entry, text_id) VALUES (12104, 16995);
-- Update the gossip menu option to show the gossip option to leave gnomeragan
UPDATE gossip_menu_option SET option_id = 1, npc_option_npcflag = 1 WHERE menu_id = 12104 AND id = 1;
-- Create the telelport smart script so gnomes can exit their starting location
DELETE FROM smart_scripts WHERE entryorguid = 46293;
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 (46293, 0, 1, 0, 62, 0, 100, 0, 12104, 1, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, -5201.2856, 477.5454, 388.471, 5.2577, 'Teleport');
-- Quest #26264 What's Left Behind - fix: Adding the Recovered Possession, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 42184 AND `item` = 57987;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(42184, 57987, -89, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 42184 WHERE `entry` = 42184;
-- Quest #26285 Get Me Explosives Back! - fix: Adding the Stolen Powder Keg, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 42221 AND `item` = 58202;
DELETE FROM `creature_loot_template` WHERE `entry` = 42222 AND `item` = 58202;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(42221, 58202, -95, 1, 0, 1, 1),
(42222, 58202, -86, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 42221 WHERE `entry` = 42221;
UPDATE `creature_template` SET `lootid` = 42222 WHERE `entry` = 42222;
-- *** FIXES FOR THE WETLANDS ***
-- Quest #25722 Sedimentary, My Dear - fix: Adding the Flood Sediment Sample
DELETE FROM `gameobject_loot_template` WHERE `entry` = 29569 AND `item` = 55231;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(29569, 55231, -100, 1, 0, 1, 1);
-- Quest #25726 A Dumpy Job - fix: Adding the Dumpy Level, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 41145 AND `item` = 55234;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(41145, 55234, -9, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 41145 WHERE `entry` = 41145;
-- Quest #25727 Drungeld Glowerglare - fix: Adding the Glowerglare's Beard
DELETE FROM `creature_loot_template` WHERE `entry` = 41151 AND `item` = 55988;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(41151, 55988, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 41151 WHERE `entry` = 41151;
-- *** FIXES FOR THE SOUTERN BARRENS ***
-- Quest #24824 The Disturbed Earth - fix: Adding the Gargantapid's Poison Gland, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 37553 AND `item` = 50385;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(37553, 50385, -39, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 37553 WHERE `entry` = 37553;
-- *** FIXES FOR TANARIS ***
-- Quest #25522 Gargantapid - fix: Adding the Gargantapid's Poison Gland
DELETE FROM `creature_loot_template` WHERE `entry` = 40581 AND `item` = 54855;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(40581, 54855, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 40581 WHERE `entry` = 40581;
-- Quest #25521 I'm With Scorpid - fix: Adding the Duneclaw Stinger. the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 40656 AND `item` = 54856;
DELETE FROM `creature_loot_template` WHERE `entry` = 40717 AND `item` = 54856;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(40656, 54856, -49, 1, 0, 1, 1),
(40717, 54856, -48, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 40656 WHERE `entry` = 40656;
UPDATE `creature_template` SET `lootid` = 40717 WHERE `entry` = 40717;
-- Quest #24931 Gazer Tag - fix: Adding the Ocular Crystal, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 5420 AND `item` = 51793;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(5420, 51793, -40, 1, 0, 1, 1);
-- *** FIXES FOR WINTERSPRING ***
-- Quest #28530 Scalding Signs - fix: Adding the Suspicious Green Sludge, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 48767 AND `item` = 64449;
DELETE FROM `creature_loot_template` WHERE `entry` = 48768 AND `item` = 64449;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(48767, 64449, -44, 1, 0, 1, 1),
(48768, 64449, -41, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 48767 WHERE `entry` = 48767;
UPDATE `creature_template` SET `lootid` = 48768 WHERE `entry` = 48768;
-- Quest #28625 Chop Chop - fix: Adding the Fresh-Cut Frostwood
DELETE FROM `creature_loot_template` WHERE `entry` = 48952 AND `item` = 64587;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(48952, 64587, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 48952 WHERE `entry` = 48952;
-- Quest #28610 Rubble Trouble - fix: Adding the Prime Rubble Chunk, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 48960 AND `item` = 64586;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(48960, 64586, -71, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 48960 WHERE `entry` = 48960;
-- Quest #28837 Altered Beasts - fix: Adding the Mana-Addled Brain, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 49161 AND `item` = 66052;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(49161, 66052, -42, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 49161 WHERE `entry` = 49161;
-- Quest #28537 In Pursuit of Shades - fix: Adding the Shard of the Spiritspeaker
DELETE FROM `creature_loot_template` WHERE `entry` = 48678 AND `item` = 64463;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(48678, 64463, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 48678 WHERE `entry` = 48678;
-- Quest #28540 Doin' De E'ko Magic - fix: Adding the Rimepelt's Heart
DELETE FROM `creature_loot_template` WHERE `entry` = 48765 AND `item` = 64465;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(48765, 64465, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 48765 WHERE `entry` = 48765;
-- Quest #28631 The Perfect Horns - fix: Adding the Icewhomp's Pristine Horns, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 49235 AND `item` = 64664;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(49235, 64664, -57, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 49235 WHERE `entry` = 49235;
-- Quest #28840 Winterwater - fix: Adding the Winterwater, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 50251 AND `item` = 65903;
DELETE FROM `creature_loot_template` WHERE `entry` = 50250 AND `item` = 65903;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(50251, 65903, -28, 1, 0, 1, 1),
(50250, 65903, -24, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 50251 WHERE `entry` = 50251;
UPDATE `creature_template` SET `lootid` = 50250 WHERE `entry` = 50250;
-- Quest #28518 Legacy of the High Elves - fix: Adding the Memory of Zin-Malor
DELETE FROM `creature_loot_template` WHERE `entry` = 48740 AND `item` = 64441;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(48740, 64441, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 48740 WHERE `entry` = 48740;
-- Quest #28479 The Ruins of Kel'Theril - fix: spawn the creature that gives the quest, the creature data is from Skyfire
DELETE FROM creature WHERE guid = 307142;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation,
spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (
307142, 48658, 1, 1, 1, 36232, 0, 6543.91, -4110.53, 663.446, 0.366519,
300, 0, 0, 1962, 1982, 0, 0, 0, 0);
-- Quest Descendants of the Highborn - fix: spawn the creature that gives the quest
DELETE FROM creature WHERE guid = 600000;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation,
spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (
600000, 48659, 1, 1, 1, 36232, 0, 6545.68, -4113.53, 663.78, 0.366519,
300, 0, 0, 1962, 1982, 0, 0, 0, 0);
-- Quest Descendants of the High Elves - fix: spawn the creature that gives the quest
DELETE FROM creature WHERE guid = 600001;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation,
spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (
600001, 48660, 1, 1, 1, 36232, 0, 6543.32, -4106.79, 662.95, 0.366519,
300, 0, 0, 1962, 1982, 0, 0, 0, 0);
-- Quest #25607 Ze Gnomecorder - fix: Adding the Filthy Goblin Technology, the drop % is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 34590 AND `item` = 55144;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(34590, 55144, -55, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 34590 WHERE `entry` = 34590;
-- Quest #13979 The Goblin Braintrust - fix: Adding the Sploder's Head
DELETE FROM `creature_loot_template` WHERE `entry` = 34591 AND `item` = 46768;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(34591, 46768, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 34591 WHERE `entry` = 34591;
-- *** FIXES FOR THE BLASTED LANDS ***
-- Quest #26159 (Alliance) & #25685 (Horde) The First Step - fix: Adding the Snickerfang Hyena Blood, the drop rate is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 5985 AND `item` = 55826;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`)
VALUES (5985, 55826, -69, 1, 0, 1, 1);
-- Quest #26159 (Alliance) & #25685 (Horde) The First Step - fix: Adding the Redstone Basilisk Blood, the drop rate is from wowhead
DELETE FROM `creature_loot_template` WHERE `entry` = 5990 AND `item` = 55827;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`)
VALUES (5990, 55827, -64, 1, 0, 1, 1);
-- Quest #26172 (Alliance) & #25690 (Horde) A Bloodmage's Gotta Eat Too - fix: Adding the Ashmane Steak, the drop rate is from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 5992 AND `item` = 55828;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(5992, 55828, -29, 1, 0, 1, 1);
-- Quest #25716 Cultists at our Doorstep - fix: Adding the Intact Shadowsworn Spell Focus, the drop rate is from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 42297 AND `item` = 57134;
DELETE FROM `creature_loot_template` WHERE `entry` = 42296 AND `item` = 57134;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(42297, 57134, -78, 1, 0, 1, 1),
(42296, 57134, -71, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 42297 WHERE `entry` = 42297;
UPDATE `creature_template` SET `lootid` = 42296 WHERE `entry` = 42296;
-- Quest #26165 (Alliance) & #25692 (Horde) The Vile Blood of Demons - fix: Adding the Vile Demonic Blood, the drop rate is from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 6011 AND `item` = 55991;
DELETE FROM `creature_loot_template` WHERE `entry` = 41253 AND `item` = 55991;
DELETE FROM `creature_loot_template` WHERE `entry` = 6010 AND `item` = 55991;
DELETE FROM `creature_loot_template` WHERE `entry` = 41166 AND `item` = 55991;
DELETE FROM `creature_loot_template` WHERE `entry` = 41165 AND `item` = 55991;
DELETE FROM `creature_loot_template` WHERE `entry` = 41164 AND `item` = 55991;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(6011, 55991, -36, 1, 0, 1, 1),
(41253, 55991, -33, 1, 0, 1, 1),
(6010, 55991, -32, 1, 0, 1, 1),
(41166, 55991, -16, 1, 0, 1, 1),
(41165, 55991, -16, 1, 0, 1, 1),
(41164, 55991, -11, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 6011 WHERE `entry` = 6011;
UPDATE `creature_template` SET `lootid` = 41253 WHERE `entry` = 41253;
UPDATE `creature_template` SET `lootid` = 6010 WHERE `entry` = 6010;
UPDATE `creature_template` SET `lootid` = 41166 WHERE `entry` = 41166;
UPDATE `creature_template` SET `lootid` = 41165 WHERE `entry` = 41165;
UPDATE `creature_template` SET `lootid` = 41164 WHERE `entry` = 41164;
-- *** FIXES FOR ELWYNN FOREST ***
-- Quest #26389 Blackrock Invasion - fix: Adding the Blackrock Orc Weapon
DELETE FROM `creature_loot_template` WHERE `entry` = 42937 AND `item` = 58361;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`)
VALUES (42937, 58361, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 42937 WHERE `entry` = 42937;
-- Quest #26152 Wanted: James Clark - fix: Adding the James Clark's Head
DELETE FROM `creature_loot_template` WHERE `entry` = 13159 AND `item` = 57122;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`)
VALUES (13159, 57122, -100, 1, 0, 1, 1);
-- Quest #86 Pie for Billy - fix: Adding the Tender Boar Meat, the drop rates are from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 113 AND `item` = 60401;
DELETE FROM `creature_loot_template` WHERE `entry` = 524 AND `item` = 60401;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(113, 60401, -21, 1, 0, 1, 1),
(524, 60401, -12, 1, 0, 1, 1);
-- *** FIXES FOR DUSK WOOD ***
-- Quest #26707 A Deadly Vine - fix: Adding the Corpseweed, the drop rates are from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 43732 AND `item` = 60204;
DELETE FROM `creature_loot_template` WHERE `entry` = 45785 AND `item` = 60204;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(43732, 60204, -89, 1, 0, 1, 1),
(45785, 60204, -56, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 43732 WHERE `entry` = 43732;
UPDATE `creature_template` SET `lootid` = 45785 WHERE `entry` = 45785;
-- Quest #26677 Ghoulish Effigy - fix: Adding the Ghoul Rib, the drop rates are from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 1270 AND `item` = 884;
DELETE FROM `creature_loot_template` WHERE `entry` = 570 AND `item` = 884;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(1270, 884, -72, 1, 0, 1, 1),
(570, 884, -6, 1, 0, 1, 1);
-- Quest #26620 Seasoned Wolf Kabobs - fix: Adding the Wolf Skirt Steak, the drop rates are from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 43704 AND `item` = 60989;
DELETE FROM `creature_loot_template` WHERE `entry` = 521 AND `item` = 60989;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(43704, 60989, -31, 1, 0, 1, 1),
(521, 60989, -31, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 43704 WHERE `entry` = 43704;
-- Quest #26623 Dusky Crab Cakes - fix: Adding the Dusky Lump, the drop rates is from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 217 AND `item` = 60988;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(217, 60988, -40, 1, 0, 1, 1);
-- Quest Delivery to Master Harris, Remove Aura so Oliver Harris is shown
UPDATE creature_template_addon SET auras = '' WHERE entry = 43730;
-- Monster Marl Wormthorn must be changed so players can fight him
UPDATE creature_template SET faction_A = 90, faction_H = 90, unit_flags = 0, type_flags = 0, type = 3 WHERE entry = 42334;
-- *** FIXES FOR WESTFALL ***
-- Quest #26230 Feast or Famine - fix: Adding the Coyote Tail, the drop rates is from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 834 AND `item` = 57787;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(834, 57787, -49, 1, 0, 1, 1);
-- Quest #26347 Keeper of the Flame - fix: Adding the Chasm Ooze, the drop rates is from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 42669 AND `item` = 58204;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(42669, 58204, -89, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 42669 WHERE `entry` = 42669;
-- Quest #26286 In Defense of Westfall - fix: Adding the Chasm Ooze, the drop rates is from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 124 AND `item` = 58111;
DELETE FROM `creature_loot_template` WHERE `entry` = 452 AND `item` = 58111;
DELETE FROM `creature_loot_template` WHERE `entry` = 501 AND `item` = 58111;
DELETE FROM `creature_loot_template` WHERE `entry` = 54373 AND `item` = 58111;
DELETE FROM `creature_loot_template` WHERE `entry` = 54372 AND `item` = 58111;
DELETE FROM `creature_loot_template` WHERE `entry` = 54371 AND `item` = 58111;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(124, 58111, -8, 1, 0, 1, 1),
(452, 58111, -7, 1, 0, 1, 1),
(501, 58111, -7, 1, 0, 1, 1),
(54373, 58111, -6, 1, 0, 1, 1),
(54372, 58111, -5, 1, 0, 1, 1),
(54371, 58111, -5, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 54373 WHERE `entry` = 54373;
UPDATE `creature_template` SET `lootid` = 54372 WHERE `entry` = 54372;
UPDATE `creature_template` SET `lootid` = 54371 WHERE `entry` = 54371;
-- Quest #26241 Westfall Stew - fix: Adding the Goretusk Flank, the drop rates is from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 157 AND `item` = 57788;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(157, 57788, -61, 1, 0, 1, 1);
-- Quest #26241 Westfall Stew - fix: Adding the Stringy Fleshripper Meat, the drop rates is from wow head
DELETE FROM `creature_loot_template` WHERE `entry` = 1109 AND `item` = 57786;
DELETE FROM `creature_loot_template` WHERE `entry` = 199 AND `item` = 57786;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(1109, 57786, -56, 1, 0, 1, 1),
(199, 57786, -55, 1, 0, 1, 1);
-- Monster Shatterhorn must be changed so players can fight him
UPDATE creature_template SET unit_flags = 0, type_flags = 0 WHERE entry = 24178;
-- Monster Alystros the Verdant Keeper must be changed so players can fight him
UPDATE creature_template SET unit_flags = 0, type_flags = 0 WHERE entry = 27249;
-- *** FIXES FOR THE WETLANDS ***
-- Fix the quest chain for quests 25723, 25725 & 25735 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 25723 WHERE `Id` = 25725;
UPDATE `quest_template` SET `PrevQuestId` = 25725 WHERE `Id` = 25735;
-- Quest #25725 Fenbush Berries - fix: Adding the Handful of Fenberries
DELETE FROM `gameobject_loot_template` WHERE `entry` = 29571 AND `item` = 55233;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(29571, 55233, -100, 1, 0, 1, 1);
-- *** FIXES FOR DUN MOROGH ***
-- Fix the quest chain for quests 25997, 25998, 26078, 26085, 26094, 26102 & 26112 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 25997 WHERE `Id` = 25998;
UPDATE `quest_template` SET `PrevQuestId` = 25998 WHERE `Id` = 26078;
UPDATE `quest_template` SET `PrevQuestId` = 26078 WHERE `Id` = 26085;
UPDATE `quest_template` SET `PrevQuestId` = 26085 WHERE `Id` = 26094;
UPDATE `quest_template` SET `PrevQuestId` = 26094 WHERE `Id` = 26102;
UPDATE `quest_template` SET `PrevQuestId` = 26102 WHERE `Id` = 26112;
-- Fix quest 433: The Public Servant
SET @SPELL := 77819;
SET @NPC := 41671;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` = @NPC;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @NPC 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
(@NPC,0,0,1,8,0,100,0x01,@SPELL,0,0,0,33,@NPC,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Trapped Miner - On spell hit - Give kill credit for quest 433'),
(@NPC,0,1,0,61,0,100,1,0,0,0,0,41,1000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Trapped Miner - Despawn after 1 seconds');
-- *** FIXES FOR LOCH MODAN ***
-- Fix the quest chain for quests 26845, 26864, 26927, 26928 & 26868 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26845 WHERE `Id` = 26864;
UPDATE `quest_template` SET `PrevQuestId` = 26864 WHERE `Id` = 26927;
UPDATE `quest_template` SET `PrevQuestId` = 26927 WHERE `Id` = 26928;
UPDATE `quest_template` SET `PrevQuestId` = 26928 WHERE `Id` = 26868;
-- Fix the quest chain for quests 13636, 26843 & 26844 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 13636 WHERE `Id` = 26843;
UPDATE `quest_template` SET `PrevQuestId` = 26843 WHERE `Id` = 26844;
-- *** FIXES FOR ELWYNN FOREST ***
-- Fix the quest chain for quests 26393, 26394, 26395 & 26396 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26393 WHERE `Id` = 26394;
UPDATE `quest_template` SET `PrevQuestId` = 26394 WHERE `Id` = 26395;
UPDATE `quest_template` SET `PrevQuestId` = 26395 WHERE `Id` = 26396;
-- Fix the quest chain for quests 26688, 26689, 26690 & 26691 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26688 WHERE `Id` = 26689;
UPDATE `quest_template` SET `PrevQuestId` = 26689 WHERE `Id` = 26690;
UPDATE `quest_template` SET `PrevQuestId` = 26690 WHERE `Id` = 26691;
-- *** FIXES FOR DUSKWOOD ***
-- Fix the quest chain for quests 26653, 26652, 26654, 26655, 26660, 26661, 26676, 26680, 26677, 26681 & 26727 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26653 WHERE `Id` = 26652;
UPDATE `quest_template` SET `PrevQuestId` = 26652 WHERE `Id` = 26654;
UPDATE `quest_template` SET `PrevQuestId` = 26654 WHERE `Id` = 26655;
UPDATE `quest_template` SET `PrevQuestId` = 26655 WHERE `Id` = 26660;
UPDATE `quest_template` SET `PrevQuestId` = 26660 WHERE `Id` = 26661;
UPDATE `quest_template` SET `PrevQuestId` = 26661 WHERE `Id` = 26676;
UPDATE `quest_template` SET `PrevQuestId` = 26676 WHERE `Id` = 26680;
UPDATE `quest_template` SET `PrevQuestId` = 26680 WHERE `Id` = 26677;
UPDATE `quest_template` SET `PrevQuestId` = 26677 WHERE `Id` = 26681;
UPDATE `quest_template` SET `PrevQuestId` = 26681 WHERE `Id` = 26727;
-- Fix the quest chain for quests 26683, 26684 & 26685 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26683 WHERE `Id` = 26684;
UPDATE `quest_template` SET `PrevQuestId` = 26684 WHERE `Id` = 26685;
-- Fix the quest chain for quests 26666, 26667, 26669. 26670, 26671, 26672 & 26674 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26666 WHERE `Id` = 26667;
UPDATE `quest_template` SET `PrevQuestId` = 26667 WHERE `Id` = 26669;
UPDATE `quest_template` SET `PrevQuestId` = 26669 WHERE `Id` = 26670;
UPDATE `quest_template` SET `PrevQuestId` = 26670 WHERE `Id` = 26671;
UPDATE `quest_template` SET `PrevQuestId` = 26671 WHERE `Id` = 26672;
UPDATE `quest_template` SET `PrevQuestId` = 26672 WHERE `Id` = 26674;
-- *** FIXES FOR WETLANDS ***
-- NO UPLOAD - Fix the quest chain for quests 26137, 25395, 25770, 25721, 25727, 25733, 25777 & 25780 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26137 WHERE `Id` = 25395;
UPDATE `quest_template` SET `PrevQuestId` = 25395 WHERE `Id` = 25770;
UPDATE `quest_template` SET `PrevQuestId` = 25770 WHERE `Id` = 25721;
UPDATE `quest_template` SET `PrevQuestId` = 25721 WHERE `Id` = 25727;
UPDATE `quest_template` SET `PrevQuestId` = 25727 WHERE `Id` = 25733;
UPDATE `quest_template` SET `PrevQuestId` = 25733 WHERE `Id` = 25777;
UPDATE `quest_template` SET `PrevQuestId` = 25777 WHERE `Id` = 25780;
-- Fix the quest chain for quests 25722, 25726 & 25734 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 25722 WHERE `Id` = 25726;
UPDATE `quest_template` SET `PrevQuestId` = 25726 WHERE `Id` = 25734;
-- Fix the quest chain for quests 25802, 25803, 25804 & 25805 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 25802 WHERE `Id` = 25803;
UPDATE `quest_template` SET `PrevQuestId` = 25803 WHERE `Id` = 25804;
UPDATE `quest_template` SET `PrevQuestId` = 25804 WHERE `Id` = 25805;
-- Fix the quest chain for quests 26980, 25864 & 25865 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26980 WHERE `Id` = 25864;
UPDATE `quest_template` SET `PrevQuestId` = 25864 WHERE `Id` = 25865;
-- Correct the Half-Buried Barrel, the Damaged Crate and the Sealed Barrel
-- so they can be selectable and they can give their quests. Previous flags entry was 4
UPDATE gameobject_template SET flags = 0 WHERE entry = 261;
UPDATE gameobject_template SET flags = 0 WHERE entry = 142151;
UPDATE gameobject_template SET flags = 0 WHERE entry = 259;
-- Quest #25865 The Mosshide Job - fix: Adding the Ironforge Ingot
DELETE FROM `creature_loot_template` WHERE `entry` = 41390 AND `item` = 56088;
DELETE FROM `creature_loot_template` WHERE `entry` = 41391 AND `item` = 56088;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(41390, 56088, -75, 1, 0, 1, 1),
(41391, 56088, -75, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 41390 WHERE `entry` = 41390;
UPDATE `creature_template` SET `lootid` = 41391 WHERE `entry` = 41391;
-- NO UPLOAD - Fix the quest chain for quests 25866, 25867 & 25868 so they follow the chain correctly
UPDATE `quest_template` SET `NextQuestIDChain` = 25867 WHERE `Id` = 25866;
UPDATE `quest_template` SET `NextQuestIDChain` = 25868 WHERE `Id` = 25867;
UPDATE `quest_template` SET `PrevQuestId` = 25866 WHERE `Id` = 25867;
UPDATE `quest_template` SET `PrevQuestId` = 25867 WHERE `Id` = 25868;
-- Quest #25867 Gnoll Escape - fix: Adding the Trapper's Key
DELETE FROM `creature_loot_template` WHERE `entry` = 41409 AND `item` = 56081;
DELETE FROM `creature_loot_template` WHERE `entry` = 44225 AND `item` = 56081;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(41409, 56081, -100, 1, 0, 1, 1),
(44225, 56081, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 41409 WHERE `entry` = 41409;
UPDATE `creature_template` SET `lootid` = 44225 WHERE `entry` = 44225;
-- NO UPLOAD Quest #25865 Gnoll Escape - Autocomplete
update quest_template set flags = 65536 WHERE id = 25867;
-- Fix the quest chain for quests 25856 & 25857 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 25856 WHERE `Id` = 25857;
-- Fix the quest chain for quests 25854 & 25855 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 25854 WHERE `Id` = 25855;
-- Fix the quest chain for quests 25939 & 26196 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 25939 WHERE `Id` = 26196;
-- Quest #25856 Crocolisk Hides - fix: Adding the Marshy Crocolisk Hide
DELETE FROM `creature_loot_template` WHERE `entry` = 41419 AND `item` = 56087;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(41419, 56087, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 41419 WHERE `entry` = 41419;
-- Quest #25857 Hunting Horrorjaw - fix: Adding the Horrorjaw's Hide
DELETE FROM `creature_loot_template` WHERE `entry` = 41420 AND `item` = 56089;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(41420, 56089, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 41420 WHERE `entry` = 41420;
-- Fix the quest chain for quests 25926 & 25927 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 25926 WHERE `Id` = 25927;
-- Fix the quest chain for quests 26327, 26127, 26128 & 26139 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26327 WHERE `Id` = 26127;
UPDATE `quest_template` SET `PrevQuestId` = 26127 WHERE `Id` = 26128;
UPDATE `quest_template` SET `PrevQuestId` = 26128 WHERE `Id` = 26139;
-- Fix the quest chain for quests 13639, 309 & 13650 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 13639 WHERE `Id` = 309;
UPDATE `quest_template` SET `PrevQuestId` = 309 WHERE `Id` = 13650;
-- NO UPLOAD Quest #13650 Keep Your Hands Off The Goods! - Autocomplete
update quest_template set flags = 65536 WHERE id = 13650;
-- NO UPLOAD Quest #25939 For Peat's Sake - Autocomplete
update quest_template set flags = 65536 WHERE id = 25939;
-- NO UPLOAD Quest #26531 - Autocomplete
update quest_template set flags = 65536 WHERE id = 26868;
-- Fix the quest chain for quests 26981, 25849, 26189 & 26195 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26981 WHERE `Id` = 25849;
UPDATE `quest_template` SET `PrevQuestId` = 25849 WHERE `Id` = 26189;
UPDATE `quest_template` SET `PrevQuestId` = 26189 WHERE `Id` = 26195;
-- Fix the quest chain for quests 26035, 26036, 26037 & 26038 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26035 WHERE `Id` = 26036;
UPDATE `quest_template` SET `PrevQuestId` = 26036 WHERE `Id` = 26037;
UPDATE `quest_template` SET `PrevQuestId` = 26037 WHERE `Id` = 26038;
-- Fix the quest chain for quests 26113, 26110 & 26114 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26113 WHERE `Id` = 26110;
UPDATE `quest_template` SET `PrevQuestId` = 26110 WHERE `Id` = 26114;
-- Fix the quest chain for quests 26528, 26529, 26530, 26531 & 26532 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26528 WHERE `Id` = 26529;
UPDATE `quest_template` SET `PrevQuestId` = 26529 WHERE `Id` = 26530;
UPDATE `quest_template` SET `PrevQuestId` = 26530 WHERE `Id` = 26531;
UPDATE `quest_template` SET `PrevQuestId` = 26531 WHERE `Id` = 26532;
-- Fix the quest chain for quests 26641 & 26643 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26641 WHERE `Id` = 26643;
-- Quest #26528 The Eye of Shadra - fix: Adding the Eye of Shadra
DELETE FROM `gameobject_loot_template` WHERE `entry` = 30439 AND `item` = 58282;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(30439, 58282, -100, 1, 0, 1, 1);
-- Quest #26530 The Shell of Shadra - fix: Adding the Shell of Shadra
DELETE FROM `creature_loot_template` WHERE `entry` = 42919 AND `item` = 58779;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(42919, 58779, -100, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid` = 42919 WHERE `entry` = 42919;
-- NEW FIXES 2013-02-18
-- Fix the quest chain for quests 27775 & 27775 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 27775 WHERE `Id` = 27776;
-- Fix the quest chain for quests 27823 & 27824 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 27823 WHERE `Id` = 27824;
-- Fix the quest chain for quests 26961 & 13647 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26961 WHERE `Id` = 13647;
-- Fix the quest chain for quests 27031, 27032, 27033, 27034, 27035 & 27074 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 27031 WHERE `Id` = 27032;
UPDATE `quest_template` SET `PrevQuestId` = 27032 WHERE `Id` = 27033;
UPDATE `quest_template` SET `PrevQuestId` = 27033 WHERE `Id` = 27034;
UPDATE `quest_template` SET `PrevQuestId` = 27034 WHERE `Id` = 27035;
UPDATE `quest_template` SET `PrevQuestId` = 27035 WHERE `Id` = 27074;
-- Fix the quest chain for quests 27036 & 27037 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 27036 WHERE `Id` = 27037;
-- Fix the quest chain for quests 27025 & 27026 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 27025 WHERE `Id` = 27026;
-- Fix the quest chain for quests 25841 & 25882 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 25841 WHERE `Id` = 25882;
-- Fix the quest chain for quests 27078, 27115 & 27116 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 27078 WHERE `Id` = 27115;
UPDATE `quest_template` SET `PrevQuestId` = 27115 WHERE `Id` = 27116;
-- Quest #27823 A Dwarf's Got Needs - fix: Adding the Shadowstout
DELETE FROM `creature_loot_template` WHERE `entry` IN (2739, 2740) AND `item` = 62510;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(2739, 62510, -90, 1, 0, 1, 2),
(2740, 62510, -90, 1, 0, 1, 2);
-- NO UPLOAD Zul Drak fix object
UPDATE gameobject_template SET flags = 0 WHERE entry = 190535;
UPDATE gameobject_template SET flags = 0 WHERE entry = 187565;
-- NO UPLOAD - It's Raid Night Every Night - Autocomplete
update quest_template set flags = 65536 WHERE id = 25932;
-- NO UPLOAD - Rams on the Lam - Autocomplete
update quest_template set flags = 65536 WHERE id = 25905;
-- NO UPLOAD - Entombed in Ice - Autocomplete
update quest_template set flags = 65536 WHERE id = 25978;
-- NO UPLOAD - Strike from Above - Autocomplete
update quest_template set flags = 65536 WHERE id = 25841;
-- Fix quest 28868: The View from Down Here
SET @SPELL := 93773;
SET @NPC := 41251;
SET @NPC_REWARD := 50606;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` = @NPC;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @NPC 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
(@NPC,0,0,1,8,0,100,0x01,@SPELL,0,0,0,33,@NPC_REWARD,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Frostmane Builder - On spell hit - Give kill credit for quest 28868'),
(@NPC,0,1,0,61,0,100,1,0,0,0,0,41,3000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Frostmane Builder - Despawn after 3 seconds');
-- Fix quest 25867: Gnoll Escape
SET @NPC := 41438;
SET @GAMEOBJ := 203282;
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry` = @GAMEOBJ;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @GAMEOBJ AND `source_type`=1;
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
(@GAMEOBJ,1,0,0,70,0,100,0,2,0,0,0,33,@NPC,0,0,0,0,0,7,0,0,0,0,0,0,0,'Gnoll Cage - On activate - Give credit for quest 25867');
-- Fix the quest chain for quests 24469 & 24470 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 24469 WHERE `Id` = 24470;
-- Fix the quest chain for quests 24474 & 24475 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 24474 WHERE `Id` = 24475;
-- Fix the quest chain for quests 24487 & 182 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 24487 WHERE `Id` = 182;
-- Fix the quest chain for quests 24477 & 24486 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 24477 WHERE `Id` = 24486;
-- Fix the quest chain for quests 218 & 24490 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 218 WHERE `Id` = 24490;
-- Fix the quest chain for quests 24491 & 24492 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 24491 WHERE `Id` = 24492;
-- NO UPLOAD - Trolling for information - Autocomplete
update quest_template set flags = 65536 WHERE id = 24489;
-- Previous Value was 768
UPDATE creature_template SET unit_flags = 0 where entry = 41202;
-- NO UPLOAD - Kharanos Report - Autocomplete
update quest_template set flags = 65536 WHERE id = 313;
-- NO UPLOAD - The Fight Continues - Autocomplete
update quest_template set flags = 65536 WHERE id = 26208;
-- NO UPLOAD - A Job for the multi bot - Autocomplete
update quest_template set flags = 65536 WHERE id = 26205;
-- NO UPLOAD - 26364 - Down with Crushcog! - Autocomplete
update quest_template set flags = 65536 WHERE id = 26364;
-- NO UPLOAD - 28002 - Crisis Management - Autocomplete
update quest_template set flags = 65536 WHERE id = 28002;
-- NO UPLOAD - 27926 - Eastern Hospitality - Autocomplete
update quest_template set flags = 65536 WHERE id = 27926;
-- NO UPLOAD - 28134 - Impending Retribution - Autocomplete
update quest_template set flags = 65536 WHERE id = 28134;
-- NO UPLOAD - Missing in action is out
UPDATE `quest_template` SET `PrevQuestId` = 26285 WHERE `Id` = 26318;
update quest_template set Level = 90, MinLevel = 90 WHERE id = 26284;
-- NO UPLOAD - Quest 26318 - Finishin' the job
update quest_template set RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0 WHERE id = 26318;
-- Fix quest 27671: See to the Survivors
SET @SPELL := 86264;
SET @NPC := 46268;
SET @NPC_REWARD := 46268;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` = @NPC;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @NPC 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
(@NPC,0,0,1,8,0,100,0x01,@SPELL,0,0,0,33,@NPC_REWARD,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Survivor - On spell hit - Give kill credit for quest 27671'),
(@NPC,0,1,0,61,0,100,1,0,0,0,0,41,2000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Survivor - Despawn after 2 seconds');
-- Fix quest 14077: The Light's Mercy
SET @SPELL := 66390;
SET @NPC := 34852;
SET @NPC_REWARD := 34852;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` = @NPC;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @NPC 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
(@NPC,0,0,1,8,0,100,0x01,@SPELL,0,0,0,33,@NPC_REWARD,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Slain Tualiq Villager - On spell hit - Give kill credit for quest 14077'),
(@NPC,0,1,0,61,0,100,1,0,0,0,0,41,2000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Slain Tualiq Villager - Despawn after 2 seconds');
-- Fix quest 14107: The Fate Of The Fallen
SET @SPELL := 66719;
SET @NPC := 32149;
SET @NPC_REWARD := 35055;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` = @NPC;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @NPC 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
(@NPC,0,0,1,8,0,100,0x01,@SPELL,0,0,0,33,@NPC_REWARD,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Fallen Hero''s Spirit - On spell hit - Give kill credit for quest 14107'),
(@NPC,0,1,0,61,0,100,1,0,0,0,0,41,2000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Fallen Hero''s Spirit - Despawn after 2 second');
-- Fix the quest chain for quests 26208, 26566, 26222 & 26205 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26208 WHERE `Id` = 26566;
UPDATE `quest_template` SET `PrevQuestId` = 26566 WHERE `Id` = 26222;
UPDATE `quest_template` SET `PrevQuestId` = 26222 WHERE `Id` = 26205;
-- Fix the quest chain for quests 26318, 26329 & 26331 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26318 WHERE `Id` = 26329;
UPDATE `quest_template` SET `PrevQuestId` = 26329 WHERE `Id` = 26331;
-- Fix the quest chain for quests 26339, 26342 & 26364 so they follow the chain correctly
UPDATE `quest_template` SET `PrevQuestId` = 26339 WHERE `Id` = 26342;
UPDATE `quest_template` SET `PrevQuestId` = 26342 WHERE `Id` = 26364;
-- Fix quest 26333: No Tanks!
SET @SPELL := 79751;
SET @NPC := 42224;
SET @NPC_REWARD := 42224;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` = @NPC;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @NPC 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
(@NPC,0,0,1,8,0,100,0x01,@SPELL,0,0,0,33,@NPC_REWARD,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Repaired Mechano-Tank - On spell hit - Give kill credit for quest 26333'),
(@NPC,0,1,0,61,0,100,1,0,0,0,0,41,1000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Repaired Mechano-Tank - Despawn after 1 second');
-- Fix quest 26342: Paint It Black
SET @SPELL := 79781;
SET @NPC := 42291;
SET @NPC_REWARD := 42796;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` = @NPC;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @NPC 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
(@NPC,0,0,0,8,0,100,0x01,@SPELL,0,0,0,33,@NPC_REWARD,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Crushcog Sentry-Bot - On spell hit - Give kill credit for quest 26342');
-- NO UPLOAD Quest 309 - Protecting the shipment - Hide the quest
update quest_template set minlevel = 12, RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0, RequiredNpcOrGo2 = 0, RequiredNpcOrGoCount2 = 0, RequiredNpcOrGo3 = 0, RequiredNpcOrGoCount3 = 0, flags = 8 WHERE id = 309;
DELETE FROM creature_involvedrelation WHERE id = 1344 AND quest = 309;
DELETE FROM creature_questrelation WHERE id = 2057 AND quest = 309;
INSERT INTO creature_involvedrelation (id, quest) VALUES (1344, 309);
-- *** Arathi Highlands ***
-- Calamoth Ashbeard, needs to be hostile and quest needs to be corrected
UPDATE creature_template SET faction_A = 834, faction_H = 834, gossip_menu_id = 0, npcflag = 0, unit_flags = 0, unit_flags2 = 0, dynamicflags = 0, type = 6, type_flags = 0, lootid = 0, VehicleId = 0, minlevel = 25, maxlevel = 25 WHERE entry = 41522;
UPDATE quest_template SET RequiredNpcOrGo1 = 41522, RequiredNpcOrGoCount1 = 1, flags = 8 WHERE id = 26128;
-- Correct the game objects so they can start / end quests. Previous flags entry was 4
UPDATE gameobject_template SET flags = 0 WHERE entry = 138492;
UPDATE gameobject_template SET flags = 0 WHERE entry = 2701;
UPDATE gameobject_template SET flags = 0 WHERE entry = 2702;
UPDATE gameobject_template SET flags = 0 WHERE entry = 2688;
UPDATE gameobject_template SET flags = 0 WHERE flags = 4 AND entry = 2713;
UPDATE gameobject_template SET flags = 0 WHERE flags = 4 AND entry = 156561;
UPDATE gameobject_template SET flags = 0 WHERE flags = 4 AND entry = 203734;
-- Farmer Fulbrow and investigator and westfall, Remove Aura so the NPCs are shown
UPDATE creature_template_addon SET auras = '' WHERE entry = 237;
UPDATE creature_template_addon SET auras = '' WHERE entry = 42308;
-- Fix Griphon Master Gyll so you can catch a ride
UPDATE creature_template SET gossip_menu_id = 0 WHERE name = 'Gyll';
-- *** FIXES FOR THE HINTERLANDS ***
-- Fix Deathstalker invader so they are hostile with the correct level
UPDATE creature_template SET minlevel = 34, maxlevel = 34, faction_A = 14, faction_H = 14 WHERE entry = 43541;
-- Quest #27626 fix : The Highvale Documents. Add the quest loot
DELETE FROM `creature_loot_template` WHERE `entry` = 43541 AND `item` = 61972;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (43541, 61972, -33, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry` = 43541 AND `item` = 61973;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (43541, 61973, -33, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry` = 43541 AND `item` = 61974;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (43541, 61974, -33, 1, 0, 1, 1);
-- Quest #26485 fix : Snapjaws, Lad! Add the Snapjaw Gizzard loot.
DELETE FROM `creature_loot_template` WHERE `entry` = 2505 AND `item` = 58867;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(2505, 58867, -75, 1, 0, 1, 1);
-- Quest #26517 fix : Summit of Fate. Add the Spider Idol loot.
DELETE FROM `creature_loot_template` WHERE `entry` = 42879 AND `item` = 58228;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(42879, 58228, -100, 1, 0, 1, 1);
-- Quest #26517 fix : Skittering Spiderling. Add the Skittering Spiderling loot.
UPDATE `creature_template` SET `lootid` = 42689 WHERE `entry` = 42689;
DELETE FROM `creature_loot_template` WHERE `entry` = 42689 AND `item` = 58120;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(42689, 58120, -100, 1, 0, 1, 1);
-- Quest #26521 - Faces of Evil. Autocomplete
update quest_template set RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0, RequiredNpcOrGo2 = 0, RequiredNpcOrGoCount2 = 0, RequiredNpcOrGo3 = 0, RequiredNpcOrGoCount3 = 0 WHERE id = 26521;
-- Quest #26546 - Razorbeak friends, do not allow the player to do this quest so the other one in the multi select must be picked
update quest_template set Level = 90, MinLevel = 90 WHERE id = 26546;
-- Class quest cannot be done so we hide them
update quest_template set Level = 90, MinLevel = 90 WHERE Title = 'Steady Shot';
update quest_template set Level = 90, MinLevel = 90 WHERE Title = 'Charge';
-- This quest doesn't work at all and leads to other bugged quests so we hide it
update quest_template set Level = 90, MinLevel = 90 WHERE Title = 'The Ultrasafe Personnel Launcher';
DELETE FROM creature_questrelation WHERE quest = 25839;
-- Update the flag so the loose dirt game object can give its quests
UPDATE gameobject_template SET flags = 0 WHERE entry = 20985;
-- Quest #27188 What's Haunting Witch Hill?, change to the correct mob for the kill
UPDATE quest_template SET RequiredNpcOrGo1 = 23554 WHERE id = 27188;
-- Update Zelfrax so he can be attacked
UPDATE creature_template SET unit_flags = 32768, unit_flags2 = 2048, npcflag = 0, faction_A = 834, faction_H = 834, lootid = 23864 WHERE entry = 23864;
-- Fix quest 27245: Prisoners of the Grimtotems
SET @NPC := 23720;
SET @GAMEOBJ := 186287;
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry` = @GAMEOBJ;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @GAMEOBJ AND `source_type`=1;
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
(@GAMEOBJ,1,0,0,70,0,100,0,2,0,0,0,33,@NPC,0,0,0,0,0,7,0,0,0,0,0,0,0,'Blackhoof Cage - On activate - Give credit for quest 27245');
-- Update the blackhoof cage game object so it closes back after 60 seconds
UPDATE gameobject_template SET data2 = 60000 WHERE entry = 186287;
-- Update Balos Jacken so alliance players can get and complete its quests
UPDATE creature_template SET faction_A = 1077, faction_H = 1077 WHERE entry = 5089;
-- Update the item quests for Horde only
UPDATE quest_template SET RequiredRaces = 690 WHERE Id IN (27254, 27255, 27256, 27257, 27260, 27244, 27259);
-- Quest #25112 - Butcherbot, change the NPC to get the correct kill ID
UPDATE quest_template SET RequiredNpcOrGo1 = 5419 WHERE Id = 25112;
-- Quest #25111 - Scavengers Scavenged, change the NPC to get the correct kill ID
UPDATE quest_template SET RequiredNpcOrGo1 = 5429 WHERE Id = 25111;
-- Quest #25115 - Blisterpaw Butchery, change the NPC to get the correct kill ID
UPDATE quest_template SET RequiredNpcOrGo1 = 5426 WHERE Id = 25115;
-- Quest #24951 - A Great Idea, change the NPC to get the correct kill ID
UPDATE quest_template SET RequiredNpcOrGo1 = 5451 WHERE Id = 24951;
-- Quest #24933 Chicken of the Desert - Add the loot to the NPC
DELETE FROM `creature_loot_template` WHERE `entry` = 5427 AND `item` = 51778;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(5427, 51778, -75, 1, 0, 1, 1);
-- Quest #25063 Terrapination - Add the loot to the NPC
DELETE FROM `creature_loot_template` WHERE `entry` = 5431 AND `item` = 52282;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(5431, 52282, -75, 1, 0, 1, 1);
-- Update the item quests for Horde only
UPDATE quest_template SET RequiredRaces = 690 WHERE Id IN (25107, 24905);
-- Update the item quests for Alliance only
UPDATE quest_template SET RequiredRaces = 1101 WHERE Id IN (25421);
-- NPC Mazoga, remove aura so the NPC will be visible
UPDATE creature_template_addon SET auras = '' WHERE entry = 38927;
-- Quest #25021 Blood to Thrive - Add the loot to the NPC
DELETE FROM `creature_loot_template` WHERE `entry` IN (5646, 5647, 5645) AND `item` = 52064;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(5646, 52064, -90, 1, 0, 1, 1),
(5647, 52064, -90, 1, 0, 1, 1),
(5645, 52064, -90, 1, 0, 1, 1);
-- Monster Mazoga must be changed so players can fight him
UPDATE creature_template SET faction_A = 90, faction_H = 90 WHERE entry = 38968;
-- Quest #25032 - Secrets in the Oasis, change the NPC to get the correct kill ID
UPDATE quest_template SET RequiredNpcOrGo1 = 38968 WHERE Id = 25032;
-- NPC Kelsey Steelspark, remove aura so the NPC will be visible
UPDATE creature_template_addon SET auras = '' WHERE entry = 38535;
-- NPC Steamwheedle Survivor must be changed so players can fight him
UPDATE creature_template SET faction_A = 90, faction_H = 90 WHERE entry = 38571;
-- Quest #24910 & 25050 - Rocket Rescue, change the NPC to get the correct kill ID
UPDATE quest_template SET RequiredNpcOrGo1 = 38571 WHERE Id IN (24910, 25050);
-- *** FIXES FOR TANARIS END ***
Status :Not yet tested by me
29-04-13, 13:51
Achernar_Altair
[SQL]Fix For All Quest Chains
Description :
This script fixes all the quest chains from Cataclysm. This prevents a lot of “You don’t meet the requirement for this quest” errors. It recreates the quest chains based on wowhead data and gives a way better questing experience to your players. This script is also being reviewed by Trinity right now.
seperti Cata Mobs Loot, very long script jadi g bisa dipost disini
Status : Not yet tested by me
29-04-13, 14:11
Achernar_Altair
[SQL]Kezan Fix
Description :
his script corrects all the quests and allow the player to leave the island on the last quest on the dock. The last quest shows the destruction of Kezan cutscene and teleport the player to the Durotar docks since the Lost Isles are not yet implemented. This script only works with a recent core or repack.
-- Quest 14125 - Name: 447 - Remove the last objective, it cannot be done
update quest_template set RequiredNpcOrGo4 = 0, RequiredNpcOrGoCount4 = 0 WHERE id = 14125;
-- change partygoers so they can be attacked
update creature_template set faction_A = 7, faction_H = 7, npcflag = 2, unit_flags = 32768 WHERE entry = 35175;
-- change defiant troll so they can be attacked
update creature_template set faction_A = 7, faction_H = 7, npcflag = 2, unit_flags = 32768 WHERE entry = 34830;
-- kajamite chunk needs to be selectable
update gameobject_template set flags = 0, data14 = 0 where entry = 195492;
-- Quest 26712 - Off to the bank - Hide quest, it's duplicated
update quest_template set Level = 90, MinLevel = 90 WHERE id = 26711;
update quest_template set Level = 1, MinLevel = 1 WHERE id = 26712;
-- Quest 14109 - The new you - Hide quest, it's duplicated
update quest_template set Level = 90, MinLevel = 90 WHERE id = 14110;
update quest_template set Level = 1, MinLevel = 1 WHERE id = 14109;
-- Quest 14123, the 3 game objects needs to be selectable to get the items from them and complete the quest
update gameobject_template set flags = 0, data0 = 43, data14 = 0, data3 = 1 where entry = 195515; -- Maldy's Falcon
update gameobject set id = 195515 where id = 195522;
update gameobject_template set flags = 0, data0 = 43, data14 = 0, data3 = 1 where entry = 195516; -- The Goblin Lisa
update gameobject set id = 195516 where id = 195523;
update gameobject_template set flags = 0, data0 = 43, data14 = 0, data3 = 1 where entry = 195518; -- The Ultimate Bomb
update gameobject set id = 195518 where id = 195524;
-- Change the NPC so the quest can be completed correctly
update creature_involvedrelation set id = 39615 where id = 35222 and quest = 14116;
update creature_involvedrelation set id = 36403 where id = 35222 and quest = 14126;
update creature_template set npcflag = 3 where entry in (39615, 36403);
-- Quest #14126 - Life Saving - When the quest ends, warp to Durotar
SET @NPC := 36403;
SET @QUEST := 14126;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` = @NPC;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @NPC 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
(@NPC, 0, 0, 0, 20, 0, 100, 0, @QUEST, 0, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 8, 0, 0, 1440.86, -5019.81, 12.03, 1.68, 'Teleport to Durotar');
Status : Not yet tested by me
29-04-13, 14:19
Achernar_Altair
[SQL]Death Knights Fix for Quest dan Runeforge
Description :
This script corrects all the Runeforge for Death Knights in Ebon Hold. It also fixes the starting quest chains so players can start Death Knights, do the starting area quests, gain the DK quest bonus and play normally after that.
-- Quest 13166, The battle for the Ebon Hold
update quest_template set RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0, RequiredNpcOrGo2 = 0, RequiredNpcOrGoCount2 = 0, RequiredNpcOrGo3 = 0, RequiredNpcOrGoCount3 = 0, RequiredNpcOrGo4 = 0, RequiredNpcOrGoCount4 = 0, RequiredItemId1 = 0, RequiredItemCount1 = 0, RequiredItemId2 = 0, RequiredItemCount2 = 0, RequiredItemId3 = 0, RequiredItemCount3 = 0, RequiredItemId4 = 0, RequiredItemCount4 = 0 WHERE id = 13166;
-- Quest 12698, Stop the chain there, it doesn't work very well
update quest_template set Level = 90, MinLevel = 90 WHERE id = 12698;
update quest_template set NextQuestIdChain = 0 where NextQuestIdChain = 12698;
Status : Not yet tested by me
That's all for now, sisanya belakangan :)
semoga aja kepake biar bisa cepet seneng2 dan mata saya g bete lihat keluhan ini itu di ingame -_-'a
