Northrend Kolektif Quest Report & Unofficial Fixing

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 :p

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 :)

http://img404.imageshack.us/img404/8...ownloadarr.jpg
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 :

1. 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
   
   Code:

   ---

   -- 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);

   ---

   sumber : http://pastebin.com/hv9eBqWC
2. 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]
   
   Code:

   ---

   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 )

   ---

   b. Attackable Talonshrike
   id : 24518
   Lokasi : Howling Fjord [41.5, 37.7]
   
   Code:

   ---

   UPDATE `creature_template` SET `mechanic_immune_mask` = 1 WHERE `entry` = 24518;

   ---

3. 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;

   ---

4. 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;

   ---

5. 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
   
   Code:

   ---

   UPDATE `creature_template` SET `modelid2`='0', `faction_H`='14' WHERE
`entry`='24170';

   ---

   Sumber : http://pastebin.com/r0E7MX8P
6. 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
   
   Code:

   ---

   UPDATE `quest_template` SET `ReqItemId1` = 0, `ReqItemCount1` = 0, `ReqCreatureOrGOId1` = 26503, `ReqCreatureOrGOCount1` = 1 WHERE `entry` = 11476;

   ---

   sumber : http://ytdb.ru/archive/index.php/t-7510.html
7. 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
   
   Code:

   ---

   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);

   ---

   sumber : http://ytdb.ru/archive/index.php/t-7510.html

GRIZZLY HILLS
Thread yg berkaitan : http://forum.indogamers.com/showthread.php?t=517125

Spoiler untuk GRIZZLY HILLS :

1. 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
   
   Code:

   ---

   UPDATE `quest_template` SET `ReqSpellCast1`='47394' WHERE `entry`='12070';

   ---

   sumber
2. 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
   
   Code:

   ---

   -- 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);

   ---

   SUmber : http://pastebin.com/bSdGrbnT
3. 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;

   ---

4. 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 :

1. 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');

   ---

2. 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 :

1. 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 :

1. Blending InFIXED
   NPC: Chieftain Wintergale
   Faction: Horde
   Eror: Spire of the Blood ga bisa di SCOUT, yg 2 sisanya bisa
   
   Code:

   ---

   - 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);

   ---

   sumber : https://github.com/TrinityCore/TrinityCore/issues/5979

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

Quote:

---

Originally Posted by oblivi0n

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.

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.');

---

Quest : Argent Crusade, We Are Leaving!
NPC : Sergeant Stackhammer
Faction : Both
Error : Argent Soldier tidak dapat diajak bicara.

Code:

---

    -- 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.');

---

Quest : A Tangled Skein FIXED
NPC : Specialist Cogwheel
Faction : Both
Error : Plague Sprayer tidak dapat di jatuhkan dengan menggunakan Tangled Skein Thrower

Code:

---

    -- 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.');

---

Quest : Leave No One Behind
NPC : Dr. Rogers
Faction : Both
Error : Penggunaan Crusader's Bandage pada NPC Crusader Jonathan, Crusader Lamoof dan Crusader Josephine tidak terhitung dalam quest objective.

Code:

---

    -- 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.');

---

Quest : Tails Up
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.

Code:

---

    -- 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.');

---

SUMBER

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
http://www.youtube.com/watch?v=ZQ0rY5VBGVA

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.

Code:

---

    -- 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.');

---

SUMBER

dan

Code:

---

    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)

---

SUMBER

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.

Code:

---

    -- 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;

---

SUMBER

---

http://img404.imageshack.us/img404/8...ownloadarr.jpg
UPDATE TERBARU <<<<<<

wah baik sekali kinerja dari kk noray.. contoh player yg harus di perbanyak, peduli dengan sesama
ditunggu fixnya ini

mantap kali bang norakrise ehuheuheueh, kurang blade edge neh buat yang outland T_T
di tunggu deh fix dari bugs_bunny yang ngaku2 gampang benerin fix dll
http://forum.indogamers.com/showthread.php?t=529209

Mantab mas bro... Klo kooperative kyk gini kan enak saling membantu, Lanjutkan mas broo......

(yang bisanya triak2 pake caps minta concentration aura dibenerin mana ya orangnya, apa lagi trans gender jgn2)

GG.......
tp ane msh jauh bener buat dapetin Loremaster T_T

Ikutan nimbrung kk noray :)
Jujur saya buta soal coding scripting dkk hehe :D (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 :

1. 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.
   
   
   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.');

   ---

2. Quest : Argent Crusade, We Are Leaving!
   NPC : Sergeant Stackhammer
   Faction : Both
   Error : Argent Soldier tidak dapat diajak bicara.
   
   
   Code:

   ---

   -- Fix for the quest Argent Crusade, We Are Leaving!
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.');

   ---

3. Quest : A Tangled Skein
   NPC : Specialist Cogwheel
   Faction : Both
   Error : Plague Sprayer tidak dapat di jatuhkan dengan menggunakan Tangled Skein Thrower
   
   
   Code:

   ---

   -- 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.');

   ---

4. Quest : Leave No One Behind
   NPC : Dr. Rogers
   Faction : Both
   Error : Penggunaan Crusader's Bandage pada NPC Crusader Jonathan, Crusader Lamoof dan Crusader Josephine tidak terhitung dalam quest objective.
   
   
   Code:

   ---

   -- 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.');

   ---

5. Quest : Tails Up
   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.
   
   
   Code:

   ---

   -- 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.');

   ---

   SUMBER
   

Grizzly Hills

Spoiler untuk Grizzly Hills :

1. 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
   http://www.youtube.com/watch?v=ZQ0rY5VBGVA
   
   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.
   
   
   Code:

   ---

   -- 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.');

   ---

   SUMBER
   
   dan
   
   
   Code:

   ---

   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)

   ---

   SUMBER
   

Dragon Blight

Spoiler untuk Dragon Blight :

1. Quest : Slim Pickings
   NPC : Zort
   Faction : Both
   Error : Sample of Rockflesh tidak dapat di loot dari Ravaged Crystalline Ice Giant.
   
   
   Code:

   ---

   -- 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;

   ---

   SUMBER
   

Quote:

---

Originally Posted by najre

wah baik sekali kinerja dari kk noray.. contoh player yg harus di perbanyak, peduli dengan sesama
ditunggu fixnya ini

---

Quote:

---

Originally Posted by Emiya

mantap kali bang norakrise ehuheuheueh, kurang blade edge neh buat yang outland T_T
di tunggu deh fix dari bugs_bunny yang ngaku2 gampang benerin fix dll
http://forum.indogamers.com/showthread.php?t=529209

---

Quote:

---

Originally Posted by vantheman

Mantab mas bro... Klo kooperative kyk gini kan enak saling membantu, Lanjutkan mas broo......

(yang bisanya triak2 pake caps minta concentration aura dibenerin mana ya orangnya, apa lagi trans gender jgn2)

---

Quote:

---

Originally Posted by rajoitam

GG.......
tp ane msh jauh bener buat dapetin Loremaster T_T

---

Makasih kawan kawan dukungannya :) semoga pada dapet loremaster kelak

Quote:

---

Originally Posted by oblivi0n

