[Tutorial] Permanenter Personalausweis/Dienstausweis - (V1+V2)

/*
Autor: Felix von Studsinske
Dateiname: fn_persoRequest.sqf
Beschreibung:
Sucht in der DB nach Einträgen für den Personalausweis je nach Fraktion.

Sie dürfen meine Funktionen/Scripte nur mit der "License-FvS.txt" nutzen sowie der Einhaltung der Regeln.
Im Missionshauptverzeichnis oder in einem leicht zu findenen Ordner muss die "License-FvS.txt" vorhanden sein!
Beispiel-Pfad:
Altis_Life.Altis\License-FvS.txt
MyExampleMission.Altis\License-FvS.txt
You are only allowed to use my scripts/functions with my littly "License-FvS.txt" and the agreements to the rules.
The "License-FvS.txt" has to be in your mission root folder or in an easy to finding folder
Destination example:
Altis_Life.Altis\License-FvS.txt
MyExampleMission.Altis\License-FvS.txt
*/
params [
["_uid","",[""]],
["_side",sideUnknown,[sideUnknown]],
["_player",objNull,[objNull]]
];

if(isNull _player) exitWith {}; // Gibt's nicht

_query = switch(_side) do
{
case west:
{
format["requestPersoWest:%1",_uid];
};
case independent:
{
format["requestPersoIndependent:%1",_uid];
};
case civilian:
{
format["requestPersoCivilian:%1",_uid];
};
//case east:
//{
// format["requestPersoEast:%1",_uid];
//};
};

_queryResult = [_query,2] call DB_fnc_asyncCall;

if(count _queryResult == 0 _queryResult isEqualTo []) exitWith {
_query_2 = format["insertPerso:%1",_uid];
[_query_2,1] call DB_fnc_asyncCall;
[] remoteExecCall ["fvs_fnc_persoNeu",(owner _player)];
};
_result = ((_queryResult select 0)select 0);
_ergebnis = [_result] call DB_fnc_mresToArray;
[_ergebnis] remoteExecCall ["fvs_fnc_persoErgebnis",(owner _player)];

-- ----------------------------
-- Table structure for `perso`
-- ----------------------------
DROP TABLE IF EXISTS `perso`;
CREATE TABLE `perso` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`pid` varchar(50) NOT NULL DEFAULT '',
`persoCop` text NOT NULL,
`persoMed` text NOT NULL,
`persoCiv` text NOT NULL,
`Erstellungsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`Aenderungsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`,`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of perso
-- ----------------------------
INSERT INTO `perso` VALUES ('4', '76561198042173943', '[]', '[]', '\"[`Günther Gundula`,`64`,`M`,`A`,`Kleine Felswand`,`76942173943`,`Gü[email protected]`,`170`,`55`,`1`,`1`,`1950`,`39071`,`0`,`1`]\"', '2016-10-21 16:14:34', '2016-10-21 16:14:41');

