-- JapariPark_Option
-- Author: Cons
-- DateCreated: 2/21/2018 9:15:32 PM
--------------------------------------------------------------
CREATE TABLE IF NOT EXISTS Cons_GlobalUserSettings 
	(Type text default null,
	Value integer default 1);
	
-----------------------------------------------------------------------------------------------------------------------------------------------
--OPTION 1: Leader Setting
--Set this to "0" to disable leader
-----------------------------------------------------------------------------------------------------------------------------------------------
--Modular Features that can be toggled on and off and then back on. Restart the game for changed to take effect!
--Code from JFD's MOD
--------------------------------------------------------------------------
/*
GENERAL SETTINGS
--1 = Enabled (Default)
--0 = Disabled 
*/
--------------------------------------------------------------------------

INSERT OR REPLACE INTO Cons_GlobalUserSettings
		(Type,							Value)
VALUES	('CONS_JAPARI_PARK_KABAN',			1), 
		('CONS_JAPARI_PARK_SERVAL',			1), 
		('CONS_JAPARI_PARK_RACCOON',		1), 
		('CONS_JAPARI_PARK_TSUCHINOKO',		1); 

-----------------------------------------------------------------------------------------------------------------------------------------------

DELETE FROM Players WHERE LeaderType = 'LEADER_CONS_KABAN' AND EXISTS (SELECT * FROM Cons_GlobalUserSettings WHERE Type = 'CONS_JAPARI_PARK_KABAN' AND Value = 0);
DELETE FROM Players WHERE LeaderType = 'LEADER_CONS_SERVAL' AND EXISTS (SELECT * FROM Cons_GlobalUserSettings WHERE Type = 'CONS_JAPARI_PARK_SERVAL' AND Value = 0);
DELETE FROM Players WHERE LeaderType = 'LEADER_CONS_RACCOON' AND EXISTS (SELECT * FROM Cons_GlobalUserSettings WHERE Type = 'CONS_JAPARI_PARK_RACCOON' AND Value = 0);
DELETE FROM Players WHERE LeaderType = 'LEADER_CONS_TSUCHINOKO' AND EXISTS (SELECT * FROM Cons_GlobalUserSettings WHERE Type = 'CONS_JAPARI_PARK_TSUCHINOKO' AND Value = 0);