Unofficial Bug Fixing

[DickDzink]

walah,gk nyangka ne
ternyata kamulah si mamang Irhaz @@

[heaven1st]

read first sebelum jatuhin penilaian , gue uda posting di halaman 4 , sunlounger juga da posting di halaman 3. Ga semua yang di fix disini bisa langsung di apply.

makanya baca dulu , baru ngebanyol ngeluarin statement nya.

Btw bug quest zuluhed the whacked uda pernah gw kasi fix nya di page one. tolong dipake lagi dong fix dari gw. soalnya ga jalan lagi quest nya bos. Pada nanyain di channel. thanks.

[Darkdaviz]

Ok gw lanjutin fixnya, tapi skrg gw lebih fokus ke Quest ama NPC bug dulu.. Soalnya spesialisasi gw di database, bukan di core (item + spell). Im sorry for being late.

akhirnya ... cerita bersambung lewat Quest bisa ane lanjutin ... makasih om.

[BebeghTempoer]

halah.. sotoy nih bebekgoreng. haha.

[/B]

hmmh hmm brarti yg waktu itu curhat di tempat si dika trus bilang "wah lagi males lagian.... bla bla bla" bukan maneh brarti ya...

eee iya ini... tolong itu shadowform sering nyangkut has klo di BG... gak bisa di klik biar dah reload ato console reloadui juga...

[Improved Poisons] jg yg bwat deadly poisonnya gak jalan TQ

[kuroi_eru]

Btw bug quest zuluhed the whacked uda pernah gw kasi fix nya di page one. tolong dipake lagi dong fix dari gw. soalnya ga jalan lagi quest nya bos. Pada nanyain di channel. thanks.

（つ^_^）つ Lanjutkan Gan!!! X3

[heaven1st]

