[Default]
Version = 1
;; Used incase there is ever a breaking change, or to inform user in log about a new feature.

;;Strip Chars = "/\|;{}<>'"
Strip Chars = /\|;{}<>
;; List of characters to strip out
Strip Chars Mode = 0
;; 0 = Strip Bad Chars, 1 = Strip + Log Bad Chars, 2 = Return Error & Log Bad Chars
;;     Note: Logging on works when sending data to database.

Input SQF Parser = false
;; Expermential
;;   If enabled will use SQF Array Parser instead of : seperator for values
;;   i.e   0:SQL:UpdatePlayer:["Joe",[1,2,0],0.22333,"PlayerBackpack",-3]
;;   Advantage is that you don't need to strip : seperator from user inputted values



; --------------------------------------------------------------------------------
; DB INFO
; --------------------------------------------------------------------------------

[getDBVersion]
Prepared Statement = false

SQL1_1 = SELECT IFNULL ((SELECT Value FROM DBInfo WHERE Name = 'Version'), '2.0');


; --------------------------------------------------------------------------------
; SERVER INSTANCE & MAP
; --------------------------------------------------------------------------------

[checkServerInstance]
Prepared Statement = false

SQL1_1 = SELECT IF ((SELECT 1 FROM ServerInstance WHERE ID = $CUSTOM_1$), 'true', 'false');
SQL1_INPUTS = 1

[insertServerInstance]
Prepared Statement = false

SQL1_1 = INSERT INTO ServerInstance SET ID = $CUSTOM_1$;
SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE

[getServerMapID]
Prepared Statement = false

SQL1_1 = SELECT IFNULL ((SELECT ID FROM ServerMap WHERE WorldName = "$CUSTOM_1$" AND Environment = "$CUSTOM_2$"), 0);
SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE

[insertServerMap]
Prepared Statement = false
Return InsertID = true

SQL1_1 = INSERT INTO ServerMap SET WorldName = "$CUSTOM_1$", Environment = "$CUSTOM_2$";
SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE

; --------------------------------------------------------------------------------
; PLAYER SAVING
; --------------------------------------------------------------------------------

[checkPlayerSave]
SQL1_1 = SELECT IF ((SELECT 1 FROM PlayerSave WHERE PlayerUID = ? AND MapID = ?), 'true', 'false');
SQL1_INPUTS = 1,2

[checkPlayerSaveXMap]
SQL1_1 = SELECT IF ((SELECT 1 FROM PlayerSave ps INNER JOIN (SELECT ID AS ServerMapID FROM ServerMap WHERE Environment = ?) sm
SQL1_2 =             WHERE PlayerUID = ? AND ps.MapID = sm.ServerMapID GROUP BY 1), 'true', 'false');
SQL1_INPUTS = 2,1

[getPlayerSave]
Prepared Statement = false

SQL1_1 = SELECT $CUSTOM_3$ FROM PlayerSave WHERE PlayerUID = "$CUSTOM_1$" AND MapID = "$CUSTOM_2$";
SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE, 3-STRIP

[getPlayerSaveXMap]
Prepared Statement = false

SQL1_1 = SELECT $CUSTOM_3$ FROM PlayerSave ps INNER JOIN (SELECT ID AS ServerMapID FROM ServerMap WHERE Environment = "$CUSTOM_1$") sm
SQL1_2 = WHERE PlayerUID = "$CUSTOM_2$" AND ps.MapID = sm.ServerMapID
SQL1_3 = ORDER BY LastModified DESC LIMIT 1;

SQL1_INPUTS = 2-STRIP-MYSQL_ESCAPE, 1-STRIP-MYSQL_ESCAPE, 3-MYSQL_ESCAPE

[getPlayerBankMoney]
SQL1_1 = SELECT BankMoney FROM PlayerInfo WHERE UID = ?;

SQL1_INPUTS = 1

[getPlayerBounty]
SQL1_1 = SELECT Bounty, BountyKills FROM PlayerInfo WHERE UID = ?;

SQL1_INPUTS = 1

[getTimeSinceServerSwitch]
SQL1_1 = SELECT TIMESTAMPDIFF(SECOND, LastModified, NOW()), LastServerID FROM PlayerSave
SQL1_2 = WHERE PlayerUID = ? AND MapID = ? AND LastServerID != ? AND LastServerID IS NOT NULL;

SQL1_INPUTS = 1,2,3

