[SignFinder]

Сообщение от YuruY

Наше (то которое 1шт) похоже не по кешу, буду разбирать новые кеши уточню ГО, а пока временное:

DELETE FROM `gameobject_template` WHERE (`entry`=300068);
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`, `mingold`, `maxgold`, `ScriptName`) VALUES (300068, 8, 0, 'Midsummer Bonfire', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 1365, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
DELETE FROM `gameobject` WHERE `id`=300068;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(6206, 300068, 0, 1, 1, -8828.22, 856.892, 99.0967, 1.33909, 0, 0, 0.620629, 0.784104, 300, 100, 1),
(6207, 300068, 0, 1, 1, -4700.28, -1224.34, 501.659, -2.14675, 0, 0, -0.878816, 0.477161, 300, 100, 1),
(6213, 300068, 1, 1, 1, 8699.36, 927.891, 15.2129, 1.67552, 0, 0, 0.743146, 0.669129, 300, 100, 1),
(6223, 300068, 0, 1, 1, 1642.16, 239.434, 62.5916, 2.05146, 0, 0, 0.855093, 0.518475, 300, 100, 1),
(6225, 300068, 1, 1, 1, 1955.5, -4271.51, 31.111, 4.64484, 0, 0, 0.730581, -0.682826, 300, 100, 1),
(6227, 300068, 1, 1, 1, -1036.27, 294.252, 135.746, 6.04992, 0, 0, 0.116368, -0.993206, 300, 100, 1),
(6228, 300068, 530, 1, 1, -3799.94, -11498.6, -134.796, 3.03715, 0, 0, 0.998637, 0.0521976, 300, 100, 1),
(6229, 300068, 530, 1, 1, 9810.75, -7236.68, 26.068, 0.107613, 0, 0, 0.0537805, 0.998553, 300, 100, 1);

полей mingold, maxgold нет

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`) VALUES (300068, 8, 0, 'Midsummer Bonfire', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 1365, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');