Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Код:
DELETE FROM creature WHERE id = 31754 AND phaseMask = 1;
SET @XXXXX := 150670
--------------------------------GUID (High: Unit Entry: 31754, Counter: 6472413)----------------------------------
SET @GUID := XXXXX+1;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31754`, `571`, `1`, `1`, `27702`, `0`, `6424.402`, `2408.305`, `468.9902`, `0.2368279`, `300`, `0`, `0`, `12600`, `0`, `0`, `1`);
UPDATE `creature_template` SET `speed_run` = 0.8571429 WHERE entry = 31754;
UPDATE `creature_model_info` SET `combat_reach` = 3 WHERE `modelid` = 27702;
--------------------------------GUID (High: Unit Entry: 31754, Counter: 6469104)----------------------------------
SET @GUID := XXXXX+2;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31754`, `571`, `1`, `1`, `27702`, `0`, `6385.127`, `2447.764`, `474.883`, `4.364398`, `300`, `0`, `0`, `12600`, `0`, `0`, `1`);
--------------------------------GUID (High: Unit Entry: 31754, Counter: 3353812)----------------------------------
SET @GUID := XXXXX+3;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31754`, `571`, `1`, `1`, `27702`, `0`, `6351.619`, `2496.307`, `486.3921`, `6.035602`, `300`, `0`, `0`, `12600`, `0`, `0`, `1`);
--------------------------------GUID (High: Unit Entry: 31754, Counter: 6471548)----------------------------------
SET @GUID := XXXXX+4;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31754`, `571`, `1`, `1`, `27702`, `0`, `6321.662`, `2471.347`, `493.6343`, `5.305801`, `300`, `0`, `0`, `12600`, `0`, `0`, `1`);
--------------------------------GUID (High: Unit Entry: 31754, Counter: 1110634)----------------------------------
SET @GUID := XXXXX+5;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31754`, `571`, `1`, `1`, `27702`, `0`, `6445.833`, `2445.833`, `465.4876`, `3.606243`, `300`, `0`, `0`, `12600`, `0`, `0`, `1`);
--------------------------------GUID (High: Unit Entry: 31754, Counter: 12572)----------------------------------
SET @GUID := XXXXX+6;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31754`, `571`, `1`, `1`, `27702`, `0`, `6423.156`, `2515.89`, `482.2788`, `0.7342671`, `300`, `0`, `0`, `12600`, `0`, `0`, `2`);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, 6420.885, 2514.159, 481.3015),
(@GUID, 2, 6420.322, 2513.332, 481.3015),
(@GUID, 3, 6421.807, 2514.672, 482.0515),
(@GUID, 4, 6425.518, 2518.021, 482.6765),
(@GUID, 5, 6427.058, 2519.415, 483.0515),
(@GUID, 6, 6427.058, 2519.415, 483.0515);
Код:
UPDATE `creature_template` SET `unit_flags` = `unit_flags` | 256 WHERE `entry` = 31395;
UPDATE `creature_model_info` SET `bounding_radius` = 0.3366 WHERE `modelid` = 27571;
UPDATE `creature_model_info` SET `combat_reach` = 5.5 WHERE `modelid` = 27571;
UPDATE `creature_template` SET `speed_walk` = 1.6 WHERE entry = 31395;
UPDATE `creature_template` SET `speed_run` = 1.857143 WHERE entry = 31395;
Код:
UPDATE `creature_model_info` SET `bounding_radius` = 0.3366 WHERE `modelid` = 27571;
UPDATE `creature_model_info` SET `combat_reach` = 5.5 WHERE `modelid` = 27571;
UPDATE `creature_template` SET `speed_walk` = 1.6 WHERE entry = 32588;
UPDATE `creature_template` SET `speed_run` = 1.857143 WHERE entry = 32588;
Код:
UPDATE `creature_template` SET `equipment_id` = 32326, WHERE entry = 32326;
REPLACE INTO `creature_equip_template` VALUES (32326, 33475, 0, 0);
UPDATE `creature_template` SET `speed_run` = 0.9920629 WHERE entry = 32326;
UPDATE `creature_template` SET `faction_A` = 2, `faction_H` = 2 WHERE `entry` = 32326;
UPDATE `creature_template` SET `baseattacktime` = 3000 WHERE `entry` = 32326;
UPDATE `creature_template` SET `unit_flags` = `unit_flags` | 8 WHERE `entry` = 32326;
UPDATE `creature_model_info` SET `bounding_radius` = 1.4 WHERE `modelid` = 27545;
Код:
UPDATE `gameobject_template` SET `faction` = 1732 WHERE `entry` = 190375;
UPDATE `gameobject_template` SET `faction` = 1732 WHERE `entry` = 190374;
UPDATE `gameobject_template` SET `flags` = 32 WHERE `entry` = 190221;
UPDATE `gameobject_template` SET `faction` = 1732 WHERE `entry` = 190221;
UPDATE `gameobject_template` SET `faction` = 1732 WHERE `entry` = 190376;
UPDATE `gameobject_template` SET `faction` = 1732 WHERE `entry` = 190377;
UPDATE `gameobject_template` SET `faction` = 1732 WHERE `entry` = 191802;
Код:
UPDATE `creature_model_info` SET `combat_reach` = 1 WHERE `modelid` = 11686;
Код:
UPDATE `creature_model_info` SET `bounding_radius` = 0.62, `combat_reach` = 2, `gender` = 2 WHERE `modelid` IN (27705, 27707,26919);
SET @XXXXX := 150680
DELETE FROM creature WHERE id = 31779
--------------------------------GUID (High: Unit Entry: 31779, Counter: 12561)----------------------------------
SET @GUID := XXXXX+1;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31779`, `571`, `1`, `1`, `27707`, `0`, `6452.331`, `2279.314`, `472.469`, `1.558739`, `300`, `0`, `0`, `12600`, `7988`, `0`, `1`);
--------------------------------GUID (High: Unit Entry: 31779, Counter: 12564)----------------------------------
SET @GUID := XXXXX+2;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31779`, `571`, `1`, `1`, `27706`, `0`, `6475.004`, `2316.39`, `466.9418`, `5.251906`, `300`, `0`, `0`, `12600`, `7988`, `0`, `1`);
--------------------------------GUID (High: Unit Entry: 31779, Counter: 12565)----------------------------------
SET @GUID := XXXXX+3;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31779`, `571`, `1`, `1`, `26919`, `0`, `6431.973`, `2290.813`, `472.1604`, `0.6557543`, `300`, `0`, `0`, `12600`, `7988`, `0`, `1`);
--------------------------------GUID (High: Unit Entry: 31779, Counter: 12558)----------------------------------
SET @GUID := XXXXX+4;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31779`, `571`, `1`, `1`, `27707`, `0`, `6432.254`, `2252.781`, `476.3964`, `3.749347`, `300`, `0`, `0`, `12600`, `7988`, `0`, `1`);
--------------------------------GUID (High: Unit Entry: 31779, Counter: 12566)----------------------------------
SET @GUID := XXXXX+5;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31779`, `571`, `1`, `1`, `27707`, `0`, `6438.842`, `2258.969`, `475.5274`, `4.305573`, `300`, `0`, `0`, `12600`, `7988`, `0`, `2`);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, 6448.099, 2279.859, 472.469),
(@GUID, 2, 6448.267, 2280.845, 472.469),
(@GUID, 3, 6446.289, 2276.255, 473.094),
(@GUID, 4, 6445.103, 2273.501, 473.719),
(@GUID, 5, 6443.125, 2268.911, 474.344),
(@GUID, 6, 6440.752, 2263.403, 474.9237),
(@GUID, 7, 6438.379, 2257.896, 475.6737),
(@GUID, 8, 6436.006, 2252.388, 476.2987),
(@GUID, 9, 6434.028, 2247.798, 476.9237),
(@GUID, 10, 6431.655, 2242.29, 477.6287),
(@GUID, 11, 6429.537, 2237.38, 478.2537),
(@GUID, 12, 6429.537, 2237.38, 478.2537);
--------------------------------GUID (High: Unit Entry: 31779, Counter: 21622)----------------------------------
SET @GUID := XXXXX+6;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31779`, `571`, `1`, `1`, `27705`, `0`, `6428.32`, `2257.417`, `476.0307`, `4.127908`, `300`, `0`, `0`, `12600`, `7988`, `0`, `2`);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, 6449.477, 2288.673, 470.969),
(@GUID, 2, 6449.65, 2289.658, 470.969),
(@GUID, 3, 6447.443, 2286.322, 471.594),
(@GUID, 4, 6444.685, 2282.152, 472.344),
(@GUID, 5, 6441.926, 2277.982, 473.094),
(@GUID, 6, 6440.271, 2275.48, 473.844),
(@GUID, 7, 6438.063, 2272.145, 474.469),
(@GUID, 8, 6433.098, 2264.639, 475.0037),
(@GUID, 9, 6429.787, 2259.635, 475.7537),
(@GUID, 10, 6426.477, 2254.631, 476.3787),
(@GUID, 11, 6423.718, 2250.461, 477.0037),
(@GUID, 12, 6420.407, 2245.457, 477.6287),
(@GUID, 13, 6417.648, 2241.287, 478.2537),
(@GUID, 14, 6415.441, 2237.951, 478.8787),
(@GUID, 15, 6413.234, 2234.615, 479.6287),
(@GUID, 16, 6411.579, 2232.113, 480.2086),
(@GUID, 17, 6409.372, 2228.777, 480.8336),
(@GUID, 18, 6406.062, 2223.773, 481.4586),
(@GUID, 19, 6403.303, 2219.604, 482.2086),
(@GUID, 20, 6401.647, 2217.102, 483.7086),
(@GUID, 21, 6400.544, 2215.434, 485.0836),
(@GUID, 22, 6398.889, 2212.932, 485.7763),
(@GUID, 23, 6395.578, 2207.928, 486.4013),
(@GUID, 24, 6390.061, 2199.588, 487.0377),
(@GUID, 25, 6385.095, 2192.082, 487.6627),
(@GUID, 26, 6384.156, 2190.638, 487.7877),
(@GUID, 27, 6384.156, 2190.638, 487.7877);
--------------------------------GUID (High: Unit Entry: 31779, Counter: 12563)----------------------------------
SET @GUID := XXXXX+7;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31779`, `571`, `1`, `1`, `27706`, `0`, `6494.598`, `2294.576`, `470.4745`, `0.2445052`, `300`, `0`, `0`, `12600`, `7988`, `0`, `2`);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, 6456.903, 2284.142, 471.594),
(@GUID, 2, 6456.719, 2285.125, 471.594),
(@GUID, 3, 6466.426, 2287.547, 470.969),
(@GUID, 4, 6491.664, 2293.844, 470.3495),
(@GUID, 5, 6504.283, 2296.992, 469.8011),
(@GUID, 6, 6512.049, 2298.93, 469.1761),
(@GUID, 7, 6516.902, 2300.141, 468.4418),
(@GUID, 8, 6526.588, 2302.533, 468.1919),
(@GUID, 9, 6526.588, 2302.533, 468.1919);
--------------------------------GUID (High: Unit Entry: 31779, Counter: 12557)----------------------------------
SET @GUID := XXXXX+8;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31779`, `571`, `1`, `1`, `27705`, `0`, `6435.229`, `2253.784`, `476.1737`, `4.356361`, `300`, `0`, `0`, `12600`, `7988`, `0`, `2`);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, 6448.472, 2289.041, 470.969),
(@GUID, 2, 6448.702, 2290.014, 470.969),
(@GUID, 3, 6447.308, 2286.264, 471.594),
(@GUID, 4, 6445.564, 2281.576, 472.219),
(@GUID, 5, 6444.519, 2278.764, 472.844),
(@GUID, 6, 6443.473, 2275.951, 473.594),
(@GUID, 7, 6441.729, 2271.264, 474.219),
(@GUID, 8, 6439.289, 2264.701, 474.7987),
(@GUID, 9, 6437.546, 2260.014, 475.4237),
(@GUID, 10, 6435.454, 2254.389, 476.0487),
(@GUID, 11, 6433.711, 2249.701, 476.6737),
(@GUID, 12, 6431.619, 2244.076, 477.2537),
(@GUID, 13, 6430.225, 2240.326, 477.8787),
(@GUID, 14, 6428.481, 2235.639, 478.5037),
(@GUID, 15, 6427.087, 2231.889, 479.0836),
(@GUID, 16, 6425.344, 2227.201, 479.8336),
(@GUID, 17, 6423.949, 2223.451, 480.5836),
(@GUID, 18, 6422.903, 2220.639, 481.3336),
(@GUID, 19, 6421.857, 2217.826, 481.9586),
(@GUID, 20, 6420.463, 2214.076, 482.7086),
(@GUID, 21, 6419.766, 2212.201, 483.4586),
(@GUID, 22, 6419.417, 2211.264, 484.2086),
(@GUID, 23, 6419.068, 2210.326, 485.0836),
(@GUID, 24, 6418.371, 2208.451, 485.9586),
(@GUID, 25, 6417.674, 2206.576, 486.7086),
(@GUID, 26, 6416.628, 2203.764, 487.4586),
(@GUID, 27, 6414.885, 2199.076, 488.1364),
(@GUID, 28, 6413.142, 2194.389, 488.7614),
(@GUID, 29, 6410.701, 2187.826, 489.3864),
(@GUID, 30, 6407.912, 2180.326, 490.0114),
(@GUID, 31, 6406.169, 2175.639, 490.6364),
(@GUID, 32, 6404.077, 2170.014, 491.2614),
(@GUID, 33, 6402.683, 2166.264, 491.865),
(@GUID, 34, 6400.939, 2161.576, 492.49),
(@GUID, 35, 6399.545, 2157.826, 493.1527),
(@GUID, 36, 6398.15, 2154.076, 493.9027),
(@GUID, 37, 6396.407, 2149.389, 494.5277),
(@GUID, 38, 6395.013, 2145.639, 495.1527),
(@GUID, 39, 6393.27, 2140.951, 495.7777),
(@GUID, 40, 6391.875, 2137.201, 496.5277),
(@GUID, 41, 6390.132, 2132.514, 497.0777),
(@GUID, 42, 6388.737, 2128.764, 497.7027),
(@GUID, 43, 6386.994, 2124.076, 498.3277),
(@GUID, 44, 6385.6, 2120.326, 499.0777),
(@GUID, 45, 6384.205, 2116.576, 499.7027),
(@GUID, 46, 6382.462, 2111.889, 500.4527),
(@GUID, 47, 6381.416, 2109.076, 501.0777),
(@GUID, 48, 6380.021, 2105.326, 501.7027),
(@GUID, 49, 6378.976, 2102.514, 502.3277),
(@GUID, 50, 6377.93, 2099.701, 502.928),
(@GUID, 51, 6376.187, 2095.014, 503.678),
(@GUID, 52, 6374.792, 2091.264, 504.303),
(@GUID, 53, 6374.609, 2090.88, 504.303),
(@GUID, 54, 6374.609, 2090.88, 504.303);
--------------------------------GUID (High: Unit Entry: 31779, Counter: 12560)----------------------------------
SET @GUID := XXXXX+9;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31779`, `571`, `1`, `1`, `26919`, `0`, `6438.341`, `2255.009`, `475.933`, `3.926991`, `300`, `0`, `0`, `12600`, `7988`, `0`, `2`);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, 6455.689, 2287.271, 471.219),
(@GUID, 2, 6455.535, 2288.259, 471.219),
(@GUID, 3, 6454.295, 2283.416, 471.844),
(@GUID, 4, 6453.303, 2279.541, 472.469),
(@GUID, 5, 6452.311, 2275.666, 473.094),
(@GUID, 6, 6451.318, 2271.791, 473.719),
(@GUID, 7, 6450.078, 2266.947, 474.344),
(@GUID, 8, 6445.758, 2262.425, 475.0487),
(@GUID, 9, 6440.102, 2256.769, 475.6737),
(@GUID, 10, 6435.859, 2252.526, 476.2987),
(@GUID, 11, 6433.333, 2250, 476.6287),
(@GUID, 12, 6431.097, 2245.527, 477.2537),
(@GUID, 13, 6428.413, 2240.16, 477.8787),
(@GUID, 14, 6426.177, 2235.688, 478.5037),
(@GUID, 15, 6425, 2233.333, 478.9586),
(@GUID, 16, 6425, 2228.333, 479.5836),
(@GUID, 17, 6425, 2224.333, 480.3336),
(@GUID, 18, 6425, 2222.333, 480.9586),
(@GUID, 19, 6425, 2219.333, 481.7086),
(@GUID, 20, 6425, 2217.333, 482.3336),
(@GUID, 21, 6425, 2216.667, 482.5836),
(@GUID, 22, 6425, 2212.667, 483.2086),
(@GUID, 23, 6425, 2210.667, 484.5836),
(@GUID, 24, 6425, 2208.667, 486.2086),
(@GUID, 25, 6425, 2205.667, 487.4586),
(@GUID, 26, 6425, 2203.667, 488.0836),
(@GUID, 27, 6425, 2200.667, 488.7086),
(@GUID, 28, 6425, 2200, 488.8864),
(@GUID, 29, 6422.891, 2194.381, 489.5114),
(@GUID, 30, 6418.75, 2183.333, 489.7614),
(@GUID, 31, 6418.75, 2179.167, 489.2614),
(@GUID, 32, 6418.75, 2175, 490.0114),
(@GUID, 33, 6418.75, 2172, 490.6364),
(@GUID, 34, 6418.75, 2170.833, 491.2614),
(@GUID, 35, 6418.75, 2166.833, 492.0114),
(@GUID, 36, 6418.75, 2163.667, 491.24),
(@GUID, 37, 6418.75, 2158.333, 491.99),
(@GUID, 38, 6418.934, 2156.054, 492.49),
(@GUID, 39, 6418.934, 2156.054, 492.49);
--------------------------------GUID (High: Unit Entry: 31779, Counter: 6199147)----------------------------------
SET @GUID := XXXXX+10;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `31779`, `571`, `1`, `1`, `26919`, `0`, `6423.059`, `2309.248`, `471.9709`, `5.497858`, `300`, `0`, `0`, `12600`, `7988`, `0`, `1`);
Код:
DELETE FROM creature WHERE id = 26525
SET @XXXXX := 150690
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 37463)----------------------------------
SET @GUID := XXXXX+1;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7419.081`, `1468.756`, `325.2975`, `5.967835`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
UPDATE `creature_template` SET `speed_walk` = 0.4 WHERE entry = 26525;
UPDATE `creature_template` SET `speed_run` = 0.8571429 WHERE entry = 26525;
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 38377)----------------------------------
SET @GUID := XXXXX+2;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7333.564`, `1348.066`, `308.2373`, `6.165107`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 982981)----------------------------------
SET @GUID := XXXXX+3;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7248.285`, `1452.929`, `321.5957`, `3.618543`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 5429087)----------------------------------
SET @GUID := XXXXX+4;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7242.083`, `1310.089`, `304.1856`, `4.973243`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 38374)----------------------------------
SET @GUID := XXXXX+5;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7333.101`, `1211.449`, `320.825`, `5.93333`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 2202026)----------------------------------
SET @GUID := XXXXX+6;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7237.939`, `1172.951`, `317.078`, `2.453733`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 30611)----------------------------------
SET @GUID := XXXXX+7;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7517.411`, `1374.746`, `321.4925`, `2.027017`, `300`, `0`, `0`, `42`, `0`, `0`, `2`);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, 7519.142, 1371.785, 321.7974),
(@GUID, 2, 7519.345, 1370.806, 321.7974),
(@GUID, 3, 7515.381, 1378.883, 321.1724),
(@GUID, 4, 7513.179, 1383.37, 320.5474),
(@GUID, 5, 7509.924, 1389.987, 320.4224),
(@GUID, 6, 7509.924, 1389.987, 320.4224);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 37464)----------------------------------
SET @GUID := XXXXX+8;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7478.864`, `1248.149`, `331.0811`, `1.60402`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 26525)----------------------------------
SET @GUID := XXXXX+9;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7655.143`, `1303.713`, `344.7319`, `5.085456`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 36058)----------------------------------
SET @GUID := XXXXX+10;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7620.411`, `1484.408`, `331.5391`, `4.091156`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 39067)----------------------------------
SET @GUID := XXXXX+11;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7503.576`, `1543.063`, `343.5091`, `5.695183`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 9790)----------------------------------
SET @GUID := XXXXX+12;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7735.689`, `1652.106`, `346.4973`, `0.901701`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 36059)----------------------------------
SET @GUID := XXXXX+13;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7859.71`, `1677.09`, `365.4266`, `3.88917`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 2316773)----------------------------------
SET @GUID := XXXXX+14;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `7148.502`, `1410`, `319.7658`, `2.102669`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 2624345)----------------------------------
SET @GUID := XXXXX+15;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `6910.936`, `1727.1`, `528.24`, `0.8536911`, `300`, `0`, `0`, `42`, `0`, `0`, `2`);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, 6906.774, 1722.83, 528.118),
(@GUID, 2, 6906.402, 1721.901, 528.118),
(@GUID, 3, 6911.049, 1727.231, 528.243),
(@GUID, 4, 6911.049, 1727.231, 528.243);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 6139601)----------------------------------
SET @GUID := XXXXX+16;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `6736.703`, `1704.261`, `568.4552`, `4.112466`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 7382261)----------------------------------
SET @GUID := XXXXX+17;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `6816.393`, `1815.679`, `578.3918`, `1.815665`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 38908)----------------------------------
SET @GUID := XXXXX+18;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `6617.345`, `2035.851`, `651.1174`, `1.679883`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 19988)----------------------------------
SET @GUID := XXXXX+19;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `6480.436`, `2156.3`, `502.6486`, `6.096518`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
--------------------------------GUID (High: Vehicle Entry: 26525, Counter: 38373)----------------------------------
SET @GUID := XXXXX+20;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(`@GUID`, `26525`, `571`, `1`, `1`, `23902`, `0`, `6442.111`, `2324.551`, `468.7483`, `2.905347`, `300`, `0`, `0`, `42`, `0`, `0`, `1`);
Сел и за час модернизировал плагин. Теперь отпутить как надо. Если первый раз ентри попадается - вся инфа ему: флаги, аттак пауер, вех Ид и прочее; если второй и далее - позиция и вейпоинты если есть. до этого приходилось удалять повторяемые апдейты флагов и т.д.Теперь могу сразу оутпуть и выкладывать, правдо еще с базой надо сверятся и смотреть
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Последний раз редактировалось Heisenberg; 06.02.2011 в 19:55.
|