[getTimeSinceServerSwitchXMap]
SQL1_1 = SELECT TIMESTAMPDIFF(SECOND, LastModified, NOW()), LastServerID, WorldName
SQL1_2 = FROM PlayerSave ps INNER JOIN (SELECT ID AS ServerMapID, WorldName FROM ServerMap WHERE Environment = ?) sm
SQL1_3 = WHERE PlayerUID = ? AND ps.MapID = sm.ServerMapID AND LastServerID != ? AND LastServerID IS NOT NULL
SQL1_4 = ORDER BY LastModified DESC LIMIT 1;

SQL1_INPUTS = 2,1,3

[insertOrUpdatePlayerInfo]
Prepared Statement = false

SQL1_1 = INSERT INTO PlayerInfo SET UID = "$CUSTOM_1$", BattlEyeGUID = REPLACE("$CUSTOM_2$",'"',''), $CUSTOM_3$
SQL1_2 = ON DUPLICATE KEY UPDATE $CUSTOM_4$;

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 1-BEGUID, 2-STRIP, 3-STRIP


[insertOrUpdatePlayerSave]
Prepared Statement = false

SQL1_1 = INSERT INTO PlayerSave SET PlayerUID = "$CUSTOM_1$", MapID = "$CUSTOM_2$", LastServerID = "$CUSTOM_3$", CreationDate = NOW(), $CUSTOM_4$
SQL1_2 = ON DUPLICATE KEY UPDATE LastServerID = VALUES(LastServerID), $CUSTOM_5$;

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE, 3-STRIP-MYSQL_ESCAPE, 4-STRIP, 5-STRIP


[deletePlayerSave]
SQL1_1 = DELETE FROM PlayerSave WHERE PlayerUID = ? AND MapID = ?;

SQL1_INPUTS = 1,2

[deletePlayerSaveXMap]
SQL1_1 = DELETE ps FROM PlayerSave ps INNER JOIN (SELECT ID AS ServerMapID FROM ServerMap WHERE Environment = ?) sm
SQL1_2 = WHERE PlayerUID = ? AND ps.MapID = sm.ServerMapID;

SQL1_INPUTS = 2,1

[getPlayerStats]
Prepared Statement = false

SQL1_1 = SELECT $CUSTOM_2$ FROM PlayerStats WHERE PlayerUID = $CUSTOM_1$;

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP

[insertOrUpdatePlayerStats]
Prepared Statement = false

SQL1_1 = INSERT INTO PlayerStats SET PlayerUID = "$CUSTOM_1$", $CUSTOM_2$ = "$CUSTOM_3$"
SQL1_2 = ON DUPLICATE KEY UPDATE $CUSTOM_2$ = $CUSTOM_2$ + "$CUSTOM_3$";
SQL2_1 = INSERT INTO PlayerStatsMap SET PlayerUID = "$CUSTOM_1$", ServerID = "$CUSTOM_2$", MapID = "$CUSTOM_3$", $CUSTOM_4$ = "$CUSTOM_5$"
SQL2_2 = ON DUPLICATE KEY UPDATE $CUSTOM_4$ = $CUSTOM_4$ + "$CUSTOM_5$";

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 4-STRIP-MYSQL_ESCAPE, 5-STRIP-MYSQL_ESCAPE
SQL2_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE, 3-STRIP-MYSQL_ESCAPE, 4-STRIP-MYSQL_ESCAPE, 5-STRIP-MYSQL_ESCAPE

; --------------------------------------------------------------------------------
; PRIVATE STORAGE
; --------------------------------------------------------------------------------

[getPlayerStorage]
Prepared Statement = false

SQL1_1 = SELECT $CUSTOM_3$ FROM PlayerStorage WHERE PlayerUID = "$CUSTOM_1$" AND MapID = "$CUSTOM_2$";

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE, 3-STRIP

[getPlayerStorageXMap]
Prepared Statement = false

SQL1_1 = SELECT $CUSTOM_3$ FROM PlayerStorage ps INNER JOIN (SELECT ID AS ServerMapID FROM ServerMap WHERE Environment = "%CUSTOM_1") sm
SQL1_2 = WHERE PlayerUID = "$CUSTOM_2$" AND ps.MapID = sm.ServerMapID
SQL1_3 = ORDER BY LastModified DESC LIMIT 1;

SQL1_INPUTS = 2-STRIP-MYSQL_ESCAPE, 1-STRIP-MYSQL_ESCAPE, 3-STRIP

[insertOrUpdatePlayerStorage]
Prepared Statement = false