Ikutan nimbrung kk noray :)
Jujur saya buta soal coding scripting dkk hehe :D (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 :

1. 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.
   
   
   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.');

   ---

2. Quest : Argent Crusade, We Are Leaving!
   NPC : Sergeant Stackhammer
   Faction : Both
   Error : Argent Soldier tidak dapat diajak bicara.
   
   
   Code:

   ---

   -- Fix for the quest Argent Crusade, We Are Leaving!
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.');

   ---

3. Quest : A Tangled Skein
   NPC : Specialist Cogwheel
   Faction : Both
   Error : Plague Sprayer tidak dapat di jatuhkan dengan menggunakan Tangled Skein Thrower
   
   
   Code:

   ---

   -- 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.');

   ---

4. Quest : Leave No One Behind
   NPC : Dr. Rogers
   Faction : Both
   Error : Penggunaan Crusader's Bandage pada NPC Crusader Jonathan, Crusader Lamoof dan Crusader Josephine tidak terhitung dalam quest objective.
   
   
   Code:

   ---

   -- 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.');

   ---

5. Quest : Tails Up
   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.
   
   
   Code:

   ---

   -- 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.');

   ---

   SUMBER

Grizzly Hills

Spoiler untuk Grizzly Hills :

1. 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
   http://www.youtube.com/watch?v=ZQ0rY5VBGVA
   
   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.
   
   
   Code:

   ---

   -- 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.');

   ---

   SUMBER
   
   dan
   
   
   Code:

   ---

   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)

   ---

   SUMBER

Dragon Blight

Spoiler untuk Dragon Blight :

1. Quest : Slim Pickings
   NPC : Zort
   Faction : Both
   Error : Sample of Rockflesh tidak dapat di loot dari Ravaged Crystalline Ice Giant.
   
   
   Code:

   ---

   -- 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;

   ---

   SUMBER

---

wah mantap lanjutkan bro, makasih bantuan scriptnya, saya taruh di atas ya

Permisi kak noray dan Tim GM izin menambahkan beberapa2 kode.
Mohon di re-check
Mudah2an tepat sasaran :)
Terima Kasih

Dragon Blight

Spoiler untuk Dragon Blight :

1. Quest : Slim Pickings
   NPC : Zort
   Faction : Both
   Error : Sample of Rockflesh tidak dapat di loot dari Ravaged Crystalline Ice Giant.
   
   
   Code:

   ---

   -- 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;

   ---

   SUMBER
   
   
2. Quest : Rescue from Town Square (Quest ini merupakan kunci membuka chain quest yang panjang alliance di Dragon Blight)
   NPC : High Commander Halford Wyrmbane <7th Legion>
   Faction : Alliance
   Error : Quest Objective tidak terhitung saat membunuh Vengeful Geist untuk menyelamatkan Trapped Wintergarde Villager
   
   
   Code:

   ---

   #include "ScriptPCH.h"
#include "ScriptedEscortAI.h"

enum eEnums
{
    QUEST_RETURN_TO_AG_A    = 12499,
    QUEST_RETURN_TO_AG_H    = 12500,
    MOVIE_ID_GATES          = 14
};

#define GOSSIP_ITEM_WHAT_HAPPENED  "Alexstrasza, can you show me what happened here?"

class npc_alexstrasza_wr_gate : public CreatureScript
{
public:
    npc_alexstrasza_wr_gate() : CreatureScript("npc_alexstrasza_wr_gate") { }

    bool OnGossipHello(Player* player, Creature* creature)
    {
        if (creature->isQuestGiver())
            player->PrepareQuestMenu(creature->GetGUID());

        if (player->GetQuestRewardStatus(QUEST_RETURN_TO_AG_A) || player->GetQuestRewardStatus(QUEST_RETURN_TO_AG_H))
            player->ADD_GOSSIP_ITEM(GOSSIP_ICON_CHAT, GOSSIP_ITEM_WHAT_HAPPENED, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF+1);

        player->SEND_GOSSIP_MENU(player->GetGossipTextId(creature), creature->GetGUID());
        return true;
    }

    bool OnGossipSelect(Player* player, Creature* /*creature*/, uint32 /*uiSender*/, uint32 uiAction)
    {
        player->PlayerTalkClass->ClearMenus();
        if (uiAction == GOSSIP_ACTION_INFO_DEF+1)
        {
            player->CLOSE_GOSSIP_MENU();
            player->SendMovieStart(MOVIE_ID_GATES);
        }

        return true;
    }
};

/*#######
# Quest Rescue from Town Square
########*/
enum eEnumVillager
{
    QUEST_RESCUE_FROM_TOWN_SQUARE    = 12253,
    NPC_VILLAGER                    = 27359
};

#define GOSSIP_ITEM_HELP  "Rettet mich bitte!"

class npc_trapped_wintergarde_villager : public CreatureScript
{
public:
    npc_trapped_wintergarde_villager() : CreatureScript("npc_trapped_wintergarde_villager") {}

    bool OnGossipHello(Player* player, Creature* creature)
    {
        if (creature->isQuestGiver())
            player->PrepareQuestMenu(creature->GetGUID());

        if (player->GetQuestStatus(QUEST_RESCUE_FROM_TOWN_SQUARE) == QUEST_STATUS_INCOMPLETE)
            player->ADD_GOSSIP_ITEM(GOSSIP_ICON_CHAT, GOSSIP_ITEM_HELP, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF+1);

        player->SEND_GOSSIP_MENU(player->GetGossipTextId(creature), creature->GetGUID());
        return true;
    }

    bool OnGossipSelect(Player* player, Creature* creature, uint32 /*uiSender*/, uint32 uiAction)
    {
        player->PlayerTalkClass->ClearMenus();
        if (uiAction == GOSSIP_ACTION_INFO_DEF+1)
        {
            player->CLOSE_GOSSIP_MENU();
                        player->ToPlayer()->KilledMonsterCredit(NPC_VILLAGER, 0);
                        creature->DespawnOrUnsummon();
        }
        return true;
    }
};



/*######
## npc_rokhan
######*/

#define ROKHAN_GOSSIP_ITEM1 "Bitte ruft den Drachen, damit ich ihm das Herz entreissen kann!"

enum eRokhan
{
    QUEST_SARATHSTRA_COURGE_OF_THE_NORTH  = 12097,
    QUEST_TO_DRAGONS_FALL                  = 12095,
    NPC_ROKHAN                            = 26859,
    CREATURE_SARATHSTRA                    = 26858
};

class npc_rokhan : public CreatureScript
{
public:
    npc_rokhan() : CreatureScript("npc_rokhan") { }

    bool OnGossipHello(Player* player, Creature* creature)
    {
        if (creature->isQuestGiver())
            player->PrepareQuestMenu(creature->GetGUID());

        if (player->GetQuestStatus(QUEST_SARATHSTRA_COURGE_OF_THE_NORTH) == QUEST_STATUS_INCOMPLETE && !player->FindNearestCreature(CREATURE_SARATHSTRA,200,true))
            player->ADD_GOSSIP_ITEM(GOSSIP_ICON_CHAT, ROKHAN_GOSSIP_ITEM1, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF+1);
       
        player->SEND_GOSSIP_MENU(player->GetGossipTextId(creature), creature->GetGUID());
       
        return true;
    }

    bool OnGossipSelect(Player* player, Creature* creature, uint32 /*uiSender*/, uint32 uiAction)
    {
        player->CLOSE_GOSSIP_MENU();
     
        if(Creature* tmp = player->FindNearestCreature(CREATURE_SARATHSTRA,200,false))
            tmp->DespawnOrUnsummon();

        Creature *tmpsarath = player->SummonCreature(CREATURE_SARATHSTRA,4412.329f,857.795f,170.0f,2.28f);
                tmpsarath->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
        tmpsarath->SetFlying(true);
        tmpsarath->GetMotionMaster()->MovePoint(0,4362.881f,946.37f,87.94f);
        player->GetMotionMaster()->MovePoint(0,4362.881f,946.37f,82.94f);
                tmpsarath->DespawnOrUnsummon(17000);
               
                Creature *tmpsarath = player->SummonCreature(CREATURE_SARATHSTRA,0,4362.881f,946.37f,82.94f,TEMPSUMMON_CORPSE_TIMED_DESPAWN,60000);
                tmpsarath->RemoveFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
                tmpsarath->SetFlying(false);
               
               
       


        return true;
       
    }
};

