Page 1 of 3 123 LastLast
Results 1 to 15 of 38
http://idgs.in/530088
  1. #1
    Anz69's Avatar
    Join Date
    May 2010
    Location
    Grizzly Hills
    Posts
    326
    Points
    372.64
    Thanks: 78 / 136 / 22

    Default 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

    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 :


    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 View Post
    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


    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



    UPDATE TERBARU <<<<<<
    Last edited by Anz69; 17-05-12 at 18:12. Reason: uPDATE 27-04-2012

  2. Hot Ad
  3. The Following 7 Users Say Thank You to Anz69 For This Useful Post:
  4. #2

    Join Date
    Oct 2009
    Posts
    62
    Points
    85.96
    Thanks: 9 / 6 / 5

    Default

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

  5. #3
    Emiya's Avatar
    Join Date
    Jun 2007
    Location
    di kos fadli
    Posts
    355
    Points
    400.01
    Thanks: 18 / 60 / 26

    Default

    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
    Titania LoL's Beloved Leader

  6. #4
    vantheman's Avatar
    Join Date
    Apr 2008
    Location
    Altar of Hell
    Posts
    224
    Points
    188.10
    Thanks: 17 / 39 / 21

    Default

    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)

    Ranger

  7. #5
    rajoitam's Avatar
    Join Date
    Feb 2010
    Location
    BENGKULU!
    Posts
    376
    Points
    388.32
    Thanks: 29 / 16 / 13

    Default

    GG.......
    tp ane msh jauh bener buat dapetin Loremaster T_T
    http://static.indogamers.com/signaturepics/sigpic207776_1.gif

  8. #6
    oblivi0n's Avatar
    Join Date
    Nov 2011
    Location
    Solitary Ground
    Posts
    157
    Points
    120.10
    Thanks: 4 / 5 / 4

    Default

    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 :

    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


      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


  9. #7
    Anz69's Avatar
    Join Date
    May 2010
    Location
    Grizzly Hills
    Posts
    326
    Points
    372.64
    Thanks: 78 / 136 / 22

    Default

    Quote Originally Posted by najre View Post
    wah baik sekali kinerja dari kk noray.. contoh player yg harus di perbanyak, peduli dengan sesama
    ditunggu fixnya ini
    Quote Originally Posted by Emiya View Post
    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 View Post
    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 View Post
    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 View Post
    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 :

    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


      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

  10. #8
    oblivi0n's Avatar
    Join Date
    Nov 2011
    Location
    Solitary Ground
    Posts
    157
    Points
    120.10
    Thanks: 4 / 5 / 4

    Default

    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


  11. #9

    Join Date
    Apr 2012
    Posts
    6
    Points
    3.02
    Thanks: 0 / 2

    Default

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

  12. #10
    Anz69's Avatar
    Join Date
    May 2010
    Location
    Grizzly Hills
    Posts
    326
    Points
    372.64
    Thanks: 78 / 136 / 22

    Default HOWLING, GRIZZLY, BOREAN

    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

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

    Keterangan Status Quest :
    = Telah Di Fix ^_^
    = Sedang dalam proses / Antrian dengan unofficial fixing & keterangan error di bagian bawah Post
    = 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
    2. Eyes of the Eagle - Attackable Talonshrike
    3. The Slumbering King - Now Hostile
    4. The Frost Wyrm and its Master - Now Spawned
    5. Draconis Gastritis - Item Works on Drakes
    6. A Carver and a Croaker
    7. The Rune of Command


    New List :

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

    Unofficial Fixing Howling Fjord

    Spoiler untuk Howling :

    1. Gambling Debt
      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
      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
      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 Worg
      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 Hell
      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 Troops - Item Works on NPC
    2. Loken's Orders - Event Works
    3. Bringing Down the Iron Thane - Now Spawned
    4. Dun-da-Dun-tah!


    New List :


    1. Runes of Compulsion
    2. The Conquest Pit : Bear Wrestling !
    3. Out of Body Experience
    4. Seared Scourge
    5. Subject to Interpretation
    6. Shred The Alliance
    7. See You on the Other Side
    8. Riding the Red ROcket
    9. Escape from Silverbrook



    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 !
      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 - Daily
      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
      @@ -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 - Now Works Using Item in Temple Area


    New List :

    1. Drake Hunt - Quest terhitung setelah membawa drake ^_^
    2. Souls of the Decursed - Use Item on Target Complete
    3. The Honored Dead - Use Item on Target Complete
    4. Neutralizing The Cauldrons - Use Item on spot complete
    5. We Strike!
    6. Springing the Trap
    7. Across Transborea


    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
    Last edited by Anz69; 17-05-12 at 18:15.

  13. The Following 2 Users Say Thank You to Anz69 For This Useful Post:
  14. #11

    Join Date
    Jun 2008
    Posts
    154
    Points
    171.60
    Thanks: 2 / 1 / 1

    Default

    BOREAN TUNDRA HORDE -1 BUAT DAPET IJASAH KYAA

    help gm satu lagi, gemes nihh

  15. #12
    Anz69's Avatar
    Join Date
    May 2010
    Location
    Grizzly Hills
    Posts
    326
    Points
    372.64
    Thanks: 78 / 136 / 22

    Default

    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

  16. #13

    Join Date
    Oct 2009
    Posts
    62
    Points
    85.96
    Thanks: 9 / 6 / 5

    Default

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

  17. #14

    Join Date
    Jan 2012
    Posts
    29
    Points
    8.95
    Thanks: 6 / 0 / 0

    Default

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

  18. #15

    Join Date
    Aug 2009
    Posts
    11
    Points
    2.10
    Thanks: 0 / 1 / 1

    Default

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

Page 1 of 3 123 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •