extdb3 Prepared Statements Config - TaskForce47/TF47CoreScripts GitHub Wiki

[Default]

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

Strip Chars = ";[]{,}|\^~`.#%-:"
;; List of characters to strip out  
Strip Chars Mode = 1
;; 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  

[checkWhitelist]
SQL1_1 = SELECT pl.player_id FROM players AS pl LEFT JOIN player_whitelist AS plwl ON pl.id = plwl.player_id WHERE pl.player_id = ? AND plwl.whitelist_id=?;
SQL1_INPUTS = 1,2
OUTPUT = 1-STRING

[getPlayerNameByPlayerId]
SQL1_1 = SELECT pl.name FROM players AS pl WHERE pl.player_id = ?;
SQL1_INPUTS = 1
OUTPUT = 1-STRING

[getPlayerIdByPlayerId]
SQL1_1 = SELECT pl.id FROM players AS pl WHERE pl.player_id = ?;
SQL1_INPUTS = 1

[updatePlayerName]
SQL1_1 = UPDATE players SET name = ? WHERE player_id = ?;
SQL1_INPUTS = 1,2

[insertPlayerName]
SQL1_1 = INSERT INTO players VALUES(NULL, ?, NULL, ?, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'de');
SQL1_INPUTS = 1,2

[getLastRound]
SQL1_1 = SELECT MAX(tl.round) from ticketlog AS tl WHERE tl.mission_id = ?;
SQL1_INPUTS = 1

[insertTicketlog]
SQL1_1 = INSERT INTO ticketlog VALUES(NULL, ?, NULL, ?, ?, ?, ?, ?, ?);
SQL1_INPUTS = 1,2,3,4,5,6-null,7