void AddSC_dragonblight()
{
    new npc_alexstrasza_wr_gate;
    new npc_trapped_wintergarde_villager();
    new npc_rokhan();
}

   ---

   SUMBER
   

IceCrown

Spoiler untuk IceCrown :

1. Quest: The Last Line Of Defense (salah satu rangkaian chain quest yang panjang menuju pada quest Light Within the Darkness)
   NPC : Siegemaster Fezzik
   Faction : Both
   Error : Argent Cannon tidak spawn di setiap tower dan tidak spawnnya juga Frostbrood Destroyer dan scourage attackers yang menyerang base argent crusade.
   
   
   Code:

   ---

   -- The Last Line Of Defense
-- start event gossip

UPDATE `creature_template` SET `gossip_menu_id`=30657 WHERE `entry`=30657;
DELETE FROM `gossip_menu` WHERE `entry`=30657;
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (30657, 1);
DELETE FROM `gossip_menu_option` WHERE `menu_id`=30657;
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`) VALUES
('30657', '0', '0', 'The Lich kings minnions are comming. May i prepare cannon for you?', '1', '3', '0', '0', '0', '0', '0', 'Are you ready to defend the camp?');
/*
+DELETE FROM `gossip_scripts` WHERE `id`=30657;
+INSERT INTO `gossip_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
+(30657, 0, 10, 730017, 600000, 0, 6291.32, 140.507, 386.517, 4.43048),
+(30657, 0, 10, 730017, 600000, 0, 6311.92, 127.115, 389.501, 3.98517),
+(30657, 0, 10, 730019, 600000, 0, 6325.59, 115.692, 390.431, 3.78489),
+(30657, 0, 10, 730019, 600000, 0, 6343.48, 94.1783, 391.444, 3.54927),
+(30657, 0, 10, 730019, 600000, 0, 6339.35, 67.395, 390.09, 2.6657),
+(30657, 0, 10, 730017, 600000, 0, 6265.25, 145.87, 383.394, 4.59306),
+(30657, 0, 10, 730021, 600000, 0, 6272.11, 77.81, 393.821, 0.69),
+(30657, 0, 6, 571, 0, 0, 6272.30, 77.69, 393.82, 0.82),
+(30657, 0, 10, 30236, 600000, 0, 6282.92, 70.2466, 396.427, 0.936193),
+(30657, 0, 10, 30236, 600000, 0, 6273.69, 79.3612, 396.309, 0.791233),
+(30657, 0, 10, 30236, 600000, 0, 6264.18, 85.28, 391.7, 0.68),
+(30657, 0, 10, 30236, 600000, 0, 6289.03, 61.45, 391.81, 0.92);
+*/
-- skript ke zkontrolovani
SET @NPC_Fezzik :=30657;
UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='',`npcflag`=3 WHERE `entry`=@NPC_Fezzik;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@NPC_Fezzik 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_Fezzik,0,0,0,1,0,100,0,1000,1000,1000,1000,15,3070,0,0,0,0,0,18,1,0,0,0,0,0,0,'Complete quest on player range'),
(@NPC_Fezzik,0,1,2,62,0,100,0,30657,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6282.92,70.2466,396.427,0.936193,'Siegemaster Fezzik - summon cannon on gossip'),
(@NPC_Fezzik,0,2,3,61,0,100,0,0,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6289.03,61.45,391.81,0.92,'Siegemaster Fezzik - summon cannon on gossip'),
(@NPC_Fezzik,0,3,4,61,0,100,0,0,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6273.69,79.3612,396.309,0.791233,'Siegemaster Fezzik - summon cannon on gossip'),
(@NPC_Fezzik,0,4,5,61,0,100,0,0,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6264.18,85.28,391.7,0.68,'Siegemaster Fezzik - summon cannon on gossip'),
(@NPC_Fezzik,0,5,6,61,0,100,0,0,0,0,0,12,730017,3,600000,0,0,0,8,0,0,0,6291.32, 140.507, 386.517, 4.43048,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,6,7,61,0,100,0,0,0,0,0,12,730017,3,600000,0,0,0,8,0,0,0,6311.92, 127.115, 389.501, 3.98517,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,7,8,61,0,100,0,0,0,0,0,12,730017,3,600000,0,0,0,8,0,0,0,6265.25, 145.87, 383.394, 4.59306,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,8,9,61,0,100,0,0,0,0,0,12,730019,3,600000,0,0,0,8,0,0,0,6325.59, 115.692, 390.431, 3.78489,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,9,10,61,0,100,0,0,0,0,0,12,730019,3,600000,0,0,0,8,0,0,0,6343.48, 94.1783, 391.444, 3.54927,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,10,11,61,0,100,0,0,0,0,0,12,730019,3,600000,0,0,0,8,0,0,0,6339.35, 67.395, 390.09, 2.6657,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,11,12,61,0,100,0,0,0,0,0,81,2,0,0,0,0,0,7,0,0,0,0,0,0,0,'Fezzik - set flag to gossip'),
(@NPC_Fezzik,0,12,0,1,0,100,0,600000,600000,0,0,81,3,0,0,0,0,0,7,0,0,0,0,0,0,0,'Fezzik - set flag back to quest giver ');



-- Argent Cannon
SET @ENTRY := 30236;
SET @VEHICLE := 246;
-- spawn utocicich mobu
 DELETE FROM `smart_scripts` WHERE `entryorguid`IN (730017, 730019, 30593);
 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