;; Version 4.1
;;
;; Status: im Lifebetrieb
;;
;; Stand: 01.11.2015
;;
;; Beschreibung: Konfiguration @extDB2 (Altis Life 4.0 ;; tauglich
;;
;; Entwickler: Media (Xylometachlorid) von Berlin Life
;; Kontakt: [email protected]

[Default]
Version = 12

Number of Inputs = 0

Sanitize Input Value Check = false
Sanitize Output Value Check = false

Prepared Statement Cache = true

Return InsertID = false

Strip = true
Strip Chars Action = STRIP
Strip Chars = /\|;{}<>'`
Strip Custom Chars = \/\|;{}<>'`

;; INPUT / OUTPUT Options
;; String (Removes " from value, then wraps value with ")
;; BeGUID (Converts value into BEGUID)
;; Check (Sanitize value check)
;; NoCheck
;; Strip (Strips Chars)
;; NoStrip
;;______________________________________________________________
[resetLifeVehicles]
;;

SQL1_1 = CALL resetLifeVehicles;

Number of Inputs = 0
Prepared Statement Cache = false

;;______________________________________________________________
[deleteDeadVehicles]
;;

SQL1_1 = CALL deleteDeadVehicles;

Number of Inputs = 0
Prepared Statement Cache = false

;;______________________________________________________________
[deleteOldHouses]
;;

SQL1_1 = CALL deleteOldHouses;

Number of Inputs = 0
Prepared Statement Cache = false

;;______________________________________________________________
[deleteOldGangs]
;;

SQL1_1 = CALL deleteOldGangs;

Number of Inputs = 0
Prepared Statement Cache = false

;;**************************************************************
;;**************************************************************
;; GANGS
;;

;;______________________________________________________________
[gangIDPlayer]
;;

SQL1_1 = SELECT id FROM gangs WHERE members LIKE ? AND active='1';

Number of Inputs = 1
SQL1_INPUTS = 1

;;______________________________________________________________
[gangNameSelectID]
;;

SQL1_1 = SELECT id FROM gangs WHERE name=? AND active=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[gangOwnerSelectID]
;;

SQL1_1 = SELECT id FROM gangs WHERE owner=? AND active=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[gangInsert]
;;

SQL1_1 = INSERT INTO gangs (owner, name, members) VALUES(?,?,?);
SQL1_INPUTS = 1, 2, 3

Number of Inputs = 3

;;______________________________________________________________
[gangUpdate]
;;

SQL1_1 = UPDATE gangs SET active=1, owner=?,members=? WHERE id=?;

Number of Inputs = 3
SQL1_INPUTS = 1, 2, 3

;;______________________________________________________________
[gangRemove]
;;

SQL1_1 = UPDATE gangs SET active='0' WHERE id=?;
SQL1_INPUTS = 1

Number of Inputs = 1

;;______________________________________________________________
[gangInfo]
;; Get Gang Info
;;

SQL1_1 = SELECT id, owner, name, maxmembers, bank, members FROM gangs WHERE active='1' AND members LIKE ?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1, 2-String, 3-String, 4, 5, 6

;;______________________________________________________________
[gangBankInfoUpdate]
;; Update Gang Bank
;;

SQL1_1 = UPDATE gangs SET bank=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[gangInfoUpdate]
;; Update Gang Info
;;

SQL1_1 = UPDATE gangs SET bank=?, maxmembers=?, owner=? WHERE id=?;
SQL1_INPUTS = 1, 2, 3-String, 4

Number of Inputs = 4

;;______________________________________________________________
[gangMaxMembersUpdate]
;; Update Gang Max Members
;;

SQL1_1 = UPDATE gangs SET maxmembers=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[gangMembersUpdate]
;; Update Gang Members
;;

SQL1_1 = UPDATE gangs SET members=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[gangOwnerUpdate]
;; Update Gang Owner
;;

SQL1_1 = UPDATE gangs SET owner=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;**************************************************************
;;**************************************************************
;; PLAYERS
;;

;;______________________________________________________________
[playerInfo]
;;

SQL1_1 = SELECT playerid, name FROM players WHERE playerid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1, 2

;;______________________________________________________________
[requestPersoWest]
;;

SQL1_1 = SELECT persoCop FROM perso WHERE pid=?;
SQL1_INPUTS = 1

OUTPUT = 1-string

;;______________________________________________________________
[requestPersoCivilian]
;;

SQL1_1 = SELECT persoCiv FROM perso WHERE pid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-string

;;______________________________________________________________
[requestPersoIndependent]
;;

SQL1_1 = SELECT persoMed FROM perso WHERE pid=?;
SQL1_INPUTS = 1

OUTPUT = 1-string

;;______________________________________________________________
[updatePersoCivilian]
;;

SQL1_1 = UPDATE perso SET persoCiv=? WHERE pid=?

Number of Inputs = 2
SQL1_INPUTS = 2,1

;;______________________________________________________________
[updatePersoWest]
;;

SQL1_1 = UPDATE perso SET persoCop=? WHERE pid=?
SQL1_INPUTS = 2,1

;;______________________________________________________________
[updatePersoIndependent]
;;

SQL1_1 = UPDATE perso SET persoMed=? WHERE pid=?
SQL1_INPUTS = 2,1

;;______________________________________________________________
[playerInfoInsert]
;;

SQL1_1 = INSERT INTO players
;;1 2 3 4 5 6 7 8 9 10 11
SQL1_2 = (playerid, name, cash, bankacc, westcash, westbankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear)
SQL1_3 = VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?);