SQL1_1 = INSERT INTO PlayerStorage SET PlayerUID = "$CUSTOM_1$", MapID = "$CUSTOM_2$", CreationDate = NOW(), $CUSTOM_3$
SQL1_2 = ON DUPLICATE KEY UPDATE $CUSTOM_4$;

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE, 3-STRIP, 4-STRIP


; --------------------------------------------------------------------------------
; WARCHEST
; --------------------------------------------------------------------------------

[getWarchestMoney]
Prepared Statement = false

SQL1_1 = SELECT WarchestMoneyBLUFOR, WarchestMoneyOPFOR FROM ServerInstance WHERE ID = "$CUSTOM_1$";

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE

[updateWarchestMoney]
SQL1_1 = UPDATE ServerInstance SET WarchestMoneyBLUFOR = ?, WarchestMoneyOPFOR = ? WHERE ID = ?;

SQL1_INPUTS = 2,3,1

; --------------------------------------------------------------------------------
; SERVER TIME
; --------------------------------------------------------------------------------

[getServerTime]
Prepared Statement = false

SQL1_1 = SELECT DayTime, Fog, Overcast, Rain, Wind FROM ServerTime WHERE ServerID = "$CUSTOM_1$" AND MapID = "$CUSTOM_2$";

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE

[insertOrUpdateServerTime]
SQL1_1 = INSERT INTO ServerTime SET ServerID = ?, MapID = ?, DayTime = ?, Fog = ?, Overcast = ?, Rain = ?, Wind = ?
SQL1_2 = ON DUPLICATE KEY UPDATE DayTime = VALUES(DayTime), Fog = VALUES(Fog), Overcast = VALUES(Overcast), Rain = VALUES(Rain), Wind = VALUES(Wind);

SQL1_INPUTS = 1,2,3,4,5,6,7

; --------------------------------------------------------------------------------
; OBJECT SAVING
; --------------------------------------------------------------------------------

[getServerObjects]
Prepared Statement = false

SQL1_1 = SELECT $CUSTOM_3$ FROM ServerObjects WHERE ServerID = "$CUSTOM_1$" AND MapID = "$CUSTOM_2$";

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE, 3-STRIP

[newServerObject]
SQL1_1 = INSERT INTO ServerObjects SET ServerID = ?, MapID = ?, CreationDate = NOW();
SQL2_1 = SELECT QUOTE(LAST_INSERT_ID());

SQL1_INPUTS = 1,2

[updateServerObject]
Prepared Statement = false

SQL1_1 = UPDATE ServerObjects SET $CUSTOM_2$ WHERE ID = "$CUSTOM_1$";

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP

[deleteServerObjects]
Prepared Statement = false

SQL1_1 = DELETE FROM ServerObjects WHERE ID IN $CUSTOM_1$;

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE

[deleteExpiredServerObjects]
Prepared Statement = false

SQL1_1 = DELETE FROM ServerObjects WHERE ServerID = "$CUSTOM_1$" AND MapID = "$CUSTOM_2$"
SQL1_2 = 	AND (($CUSTOM_3$ > 0 AND TIMESTAMPDIFF(HOUR, LastInteraction, NOW()) > $CUSTOM_4$)
SQL1_3 = 	     OR ($CUSTOM_5$ <= 0 AND Locked < 1 AND Deployable < 1)
SQL1_4 = 	     OR Damage >= 1);

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE, 3-STRIP-MYSQL_ESCAPE, 3-STRIP-MYSQL_ESCAPE, 4-STRIP-MYSQL_ESCAPE

; --------------------------------------------------------------------------------
; VEHICLE SAVING
; --------------------------------------------------------------------------------

[getServerVehicles]
Prepared Statement = false

SQL1_1 = SELECT $CUSTOM_3$ FROM ServerVehicles WHERE ServerID = "$CUSTOM_1$" AND MapID = "$CUSTOM_2$" AND Parked < 1;

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE, 3-STRIP

[newServerVehicle]
SQL1_1 = INSERT INTO ServerVehicles SET ServerID = ?, MapID = ?, CreationDate = NOW();
SQL2_1 = SELECT QUOTE(LAST_INSERT_ID());

SQL1_INPUTS = 1,2

[updateServerVehicle]
Prepared Statement = false

SQL1_1 = UPDATE ServerVehicles SET $CUSTOM_2$ WHERE ID = "$CUSTOM_1$";

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP

[deleteServerVehicles]
Prepared Statement = false

SQL1_1 = DELETE FROM ServerVehicles WHERE ID IN ($CUSTOM_1$);

SQL1_INPUTS = 1-STRIP

