[NPC] V13.1 - Hearthglen Fix

TreeOfLife

Gold Supporter
Veteran Member
35
2020
19
Location
Netherlands
Hearthglen, a settlement in Western Plaguelands, had a lot of stationairy and uncomfortably placed guards. I setup multiple paths for many of the guards to follow as well as moved some of them so as to make them seem busy.

SQL:
#Set new creature spawns according to their waypoints.
REPLACE INTO emucoach_v131_vip_world.creature (guid, id,`map`,`zone`,area,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags,walkmode,saiscriptflag) values
  (15545,44438,0,28,28,1,15,0,0,2299.19,-1881.09,89.556,0.260593,120,0.0,0,3540,1236,2,0,0,0,0.0,0.0),
  (41413,44438,0,28,28,1,15,0,0,2436.46,-1935.34,106.696,3.39938,120,0.0,0,1,0,2,0,0,0,0.0,0.0),
  (15310,44438,0,28,28,1,15,0,0,2698.29,-1721.93,119.77,4.16972,120,0.0,0,3540,1236,2,0,0,0,0.0,0.0),
  (41327,44438,0,28,28,1,15,0,0,2768.29,-1626.17,127.791,0.906186,120,0.0,0,1,0,2,0,0,0,0.0,0.0),
  (41255,44438,0,28,190,1,15,0,0,2760.1,-1577.81,130.448,1.9992,120,0.0,0,1,0,2,0,0,0,0.0,0.0),
  (41287,44438,0,28,190,1,15,0,0,2831.58,-1616.86,133.403,3.64766,120,0.0,0,1,0,2,0,0,0,0.0,0.0),
  (15510,44438,0,28,190,1,15,33893,0,2937.46,-1557.49,145.95,0.825069,120,0.0,0,3678,1283,2,0,0,0,0.0,0.0),
  (41237,44437,0,28,190,1,15,0,41237,2947.79,-1480.59,146.325,1.6928,90,0.0,0,1,2,2,0,0,0,0.0,0.0),
  (41234,44437,0,28,190,1,15,0,0,2916.05,-1478.63,146.226,4.95426,120,0.0,0,1,0,2,0,0,0,0.0,0.0),
  (15381,44438,0,28,190,1,15,33893,0,2849.06,-1455.28,146.083,0.82726,120,0.0,0,3678,1283,2,0,0,0,0.0,0.0),
  (15612,44438,0,28,190,1,15,33892,0,2791.79,-1493.52,146.196,4.73976,120,0.0,0,3540,1236,2,0,0,0,0.0,0.0),
  (15611,44440,0,28,203,1,15,33899,0,2912.51,-1399.52,152.02,5.80388,90,0.0,0,232470,8908,2,0,0,0,0.0,0.0),
  (15412,44440,0,28,203,1,15,33899,0,2952.28,-1420.83,152.02,1.11904,90,0.0,0,232470,8908,2,0,0,0,0.0,0.0),
  (41239,44440,0,28,203,1,15,0,0,2948.41,-1418.42,165.943,4.21581,90,0.0,0,1,0,2,0,0,0,0.0,0.0),
  (15621,44440,0,28,203,1,15,33899,0,2916.16,-1402.26,165.944,4.23874,90,0.0,0,232470,8908,2,0,0,0,0.0,0.0),
  (41243,44441,0,28,203,1,15,0,0,2944.32,-1388.8,167.237,5.82404,120,0.0,0,1,0,2,0,0,0,0.0,0.0),
  (41245,44440,0,28,203,1,15,0,0,2927.21,-1372.33,176.046,1.12551,90,0.0,0,1,0,2,0,0,0,0.0,0.0),
  (15432,44440,0,28,203,1,15,33898,0,2918.25,-1390.16,176.099,1.10137,90,0.0,0,232470,8908,2,0,0,0,0.0,0.0),
  (41244,44440,0,28,203,1,15,0,0,2965.91,-1392.92,176.046,1.04572,90,0.0,0,1,0,2,0,0,0,0.0,0.0),
  (15550,44440,0,28,203,1,15,33898,0,2948.39,-1426.88,176.046,4.22921,90,0.0,0,232470,8908,2,0,0,0,0.0,0.0);

