PvP Патчег: порталы в столицах, телепорт в арену и популярные игры онлайн

[DeSSower]

Пвп Патчег , который добавляет портал в Гурбаши арену , а также расставляет порталы в столицах и ставит в арене почтовый ящик

Код Выделить Развернуть

REPLACE INTO `areatrigger_teleport` (`id`, `name`, `required_level`, `required_item`, `required_item2`, `heroic_key`, `heroic_key2`, `required_quest_done`, `required_failed_text`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
(6348, 'Portal to PVP Arena Gurubashi', 0, 0, 0, 0, 0, 0, NULL, 0, -13232.8, 218.2, 31.82, 1.133);

REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
(6348, 0, -13232.8, 218.2, 31.82, 1.133),
(33728, 530, -1800.75, 5408.09, -12.4274, 2.81);

REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `castBarCaption`, `faction`, `flags`, `size`, `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
(401401, 22, 6955, 'Portal to PVP Arena Gurubashi', '', 0, 0, 1, 6348, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(183384, 22, 7146, 'Portal to Shattrath', '', 0, 0, 1, 33728, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(400003, 401401, 0, 1, -8963.63, 513.357, 96.3556, 0.711571, 0, 0, 0.348327, 0.937373, 25, 0, 1),
(400004, 401401, 0, 1, -4976.93, -888.459, 501.621, 5.39457, 0, 0, 0.429832, -0.902909, 25, 0, 1),
(400005, 401401, 1, 1, 9952.39, 2278.33, 1341.39, 1.60581, 0, 0, 0.719377, 0.69462, 25, 0, 1),
(400009, 401401, 0, 1, 1815.6, 238.21, 60.4646, 3.09815, 0, 0, 0.999764, 0.0217187, 25, 0, 1),
(400010, 401401, 1, 1, 1433.8, -4394.36, 25.2359, 1.66078, 0, 0, 0.738196, 0.674586, 25, 0, 1),
(400011, 401401, 1, 1, -1243.36, 83.2988, 129.263, 2.32052, 0, 0, 0.916907, 0.399101, 25, 0, 1),
(400135, 401401, 530, 1, 9340.59, -7277.26, 14.0443, 6.15946, 0, 0, 0.0618251, -0.998087, 25, 0, 1),
(400203, 401401, 530, 1, -1847.79, 5407.57, -12.4282, 4.70061, 0, 0, 0.71126, -0.702929, 25, 0, 1),
(400255, 401401, 530, 1, -4049.89, -11945.5, 0.706202, 1.12146, 0, 0, 0.531805, 0.846867, 25, 0, 1),
(400257, 401401, 0, 1, -5163.29, 664.788, 348.932, 4.70105, 0, 0, 0.711104, -0.703086, 25, 0, 1),
(400258, 401401, 530, 1, -4073.24, -12014.8, -1.27733, 4.59458, 0, 0, 0.747508, -0.664252, 25, 0, 1),
(400259, 401401, 1, 1, 9947.68, 2491.95, 1317.1, 4.70846, 0, 0, 0.708493, -0.705717, 25, 0, 1),
(400262, 183039, 0, 1, -13221.3, 219.914, 33.2433, 1.51254, 0, 0, 0.686214, 0.7274, 25, 0, 1),
(400263, 183039, 0, 1, -13239.8, 229.169, 33.2422, 0.809612, 0, 0, 0.39384, 0.919179, 25, 0, 1),
(400266, 183384, 0, 1, -13165.9, 232.869, 33.241, 2.35429, 0, 0, 0.923516, 0.383561, 25, 0, 1),
(400267, 183384, 0, 1, -13259.8, 282.602, 33.2409, 6.20667, 0, 0, 0.0382463, -0.999268, 25, 0, 1),
(400336, 401401, 530, 1, -2149.78, 6632.63, 0.763543, 1.90436, 0, 0, 0.814681, 0.579909, 25, 0, 1),
(400338, 401401, 530, 1, 12941.8, -6893.27, 5.66441, 5.4603, 0, 0, 0.399931, -0.916545, 25, 0, 1);

REPLACE INTO `game_graveyard_zone` (`id`, `ghost_zone`, `faction`) VALUES
(551207, 33, 0);

REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
(500105, 0, 7991, 0, 7991, 0, 'Gurubashi Auctioneer', '', NULL, 50, 50, 4500, 4500, 2103, 2103, 10000, 35, 35, 2097152, 1.2, 1, 0, 500, 600, 0, 300, 1000, 0, 4096, 0, 0, 0, 0, 0, 0, 66.44, 91.355, 100, 7, 0, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');


REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(101145, 6491, 0, 1, 0, 0, -13254.1, 177.807, 32.6221, 1.0953, 25, 0, 0, 4900, 0, 0, 0),
(101549, 500105, 0, 1, 0, 0, -13246.1, 234.09, 33.2427, 0.709159, 25, 0, 0, 4500, 2103, 0, 0),
(101550, 500105, 0, 1, 0, 0, -13213.6, 217.6, 33.2411, 1.36104, 25, 0, 0, 4500, 2103, 0, 0);