SQL1_INPUTS = 1, 2-String, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13

Number of Inputs = 13

;;______________________________________________________________
[insertPerso]
SQL1_1 = INSERT INTO perso(pid, persoCop, persoMed, persoCiv) VALUES (?,'[]','[]','[]');

Number of Inputs = 1
SQL1_INPUTS = 1

;;______________________________________________________________
[playerWestInfo]
;;

SQL1_1 = SELECT playerid, name, westcash, westbankacc, adminlevel, donatorlvl, cop_licenses, coplevel, cop_gear, blacklist FROM players WHERE playerid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4, 5-String, 6-String, 7, 8-String, 9, 10

;;______________________________________________________________
[playerCivInfo]
;;

SQL1_1 = SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear FROM players WHERE playerid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4, 5-String, 6-String, 7, 8-String, 9

;;______________________________________________________________
[playerIndependentInfo]
;;

SQL1_1 = SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, med_licenses, mediclevel, med_gear FROM players WHERE playerid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4, 5-String, 6-String, 7, 8-String, 9

;;______________________________________________________________
[playerWestUpdate]
;;

SQL1_1 = UPDATE players
;;1 2 3 4 5 6
SQL1_2 = SET name=?, westcash=?, westbankacc=?, cop_gear=?, cop_licenses=? WHERE playerid=?

SQL1_INPUTS = 1-String, 2, 3, 4, 5, 6

Number of Inputs = 6

;;______________________________________________________________
[playerCivilianUpdate]
;;

SQL1_1 = UPDATE players
;;1 2 3 4 5 6 7
SQL1_2 = SET name=?, cash=?, bankacc=?, civ_licenses=?, civ_gear=?, arrested=? WHERE playerid=?;

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

Number of Inputs = 7

;;______________________________________________________________
[playerIndependentUpdate]
;;

SQL1_1 = UPDATE players
;;1 2 3 4 5 6
SQL1_2 = SET name=?, cash=?, bankacc=?, med_licenses=?, med_gear=? WHERE playerid=?;

SQL1_INPUTS = 1-String, 2, 3, 4, 5, 6

Number of Inputs = 6

;;______________________________________________________________
[playerUpdateCash]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET cash=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerWestUpdateBank]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET westbankacc=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[playerUpdateBank]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET bankacc=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateBank+Cash]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET cash=?, bankacc=? WHERE playerid=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;______________________________________________________________
[playerWestUpdateBank+Cash]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET westcash=?, westbankacc=? WHERE playerid=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;______________________________________________________________
[playerUpdateCopLicense]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET cop_licenses=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateCivLicense]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET civ_licenses=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateMedLicense]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET med_licenses=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateCopGear]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET cop_gear=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateCivGear]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET civ_gear=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateMedGear]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET med_gear=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateAlive]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET alive=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateArrested]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET arrested=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;**************************************************************
;;**************************************************************
;; VEHICLES
;;

;;______________________________________________________________
[vehicleDead]
;;

SQL1_1 = UPDATE vehicles SET alive=? WHERE pid=? AND plate=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;______________________________________________________________
[vehicleInsert]
;;

SQL1_1 = INSERT INTO vehicles
;;1 2 3 4 5 6 7 8 9
SQL1_2 = (side, classname, type, pid, alive, active, inventory, color, plate)
SQL1_3 = VALUES (?,?,?,?,?,?,?,?,?);

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

;;______________________________________________________________
[vehicleInfo]
;;