#Moves creatures.
REPLACE INTO emucoach_v131_vip_world.creature (guid, id,`map`,`zone`,area,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags,walkmode,saiscriptflag) VALUES
  (41230,44438,0,28,190,1,15,0,0,2890.73,-1429.83,147.548,4.33191,120,0.0,0,1,0,0,0,0,0,0.0,0.0),
  (41227,44437,0,28,190,1,15,0,44437,2816.52,-1407.06,147.548,5.98437,90,0.0,0,1,0,0,0,0,0,0.0,0.0),
  (15535,44437,0,28,190,1,15,33889,44437,2781.75,-1430.45,146.146,2.78334,90,0.0,0,1180,1236,0,0,0,0,0.0,0.0),
  (41225,44437,0,28,190,1,15,0,44437,2786.51,-1448.45,146.055,0.453066,90,0.0,0,1,0,0,0,0,0,0.0,0.0),
  (15609,44438,0,28,190,1,15,33893,0,2911.29,-1426.17,149.348,3.50215,120,0.0,0,3540,1236,0,0,0,0,0.0,0.0),
  (41238,44440,0,28,203,1,15,0,0,2936.61,-1402.32,150.52,4.26896,90,0.0,0,1,0,0,0,0,0,0.0,0.0),
  (41240,44440,0,28,203,1,15,0,0,2948.87,-1434.46,152.02,5.14912,90,0.0,0,1,0,0,0,0,0,0.0,0.0),
  (41242,44440,0,28,203,1,15,0,0,2941.90,-1387.42,152.02,4.24063,90,0.0,0,1,0,0,0,0,0,0.0,0.0),
  (15311,44440,0,28,203,1,15,33899,0,2938.89,-1395.84,160.842,1.15401,90,0.0,0,232470,8908,0,0,0,0,0.0,0.0),
  (15416,44440,0,28,203,1,15,33898,0,2944.43,-1408.28,165.944,2.73768,90,0.0,0,232470,8908,0,0,0,0,0.0,0.0),
  (41236,44440,0,28,203,1,15,0,0,2926.78,-1399.51,165.943,5.57533,90,0.0,0,1,0,0,0,0,0,0.0,0.0);

#Link new waypoints to the creatures.
INSERT INTO emucoach_v131_vip_world.creature_addon (guid,path_id,mount,bytes1,bytes2,emote,auras,VisibilityDistanceType) VALUES
  (15545,155450,0,0,1,0,NULL,-1),
  (41413,414130,0,0,1,0,NULL,-1),
  (15310,153100,0,0,1,0,NULL,-1),
  (41327,413270,0,0,1,0,NULL,-1),
  (41255,412550,0,0,1,0,NULL,-1),
  (41287,412870,0,0,1,0,NULL,-1),
  (15510,155100,0,0,1,0,NULL,-1),
  (41237,412370,0,0,1,0,NULL,-1),
  (41234,412340,0,0,1,0,NULL,-1),
  (15381,153810,0,0,1,0,NULL,-1),
  (15612,156120,0,0,1,0,NULL,-1),
  (15611,156110,0,0,1,0,NULL,-1),
  (15412,154120,0,0,1,0,NULL,-1),
  (41239,412390,0,0,1,0,NULL,-1),
  (15621,156210,0,0,1,0,NULL,-1),
  (41243,412430,0,0,0,0,NULL,-1),
  (41245,412450,0,0,1,0,NULL,-1),
  (15432,154320,0,0,1,0,NULL,-1),
  (41244,412440,0,0,1,0,NULL,-1),
  (15550,155500,0,0,1,0,NULL,-1),

#Assign emotes.
  (15535,0,0,0,0,68,NULL,-1),
  (41225,0,0,0,0,69,NULL,-1),
  (41240,0,0,0,0,69,NULL,-1);

