This SQL removes 140 duplicate waypoint scripts.
-- Remove some duplicate waypoint scripts
UPDATE `waypoint_data` SET `action`=3 WHERE `action`=4;
DELETE FROM `waypoint_scripts` WHERE `id`=4;
UPDATE `waypoint_data` SET `action`=31 WHERE `action` IN (32,33);
DELETE FROM `waypoint_scripts` WHERE `id` IN (32,33);
UPDATE `waypoint_data` SET `action`=34 WHERE `action` IN (35,36,37,38);
DELETE FROM `waypoint_scripts` WHERE `id` IN (35,36,37,38);
UPDATE `waypoint_data` SET `action`=113 WHERE `action` BETWEEN 114 AND 141;
UPDATE `waypoint_data` SET `action`=113 WHERE `action` IN (227,228,684692);
DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 114 AND 141;
DELETE FROM `waypoint_scripts` WHERE `id` IN (227,228,684692);
UPDATE `waypoint_data` SET `action`=336 WHERE `action` BETWEEN 337 AND 369;
UPDATE `waypoint_data` SET `action`=336 WHERE `action` BETWEEN 376 AND 379;
DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 337 AND 369;
DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 376 AND 379;
UPDATE `waypoint_data` SET `action`=161 WHERE `action` BETWEEN 162 AND 166;
UPDATE `waypoint_data` SET `action`=161 WHERE `action` BETWEEN 370 AND 375;
DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 162 AND 166;
DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 370 AND 375;
UPDATE `waypoint_data` SET `action`=172 WHERE `action` BETWEEN 173 AND 183;
DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 173 AND 183;
UPDATE `waypoint_data` SET `action`=1013 WHERE `action` BETWEEN 1014 AND 1020;
UPDATE `waypoint_data` SET `action`=1013 WHERE `action` BETWEEN 1027 AND 1037;
UPDATE `waypoint_data` SET `action`=1013 WHERE `action` BETWEEN 1072 AND 1076;
UPDATE `waypoint_data` SET `action`=1013 WHERE `action` BETWEEN 1108 AND 1113;
UPDATE `waypoint_data` SET `action`=1013 WHERE `action` IN (1043,1044,1045,1065,1070,1083,1085,1088,1090,1092,1094,1096,1097,1100,1105,1166);
DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 1014 AND 1020;
DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 1027 AND 1037;
DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 1072 AND 1076;
DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 1108 AND 1113;
DELETE FROM `waypoint_scripts` WHERE `id` IN (1043,1044,1045,1065,1070,1083,1085,1088,1090,1092,1094,1096,1097,1100,1105,1166);[/sql]