diff options
| -rw-r--r-- | sql/updates/world/2015_07_19_21_world.sql | 827 |
1 files changed, 827 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_19_21_world.sql b/sql/updates/world/2015_07_19_21_world.sql new file mode 100644 index 00000000000..dfc49c45c6b --- /dev/null +++ b/sql/updates/world/2015_07_19_21_world.sql @@ -0,0 +1,827 @@ +-- All Stormshield Vendors +DELETE FROM `npc_vendor` WHERE `entry` IN (91321, 86175, 86176, 86178, 87049, 85849, 86387, 86389, 86390, 86391, 85932, 93906, 93907, 92501, 88155, 85946, 85950, 88230, 85955, 88235, 87365); +INSERT INTO `npc_vendor` (`entry`, `item`, `slot`, `maxcount`, `ExtendedCost`, `Type`, `VerifiedBuild`) VALUES +-- 91321 +(91321, 116965, 1, 0, 5340, 1, 20253), -- 116965 +(91321, 116967, 2, 0, 5340, 1, 20253), -- 116967 +(91321, 116966, 3, 0, 5340, 1, 20253), -- 116966 +(91321, 116968, 4, 0, 5340, 1, 20253), -- 116968 +(91321, 116961, 5, 0, 5900, 1, 20253), -- 116961 +(91321, 116962, 6, 0, 5900, 1, 20253), -- 116962 +(91321, 116964, 7, 0, 5900, 1, 20253), -- 116964 +(91321, 116963, 8, 0, 5900, 1, 20253), -- 116963 +(91321, 115403, 9, 0, 5901, 1, 20253), -- 115403 +(91321, 115402, 10, 0, 5901, 1, 20253), -- 115402 +(91321, 115400, 11, 0, 5901, 1, 20253), -- 115400 +(91321, 115401, 12, 0, 5901, 1, 20253), -- 115401 +(91321, 122315, 13, 0, 5902, 1, 20253), -- 122315 +(91321, 122312, 14, 0, 5902, 1, 20253), -- 122312 +(91321, 122313, 15, 0, 5902, 1, 20253), -- 122313 +(91321, 122314, 16, 0, 5902, 1, 20253), -- 122314 +(91321, 116768, 17, 0, 5853, 1, 20253), -- 116768 +(91321, 119821, 18, 0, 5490, 1, 20253), -- 119821 +-- 86175 +(86175, 120945, 1, 0, 2483, 1, 20253), -- 120945 +(86175, 120061, 3, 0, 5311, 1, 20253), -- 120061 +(86175, 120069, 4, 0, 5311, 1, 20253), -- 120069 +(86175, 120074, 5, 0, 5311, 1, 20253), -- 120074 +(86175, 120076, 6, 0, 5311, 1, 20253), -- 120076 +(86175, 120062, 7, 0, 5311, 1, 20253), -- 120062 +(86175, 120075, 8, 0, 5311, 1, 20253), -- 120075 +(86175, 120068, 9, 0, 5311, 1, 20253), -- 120068 +(86175, 120058, 10, 0, 5311, 1, 20253), -- 120058 +(86175, 120067, 11, 0, 5309, 1, 20253), -- 120067 +(86175, 120066, 12, 0, 5309, 1, 20253), -- 120066 +(86175, 120060, 13, 0, 5311, 1, 20253), -- 120060 +(86175, 120056, 14, 0, 5307, 1, 20253), -- 120056 +(86175, 120073, 15, 0, 5307, 1, 20253), -- 120073 +(86175, 120053, 16, 0, 5307, 1, 20253), -- 120053 +(86175, 120054, 17, 0, 5307, 1, 20253), -- 120054 +(86175, 120072, 18, 0, 5307, 1, 20253), -- 120072 +(86175, 120070, 19, 0, 5307, 1, 20253), -- 120070 +(86175, 120071, 20, 0, 5307, 1, 20253), -- 120071 +(86175, 120055, 21, 0, 5307, 1, 20253), -- 120055 +(86175, 120057, 22, 0, 5307, 1, 20253), -- 120057 +(86175, 120063, 23, 0, 5309, 1, 20253), -- 120063 +(86175, 120064, 24, 0, 5309, 1, 20253), -- 120064 +(86175, 115148, 25, 0, 5304, 1, 20253), -- 115148 +(86175, 115082, 26, 0, 5305, 1, 20253), -- 115082 +(86175, 115083, 27, 0, 5305, 1, 20253), -- 115083 +(86175, 115076, 28, 0, 5305, 1, 20253), -- 115076 +(86175, 115075, 29, 0, 5305, 1, 20253), -- 115075 +(86175, 115117, 35, 0, 5308, 1, 20253), -- 115117 +(86175, 115118, 36, 0, 5310, 1, 20253), -- 115118 +(86175, 115119, 37, 0, 5310, 1, 20253), -- 115119 +(86175, 115121, 38, 0, 5308, 1, 20253), -- 115121 +(86175, 115120, 39, 0, 5310, 1, 20253), -- 115120 +(86175, 115140, 85, 0, 5306, 1, 20253), -- 115140 +(86175, 115074, 86, 0, 5306, 1, 20253), -- 115074 +(86175, 115034, 87, 0, 5306, 1, 20253), -- 115034 +(86175, 115035, 88, 0, 5306, 1, 20253), -- 115035 +(86175, 115071, 89, 0, 5306, 1, 20253), -- 115071 +(86175, 115072, 90, 0, 5306, 1, 20253), -- 115072 +(86175, 115073, 91, 0, 5306, 1, 20253), -- 115073 +(86175, 115139, 92, 0, 5306, 1, 20253), -- 115139 +(86175, 115079, 93, 0, 5306, 1, 20253), -- 115079 +(86175, 115081, 94, 0, 5306, 1, 20253), -- 115081 +(86175, 115146, 95, 0, 5306, 1, 20253), -- 115146 +(86175, 115172, 96, 0, 5306, 1, 20253), -- 115172 +(86175, 115037, 97, 0, 5306, 1, 20253), -- 115037 +(86175, 115171, 98, 0, 5306, 1, 20253), -- 115171 +(86175, 115078, 99, 0, 5306, 1, 20253), -- 115078 +(86175, 115077, 100, 0, 5306, 1, 20253), -- 115077 +(86175, 115147, 101, 0, 5306, 1, 20253), -- 115147 +(86175, 115080, 102, 0, 5306, 1, 20253), -- 115080 +(86175, 115036, 103, 0, 5306, 1, 20253), -- 115036 +(86175, 115149, 104, 0, 5308, 1, 20253), -- 115149 +(86175, 115150, 105, 0, 5308, 1, 20253), -- 115150 +(86175, 115151, 106, 0, 5308, 1, 20253), -- 115151 +(86175, 115152, 107, 0, 5308, 1, 20253), -- 115152 +(86175, 115153, 108, 0, 5308, 1, 20253), -- 115153 +(86175, 115154, 109, 0, 5308, 1, 20253), -- 115154 +(86175, 115155, 110, 0, 5308, 1, 20253), -- 115155 +(86175, 122708, 111, 0, 5308, 1, 20253), -- 122708 +(86175, 115156, 112, 0, 5308, 1, 20253), -- 115156 +(86175, 115157, 113, 0, 5308, 1, 20253), -- 115157 +(86175, 115158, 114, 0, 5308, 1, 20253), -- 115158 +(86175, 115159, 115, 0, 5308, 1, 20253), -- 115159 +(86175, 115160, 116, 0, 5308, 1, 20253), -- 115160 +(86175, 115521, 117, 0, 5308, 1, 20253), -- 115521 +(86175, 115183, 118, 0, 5306, 1, 20253), -- 115183 +(86175, 115184, 119, 0, 5306, 1, 20253), -- 115184 +(86175, 115185, 120, 0, 5306, 1, 20253), -- 115185 +(86175, 115186, 121, 0, 5306, 1, 20253), -- 115186 +(86175, 115187, 122, 0, 5306, 1, 20253), -- 115187 +(86175, 115188, 123, 0, 5306, 1, 20253), -- 115188 +(86175, 115189, 124, 0, 5306, 1, 20253), -- 115189 +(86175, 115190, 125, 0, 5306, 1, 20253), -- 115190 +(86175, 115045, 126, 0, 5308, 1, 20253), -- 115045 +(86175, 115046, 127, 0, 5308, 1, 20253), -- 115046 +(86175, 115043, 128, 0, 5308, 1, 20253), -- 115043 +(86175, 115044, 129, 0, 5308, 1, 20253), -- 115044 +(86175, 115047, 130, 0, 5306, 1, 20253), -- 115047 +(86175, 115048, 131, 0, 5306, 1, 20253), -- 115048 +(86175, 115038, 132, 0, 5308, 1, 20253), -- 115038 +(86175, 115039, 133, 0, 5310, 1, 20253), -- 115039 +(86175, 115040, 134, 0, 5310, 1, 20253), -- 115040 +(86175, 115041, 135, 0, 5310, 1, 20253), -- 115041 +(86175, 115042, 136, 0, 5308, 1, 20253), -- 115042 +(86175, 115086, 137, 0, 5308, 1, 20253), -- 115086 +(86175, 115087, 138, 0, 5308, 1, 20253), -- 115087 +(86175, 115084, 139, 0, 5308, 1, 20253), -- 115084 +(86175, 115085, 140, 0, 5308, 1, 20253), -- 115085 +(86175, 115088, 141, 0, 5306, 1, 20253), -- 115088 +(86175, 115089, 142, 0, 5306, 1, 20253), -- 115089 +(86175, 115174, 143, 0, 5308, 1, 20253), -- 115174 +(86175, 115175, 144, 0, 5310, 1, 20253), -- 115175 +(86175, 115173, 145, 0, 5310, 1, 20253), -- 115173 +(86175, 115176, 146, 0, 5310, 1, 20253), -- 115176 +(86175, 115177, 147, 0, 5308, 1, 20253), -- 115177 +(86175, 115097, 148, 0, 5308, 1, 20253), -- 115097 +(86175, 115098, 149, 0, 5308, 1, 20253), -- 115098 +(86175, 115095, 150, 0, 5308, 1, 20253), -- 115095 +(86175, 115096, 151, 0, 5308, 1, 20253), -- 115096 +(86175, 115100, 152, 0, 5306, 1, 20253), -- 115100 +(86175, 115099, 153, 0, 5306, 1, 20253), -- 115099 +(86175, 115179, 154, 0, 5308, 1, 20253), -- 115179 +(86175, 115180, 155, 0, 5310, 1, 20253), -- 115180 +(86175, 115178, 156, 0, 5310, 1, 20253), -- 115178 +(86175, 115181, 157, 0, 5310, 1, 20253), -- 115181 +(86175, 115182, 158, 0, 5308, 1, 20253), -- 115182 +(86175, 115113, 159, 0, 5308, 1, 20253), -- 115113 +(86175, 115114, 160, 0, 5308, 1, 20253), -- 115114 +(86175, 115111, 161, 0, 5308, 1, 20253), -- 115111 +(86175, 115112, 162, 0, 5308, 1, 20253), -- 115112 +(86175, 115115, 163, 0, 5306, 1, 20253), -- 115115 +(86175, 115116, 164, 0, 5306, 1, 20253), -- 115116 +(86175, 115142, 165, 0, 5308, 1, 20253), -- 115142 +(86175, 115143, 166, 0, 5310, 1, 20253), -- 115143 +(86175, 115141, 167, 0, 5310, 1, 20253), -- 115141 +(86175, 115144, 168, 0, 5310, 1, 20253), -- 115144 +(86175, 115145, 169, 0, 5308, 1, 20253), -- 115145 +-- 86176 +(86176, 115594, 2, 0, 5307, 1, 20253), -- 115594 +(86176, 115595, 3, 0, 5307, 1, 20253), -- 115595 +(86176, 115596, 4, 0, 5307, 1, 20253), -- 115596 +(86176, 115597, 5, 0, 5307, 1, 20253), -- 115597 +(86176, 115598, 6, 0, 5307, 1, 20253), -- 115598 +(86176, 115599, 7, 0, 5311, 1, 20253), -- 115599 +(86176, 115601, 8, 0, 5311, 1, 20253), -- 115601 +(86176, 115602, 9, 0, 5311, 1, 20253), -- 115602 +(86176, 115644, 10, 0, 5309, 1, 20253), -- 115644 +(86176, 115645, 11, 0, 5309, 1, 20253), -- 115645 +(86176, 115646, 12, 0, 5309, 1, 20253), -- 115646 +(86176, 115647, 13, 0, 5309, 1, 20253), -- 115647 +(86176, 115648, 14, 0, 5309, 1, 20253), -- 115648 +(86176, 115649, 15, 0, 5311, 1, 20253), -- 115649 +(86176, 115650, 16, 0, 5311, 1, 20253), -- 115650 +(86176, 115725, 17, 0, 5307, 1, 20253), -- 115725 +(86176, 115726, 18, 0, 5307, 1, 20253), -- 115726 +(86176, 115727, 19, 0, 5307, 1, 20253), -- 115727 +(86176, 115728, 20, 0, 5307, 1, 20253), -- 115728 +(86176, 115729, 21, 0, 5311, 1, 20253), -- 115729 +(86176, 115730, 22, 0, 5311, 1, 20253), -- 115730 +(86176, 115731, 23, 0, 5311, 1, 20253), -- 115731 +(86176, 115659, 24, 0, 5305, 1, 20253), -- 115659 +(86176, 115660, 25, 0, 5305, 1, 20253), -- 115660 +(86176, 115666, 26, 0, 5305, 1, 20253), -- 115666 +(86176, 115667, 27, 0, 5305, 1, 20253), -- 115667 +(86176, 115748, 28, 0, 5305, 1, 20253), -- 115748 +(86176, 115710, 34, 0, 5308, 1, 20253), -- 115710 +(86176, 115711, 35, 0, 5310, 1, 20253), -- 115711 +(86176, 115712, 36, 0, 5310, 1, 20253), -- 115712 +(86176, 115713, 37, 0, 5310, 1, 20253), -- 115713 +(86176, 115714, 38, 0, 5308, 1, 20253), -- 115714 +(86176, 115661, 84, 0, 5306, 1, 20253), -- 115661 +(86176, 115664, 85, 0, 5306, 1, 20253), -- 115664 +(86176, 115771, 86, 0, 5306, 1, 20253), -- 115771 +(86176, 115772, 87, 0, 5306, 1, 20253), -- 115772 +(86176, 115662, 88, 0, 5306, 1, 20253), -- 115662 +(86176, 115665, 89, 0, 5306, 1, 20253), -- 115665 +(86176, 115608, 90, 0, 5306, 1, 20253), -- 115608 +(86176, 115746, 91, 0, 5306, 1, 20253), -- 115746 +(86176, 115609, 92, 0, 5306, 1, 20253), -- 115609 +(86176, 115663, 93, 0, 5306, 1, 20253), -- 115663 +(86176, 115747, 94, 0, 5306, 1, 20253), -- 115747 +(86176, 115657, 95, 0, 5306, 1, 20253), -- 115657 +(86176, 115658, 96, 0, 5306, 1, 20253), -- 115658 +(86176, 115606, 97, 0, 5306, 1, 20253), -- 115606 +(86176, 115655, 98, 0, 5306, 1, 20253), -- 115655 +(86176, 115656, 99, 0, 5306, 1, 20253), -- 115656 +(86176, 115607, 100, 0, 5306, 1, 20253), -- 115607 +(86176, 115734, 101, 0, 5306, 1, 20253), -- 115734 +(86176, 115735, 102, 0, 5306, 1, 20253), -- 115735 +(86176, 115755, 103, 0, 5308, 1, 20253), -- 115755 +(86176, 115753, 104, 0, 5308, 1, 20253), -- 115753 +(86176, 115752, 105, 0, 5308, 1, 20253), -- 115752 +(86176, 115757, 106, 0, 5308, 1, 20253), -- 115757 +(86176, 115749, 107, 0, 5308, 1, 20253), -- 115749 +(86176, 115750, 108, 0, 5308, 1, 20253), -- 115750 +(86176, 115756, 109, 0, 5308, 1, 20253), -- 115756 +(86176, 115751, 110, 0, 5308, 1, 20253), -- 115751 +(86176, 115754, 111, 0, 5308, 1, 20253), -- 115754 +(86176, 115758, 112, 0, 5308, 1, 20253), -- 115758 +(86176, 122706, 113, 0, 5308, 1, 20253), -- 122706 +(86176, 115496, 114, 0, 5308, 1, 20253), -- 115496 +(86176, 115760, 115, 0, 5308, 1, 20253), -- 115760 +(86176, 115759, 116, 0, 5308, 1, 20253), -- 115759 +(86176, 115604, 117, 0, 5306, 1, 20253), -- 115604 +(86176, 115651, 118, 0, 5306, 1, 20253), -- 115651 +(86176, 115732, 119, 0, 5306, 1, 20253), -- 115732 +(86176, 115652, 120, 0, 5306, 1, 20253), -- 115652 +(86176, 115653, 121, 0, 5306, 1, 20253), -- 115653 +(86176, 115654, 122, 0, 5306, 1, 20253), -- 115654 +(86176, 115733, 123, 0, 5306, 1, 20253), -- 115733 +(86176, 115605, 124, 0, 5306, 1, 20253), -- 115605 +(86176, 120100, 125, 0, 5306, 1, 20253), -- 120100 +(86176, 120108, 126, 0, 5306, 1, 20253), -- 120108 +(86176, 120104, 127, 0, 5306, 1, 20253), -- 120104 +(86176, 115623, 128, 0, 5308, 1, 20253), -- 115623 +(86176, 115624, 129, 0, 5308, 1, 20253), -- 115624 +(86176, 115625, 130, 0, 5308, 1, 20253), -- 115625 +(86176, 115620, 131, 0, 5308, 1, 20253), -- 115620 +(86176, 115621, 132, 0, 5308, 1, 20253), -- 115621 +(86176, 115622, 133, 0, 5308, 1, 20253), -- 115622 +(86176, 115626, 134, 0, 5306, 1, 20253), -- 115626 +(86176, 115627, 135, 0, 5306, 1, 20253), -- 115627 +(86176, 115628, 136, 0, 5306, 1, 20253), -- 115628 +(86176, 115619, 137, 0, 5308, 1, 20253), -- 115619 +(86176, 115614, 138, 0, 5308, 1, 20253), -- 115614 +(86176, 115613, 139, 0, 5310, 1, 20253), -- 115613 +(86176, 115618, 140, 0, 5310, 1, 20253), -- 115618 +(86176, 115612, 141, 0, 5310, 1, 20253), -- 115612 +(86176, 115617, 142, 0, 5310, 1, 20253), -- 115617 +(86176, 115611, 143, 0, 5310, 1, 20253), -- 115611 +(86176, 115616, 144, 0, 5310, 1, 20253), -- 115616 +(86176, 115610, 145, 0, 5308, 1, 20253), -- 115610 +(86176, 115615, 146, 0, 5308, 1, 20253), -- 115615 +(86176, 115672, 147, 0, 5308, 1, 20253), -- 115672 +(86176, 115673, 148, 0, 5308, 1, 20253), -- 115673 +(86176, 115671, 149, 0, 5308, 1, 20253), -- 115671 +(86176, 115670, 150, 0, 5308, 1, 20253), -- 115670 +(86176, 115668, 151, 0, 5308, 1, 20253), -- 115668 +(86176, 115669, 152, 0, 5308, 1, 20253), -- 115669 +(86176, 115675, 153, 0, 5306, 1, 20253), -- 115675 +(86176, 115674, 154, 0, 5306, 1, 20253), -- 115674 +(86176, 115676, 155, 0, 5306, 1, 20253), -- 115676 +(86176, 115787, 156, 0, 5308, 1, 20253), -- 115787 +(86176, 115777, 157, 0, 5308, 1, 20253), -- 115777 +(86176, 115786, 158, 0, 5310, 1, 20253), -- 115786 +(86176, 115776, 159, 0, 5310, 1, 20253), -- 115776 +(86176, 115785, 160, 0, 5310, 1, 20253), -- 115785 +(86176, 115775, 161, 0, 5310, 1, 20253), -- 115775 +(86176, 115784, 162, 0, 5308, 1, 20253), -- 115784 +(86176, 115774, 163, 0, 5308, 1, 20253), -- 115774 +(86176, 115773, 164, 0, 5310, 1, 20253), -- 115773 +(86176, 115783, 165, 0, 5310, 1, 20253), -- 115783 +(86176, 115686, 166, 0, 5308, 1, 20253), -- 115686 +(86176, 115687, 167, 0, 5308, 1, 20253), -- 115687 +(86176, 115685, 168, 0, 5308, 1, 20253), -- 115685 +(86176, 115684, 169, 0, 5308, 1, 20253), -- 115684 +(86176, 115682, 170, 0, 5308, 1, 20253), -- 115682 +(86176, 115683, 171, 0, 5308, 1, 20253), -- 115683 +(86176, 115688, 172, 0, 5306, 1, 20253), -- 115688 +(86176, 115689, 173, 0, 5306, 1, 20253), -- 115689 +(86176, 115690, 174, 0, 5306, 1, 20253), -- 115690 +(86176, 115792, 175, 0, 5308, 1, 20253), -- 115792 +(86176, 115782, 176, 0, 5308, 1, 20253), -- 115782 +(86176, 115781, 177, 0, 5310, 1, 20253), -- 115781 +(86176, 115791, 178, 0, 5310, 1, 20253), -- 115791 +(86176, 115790, 179, 0, 5310, 1, 20253), -- 115790 +(86176, 115780, 180, 0, 5310, 1, 20253), -- 115780 +(86176, 115779, 181, 0, 5308, 1, 20253), -- 115779 +(86176, 115789, 182, 0, 5308, 1, 20253), -- 115789 +(86176, 115778, 183, 0, 5310, 1, 20253), -- 115778 +(86176, 115788, 184, 0, 5310, 1, 20253), -- 115788 +(86176, 115706, 185, 0, 5308, 1, 20253), -- 115706 +(86176, 115704, 186, 0, 5308, 1, 20253), -- 115704 +(86176, 115705, 187, 0, 5308, 1, 20253), -- 115705 +(86176, 115701, 188, 0, 5308, 1, 20253), -- 115701 +(86176, 115702, 189, 0, 5308, 1, 20253), -- 115702 +(86176, 115703, 190, 0, 5308, 1, 20253), -- 115703 +(86176, 115707, 191, 0, 5306, 1, 20253), -- 115707 +(86176, 115708, 192, 0, 5306, 1, 20253), -- 115708 +(86176, 115709, 193, 0, 5306, 1, 20253), -- 115709 +(86176, 115740, 194, 0, 5308, 1, 20253), -- 115740 +(86176, 115745, 195, 0, 5308, 1, 20253), -- 115745 +(86176, 115744, 196, 0, 5310, 1, 20253), -- 115744 +(86176, 115739, 197, 0, 5310, 1, 20253), -- 115739 +(86176, 115738, 198, 0, 5310, 1, 20253), -- 115738 +(86176, 115743, 199, 0, 5310, 1, 20253), -- 115743 +(86176, 115737, 200, 0, 5308, 1, 20253), -- 115737 +(86176, 115742, 201, 0, 5308, 1, 20253), -- 115742 +(86176, 115736, 202, 0, 5310, 1, 20253), -- 115736 +(86176, 115741, 203, 0, 5310, 1, 20253), -- 115741 +-- 86178 +(86178, 127366, 1, 0, 5318, 1, 20253), -- 127366 +(86178, 127375, 2, 0, 5318, 1, 20253), -- 127375 +(86178, 120287, 3, 0, 5275, 1, 20253), -- 120287 +(86178, 120286, 4, 0, 5275, 1, 20253), -- 120286 +(86178, 125631, 5, 0, 5205, 1, 20253), -- 125631 +(86178, 125632, 6, 0, 5205, 1, 20253), -- 125632 +(86178, 125633, 7, 0, 5205, 1, 20253), -- 125633 +(86178, 125634, 8, 0, 5206, 1, 20253), -- 125634 +(86178, 125635, 9, 0, 5206, 1, 20253), -- 125635 +(86178, 125636, 10, 0, 5206, 1, 20253), -- 125636 +(86178, 125637, 11, 0, 5205, 1, 20253), -- 125637 +(86178, 125646, 12, 0, 5209, 1, 20253), -- 125646 +(86178, 125647, 13, 0, 5205, 1, 20253), -- 125647 +(86178, 125649, 14, 0, 5209, 1, 20253), -- 125649 +(86178, 125650, 15, 0, 5205, 1, 20253), -- 125650 +(86178, 125668, 16, 0, 5205, 1, 20253), -- 125668 +(86178, 125676, 17, 0, 5205, 1, 20253), -- 125676 +(86178, 125677, 18, 0, 5209, 1, 20253), -- 125677 +(86178, 125679, 19, 0, 5205, 1, 20253), -- 125679 +(86178, 125724, 20, 0, 5205, 1, 20253), -- 125724 +(86178, 125761, 21, 0, 5206, 1, 20253), -- 125761 +(86178, 125762, 22, 0, 5206, 1, 20253), -- 125762 +(86178, 125763, 23, 0, 5206, 1, 20253), -- 125763 +(86178, 125764, 24, 0, 5209, 1, 20253), -- 125764 +(86178, 125765, 25, 0, 5209, 1, 20253), -- 125765 +(86178, 125766, 26, 0, 5206, 1, 20253), -- 125766 +(86178, 125767, 27, 0, 5206, 1, 20253), -- 125767 +(86178, 125768, 28, 0, 5206, 1, 20253), -- 125768 +(86178, 125644, 29, 0, 5208, 1, 20253), -- 125644 +(86178, 125648, 30, 0, 5208, 1, 20253), -- 125648 +(86178, 125645, 31, 0, 5208, 1, 20253), -- 125645 +(86178, 125678, 32, 0, 5208, 1, 20253), -- 125678 +(86178, 125769, 33, 0, 5208, 1, 20253), -- 125769 +(86178, 125640, 36, 0, 5207, 1, 20253), -- 125640 +(86178, 125643, 39, 0, 5207, 1, 20253), -- 125643 +(86178, 125725, 45, 0, 5207, 1, 20253), -- 125725 +(86178, 125726, 46, 0, 5210, 1, 20253), -- 125726 +(86178, 125727, 47, 0, 5210, 1, 20253), -- 125727 +(86178, 125728, 48, 0, 5210, 1, 20253), -- 125728 +(86178, 125729, 49, 0, 5207, 1, 20253), -- 125729 +(86178, 125730, 50, 0, 5207, 1, 20253), -- 125730 +(86178, 125731, 51, 0, 5210, 1, 20253), -- 125731 +(86178, 125732, 52, 0, 5210, 1, 20253), -- 125732 +(86178, 125733, 53, 0, 5210, 1, 20253), -- 125733 +(86178, 125734, 54, 0, 5207, 1, 20253), -- 125734 +(86178, 125782, 60, 0, 5207, 1, 20253), -- 125782 +(86178, 125783, 61, 0, 5207, 1, 20253), -- 125783 +-- 87049 +(87049, 114852, 2, 0, 5303, 1, 20253), -- 114852 +(87049, 114861, 3, 0, 5303, 1, 20253), -- 114861 +(87049, 114862, 4, 0, 5303, 1, 20253), -- 114862 +(87049, 114863, 5, 0, 5303, 1, 20253), -- 114863 +(87049, 114853, 6, 0, 5303, 1, 20253), -- 114853 +(87049, 114854, 7, 0, 5303, 1, 20253), -- 114854 +(87049, 114855, 8, 0, 5303, 1, 20253), -- 114855 +(87049, 114856, 9, 0, 5303, 1, 20253), -- 114856 +(87049, 114857, 10, 0, 5303, 1, 20253), -- 114857 +(87049, 114858, 11, 0, 5303, 1, 20253), -- 114858 +(87049, 114859, 12, 0, 5303, 1, 20253), -- 114859 +(87049, 114860, 13, 0, 5303, 1, 20253), -- 114860 +(87049, 114864, 14, 0, 5300, 1, 20253), -- 114864 +(87049, 114865, 15, 0, 5300, 1, 20253), -- 114865 +(87049, 114866, 16, 0, 5300, 1, 20253), -- 114866 +(87049, 114871, 17, 0, 5300, 1, 20253), -- 114871 +(87049, 114970, 18, 0, 5303, 1, 20253), -- 114970 +-- 85849 +(85849, 111966, 1, 0, 5329, 1, 20253), -- 111966 +(85849, 109062, 2, 0, 5329, 1, 20253), -- 109062 +(85849, 112002, 3, 0, 5329, 1, 20253), -- 112002 +(85849, 111984, 4, 0, 5329, 1, 20253), -- 111984 +(85849, 111970, 5, 0, 5329, 1, 20253), -- 111970 +(85849, 111968, 6, 0, 5325, 1, 20253), -- 111968 +(85849, 107694, 7, 0, 5325, 1, 20253), -- 107694 +(85849, 109254, 8, 0, 5325, 1, 20253), -- 109254 +(85849, 111980, 9, 0, 5325, 1, 20253), -- 111980 +(85849, 111986, 10, 0, 5325, 1, 20253), -- 111986 +(85849, 111929, 11, 0, 5325, 1, 20253), -- 111929 +(85849, 111972, 12, 0, 5325, 1, 20253), -- 111972 +(85849, 109256, 13, 0, 5325, 1, 20253), -- 109256 +(85849, 111974, 14, 0, 5325, 1, 20253), -- 111974 +(85849, 111976, 15, 0, 5325, 1, 20253), -- 111976 +(85849, 111978, 16, 0, 5325, 1, 20253), -- 111978 +(85849, 111982, 17, 0, 5325, 1, 20253), -- 111982 +(85849, 111992, 18, 0, 5325, 1, 20253), -- 111992 +(85849, 111990, 19, 0, 5325, 1, 20253), -- 111990 +(85849, 111988, 20, 0, 5325, 1, 20253), -- 111988 +-- 86387 +(86387, 116956, 1, 0, 5340, 1, 20253), -- 116956 +(86387, 116953, 2, 0, 5340, 1, 20253), -- 116953 +(86387, 116954, 3, 0, 5340, 1, 20253), -- 116954 +(86387, 116955, 4, 0, 5340, 1, 20253), -- 116955 +(86387, 116959, 5, 0, 5900, 1, 20253), -- 116959 +(86387, 116957, 6, 0, 5900, 1, 20253), -- 116957 +(86387, 116960, 7, 0, 5900, 1, 20253), -- 116960 +(86387, 116958, 8, 0, 5900, 1, 20253), -- 116958 +(86387, 115398, 9, 0, 5901, 1, 20253), -- 115398 +(86387, 115396, 10, 0, 5901, 1, 20253), -- 115396 +(86387, 115397, 11, 0, 5901, 1, 20253), -- 115397 +(86387, 115399, 12, 0, 5901, 1, 20253), -- 115399 +(86387, 122308, 13, 0, 5902, 1, 20253), -- 122308 +(86387, 122311, 14, 0, 5902, 1, 20253), -- 122311 +(86387, 122310, 15, 0, 5902, 1, 20253), -- 122310 +(86387, 122309, 16, 0, 5902, 1, 20253), -- 122309 +(86387, 116768, 17, 0, 5853, 1, 20253), -- 116768 +(86387, 119821, 18, 0, 5490, 1, 20253), -- 119821 +-- 86389 +(86389, 116975, 1, 0, 5340, 1, 20253), -- 116975 +(86389, 116976, 2, 0, 5340, 1, 20253), -- 116976 +(86389, 116973, 3, 0, 5340, 1, 20253), -- 116973 +(86389, 116974, 4, 0, 5340, 1, 20253), -- 116974 +(86389, 116952, 5, 0, 5340, 1, 20253), -- 116952 +(86389, 115394, 6, 0, 5900, 1, 20253), -- 115394 +(86389, 115393, 7, 0, 5900, 1, 20253), -- 115393 +(86389, 115392, 8, 0, 5900, 1, 20253), -- 115392 +(86389, 115395, 9, 0, 5900, 1, 20253), -- 115395 +(86389, 115391, 10, 0, 5900, 1, 20253), -- 115391 +(86389, 116972, 11, 0, 5901, 1, 20253), -- 116972 +(86389, 116969, 12, 0, 5901, 1, 20253), -- 116969 +(86389, 116951, 13, 0, 5901, 1, 20253), -- 116951 +(86389, 116971, 14, 0, 5901, 1, 20253), -- 116971 +(86389, 116970, 15, 0, 5901, 1, 20253), -- 116970 +(86389, 122329, 16, 0, 5902, 1, 20253), -- 122329 +(86389, 122332, 17, 0, 5902, 1, 20253), -- 122332 +(86389, 122330, 18, 0, 5902, 1, 20253), -- 122330 +(86389, 122328, 19, 0, 5902, 1, 20253), -- 122328 +(86389, 122331, 20, 0, 5902, 1, 20253), -- 122331 +(86389, 116768, 21, 0, 5853, 1, 20253), -- 116768 +(86389, 119821, 22, 0, 5490, 1, 20253), -- 119821 +-- 86390 +(86390, 116945, 1, 0, 5340, 1, 20253), -- 116945 +(86390, 116946, 2, 0, 5340, 1, 20253), -- 116946 +(86390, 116944, 3, 0, 5340, 1, 20253), -- 116944 +(86390, 116943, 4, 0, 5340, 1, 20253), -- 116943 +(86390, 115388, 5, 0, 5900, 1, 20253), -- 115388 +(86390, 115387, 6, 0, 5900, 1, 20253), -- 115387 +(86390, 115390, 7, 0, 5900, 1, 20253), -- 115390 +(86390, 115389, 8, 0, 5900, 1, 20253), -- 115389 +(86390, 116950, 9, 0, 5901, 1, 20253), -- 116950 +(86390, 116947, 10, 0, 5901, 1, 20253), -- 116947 +(86390, 116948, 11, 0, 5901, 1, 20253), -- 116948 +(86390, 116949, 12, 0, 5901, 1, 20253), -- 116949 +(86390, 122324, 13, 0, 5902, 1, 20253), -- 122324 +(86390, 122326, 14, 0, 5902, 1, 20253), -- 122326 +(86390, 122325, 15, 0, 5902, 1, 20253), -- 122325 +(86390, 122327, 16, 0, 5902, 1, 20253), -- 122327 +(86390, 116768, 17, 0, 5853, 1, 20253), -- 116768 +(86390, 119821, 18, 0, 5490, 1, 20253), -- 119821 +-- 86391 +(86391, 115377, 1, 0, 5340, 1, 20253), -- 115377 +(86391, 115376, 2, 0, 5340, 1, 20253), -- 115376 +(86391, 115374, 3, 0, 5340, 1, 20253), -- 115374 +(86391, 115375, 4, 0, 5340, 1, 20253), -- 115375 +(86391, 116930, 5, 0, 5900, 1, 20253), -- 116930 +(86391, 116927, 6, 0, 5900, 1, 20253), -- 116927 +(86391, 116928, 7, 0, 5900, 1, 20253), -- 116928 +(86391, 116929, 8, 0, 5900, 1, 20253), -- 116929 +(86391, 116933, 9, 0, 5901, 1, 20253), -- 116933 +(86391, 116934, 10, 0, 5901, 1, 20253), -- 116934 +(86391, 116931, 11, 0, 5901, 1, 20253), -- 116931 +(86391, 116932, 12, 0, 5901, 1, 20253), -- 116932 +(86391, 122316, 13, 0, 5902, 1, 20253), -- 122316 +(86391, 122318, 14, 0, 5902, 1, 20253), -- 122318 +(86391, 122319, 15, 0, 5902, 1, 20253), -- 122319 +(86391, 122317, 16, 0, 5902, 1, 20253), -- 122317 +(86391, 116768, 17, 0, 5853, 1, 20253), -- 116768 +(86391, 119821, 18, 0, 5490, 1, 20253), -- 119821 +-- 85932 +(85932, 116664, 1, 0, 5457, 1, 20253), -- 116664 +(85932, 115472, 2, 0, 5453, 1, 20253), -- 115472 +(85932, 119162, 3, 0, 5851, 1, 20253), -- 119162 +(85932, 118663, 4, 0, 0, 1, 20253), -- 118663 +(85932, 118665, 5, 0, 5456, 1, 20253), -- 118665 +(85932, 119142, 6, 0, 5458, 1, 20253), -- 119142 +(85932, 119135, 7, 0, 0, 1, 20253), -- 119135 +(85932, 118680, 8, 0, 0, 1, 20253), -- 118680 +-- 93906 +(93906, 120945, 1, 0, 2483, 1, 20253), -- 120945 +(93906, 124885, 3, 0, 5307, 1, 20253), -- 124885 +(93906, 124886, 4, 0, 5307, 1, 20253), -- 124886 +(93906, 124887, 5, 0, 5307, 1, 20253), -- 124887 +(93906, 124888, 6, 0, 5307, 1, 20253), -- 124888 +(93906, 124889, 7, 0, 5307, 1, 20253), -- 124889 +(93906, 124890, 8, 0, 5311, 1, 20253), -- 124890 +(93906, 124891, 9, 0, 5311, 1, 20253), -- 124891 +(93906, 124892, 10, 0, 5311, 1, 20253), -- 124892 +(93906, 124893, 11, 0, 5311, 1, 20253), -- 124893 +(93906, 124894, 12, 0, 5311, 1, 20253), -- 124894 +(93906, 124928, 13, 0, 5309, 1, 20253), -- 124928 +(93906, 124929, 14, 0, 5309, 1, 20253), -- 124929 +(93906, 124930, 15, 0, 5309, 1, 20253), -- 124930 +(93906, 124931, 16, 0, 5309, 1, 20253), -- 124931 +(93906, 124932, 17, 0, 5309, 1, 20253), -- 124932 +(93906, 124933, 18, 0, 5311, 1, 20253), -- 124933 +(93906, 124934, 19, 0, 5311, 1, 20253), -- 124934 +(93906, 125015, 20, 0, 5307, 1, 20253), -- 125015 +(93906, 125016, 21, 0, 5307, 1, 20253), -- 125016 +(93906, 125017, 22, 0, 5307, 1, 20253), -- 125017 +(93906, 125018, 23, 0, 5307, 1, 20253), -- 125018 +(93906, 125019, 24, 0, 5311, 1, 20253), -- 125019 +(93906, 125020, 25, 0, 5311, 1, 20253), -- 125020 +(93906, 125021, 26, 0, 5311, 1, 20253), -- 125021 +(93906, 124943, 27, 0, 5305, 1, 20253), -- 124943 +(93906, 124944, 28, 0, 5305, 1, 20253), -- 124944 +(93906, 124950, 29, 0, 5305, 1, 20253), -- 124950 +(93906, 124951, 30, 0, 5305, 1, 20253), -- 124951 +(93906, 125029, 31, 0, 5304, 1, 20253), -- 125029 +(93906, 127381, 32, 0, 5307, 1, 20253), -- 127381 +(93906, 125000, 38, 0, 5308, 1, 20253), -- 125000 +(93906, 125001, 39, 0, 5310, 1, 20253), -- 125001 +(93906, 125002, 40, 0, 5310, 1, 20253), -- 125002 +(93906, 125003, 41, 0, 5310, 1, 20253), -- 125003 +(93906, 125004, 42, 0, 5308, 1, 20253), -- 125004 +(93906, 124902, 48, 0, 5308, 1, 20253), -- 124902 +(93906, 124903, 49, 0, 5308, 1, 20253), -- 124903 +(93906, 124904, 50, 0, 5308, 1, 20253), -- 124904 +(93906, 124905, 51, 0, 5308, 1, 20253), -- 124905 +(93906, 124906, 52, 0, 5306, 1, 20253), -- 124906 +(93906, 124907, 53, 0, 5306, 1, 20253), -- 124907 +(93906, 124952, 69, 0, 5308, 1, 20253), -- 124952 +(93906, 124953, 70, 0, 5308, 1, 20253), -- 124953 +(93906, 124954, 71, 0, 5308, 1, 20253), -- 124954 +(93906, 124955, 72, 0, 5308, 1, 20253), -- 124955 +(93906, 124956, 73, 0, 5306, 1, 20253), -- 124956 +(93906, 124957, 74, 0, 5306, 1, 20253), -- 124957 +(93906, 124968, 85, 0, 5308, 1, 20253), -- 124968 +(93906, 124969, 86, 0, 5308, 1, 20253), -- 124969 +(93906, 124970, 87, 0, 5308, 1, 20253), -- 124970 +(93906, 124971, 88, 0, 5308, 1, 20253), -- 124971 +(93906, 124972, 89, 0, 5306, 1, 20253), -- 124972 +(93906, 124973, 90, 0, 5306, 1, 20253), -- 124973 +(93906, 124989, 106, 0, 5308, 1, 20253), -- 124989 +(93906, 124990, 107, 0, 5308, 1, 20253), -- 124990 +(93906, 124991, 108, 0, 5308, 1, 20253), -- 124991 +(93906, 124992, 109, 0, 5308, 1, 20253), -- 124992 +(93906, 124993, 110, 0, 5306, 1, 20253), -- 124993 +(93906, 124994, 111, 0, 5306, 1, 20253), -- 124994 +(93906, 124899, 112, 0, 5306, 1, 20253), -- 124899 +(93906, 124900, 113, 0, 5306, 1, 20253), -- 124900 +(93906, 124901, 114, 0, 5306, 1, 20253), -- 124901 +(93906, 124945, 115, 0, 5306, 1, 20253), -- 124945 +(93906, 124946, 116, 0, 5306, 1, 20253), -- 124946 +(93906, 124947, 117, 0, 5306, 1, 20253), -- 124947 +(93906, 124948, 118, 0, 5306, 1, 20253), -- 124948 +(93906, 124949, 119, 0, 5306, 1, 20253), -- 124949 +(93906, 125026, 120, 0, 5306, 1, 20253), -- 125026 +(93906, 125027, 121, 0, 5306, 1, 20253), -- 125027 +(93906, 125028, 122, 0, 5306, 1, 20253), -- 125028 +(93906, 125051, 123, 0, 5306, 1, 20253), -- 125051 +(93906, 125052, 124, 0, 5306, 1, 20253), -- 125052 +(93906, 124897, 125, 0, 5306, 1, 20253), -- 124897 +(93906, 124898, 126, 0, 5306, 1, 20253), -- 124898 +(93906, 124939, 127, 0, 5306, 1, 20253), -- 124939 +(93906, 124940, 128, 0, 5306, 1, 20253), -- 124940 +(93906, 124941, 129, 0, 5306, 1, 20253), -- 124941 +(93906, 124942, 130, 0, 5306, 1, 20253), -- 124942 +(93906, 125024, 131, 0, 5306, 1, 20253), -- 125024 +(93906, 125025, 132, 0, 5306, 1, 20253), -- 125025 +(93906, 125050, 133, 0, 5306, 1, 20253), -- 125050 +(93906, 124895, 134, 0, 5306, 1, 20253), -- 124895 +(93906, 124896, 135, 0, 5306, 1, 20253), -- 124896 +(93906, 124935, 136, 0, 5306, 1, 20253), -- 124935 +(93906, 124936, 137, 0, 5306, 1, 20253), -- 124936 +(93906, 124937, 138, 0, 5306, 1, 20253), -- 124937 +(93906, 124938, 139, 0, 5306, 1, 20253), -- 124938 +(93906, 125022, 140, 0, 5306, 1, 20253), -- 125022 +(93906, 125023, 141, 0, 5306, 1, 20253), -- 125023 +(93906, 125049, 142, 0, 5306, 1, 20253), -- 125049 +(93906, 125037, 143, 0, 5308, 1, 20253), -- 125037 +(93906, 125038, 144, 0, 5308, 1, 20253), -- 125038 +(93906, 125040, 145, 0, 5308, 1, 20253), -- 125040 +(93906, 125041, 146, 0, 5308, 1, 20253), -- 125041 +(93906, 125043, 147, 0, 5308, 1, 20253), -- 125043 +(93906, 125030, 148, 0, 5308, 1, 20253), -- 125030 +(93906, 125035, 149, 0, 5308, 1, 20253), -- 125035 +(93906, 125036, 150, 0, 5308, 1, 20253), -- 125036 +(93906, 125031, 151, 0, 5308, 1, 20253), -- 125031 +(93906, 125034, 152, 0, 5308, 1, 20253), -- 125034 +(93906, 125039, 153, 0, 5308, 1, 20253), -- 125039 +(93906, 125042, 154, 0, 5308, 1, 20253), -- 125042 +(93906, 125032, 155, 0, 5308, 1, 20253), -- 125032 +(93906, 125033, 156, 0, 5308, 1, 20253), -- 125033 +-- 93907 +(93907, 124675, 2, 0, 5273, 1, 20253), -- 124675 +(93907, 124676, 3, 0, 5273, 1, 20253), -- 124676 +(93907, 124677, 4, 0, 5273, 1, 20253), -- 124677 +(93907, 124678, 5, 0, 5273, 1, 20253), -- 124678 +(93907, 124679, 6, 0, 5273, 1, 20253), -- 124679 +(93907, 124680, 7, 0, 5278, 1, 20253), -- 124680 +(93907, 124681, 8, 0, 5278, 1, 20253), -- 124681 +(93907, 124682, 9, 0, 5278, 1, 20253), -- 124682 +(93907, 124683, 10, 0, 5278, 1, 20253), -- 124683 +(93907, 124684, 11, 0, 5278, 1, 20253), -- 124684 +(93907, 124726, 12, 0, 5276, 1, 20253), -- 124726 +(93907, 124727, 13, 0, 5276, 1, 20253), -- 124727 +(93907, 124728, 14, 0, 5276, 1, 20253), -- 124728 +(93907, 124729, 15, 0, 5276, 1, 20253), -- 124729 +(93907, 124730, 16, 0, 5276, 1, 20253), -- 124730 +(93907, 124731, 17, 0, 5278, 1, 20253), -- 124731 +(93907, 124732, 18, 0, 5278, 1, 20253), -- 124732 +(93907, 124837, 19, 0, 5273, 1, 20253), -- 124837 +(93907, 124838, 20, 0, 5273, 1, 20253), -- 124838 +(93907, 124839, 21, 0, 5273, 1, 20253), -- 124839 +(93907, 124840, 22, 0, 5273, 1, 20253), -- 124840 +(93907, 124841, 23, 0, 5278, 1, 20253), -- 124841 +(93907, 124842, 24, 0, 5278, 1, 20253), -- 124842 +(93907, 124843, 25, 0, 5278, 1, 20253), -- 124843 +(93907, 124741, 26, 0, 5271, 1, 20253), -- 124741 +(93907, 124742, 27, 0, 5271, 1, 20253), -- 124742 +(93907, 124748, 28, 0, 5271, 1, 20253), -- 124748 +(93907, 124749, 29, 0, 5271, 1, 20253), -- 124749 +(93907, 124851, 30, 0, 5271, 1, 20253), -- 124851 +(93907, 124822, 36, 0, 5274, 1, 20253), -- 124822 +(93907, 124823, 37, 0, 5277, 1, 20253), -- 124823 +(93907, 124824, 38, 0, 5277, 1, 20253), -- 124824 +(93907, 124825, 39, 0, 5277, 1, 20253), -- 124825 +(93907, 124826, 40, 0, 5274, 1, 20253), -- 124826 +(93907, 124692, 46, 0, 5274, 1, 20253), -- 124692 +(93907, 124693, 47, 0, 5274, 1, 20253), -- 124693 +(93907, 124694, 48, 0, 5274, 1, 20253), -- 124694 +(93907, 124695, 49, 0, 5274, 1, 20253), -- 124695 +(93907, 124696, 50, 0, 5274, 1, 20253), -- 124696 +(93907, 124697, 51, 0, 5274, 1, 20253), -- 124697 +(93907, 124698, 52, 0, 5272, 1, 20253), -- 124698 +(93907, 124699, 53, 0, 5272, 1, 20253), -- 124699 +(93907, 124700, 54, 0, 5272, 1, 20253), -- 124700 +(93907, 124750, 70, 0, 5274, 1, 20253), -- 124750 +(93907, 124751, 71, 0, 5274, 1, 20253), -- 124751 +(93907, 124752, 72, 0, 5274, 1, 20253), -- 124752 +(93907, 124753, 73, 0, 5274, 1, 20253), -- 124753 +(93907, 124754, 74, 0, 5274, 1, 20253), -- 124754 +(93907, 124755, 75, 0, 5274, 1, 20253), -- 124755 +(93907, 124756, 76, 0, 5272, 1, 20253), -- 124756 +(93907, 124757, 77, 0, 5272, 1, 20253), -- 124757 +(93907, 124758, 78, 0, 5272, 1, 20253), -- 124758 +(93907, 124774, 89, 0, 5274, 1, 20253), -- 124774 +(93907, 124775, 90, 0, 5274, 1, 20253), -- 124775 +(93907, 124776, 91, 0, 5274, 1, 20253), -- 124776 +(93907, 124777, 92, 0, 5274, 1, 20253), -- 124777 +(93907, 124778, 93, 0, 5274, 1, 20253), -- 124778 +(93907, 124779, 94, 0, 5274, 1, 20253), -- 124779 +(93907, 124780, 95, 0, 5272, 1, 20253), -- 124780 +(93907, 124781, 96, 0, 5272, 1, 20253), -- 124781 +(93907, 124782, 97, 0, 5272, 1, 20253), -- 124782 +(93907, 124803, 113, 0, 5274, 1, 20253), -- 124803 +(93907, 124804, 114, 0, 5274, 1, 20253), -- 124804 +(93907, 124805, 115, 0, 5274, 1, 20253), -- 124805 +(93907, 124806, 116, 0, 5274, 1, 20253), -- 124806 +(93907, 124807, 117, 0, 5274, 1, 20253), -- 124807 +(93907, 124808, 118, 0, 5274, 1, 20253), -- 124808 +(93907, 124809, 119, 0, 5272, 1, 20253), -- 124809 +(93907, 124810, 120, 0, 5272, 1, 20253), -- 124810 +(93907, 124811, 121, 0, 5272, 1, 20253), -- 124811 +(93907, 124689, 122, 0, 5272, 1, 20253), -- 124689 +(93907, 124690, 123, 0, 5272, 1, 20253), -- 124690 +(93907, 124691, 124, 0, 5272, 1, 20253), -- 124691 +(93907, 124743, 125, 0, 5272, 1, 20253), -- 124743 +(93907, 124744, 126, 0, 5272, 1, 20253), -- 124744 +(93907, 124745, 127, 0, 5272, 1, 20253), -- 124745 +(93907, 124746, 128, 0, 5272, 1, 20253), -- 124746 +(93907, 124747, 129, 0, 5272, 1, 20253), -- 124747 +(93907, 124848, 130, 0, 5272, 1, 20253), -- 124848 +(93907, 124849, 131, 0, 5272, 1, 20253), -- 124849 +(93907, 124850, 132, 0, 5272, 1, 20253), -- 124850 +(93907, 124854, 133, 0, 5272, 1, 20253), -- 124854 +(93907, 124855, 134, 0, 5272, 1, 20253), -- 124855 +(93907, 124687, 135, 0, 5272, 1, 20253), -- 124687 +(93907, 124688, 136, 0, 5272, 1, 20253), -- 124688 +(93907, 124737, 137, 0, 5272, 1, 20253), -- 124737 +(93907, 124738, 138, 0, 5272, 1, 20253), -- 124738 +(93907, 124739, 139, 0, 5272, 1, 20253), -- 124739 +(93907, 124740, 140, 0, 5272, 1, 20253), -- 124740 +(93907, 124846, 141, 0, 5272, 1, 20253), -- 124846 +(93907, 124847, 142, 0, 5272, 1, 20253), -- 124847 +(93907, 124853, 143, 0, 5272, 1, 20253), -- 124853 +(93907, 124685, 144, 0, 5272, 1, 20253), -- 124685 +(93907, 124686, 145, 0, 5272, 1, 20253), -- 124686 +(93907, 124733, 146, 0, 5272, 1, 20253), -- 124733 +(93907, 124734, 147, 0, 5272, 1, 20253), -- 124734 +(93907, 124735, 148, 0, 5272, 1, 20253), -- 124735 +(93907, 124736, 149, 0, 5272, 1, 20253), -- 124736 +(93907, 124844, 150, 0, 5272, 1, 20253), -- 124844 +(93907, 124845, 151, 0, 5272, 1, 20253), -- 124845 +(93907, 124852, 152, 0, 5272, 1, 20253), -- 124852 +(93907, 124856, 153, 0, 5274, 1, 20253), -- 124856 +(93907, 124857, 154, 0, 5274, 1, 20253), -- 124857 +(93907, 124858, 155, 0, 5274, 1, 20253), -- 124858 +(93907, 124859, 156, 0, 5274, 1, 20253), -- 124859 +(93907, 124860, 157, 0, 5274, 1, 20253), -- 124860 +(93907, 124861, 158, 0, 5274, 1, 20253), -- 124861 +(93907, 124862, 159, 0, 5274, 1, 20253), -- 124862 +(93907, 124863, 160, 0, 5274, 1, 20253), -- 124863 +(93907, 124865, 161, 0, 5274, 1, 20253), -- 124865 +(93907, 124866, 162, 0, 5274, 1, 20253), -- 124866 +(93907, 124867, 163, 0, 5274, 1, 20253), -- 124867 +(93907, 124868, 164, 0, 5274, 1, 20253), -- 124868 +(93907, 124869, 165, 0, 5274, 1, 20253), -- 124869 +(93907, 127123, 166, 0, 5274, 1, 20253), -- 127123 +-- 92501 +(92501, 115378, 1, 0, 5340, 1, 20253), -- 115378 +(92501, 115379, 2, 0, 5340, 1, 20253), -- 115379 +(92501, 115380, 3, 0, 5340, 1, 20253), -- 115380 +(92501, 115381, 4, 0, 5340, 1, 20253), -- 115381 +(92501, 116935, 5, 0, 5900, 1, 20253), -- 116935 +(92501, 116936, 6, 0, 5900, 1, 20253), -- 116936 +(92501, 116937, 7, 0, 5900, 1, 20253), -- 116937 +(92501, 116938, 8, 0, 5900, 1, 20253), -- 116938 +(92501, 116939, 9, 0, 5901, 1, 20253), -- 116939 +(92501, 116940, 10, 0, 5901, 1, 20253), -- 116940 +(92501, 116941, 11, 0, 5901, 1, 20253), -- 116941 +(92501, 116942, 12, 0, 5901, 1, 20253), -- 116942 +(92501, 122320, 13, 0, 5902, 1, 20253), -- 122320 +(92501, 122321, 14, 0, 5902, 1, 20253), -- 122321 +(92501, 122322, 15, 0, 5902, 1, 20253), -- 122322 +(92501, 122323, 16, 0, 5902, 1, 20253), -- 122323 +(92501, 116768, 17, 0, 5853, 1, 20253), -- 116768 +(92501, 119821, 18, 0, 5490, 1, 20253), -- 119821 +-- 88155 +(88155, 118401, 1, 0, 0, 1, 20253), -- 118401 +(88155, 118409, 2, 0, 0, 1, 20253), -- 118409 +(88155, 118403, 3, 0, 0, 1, 20253), -- 118403 +(88155, 118413, 4, 0, 0, 1, 20253), -- 118413 +(88155, 118402, 5, 0, 0, 1, 20253), -- 118402 +(88155, 118412, 6, 0, 0, 1, 20253), -- 118412 +(88155, 118411, 7, 0, 0, 1, 20253), -- 118411 +(88155, 118404, 8, 0, 0, 1, 20253), -- 118404 +(88155, 118396, 9, 0, 0, 1, 20253), -- 118396 +(88155, 118395, 10, 0, 0, 1, 20253), -- 118395 +(88155, 118408, 11, 0, 0, 1, 20253), -- 118408 +(88155, 118397, 12, 0, 0, 1, 20253), -- 118397 +(88155, 118405, 13, 0, 0, 1, 20253), -- 118405 +(88155, 118399, 14, 0, 0, 1, 20253), -- 118399 +(88155, 118398, 15, 0, 0, 1, 20253), -- 118398 +(88155, 118407, 16, 0, 0, 1, 20253), -- 118407 +(88155, 118406, 17, 0, 0, 1, 20253), -- 118406 +(88155, 118410, 18, 0, 0, 1, 20253), -- 118410 +-- 85946 +(85946, 116772, 1, 0, 5457, 1, 20253), -- 116772 +(85946, 118666, 2, 0, 5456, 1, 20253), -- 118666 +(85946, 119143, 3, 0, 5458, 1, 20253), -- 119143 +(85946, 118698, 4, 0, 0, 1, 20253), -- 118698 +(85946, 119136, 5, 0, 0, 1, 20253), -- 119136 +(85946, 118682, 6, 0, 0, 1, 20253), -- 118682 +-- 85950 +(85950, 117452, 1, 0, 0, 1, 20253), -- 117452 +(85950, 115351, 2, 0, 0, 1, 20253), -- 115351 +(85950, 39354, 3, 0, 0, 1, 20253), -- 39354 +(85950, 3371, 4, 0, 0, 1, 20253), -- 3371 +(85950, 38682, 5, 0, 0, 1, 20253), -- 38682 +(85950, 4470, 6, 0, 0, 1, 20253), -- 4470 +(85950, 79249, 7, 0, 0, 1, 20253), -- 79249 +(85950, 90146, 8, 0, 0, 1, 20253), -- 90146 +(85950, 117445, 9, 0, 0, 1, 20253), -- 117445 +(85950, 2901, 10, 0, 0, 1, 20253), -- 2901 +(85950, 7005, 11, 0, 0, 1, 20253), -- 7005 +(85950, 85663, 12, 0, 0, 1, 20253), -- 85663 +(85950, 6256, 13, 0, 0, 1, 20253), -- 6256 +(85950, 6217, 14, 0, 0, 1, 20253), -- 6217 +(85950, 5956, 15, 0, 0, 1, 20253), -- 5956 +(85950, 20815, 16, 0, 0, 1, 20253), -- 20815 +(85950, 39505, 17, 0, 0, 1, 20253), -- 39505 +-- 88230 +(88230, 2901, 1, 0, 0, 1, 20253), -- 2901 +(88230, 5956, 2, 0, 0, 1, 20253), -- 5956 +(88230, 2880, 3, 0, 0, 1, 20253), -- 2880 +(88230, 3466, 4, 0, 0, 1, 20253), -- 3466 +(88230, 18567, 5, 0, 0, 1, 20253), -- 18567 +(88230, 3857, 6, 0, 0, 1, 20253), -- 3857 +-- 85955 +(85955, 64670, 1, 0, 0, 1, 20253), -- 64670 +(85955, 63388, 2, 0, 0, 1, 20253), -- 63388 +(85955, 79249, 3, 0, 0, 1, 20253), -- 79249 +-- 88235 +(88235, 117441, 1, 0, 0, 1, 20253), -- 117441 +(88235, 117437, 2, 0, 0, 1, 20253), -- 117437 +(88235, 117453, 3, 0, 0, 1, 20253), -- 117453 +(88235, 117568, 4, 0, 0, 1, 20253), -- 117568 +(88235, 117440, 5, 0, 0, 1, 20253), -- 117440 +(88235, 117442, 6, 0, 0, 1, 20253), -- 117442 +(88235, 117439, 7, 0, 0, 1, 20253), -- 117439 +(88235, 119022, 8, 0, 0, 1, 20253), -- 119022 +(88235, 119324, 9, 0, 0, 1, 20253), -- 119324 +(88235, 120959, 10, 0, 0, 1, 20253), -- 120959 +-- 87365 +(87365, 122606, 1, 0, 3900, 1, 20253), -- 122606 +(87365, 87533, 2, 0, 3890, 1, 20253), -- 87533 +(87365, 87534, 3, 0, 3890, 1, 20253), -- 87534 +(87365, 87535, 4, 0, 3890, 1, 20253), -- 87535 +(87365, 87536, 5, 0, 3890, 1, 20253), -- 87536 +(87365, 87537, 6, 0, 3890, 1, 20253), -- 87537 +(87365, 87538, 7, 0, 3890, 1, 20253), -- 87538 +(87365, 87539, 8, 0, 3890, 1, 20253), -- 87539 +(87365, 87540, 9, 0, 3890, 1, 20253), -- 87540 +(87365, 87541, 10, 0, 3890, 1, 20253), -- 87541 +(87365, 117386, 11, 0, 3890, 1, 20253), -- 117386 +(87365, 117387, 12, 0, 3890, 1, 20253), -- 117387 +(87365, 117388, 13, 0, 3890, 1, 20253), -- 117388 +(87365, 117390, 14, 0, 3890, 1, 20253), -- 117390 +(87365, 117389, 15, 0, 3890, 1, 20253), -- 117389 +(87365, 118728, 16, 0, 0, 1, 20253), -- 118728 +(87365, 118729, 17, 0, 0, 1, 20253), -- 118729 +(87365, 118730, 18, 0, 0, 1, 20253), -- 118730 +(87365, 118731, 19, 0, 0, 1, 20253), -- 118731 +(87365, 118732, 20, 0, 0, 1, 20253); -- 118732 + +-- Pathing - Stormshield +-- 1. Stormshield Officer +SET @NPC := 371281; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3610.942,`position_y`=-3935.089,`position_z`=16.77913 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,28917,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3610.942,-3935.089,16.77913,0,0,0,0,100,0), +(@PATH,2,3622.692,-3940.839,17.27913,0,0,0,0,100,0), +(@PATH,3,3634.192,-3937.089,18.02913,0,0,0,0,100,0), +(@PATH,4,3640.942,-3930.339,17.77913,0,0,0,0,100,0), +(@PATH,5,3651.442,-3922.839,17.77913,0,0,0,0,100,0), +(@PATH,6,3657.442,-3928.839,18.77913,0,0,0,0,100,0), +(@PATH,7,3668.692,-3942.839,23.02913,0,0,0,0,100,0), +(@PATH,8,3677.692,-3949.339,25.77913,0,0,0,0,100,0), +(@PATH,9,3689.942,-3950.339,27.27913,0,0,0,0,100,0), +(@PATH,16,3622.692,-3940.839,17.27913,0,0,0,0,100,0), +(@PATH,15,3634.192,-3937.089,18.02913,0,0,0,0,100,0), +(@PATH,14,3640.942,-3930.339,17.77913,0,0,0,0,100,0), +(@PATH,13,3651.442,-3922.839,17.77913,0,0,0,0,100,0), +(@PATH,12,3657.442,-3928.839,18.77913,0,0,0,0,100,0), +(@PATH,11,3668.692,-3942.839,23.02913,0,0,0,0,100,0), +(@PATH,10,3677.692,-3949.339,25.77913,0,0,0,0,100,0); + +-- trainer dummies +UPDATE `creature_template` SET `unit_flags`=131072, `type_flags`=4, `mechanic_immune_mask`=32, `flags_extra`=262144, `ScriptName`='npc_training_dummy' WHERE `entry` IN(87322, 87318, 87320, 87318, 87329); |