#Insert waypoint data.
INSERT INTO emucoach_v131_vip_world.waypoint_data (id,`point`,position_x,position_y,position_z,orientation,delay,move_type,`action`,action_chance,inverse_formation_angle,wpguid) VALUES
  (155450,18,2306.95,-1883.94,90.7326,0,0,0,0,100,0,9997180),
  (155450,17,2318.11,-1892.4,91.8786,0,0,0,0,100,0,9997181),
  (155450,16,2326.47,-1898.75,94.0608,0,0,0,0,100,0,9997182),
  (155450,15,2337.63,-1907.21,97.3531,0,0,0,0,100,0,9997183),
  (155450,14,2346.67,-1914.62,100.388,0,0,0,0,100,0,9997184),
  (155450,13,2358.17,-1923.06,104.049,0,0,0,0,100,0,9997185),
  (155450,12,2372.75,-1928.05,106.407,0,0,0,0,100,0,9997186),
  (155450,11,2387.82,-1931.76,107.163,0,0,0,0,100,0,9997187),
  (155450,10,2394.91,-1933.42,107.47,0,0,0,0,100,0,9997188),
  (155450,9,2380.39,-1929.65,106.844,0,0,0,0,100,0,9997189),
  (155450,8,2367.5,-1926.34,105.794,0,0,0,0,100,0,9997190),
  (155450,7,2355.37,-1921.17,103.188,0,0,0,0,100,0,9997191),
  (155450,6,2344.32,-1912.58,99.5482,0,0,0,0,100,0,9997192),
  (155450,5,2336.03,-1906.14,96.85,0,0,0,0,100,0,9997193),
  (155450,4,2325.02,-1897.49,93.6076,0,0,0,0,100,0,9997194),
  (155450,3,2314.03,-1888.82,91.2565,0,0,0,0,100,0,9997195),
  (155450,2,2303.05,-1880.15,90.0543,0,0,0,0,100,0,9997196),
  (155450,1,2295.68,-1874.31,88.3194,0,0,0,0,100,0,9997197),

  (414130,19,2489.67,-1938.93,99.2651,0,0,0,0,100,0,0),
    (414130,18,2514.44,-1934.77,95.6535,0,0,0,0,100,0,0),
    (414130,17,2537.38,-1937.27,92.4763,0,0,0,0,100,0,0),
    (414130,16,2555.26,-1930.79,87.8047,0,0,0,0,100,0,0),
    (414130,15,2579.37,-1926.09,83.1371,0,0,0,0,100,0,0),
    (414130,14,2600.18,-1923.3,77.8327,0,0,0,0,100,0,0),
    (414130,13,2622.11,-1920.14,73.9413,0,0,0,0,100,0,0),
    (414130,12,2640.66,-1916.56,71.3422,0,0,0,0,100,0,0),
    (414130,11,2652.81,-1908.71,69.5829,0,0,0,0,100,0,0),
    (414130,10,2632.29,-1916.34,72.4035,0,0,0,0,100,0,0),
    (414130,9,2618.14,-1918.62,74.2563,0,0,0,0,100,0,0),
    (414130,8,2599.49,-1922.54,78.0152,0,0,0,0,100,0,0),
    (414130,7,2577.86,-1924.16,83.2639,0,0,0,0,100,0,0),
    (414130,6,2555.76,-1928.23,87.5065,0,0,0,0,100,0,0),
    (414130,5,2529.79,-1937.38,94.0102,0,0,0,0,100,0,0),
    (414130,4,2505.0,-1936.88,97.0089,0,0,0,0,100,0,0),
    (414130,3,2470.72,-1939.16,101.046,0,0,0,0,100,0,0),
    (414130,2,2454.56,-1938.43,104.611,0,0,0,0,100,0,0),
    (414130,1,2432.78,-1934.71,107.024,0,0,0,0,100,0,0),
    (414130,20,2463.41,-1937.9,102.259,0,0,0,0,100,0,0),
    (414130,21,2443.57,-1936.45,105.98,0,0,0,0,100,0,0),

  (155450,1,2292.33,-1875.23,87.9221,0,0,0,0,100,0,0),
    (155450,2,2307.48,-1887.16,91.0679,0,0,0,0,100,0,0),
    (155450,3,2323.88,-1900.27,93.7422,0,0,0,0,100,0,0),
    (155450,4,2341.24,-1912.25,98.8184,0,0,0,0,100,0,0),
    (155450,5,2357.79,-1922.87,103.949,0,0,0,0,100,0,0),
    (155450,6,2372.55,-1927.61,106.346,0,0,0,0,100,0,0),
    (155450,7,2395.71,-1933.39,107.507,0,0,0,0,100,0,0),

    (153100,1,2694.28,-1729.08,117.656,0,0,0,0,100,0,0),
    (153100,2,2691.07,-1742.09,113.874,0,0,0,0,100,0,0),
    (153100,3,2690.92,-1752.99,110.451,0,0,0,0,100,0,0),
    (153100,4,2690.84,-1761.22,107.065,0,0,0,0,100,0,0),
    (153100,5,2691.02,-1769.33,103.899,0,0,0,0,100,0,0),
    (153100,6,2691.71,-1776.48,101.365,0,0,0,0,100,0,0),
    (153100,7,2692.26,-1782.75,98.9297,0,0,0,0,100,0,0),
    (153100,8,2692.95,-1789.89,95.4162,0,0,0,0,100,0,0),
    (153100,9,2693.63,-1796.8,91.7495,0,0,0,0,100,0,0),
    (153100,10,2694.09,-1801.03,89.4885,0,0,0,0,100,0,0),
    (153100,11,2695.41,-1807.96,86.1989,0,0,0,0,100,0,0),
    (153100,12,2697.95,-1814.79,83.3724,0,0,0,0,100,0,0),
    (153100,13,2700.72,-1822.15,79.7615,0,0,0,0,100,0,0),
    (153100,14,2700.72,-1831.82,75.3426,0,0,0,0,100,0,0),
    (153100,15,2699.62,-1839.97,72.7995,0,0,0,0,100,0,0),
    (153100,16,2697.96,-1850.03,70.1658,0,0,0,0,100,0,0),
    (153100,17,2695.05,-1860.6,67.3278,0,0,0,0,100,0,0),
    (153100,18,2690.43,-1871.17,66.775,0,0,0,0,100,0,0),
    (153100,19,2682.99,-1882.01,66.0515,0,0,0,0,100,0,0),
    (153100,20,2692.44,-1871.29,66.8373,0,0,0,0,100,0,0),
    (153100,21,2698.04,-1858.08,67.9788,0,0,0,0,100,0,0),
    (153100,22,2700.51,-1846.87,71.0991,0,0,0,0,100,0,0),
    (153100,23,2700.54,-1833.08,74.8213,0,0,0,0,100,0,0),
    (153100,24,2699.16,-1823.67,79.0197,0,0,0,0,100,0,0),
    (153100,25,2697.14,-1815.58,83.0631,0,0,0,0,100,0,0),
    (153100,26,2694.68,-1806.05,87.0861,0,0,0,0,100,0,0),
    (153100,27,2693.44,-1797.2,91.5505,0,0,0,0,100,0,0),
    (153100,28,2692.43,-1786.7,97.028,0,0,0,0,100,0,0),
    (153100,29,2691.52,-1779.12,100.359,0,0,0,0,100,0,0),
    (153100,30,2690.54,-1771.01,103.314,0,0,0,0,100,0,0),
    (153100,31,2690.04,-1760.3,107.354,0,0,0,0,100,0,0),
    (153100,32,2690.53,-1749.69,111.631,0,0,0,0,100,0,0),
    (153100,33,2691.49,-1739.25,114.704,0,0,0,0,100,0,0),
    (153100,34,2693.91,-1731.94,116.945,0,0,0,0,100,0,0),

  (413270,1,2742.1,-1655.79,126.323,0,0,0,0,100,0,0),
    (413270,2,2778.17,-1616.63,128.816,0,0,0,0,100,0,0),

    (412550,1,2760.36,-1581.32,129.798,0,0,0,0,100,0,9996811),
    (412550,2,2765.41,-1589.7,129.629,0,0,0,0,100,0,9996812),
    (412550,3,2772.29,-1600.87,129.366,0,0,0,0,100,0,9996813),
    (412550,4,2765.27,-1589.9,129.599,0,0,0,0,100,0,9996814),
    (412550,5,2760.87,-1577.69,130.51,0,0,0,0,100,0,9996815),
    (412550,6,2760.2,-1570.15,131.556,0,0,0,0,100,0,9996816),
    (412550,7,2763.03,-1562.15,133.88,0,0,0,0,100,0,9996817),
    (412550,8,2763.15,-1584.03,129.958,0,0,0,0,100,0,9996817),
    (412550,9,2770.44,-1552.18,136.561,0,0,0,0,100,0,9996818),
    (412550,10,2779.72,-1539.25,140.342,0,0,0,0,100,0,9996819),
    (412550,11,2770.66,-1550.28,137.033,0,0,0,0,100,0,9996820),
    (412550,12,2764.34,-1559.1,134.529,0,0,0,0,100,0,9996821),
    (412550,13,2759.79,-1567.54,132.048,0,0,0,0,100,0,9996822),

    (412870,1,2828.92,-1618.4,132.465,0,0,0,0,100,0,9996836),
    (412870,2,2821.5,-1622.9,131.265,0,0,0,0,100,0,9996837),
    (412870,3,2809.95,-1621.97,129.828,0,0,0,0,100,0,9996838),
    (412870,4,2800.55,-1619.68,129.645,0,0,0,0,100,0,9996839),
    (412870,5,2789.68,-1617.64,129.675,0,0,0,0,100,0,9996840),
    (412870,6,2799.41,-1619.2,129.683,0,0,0,0,100,0,9996841),
    (412870,7,2809.73,-1622.01,129.804,0,0,0,0,100,0,9996842),
    (412870,8,2817.83,-1622.52,130.779,0,0,0,0,100,0,9996843),
    (412870,9,2825.34,-1619.96,131.694,0,0,0,0,100,0,9996844),
    (412870,10,2835.01,-1614.13,134.839,0,0,0,0,100,0,9996845),
    (412870,11,2842.81,-1607.11,137.534,0,0,0,0,100,0,9996846),
    (412870,12,2850.62,-1599.57,140.052,0,0,0,0,100,0,9996847),
    (412870,13,2857.97,-1592.45,141.96,0,0,0,0,100,0,9996848),
    (412870,15,2850.52,-1599.16,140.065,0,0,0,0,100,0,9996849),
    (412870,17,2842.73,-1606.95,137.538,0,0,0,0,100,0,9996850),
    (412870,19,2836.1,-1613.02,135.188,0,0,0,0,100,0,9996851),
    (412870,14,2854.35,-1595.48,141.045,0,0,0,0,100,0,0),
    (412870,16,2847.26,-1602.52,139.239,0,0,0,0,100,0,0),
    (412870,18,2839.91,-1609.61,136.47,0,0,0,0,100,0,0),

  (155100,15,2936.03,-1559.07,145.882,0,0,0,0,100,0,0),
  (155100,14,2928.06,-1567.71,145.928,0,0,0,0,100,0,0),
  (155100,13,2918.38,-1577.74,146.104,0,0,0,0,100,0,0),
  (155100,12,2904.9,-1590.08,146.587,0,0,0,0,100,0,0),
  (155100,11,2888.77,-1592.09,145.711,0,0,0,0,100,0,0),
  (155100,10,2906.99,-1589.2,146.604,0,0,0,0,100,0,0),
    (155100,9,2918.85,-1576.35,146.062,0,0,0,0,100,0,0),
    (155100,8,2925.97,-1568.63,146.017,0,0,0,0,100,0,0),
    (155100,7,2935.42,-1558.31,145.847,0,0,0,0,100,0,0),
    (155100,6,2942.36,-1550.42,146.178,0,0,0,0,100,0,0),
    (155100,5,2945.79,-1546.51,146.419,0,0,0,0,100,0,0),
    (155100,4,2953.32,-1538.51,145.99,0,0,0,0,100,0,0),
    (155100,3,2945.34,-1549.28,146.353,0,0,0,0,100,0,0),
    (155100,2,2942.68,-1552.53,146.091,0,0,0,0,100,0,0),
    (155100,1,2939.51,-1556.34,145.988,0,0,0,0,100,0,0),
 
    (412370,1,2948.77,-1485.12,146.334,0,0,0,0,100,0,9996893),
    (412370,2,2949.32,-1492.9,146.3,0,0,0,0,100,0,9996894),
    (412370,3,2950.18,-1504.76,146.039,0,0,0,0,100,0,9996895),
    (412370,4,2950.67,-1515.97,146.06,0,0,0,0,100,0,9996896),
    (412370,5,2951.23,-1525.86,146.063,0,0,0,0,100,0,9996897),
    (412370,6,2951.5,-1516.23,146.021,0,0,0,0,100,0,9996898),
    (412370,7,2951.15,-1505.74,146.027,0,0,0,0,100,0,9996899),
    (412370,8,2950.73,-1499.3,146.188,0,0,0,0,100,0,9996900),
    (412370,9,2949.92,-1488.91,146.353,0,0,0,0,100,0,9996901),
    (412370,10,2950.93,-1481.24,146.165,0,0,0,0,100,0,9996902),
    (412370,11,2953.98,-1476.45,145.951,0,0,0,0,100,0,9996903),
    (412370,12,2959.04,-1471.72,145.82,0,0,0,0,100,0,9996904),
    (412370,13,2967.86,-1466.89,145.735,0,0,0,0,100,0,9996905),
    (412370,14,2960.06,-1469.79,145.668,0,0,0,0,100,0,9996906),
    (412370,15,2954.3,-1474.41,145.922,0,0,0,0,100,0,9996907),
    (412370,16,2948.87,-1477.94,146.357,0,0,0,0,100,0,9996908),
    (412370,17,2944.14,-1477.63,146.573,0,0,0,0,100,0,9996909),
    (412370,18,2938.93,-1475.87,146.751,0,0,0,0,100,0,9996910),
    (412370,19,2932.81,-1475.06,146.791,0,0,0,0,100,0,9996911),
    (412370,20,2926.78,-1475.81,146.555,0,0,0,0,100,0,9996912),
    (412370,21,2930.88,-1475.23,146.731,0,0,0,0,100,0,9996913),
    (412370,22,2935.74,-1475.1,146.798,0,0,0,0,100,0,9996914),
    (412370,23,2940.97,-1477.35,146.7,0,0,0,0,100,0,9996915),
    (412370,24,2946.05,-1481.07,146.376,0,0,0,0,100,0,9996916),

    (412340,1,2914.0,-1480.44,146.178,0,0,0,0,100,0,9996989),
    (412340,2,2907.41,-1486.35,146.243,0,0,0,0,100,0,9996990),
    (412340,3,2911.84,-1480.9,146.213,0,0,0,0,100,0,9996991),
    (412340,4,2914.16,-1472.76,146.155,0,0,0,0,100,0,9996992),
    (412340,5,2913.62,-1467.08,146.461,0,0,0,0,100,0,9996993),
    (412340,6,2912.06,-1460.87,147.339,0,0,0,0,100,0,9996994),
    (412340,7,2908.42,-1454.38,147.625,0,0,0,0,100,0,9996995),
    (412340,8,2903.03,-1449.34,146.902,0,0,0,0,100,0,9996996),
    (412340,9,2898.94,-1447.16,146.399,0,0,0,0,100,0,9996997),
    (412340,10,2894.09,-1445.55,146.102,0,0,0,0,100,0,9996998),
    (412340,11,2885.41,-1443.24,145.936,0,0,0,0,100,0,9996999),
    (412340,12,2878.97,-1442.32,145.876,0,0,0,0,100,0,9997000),
    (412340,13,2870.97,-1442.65,145.724,0,0,0,0,100,0,9997001),
    (412340,14,2871.58,-1442.81,145.74,0,0,0,0,100,0,9997002),
    (412340,15,2881.16,-1442.54,145.893,0,0,0,0,100,0,9997003),
    (412340,16,2887.37,-1443.33,145.988,0,0,0,0,100,0,9997004),
    (412340,17,2893.44,-1444.96,146.111,0,0,0,0,100,0,9997005),
    (412340,18,2898.85,-1446.92,146.388,0,0,0,0,100,0,9997006),
    (412340,19,2903.07,-1449.05,146.905,0,0,0,0,100,0,9997007),
    (412340,20,2907.45,-1452.82,147.471,0,0,0,0,100,0,9997008),
    (412340,21,2909.88,-1456.55,147.768,0,0,0,0,100,0,9997009),
    (412340,22,2911.65,-1460.9,147.328,0,0,0,0,100,0,9997010),
    (412340,23,2912.18,-1462.65,147.09,0,0,0,0,100,0,9997011),
    (412340,24,2913.74,-1469.0,146.287,0,0,0,0,100,0,9997012),

    (153810,1,2853.23,-1452.08,146.052,0,0,0,0,100,0,9997013),
    (153810,2,2857.85,-1448.4,145.958,0,0,0,0,100,0,9997014),
    (153810,3,2864.09,-1444.18,145.817,0,0,0,0,100,0,9997015),
    (153810,4,2859.62,-1447.34,145.919,0,0,0,0,100,0,9997016),
    (153810,5,2854.26,-1451.91,146.008,0,0,0,0,100,0,9997017),
    (153810,6,2848.07,-1457.78,146.013,0,0,0,0,100,0,9997018),
    (153810,7,2841.96,-1463.8,146.051,0,0,0,0,100,0,9997019),
    (153810,8,2836.0,-1469.84,146.426,0,0,0,0,100,0,9997020),
    (153810,9,2831.19,-1474.8,146.226,0,0,0,0,100,0,9997021),
    (153810,10,2826.05,-1480.74,146.045,0,0,0,0,100,0,9997022),
    (153810,11,2821.78,-1488.31,145.902,0,0,0,0,100,0,9997023),
    (153810,12,2818.71,-1492.25,145.865,0,0,0,0,100,0,9997024),
    (153810,13,2813.69,-1498.14,145.703,0,0,0,0,100,0,9997025),
    (153810,14,2807.54,-1504.5,145.109,0,0,0,0,100,0,9997026),
    (153810,15,2810.46,-1500.37,145.469,0,0,0,0,100,0,9997027),
    (153810,16,2815.76,-1494.16,145.9,0,0,0,0,100,0,9997028),
    (153810,17,2819.87,-1488.86,145.896,0,0,0,0,100,0,9997029),
    (153810,18,2826.24,-1480.95,146.047,0,0,0,0,100,0,9997030),
    (153810,19,2830.85,-1475.68,146.19,0,0,0,0,100,0,9997031),
    (153810,20,2835.46,-1470.41,146.432,0,0,0,0,100,0,9997032),
    (153810,21,2842.37,-1462.51,146.028,0,0,0,0,100,0,9997033),

    (156120,1,2791.77,-1496.23,145.878,0,0,0,0,100,0,9997034),
  (156120,2,2792.1,-1502.27,145.442,0,0,0,0,100,0,9997035),
     (156120,3,2791.98,-1510.26,145.062,0,0,0,0,100,0,9997036),
    (156120,4,2789.78,-1521.66,144.264,0,0,0,0,100,0,9997037),
    (156120,5,2789.08,-1522.73,144.079,0,0,0,0,100,0,9997038),
    (156120,6,2791.33,-1513.23,144.943,0,0,0,0,100,0,9997039),
    (156120,7,2791.88,-1505.79,145.205,0,0,0,0,100,0,9997040),
    (156120,8,2791.93,-1502.29,145.443,0,0,0,0,100,0,9997041),
    (156120,9,2792.36,-1491.87,146.255,0,0,0,0,100,0,9997042),
    (156120,10,2793.34,-1485.52,146.495,0,0,0,0,100,0,9997043),
    (156120,11,2795.52,-1477.61,146.632,0,0,0,0,100,0,9997044),
    (156120,12,2795.19,-1478.67,146.628,0,0,0,0,100,0,9997045),
    (156120,13,2793.65,-1485.38,146.52,0,0,0,0,100,0,9997046),

  (156110,2,2922.35,-1381.56,152.02,0,0,0,0,100,0,0),
    (156110,1,2912.51,-1399.52,152.02,0,0,0,0,100,0,0),

    (154120,2,2961.89,-1402.18,152.02,0,0,0,0,100,0,0),
    (154120,1,2952.28,-1420.83,152.02,0,0,0,0,100,0,0),

  (412390,2,2960.06,-1396.56,160.842,0,0,0,0,100,0,0),
    (412390,1,2948.41,-1418.42,165.943,0,0,0,0,100,0,0),

  (156210,2,2927.58,-1379.86,160.842,0,0,0,0,100,0,0),
    (156210,1,2916.16,-1402.26,165.944,0,0,0,0,100,0,0),

  (412430,2,2947.01,-1390.01,167.238,0,5000,0,0,100,0,0),
  (412430,1,2940.24,-1386.83,167.238,0,5000,0,0,100,0,0),

  (412450,2,2919.62,-1387.2,176.099,0,0,0,0,100,0,9996283),
    (412450,1,2927.21,-1372.33,176.046,0,0,0,0,100,0,9996284),

  (154320,2,2909.69,-1407.05,176.047,0,0,0,0,100,0,9996285),
    (154320,1,2918.25,-1390.16,176.099,0,0,0,0,100,0,9996286),

  (412440,2,2958.24,-1407.82,176.1,0,0,0,0,100,0,0),
    (412440,1,2965.91,-1392.92,176.046,0,0,0,0,100,0,0),

  (155500,2,2956.66,-1411.01,176.101,0,0,0,0,100,0,0),
  (155500,1,2948.51,-1426.8,176.047,0,0,0,0,100,0,0);
 