Bug NPC Efrem the Faithful ga bisa di hit + (Sigrid Iceborn, Efrem the Faithful, Onu'zun, Tinky Wickwhistle) Neutral faction (http://www.wowhead.com/quest=12955)
Keterangan:
> Sigrid Iceborn, Efrem the Faithful, Onu'zun, Tinky Wickwhistle pake faction yang salah, jadi warna nya kuning/netral. Harusnya hostile ke A/H. Jadi ubah faction_A ama faction_H nya ke 14(monster).
> Efrem ga bisa di hit karena salah unit_flags (pake unit_flags ambient), jadi diubah aja unit_flags=0.
Tested Fix:

Spoiler untuk sql :

--Sigrid Iceborn, Efrem the Faithful, Onu'zun, Tinky Wickwhistle
UPDATE creature_template SET faction_A=14,faction_H=14 WHERE entry IN (30086,30081,30180,30162); 

--Efrem the Faithful (http://www.wowhead.com/npc=30081)
UPDATE creature_template SET unit_flags=0 WHERE entry=30081;

[heaven1st]

Missing NPCs in Argent Vanguard


Missing Highlord Tirion Fordring (http://www.wowhead.com/npc=28179) & Crusade Commander Entari (http://www.wowhead.com/npc=30223) at Argent Vanguard

Scourge Tactics (http://www.wowhead.com/quest=13008) ReqCreature & Missing Webbed Creature (http://www.wowhead.com/npc=30268)
Keterangan:
Quest scourge tactic mengharuskan untuk meng-attack webbed creature.
Webbed creature nya belum di spawn.

Missing NPC Penumbrius (http://www.wowhead.com/npc=30227) at Argent Vanguard

Missing Crusader Lord Dalfors (http://www.wowhead.com/npc=30224) at Argent Vanguard

Forgotten Depths Mobs Spawn (http://www.wowhead.com/npc=30204,30205,30333)
Keterangan:
Mob buat quest Defending The Vanguard belum spawn.
Di DB nya faction_A ama _H nya masi 35. Harus di ubah jadi 14(monster) biar jadi hostile.

Father Gustav (http://www.wowhead.com/npc=30226) ketuker/ salah entry
Keterangan:
Harusnya yang spawn di argent vanguard itu, entry=30226. Tapi yang spawn malah 30683. Walopun sama2 father gustav, tapi 30683 bukan bagian dari chain quest.

Missing Argent Skytalon (http://www.wowhead.com/npc=30228) buat Quest Into The Wild Green Yonder
Missing Argent Skytalon skills, Grab Captured Crusader & Drop off Captured Crusader
Keterangan:
Seharusnya quest nya diselsein dengan vehicle argent skytalon. tapi skill grab captured crusader nya masi error. jadi dibuat script aja, setelah quest diambil, argent skytalon + captured crusader spawn.


Tested fix:

Spoiler untuk sql :

--Higlord Tirion Fordring Spawn 
--Crusade Commander Entari Spawn
DELETE FROM `creature` WHERE `id` IN (28179,30223);
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('269572','28179','571','1','1','0','547','6255.93','-44.4343','421.415','4.71001','300','0','0','13945000','4258000','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('270324','30223','571','1','1','0','0','6254.81','-19.908','410.049','1.00687','300','0','0','100800','0','0','0');

--Scourge Tactics (http://www.wowhead.com/quest=13008) ReqCreature
UPDATE quest_template SET ReqCreatureOrGOId1=30268 WHERE entry=13008;

--Webbed Creature (http://www.wowhead.com/npc=30268) Spawn 
UPDATE creature_template SET minlevel=79,maxlevel=80,faction_A=7,faction_H=7,unit_flags=512 WHERE entry=30268;
DELETE FROM creature WHERE id=30268;
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('276070','30268','571','1','1','0','0','6290.27','131.467','387.215','1.22914','300','0','0','1','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('276071','30268','571','1','1','0','0','6269.52','160.989','382.766','1.77892','300','0','0','1','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('276078','30268','571','1','1','0','0','6318.13','191.069','388.66','6.02792','300','0','0','1','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('276079','30268','571','1','1','0','0','6373.53','139.499','392.196','5.06974','300','0','0','1','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('276080','30268','571','1','1','0','0','6333.29','113.481','391.138','4.72181','300','0','0','1','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('276111','30268','571','1','1','0','0','6318.78','67.2898','388.215','0.688786','300','0','0','1','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('276115','30268','571','1','1','0','0','6408.25','158.69','394.793','1.19144','300','0','0','1','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('276116','30268','571','1','1','0','0','6282.09','229.14','390.008','2.19282','300','0','0','1','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('276117','30268','571','1','1','0','0','6233.35','211.148','386.399','3.35128','300','0','0','1','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('276118','30268','571','1','1','0','0','6225.59','163.875','380.753','2.76302','300','0','0','1','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('276119','30268','571','1','1','0','0','6171.58','150.973','373.992','2.74731','300','0','0','1','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('276120','30268','571','1','1','0','0','6161.53','108.401','374.59','5.42945','300','0','0','1','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('276121','30268','571','1','1','0','0','6108','114.362','369.54','3.89792','300','0','0','1','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('276129','30268','571','1','1','0','0','6125.36','59.5934','369.399','0.845862','300','0','0','1','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('276150','30268','571','1','1','0','0','6357.12','176.027','390.692','0.76732','300','0','0','1','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('276165','30268','571','1','1','0','0','6184.33','194.96','379.061','2.33811','300','0','0','1','0','0','0');

--Penumbrius (http://www.wowhead.com/npc=30227) Spawn 
DELETE FROM creature WHERE id=30227;
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('276483','30227','571','1','1','0','0','6120.09','-28.2037','383.51','2.17643','300','0','0','88200','0','0','0');

--Crusader Lord Dalfors Spawn (http://www.wowhead.com/npc=30224)
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('277697','30224','571','1','1','0','0','6256.51','46.2487','387.841','0.939325','300','0','0','88200','31952','0','0');

--Forgotten Depths Mobs Spawn (http://www.wowhead.com/npc=30204,30205,30333)
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('278043','30204','571','1','1','0','0','6323.09','83.2156','389.944','0.48458','300','0','0','11770','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('278051','30204','571','1','1','0','0','6352.36','98.2929','391.765','1.83546','300','0','0','11379','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('278060','30204','571','1','1','0','0','6268.63','130.668','384.756','2.95073','300','0','0','11379','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('278087','30204','571','1','1','0','0','6229.65','161.311','380.448','2.2046','300','0','0','11770','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('278094','30204','571','1','1','0','0','6161.12','145.527','372.967','4.68253','300','0','0','11770','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('278126','30204','571','1','1','0','0','6407.22','160.627','394.715','5.04224','300','0','0','11770','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('278169','30204','571','1','1','0','0','6287.51','194.913','386.052','5.17025','300','0','0','11379','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('278176','30204','571','1','1','0','0','6430.27','210.985','397.632','1.40034','300','0','0','11770','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('278102','30205','571','1','1','0','0','6151.23','112.502','373.23','5.7703','300','0','0','11379','3725','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('278103','30205','571','1','1','0','0','6104.24','118.159','369.04','3.45338','300','0','0','11770','3809','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('278104','30205','571','1','1','0','0','6133.57','166.744','371.074','4.1516','300','0','0','11770','3809','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('278105','30205','571','1','1','0','0','6185.27','192.196','378.552','1.37129','300','0','0','11379','3725','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('278177','30205','571','1','1','0','0','6447.29','184.108','392.48','2.0208','300','0','0','11379','3725','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('278192','30205','571','1','1','0','0','6342.29','223.682','392.657','4.28511','300','0','0','11379','3725','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('278112','30333','571','1','1','0','0','6211.11','234.631','387.047','0.848995','300','0','0','11379','3725','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('278121','30333','571','1','1','0','0','6227.87','216.227','386.288','5.45536','300','0','0','11770','3809','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('278122','30333','571','1','1','0','0','6246.58','249.055','390.677','2.57295','300','0','0','11379','3725','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('278123','30333','571','1','1','0','0','6285.69','229.524','390.316','5.71375','300','0','0','11379','3725','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('278124','30333','571','1','1','0','0','6328.93','188.731','389.06','5.47185','300','0','0','11770','3809','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('278125','30333','571','1','1','0','0','6360.51','178.833','390.981','6.03341','300','0','0','11770','3809','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('278127','30333','571','1','1','0','0','6373.6','135.137','392.163','4.06677','300','0','0','11770','3809','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('278142','30333','571','1','1','0','0','6332.11','117.708','390.829','2.62949','300','0','0','11770','3809','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('278185','30333','571','1','1','0','0','6408.62','187.348','395.77','1.52993','300','0','0','11770','3809','0','0');

--Forgotten Depths hostile faction A/H
UPDATE creature_template SET faction_A=14,faction_H=14 WHERE entry IN (30204,30205,30333);

--Real Father Gustav (http://www.wowhead.com/npc=30226) Replace
UPDATE creature SET id=30226 WHERE id=30683;

-- Argent Skytalon Fix and Script
UPDATE creature_template SET spell1=56683,spell2=56684,InhabitType=4 WHERE entry=30228;
UPDATE quest_template SET QuestFlags=2 WHERE entry=13045;
INSERT INTO quest_start_scripts VALUES (13045,0,10,30228,900000,0,6109.276367,-32.520367,383.510620,0.753534);
INSERT INTO quest_start_scripts VALUES (13045,0,10,30407,900000,0,6109.276367,-32.520367,383.510620,0.753534);
UPDATE quest_template SET StartScript=13045 WHERE entry=13045;

[heaven1st]

Bug Chain in Zuluhed the Whacked Quest (http://www.wowhead.com/quest=10866)
Keterangan:
Chainnya pas di klik ga bikin quest complete a.k.a error

Tested fix:

Spoiler untuk sql :

-- Fix Chain in Zuluhed The Whacked Quest

DELETE FROM gameobject_template WHERE entry=185156;
insert into `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`, `WDBVerified`) values('185156','10','181','Zuluhed\'s Chains','','','','0','0','5','0','0','0','0','0','0','1724','0','0','3000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','12340');

UPDATE quest_template SET ReqCreatureOrGoId1=-185156 WHERE entry=10866;

Bug Horde Slave Freed buat quest The Path to the Citadel (http://www.wowhead.com/quest=24507) di Pit Of Saron
Keterangan:
Ball and chain (http://www.wowhead.com/object=201969) error.

Spoiler untuk uda di tes dan berhasil :

tested fix:

Spoiler untuk sql :

--ball and chain fix
DELETE FROM gameobject_template WHERE entry=201969;
insert into `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`, `WDBVerified`) values('201969','10','181','Ball and chain','','','','0','0','1','0','0','0','0','0','0','86','0','0','3000','0','1','0','0','0','0','71291','0','0','0','0','0','0','0','0','0','0','0','0','0','','12340');

UPDATE quest_template SET ReqCreatureOrGoId1=-201969 WHERE entry=24507;

[sunlounger]

ampmTC rev 80.

Some SQL Fix by heaven1st. (Quest)

[sunlounger]

sorry double post, delete pls mod/gm/admin

[heaven1st]

Error Chain Quests in Argent Vanguard


Chainnya ga teratur.
Untuk fix di bawah ini, membuat 100% sama urutannya dengan yg ada di gambar atas.
Teknik yang digunakan, http://www.trinitycore.info/index.ph...e_tc2#Examples

NOT Tested fix:

Spoiler untuk sql :

UPDATE quest_template SET NextQuestInChain=0 WHERE entry=13036; --teknik Quests with split and a child quest
UPDATE quest_template SET ExclusiveGroup=-13008,NextQuestId=13044,PrevQuestId=13036 WHERE entry IN (13008,13039,13040); --teknik Quests with split and a child quest
UPDATE quest_template SET NextQuestInChain=13104 WHERE entry=13086; --teknik Chain of quests
--teknik Complicated
UPDATE quest_template SET NextQuestInChain=13125,PrevQuestId=13104 WHERE entry=13122; 
UPDATE quest_template SET ExclusiveGroup=-13125,NextQuestId=13139,PrevQuestId=13122 WHERE entry=13125;
UPDATE quest_template SET NextQuestInChain=13130,PrevQuestId=13104 WHERE entry=13118;
UPDATE quest_template SET ExclusiveGroup=-13125,NextQuestId=13139,PrevQuestId=13118 WHERE entry=13130;
UPDATE quest_template SET NextQuestInChain=13135,PrevQuestId=13104 WHERE entry=13110;
UPDATE quest_template SET ExclusiveGroup=-13125,NextQuestId=13139,PrevQuestId=13110 WHERE entry=13135;
--teknik Chain of quests
UPDATE quest_template SET NextQuestInChain=0 WHERE entry=13141;
UPDATE quest_template SET PrevQuestId=13141,NextQuestInChain=0 WHERE entry=13157;
UPDATE quest_template SET PrevQuestId=13141 WHERE entry=13068;
UPDATE quest_template SET PrevQuestId=13157 WHERE entry IN (13224,13225);
UPDATE quest_template SET PrevQuestId=13075 WHERE entry=13076;
UPDATE quest_template SET PrevQuestId=13079 WHERE entry=13080;
UPDATE quest_template SET PrevQuestId=13082 WHERE entry=13083;

===========================
Btw,Bug Horde Slave Freed buat quest The Path to the Citadel nya uda bener. Tapi sekarang Forgemaster slain nya yang eror.
Keknya ReqCreatureOrGOId2 nya keisi 0 ato ga ReqCreatureOrGOCount2 nya keisi 0.
Jadi fix kecilnya,

Spoiler untuk sql :

UPDATE quest_template SET ReqCreatureOrGOId2=36494,ReqCreatureOrGOCount2=1 WHERE entry=24507;

[old_shatterhand]

Q shadow edge bisa d ambil smua class, harus nya kan cman dk pally warr
byk kasus,karena class laen yang ambil, itu fester rotface, byk kejadian ke klik lah, ini lah itu lah

terima kasih

[-OceaN-LorD]

horde nick Irhaz. iya emang diliat kok, i knew it.



halah.. sotoy nih bebekgoreng. haha.



y itu ma kita ga tau. (tapi kalo gw dikasi kesempatan jd GM pasti langsung gw fix.. Xp hahaha.)




Ok gw lanjutin fixnya, tapi skrg gw lebih fokus ke Quest ama NPC bug dulu.. Soalnya spesialisasi gw di database, bukan di core (item + spell). Im sorry for being late.

silakan dicoba ngajuin aja bro,
toh sekarang kita punya 2 server,buat coba2 bisa diserver satu lagi,yang disebut server tourney

[heaven1st]

silakan dicoba ngajuin aja bro,
toh sekarang kita punya 2 server,buat coba2 bisa diserver satu lagi,yang disebut server tourney

ngajuin jd GM mksdny?

Spoiler untuk gw? :

uda pernah bro dan ditolak. haha. XP

[-OceaN-LorD]

ngajuin jd GM mksdny?

Spoiler untuk gw? :

uda pernah bro dan ditolak. haha. XP

wah,sayang banget >.<
padahal skillnya bisa sangat berguna!