Public feed #890585

Meins

public text v1 · immutable
Raw Edit
·published 2008-02-03 21:28 UTC
rendered paste body
DELETE FROM `gameobject` WHERE `id` IN (187334,187365,187294,187329,187299,187291,187292,187295,187337,187296,187290,187390);
INSERT INTO `gameobject`
  (id, map, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state)
VALUES
  (187329, 0, -8934.91, 618.273, 100.589, 0.506145, 0, 0, 0.25038, 0.968148, 180, 100, 1),
  (187329, 0, -8910.43, 636.38, 100.91, -2.67035, 0, 0, 0.97237, -0.233445, 180, 100, 1),
  (187329, 0, -8930.72, 610.526, 100.595, 0.506145, 0, 0, 0.25038, 0.968148, 180, 100, 1),
  (187329, 0, -8902.25, 621.314, 100.916, -2.63545, 0, 0, 0.968148, -0.25038, 180, 100, 1),
  (187290, 0, 1603.91, 248.463, -51.2896, 0.017453, 0, 0, 0.008727, 0.999962, 180, 100, 1),
  (187290, 0, 1587.58, 232.057, -51.2757, -3.08923, 0, 0, 0.999657, -0.026177, 180, 100, 1),
  (187290, 0, 1587.67, 248.657, -51.2757, 1.53589, 0, 0, 0.694658, 0.71934, 180, 100, 1),
  (187290, 0, 1603.5, 231.786, -51.2794, -1.69297, 0, 0, 0.748956, -0.66262, 180, 100, 1),
  (187292, 1, 1624.84, -4362.77, 12.4746, -2.30383, 0, 0, 0.913545, -0.406737, 180, 100, 1),
  (187292, 1, 1638.22, -4382.22, 12.5441, 1.15192, 0, 0, 0.544639, 0.838671, 180, 100, 1),
  (187365, 530, -1709.686279, 5461.005859, -7.927668, 1.850049, 0, 0, 0.798636, 0.601815, 180, 100, 1),
  (187365, 530, -1745.807495, 5533.837891, -7.926137, -0.977384, 0, 0, 0.469472, -0.882948, 180, 100, 1),
  (187334, 530, -1987.361084, 5320.466309, -6.776728, -1.239184, 0, 0, 0.580703, -0.814116, 180, 100, 1),
  (187334, 530, -2025.808228, 5396.902832, -6.562429, 2.111848, 0, 0, 0.870356, 0.492424, 180, 100, 1),
  (187299, 530, 2936.958252, 3644.469971, 132.578217, -1.466077, 0, 0, 0.669131, -0.743145, 180, 100, 1),
  (187299, 530, 2936.460205, 3663.392334, 132.578217, 1.989675, 0, 0, 0.838671, 0.544639, 180, 100, 1);

UPDATE `gameobject_template` SET `name`='Gildentresor' WHERE `entry` IN 

(187334,187365,187294,187329,187299,187291,187292,187295,187337,187296,187290,187390);