Jump to content

RanGo

Members
  • Posts

    8
  • Joined

  • Last visited

Everything posted by RanGo

  1. A few days ago I was trying to create a life_job variable to collect career data. //---configuration.sqf----/// life_job = 'UNEMPLOYED'; /------------------------------/ /------------------------------/ When I request to join any job, the life_job variable will change accordingly /------------------------------/ And I tried to make the life_job save to the database by doing this. //---\life_server\Functions\MySQL\fn_queryRequest.sqf----/// I add _query = switch (_side) do { // West - 12 entries returned case west: {format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, cop_licenses, coplevel, cop_gear, blacklist, cop_stats, playtime, debit, job_cop FROM players WHERE pid='%1'",_uid];}; // Civilian - 13 entries returned case civilian: {format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime, debit, job_civ FROM players WHERE pid='%1'",_uid];}; // Independent - 11 entries returned case independent: {format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, med_licenses, mediclevel, med_gear, med_stats, playtime, debit, job_medic FROM players WHERE pid='%1'",_uid];}; }; /------------------------------/ //---\MissionFile\Core\session\fn_requestReceived.sqf----/// I add life_job in switch (playerSide) case west: { life_job = _this select 13; }; case civilian: { life_job = _this select 14; }; case independent: { life_job = _this select 12; }; }; /------------------------------/ //---\MissionFile\Core\session\fn_updatePartial.sqf----/// I add new case case 9: { _packet set[2,life_job]; }; /------------------------------/ This is a sample join Job file. This is database Thanks in advance. I'm not very good at languages. I use google translate.🥰
  2. RanGo

    extdb3 download help

    Yํou can try this https://github.com/SteezCram/extDB3 I don't know It's working?
  3. A few days ago I was trying to create a life_job variable to collect career data. //---configuration.sqf----/// life_job = 'UNEMPLOYED'; /------------------------------/ /------------------------------/ When I request to join any job, the life_job variable will change accordingly /------------------------------/ And I tried to make the life_job save to the database by doing this. //---\life_server\Functions\MySQL\fn_queryRequest.sqf----/// I add _query = switch (_side) do { // West - 12 entries returned case west: {format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, cop_licenses, coplevel, cop_gear, blacklist, cop_stats, playtime, debit, job_cop FROM players WHERE pid='%1'",_uid];}; // Civilian - 13 entries returned case civilian: {format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime, debit, job_civ FROM players WHERE pid='%1'",_uid];}; // Independent - 11 entries returned case independent: {format ["SELECT pid, name, cash, bankacc, adminlevel, donorlevel, med_licenses, mediclevel, med_gear, med_stats, playtime, debit, job_medic FROM players WHERE pid='%1'",_uid];}; }; /------------------------------/ //---\MissionFile\Core\session\fn_requestReceived.sqf----/// I add life_job in switch (playerSide) case west: { life_job = _this select 13; }; case civilian: { life_job = _this select 14; }; case independent: { life_job = _this select 12; }; }; /------------------------------/ //---\MissionFile\Core\session\fn_updatePartial.sqf----/// I add new case case 9: { _packet set[2,life_job]; }; /------------------------------/ This is a sample join Job file. This is database Thanks in advance. I'm not very good at languages. I use google translate.🥰
  4. arma3server_2021-06-17_20-53-46.rpt Scripting function 'ton_fnc_firstexperince' is not allowed to be remotely executed
  5. I'm not sure if I'm doing anything wrong, but the level and exp or all of the data is not saved to the database at all.😊
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.