Moat_monster_quest_hacky_fix(backup)

-- http://www.wowhead.com/quest=29361/moat-monster
DELETE FROM item_loot_template WHERE entry=69999;
INSERT INTO item_loot_template VALUES
(69999,69995,100,1,0,1,1),
(69999,69998,100,1,1,1,1);
-- http://www.wowhead.com/spell=99508 (Throw Frog) & http://www.wowhead.com/spell=99511 (Simulate Alliance Presence) cuma bisa dipake kalo ada gameobject yg menggunakan data0=1725 diambil dari SpellFocusObject.dbc yg isi entry nya Ruins of Lordaeron Moat. Jadi dibuat dummynya untuk spawnin moat monster. GO entry nya tinggal diganti, terserah mau berapa aja.

DELETE FROM gameobject_template WHERE entry=500000;
INSERT INTO gameobject_template (`entry`,`type`,`displayId`,`name`,`data0`,`data4`) VALUES
(500000,8,4051,'TEMP Ruins of Lordaeron Moat',1725,29361);
-- ketika Simulate Alliance Presence di cast, bakal kluar npc Moat Monster, disini dibuat agar quest complete ketika moat nya di bunuh. Hacky way, tapi setelah dicoba spellscripts,smart_scripts,di ubah database maupun di masukin script .cpp, masih belum mendapatkan credit. Jadi untuk sementara cara ini lebih baik dibandingkan tidak sama sekali.
DELETE FROM quest_template WHERE id=29361;
DELETE FROM creature_template WHERE entry=53590;

insert into `quest_template` values('29361','2','-1','10','0','-101','0','0','0','0','946','356','0','0','0','0','0','0','0','0','0','0','0','0','0','5','125','9300','0','0','0','0','0','0','69999','1','0','266240','1','0','0','0','0','0','356','1','0','0','0','67414','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','68','0','0','0','0','5','0','0','0','0','0','0','0','0','0','0','0','0','0','Moat Monster!','Use the Alliance Decoy Kit to summon the Moat Monster in the Ruins of Lordaeron.  Then use the Bloated Frogs to feed the monster.','Sometimes fishing means throwing something back, $c.$b$bWe\'ve been overfeeding these frogs for just that occasion.  We\'ve fed these frogs bloated spiders, that were fed bloated flies, and now, we are going to feed a real monster.$b$bThe moat above, in the Ruins of Lordaeron, is home to our very own moat monster.$b$bToday is feeding day.  But we must train it as well.  In this bag, you will find a decoy kit and some bloated frogs.  Use the decoy kit, then toss the frogs to the monster when it appears.','','The dead feed the flies.  The flies feed the spiders.  The spiders feed the frogs.  The frogs feed our moat monster... It\'s a beautiful circle of life with the goal of ending life.',NULL,'Return to to Armand Cromwell in Undercity.','53590','0','0','0','10','0','0','0','0','69998','69995','69999','0','1','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Feed Bloated Frogs to the Moat Monster','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','','','890','878','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','15595');

insert into `creature_template` values('53590','0','0','0','0','0','30165','0','0','0','Moat Monster','','','0','1','1','0','0','17','17','0','1','1.14286','1','0','0','0','0','0','1','0','0','1','0','2048','0','0','0','0','0','0','0','0','10','0','0','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','1','1','0','0','0','0','0','0','0','0','1','0','0','','15595');

-- Bagian ini untuk penempatan gameobject yang baru dibuat tadi. Untuk GOguid terserah mo diisi berapa aja.
DELETE FROM gameobject WHERE id=500000;
SET @GOguid := 610000;
insert into `gameobject` values ('@GOguid','500000','0','1','65535','1768.27','253.297','60.2328','2.21642','0','0','0.894902','0.446263','300','0','1'),('@GOguid+1','500000','0','1','65535','1757.35','228.325','48.247','0.659675','0','0','0.323889','0.946095','300','0','1'),('@GOguid+2','500000','0','1','65535','1763.38','216.408','49.528','0.298394','0','0','0.148644','0.988891','300','0','1'),('@GOguid+3','500000','0','1','65535','1750.4','212.083','48.9491','6.1082','0','0','0.0873832','-0.996175','300','0','1'),('@GOguid+4','500000','0','1','65535','1765.43','265.131','50.708','5.52513','0','0','0.37002','-0.929024','300','0','1'),('@GOguid+5','500000','0','1','65535','1739.29','272.781','48.1963','2.49029','0','0','0.947442','0.319926','300','0','1');