All pastes #566652 Raw Edit

Untitled

public text v1 · immutable
·published 2007-06-14 15:26 UTC
rendered paste body
DELETE FROM creature_template WHERE entry IN (25000,25001,25002,25003,25005,25006);
insert  into creature_template values
(25000, 6778, 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,  '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, 6778, 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,  '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,  '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,  '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'),
(25005, 3758, 0, 'Transportation Master', 'Feralas-Feathermoon', 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,  '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_teleporter_fea_fer'),
(25006, 3758, 0, 'Transportation Master', 'Auberdine-Exodar', 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,  '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_teleporter_bl_ex_au');
update creature_template set npcflag='1' where (entry='25000');
update creature_template set npcflag='1' where (entry='25001');
update creature_template set npcflag='1' where (entry='25002');
update creature_template set npcflag='1' where (entry='25003');
update creature_template set npcflag='1' where (entry='25004');
update creature_template set npcflag='1' where (entry='25005');
update creature_template set npcflag='1' where (entry='25006');

DELETE FROM creature WHERE guid IN (991660,991650,991640,991630,991600,991610,991550,991500,1081821,1081823,1081824,1081820);
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, ''),
(1081821, 25005, 1, '-4221.01', '3292.7', '8.10928', '4.80292', 25, '0', 0, '-4221.01', '3292.7', '8.10928', '0', 4667, 0, 0, 0, ''), 
(1081823, 25006, 530, '-4271.16', '-11339.6', '5.92123', '0.0518274', 25, '0', 0, '-4271.16', '-11339.6', '5.92123', '0', 4667, 0, 0, 0, ''), 
(1081824, 25006, 1, '6433.53', '616.901', '10.4548', '5.95725', 25, '0', 0, '6433.53', '616.901', '10.4548', '0', 4667, 0, 0, 0, ''), 
(1081820, 25005, 1, '-4354.88', '2415.12', '8.39395', '0.0722399', 25, '0', 0, '-4354.88', '2415.12', '8.39395', '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,  '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`, `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',''),
('25004','451','16395.2','16338.6','69.44','3.32145','180','0','0','16395.2','16338.6','69.44','0','99999','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',''),
('25004','0','-4878.1','-984.265','503.94','3.39656','180','0','0','-4878.1','-984.265','503.94','0','99999','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',''),
('25004','1','9934.28','2513.76','1318.06','5.70852','180','0','0','9934.28','2513.76','1318.06','0','99999','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',''),
('25004','1','6780.12','-4680.44','723.893','1.7577','180','0','0','6780.12','-4680.44','723.893','0','99999','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',''),
('25004','1','-1265.02','26.1605','128.187','6.03264','180','0','0','-1265.02','26.1605','128.187','0','99999','0','0',''),
('25004','530','-9803.44','-7476.55','13.55','5.00','180','0','0','-9803.44','-7476.55','13.55','0','99999','0','0',''),
('25004','530','-3927.75','-11547.86','-150.25','5.75','180','0','0','-3927.75','-11547.86','-150.25','0','99999','0','0','');
update creature_template set modelid_m='15214' where (entry='25001');
update creature_template set modelid_m='15214' where (entry='25002');
update creature_template set modelid_m='15214' where (entry='25003');
update creature_template set modelid_m='15214' where (entry='25004');
update creature_template set modelid_m='5426' where (entry='30001');
UPDATE `creature_template` SET `size`='1' WHERE `entry` IN (25000,25001,25002,25003,25004,25005,25006);
update creature_template set modelid_f='15013' where (entry='25001');
update creature_template set modelid_f='15013' where (entry='25002');
update creature_template set modelid_f='15013' where (entry='25003');
update creature_template set modelid_f='15013' where (entry='25004');
update creature_template set modelid_f='15013' where (entry='25005');
update creature_template set modelid_f='15013' where (entry='25006');
update creature_template set faction='120' where (entry='25005');
update creature_template set faction='120' where (entry='25006');
update creature_template set subname='Powered By Goblin Porta-Magic' where (entry='25004');
update creature_template set name='City Teleportation Master' where (entry='25004');
update creature_template set `ScriptName` = 'npc_teleport_gm' where (entry='25000');
update creature_template set `ScriptName` = 'npc_teleport_both' where (entry='25001');
update creature_template set `ScriptName` = 'npc_teleport_allaince' where (entry='25002');
update creature_template set `ScriptName` = 'npc_teleport_horde' where (entry='25003');
update creature_template set `ScriptName` = 'npc_teleport_allaince2' where (entry='25005');
update creature_template set `ScriptName` = 'npc_teleport_allaince' where (entry='25006');
update creature_template set `ScriptName` = 'npc_teleport_city' where (entry='25004');

DELETE FROM `item_template` WHERE entry=69481199;
DELETE FROM `item_template` WHERE entry=69481198;
insert  into item_template values
(69481199, 15, 0, -1, 'Teleport Stone', 'Teleport Stone', 'Teleport Stone', 'Teleport Stone', 6418, 1, 64, 1, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'item_teleport_stone2', 0), 
(69481198, 15, 0, -1, 'Teleport Stone_test', 'Teleport Stone_test', 'Teleport Stone_test', 'Teleport Stone_test', 6418, 1, 64, 1, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'item_teleport_stone', 0);
update item_template set spellid_1='331' where (entry='69481198');  
update item_template set spellid_1='331' where (entry='69481199');