Oops I broke Nektulos..

Huppy · #2 09-11-2019, 09:28 AM

I'm sure sure your aware there are 2 versions of nektulos in the zone table, (old and new) - ID 439 (version 1) ID 246 (version 0) The following is something you can either use to restore, or use for reference:

(This is assuming these zone_points exist in your DB)

These are all the default zone_points going OUT of Nektulos

Code:

UPDATE `zone_points` SET `zone` = 'nektulos', `version` = 1, `number` = 20, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = -386, `target_x` = -133, `target_z` = -64, `target_heading` = 145, `zoneinst` = 0, `target_zone_id` = 365, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 4294967292 WHERE `id` = 1477;
UPDATE `zone_points` SET `zone` = 'nektulos', `version` = 1, `number` = 10, `y` = 2325, `x` = 740, `z` = 56, `heading` = 0, `target_y` = 118, `target_x` = -18, `target_z` = -62, `target_heading` = 506, `zoneinst` = 0, `target_zone_id` = 27, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 4294967292 WHERE `id` = 1476;
UPDATE `zone_points` SET `zone` = 'nektulos', `version` = 1, `number` = 30, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = 1355, `target_x` = 798, `target_z` = -18, `target_heading` = 87, `zoneinst` = 0, `target_zone_id` = 22, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 31 WHERE `id` = 1478;
UPDATE `zone_points` SET `zone` = 'nektulos', `version` = 1, `number` = 77, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = -841, `target_x` = 132, `target_z` = -157, `target_heading` = 257, `zoneinst` = 0, `target_zone_id` = 202, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 4294967292 WHERE `id` = 1480;
UPDATE `zone_points` SET `zone` = 'nektulos', `version` = 1, `number` = 30, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = 1292, `target_x` = -2480, `target_z` = 78, `target_heading` = 101.5, `zoneinst` = 0, `target_zone_id` = 408, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 4294967232 WHERE `id` = 2339;
UPDATE `zone_points` SET `zone` = 'nektulos', `version` = 1, `number` = 50, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = 53, `target_x` = 154, `target_z` = 28, `target_heading` = 251, `zoneinst` = 0, `target_zone_id` = 40, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 4294967292 WHERE `id` = 1479;
UPDATE `zone_points` SET `zone` = 'nektulos', `version` = 0, `number` = 1, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = 53, `target_x` = 154, `target_z` = 28, `target_heading` = 130, `zoneinst` = 0, `target_zone_id` = 40, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 4294967295 WHERE `id` = 1444;
UPDATE `zone_points` SET `zone` = 'nektulos', `version` = 0, `number` = 2, `y` = -2702, `x` = -654, `z` = -18, `heading` = 0, `target_y` = 1549, `target_x` = 627, `target_z` = -20, `target_heading` = 110, `zoneinst` = 0, `target_zone_id` = 22, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 4294967295 WHERE `id` = 1445;
UPDATE `zone_points` SET `zone` = 'nektulos', `version` = 0, `number` = 3, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = 81.43, `target_x` = -10.38, `target_z` = -54.94, `target_heading` = 0, `zoneinst` = 0, `target_zone_id` = 27, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 4294967295 WHERE `id` = 1446;
UPDATE `zone_points` SET `zone` = 'nektulos', `version` = 0, `number` = 77, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = -841, `target_x` = 132, `target_z` = -157, `target_heading` = 1, `zoneinst` = 0, `target_zone_id` = 202, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 4294967295 WHERE `id` = 1447;

These are all the default zone_points going IN to Nektulos:

Code:

UPDATE `zone_points` SET `zone` = 'ecommons', `version` = 0, `number` = 4, `y` = 1553, `x` = 641, `z` = -18, `heading` = 0, `target_y` = -2679.36, `target_x` = -514.8, `target_z` = -19.34, `target_heading` = 50, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 3 WHERE `id` = 53;
UPDATE `zone_points` SET `zone` = 'neriaka', `version` = 0, `number` = 3, `y` = 29, `x` = 155, `z` = 30, `heading` = 0, `target_y` = 2299.79, `target_x` = -1108.24, `target_z` = 2.19, `target_heading` = 64, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 3 WHERE `id` = 415;
UPDATE `zone_points` SET `zone` = 'poknowledge', `version` = 0, `number` = 17, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = 705, `target_x` = -349, `target_z` = -4, `target_heading` = 20, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 3 WHERE `id` = 468;
UPDATE `zone_points` SET `zone` = 'lavastorm', `version` = 0, `number` = 0, `y` = 75, `x` = -10, `z` = -53, `heading` = 0, `target_y` = 3107, `target_x` = 289, `target_z` = -17, `target_heading` = 88, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 3 WHERE `id` = 658;
UPDATE `zone_points` SET `zone` = 'corathus', `version` = 0, `number` = 1, `y` = 999999, `x` = 999999, `z` = 999999, `heading` = 999, `target_y` = -697.9, `target_x` = 1271.2, `target_z` = -2.2, `target_heading` = 169.5, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 4294967295 WHERE `id` = 1458;
UPDATE `zone_points` SET `zone` = 'corathus', `version` = 0, `number` = 30, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = -1026, `target_x` = 1187, `target_z` = -11, `target_heading` = 442, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 0, `buffer` = 0, `client_version_mask` = 4294967295 WHERE `id` = 1501;
UPDATE `zone_points` SET `zone` = 'commonlands', `version` = 0, `number` = 20, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = -2192, `target_x` = -419, `target_z` = 2, `target_heading` = 235, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 1, `buffer` = 0, `client_version_mask` = 4294967295 WHERE `id` = 1575;
UPDATE `zone_points` SET `zone` = 'ecommons', `version` = 0, `number` = 4, `y` = 1553, `x` = 641, `z` = -18, `heading` = 0, `target_y` = -2225.7, `target_x` = -466.5, `target_z` = 3.6, `target_heading` = 246.8, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 1, `buffer` = 0, `client_version_mask` = 4294967292 WHERE `id` = 1585;
UPDATE `zone_points` SET `zone` = 'neriaka', `version` = 0, `number` = 3, `y` = 29, `x` = 155, `z` = 30, `heading` = 0, `target_y` = 1824.4, `target_x` = -977.1, `target_z` = 24.7, `target_heading` = 71.5, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 1, `buffer` = 0, `client_version_mask` = 4294967292 WHERE `id` = 1586;
UPDATE `zone_points` SET `zone` = 'poknowledge', `version` = 0, `number` = 17, `y` = 0, `x` = 0, `z` = 0, `heading` = 0, `target_y` = -814.6, `target_x` = -833.7, `target_z` = 9.9, `target_heading` = 218.8, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 1, `buffer` = 0, `client_version_mask` = 4294967292 WHERE `id` = 1587;
UPDATE `zone_points` SET `zone` = 'lavastorm', `version` = 0, `number` = 0, `y` = 75, `x` = -10, `z` = -53, `heading` = 0, `target_y` = 2275.93, `target_x` = 744.19, `target_z` = 38, `target_heading` = 128, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 1, `buffer` = 0, `client_version_mask` = 4294967292 WHERE `id` = 1588;
UPDATE `zone_points` SET `zone` = 'corathus', `version` = 0, `number` = 1, `y` = 999999, `x` = 999999, `z` = 999999, `heading` = 999, `target_y` = -1053.9, `target_x` = 1193.9, `target_z` = -4.2, `target_heading` = 221.3, `zoneinst` = 0, `target_zone_id` = 25, `target_instance` = 1, `buffer` = 0, `client_version_mask` = 4294967292 WHERE `id` = 1589;