All pastes #426666 Raw Edit

Stuff

public text v1 · immutable
·published 2007-04-06 09:45 UTC
rendered paste body
DELETE FROM creature_template WHERE entry IN (25000,25001,25002,25003);
insert  into creature_template values
(25000, 7010, 0, 'Lazy GMs Buddie', 'I keep those fingers happy', 65, 65, 4667, 4667, 0, 0, 0, 120, 65, '1.2', 0, '347', '434', 100, 1430, 1573, 0, 0, 0, '1', 0, '2', 0, 0, 0, 0, '70.4704', '96.8968', 100, '2.31', 7, 0, 0, 22178, 0, 0, 285346306, 0, 0, 3, 4, 0, 68, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 690, 690, '', 0, 3, 'allinone_teleporter'), 
(25001, 7010, 0, 'Transportation Master', 'Bootybay-Ratchet', 65, 65, 4667, 4667, 0, 0, 0, 120, 65, '1.2', 0, '347', '434', 100, 1430, 1573, 0, 0, 0, '1', 0, '2', 0, 0, 0, 0, '70.4704', '96.8968', 100, '2.31', 7, 0, 0, 22178, 0, 0, 285346306, 0, 0, 3, 4, 0, 68, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 690, 690, '', 0, 3,  'allinone_teleporter'),
(25002, 6778, 0, 'Transportation Master', 'Menethil-Auberdine-Theramore', 65, 65, 4667, 4667, 0, 0, 0, 11, 65, '1.2', 0, '347', '434', 100, 1430, 1573, 0, 0, 0, '1', 0, '2', 0, 0, 0, 0, '70.4704', '96.8968', 100, '2.31', 7, 0, 0, 22178, 0, 0, 285346306, 0, 0, 3, 4, 0, 68, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 690, 690, '', 0, 3,  'allinone_teleporter'),
(25003, 3758, 0, 'Transportation Master', 'Orgrimmar-Undercity-Grom Gol Base Camp', 65, 65, 4667, 4667, 0, 0, 0, 126, 65, '1.2', 0, '347', '434', 100, 1430, 1573, 0, 0, 0, '1', 0, '2', 0, 0, 0, 0, '70.4704', '96.8968', 100, '2.31', 7, 0, 0, 22178, 0, 0, 285346306, 0, 0, 3, 4, 0, 68, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 690, 690, '', 0, 3,  'allinone_teleporter');



DELETE FROM creature WHERE guid IN (991660,991650,991640,991630,991600,991610,991550,991500);
insert  into creature values 
(991660, 25000, 451, '16395', '16343.5', '69.44', '3.3081', 25, '0', 0, '16395', '16343.5', '69.44', '0', 4667, 0, 0, 0, ''), 
(991650, 25003, 1, '1342.81', '-4664.98', '53.9519', '1.2912', 25, '0', 0, '1342.81', '-4664.98', '53.9519', '0', 4667, 0, 0, 0, ''), 
(991640, 25003, 0, '-12442.8', '213.028', '31.2', '5.75226', 25, '0', 0, '-12442.8', '213.028', '31.2', '0', 4667, 0, 0, 0, ''), 
(991630, 25003, 0, '2063.77', '252.823', '99.76', '2.91854', 25, '0', 0, '2063.77', '252.823', '99.76', '0', 4667, 0, 0, 0, ''), 
(991600, 25002, 1, '-3997.39', '-4725.48', '4.85029', '0.841945', 25, '0', 0, '-3997.39', '-4725.48', '4.85029', '0', 4667, 0, 0, 0, ''), 
(991610, 25002, 1, '6443.57', '613.337', '10.4547', '2.91854', 25, '0', 0, '6443.57', '613.337', '10.4547', '0', 4667, 0, 0, 0, ''), 
(991550, 25001, 1, '-1000.19', '-3818.6', '5.08738', '5.57318', 25, '0', 0, '-1000.19', '-3818.6', '5.08738', '0', 4667, 0, 0, 0, ''), 
(991500, 25001, 0, '-14293.7', '558.116', '8.74751', '5.80409', 25, '0', 0, '-14293.7', '558.116', '8.74751', '0', 4667, 0, 0, 0, '');  



DELETE FROM creature_template WHERE entry IN (25004);
insert  into creature_template values
(25004, 9784, 0, 'Teleportation Master', 'Instance Guardian', 65, 65, 4667, 4667, 0, 0, 0, 120, 65, '1.2', 0, '347', '434', 100, 1430, 1573, 0, 0, 0, '1', 0, '2', 0, 0, 0, 0, '70.4704', '96.8968', 100, '2.31', 7, 0, 0, 22178, 0, 0, 285346306, 0, 0, 3, 4, 0, 68, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 690, 690, '', 0, 3,  'my_instance');
DELETE FROM `creature` WHERE `id`= 25004;
INSERT INTO `creature` (`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`state`,`MovementType`,`auras`) VALUES ('25004','0','-14419.1','525.438','5.00728','4.45478','180','0','0','-14419.1','525.438','5.00728','0','99999','0','0','0',''),
('25004','451','16395.2','16338.6','69.44','3.32145','180','0','0','16395.2','16338.6','69.44','0','99999','0','0','0',''),
('25004','0','-8925.21','605.048','99.5228','1.39487','180','0','0','-8925.21','605.048','99.5228','0','99999','0','0','0',''),
('25004','0','-4878.1','-984.265','503.94','3.39656','180','0','0','-4878.1','-984.265','503.94','0','99999','0','0','0',''),
('25004','0','1588.09','244.959','-52.1511','3.5861','180','0','0','1588.09','244.959','-52.1511','0','99999','0','0','0',''),
('25004','1','9934.28','2513.76','1318.06','5.70852','180','0','0','9934.28','2513.76','1318.06','0','99999','0','0','0',''),
('25004','1','1633.32','-4386.94','11.8032','2.51327','180','0','0','1633.32','-4386.94','11.8032','0','99999','0','0','0',''),
('25004','1','6780.12','-4680.44','723.893','1.7577','180','0','0','6780.12','-4680.44','723.893','0','99999','0','0','0',''),
('25004','1','-7195.73','-3831.66','8.56006','2.37897','180','0','0','-7195.73','-3831.66','8.56006','0','99999','0','0','0',''),
('25004','1','-1265.02','26.1605','128.187','6.03264','180','0','0','-1265.02','26.1605','128.187','0','99999','0','0','0','');

CREATE TABLE `pvp_cmd_data` (
  `time_enter` varchar(255) default NULL,
  `playerid` int(11) default NULL,
  `mymap` varchar(255) default NULL,
  `time_leave` varchar(255) default NULL,
  `in_arena` int(11) default NULL,
  `myx` varchar(255) default NULL,
  `myy` varchar(255) default NULL,
  `myz` varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 22528 kB; InnoDB free: 22528 kB; InnoDB free: 2';