PERHATIAN!
---------------------------------------------------
This thread is open for public.
Untuk user yang ingin membantu memberikan fix berupa SQL Queries ato C++ patch, mari kita taro di sini.
---------------------------------------------------
PERLU DIINGAT!---------------------------------------------------
TOLONG JANGAN MENGELUHKAN BUG YANG BELUM DI FIX SETELAH MAINTENANCE, this is unofficial bro.
BUG YANG JELAS SUDAH DI FIX OLEH GM, http://idgs.in/292395
---------------------------------------------------
---------------------------------------------------
Unofficial Sql Queries for FixesSpoiler untuk Fix01.sql :
08/07/10
Spoiler untuk sql fixes :
Code:-- Mind Flay Fix
INSERT INTO spell_bonus_data VALUES (58381,0.257,-1,-1,-1,'Priest - Mind
Flay');
-- Feral Spirit : Spirit Walk
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`)
VALUES ('58875', '58876', '0', '');
UPDATE creature_template SET spell5 = 58879 WHERE entry = 29264;
12/07/10
Spoiler untuk sql fixes :Code:-- Fix Warrior's Bladestorm
DELETE FROM `spell_linked_spell` where `spell_trigger` in (46924);
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
('46924', '-13810', '2', 'Bladestorm immune at Frost Trap'),
('46924', '-51514', '2', 'Bladestorm immune at Hex'),
('46924', '-116', '2', 'Bladestorm immune at FrostBolt'),
('46924', '-45524', '2', 'Bladestorm immune at Chains of Ice'),
('46924', '-68766', '2', 'Bladestorm immune at Desecration'),
('46924', '-58617', '2', 'Bladestorm immune at Glyph of Heart Strike');
-- Fix Npc Dame Evniki Kapsalis vending list
DELETE FROM npc_vendor WHERE entry=34885;
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42943','0','0','2674');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42944','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42945','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42946','0','0','2674');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42947','0','0','2674');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42948','0','0','2675');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42949','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42950','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42951','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42952','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42984','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42985','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42991','0','0','2675');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42992','0','0','2675');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','46843','0','0','2597');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','46874','0','0','2598');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','47179','0','0','2600');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','47180','0','0','2600');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','47541','0','0','2603');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48677','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48683','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48685','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48687','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48689','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48691','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48716','0','0','2675');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48718','0','0','2674');
30/07/10
Spoiler untuk sql fixes :Code:-- Respawning Tiffany Cartier
DELETE FROM creature_template WHERE entry=28721;
insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) values('28721','0','0','0','0','0','25645','0','0','0','Tiffany Cartier','Jewelcrafting Supplies','','0','75','75','2','2007','2007','128','1','1.14286','1','0','342','485','0','392','1','2000','0','1','32768','8','0','0','0','0','0','295','438','68','7','4096','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','1','0','0','0','0','0','0','0','0','1','0','0','0','','11723');
DELETE FROM creature WHERE guid=100492;
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('100492','28721','571','1','1','25645','0','5875.72','714.049','643.171','1.79769','300','0','0','10635','0','0','0');
---------------------------------------------------Diingetin lagi, fix bug yang official bisa di lihat di http://idgs.in/292395
---------------------------------------------------