Core/WorldStates: Migrate OutdoorPvP worldstates to new system

1 files changed, 107 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_07_11_00_world.sql b/sql/updates/world/master/2022_07_11_00_world.sql
new file mode 100644
index 00000000000..f752c92ce2e
--- /dev/null
+++ b/sql/updates/world/master/2022_07_11_00_world.sql
@@ -0,0 +1,107 @@
+DELETE FROM `world_state` WHERE `ID` IN (2313,2314,2317,2322,2323,2324,2325,2470,2471,2472,2473,2474,2475,2476,2478,2480,2481,2482,2483,2484,2485,2489,2490,2491,2493,2494,2495,2497,2502,
+2503,2508,2509,2510,2512,2527,2528,2529,2533,2534,2535,2555,2556,2557,2558,2559,2560,2620,2621,2622,2623,2624,2625,2644,2645,2646,2647,2648,2649,2650,2651,2652,2655,2656,2657,2658,2659,
+2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2676,2677,2681,2682,2683,2684,2685,2686,2688,2689,2690,2691,2692,2693,2694,2695,2696,2760,2761,2762,2763,2767,2768);
+INSERT INTO `world_state` (`ID`,`DefaultValue`,`MapIDs`,`AreaIDs`,`ScriptName`,`Comment`) VALUES
+(2313,0,'1','1377','','Silithus - Alliance Silithyst Collected'),
+(2314,0,'1','1377','','Silithus - Horde Silithyst Collected'),
+(2317,200,'1','1377','','Silithus - Max Silithyst'),
+(2322,0,'1','1377','','Silithus - Sandworm N (unused)'),
+(2323,0,'1','1377','','Silithus - Sandworm S (unused)'),
+(2324,0,'1','1377','','Silithus - Sandworm SW (unused)'),
+(2325,0,'1','1377','','Silithus - Sandworm E (unused)'),
+(2470,0,'530','3483','','Hellfire Peninsula - The Stadium - Horde Controlled'),
+(2471,0,'530','3483','','Hellfire Peninsula - The Stadium - Alliance Controlled'),
+(2472,1,'530','3483','','Hellfire Peninsula - The Stadium - Neutral'),
+(2473,0,'530','3483','','Hellfire Peninsula - Show Fort capture bar'),
+(2474,50,'530','3483','','Hellfire Peninsula - Fort CaptureBar Value'),
+(2475,20,'530','3483','','Hellfire Peninsula - Fort CaptureBar Neutral Zone Size'),
+(2476,0,'530','3483','','Hellfire Peninsula - Alliance Forts Controlled'),
+(2478,0,'530','3483','','Hellfire Peninsula - Horde Forts Controlled'),
+(2480,0,'530','3483','','Hellfire Peninsula - The Overlook - Alliance Controlled'),
+(2481,0,'530','3483','','Hellfire Peninsula - The Overlook - Horde Controlled'),
+(2482,1,'530','3483','','Hellfire Peninsula - The Overlook - Neutral'),
+(2483,0,'530','3483','','Hellfire Peninsula - Broken Hill - Alliance Controlled'),
+(2484,0,'530','3483','','Hellfire Peninsula - Broken Hill - Horde Controlled'),
+(2485,1,'530','3483','','Hellfire Peninsula - Broken Hill - Neutral'),
+(2489,1,'530','3483','','Hellfire Peninsula - Show Horde Forts Controlled'),
+(2490,1,'530','3483','','Hellfire Peninsula - Show Alliance Forts Controlled'),
+(2491,0,'530','3518','','Nagrand - Halaa - Guards Remaining'),
+(2493,15,'530','3518','','Nagrand - Halaa - Guards Max'),
+(2494,50,'530','3518','','Nagrand - Halaa - CaptureBar Value'),
+(2495,0,'530','3518','','Nagrand - Halaa - Show capture bar'),
+(2497,0,'530','3518','','Nagrand - Halaa - CaptureBar Neutral Zone Size'),
+(2502,0,'530','3518','','Nagrand - Halaa - Show Alliance Guards Remaining'),
+(2503,0,'530','3518','','Nagrand - Halaa - Show Horde Guards Remaining'),
+(2508,0,'530','3519','','Terokkar Forest - Show Locked time remaining (Neutral)'),
+(2509,0,'530','3519','','Terokkar Forest - Locked time remaining hours'),
+(2510,0,'530','3519','','Terokkar Forest - Locked time remaining minutes first digit'),
+(2512,0,'530','3519','','Terokkar Forest - Locked time remaining minutes second digit'),
+(2527,0,'530','3521','','Zangarmarsh - West Beacon Show CaptureBar'),
+(2528,50,'530','3521','','Zangarmarsh - West Beacon CaptureBar Value'),
+(2529,80,'530','3521','','Zangarmarsh - West Beacon CaptureBar Neutral Zone Size'),
+(2533,0,'530','3521','','Zangarmarsh - East Beacon Show CaptureBar'),
+(2534,50,'530','3521','','Zangarmarsh - East Beacon CaptureBar Value'),
+(2535,80,'530','3521','','Zangarmarsh - East Beacon CaptureBar Neutral Zone Size'),
+(2555,0,'530','3521','','Zangarmarsh - West Beacon - Alliance Controlled widget'),
+(2556,0,'530','3521','','Zangarmarsh - West Beacon - Horde Controlled widget'),
+(2557,1,'530','3521','','Zangarmarsh - West Beacon - Neutral widget'),
+(2558,0,'530','3521','','Zangarmarsh - East Beacon - Alliance Controlled widget'),
+(2559,0,'530','3521','','Zangarmarsh - East Beacon - Horde Controlled widget'),
+(2560,1,'530','3521','','Zangarmarsh - East Beacon - Neutral widget'),
+(2620,1,'530','3519','','Terokkar Forest - Show Towers Controlled'),
+(2621,0,'530','3519','','Terokkar Forest - Alliance Towers Controlled'),
+(2622,0,'530','3519','','Terokkar Forest - Horde Towers Controlled'),
+(2623,0,'530','3519','','Terokkar Forest - Show Tower capture bar'),
+(2624,80,'530','3519','','Terokkar Forest - Tower CaptureBar Neutral Zone Size'),
+(2625,50,'530','3519','','Terokkar Forest - Tower CaptureBar Value'),
+(2644,0,'530','3521','','Zangarmarsh - West Beacon - Alliance Controlled POI'),
+(2645,0,'530','3521','','Zangarmarsh - West Beacon - Horde Controlled POI'),
+(2646,1,'530','3521','','Zangarmarsh - West Beacon  POI'),
+(2647,1,'530','3521','','Zangarmarsh - Twinspire Graveyard'),
+(2648,0,'530','3521','','Zangarmarsh - Twinspire Graveyard - Alliance Controlled'),
+(2649,0,'530','3521','','Zangarmarsh - Twinspire Graveyard - Horde Controlled'),
+(2650,0,'530','3521','','Zangarmarsh - East Beacon - Alliance Controlled POI'),
+(2651,0,'530','3521','','Zangarmarsh - East Beacon - Horde Controlled POI'),
+(2652,1,'530','3521','','Zangarmarsh - East Beacon POI'),
+(2655,0,'530','3521','','Zangarmarsh - Alliance Field Scout (ready)'),
+(2656,1,'530','3521','','Zangarmarsh - Alliance Field Scout (not ready)'),
+(2657,1,'530','3521','','Zangarmarsh - Horde Field Scout (not ready)'),
+(2658,0,'530','3521','','Zangarmarsh - Horde Field Scout (ready)'),
+(2659,0,'530','3518','','Nagrand - Wyvern Camp (East) - Alliance Uncontrolled'),
+(2660,0,'530','3518','','Nagrand - Wyvern Camp (East) - Horde Controlled'),
+(2661,0,'530','3518','','Nagrand - Wyvern Camp (East) - Alliance Controlled'),
+(2662,0,'530','3518','','Nagrand - Wyvern Camp (North) - Alliance Uncontrolled'),
+(2663,0,'530','3518','','Nagrand - Wyvern Camp (North) - Horde Controlled'),
+(2664,0,'530','3518','','Nagrand - Wyvern Camp (North) - Alliance Controlled'),
+(2665,0,'530','3518','','Nagrand - Wyvern Camp (West) - Horde Controlled'),
+(2666,0,'530','3518','','Nagrand - Wyvern Camp (West) - Alliance Controlled'),
+(2667,0,'530','3518','','Nagrand - Wyvern Camp (West) - Alliance Uncontrolled'),
+(2668,0,'530','3518','','Nagrand - Wyvern Camp (South) - Horde Controlled'),
+(2669,0,'530','3518','','Nagrand - Wyvern Camp (South) - Alliance Controlled'),
+(2670,0,'530','3518','','Nagrand - Wyvern Camp (South) - Alliance Uncontrolled'),
+(2671,1,'530','3518','','Nagrand - Halaa - Uncontrolled'),
+(2672,0,'530','3518','','Nagrand - Halaa - Horde Controlled'),
+(2673,0,'530','3518','','Nagrand - Halaa - Alliance Controlled'),
+(2676,0,'530','3518','','Nagrand - Halaa - Alliance Capturing'),
+(2677,0,'530','3518','','Nagrand - Halaa - Horde Capturing'),
+(2681,1,'530','3519','','Terokkar Forest - Spirit Tower (NW) - Neutral'),
+(2682,0,'530','3519','','Terokkar Forest - Spirit Tower (NW) - Horde Controlled'),
+(2683,0,'530','3519','','Terokkar Forest - Spirit Tower (NW) - Alliance Controlled'),
+(2684,0,'530','3519','','Terokkar Forest - Spirit Tower (N) - Alliance Controlled'),
+(2685,0,'530','3519','','Terokkar Forest - Spirit Tower (N) - Horde Controlled'),
+(2686,1,'530','3519','','Terokkar Forest - Spirit Tower (N) - Neutral'),
+(2688,0,'530','3519','','Terokkar Forest - Spirit Tower (NE) - Alliance Controlled'),
+(2689,0,'530','3519','','Terokkar Forest - Spirit Tower (NE) - Horde Controlled'),
+(2690,1,'530','3519','','Terokkar Forest - Spirit Tower (NE) - Neutral'),
+(2691,0,'530','3519','','Terokkar Forest - Spirit Tower (S) - Alliance Controlled'),
+(2692,0,'530','3519','','Terokkar Forest - Spirit Tower (S) - Horde Controlled'),
+(2693,1,'530','3519','','Terokkar Forest - Spirit Tower (S) - Neutral'),
+(2694,0,'530','3519','','Terokkar Forest - Spirit Tower (SE) - Alliance Controlled'),
+(2695,0,'530','3519','','Terokkar Forest - Spirit Tower (SE) - Horde Controlled'),
+(2696,1,'530','3519','','Terokkar Forest - Spirit Tower (SE) - Neutral'),
+(2760,0,'530','3518','','Nagrand - Wyvern Camp (South) - Horde Uncontrolled'),
+(2761,0,'530','3518','','Nagrand - Wyvern Camp (West) - Horde Uncontrolled'),
+(2762,0,'530','3518','','Nagrand - Wyvern Camp (North) - Horde Uncontrolled'),
+(2763,0,'530','3518','','Nagrand - Wyvern Camp (East) - Horde Uncontrolled'),
+(2767,0,'530','3519','','Terokkar Forest - Show Locked time remaining (Alliance)'),
+(2768,0,'530','3519','','Terokkar Forest - Show Locked time remaining (Horde)');