All pastes #447081 Raw Edit

Someone

public text v1 · immutable
·published 2007-04-18 20:34 UTC
rendered paste body
delete from areatrigger_template where id in (3688,3647,3649,3669,3687,3708,3709,3646,3671,3686,3706,3707);
insert into `areatrigger_template` (`id`, `name`, `required_level`, `trigger_map`, `trigger_position_x`, `trigger_position_y`, `trigger_position_z`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) values
('3688','Warsong Gulch - Horde side','0','489','1125.23','1541.5','307.392','0','0','0','0','0'),
('3647','Warsong Gulch - Horde Flag spawn','0','489','915.809','1433.73','346.172','0','915.809','1433.73','346.172','3.244'),
('3649','Warsong Gulch - Horde Flag spawn','0','489','915.809','1433.73','346.172','0','915.809','1433.73','346.172','3.244'),
('3669','Warsong Gulch - Horde Exit','0','489','1009.17','1290.77','346.961','1','1034.89','-2099.88','122.945','0'),
('3687','Warsong Gulch - Horde elexir of speed spawn','0','489','1006.22','1445.98','335.77','0','1006.22','1445.98','335.77','1.683'),
('3708','Warsong Gulch - Horde elexir of regeneration spawn','0','489','1110.1','1353.24','316.513','0','1110.1','1353.24','316.513','5.68'),
('3709','Warsong Gulch - Horde elexir of berserk spawn','0','489','1141.36','1560.99','306.791','0','1141.36','1560.99','306.791','3.858'),
('3646','Warsong Gulch - Alliance Flag spawn','0','489','1540.35','1481.31','352.635','0','1540.35','1481.31','352.635','6.24'),
('3671','Warsong Gulch - Alliance Exit','0','489','1456.47','1628.47','360.352','1','1435.33','-1856.02','133.546','0'),
('3686','Warsong Gulch - Alliance elexir of speed spawn','0','489','1449.98','1468.86','342.66','0','1449.98','1468.86','342.66','4.866'),
('3706','Warsong Gulch - Alliance elexir of regeneration spawn','0','489','1316.94','1551.99','313.234','0','1316.94','1551.99','313.234','5.869'),
('3707','Warsong Gulch - Alliance elexir of berserk spawn','0','489','1318.68','1378.03','314.753','0','1318.68','1378.03','314.753','1.001');

update `item_template` set maxcount='100', stackable='100' where entry='20560';
update `item_template` set maxcount='100', stackable='100' where entry='20559';
update `item_template` set maxcount='100', stackable='100' where entry='20558';


update `creature` set position_x='-8385.659180', position_y='272.508362', position_z='120.886002', orientation='2.256450', spawn_position_x='-8385.659180', spawn_position_y='272.508362', spawn_position_z='120.886002', spawn_orientation='2.256450' where id='7410';
update `creature` set position_x='-8390.152344', position_y='268.792542', position_z='120.886017', orientation='2.234459', spawn_position_x='-8390.152344', spawn_position_y='268.792542', spawn_position_z='120.886017', spawn_orientation='2.234459' where id='15008';
update `creature` set position_x='-8394.844727', position_y='264.964355', position_z='120.886017', orientation='2.314569', spawn_position_x='-8394.844727', spawn_position_y='264.964355', spawn_position_z='120.886017', spawn_orientation='2.314569' where id='14981';