RG Live WotLK 3.3.5a

Wenn die Spieler wüssten wieviel Arbeit hinter all den Fixes steckt, von wegen "Ach ist doch schnell gemacht, kann ja net so riesig sein das zu beheben!" :D

damit müssen devs und tester leben ja :D

ps: ich z.b. mache es ja nicht für die user, meine hauptmovitation ist primär eine perfekte welt iwann vorzufinden für mich selbst

ich kann dir die tage mal noch die datenbank von mangos zukommen lassen, die haben einige wegpunkte, die wir z.b überhaupt nicht übernommen haben, d.h. den kram müsste man nur für den tc konvertieren

kay hp anpassung hab ich erstmal weggelassen

der komplette fix dafür würde so aussehen

SET @NPC := 6174;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -9609.59, -1902.44, 59.8293),
(@PATH, 2, -9614.35, -1908.93, 60.518),
(@PATH, 3, -9587.91, -1935.53, 63.93),
(@PATH, 4, -9583.95, -1927.61, 63.7386),
(@PATH, 5, -9590.18, -1908.27, 61.745),
(@PATH, 6, -9593.15, -1898.69, 60.4965),
(@PATH, 7, -9596.19, -1891.47, 59.6416),
(@PATH, 8, -9598.06, -1885.26, 59.1268),
(@PATH, 9, -9601.44, -1890.48, 59.3318),
(@PATH, 10, -9603.94, -1895.18, 59.5628),
(@PATH, 11, -9606.79, -1898.93, 59.6821);

SET @NPC := 89536;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -10494.1, 1028.6, 95.6127),
(@PATH, 2, -10493.8, 1024.01, 95.6127),
(@PATH, 3, -10496.6, 1019.52, 95.6127),
(@PATH, 4, -10501.7, 1018.4, 95.6127),
(@PATH, 5, -10506.5, 1021.16, 95.6127),
(@PATH, 6, -10508.2, 1026.82, 95.6127),
(@PATH, 7, -10505, 1031.12, 95.6127),
(@PATH, 8, -10499.2, 1032.62, 95.6127);

SET @NPC := 90391;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -10639.8, 995.543, 33.2862),
(@PATH, 2, -10644.9, 986.014, 32.8751),
(@PATH, 3, -10652.6, 982.5, 32.8751),
(@PATH, 4, -10661.5, 984.742, 32.8754),
(@PATH, 5, -10668.3, 989.124, 32.8754),
(@PATH, 6, -10673.4, 995.095, 32.9461),
(@PATH, 7, -10672.7, 1002.97, 32.9871),
(@PATH, 8, -10668.3, 1009.09, 33.5749);

SET @NPC := 18487;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -122.958, 761.745, 63.8195),
(@PATH, 2, -104.558, 767.504, 63.7726),
(@PATH, 3, -104.37, 774.128, 63.7082),
(@PATH, 4, -87.6989, 776.315, 63.9822),
(@PATH, 5, -90.0648, 794.821, 63.8111),
(@PATH, 6, -91.9612, 807.847, 63.6554),
(@PATH, 7, -97.9604, 820.414, 63.6546),
(@PATH, 8, -106.613, 826.77, 63.8459),
(@PATH, 9, -118.914, 829.674, 64.2801),
(@PATH, 10, -128.463, 835.776, 63.5951),
(@PATH, 11, -136.809, 829.198, 64.3145),
(@PATH, 12, -151.292, 816.324, 63.9126),
(@PATH, 13, -161.542, 808.734, 63.7224),
(@PATH, 14, -168.727, 805.758, 63.7161),
(@PATH, 15, -172.127, 791.766, 63.9629),
(@PATH, 16, -175.2, 772.535, 63.7749),
(@PATH, 17, -162.402, 765.096, 63.7155),
(@PATH, 18, -147.562, 756.737, 63.7234),
(@PATH, 19, -131.638, 759.655, 63.7268);

SET @NPC := 15360;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -929.691, -517.228, 6.87966),
(@PATH, 2, -914.649, -517.207, 6.87966),
(@PATH, 3, -898.67, -517.003, 6.87966),
(@PATH, 4, -898.597, -530.995, 6.87966),
(@PATH, 5, -898.198, -545.344, 6.87966),
(@PATH, 6, -897.652, -561.097, 6.87966),
(@PATH, 7, -897.638, -575.44, 6.87966),
(@PATH, 8, -907.555, -575.612, 6.87966),
(@PATH, 9, -907.538, -564.763, 6.87966),
(@PATH, 10, -908.832, -544.513, 6.87966),
(@PATH, 11, -908.849, -538.087, 6.87966),
(@PATH, 12, -921.772, -530.701, 6.87966),
(@PATH, 13, -929.333, -531.072, 6.87966);

DELETE FROM `creature` WHERE `guid`=15966;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES 
(15966, 2268, 0, 267, 286, 1, 1, 4125, 1, -496.828, 77.2981, 56.618, 4.71184, 300, 0, 0, 734, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=18486;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (18486, 1913, 0, 130, 233, 1, 1, 3593, 1, -131.688, 824.281, 63.5846, 1.63225, 275, 0, 0, 356, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=16535;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (16535, 2360, 0, 267, 286, 1, 1, 3703, 1, -378.11, 42.3602, 54.1959, 2.42634, 300, 5, 0, 573, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=16539;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (16539, 2360, 0, 267, 286, 1, 1, 3703, 1, -397.521, 106.942, 54.1701, 1.46815, 300, 0, 0, 573, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=16520;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (16520, 232, 0, 267, 286, 1, 1, 3614, 1, -338.875, 2.18325, 60.2852, 2.43811, 300, 0, 0, 617, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=15644;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (15644, 620, 0, 267, 286, 1, 1, 304, 0, -463.366, -102.693, 54.206, 1.5938, 300, 5, 0, 1, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=16372;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (16372, 2267, 0, 267, 286, 1, 1, 11035, 1, -552.191, -63.9678, 46.3555, 2.42632, 300, 5, 0, 664, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=15347;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (15347, 2386, 0, 267, 271, 1, 1, 3705, 1, -881.15, -589.017, 10.0753, 3.3586, 300, 3, 0, 2310, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=15664;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (15664, 2386, 0, 267, 271, 1, 1, 3708, 1, -795.343, -602.324, 15.1515, 2.39413, 300, 5, 0, 2310, 0, 1, 0, 0, 0, 0);

kp wie weit du mit dem tc install bist, aber das wird dir evtl später weiterhelfen :)

Bedeutung Live:

Der Bug wurde erfolgreich behoben und befindet sich auf dem Spielserver. Sollte der Fehler weiterhin bestehen sollte ein neues Ticket ( https://redmine.rising-gods.de/projects/live/issues/new ) erstellt werden. Anmerkungen in dem alten abgewiesenen oder live genommenen Ticket werden ignoriert und gelöscht.