• Beiträge von apple123

    • Fahrzeughandel (Autos an Spieler weiterverkaufen)

      i think

      Code
      _query = format ["UPDATE vehicles SET pid='%2' WHERE plate='%1' and pid ='%3' and type = '%4'", _plate,_uidnew,_uidold,_type]; 
has error
change to
_query = format ["UPDATE vehicles SET pid='%2' WHERE plate='%1' and pid ='%3' and classname = '%4'", _plate,_uidnew,_uidold,_type];

      8o

    • Simple whitelist (only allowed players to enter the game)

      Difficulty: Very simple

      Suitable for beginner

      fn_requestReceived.sqf

      find

      !isServer && (!isNil "life_adminlevel" || !isNil "life_coplevel" || !isNil "life_donorlevel")

      change it to

      !isServer && (!isNil "life_adminlevel" || !isNil "life_coplevel" || !isNil "life_donorlevel"|| !isNil "life_whitelist")

      then find

      CONST(life_coplevel,(_this select 7));

      Add code below it

      CONST(life_whitelist,(_this select 12));

      then find

      life_is_arrested = _this select 7;

      Add code below it

      CONST(life_whitelist,(_this select 13));

      then find

      CONST(life_medicLevel,(_this select 7));

      Add code below it

      CONST(life_whitelist,(_this select 11));

      then to

      fn_initciv.sqf

      add it:

      if((call life_whitelist) < 1) then {["NotWhitelistplayer",false,false] call BIS_fnc_endMission;};

      then to

      description.ext

      find

      class NotWhitelisted { title = "$STR_NotWhitelisted_Title"; subtitle = "$STR_NotWhitelisted_SubTitle"; description = "$STR_NotWhitelisted_Descript"; pictureBackground = ""; picture = ""; pictureColor[] = {0,0.3,0.6,1}; };

      Add code below it

      class NotWhitelistplayer { title = "You are not a whitelist player applied by the server, please contact the administrator"; subtitle = "You are not a whitelist player applied by the server, please contact the administrator"; description = "You are not a whitelist player applied by the server, please contact the administrator"; pictureBackground = ""; picture = ""; pictureColor[] = {0,0.3,0.6,1}; };

      then go to the life_server:

      find fn_queryRequest.sqf

      change it

      Code
      _query = switch (_side) do {
    // West - 11 entries returned
    case west: {format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, cop_licenses, coplevel, cop_gear, blacklist, cop_stats, playtime FROM players WHERE pid='%1'",_uid];};
    // Civilian - 12 entries returned
    case civilian: {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];};
    // Independent - 10 entries returned
    case independent: {format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, med_licenses, mediclevel, med_gear, med_stats, playtime FROM players WHERE pid='%1'",_uid];};
};

      to

      Code
      _query = switch (_side) do {
    // West - 11 entries returned
    case west: {format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, cop_licenses, coplevel, cop_gear, blacklist, cop_stats, playtime, whitelist FROM players WHERE pid='%1'",_uid];};
    // Civilian - 12 entries returned
    case civilian: {format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime, whitelist FROM players WHERE pid='%1'",_uid];};
    // Independent - 10 entries returned
    case independent: {format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, med_licenses, mediclevel, med_gear, med_stats, playtime, whitelist FROM players WHERE pid='%1'",_uid];};
};

      at last you should add this to sql -> players

      `whitelist` ENUM('0','1') NOT NULL DEFAULT '0',

      If you change the value of whitelist to 1, players can enter, otherwise they cannot enter, that's it! :)

    • i need help plz.about gangs

      Zitat von apple123

    • i need help plz.about gangs

      Zitat von apple123

    • i need help plz.about gangs

      I encountered a very important problem that caused me a headache. When a player invited another player and accepted, members returned an empty array, but I debugged gang_members (hint str group player getVariable "gang_members") after debugging The array format is displayed normally, but the database displays []. This causes the player to drop the team after restarting the server or retreating the game, any help is greatly appreciated!dashdashdash

    • Willkommensnachricht nach dem Spawn

      Try here, the script posted by the author has some punctuation errors, I have modified it.


      welcome.sqf

    • How to read the database contents on the server

      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.

    • How to read the database contents on the server

      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.

    • 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

    • Ask for help from the Chief of Police to issue rankings!

      fn_makecop.sqf

      fn_changeFractionDone.sqf

      fn_setupaction.sqf

      player addAction["<t color='#002aff'>give cop licenses</t>",fn_makecop,"",0,false,false,"",' !isNull cursorObject && {player distance cursorObject < 3.5} && {isPlayer cursorObject} && {alive cursorObject} && {cursorObject isKindOf "Man"} && life_coplevel > 27 && !life_fractionInUse'];

      then in functions.hpp

      and server

      fn_changeFraction.sqf

      and then in config.cpp

      The principle is that after issuing the certificate through the police chief, the player released by the wheel will immediately exit the game and get a level 1 police officer.

      But I don't know where the problem is, did not execute to the server and execute the mysql function.

      Any help, thanks!

      :)