Selamat Siang Tim GM yang terhormat
Menindaklanjuti dari Thread http://forum.indogamers.com/showthread.php?t=529413
Saya mencoba membantu mencari dari berbagai sumber atau meramu script-script untuk fix quest yang bug, mohon maaf sebelumnya apabila thread ini semakin merepotkan tim gm dengan menambah list pekerjaanya serta script-script yang belum lengkap isinya.
Mudah-mudahan dengan thread ini dapat membantu kemajuan server AMPM Road to Loremaster
Berikut Daftar Quest beserta unofficial Fixingnya, mohon di cek apakah berfungsi dan aman bagi server apabila di apply
Apabila ada dari kawan-kawan yang ingin menambahkan, mengkoreksi script, ataupun request quest yg bug silahkan nanti kalau pas di taruh di pejawan hehe
Trims very much
UPDATE TERBARU <<<<<<
Kebetulan baru 2 Map coz harus pergi mendadak ..
HOWLING FJORD
Thread yg berkaitan : http://forum.indogamers.com/showthread.php?t=516727
Spoiler untuk HOWLING FJORD :
- The Rune of Command FIXED
NPC : Longrunner Pembe - Prospector Belvar
Faction : A/H
Error : item q-nya Rune of Command nya, ga kelarin objektif Test Rune of Command meski uda dipake ke giant-nya,
ids : 11352 H, 11348 A
sumber : http://pastebin.com/hv9eBqWCCode:-- Fix for quest The Rune of Command (Alliance & Horde) (by Bastek) UPDATE creature_template SET unit_flags = 4096 WHERE entry = 24345; UPDATE quest_template SET ReqItemId1 = 33796, ReqItemCount1 = 1, ReqSourceId3 = 0, ReqSpellCast1 = 49859 WHERE entry IN (11352, 11348); DELETE FROM spell_script_target WHERE entry = 49859 AND targetEntry = 24345; INSERT INTO spell_script_target VALUES (49859, 1, 24345);- Eyes of the Eagle FIXED
NPC: Ulfang
Faction: Both
Error : Talonshrike's Egg tidak ada di TKP untuk memanggil Talonshrike turun.
Solusi ALternatif :
a. Spawn Object Talonshrike's Egg to trigger npc down
id : 186814
Lokasi : Howling Fjord [41.5, 37.7]
b. Attackable TalonshrikeCode:DELETE FROM `gameobject` WHERE `id` IN (186814); INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `spawntimesecs`, `spawndist`) VALUES (unknown , 186814, 571 , 1 , 1, unknown , unknown, unknown, 150 , 0 )
id : 24518
Lokasi : Howling Fjord [41.5, 37.7]
Code:UPDATE `creature_template` SET `mechanic_immune_mask` = 1 WHERE `entry` = 24518;- The Slumbering KingFIXED
NPC : Mezhen's Writings
Faction : Horde / Alliance
Error : NPC target Quest Queen Angerboda
telah dispawnkan di tkp namun friendly status
Code:UPDATE `creature_template` SET `faction_A`=14, `faction_H`=14, `mechanic_immune_mask` = 1 WHERE `entry` = 24023;- The Frost Wyrm and its MasterFIXED
NPC : Celea Frozenmane
Faction : Horde / ALliance
Error : NPC Target Quest Wyrmcaller Vile
tidak ada di TKP, sedangkan Glacion ada
Muter muter di atas
Info NPC :
id : 24029
map : 571 ( Northrend )
Coordinat map : Gjalerbron, Howling fjord, [36.6 , 7.4]
curhealth : 9,291
curmana : 3,231
Code:DELETE FROM `creature` WHERE `id` IN (24029); INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `spawntimesecs`, `spawndist`, `curhealth`, 'curmana') VALUES (unknown , 24029, 571 , 1 , 1, unknown , unknown, unknown, 180 , 0 , 9291 , 3231) -add template- UPDATE `creature_template` SET `faction_A`=14, `faction_H`=14, `mechanic_immune_mask` = 1 WHERE `entry`=24209;- Nama Quest : Draconis Gastritis FIXED
NPC : Plaguebringer Tillinghast
Faction : Horde
Error : meat item q-nya bisa di-use,
kluar kyk boneka golem tapi ga complete, ga ada naga yg turun
Sumber : http://pastebin.com/r0E7MX8PCode:UPDATE `creature_template` SET `modelid2`='0', `faction_H`='14' WHERE `entry`='24170';- Nama Quest : A Carver and a Croaker FIXED
NPC : Handsome Terry
Faction : AH
Error : objektifnya 2, bawa piso sama bawa kodok, pisonya tinggal beli, kodoknya ga bs diloot,
fIx Code : Biar Kodok bisa di loot
sumber : http://ytdb.ru/archive/index.php/t-7510.htmlCode:UPDATE `quest_template` SET `ReqItemId1` = 0, `ReqItemCount1` = 0, `ReqCreatureOrGOId1` = 26503, `ReqCreatureOrGOCount1` = 1 WHERE `entry` = 11476;- Nama Quest : Gambling Debt FIXED
NPC : Taruk
Faction : AH
Error : "Silvermoon" Harry is supposed to turn friendly once more at a low % of health. He'll say, "I'll pay! I'll pay! Eeeek! Please don't hurt me!" and stop attacking. Talk to him once more and use the chat option to obtain your payment.
Fix : Item Quest "Silvermoon" Harry's Debt Di jual di vendor "Silvermoon Harry
sumber : http://ytdb.ru/archive/index.php/t-7510.htmlCode:DELETE FROM `npc_vendor` WHERE (`entry`=24539) AND (`item`=34115); INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (24539, 34115, 0, 0, 0);
GRIZZLY HILLS
Thread yg berkaitan : http://forum.indogamers.com/showthread.php?t=517125
Spoiler untuk GRIZZLY HILLS :
- Rallying the TroopsFIXED
NPC : Kurun
Faction : Horde / ALliance
Error : Item Quest Shard of the Earth dapat digunakan pada Grizzly Hills Giants namun quest tidak terhitung / tidak selesai
Fix Code : fixed use item on specified npcs
sumberCode:UPDATE `quest_template` SET `ReqSpellCast1`='47394' WHERE `entry`='12070';- Loken's OrdersFIXED
NPC : Scout Vor'takh
Faction : HOrde
Error : Overseer Disguise Kit dapat digunakan namun ketika klik object Loken's Pedestal di lokasi tidak terjadi event
Solusi alternatif : auto complete ketika kita klik object Loken's Pedestal
fiX cODE : Event & Quest
SUmber : http://pastebin.com/bSdGrbnTCode:-- Fix for quests 12185 (Alliance) and 12203 (Horde) (by Bastek) LOKEN ORDER GRIZZLY UPDATE creature_template SET AIName = 'EventAI' WHERE entry = 27212; UPDATE gameobject_template SET data2 = 60046 WHERE entry = 188596; DELETE FROM event_scripts WHERE id = 60046; INSERT INTO event_scripts VALUES (60046, 0, 10, 27212, 120000, 0, 0, 0, 0, 0, 0, 0, 3404.324219, -5394.511230, 270.199677, 1.148978, 'Image of Loken - Spawn'), (60046, 22, 8, 27212, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Loken Podest - Quest Credit'); DELETE FROM creature_ai_scripts WHERE creature_id = 27212; INSERT INTO creature_ai_scripts VALUES (2721201, 27212, 1, 0, 100, 0, 1000, 1000, 0, 0, 1, -2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Image of Loken - Text'), (2721202, 27212, 1, 0, 100, 0, 6000, 6000, 0, 0, 1, -2001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Image of Loken - Text'), (2721203, 27212, 1, 0, 100, 0, 11000, 11000, 0, 0, 1, -2002, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Image of Loken - Text'), (2721204, 27212, 1, 0, 100, 0, 16000, 16000, 0, 0, 1, -2003, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Image of Loken - Text'), (2721205, 27212, 1, 0, 100, 0, 21000, 21000, 0, 0, 1, -2004, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Image of Loken - Text'); DELETE FROM creature_ai_texts WHERE entry IN (-2000, -2001, -2002, -2003, -2004); INSERT INTO creature_ai_texts VALUES (-2000, 'You''re late, overseer.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL), (-2001, 'Destiny will not wait. Your craftsmen must increase their production of the war golems before the stone giant leader and his army reach Ulduar.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL), (-2002, 'Tell your rune-smiths to continue converting what stone giants you can. Those that will not submit must be destroyed.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL), (-2003, 'If the stone giants interfere with our work at Ulduar, I will hold you and your thane responsible. Mortal must not be allowed to come to the aid of the giants.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL), (-2004, 'Return to your duties, overseer. Be certain to impress upon your workers the urgency of their tasks.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL);- Bringing Down the Iron ThaneFIXED
NPC : Prospector Rokar
Faction : HOrde
Error : Missing NPC target quest Iron Thane Furyhammer tidak ada di lokasi
Info Lokasi : Dun Argol, Grizzly Hills [76.6, 63.6]
Fix Code : Spawn NPC di TKP
Code:-add npc- DELETE FROM `creature` WHERE `id` IN (26405); INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `spawntimesecs`, `spawndist`, `curhealth`, 'curmana') VALUES (unknown , 26405, 571 , 1 , 1, unknown , unknown, unknown, 180 , 0 , 12762 , 3561) -add template- UPDATE `creature_template` SET `minlevel`=75, `maxlevel`=75, `faction_A`=14, `faction_H`=14, `mechanic_immune_mask` = 1 WHERE `entry`=26405;- Dun-da-Dun-tah!
NPC : Harrison Jones
Faction : Horde / ALlliance
Error : Event Escort Quest tidak mulai
Fix Code : Blizzlike Event
Code:Panjang banget Code nya, maaf bingung misahin sql sama cpp nya bang Link Script From This Issues Link DOwnload File
DRAGONBLIGHT
Thread yg berkaitan : http://forum.indogamers.com/showthread.php?t=516502
Spoiler untuk DRAGONBLIGHT :
- No Mercy for the Captured
NPC : Spy Mistress Repine
Faction : Horde
Error : Objective Quest, Deathguard Schneider, Senior Scrivener Barriga, Engineer Burke, Chancellor Amai tidak dapat di speak lalu di slain.
Fix Code : script npcs made neutral for Horde
Code:UPDATE `creature_template` SET `faction_H`='7' WHERE `entry` IN ('27376','27378','27379','27381');- Wanton WarlordFIXED
NPC : Aurastrasza
Faction : Horde / Alliance
Error : Item Quest Emblazoned Battle Horn dapat digunakan diTKP namun Grom'thar the Thunderbringer tidak spawn untuk meloot Grom'thar's Head
fIx Code : Spawnkan secara tetap grom'thar the thunderbringer di lokasi Dragonblight[57.0, 76.4]
Code:-add npc- DELETE FROM `creature` WHERE `id` IN (27002); INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `spawntimesecs`, `spawndist`, `curhealth`) VALUES (unknown , 27002, 571 , 1 , 1, unknown , unknown, unknown, 180 , 0 , 20564) -add template- UPDATE `creature_template` SET `minlevel`=74, `maxlevel`=74, `faction_A`=14, `faction_H`=14, `mechanic_immune_mask` = 1 WHERE `entry`=27002;
ZULDRAK
Thread yg berkaitan : http://forum.indogamers.com/showthread.php?t=517355
Spoiler untuk ZULDRAK :
- I Sense a Disturbance
NPC: Har'koa
Faction: Both
Eror: harusnya pas ambil quest ngomong lagi trus di kasi kucing dan ga lama complete, tapi pas ambil quest kita ga bisa ngomong lagi, jadinya ga dapet kucing dari harkoa jadinya ga bisa compelete quest, jadinya manyun
Fix Code : AutoComplete
Code:UPDATE `quest_template` SET `method`='0', `RewXPId`='2' WHERE `entry`='12665';
BOREAN TUNDRA
Thread yg berkaitan : http://forum.indogamers.com/showthread.php?t=499389
Spoiler untuk BOREAN TUNDRA :
- Blending InFIXED
NPC: Chieftain Wintergale
Faction: Horde
Eror: Spire of the Blood ga bisa di SCOUT, yg 2 sisanya bisa
sumber : https://github.com/TrinityCore/TrinityCore/issues/5979Code:- Fix [Q]{A/H} - Blending In ID: 11633 SET @Blood := 4135; SET @Decay := 4136; SET @Pain := 4137; SET @ReqAura := 45614; SET @Quest := 11633; SET @Credit1 := 45627; SET @Credit2 := 45628; SET @Credit3 := 45629; -- Remove old EAI + mobs DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (25471,25472,25473); DELETE FROM `creature` WHERE `id` IN (25471,25472,25473); -- Set spells to trigger on players under certain conditions for certain subareas DELETE FROM `spell_area` WHERE `spell`=@Credit2; INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES (@Credit2,@Blood,@Quest,1,@Quest,@ReqAura,0,2,1); DELETE FROM `spell_area` WHERE `spell`=@Credit1; INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES (@Credit1,@Decay,@Quest,1,@Quest,@ReqAura,0,2,1); DELETE FROM `spell_area` WHERE `spell`=@Credit3; INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES (@Credit3,@Pain,@Quest,1,@Quest,@ReqAura,0,2,1);
STORM PEAKS
Thread yg berkaitan : http://forum.indogamers.com/showthread.php?t=517527
Spoiler untuk STORM PEAKS :
ICECROWN
Thread yg berkaitan : http://forum.indogamers.com/showthread.php?t=518734
Spoiler untuk ICECROWN :
SHOLAZAR BASIN
Thread yg berkaitan : http://forum.indogamers.com/showthread.php?t=517345
Spoiler untuk SHOLAZAR BASIN :
Tambahan Unofficial fixing dari kawan - kawan
Ikutan nimbrung kk noray
Jujur saya buta soal coding scripting dkk hehe (mungkin ada yg mau ngajarin sayah dasar2 mengenai itu ^^).
Saya lagi iseng2 browsing trus nemu code MySQL untuk fix beberapa quest.
Mohon Tim GM untuk mengecek code2 berikut, mudah2an tepat sasaran dan bisa di implementasikan jika code2 ini aman dan dapat berfungsi di server AMPM dan saya mohon maaf jika code2 yang saya dapatkan tersebut ternyata tidak tepat sasaran.
Terima kasih
Zul Drak
Spoiler untuk Zul Drak :
Quest : I Sense a Disturbance
NPC : Har'koa
Faction : Both
Error : Saat kita mendapatkan quest dan kembali bicara pada Har'koa, Har'koa's Kitten tidak spawn.
Quest : Argent Crusade, We Are Leaving!Code:-- Fix for the quest I Sense a Disturbance UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 28671; INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (2867100, 28671, 4, 0, 100, 0, 0, 0, 0, 0, 15, 12665, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Quest complete.');
NPC : Sergeant Stackhammer
Faction : Both
Error : Argent Soldier tidak dapat diajak bicara.
Quest : A Tangled Skein FIXEDCode:-- Fix for the quest Argent Crusade, We Are Leaving!FIXED UPDATE `quest_template` SET `ReqSpellCast1` = 34656 WHERE `entry` = 12504; INSERT INTO `creature_ai_scripts` (`id`,`creature_id`,`event_type`,`event_inverse_ph ase_mask`,`event_chance`,`event_flags`,`event_para m1`,`event_param2`,`event_param3`,`event_param4`,` action1_type`,`action1_param1`,`action1_param2`,`a ction1_param3`,`action2_type`,`action2_param1`,`ac tion2_param2`,`action2_param3`,`action3_type`,`act ion3_param1`,`action3_param2`,`action3_param3`,`co mment`) VALUES ('2804102','28041','10','0','100','0','1','3','0', '0','16','28041','34656','6','0','0','0','0','0',' 0','0','0','Quest credit when moving close to talk.');
NPC : Specialist Cogwheel
Faction : Both
Error : Plague Sprayer tidak dapat di jatuhkan dengan menggunakan Tangled Skein Thrower
Quest : Leave No One BehindCode:-- Fix for the quest A Tangled Skein UPDATE `quest_template` SET `ReqCreatureOrGOId1` = 28274, `ReqSpellCast1` = 51165 WHERE `entry` = 12555; UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 28274; INSERT INTO `creature_ai_scripts` VALUES ( 2827400, 28274, 8, 0, 100, 0, 51165, -1, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 20, 0, 0, 0, 'Increase phase on spellhit.'), ( 2827401, 28274, 0, 1, 100, 0, 5100, 5200, 0, 0, 11, 53236, 0, 23, 0, 0, 0, 0, 0, 0, 0, 0, 'Sprayer explosion.'), ( 2827402, 28274, 0, 1, 100, 0, 5400, 5500, 0, 0, 11, 51314, 0, 23, 0, 0, 0, 0, 0, 0, 0, 0, 'Sprayer spawn corpse.'), (2827403, 28274, 0, 1, 100, 0, 5600, 5700, 0, 0, 41, 0, 0, 0, 23, -1, 0, 0, 0, 0, 0, 0, 'Sprayer despawn.');
NPC : Dr. Rogers
Faction : Both
Error : Penggunaan Crusader's Bandage pada NPC Crusader Jonathan, Crusader Lamoof dan Crusader Josephine tidak terhitung dalam quest objective.
Quest : Tails UpCode:-- Fix for the quest Leave No One Behind UPDATE `quest_template` SET `ReqSpellCast1` = 50662, `ReqSpellCast2` = 50662, `ReqSpellCast3` = 50662 WHERE `entry` = 12512; INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`languag e`,`emote`,`comment`) VALUES ('-40000','<sigh>... Well, I suppose it could be worse.','0','0','0','1','Lamoof Say'), ('-40001','Thank you, friend. Were it not for your aid I would be no more.','0','0','0','1','Jonathan Say'), ('-40002','I am in your debt, friend. Thank you for my life.','0','0','0','1','Josephine Say'); UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 28136; UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 28142; UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 28148; INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (2813600, 28136, 8, 0, 100, 0, 50662, -1, 0, 0, 1, -40001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Speak on spellhit.'), (2814200, 28142, 8, 0, 100, 0, 50662, -1, 0, 0, 1, -40000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Speak on spellhit.'), (2814800, 28148, 8, 0, 100, 0, 50662, -1, 0, 0, 1, -40002, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Speak on spellhit.');
NPC : Chronicler To'kini
Faction : Both
Error : Penggunaan To'kini's Blowgun pada NPC Female Frost Leopard dan Female Icepaw Bear tidak terhitung dalam quest objective.
SUMBERCode:-- Fix for the quest Tails Up UPDATE `quest_template` SET `ReqCreatureOrGOId1` = 29327, `ReqCreatureOrGOId2` = 29319, `ReqSpellCast1` = 62105, `ReqSpellCast2` = 62105 WHERE `entry` = 13549; UPDATE `creature_template` SET `unit_flags` = 0 WHERE `entry` = 29319; INSERT INTO `creature_ai_scripts` (`id`,`creature_id`,`event_type`,`event_inverse_ph ase_mask`,`event_chance`,`event_flags`,`event_para m1`,`event_param2`,`event_param3`,`event_param4`,` action1_type`,`action1_param1`,`action1_param2`,`a ction1_param3`,`action2_type`,`action2_param1`,`ac tion2_param2`,`action2_param3`,`action3_type`,`act ion3_param1`,`action3_param2`,`action3_param3`,`co mment`) VALUES ('2932702','29327','8','0','100','0','62105','-1','0','0','23','1','0','0','11','17743','0','23', '0','0','0','0','Fall asleep on spellhit and increase phase by 1.'), ('2932703','29327','0','1','100','0','5000','6000' ,'0','0','23','-1','0','0','41','0','0','0','0','0','0','0','Despa wn after 5 seconds to avoid abusing.'), ('2931902','29319','8','0','100','0','62105','-1','0','0','23','1','0','0','11','17743','0','23', '0','0','0','0','Fall asleep on spellhit and increase phase by 1.'), ('2931903','29319','0','1','100','0','5000','6000' ,'0','0','23','-1','0','0','41','0','0','0','0','0','0','0','Despa wn after 5 seconds to avoid abusing.');
Grizzly Hills
Spoiler untuk Grizzly Hills :
Quest : Escape from Silverbrook
NPC : Caged Prisoner
Faction : Alliance
Error : Tidak terjadi apa2 setelah menerima quest dari Caged Prisoner yang seharusnya kita escord Caged Prisoner dengan menunggangi kuda bersama2.
Referensi Video
Saya menemukan dua code mohon di cek oleh para Tim GM. Saya berharap quest ini dapat di fix karena quest ini merupakan kunci chain quest panjang alliance di grizzly hills.
SUMBERCode:-- Fix for the quest Escape from Silverbrook UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 26875; INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (2687500, 26875, 10, 0, 100, 0, 1, 35, 0, 0, 33, 28019, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Credit for escaping Silverbrook.');
dan
SUMBERCode:UPDATE `creature_template` SET `unit_flags`=0x0000100,`speed_run`=1.28571 WHERE `entry`=27409; -- Ducal's Horse UPDATE `creature_template` SET `faction_A`=1891,`faction_H`=1891,`baseattacktime` =1500,`unit_flags`=0x2000200 WHERE `entry`=27411; -- Freed Alliance Scout DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=27409; INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`, `aura_required`, `aura_forbidden`, `user_type`) VALUES (27409,46598,0,0,0,1,0,0,0), -- Ride Vehicle Hardcoded (for npc) (27409,48678,0,0,0,1,0,0,0); -- Mount Ducal's Horse (for player)
Dragon Blight
Spoiler untuk Dragon Blight :
Quest : Slim Pickings
NPC : Zort
Faction : Both
Error : Sample of Rockflesh tidak dapat di loot dari Ravaged Crystalline Ice Giant.
SUMBERCode:-- Fix for the quest Slim Pickings INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES ('26809','36765','-100','1','0','1','1','0','0','0'); UPDATE `creature_template` SET `faction_A` = 1990, `faction_H` = 1990, `lootid` = 26809, `unit_flags` = 0, `dynamicflags` = 0, `type_flags` = 0 WHERE `entry` = 26809;
UPDATE TERBARU <<<<<<
Share This Thread