[deleteExpiredServerVehicles]
Prepared Statement = false

SQL1_1 = DELETE FROM ServerVehicles WHERE ServerID = "$CUSTOM_1$" AND MapID = "$CUSTOM_2$" AND Parked < 1
SQL1_2 = 	AND (("$CUSTOM_3$" > 0 AND TIMESTAMPDIFF(HOUR, CreationDate, NOW()) > $CUSTOM_4$)
SQL1_3 = 	     OR ($CUSTOM_5$ > 0 AND TIMESTAMPDIFF(HOUR, LastUsed, NOW()) > $CUSTOM_6$)
SQL1_4 = 	     OR Damage >= 0.99);

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE, 3-STRIP-MYSQL_ESCAPE, 3-STRIP-MYSQL_ESCAPE, 4-STRIP-MYSQL_ESCAPE, 4-STRIP-MYSQL_ESCAPE

[getParkedVehicles]
Prepared Statement = false

SQL1_1 = SELECT $CUSTOM_3$ FROM ServerVehicles sv INNER JOIN (SELECT ID AS ServerMapID FROM ServerMap WHERE Environment = "$CUSTOM_1$") sm
SQL1_2 = WHERE OwnerUID = "$CUSTOM_2$" AND Parked > 0 AND sv.MapID = sm.ServerMapID;

SQL1_INPUTS = 2-STRIP-MYSQL_ESCAPE, 1-STRIP-MYSQL_ESCAPE, 3-Strip

; --------------------------------------------------------------------------------
; MINE SAVING
; --------------------------------------------------------------------------------

[getServerMines]
Prepared Statement = false

SQL1_1 = SELECT $CUSTOM_3$ FROM ServerMines WHERE ServerID = "$CUSTOM_1$" AND MapID = "$CUSTOM_2$";

SQL1_INPUTS = 1-STRIP, 2-STRIP-MYSQL_ESCAPE, 3-STRIP-MYSQL_ESCAPE

[newServerMine]
SQL1_1 = INSERT INTO ServerMines SET ServerID = ?, MapID = ?, CreationDate = NOW();
SQL2_1 = SELECT QUOTE(LAST_INSERT_ID());

SQL1_INPUTS = 1,2

[updateServerMine]
Prepared Statement = false

SQL1_1 = UPDATE ServerMines SET $CUSTOM_2$ WHERE ID = "$CUSTOM_1$";

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP


[deleteServerMines]
Prepared Statement = false

SQL1_1 = DELETE FROM ServerMines WHERE ID IN ($CUSTOM_1$);

SQL1_INPUTS = 1-STRIP

[deleteExpiredServerMines]
Prepared Statement = false

SQL1_1 = DELETE FROM ServerMines WHERE ServerID = "$CUSTOM_1$" AND MapID = "$CUSTOM_2$"
SQL1_2 = 	AND ($CUSTOM_3$ > 0 AND TIMESTAMPDIFF(HOUR, LastInteraction, NOW()) > $CUSTOM_4$);

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE, 3-STRIP-MYSQL_ESCAPE, 3-STRIP-MYSQL_ESCAPE

; --------------------------------------------------------------------------------
; LOGGING
; --------------------------------------------------------------------------------

[addAdminLog]
SQL1_1 = INSERT INTO AdminLog (ServerID, PlayerName, PlayerUID, BattlEyeGUID, ActionType, ActionValue)
SQL1_2 = 	VALUES (?, ?, ?, REPLACE(?,'"',''), ?, ?);

SQL1_INPUTS = 1,2,3,3-STRING-BEGUID,4-STRING,5-STRING

[addAntihackLog]
SQL1_1 = INSERT INTO AntihackLog (ServerID, PlayerName, PlayerUID, BattlEyeGUID, HackType, HackValue)
SQL1_2 = 	VALUES (?, ?, ?, REPLACE(?,'"',''), ?, ?);

SQL1_INPUTS = 1,2,3,3-STRING-BEGUID,4-STRING,5-STRING

[getAntihackEntry]
SQL1_1 = SELECT QUOTE(PlayerName), HackType FROM AntihackLog WHERE PlayerUID = ? AND KickOnJoin > 0 LIMIT 1;

SQL1_INPUTS = 1

[addBankTransferLog]
SQL1_1 = INSERT INTO BankTransferLog (ServerID, SenderName, SenderUID, SenderSide, RecipientName, RecipientUID, RecipientSide, Amount, Fee)
SQL1_2 = 	VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?);

SQL1_INPUTS = 1,2,3,4,5,6,7,8,9