Damieninabox

Gold Supporter
Senior User
194
2019
63
Nice fix

For everyone trying to implement it: Make sure your GUID's match.
If not, you can end up having a horrible time refixing it - just make sure.
 

Blackvision

Mythical User
Super Moderator
Gold Supporter
2,298
2015
272
Location
Denmark
Nice fix

For everyone trying to implement it: Make sure your GUID's match.
If not, you can end up having a horrible time refixing it - just make sure.
Can't we just set them all to replace into ?
To prevent adding a second npc..
 

Damieninabox

Gold Supporter
Senior User
194
2019
63
What if the GUID of all these npcs is (for any reason) like +1 in difference compared to the query and you then run the query.
What will happen?
Exactly, you will add these npcs a second time.
 

Blackvision

Mythical User
Super Moderator
Gold Supporter
2,298
2015
272
Location
Denmark
What if the GUID of all these npcs is (for any reason) like +1 in difference compared to the query and you then run the query.
What will happen?
Exactly, you will add these npcs a second time.
Well, if he use the same repack as we do, i cant see why it would mess anything up ? ..
But i get your point ?
 

Damieninabox

Gold Supporter
Senior User
194
2019
63
Because people like to mess around with things.
There are several reasons why people could have different GUID's....
 

Jenniy

I collect profile flairs.
Silver Supporter
Senior User
351
2020
70
Parroting my comment from your other post; Thank you much for fixes you given us!
 
Top