PDA

Просмотр полной версии : Wrong spawn Blackrock Sentry - Old spawn


alexluana
09.03.2012, 14:31
Core Revision: 11928 (I am using Mangosr2 mr1784)
Database revision: YTDB 616
Guid Npc: 4547
Description:This is an old spawn left in elwyn forest at the edge with lakeshire. It's place must not be there!

Suggestion Fix:
DELETE FROM creature WHERE guid=4547;
DELETE FROM creature_addon WHERE guid=4547;
DELETE FROM creature_movement WHERE id=4547;
DELETE FROM game_event_creature WHERE guid=4547;
DELETE FROM game_event_creature_data WHERE guid=4547;
DELETE FROM creature_battleground WHERE guid=4547;

NeatElves
09.03.2012, 15:04
Why delete, you have a lot of them?)
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
(92101, 4065, 0, 1, 1, 0, 0, -9283.71, -3027.75, 120.66, 1.28981, 300, 5, 0, 521, 0, 0, 1),
(92102, 4065, 0, 1, 1, 0, 0, -9392.3, -3017.34, 136.81, 3.45104, 300, 5, 0, 521, 0, 0, 1),
(4547, 4065, 0, 1, 1, 0, 0, -9308.72, -2942.36, 128.656, 4.43853, 300, 0, 0, 521, 0, 0, 2),
(94942, 4065, 0, 1, 1, 0, 0, -9337.76, -3025.9, 135.564, 2.82787, 300, 5, 0, 521, 0, 0, 1),
(94943, 4065, 0, 1, 1, 0, 0, -9278.73, -2939.37, 134.909, 1.10709, 300, 5, 0, 521, 0, 0, 1);
REPLACE INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES
(4547, 1, -9307.15, -2944.28, 128.676, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.20397, 0, 0),
(4547, 2, -9301.33, -2954.65, 128.753, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.62416, 0, 0),
(4547, 3, -9290.17, -2958.82, 128.753, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.000702, 0, 0),
(4547, 4, -9275.54, -2953.19, 128.661, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.358058, 0, 0),
(4547, 5, -9268.44, -2937.71, 128.753, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.2377, 0, 0),
(4547, 6, -9274.3, -2923.29, 128.752, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.35297, 0, 0),
(4547, 7, -9289.67, -2916.54, 128.753, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.81243, 0, 0),
(4547, 8, -9304.1, -2924.26, 128.753, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.05728, 0, 0),
(4547, 9, -9308.74, -2939.14, 128.737, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.55208, 0, 0);

alexluana
09.03.2012, 19:52
well in that case I don't understand what's with the movement when he just stand and do nothing...

and more than that...why is he spawned in elwyn forest? I remember that I confronted with this problem in past, when was still wotlk on official servers... and I checked wowhead and no references got me elwyn forest at all!