• How to read the database contents on the server

      I want to implement a script so that when a new player enters the game as a civilian, he must have the player's UID in a specific table in the database. Otherwise, the task ends. This is my script.

      Code: fn_initciv.sqf
      private _uid = getPlayerUID player;
if !(_uid in _whitelist)then{
["NotWhitelisted",false,true] call BIS_fnc_endMission;
};
[_whitelist] remoteExec ["DB_fnc_whitelist", 2];
      Code: pwhitelist.sql
      CREATE TABLE `pwhitelist` (
 `playerUID` VARCHAR(32) NULL DEFAULT NULL,
 `reason` VARCHAR(17) NULL DEFAULT NULL,
 PRIMARY KEY (`playerUID`)
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
      Code: whitelist.sqf
      //life_server
params [
["_whitelist","",[""]],
["_reason","",[""]]
];

      I don't know how to write next, so that I can add player UID to the database before players can play. This is similar to a whitelisting system, any help would be greatly appreciated!:D:D:D

      Hey,

      take a look at the fn_queryRequest.sqf:

      https://github.com/AsYetUntitled/…ueryRequest.sqf

      In these lines(31) you see the creation of the sql request:

      Code
      format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE pid='%1'",_uid];


      and here you send the query to the DB. For more informations about this, take a look at the header of the asyncCall function.

      Code
      _queryResult = [_query,2] call DB_fnc_asyncCall;

      In "_queryResult" you can find the result from the database.

      i know that,but I don't know how to make the server read the player uid so that whitelist is equal to the player uid in the database and runs at the same time as the server.

      OK,

      so, a way is to add the player over an webinterface or an extra programm. You need an html form with an little bit of php at the backend take an look here:

      https://www.w3schools.com/php/php_forms.asp and here https://www.cloudways.com/blog/connect-mysql-with-php/ you can also find a loot of tutorials an youtube. Also take a look at security that you can prevent an SQL Injection, you can also find a lot of tutorials on the internet.

      You can also do it from ingame. But isnt that good because you need to join on the server every time you would like to whitlist someone.

      Zitat von LETUS

      OK,

      so, a way is to add the player over an webinterface or an extra programm. You need an html form with an little bit of php at the backend take an look here:

      https://www.w3schools.com/php/php_forms.asp and here https://www.cloudways.com/blog/connect-mysql-with-php/ you can also find a loot of tutorials an youtube. Also take a look at security that you can prevent an SQL Injection, you can also find a lot of tutorials on the internet.

      You can also do it from ingame. But isnt that good because you need to join on the server every time you would like to whitlist someone.

      Sorry, you misunderstood me. I have created a new table "pwhitelist" in the database table. My idea is that only when I add the player's uid - "player uid", can the server read it, and then the client remoteexec arrives, the player can enter the game.

      Yeah, like in my first answer. You read the data from the database. When the response is empty, in extDB it lokes like this i think: [1, []] you can pass an error to the client and kick him from the Server.

      When you get any data(expect you got an error then you got no 1 at the first place) in the array( [1, ["My Player ID"]] the user is in the database so you can pass an success to the client over remoteExec.