;;1 2 3 4 5 6 7 8 9
SQL1_1 = SELECT id, side, classname, type, pid, alive, active, plate, color
SQL1_2 = FROM vehicles WHERE id=? AND pid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2

OUTPUT = 1, 2-String, 3-String, 4-String, 5-String, 6, 7, 8, 9

;;______________________________________________________________
[vehiclesInfo]
;;

;;1 2 3 4 5 6 7 8 9
SQL1_1 = SELECT id, side, classname, type, pid, alive, active, plate, color
SQL1_2 = FROM vehicles WHERE pid=? AND alive=1 AND active = 0 AND side=? AND type=?;
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

OUTPUT = 1, 2-String, 3-String, 4-String, 5-String, 6, 7, 8, 9

;;______________________________________________________________
[vehicleUpdateActive]
;;

SQL1_1 = UPDATE vehicles SET active=? WHERE pid=? AND id=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;______________________________________________________________
[vehicleUpdateActivePlate]
;;

SQL1_1 = UPDATE vehicles SET active=? WHERE pid=? AND plate=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;______________________________________________________________
[vehicleUpdateAlive]
;;

SQL1_1 = UPDATE vehicles SET alive=? WHERE pid=? AND id=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;______________________________________________________________
[vehicleUpdateAlivePlate]
;;

SQL1_1 = UPDATE vehicles SET alive=? WHERE pid=? AND plate=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;**************************************************************
;;**************************************************************
;; Wanted System
;;

;;______________________________________________________________
[housingCount]
;;

SQL1_1 = SELECT COUNT(*) FROM houses WHERE owned='1';

Number of Inputs = 0

;;______________________________________________________________
[housingInit]
;;

SQL1_1 = SELECT houses.id, houses.pid, houses.pos, players.name FROM houses INNER JOIN players ON houses.pid=players.playerid WHERE houses.owned='1' LIMIT ?,10;

SQL1_INPUTS = 1
Number of Inputs = 1

OUTPUT = 1, 2-String, 3-String, 4-String

;;______________________________________________________________
[housingFetchPlayerHouse]
;;
SQL1_1 = SELECT pid, pos, inventory, containers FROM houses WHERE pid=? AND owned='1';

SQL1_INPUTS = 1
Number of Inputs = 1

OUTPUT = 1-String, 2-String, 3, 4

;;______________________________________________________________
[housingCheckHouse]
;;

SQL1_1 = SELECT CASE
SQL1_2 = WHEN EXISTS(SELECT id FROM houses WHERE pos=? AND owned='1')
SQL1_3 = THEN 'false' ELSE 'true'
SQL1_4 = END

SQL1_INPUTS = 1
Number of Inputs = 1

OUTPUT = 1

;;______________________________________________________________
[housingAddHouse]
;;
SQL1_1 = INSERT INTO houses (pid, pos, inventory, containers, owned)
SQL1_2 = VALUES(?,?,?,?,?);
SQL1_INPUTS = 1, 2, 3, 4, 5
SQL2_1 = SELECT id FROM houses WHERE pos=? AND pid=? AND owned='1';
SQL2_INPUTS = 2, 1

Number of Inputs = 5
OUTPUT = 1

;;______________________________________________________________
[housingSellHouse]
;;
SQL1_1 = UPDATE houses SET owned='0', pos='[]', inventory='[[],0]', containers='[]' WHERE pid=? AND pos=? AND owned='1';
SQL1_INPUTS = 1, 2, 3

Number of Inputs = 3

;;______________________________________________________________
[housingSellHouse2]
;;
SQL1_1 = UPDATE houses SET owned='0', pos='[]', inventory='[[],0]', containers='[]' WHERE id=?;
SQL1_INPUTS = 1

Number of Inputs = 1

;;______________________________________________________________
[houseUpdateContainer]
;;
SQL1_1 = UPDATE houses SET containers=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[housingUpdateInventory]
;;
SQL1_1 = UPDATE houses SET inventory=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[housingCleanup]
;;
SQL1_1 = SELECT pid, pos, inventory, containers FROM houses WHERE pid=? AND owned='1';
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4

