DB/Misc: Adjust path ids to TDB standard (WoD+)

1 files changed, 203 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_01_12_01_world.sql b/sql/updates/world/master/2023_01_12_01_world.sql
new file mode 100644
index 00000000000..31a3a20a700
--- /dev/null
+++ b/sql/updates/world/master/2023_01_12_01_world.sql
@@ -0,0 +1,203 @@
+-- 
+UPDATE `waypoint_data` SET `id`=4599360 WHERE `id`=460098;   -- guid=459936
+UPDATE `waypoint_data` SET `id`=4599460 WHERE `id`=459955;   -- guid=459946
+UPDATE `waypoint_data` SET `id`=4599480 WHERE `id`=459975;   -- guid=459948
+UPDATE `waypoint_data` SET `id`=4599540 WHERE `id`=460035;   -- guid=459954
+UPDATE `waypoint_data` SET `id`=4599560 WHERE `id`=460055;   -- guid=459956
+UPDATE `waypoint_data` SET `id`=4599580 WHERE `id`=460075;   -- guid=459958
+UPDATE `waypoint_data` SET `id`=4599710 WHERE `id`=460025;   -- guid=459971
+UPDATE `waypoint_data` SET `id`=4599750 WHERE `id`=460065;   -- guid=459975
+UPDATE `waypoint_data` SET `id`=4599900 WHERE `id`=459999;   -- guid=459990
+UPDATE `waypoint_data` SET `id`=4599930 WHERE `id`=460029;   -- guid=459993
+UPDATE `waypoint_data` SET `id`=4600050 WHERE `id`=460149;   -- guid=460005
+UPDATE `waypoint_data` SET `id`=4600270 WHERE `id`=460369;   -- guid=460027
+UPDATE `waypoint_data` SET `id`=4600320 WHERE `id`=460419;   -- guid=460032
+UPDATE `waypoint_data` SET `id`=4600410 WHERE `id`=460509;   -- guid=460041
+UPDATE `waypoint_data` SET `id`=4600620 WHERE `id`=460719;   -- guid=460062
+UPDATE `waypoint_data` SET `id`=4600680 WHERE `id`=460779;   -- guid=460068
+UPDATE `waypoint_data` SET `id`=4600690 WHERE `id`=460789;   -- guid=460069
+UPDATE `waypoint_data` SET `id`=4600790 WHERE `id`=460889;   -- guid=460079
+UPDATE `waypoint_data` SET `id`=4600880 WHERE `id`=460979;   -- guid=460088
+UPDATE `waypoint_data` SET `id`=4601210 WHERE `id`=460148;   -- guid=460121
+UPDATE `waypoint_data` SET `id`=4601600 WHERE `id`=460538;   -- guid=460160
+UPDATE `waypoint_data` SET `id`=4602050 WHERE `id`=460988;   -- guid=460205
+UPDATE `waypoint_data` SET `id`=4602160 WHERE `id`=461098;   -- guid=460216
+UPDATE `waypoint_data` SET `id`=4602320 WHERE `id`=461258;   -- guid=460232
+UPDATE `waypoint_data` SET `id`=4602340 WHERE `id`=461278;   -- guid=460234
+UPDATE `waypoint_data` SET `id`=4602620 WHERE `id`=461558;   -- guid=460262
+UPDATE `waypoint_data` SET `id`=4603240 WHERE `id`=462178;   -- guid=460324
+UPDATE `waypoint_data` SET `id`=4603280 WHERE `id`=462218;   -- guid=460328
+UPDATE `waypoint_data` SET `id`=4603520 WHERE `id`=462458;   -- guid=460352
+UPDATE `waypoint_data` SET `id`=4603920 WHERE `id`=462858;   -- guid=460392
+UPDATE `waypoint_data` SET `id`=4604370 WHERE `id`=463308;   -- guid=460437
+UPDATE `waypoint_data` SET `id`=4604430 WHERE `id`=463368;   -- guid=460443
+UPDATE `waypoint_data` SET `id`=4604870 WHERE `id`=463808;   -- guid=460487
+UPDATE `waypoint_data` SET `id`=4605460 WHERE `id`=460555;   -- guid=460546
+UPDATE `waypoint_data` SET `id`=4605480 WHERE `id`=460575;   -- guid=460548
+UPDATE `waypoint_data` SET `id`=4605550 WHERE `id`=460645;   -- guid=460555
+UPDATE `waypoint_data` SET `id`=4605570 WHERE `id`=460665;   -- guid=460557
+UPDATE `waypoint_data` SET `id`=4605660 WHERE `id`=460602;   -- guid=460566
+UPDATE `waypoint_data` SET `id`=4605770 WHERE `id`=460712;   -- guid=460577
+UPDATE `waypoint_data` SET `id`=4605840 WHERE `id`=460782;   -- guid=460584
+UPDATE `waypoint_data` SET `id`=4606190 WHERE `id`=461132;   -- guid=460619
+UPDATE `waypoint_data` SET `id`=8500280 WHERE `id`=850199;   -- guid=850028
+UPDATE `waypoint_data` SET `id`=8500340 WHERE `id`=850259;   -- guid=850034
+UPDATE `waypoint_data` SET `id`=8500510 WHERE `id`=850429;   -- guid=850051
+UPDATE `waypoint_data` SET `id`=8500590 WHERE `id`=850509;   -- guid=850059
+UPDATE `waypoint_data` SET `id`=8500640 WHERE `id`=850559;   -- guid=850064
+UPDATE `waypoint_data` SET `id`=8501070 WHERE `id`=850989;   -- guid=850107
+UPDATE `waypoint_data` SET `id`=8501110 WHERE `id`=851029;   -- guid=850111
+UPDATE `waypoint_data` SET `id`=8501200 WHERE `id`=851119;   -- guid=850120
+UPDATE `waypoint_data` SET `id`=8501350 WHERE `id`=851269;   -- guid=850135
+UPDATE `waypoint_data` SET `id`=8501420 WHERE `id`=851339;   -- guid=850142
+UPDATE `waypoint_data` SET `id`=10501940 WHERE `id`=1050302; -- guid=1050194
+UPDATE `waypoint_data` SET `id`=10501950 WHERE `id`=1050312; -- guid=1050195
+UPDATE `waypoint_data` SET `id`=10504740 WHERE `id`=1050825; -- guid=1050474
+UPDATE `waypoint_data` SET `id`=10504790 WHERE `id`=1050875; -- guid=1050479
+UPDATE `waypoint_data` SET `id`=10504800 WHERE `id`=1050885; -- guid=1050480
+UPDATE `waypoint_data` SET `id`=10504960 WHERE `id`=1051045; -- guid=1050496
+UPDATE `waypoint_data` SET `id`=10504970 WHERE `id`=1051055; -- guid=1050497
+UPDATE `waypoint_data` SET `id`=10505240 WHERE `id`=1051325; -- guid=1050524
+UPDATE `waypoint_data` SET `id`=10505360 WHERE `id`=1051445; -- guid=1050536
+UPDATE `waypoint_data` SET `id`=10505400 WHERE `id`=1051485; -- guid=1050540
+UPDATE `waypoint_data` SET `id`=10505490 WHERE `id`=1051575; -- guid=1050549
+UPDATE `waypoint_data` SET `id`=10506290 WHERE `id`=1050980; -- guid=1050629
+UPDATE `waypoint_data` SET `id`=10506530 WHERE `id`=1051220; -- guid=1050653
+UPDATE `waypoint_data` SET `id`=10507210 WHERE `id`=1050964; -- guid=1050721
+UPDATE `waypoint_data` SET `id`=10507450 WHERE `id`=1051204; -- guid=1050745
+UPDATE `waypoint_data` SET `id`=10507620 WHERE `id`=1051374; -- guid=1050762
+UPDATE `waypoint_data` SET `id`=10507690 WHERE `id`=1051444; -- guid=1050769
+UPDATE `waypoint_data` SET `id`=10508320 WHERE `id`=1052074; -- guid=1050832
+UPDATE `waypoint_data` SET `id`=10509450 WHERE `id`=1051116; -- guid=1050945
+UPDATE `waypoint_data` SET `id`=10509650 WHERE `id`=1051316; -- guid=1050965
+UPDATE `waypoint_data` SET `id`=10509740 WHERE `id`=1051406; -- guid=1050974
+UPDATE `waypoint_data` SET `id`=10509830 WHERE `id`=1051496; -- guid=1050983
+UPDATE `waypoint_data` SET `id`=10509840 WHERE `id`=1051506; -- guid=1050984
+UPDATE `waypoint_data` SET `id`=10509870 WHERE `id`=1051536; -- guid=1050987
+UPDATE `waypoint_data` SET `id`=10510010 WHERE `id`=1051676; -- guid=1051001
+UPDATE `waypoint_data` SET `id`=10510460 WHERE `id`=1051163; -- guid=1051046
+UPDATE `waypoint_data` SET `id`=10510510 WHERE `id`=1051213; -- guid=1051051
+UPDATE `waypoint_data` SET `id`=10510850 WHERE `id`=1051238; -- guid=1051085
+UPDATE `waypoint_data` SET `id`=10510860 WHERE `id`=1051248; -- guid=1051086
+UPDATE `waypoint_data` SET `id`=10511010 WHERE `id`=1051398; -- guid=1051101
+UPDATE `waypoint_data` SET `id`=10511080 WHERE `id`=1051468; -- guid=1051108
+UPDATE `waypoint_data` SET `id`=10511250 WHERE `id`=1051638; -- guid=1051125
+UPDATE `waypoint_data` SET `id`=10511430 WHERE `id`=1051818; -- guid=1051143
+UPDATE `waypoint_data` SET `id`=10512190 WHERE `id`=1051273; -- guid=1051219
+UPDATE `waypoint_data` SET `id`=10512200 WHERE `id`=1051283; -- guid=1051220
+UPDATE `waypoint_data` SET `id`=10512390 WHERE `id`=1051473; -- guid=1051239
+UPDATE `waypoint_data` SET `id`=10512530 WHERE `id`=1051613; -- guid=1051253
+UPDATE `waypoint_data` SET `id`=10512810 WHERE `id`=1051362; -- guid=1051281
+UPDATE `waypoint_data` SET `id`=10512900 WHERE `id`=1051452; -- guid=1051290
+UPDATE `waypoint_data` SET `id`=10512950 WHERE `id`=1051502; -- guid=1051295
+UPDATE `waypoint_data` SET `id`=10513020 WHERE `id`=1051572; -- guid=1051302
+UPDATE `waypoint_data` SET `id`=10514200 WHERE `id`=1051483; -- guid=1051420
+UPDATE `waypoint_data` SET `id`=10514350 WHERE `id`=1051633; -- guid=1051435
+UPDATE `waypoint_data` SET `id`=10514780 WHERE `id`=1051802; -- guid=1051478
+UPDATE `waypoint_data` SET `id`=10514790 WHERE `id`=1051812; -- guid=1051479
+UPDATE `waypoint_data` SET `id`=10514840 WHERE `id`=1051862; -- guid=1051484
+UPDATE `waypoint_data` SET `id`=10515100 WHERE `id`=1051519; -- guid=1051510
+UPDATE `waypoint_data` SET `id`=10515270 WHERE `id`=1051689; -- guid=1051527
+UPDATE `waypoint_data` SET `id`=10515280 WHERE `id`=1051699; -- guid=1051528
+
+--
+UPDATE `creature_addon` SET `path_id`=4599360 WHERE `guid`=459936;  -- old path_id=460098 
+UPDATE `creature_addon` SET `path_id`=4599460 WHERE `guid`=459946;  -- old path_id=459955 
+UPDATE `creature_addon` SET `path_id`=4599480 WHERE `guid`=459948;  -- old path_id=459975 
+UPDATE `creature_addon` SET `path_id`=4599540 WHERE `guid`=459954;  -- old path_id=460035 
+UPDATE `creature_addon` SET `path_id`=4599560 WHERE `guid`=459956;  -- old path_id=460055 
+UPDATE `creature_addon` SET `path_id`=4599580 WHERE `guid`=459958;  -- old path_id=460075 
+UPDATE `creature_addon` SET `path_id`=4599710 WHERE `guid`=459971;  -- old path_id=460025 
+UPDATE `creature_addon` SET `path_id`=4599750 WHERE `guid`=459975;  -- old path_id=460065 
+UPDATE `creature_addon` SET `path_id`=4599900 WHERE `guid`=459990;  -- old path_id=459999 
+UPDATE `creature_addon` SET `path_id`=4599930 WHERE `guid`=459993;  -- old path_id=460029 
+UPDATE `creature_addon` SET `path_id`=4600050 WHERE `guid`=460005;  -- old path_id=460149 
+UPDATE `creature_addon` SET `path_id`=4600270 WHERE `guid`=460027;  -- old path_id=460369 
+UPDATE `creature_addon` SET `path_id`=4600320 WHERE `guid`=460032;  -- old path_id=460419 
+UPDATE `creature_addon` SET `path_id`=4600410 WHERE `guid`=460041;  -- old path_id=460509 
+UPDATE `creature_addon` SET `path_id`=4600620 WHERE `guid`=460062;  -- old path_id=460719 
+UPDATE `creature_addon` SET `path_id`=4600680 WHERE `guid`=460068;  -- old path_id=460779 
+UPDATE `creature_addon` SET `path_id`=4600690 WHERE `guid`=460069;  -- old path_id=460789 
+UPDATE `creature_addon` SET `path_id`=4600790 WHERE `guid`=460079;  -- old path_id=460889 
+UPDATE `creature_addon` SET `path_id`=4600880 WHERE `guid`=460088;  -- old path_id=460979 
+UPDATE `creature_addon` SET `path_id`=4601210 WHERE `guid`=460121;  -- old path_id=460148 
+UPDATE `creature_addon` SET `path_id`=4601600 WHERE `guid`=460160;  -- old path_id=460538 
+UPDATE `creature_addon` SET `path_id`=4602050 WHERE `guid`=460205;  -- old path_id=460988 
+UPDATE `creature_addon` SET `path_id`=4602160 WHERE `guid`=460216;  -- old path_id=461098 
+UPDATE `creature_addon` SET `path_id`=4602320 WHERE `guid`=460232;  -- old path_id=461258 
+UPDATE `creature_addon` SET `path_id`=4602340 WHERE `guid`=460234;  -- old path_id=461278 
+UPDATE `creature_addon` SET `path_id`=4602620 WHERE `guid`=460262;  -- old path_id=461558 
+UPDATE `creature_addon` SET `path_id`=4603240 WHERE `guid`=460324;  -- old path_id=462178 
+UPDATE `creature_addon` SET `path_id`=4603280 WHERE `guid`=460328;  -- old path_id=462218 
+UPDATE `creature_addon` SET `path_id`=4603520 WHERE `guid`=460352;  -- old path_id=462458 
+UPDATE `creature_addon` SET `path_id`=4603920 WHERE `guid`=460392;  -- old path_id=462858 
+UPDATE `creature_addon` SET `path_id`=4604370 WHERE `guid`=460437;  -- old path_id=463308 
+UPDATE `creature_addon` SET `path_id`=4604430 WHERE `guid`=460443;  -- old path_id=463368 
+UPDATE `creature_addon` SET `path_id`=4604870 WHERE `guid`=460487;  -- old path_id=463808 
+UPDATE `creature_addon` SET `path_id`=4605460 WHERE `guid`=460546;  -- old path_id=460555 
+UPDATE `creature_addon` SET `path_id`=4605480 WHERE `guid`=460548;  -- old path_id=460575 
+UPDATE `creature_addon` SET `path_id`=4605550 WHERE `guid`=460555;  -- old path_id=460645 
+UPDATE `creature_addon` SET `path_id`=4605570 WHERE `guid`=460557;  -- old path_id=460665 
+UPDATE `creature_addon` SET `path_id`=4605660 WHERE `guid`=460566;  -- old path_id=460602 
+UPDATE `creature_addon` SET `path_id`=4605770 WHERE `guid`=460577;  -- old path_id=460712 
+UPDATE `creature_addon` SET `path_id`=4605840 WHERE `guid`=460584;  -- old path_id=460782 
+UPDATE `creature_addon` SET `path_id`=4606190 WHERE `guid`=460619;  -- old path_id=461132 
+UPDATE `creature_addon` SET `path_id`=8500280 WHERE `guid`=850028;  -- old path_id=850199 
+UPDATE `creature_addon` SET `path_id`=8500340 WHERE `guid`=850034;  -- old path_id=850259 
+UPDATE `creature_addon` SET `path_id`=8500510 WHERE `guid`=850051;  -- old path_id=850429 
+UPDATE `creature_addon` SET `path_id`=8500590 WHERE `guid`=850059;  -- old path_id=850509 
+UPDATE `creature_addon` SET `path_id`=8500640 WHERE `guid`=850064;  -- old path_id=850559 
+UPDATE `creature_addon` SET `path_id`=8501070 WHERE `guid`=850107;  -- old path_id=850989 
+UPDATE `creature_addon` SET `path_id`=8501110 WHERE `guid`=850111;  -- old path_id=851029 
+UPDATE `creature_addon` SET `path_id`=8501200 WHERE `guid`=850120;  -- old path_id=851119 
+UPDATE `creature_addon` SET `path_id`=8501350 WHERE `guid`=850135;  -- old path_id=851269 
+UPDATE `creature_addon` SET `path_id`=8501420 WHERE `guid`=850142;  -- old path_id=851339 
+UPDATE `creature_addon` SET `path_id`=10501940 WHERE `guid`=1050194; -- old path_id=1050302
+UPDATE `creature_addon` SET `path_id`=10501950 WHERE `guid`=1050195; -- old path_id=1050312
+UPDATE `creature_addon` SET `path_id`=10504740 WHERE `guid`=1050474; -- old path_id=1050825
+UPDATE `creature_addon` SET `path_id`=10504790 WHERE `guid`=1050479; -- old path_id=1050875
+UPDATE `creature_addon` SET `path_id`=10504800 WHERE `guid`=1050480; -- old path_id=1050885
+UPDATE `creature_addon` SET `path_id`=10504960 WHERE `guid`=1050496; -- old path_id=1051045
+UPDATE `creature_addon` SET `path_id`=10504970 WHERE `guid`=1050497; -- old path_id=1051055
+UPDATE `creature_addon` SET `path_id`=10505240 WHERE `guid`=1050524; -- old path_id=1051325
+UPDATE `creature_addon` SET `path_id`=10505360 WHERE `guid`=1050536; -- old path_id=1051445
+UPDATE `creature_addon` SET `path_id`=10505400 WHERE `guid`=1050540; -- old path_id=1051485
+UPDATE `creature_addon` SET `path_id`=10505490 WHERE `guid`=1050549; -- old path_id=1051575
+UPDATE `creature_addon` SET `path_id`=10506290 WHERE `guid`=1050629; -- old path_id=1050980
+UPDATE `creature_addon` SET `path_id`=10506530 WHERE `guid`=1050653; -- old path_id=1051220
+UPDATE `creature_addon` SET `path_id`=10507210 WHERE `guid`=1050721; -- old path_id=1050964
+UPDATE `creature_addon` SET `path_id`=10507450 WHERE `guid`=1050745; -- old path_id=1051204
+UPDATE `creature_addon` SET `path_id`=10507620 WHERE `guid`=1050762; -- old path_id=1051374
+UPDATE `creature_addon` SET `path_id`=10507690 WHERE `guid`=1050769; -- old path_id=1051444
+UPDATE `creature_addon` SET `path_id`=10508320 WHERE `guid`=1050832; -- old path_id=1052074
+UPDATE `creature_addon` SET `path_id`=10509450 WHERE `guid`=1050945; -- old path_id=1051116
+UPDATE `creature_addon` SET `path_id`=10509650 WHERE `guid`=1050965; -- old path_id=1051316
+UPDATE `creature_addon` SET `path_id`=10509740 WHERE `guid`=1050974; -- old path_id=1051406
+UPDATE `creature_addon` SET `path_id`=10509830 WHERE `guid`=1050983; -- old path_id=1051496
+UPDATE `creature_addon` SET `path_id`=10509840 WHERE `guid`=1050984; -- old path_id=1051506
+UPDATE `creature_addon` SET `path_id`=10509870 WHERE `guid`=1050987; -- old path_id=1051536
+UPDATE `creature_addon` SET `path_id`=10510010 WHERE `guid`=1051001; -- old path_id=1051676
+UPDATE `creature_addon` SET `path_id`=10510460 WHERE `guid`=1051046; -- old path_id=1051163
+UPDATE `creature_addon` SET `path_id`=10510510 WHERE `guid`=1051051; -- old path_id=1051213
+UPDATE `creature_addon` SET `path_id`=10510850 WHERE `guid`=1051085; -- old path_id=1051238
+UPDATE `creature_addon` SET `path_id`=10510860 WHERE `guid`=1051086; -- old path_id=1051248
+UPDATE `creature_addon` SET `path_id`=10511010 WHERE `guid`=1051101; -- old path_id=1051398
+UPDATE `creature_addon` SET `path_id`=10511080 WHERE `guid`=1051108; -- old path_id=1051468
+UPDATE `creature_addon` SET `path_id`=10511250 WHERE `guid`=1051125; -- old path_id=1051638
+UPDATE `creature_addon` SET `path_id`=10511430 WHERE `guid`=1051143; -- old path_id=1051818
+UPDATE `creature_addon` SET `path_id`=10512190 WHERE `guid`=1051219; -- old path_id=1051273
+UPDATE `creature_addon` SET `path_id`=10512200 WHERE `guid`=1051220; -- old path_id=1051283
+UPDATE `creature_addon` SET `path_id`=10512390 WHERE `guid`=1051239; -- old path_id=1051473
+UPDATE `creature_addon` SET `path_id`=10512530 WHERE `guid`=1051253; -- old path_id=1051613
+UPDATE `creature_addon` SET `path_id`=10512810 WHERE `guid`=1051281; -- old path_id=1051362
+UPDATE `creature_addon` SET `path_id`=10512900 WHERE `guid`=1051290; -- old path_id=1051452
+UPDATE `creature_addon` SET `path_id`=10512950 WHERE `guid`=1051295; -- old path_id=1051502
+UPDATE `creature_addon` SET `path_id`=10513020 WHERE `guid`=1051302; -- old path_id=1051572
+UPDATE `creature_addon` SET `path_id`=10514200 WHERE `guid`=1051420; -- old path_id=1051483
+UPDATE `creature_addon` SET `path_id`=10514350 WHERE `guid`=1051435; -- old path_id=1051633
+UPDATE `creature_addon` SET `path_id`=10514780 WHERE `guid`=1051478; -- old path_id=1051802
+UPDATE `creature_addon` SET `path_id`=10514790 WHERE `guid`=1051479; -- old path_id=1051812
+UPDATE `creature_addon` SET `path_id`=10514840 WHERE `guid`=1051484; -- old path_id=1051862
+UPDATE `creature_addon` SET `path_id`=10515100 WHERE `guid`=1051510; -- old path_id=1051519
+UPDATE `creature_addon` SET `path_id`=10515270 WHERE `guid`=1051527; -- old path_id=1051689
+UPDATE `creature_addon` SET `path_id`=10515280 WHERE `guid`=1051528; -- old path_id=1051699