(730017, 0, 0, 0, 1, 0, 100, 0, 20000, 30000, 2000, 3000, 12, 30593, 3, 60000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Summon spider'),
(730017, 0, 1, 0, 1, 0, 100, 0, 20000, 80000, 30000, 40000, 12, 30575, 3, 60000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Summon wyrm'),
(730019, 0, 0, 0, 1, 0, 100, 0, 20000, 30000, 2000, 3000, 12, 730020, 3, 60000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Summon spider'),
(730019, 0, 1, 0, 1, 0, 100, 0, 20000, 80000, 30000, 40000, 12, 30575, 3, 60000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Summon wyrm'),
(730017, 0, 2, 0, 1, 0, 100, 0, 20000, 30000, 15000, 15000, 12, 30189, 3, 30000, 0, 0, 0, 1, 0, 0, 0, 6288.7, 96.6109, 390.21, 0.8, 'Summon defender'),
(730019, 0, 2, 0, 1, 0, 100, 0, 20000, 30000, 15000, 15000, 12, 30189, 3, 30000, 0, 0, 0, 1, 0, 0, 0, 6301.15, 86.1998, 389.705, 0.8, 'Summon defender');
UPDATE `quest_template` SET `StartScript`=13086 WHERE `Id`=13086;

/*
 -- spawn dela a vyvolavace utoku
 DELETE FROM `quest_start_scripts` WHERE `id`=13086;
 INSERT INTO `quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
-(13086, 0, 10, 730017, 180000, 0, 6291.32, 140.507, 386.517, 4.43048),
-(13086, 0, 10, 730017, 180000, 0, 6311.92, 127.115, 389.501, 3.98517),
-(13086, 0, 10, 730019, 180000, 0, 6325.59, 115.692, 390.431, 3.78489),
-(13086, 0, 10, 730019, 180000, 0, 6343.48, 94.1783, 391.444, 3.54927),
-(13086, 0, 10, 730019, 180000, 0, 6339.35, 67.395, 390.09, 2.6657),
-(13086, 0, 10, 730017, 180000, 0, 6265.25, 145.87, 383.394, 4.59306),
-(13086, 0, 10, 730021, 180000, 0, 6272.11, 77.81, 393.821, 0.69),
+(13086, 0, 10, 730017, 600000, 0, 6291.32, 140.507, 386.517, 4.43048),
+(13086, 0, 10, 730017, 600000, 0, 6311.92, 127.115, 389.501, 3.98517),
+(13086, 0, 10, 730019, 600000, 0, 6325.59, 115.692, 390.431, 3.78489),
+(13086, 0, 10, 730019, 600000, 0, 6343.48, 94.1783, 391.444, 3.54927),
+(13086, 0, 10, 730019, 600000, 0, 6339.35, 67.395, 390.09, 2.6657),
+(13086, 0, 10, 730017, 600000, 0, 6265.25, 145.87, 383.394, 4.59306),
+(13086, 0, 10, 730021, 600000, 0, 6272.11, 77.81, 393.821, 0.69),
 (13086, 0, 6, 571, 0, 0, 6272.30, 77.69, 393.82, 0.82),
-(13086, 0, 10, 30236, 180000, 0, 6282.92, 70.2466, 396.427, 0.936193),
-(13086, 0, 10, 30236, 180000, 0, 6273.69, 79.3612, 396.309, 0.791233);
+(13086, 0, 10, 30236, 600000, 0, 6282.92, 70.2466, 396.427, 0.936193),
+(13086, 0, 10, 30236, 600000, 0, 6273.69, 79.3612, 396.309, 0.791233),
+(13086, 0, 10, 30236, 600000, 0, 6264.18, 85.28, 391.7, 0.68),
+(13086, 0, 10, 30236, 600000, 0, 6289.03, 61.45, 391.81, 0.92);
+*/
 
 -- nastaveni utocniku
 UPDATE `creature_template` SET `minrangedmg`=1000,`maxrangedmg`=2000,`InhabitType`=4 WHERE `entry`=30575;

   ---

   SUMBER
   
   dan
   
   
   Code:

   ---

   -- ------------------------------------------ --
-- quest "The Last Line Of Defense" 13086 fix --
-- ------------------------------------------ --

-- on retail players can use Argent Canons to pew-pew quest mobs,
-- since it's more like science-fiction for us, players are allowed to kill mobs by sword and fire.
-- NPC "Frostbrood Destroyer" 30575 needed for quest credit #2 added and spawned
UPDATE `creature_template`
SET
`faction_A` = '2068',
`faction_H` = '2068',
`minrangedmg` = '345',
`maxrangedmg` = '509',
`minlevel` = '80',
`maxlevel` = '80',
`armor` = '9729',
`mindmg` = '1170',
`maxdmg` = '3470',
`attackpower` = '342',
`dmg_multiplier` = '2',
`minhealth` = '315000',
`maxhealth` = '315000',
`InhabitType` = '3'
WHERE
`entry` = '30575';
DELETE FROM `creature` WHERE `id` = '30575';
INSERT INTO `creature` (id, map, position_x, position_y, position_z, orientation, spawntimesecs) VALUES
(30575, 571, 6335.826172, 82.110123, 409.224274, 3.138359, 300),
(30575, 571, 6457.640625, 171.508743, 409.985840, 2.494332, 300),
(30575, 571, 6319.731445, 212.167740, 391.011688, 4.739780, 300),
(30575, 571, 6034.281250, 63.817360, 394.400238, 0.973792, 300);
UPDATE `creature`
SET
`id` = '30575'
WHERE
`id` = '30674';
-- Argent Towers spawned for better look, but they don't work
DELETE FROM `creature` WHERE `id` = '30236';
INSERT INTO `creature` (id, map, position_x, position_y, position_z, orientation, spawntimesecs) VALUES
(30236, 571, 6296.888672, 53.354115, 404.575562, 0.782158, 900),
(30236, 571, 6255.935059, 92.995056, 404.473083, 1.567560
, 900),
(30236, 571, 6219.520508, 59.812351, 394.064758, 1.944548
, 900),
(30236, 571, 6162.470215, 60.321831, 394.067474, 2.089845, 900);
-- since for quest credit #1 can be killed difrent mobs, script is the best solution for counting frags
DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN ('30204', '30333', '30205', '30206', '30673', '31043');
INSERT INTO `creature_ai_scripts` (creature_id, event_type, event_chance, action1_type, action1_param1, action1_param2, comment) VALUES
(30204, 6, 100, 33, 30670, 6, "Gives quest 13086 credit"),
(30333, 6, 100, 33, 30670, 6, "Gives quest 13086 credit"),
(30205, 6, 100, 33, 30670, 6, "Gives quest 13086 credit"),
(30206, 6, 100, 33, 30670, 6, "Gives quest 13086 credit"),
(30673, 6, 100, 33, 30670, 6, "Gives quest 13086 credit"),
(31043, 6, 100, 33, 30670, 6, "Gives quest 13086 credit");

   ---

   SUMBER
   

wah mau jg dng loremaster.
mana ini bugs_bunny scriptnya, kok malah cuma ngomong pake caps lock doang di thread laen wkwkwkw

Terima kasih banyak kepada Tim GM telah fix beberapa list quest di atas ^_^

saya coba ringkas kedalam post ini, quest - quest yang telah di lapor di thread quest bug untuk northrend map..

hanya beberapa quest lagi kami bisa dapet ijazah Howling - Grizzly - Borean hehe :D

Berikut list quest yang telah di fix dan list quest baru beserta unofficial fixingnya ( 3 Map dulu )

Keterangan Status Quest :
http://img220.imageshack.us/img220/8...klisticon2.gif = Telah Di Fix ^_^
http://img259.imageshack.us/img259/7024/helmetedit.png = Sedang dalam proses / Antrian dengan unofficial fixing & keterangan error di bagian bawah Post
http://img820.imageshack.us/img820/9...estionedit.png = Belum nemu Unofficial script fix nya

UPDATE 27/04/2012

HOWLING FJORD • SELAMAT ANDA BISA MENDAPATKAN IJASAH HOWLING SO NICEE WORKS FOR GM ^_^ TRIMS
sumber List : http://forum.indogamers.com/showthread.php?t=516727

1. Gambling Debt http://img220.imageshack.us/img220/8...klisticon2.gif
2. Eyes of the Eagle http://img220.imageshack.us/img220/8...klisticon2.gif - Attackable Talonshrike
3. The Slumbering Kinghttp://img220.imageshack.us/img220/8...klisticon2.gif - Now Hostile
4. The Frost Wyrm and its Masterhttp://img220.imageshack.us/img220/8...klisticon2.gif - Now Spawned
5. Draconis Gastritis http://img220.imageshack.us/img220/8...klisticon2.gif- Item Works on Drakes :D
6. A Carver and a Croaker http://img220.imageshack.us/img220/8...klisticon2.gif
7. The Rune of Command http://img220.imageshack.us/img220/8...klisticon2.gif

New List :

1. Alpha Worg http://img220.imageshack.us/img220/8...klisticon2.gif
2. Warning : Some Assembly Required http://img820.imageshack.us/img820/9...estionedit.png
3. War is Hell http://img220.imageshack.us/img220/8...klisticon2.gif
4. Bring Down Those Shield http://img820.imageshack.us/img820/9...estionedit.png
5. The Fallen Sisters http://img820.imageshack.us/img820/9...estionedit.png
6. Conqueror of Skorn! http://img220.imageshack.us/img220/8...klisticon2.gif- Winterhoof Emblem Issue Fix
   
7. The Echo of Ymironhttp://img820.imageshack.us/img820/9...estionedit.png
8. Guided by Honor http://img820.imageshack.us/img820/9...estionedit.png
9. Drop It then Rock It! http://img820.imageshack.us/img820/9...estionedit.png
10. There Exists No Honor Among Birds http://img820.imageshack.us/img820/9...estionedit.png
11. Iron Rune Constructs and You: Rocket Jumping http://img820.imageshack.us/img820/9...estionedit.png

Unofficial Fixing Howling Fjord

Spoiler untuk Howling :

1. Gambling Debt http://img220.imageshack.us/img220/8...klisticon2.gif
   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. Talkto him once more and use the chat option to obtain your payment.
   Fix Code : Item Quest "Silvermoon" Harry's Debt Di jual di vendor "Silvermoon Harry
   
   Code:

   ---

   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);

   ---

2. ACarver and a Croaker http://img220.imageshack.us/img220/8...klisticon2.gif
   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
   
   Code:

   ---

   UPDATE `quest_template` SET `ReqItemId1` = 0, `ReqItemCount1` = 0,`ReqCreatureOrGOId1` = 26503, `ReqCreatureOrGOCount1` = 1 WHERE `entry` = 11476;

   ---

3. The Rune of Command http://img220.imageshack.us/img220/8...klisticon2.gif
   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
   
   Code:

   ---

   -- 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);

   ---

   Code:

   ---

   
sumber

   ---

4. Alpha Worghttp://img220.imageshack.us/img220/8...klisticon2.gif
   NPC : Ulfang
   Faction : Both
   Error : Missing NPC Garwal
   Fix Code : Spawn Garwal di lokasi Rivenwood, Howling Fjord [27.0, 08.0]
   
   Code:

   ---

   DELETE FROM `creature` WHERE `id` IN (24277);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`,
`position_y`, `position_z`, `spawntimesecs`, `spawndist`, `curhealth`)
VALUES (unknown , 24277, 571 , 1 , 1, unknown , unknown, unknown, 180 , 0 , 13936)
-add template-
UPDATE `creature_template` SET `minlevel`=71, `maxlevel`=71, `faction_A`=14,
`faction_H`=14, `mechanic_immune_mask` = 1 WHERE `entry`=24277;

   ---

5. War is Hellhttp://img220.imageshack.us/img220/8...klisticon2.gif
   NPC : High Executor Anselm
   Faction : Horde
   Eror : ketika item quest Burning Torch
   di pake pada Alliance Corpse & Forsaken Corpse selesai kebakar ga di itung complete
   Fix Code 1: npc fix use item on it
   
   Code:

   ---

   UPDATE `creature_template` SET `unit_flags`='0', `dynamicflags`='8' WHERE `entry`='24009';
UPDATE `creature_template` SET `unit_flags`='0', `dynamicflags`='8' WHERE `entry`='24010';

   ---

   Fix Code 2 apabila 1 tidak bisa mungkin :npc deathstate on
   
   Code:

   ---

   UPDATE `creature` SET `DeathState`='1' WHERE `id` IN ('24009','24010');

   ---

Grizzly Hills
Sumber List : http://forum.indogamers.com/showthread.php?t=517125

1. Rallying the Troopshttp://img220.imageshack.us/img220/8...klisticon2.gif - Item Works on NPC
   
2. Loken's Ordershttp://img220.imageshack.us/img220/8...klisticon2.gif - Event Works
   
3. Bringing Down the Iron Thanehttp://img220.imageshack.us/img220/8...klisticon2.gif - Now Spawned
   
4. Dun-da-Dun-tah!http://img259.imageshack.us/img259/7024/helmetedit.png

New List :

1. Runes of Compulsion http://img259.imageshack.us/img259/7024/helmetedit.png
2. The Conquest Pit : Bear Wrestling !http://img220.imageshack.us/img220/8...klisticon2.gif
3. Out of Body Experiencehttp://img259.imageshack.us/img259/7024/helmetedit.png
4. Seared Scourgehttp://img220.imageshack.us/img220/8...klisticon2.gif
5. Subject to Interpretationhttp://img820.imageshack.us/img820/9...estionedit.png
6. Shred The Alliance http://img820.imageshack.us/img820/9...estionedit.png
7. See You on the Other Sidehttp://img820.imageshack.us/img820/9...estionedit.png
8. Riding the Red ROckethttp://img820.imageshack.us/img820/9...estionedit.png
9. Escape from Silverbrookhttp://img259.imageshack.us/img259/7024/helmetedit.png

Unofficial Fixing Grizzly Hills

Spoiler untuk Grizzly Hills :

1. Runes of Compulsion
   NPC : Gavrock
   Faction : Both
   Error : "You need to kill all 4 Iron rune-weavers to get the overseers to spawn" tidak berfungsi, Overseer tidak spawn di lokasi (Overseer Durval Overseer Korgan Overseer LochliOverseer Brunon)
   Fix COde : Spawn 4 Overseer langsung Di TKP Quest
   Lokasi : Eastwind Shore, Grizzly Hills ([67.4, 29.4], [71.8, 34.2], [74.8, 37.0], [78.8, 43.4])
   
   Code:

   ---

   -add npc-
DELETE FROM `creature` WHERE `id` IN ('26920','26921','26922','26923');
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `spawntimesecs`, `spawndist`, `curhealth`, 'curmana')
VALUES (unknown , 26920, 571 , 1 , 1, unknown , unknown, unknown, 180 , 0 , 10635, 3561),
(unknown , 26921, 571 , 1 , 1, unknown , unknown, unknown, 180 , 0 , 8508, 7981),
(unknown , 26922, 571 , 1 , 1, unknown , unknown, unknown, 180 , 0 , 10635, 3561),
(unknown , 26923, 571 , 1 , 1, unknown , unknown, unknown, 180 , 0 , 10635, 3561);
-add template-
UPDATE `creature_template` SET `minlevel`=75, `maxlevel`=75, `faction_A`=14, `faction_H`=14, `mechanic_immune_mask` = 1 WHERE `entry`= 26920;
UPDATE `creature_template` SET `minlevel`=75, `maxlevel`=75,  `faction_A`=14, `faction_H`=14, `mechanic_immune_mask` = 1 WHERE  `entry`= 26921;
UPDATE `creature_template` SET `minlevel`=75, `maxlevel`=75,  `faction_A`=14, `faction_H`=14, `mechanic_immune_mask` = 1 WHERE  `entry`= 26922;
UPDATE `creature_template` SET `minlevel`=75, `maxlevel`=75,  `faction_A`=14, `faction_H`=14, `mechanic_immune_mask` = 1 WHERE  `entry`= 26923;

   ---

2. The Conquest Pit Chain Quest Seru Nih ^_^The Conquest Pit : Bear Wrestling !http://img220.imageshack.us/img220/8...klisticon2.gif
   NPC : Grennix Shivwiggle
   Faction : Horde
   Error : Quest blm berjalan, Ironhide tidak spawn
   Series :
   The Conquest Pit: Mad Furbolg Fighting - Torgg Thundertotem
   The Conquest Pit: Blood and Metal - Rustblood
   The Conquest Pit: Death Is Likely - Horgrenn Hellcleave
   The Conquest Pit: Final Showdown - Conqueror Krenna
   Fix Code : Blizzlike Event Quest
   
   Code:

   ---

   -- Quest Chain The Conquest Pit
-- The Conquest Pit: Bear Wrestling!
-- The Conquest Pit: Mad Furbolg Fighting
-- The Conquest Pit: Blood and Metal
-- The Conquest Pit: Death Is Likely
-- The Conquest Pit: Final Showdown

DELETE FROM `creature` WHERE id=27715;
UPDATE `creature_template` SET Faction_A=14, Faction_H=14, AIName='SmartAI' WHERE entry IN (27715,27716,27717,27718);
UPDATE `creature_template` SET AIName='SmartAI' WHERE entry IN (27727,27726);

DELETE FROM `quest_start_scripts` WHERE id IN (12427,12428,12429,12430,12431);
INSERT INTO `quest_start_scripts` VALUES
(12427,5,10,27715,360000,0,3242.77,-2340.98,92.34,0.98),
(12428,5,10,27716,360000,0,3242.77,-2340.98,92.34,0.98),
(12429,5,10,27717,360000,0,3242.77,-2340.98,92.34,0.98),
(12430,5,10,27718,360000,0,3242.77,-2340.98,92.34,0.98),
(12431,8,10,27727,360000,0,3251.91,-2340.61,91.86,3.10);

UPDATE `quest_template` SET StartScript=12427 WHERE id=12427;
UPDATE `quest_template` SET StartScript=12428 WHERE id=12428;
UPDATE `quest_template` SET StartScript=12429 WHERE id=12429;
UPDATE `quest_template` SET StartScript=12430 WHERE id=12430;
UPDATE `quest_template` SET StartScript=12431 WHERE id=12431;

DELETE FROM `creature_text` WHERE entry IN (27719,27727,27726);
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
(27719,0,0,"Ladies and gentlemen! Well... let's just say you don't want to miss this one!",14,0,100,0,0,0,'Grennix Shivwiggle - Quest Accepted'),
(27727,0,0,"You went behind my back. You neglected my orders. You will pay the price.",12,0,100,0,0,0,'Conqueror Krenna - Say 0'),
(27727,1,1,"Enough talk. By the time I'm though with you, not even the worgs will go
near your corpse.",12,0,100,0,0,0,'Conqueror Krenna - Say 1'),
(27726,0,0,"I used good judgment when you showed non. I don't want to see you lead us into ruin, Krenna!",12,0,100,0,0,0,'Gorgonna - Say 0'),
(27726,1,1,"It doesn't have to end this way, you know?",12,0,100,0,0,0,'Gorgonna - Say 1'),
(27726,2,2,"We'll see about that",12,0,100,0,0,0,'Gorgonna - Say 2'),
(27726,3,3,"Why... why sister? Why did it have to come to this?",12,0,100,0,0,0,'Gorgonna - Say 3');


-- SAI


UPDATE `creature_template` SET AIName='SmartAI' WHERE entry IN (27715,27716,27717,27718,27727,27719,27726);
DELETE FROM `creature_ai_scripts`where creature_id IN (27715,27716,27717,27718,27727,27719,27726);
DELETE FROM `smart_scripts` WHERE entryorguid IN (27715,27716,27717,27718,27727,27719,27726);
INSERT INTO `smart_scripts` VALUES (27715,0,0,0,9,0,100,0,8,25,17000,24000,11,32323,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Ironhide - Cast Charge'),
(27715,0,1,0,0,0,100,0,5000,7000,7000,9000,11,34298,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Ironhide - Cast Maul'),
(27715,0,2,0,9,0,100,0,0,5,7000,11000,11,31279,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Ironhide - Cast Swipe'),
(27715,0,3,0,7,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ironhide - Evade - Unseen'),
(27715,0,4,0,7,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ironhide - Evade - Despawn'),
(27715,0,5,0,6,0,100,0,0,0,0,0,15,12427,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Ironhide - Death - Credit'),
(27715,0,6,0,6,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ironhide - Death - Unseen'),
(27715,0,7,0,7,0,100,0,0,0,0,0,6,12427,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Ironhide - Evade - Quest Fail'),


-- Torgg Thundertotem 27716

(27716,0,0,0,0,0,100,0,1000,3000,6000,8000,11,16033,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Torgg Thundertotem - Cast Chain Lightning'),
(27716,0,1,0,0,0,100,0,10000,20000,5000,15000,11,15982,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Cast Healing Wave'),
(27716,0,2,0,0,0,100,0,0,0,21000,21000,11,31991,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Cast Corrupted Nova Totem'),
(27716,0,3,0,0,0,100,0,4000,4000,12000,12000,11,15501,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Cast Earth Shock'),
(27716,0,4,0,7,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Evade - Unseen'),
(27716,0,5,0,7,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Evade - Despawn'),
(27716,0,6,0,6,0,100,0,0,0,0,0,15,12428,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Torgg Thundertotem - Credit'),
(27716,0,7,0,6,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Death - Unseen'),
(27716,0,8,0,7,0,100,0,0,0,0,0,6,12428,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Torgg Thundertotem - Evade - Quest Fail'),

-- Rustblood 27717

(27717,0,0,0,0,0,100,0,5000,7000,5000,7000,11,42746,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Rustblood - Cast Cleave'),
(27717,0,1,0,9,0,100,0,0,5,22000,30000,11,49398,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Rustblood - Cast Knockback'),
(27717,0,2,0,0,0,100,0,12000,15000,18000,21000,11,14102,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Rustblood - Cast Head Smash'),
(27717,0,3,0,0,0,100,0,0,3000,12000,12000,11,61893,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Rustblood - Cast Lightning Bolt'),
(27717,0,4,0,7,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Rustblood - Evade - Unseen'),
(27717,0,5,0,7,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Rustblood - Evade - Despawn'),
(27717,0,6,0,6,0,100,0,0,0,0,0,15,12429,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Rustblood - Death - Credit'),
(27717,0,7,0,6,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Rustblood  - Death - Unseen'),
(27717,0,8,0,7,0,100,0,0,0,0,0,6,12429,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Rustblood - Evade - Quest Fail'),

-- Horgrenn Hellcleave 27718

(27718,0,0,0,9,0,100,0,0,10,21000,29000,11,16508,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Cast Intimidating Roar'),
(27718,0,1,0,0,0,100,0,3000,6000,8000,12000,11,15572,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Cast Sunder Armor'),
(27718,0,2,0,0,0,100,0,9000,12000,12000,16000,11,39171,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Cast Mortal Strike'),
(27718,0,3,0,0,0,100,0,13000,15000,13000,18000,11,38618,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Cast Whirlwind'),
(27718,0,4,0,7,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Evade - Unseen'),
(27718,0,5,0,7,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Evade - Despawn'),
(27718,0,6,0,6,0,100,0,0,0,0,0,15,12430,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Death - Credit'),
(27718,0,7,0,6,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Death - Unseen'),
(27718,0,8,0,7,0,100,0,0,0,0,0,6,12430,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Evade - Quest Fail'),

-- Conqueror Krenna 27727

(27727,0,0,0,9,0,100,0,0,5,7000,9000,11,15284,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Conqueror Krenna - Cast Cleave'),
(27727,0,1,0,0,0,100,0,9000,12000,12000,17000,11,11430,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Conqueror Krenna - Cast Slam'),
(27727,0,2,0,13,0,100,0,14000,17000,14000,17000,11,12555,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Conqueror Krenna - Cast Pummel'),
(27727,0,3,0,13,0,100,0,3000,6000,6000,11000,11,34719,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Conqueror Krenna - Cast Fixate'),
(27727,0,4,0,54,0,100,0,0,0,0,0,12,27726,3,75000,0,0,0,8,0,0,0,3244.50,-2340.56,92.14,6.27, 'Conqueror Krenna - Summon Gorgonna'),
(27727,0,5,0,54,0,100,0,0,0,0,0,1,0,18000,0,0,0,0,1,0,0,0,0,0,0,0, 'Conqueror Krenna - Summoned - Say 0'),
(27727,0,6,0,52,0,100,0,0,27727,0,0,1,1,6000,0,0,0,0,1,0,0,0,0,0,0,0, 'Conqueror Krenna - Say 0 - Say 1'),
(27727,0,7,0,1,0,100,1,35000,35000,1,1,2,14,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Conqueror Krenna - OOC 35 Sec - Enemy'),
(27727,0,8,0,6,0,100,0,0,0,0,0,15,12431,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Conqueror Krenna - Death - Credit'),
(27727,0,9,0,6,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Conqueror Krenna - Death - Unseen'),
(27727,0,10,0,7,0,100,0,0,0,0,0,6,12431,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Conqueror Krenna - Evade - Quest Fail'),

-- Gorgonna 27726

(27726,0,0,0,1,0,100,1,6000,6000,1,1,1,0,6000,0,0,0,0,1,0,0,0,0,0,0,0,'Gorgonna - OOC 6 Sec - Say 0'),
(27726,0,1,0,52,0,100,0,0,27726,0,0,1,1,18000,0,0,0,0,1,0,0,0,0,0,0,0,'Gorgonna - Say 0 - Say 1'),
(27726,0,2,0,52,0,100,0,1,27726,0,0,1,2,15000,0,0,0,0,1,0,0,0,0,0,0,0,'Gorgonna - Say 1 - Say 2'),
(27726,0,3,0,52,0,100,0,2,27726,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'Gorgonna - Say 2 - Say 3'),

-- Grennix Shivwiggle 27719

(27719,0,0,0,19,0,100,0,12431,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Grennix Shivwiggle - Accepted Quest - Say 0');
Sumber

   ---

3. Out of Body Experience
   NPC : Ruuna the Blind
   Faction : Horde / Alliance
   Error : Item Quest Gossamer Potion dapat digunakan dilokasi, ketika pindah ke Silverpine Forest tidak terjadi event
   Solusi Fix Code : Auto COmplete, karena mungkin Event yang sulit & berat "you will get a loading screen and be in Silverpine forest watching the Shade of Arugal being revived" dan quest ini merupakan kunci chain quest berikutnya yang lumayan panjang.
   
   Code:

   ---

   UPDATE `quest_template` SET `method`='0' WHERE `entry`='12327';

   ---

4. Seared Scourge - Dailyhttp://img220.imageshack.us/img220/8...klisticon2.gif
   NPC : Mack Fearsen
   Faction : Horde / ALliance
   Error : Item quest Mack's Dark Grogdapat digunakan pada sasaran, namun quest tidak terhitung / tidak selesai
   Fix Code : Blizzlike
   
   Code:

   ---

   SET @ENTRY :=26570;
SET @KILLCREDIT :=47208;
SET @SPELL :=47214;
SET @AURA :=47208;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
DELETE FROM `creature_ai_scripts` WHERE `creature_id` = @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,8,0,100,0,@AURA,0,0,0,80,@ENTRY*100,0,2,0,0,0,1,0,0,0,0,0,0,0, 'When spellhit start SAI'),
(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,11,@KILLCREDIT,0,0,0,0,0,17,0,50,0,0,0,0,0, 'q12029 - Killcredit'),
(@ENTRY*100,9,1,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'q12029 - Despawn');
DELETE FROM `conditions` WHERE `sourceEntry`=@SPELL;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
('13','0',@SPELL,'0','18','1',@ENTRY,'0','0','','Burninate Effect Triggered Effect');

SUMBER

   ---

   Spoiler untuk CPP :

   ]src/server/game/Spells/Auras/SpellAuraEffects.cpp http://img84.imageshack.us/img84/801...edscourge1.jpg http://img88.imageshack.us/img88/788...edscourge2.jpg
   @@ -5643,6 +5643,12 @@ void AuraEffect::HandlePeriodicDummyAuraTick(Unit* target, Unit* caster) const
   caster->CastSpell(caster, 54893, true);
   break;
   }
   + case 47214: // Burninate Effect
   + if (!caster || !target || !target->ToCreature() || target->HasAura(47208) || target->GetEntry() != 26570)
   + break;
   +
   + target->CastSpell(target, 47208, true);
   + break;
   case 62292: // Blaze (Pool of Tar)
   // should we use custom damage?
   target->CastSpell((Unit*)NULL, m_spellInfo->Effects[m_effIndex].TriggerSpell, true);
   
   
5. Dun-da-Dun-tah!
   NPC : Harrison Jones
   Faction : Horde / ALlliance
   Error : Event Escort Quest tidak mulai
   Fix Code : Blizzlike Event
   
   Spoiler untuk code :

   
   

   Code:

   ---

   -- Quest Support 12082
DELETE FROM `script_waypoint` WHERE `entry` = 26814;
DELETE FROM `script_texts` WHERE `entry` IN ('-1001051','-1001052','-1001053','-1001054','-1001055','-1001056','-1001057','-1001058','-1001059','-1001060');
UPDATE `creature_template` SET `movementId` = 1,  `ScriptName` = "npc_harrison_jones"WHERE entry = 26814;
UPDATE `creature_equip_template` SET `equipentry1` = 0 WHERE entry = 1421;
-- Jones Waypoints for script
INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`)
VALUES
('26814','0','4905.259766','-4758.709961','27.216401','1000','attacks cage'), -- Start
('26814','1','4905.259766','-4758.709961','27.216401','1000','cage opens, SAY_START'),

-- Start
('26814','2','4890.980469','-4757.920898','27.233480','0',''),
('26814','3','4877.406738','-4774.577148','32.637035','0',''),
('26814','4','4875.632324','-4791.295410','32.521729','0',''),
('26814','5','4878.520508','-4793.985840','32.549927','2000','stops in doorway,

SAY_PROGRESS1'),
('26814','6','4878.520508','-4793.985840','32.549927','1000','same place in doorway,

SAY_PROGRESS2'),
('26814','7','4900.440430','-4797.862305','32.029991','0',''),
('26814','8','4909.792480','-4797.883301','32.504250','1000','starts to open cage'),
('26814','9','4909.792480','-4797.883301','32.504250','3000','opens cage and frees

Adarrah, SAY_PROGRESS3'),
('26814','10','4906.803711','-4807.826172','32.029835','0',''),
('26814','11','4913.215332','-4819.773438','32.543678','0',''),
('26814','12','4914.759277','-4823.177734','32.661606','0',''),
('26814','13','4915.018555','-4823.177246','32.665195','3000','faces skulls, gets skull

mace'),
('26814','14','4915.018555','-4823.177246','32.665195','1000','gets skull mace'),
('26814','15','4914.759277','-4823.177734','32.661606','0',''),
('26814','16','4914.649414','-4823.634766','32.667145','3000','hit gong #1 (shake

effect w sound)'),
('26814','17','4914.649414','-4823.634766','32.667145','3000','hit gong #2 (shake

effect w sound)'),
('26814','18','4909.021973','-4821.312500','32.545052','2000','SAY_PROGRESS4'),
('26814','19','4909.021973','-4821.312500','32.545052','0','SAY_PROGRESS5'),
('26814','20','4892.889648','-4813.415527','32.030029','0',''),
('26814','21','4887.824219','-4806.410156','32.030029','0','trigger firewall'),
('26814','22','4882.279297','-4797.324707','32.566734','0','run to next point,

SAY_PROGRESS6'),
('26814','23','4898.743164','-4805.551758','32.030006','0',''),
('26814','24','4898.885254','-4805.581543','32.030006','2000','SAY_PROGRESS7'),
('26814','25','4898.885254','-4805.581543','32.030006','2000','SAY_PROGRESS8'),
('26814','26','4901.917969','-4811.968262','32.030006','1000','fight starts'),
('26814','27','4898.743164','-4805.551758','32.030006','0','trigger firewall off,

run'),
('26814','28','4898.885254','-4805.581543','32.030006','1000','turn around, run'),
('26814','29','4882.279297','-4797.324707','32.566734','0','run'),
('26814','30','4878.520508','-4793.985840','32.549927','0','doorway, run'),
('26814','31','4853.520996','-4773.153809','32.615387','0','run'),
('26814','32','4831.209961','-4775.220703','32.580078','0','run'),
('26814','33','4815.007324','-4793.448242','25.466448','0','run'),
('26814','34','4827.081543','-4833.012695','25.476900','0','run'),
('26814','35','4826.137695','-4842.380371','25.462563','0','run'),
('26814','36','4820.562988','-4850.163086','25.582867','0','run'),
('26814','37','4803.599121','-4851.593750','25.517899','0','run'),
('26814','38','4769.978516','-4847.950684','25.434967','0','run'),
('26814','39','4759.688477','-4857.292480','25.636557','0','run'),
('26814','40','4717.454102','-4857.819824','25.564335','0','run'),
('26814','41','4714.354492','-4858.347656','24.426430','0','run'),
('26814','42','4673.732422','-4862.985840','35.479126','0','run'),
('26814','43','4659.693359','-4886.814941','35.479156','0','run'),
('26814','44','4658.118652','-4907.916016','38.943035','0','run'),
('26814','45','4650.998047','-4918.918945','45.480255','0','run'),
('26814','46','4655.667480','-4924.229492','46.682201','0','run'),
('26814','47','4668.253906','-4946.233398','47.992596','0','run'),
('26814','48','4673.433594','-4964.857422','47.869415','3000','SAY_END1'),
('26814','49','4678.111328','-4970.680176','47.274849','0','fadeout'); -- Final

Destination
--  Jones Text for script
INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`,

`content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`,

`content_loc8`, `sound`, `type`, `language`, `emote`, `comment`)
VALUES
('-1001051','Alright kid. Stay behind me and you\'ll be fine.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','jones SAY_START'),
('-1001052','Their ceremonial chamber, where I was to be sacrified...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','jones SAY_PROGRESS1'),
('-1001053','Time to put and end to all this!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','jones SAY_PROGRESS2'),
('-1001054','You\'re free to go, miss.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','jones SAY_PROGRESS3'),
('-1001055','Odd. That usually does it.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','jones SAY_PROGRESS4'),
('-1001056','Just as well. I\'ve had enough of this place.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','jones SAY_PROGRESS5'),
('-1001057','What\'s this?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','jones SAY_PROGRESS6'),
('-1001058','Aww, not a snake!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','jones SAY_PROGRESS7'),
('-1001059','Listen, kid. I can handle this thing. You just watch my back!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','jones SAY_PROGRESS8'),
('-1001060','See ya \'round, kid!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','jones SAY_END1');
DELETE FROM `script_waypoint` WHERE `entry` = 24405;
DELETE FROM `script_texts` WHERE `entry` IN ('-1001061');
UPDATE `creature_template` SET `movementId` = 1, `ScriptName` = "npc_adarrah" WHERE

entry = 24405;
-- Adarrah Waypoints for script
INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`,

`location_z`, `waittime`, `point_comment`)
VALUES
('24405','0','4912.772461','-4797.773458','32.644875','1000','cheers'), -- Cheer
('24405','1','4912.772461','-4797.773458','32.644875','1000','SAY_START, emote Kiss'),

-- Say Thanks, Kiss
('24405','2','4910.222656','-4799.891113','32.513424','1000','run'),
('24405','3','4894.567383','-4799.141602','32.029938','0','run'),
('24405','4','4878.586914','-4794.057129','32.552769','0','run'),
('24405','5','4843.632813','-4778.444824','32.610733','0','fadeout'); -- Final

Destination
--  Adarrah Text for script
INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`,

`content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`,

`content_loc8`, `sound`, `type`, `language`, `emote`, `comment`)
VALUES
('-1001061','Thank you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','jones

SAY_START');
DELETE FROM `creature_ai_scripts` WHERE `creature_id` = 26865;
-- Tecahuna EventAI scripts
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
('2686501','26865','0','0','100','1','10000','15000','10000','15000','11','47602','4','

0','11','47602','4','0','0','0','0','0','Tecahuna - Cast Summon Ancient Drakkari

King'),
('2686502','26865','0','0','100','1','15000','25000','15000','25000','11','47629','1','

0','0','0','0','0','0','0','0','0','Tecahuna - Cast Tecahuna Venom Spit');
DELETE FROM `creature_ai_scripts` WHERE `creature_id` = 26871;
-- Tecahuna EventAI scripts
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
('2687101','26871','0','0','100','1','5000','15000','5000','15000','11','52466','1','0'

,'0','0','0','0','0','0','0','0','Ancient Drakkari King - Cast Drakkari Curse');

sumber

   ---

6. Escape from Silverbrook report bYOblivi0n
   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. 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.
   
   
   Code:

   ---

   -- 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.');

   ---

   SUMBER
   
   dan
   
   
   Code:

   ---

   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)

   ---

   SUMBER

BOREAN TUNDRA • SELAMAT ANDA BISA MENDAPATKAN IJASAH BOREAN SO NICEE WORKS FOR GM ^_^ TRIMS
Sumber List : http://forum.indogamers.com/showthread.php?t=499389

1. Blending In http://img220.imageshack.us/img220/8...klisticon2.gif - Now Works Using Item in Temple Area

New List :

1. Drake Hunthttp://img220.imageshack.us/img220/8...klisticon2.gif - Quest terhitung setelah membawa drake ^_^
   
2. Souls of the Decursedhttp://img220.imageshack.us/img220/8...klisticon2.gif - Use Item on Target Complete
   
3. The Honored Deadhttp://img220.imageshack.us/img220/8...klisticon2.gif - Use Item on Target Complete
4. Neutralizing The Cauldronshttp://img220.imageshack.us/img220/8...klisticon2.gif - Use Item on spot complete
   
5. We Strike!http://img820.imageshack.us/img820/9...estionedit.png
6. Springing the Traphttp://img820.imageshack.us/img820/9...estionedit.png
7. Across Transboreahttp://img820.imageshack.us/img820/9...estionedit.png

Unofficial Fixing Borean Tundra

Spoiler untuk Borean Tundra :

Demikian Hasil Penelitian & pencarian dari kami, kepada Tim GM mohon di cek apakah script2 diatas berfungsi dan aman ^_^,
Semoga Tim GM tak bosan-bosannya mengecek list diatas hehe, kami tunggu kabarnyaaa..

Terima kasih banyak :D

BOREAN TUNDRA HORDE -1 BUAT DAPET IJASAH KYAA

help gm satu lagi, gemes nihh

hahay mantap Tim GM nya gerak cepaat gesit, but borean -1 kwkwkwk gemeess ya jadinya, @Cajun , @Najre, @Abud ada kabar terbaru ga nih dari borean, masih mudik belum bisa OL nih hehehe

Post Updated

kemaren cek sih belum ada yg baru di borean,,, nanti deh cek lagi moga2 dapet :D

masih -1 saya,senasib sama cajun,ga ngerti cara bunuh price valanar questBreaking Through,huhu

sama stuck d Breaking Through
kalo untuk horde di /tar Prince Valanar pasti ada, tp itu valanar untuk quest ally
valanar yg musti d bunuh horde ada d dalem Naxxanar nya, cb pehatiin screenshot 3 n 4 nya http://old.wowhead.com/quest=11898#screenshots
kalo kita tele ke lantai 2 malah di tele ke atas gedung bukan ke dalemnya..

untuk chaar horde lama (sebelum update core beberapa kali ini) Nothing Boring About Borean uda bisa, tp kalo char baru bikin pasti stuck d 149, soalnya ada beberapa npc quest giver ilank..