Page 10 of 11 FirstFirst ... 67891011 LastLast
Results 136 to 150 of 160
http://idgs.in/299687
  1. #136
    heaven1st's Avatar
    Join Date
    Aug 2007
    Location
    Bandung
    Posts
    635
    Points
    795.13
    Thanks: 31 / 139 / 54

    Default

    Forge of Souls & Pit of Saron Bugs

    FORGE OF SOULS
    Missing Apprentice Nelphi & Dark Ranger Vorel buat quest Inside the Frozen Citadel (http://www.wowhead.com/quest=24712,24510)
    Keterangan:
    2 NPC ini belum spawn di dalaran. Jadi tinggal di spawnin.

    Missing Lady Jaina Proudmoore (http://www.wowhead.com/npc=37597)
    Keterangan:
    Karena script npc di fos masi error, jadi dispawnin aja lady nya.

    Generic Lady Sylvanas & Jaina faction
    Keterangan:
    Biar horde ga bisa ambil quest dari jaina, dan kebalikannya. Masing2 harus diganti faction nya menjadi 714(horde generic) dan 534(alliance generic).

    Error alliance chain quest
    Keterangan:
    Kalo jainanya di spawnin, bakal muncul quest2 yg seharusnya bukan started oleh jaina.

    Terutama buat alliance yang ampe sekarang FOS masi error, semoga fix ini bisa membantu.
    Ini pic nya,
    Spoiler untuk fos :








    PIT OF SARON

    Untargetable Scourgelord Tyrannus (http://www.wowhead.com/npc=36658)
    Keterangan:
    Unit_flags awalnya diisi 335544xx, yang artinya UNIT_FLAG_NOT_SELECTABLE (Can't be selected by mouse). Jadi disamain aja dengan ick.

    Replacing Gorkun Ironskull & Missing Martin Victus buat complete quest The Path to the Citadel
    Keterangan:
    Gorkun berada ditengah2 TM, harusnya ditangga deket ICK.
    Martin victus(ally) buat starting quest buat ngebunuh tyrannus ga ada.

    Missing Alliance Slave & ball and chain
    Keterangan:
    Hanya ada horde slaves, jadi dispawnin.
    Quest nya belum ter-relasi dengan ball and chain. jadi fix horde slave nya dipake kesini, tapi entry quest nya yang diganti.

    Missing Lady Sylvanas & Jaina buat complete quest Deliverance from the Pit (http://www.wowhead.com/quest=24710,24712)
    Keterangan:
    Setelah mengalahkan tyrannus, seharusnya quest dibalikkan ke lady sylva or jaina, tapi ga ada NPC nya.


    Tested FIX:

    Spoiler untuk sql :

    Code:
    UPDATE creature_template SET unit_flags=64 WHERE entry=36658; --Scourgelord Tyrannus
    UPDATE creature_template SET faction_A=714,faction_H=714 WHERE entry=37596; --Sylvanas
    
    UPDATE creature_template SET faction_A=534,faction_a=534 WHERE entry=37597; --Jaina
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('281362','37597','632','1','1','0','1221','4901.04','2210.31','638.734','5.77518','300','0','0','5040000','881400','0','0');
    
    UPDATE creature_involvedrelation SET id=38160 WHERE quest=24499;
    UPDATE creature_questrelation SET id=38160 WHERE quest=24683;
    UPDATE creature_involvedrelation SET id=36993 WHERE quest=24683;
    
    -- Apprentice Nelphi & Dark Ranger Vorel buat quest Inside the Frozen Citadel
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('283553','37780','571','1','1','0','10034','5892.59','646.174','645.512','5.61659','300','0','0','75600','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('283227','37776','571','1','1','0','637','5717.65','642.358','646.223','5.84424','300','0','0','60480','8814','0','2');
    
    -- Lady Sylvanas & Jaina buat complete quest Deliverance from the Pit (http://www.wowhead.com/quest=24710,24712)
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('286843','38188','658','1','1','0','0','1175.44','331.468','627.621','3.99118','300','0','0','5040000','881400','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('286685','38189','658','1','1','0','0','1178.23','335.351','627.621','4.08294','300','0','0','6972500','85160','0','0');
    
    -- Gorkun Ironskull & Martin Victus buat complete quest The Path to the Citadel
    DELETE FROM creature WHERE id IN (37591,37592);
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285965','37591','658','1','1','0','0','854.77','35.1765','512.248','3.61753','300','0','0','126000','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285929','37592','658','1','1','0','254','850.17','44.9676','512.56','3.7746','300','0','0','126000','0','0','0');
    
    -- Alliance slave at Pit of Saron
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285392','36766','658','1','1','0','254','869.352','13.3887','509.979','1.13906','300','0','0','37800','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285390','36767','658','1','1','0','0','881.49','-3.75018','509.657','5.74542','300','0','0','30240','8814','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285331','36764','658','1','1','0','254','791.239','-26.9027','508.429','5.01813','300','0','0','37800','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285328','36764','658','1','1','0','254','778.339','-35.4808','508.354','5.39512','300','0','0','37800','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285310','36764','658','1','1','0','254','774.738','-39.4847','508.355','5.84673','300','0','0','37800','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285307','36765','658','1','1','0','254','771.937','-46.2617','508.361','6.26691','300','0','0','37800','3994','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285305','36766','658','1','1','0','254','766.401','-51.5076','508.391','5.31266','300','0','0','37800','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285294','36767','658','1','1','0','0','761.905','-53.0169','509.221','5.57655','300','0','0','30240','8814','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285246','36767','658','1','1','0','0','695.589','-82.0569','512.583','6.20801','300','0','0','30240','8814','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285236','36767','658','1','1','0','0','670.247','-56.3428','512.583','0.626182','300','0','0','30240','8814','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285228','36766','658','1','1','0','254','668.016','-46.9257','513.597','0.421976','300','0','0','37800','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285226','36765','658','1','1','0','254','660.869','-44.4866','512.615','0.391345','300','0','0','37800','3994','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285224','36764','658','1','1','0','254','656.688','-38.8909','512.583','0.132949','300','0','0','37800','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285205','36764','658','1','1','0','254','585.357','0.0347102','512.586','2.96038','300','0','0','37800','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285138','36766','658','1','1','0','254','597.157','30.7501','512.003','2.44987','300','0','0','37800','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285113','36765','658','1','1','0','254','588.4','13.6761','512.63','2.5292','300','0','0','37800','3994','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285103','36764','658','1','1','0','254','582.682','-11.7032','512.765','3.13396','300','0','0','37800','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285089','36766','658','1','1','0','254','587.405','-20.8722','512.588','4.04502','300','0','0','37800','0','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('285081','36767','658','1','1','0','0','599.098','-16.7448','512.613','5.23568','300','0','0','30240','8814','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('284971','36765','658','1','1','0','254','582.515','69.9865','525.193','1.02046','300','0','0','37800','3994','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('284947','36767','658','1','1','0','0','573.345','81.169','526.622','2.69886','300','0','0','30240','8814','0','0');
    insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('284876','36764','658','1','1','0','254','570.159','87.1936','526.614','6.00539','300','0','0','37800','0','0','0');
    
    -- Ball and Chain alliance slave
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151411','201969','658','1','1','881.03','-3.1896','509.658','4.11965','0','0','0.88279','-0.469768','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151409','201969','658','1','1','868.614','12.8286','510.009','5.62761','0','0','0.321951','-0.946756','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151407','201969','658','1','1','777.443','-36.0215','508.355','5.70693','0','0','0.284157','-0.958778','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151405','201969','658','1','1','773.806','-38.774','508.355','4.28144','0','0','0.841943','-0.539566','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151403','201969','658','1','1','772.185','-47.4847','508.356','0.393697','0','0','0.195579','0.980688','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151401','201969','658','1','1','767.011','-52.3875','508.355','0.75734','0','0','0.369685','0.929157','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151399','201969','658','1','1','761.135','-53.7197','509.344','6.06271','0','0','0.110016','-0.99393','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151397','201969','658','1','1','657.438','-38.6877','512.583','2.02499','0','0','0.848155','0.529748','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151395','201969','658','1','1','661.698','-44.0402','512.583','1.99357','0','0','0.83973','0.543005','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151393','201969','658','1','1','668.743','-46.6269','513.597','2.30851','0','0','0.914495','0.404598','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151391','201969','658','1','1','669.74','-57.0125','512.583','5.86244','0','0','0.208825','-0.977953','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151389','201969','658','1','1','694.847','-81.6845','512.583','4.80608','0','0','0.67322','-0.739442','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151387','201969','658','1','1','586.158','-0.354599','512.588','1.47598','0','0','0.672803','0.739822','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151385','201969','658','1','1','598.813','-16.256','512.604','3.68294','0','0','0.963591','-0.267381','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151383','201969','658','1','1','586.577','-21.0136','512.589','4.99456','0','0','0.60065','-0.799512','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151381','201969','658','1','1','582.841','-10.9919','512.722','3.64368','0','0','0.968654','-0.248415','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151379','201969','658','1','1','588.588','14.4825','512.712','2.86613','0','0','0.99053','0.137295','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151377','201969','658','1','1','597.457','30.0695','511.983','0.973323','0','0','0.467678','0.883899','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151375','201969','658','1','1','583.558','70.2277','525.193','1.55059','0','0','0.699929','0.714213','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151373','201969','658','1','1','572.988','81.9234','526.375','3.26669','0','0','0.998044','-0.0625097','300','0','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('151371','201969','658','1','1','569.962','86.5999','526.628','6.10198','0','0','0.0904775','-0.995898','300','0','1');
    
    UPDATE quest_template SET ReqCreatureOrGoId1=-201969 WHERE entry=24498; -- Ball and chain
    Last edited by heaven1st; 26-11-10 at 03:09. Reason: 100% tested horde ally fos pos now until tyrannus!
    If mood>0 Then open=notepad+,sqlyog,chrome,dbceditor Else sleep EndIf

  2. Hot Ad
  3. The Following User Says Thank You to heaven1st For This Useful Post:
  4. #137

    Join Date
    Mar 2009
    Posts
    60
    Points
    76.00
    Thanks: 13 / 6 / 4

    Default

    om heaven1st, bisa request buat achievement The Lurker Above http://www.wowhead.com/achievement=144 ?
    sudah saya tes di cfr lurker nya kepancing dan ga dapet achievementnya. thanks before.

  5. #138
    heaven1st's Avatar
    Join Date
    Aug 2007
    Location
    Bandung
    Posts
    635
    Points
    795.13
    Thanks: 31 / 139 / 54

    Default

    Quote Originally Posted by Kranky View Post
    om heaven1st, bisa request buat achievement The Lurker Above http://www.wowhead.com/achievement=144 ?
    sudah saya tes di cfr lurker nya kepancing dan ga dapet achievementnya. thanks before.
    kalo baca di forum trinity nya sih katanya masalah core. emang di database ada yg namanya achievement_criteria_data, bisa diutak atik. Tapi katanya spell Lurker Spawn Trigger nya ga jalan. jadi masalahnya ada di core. Dan gw kurang bisa kalo soal core. haha. pis ah.. ~(-_-~)
    If mood>0 Then open=notepad+,sqlyog,chrome,dbceditor Else sleep EndIf

  6. The Following User Says Thank You to heaven1st For This Useful Post:
  7. #139

    Join Date
    Mar 2009
    Posts
    60
    Points
    76.00
    Thanks: 13 / 6 / 4

    Default

    oohh ke core bukan ke db ya. ok thanks atas reply nya

  8. #140
    lentho's Avatar
    Join Date
    Feb 2010
    Posts
    157
    Points
    214.80
    Thanks: 41 / 30 / 17

    Default

    om heaven1st yang tampan.... tolong dibantu fix dong chain quest Son OF Hodir yang [going bearback]... beruangnya mestinya bisa dinaikin... tapi ini beruangnya ga bisa dinaikin.... char baru susah nasibnya kalo mesti reput pake emblem.. thanks/....

    yang ini kk http://thottbot.com/q12851

  9. #141
    heaven1st's Avatar
    Join Date
    Aug 2007
    Location
    Bandung
    Posts
    635
    Points
    795.13
    Thanks: 31 / 139 / 54

    Default

    Quote Originally Posted by lentho View Post
    om heaven1st yang tampan.... tolong dibantu fix dong chain quest Son OF Hodir yang [going bearback]... beruangnya mestinya bisa dinaikin... tapi ini beruangnya ga bisa dinaikin.... char baru susah nasibnya kalo mesti reput pake emblem.. thanks/....

    yang ini kk http://thottbot.com/q12851

    gw malah farm eot 90an buat exalted in SOH. haha. ok2 tar diliat dlu ya.
    If mood>0 Then open=notepad+,sqlyog,chrome,dbceditor Else sleep EndIf

  10. #142
    heaven1st's Avatar
    Join Date
    Aug 2007
    Location
    Bandung
    Posts
    635
    Points
    795.13
    Thanks: 31 / 139 / 54

    Default

    Quote Originally Posted by lentho View Post
    om heaven1st yang tampan.... tolong dibantu fix dong chain quest Son OF Hodir yang [going bearback]... beruangnya mestinya bisa dinaikin... tapi ini beruangnya ga bisa dinaikin.... char baru susah nasibnya kalo mesti reput pake emblem.. thanks/....

    yang ini kk http://thottbot.com/q12851

    gw malah farm eot 90an buat exalted in SOH. haha. ok2 tar diliat dlu ya.
    If mood>0 Then open=notepad+,sqlyog,chrome,dbceditor Else sleep EndIf

  11. #143
    EX_VANZORE's Avatar
    Join Date
    Mar 2009
    Location
    Panpukin Kafe.
    Posts
    319
    Points
    637.08
    Thanks: 68 / 45 / 22

    Default

    Bro heaven1st, tolong lihat ini dong. smile:
    Makasih sebelumnya.

    Link= http://www.indogamers.com/showthread...=1#post4997101
    Spoiler untuk isi dari link :

    mau lapor talent DK yg nge-bug,.

    1.)
    Improved Unholy Presence (2/2)
    While in Blodd Presence or Frost Presence, you retain 15% increased movement speed from Unholy Presence, and your runes finish 10% faster in Unholy Presence.

    Hijau = Movement speed jalan di semua presence.
    Merah = Belum jalan. harusnya jika sudah mengambil talent ini maka Rune regen jadi 9 detik (10detik jika tidak mengambil IUP).

    Spoiler untuk Improved Unholy Presence's source :

    "...Before casting any spells, the death knight has three pairs, totaling six runes. Different abilities and spells consume different types and amounts of runes and, when used, will place the corresponding rune on a 10 second cooldown (9 seconds if in Unholy Presence, having Improved Unholy Presence). Some abilities are able to refresh certain runes; Empower Rune Weapon will refresh all of them..." http://www.wowwiki.com/Rune_system


    2.)
    Gargoyle Attack.
    Harusnya Gargoyle ngikut command pet (bersama ghoul)
    jika ghoul attack target maka gargoyle juga attack target itu (ctrl+1, pet attack),
    jika ghoul follow target maka gargoyle juga follow target itu (ctrl+2, pet follow),

    nah di ampm, Jika sudah ktemu class yg bisa membikin hilang target (Vanish/ Shadowmeld / Feign death / Invisibility)
    maka gargoyle akan kehilangan target dan menyerang target lainnya, walaupun sudah re-target. Biasanya ketika melawan hunter, maka ghoul akan menyerang pet hunter, walaupun ghoul sudah re-target ke hunter. Cara mengakalin balik yaitu, kill pet hunter, maka gargoyle akan kembali nyerang hunter.
    Spoiler untuk source? :

    6. Here is macro, thanks to Proditor, that allows you to control your not-so-well-designed Gargoyle, while keeping your ghoul on whichever target you want. I'm not sure if there's currently an easier way to do this, but this is the only method I've found that actually works. It's going to change your focus, but it's definitely worth it. This will summon the gargoyle, and if you wish to change its target, simply use the macro again on
    whatever target you desire:
    Code:
    /cast summon gargoyle
    /focus pettarget
    /petfollow
    /petattack
    /petattack [@focus]
    source:
    http://www.mmowned.com/forums/world-...s-new-dks.html

    http://www.arenajunkies.com/showthread.php?t=147331




    Masa kita harus ngikut pet(gargoyle), yg pet sekarang siapa? /rofl
    Untuk DK yg lain mohon konfirmasi juga.

    Army of The Dead[th]Knight

  12. #144
    st4rgaze's Avatar
    Join Date
    Apr 2008
    Posts
    159
    Points
    216.70
    Thanks: 5 / 30 / 4

    Default

    dah mati nih tret? sape yg bunuh?

  13. #145
    ilhamyt's Avatar
    Join Date
    Sep 2009
    Location
    Cirebon
    Posts
    2,916
    Points
    940.94
    Thanks: 284 / 81 / 71

    Default

    bukannya dah ngundurin diri ya

  14. #146
    sahacing's Avatar
    Join Date
    Jan 2009
    Location
    Cimahi / Jakarta
    Posts
    5,372
    Points
    8,325.22
    Thanks: 163 / 296 / 171

    Default

    Quote Originally Posted by ilhamyt View Post
    bukannya dah ngundurin diri ya
    sebelum jadi GM emang udah ada deh ini thread
    http://static.indogamers.com/signaturepics/sigpic156451_35.gif

  15. #147
    orvalentine's Avatar
    Join Date
    Aug 2007
    Posts
    445
    Points
    580.30
    Thanks: 16 / 21 / 18

    Default

    Kalo ini thread masih hidup, om Heavenfirst bisa tolong cariin solusi buat ngidupin :

    Mail dari blizzard kalo misalnya pemakaian equip kita error, sebelom maintenens ini mail dari blizzard jalan fine fine aja, tapi sekarang dah jadi masalah global semua kehilangan eq, en rasa - rasanya mah gara2 ini mail blizzard gak jalan, CMIIW (bukan masalah DK only ato talent error sepertinya).

  16. #148
    Totonk's Avatar
    Join Date
    Feb 2010
    Posts
    507
    Points
    587.70
    Thanks: 22 / 28 / 19

    Default

    kalo masih ada GM mampir k sini mngkin bisa buka http://www.trinitycore.org/t/trinity...ma.patch.patch

    smoga bisa ngefix bug dari Divine Storm,,

  17. #149
    fack_me's Avatar
    Join Date
    Oct 2010
    Location
    Iron Forge
    Posts
    124
    Points
    156.70
    Thanks: 9 / 17 / 8

    Default

    Quote Originally Posted by Totonk View Post
    kalo masih ada GM mampir k sini mngkin bisa buka http://www.trinitycore.org/t/trinity...ma.patch.patch

    smoga bisa ngefix bug dari Divine Storm,,
    Pake Tehnik S.kom ga bisa?
    NE War - Krypton
    Human Pally - Argon
    Gnome Mage - Nattlee

  18. #150
    Totonk's Avatar
    Join Date
    Feb 2010
    Posts
    507
    Points
    587.70
    Thanks: 22 / 28 / 19

    Default

    Quote Originally Posted by fack_me View Post
    Pake Tehnik S.kom ga bisa?
    daftar jadi GM sono,,kan ude sekom,,

Page 10 of 11 FirstFirst ... 67891011 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
  •