;;**************************************************************
;;**************************************************************
;; Wanted System
;;

;;______________________________________________________________
[wantedGetCrimes]
;;

SQL1_1 = SELECT wantedID, wantedCrimes FROM wanted WHERE wantedID=?;

SQL1_INPUTS = 1
Number of Inputs = 1

OUTPUT = 1-String, 2

;;______________________________________________________________
[wantedUpdateCrimes]
;;

SQL1_1 = UPDATE wanted SET wantedCrimes = ?, wantedBounty = wantedBounty + ?, active = '1' WHERE wantedID=?;
SQL1_INPUTS = 1, 2, 3

Number of Inputs = 3

;;______________________________________________________________
[wantedInsertCrimes]
;;

SQL1_1 = INSERT INTO wanted (wantedID, wantedName, wantedCrimes, wantedBounty, active)
SQL1_2 = VALUES(?,?,?,?,?);

SQL1_INPUTS = 1, 2, 3, 4, 5

Number of Inputs = 5

;;______________________________________________________________
[wantedFetchBounty]
;;

SQL1_1 = SELECT wantedID, wantedName, wantedCrimes, wantedBounty FROM wanted WHERE active='1' AND wantedID=?;
SQL1_INPUTS = 1

Number of Inputs = 1

OUTPUT = 1-String, 2-String, 3, 4

;;______________________________________________________________
[wantedFetchCrimes]
;;

SQL1_1 = SELECT wantedCrimes, wantedBounty FROM wanted WHERE active='1' AND wantedID=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1, 2

;;______________________________________________________________
[wantedFetchID]
;;

SQL1_1 = SELECT wantedID, wantedName FROM wanted WHERE active='1' AND wantedID in (?);
SQL1_INPUTS = 1-STRIP

Number of Inputs = 1
OUTPUT = 1-String, 2-String

;;______________________________________________________________
[wantedFetchPerson]
;;

SQL1_1 = SELECT wantedID, wantedName, wantedBounty FROM wanted WHERE wantedID=? AND active='1';
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3

;;______________________________________________________________
[wantedFetchName]
;;

SQL1_1 = SELECT wantedName FROM wanted WHERE wantedID=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String

;;______________________________________________________________
[wantedFetchIDAll]
;;

SQL1_1 = SELECT wantedID, wantedName FROM wanted WHERE active='1';

OUTPUT = 1-String, 2-String
;;______________________________________________________________
[wantedUpdateName]
;;

SQL1_1 = UPDATE wanted
SQL1_2 =SET wantedName=? WHERE wantedID=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[wantedRemoveCrimes]
;;

SQL1_1 = UPDATE wanted
SQL1_2 =SET active = 0, wantedCrimes = '[]', wantedBounty = 0 WHERE wantedID=?;
SQL1_INPUTS = 1

Number of Inputs = 1

;;______________________________________________________________
[DYNMARKET_Price_Set]
;;
SQL1_1 = UPDATE dynmarket SET prices = ? WHERE id=1;
SQL1_INPUTS = 1
Number of Inputs = 1
;;______________________________________________________________
[DYNMARKET_Price_Get]
;;
SQL1_1 = SELECT prices FROM dynmarket WHERE id=1;
OUTPUT = 1

[requestPersoCivilian]
;;

SQL1_1 = SELECT persoCiv FROM perso WHERE pid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-string

;;______________________________________________________________
[updatePersoCivilian]
;;

SQL1_1 = UPDATE perso SET persoCiv=? WHERE pid=?

Number of Inputs = 2
SQL1_INPUTS = 2,1

;;______________________________________________________________
[insertPerso]
SQL1_1 = INSERT INTO perso(pid, persoCop, persoMed, persoCiv) VALUES (?,'[]','[]','[]');

Number of Inputs = 1
SQL1_INPUTS = 1

;;______________________________________________________________