Jump to content
Bohemia Interactive Forums

Marcel1802

Member
 View Profile  See their activity

  • Content Count

    15

  • Joined

  • Last visited

  • Medals

Posts posted by Marcel1802

  2. Posted

    Does anyone know if BI is still willing fix stuff or if the project is 'closed'?

    There are still some 'gamebreaking' bugs

     

    Spoiler

    The ending where you give the counter-agent to the insurgents is still broken.

    You can put the counter-agent into the blue van, but nothing happens.

     

    The ending & the achievements are inaccessable.

     

  7. Posted

    I had a problem with inserting data in my database and it inserted 'any' too.

     

    That was because if you execute a command on the server, you can't use the command 'player'.

    For example, if you execute (getPlayerUID player) on the server, the value will be empty because the server doesn't have a steamID.

    And if you try to execute (profileName), it will be 'arma3'.

     

    I gave each playable unit a variable name to solve the problem.

  8. Posted

    On 8.1.2018 at 5:32 PM, Marcel1802 said:

    I can connect the database and the server but it does not make any entries in the database

     

    Code:

     

    "extDB3" callExtension "9:ADD_DATABASE:ftpCoop"//connection to DB,   [ftpCoop] = name in extDB3-conf.ini

    "extDB3" callExtension "9:ADD_DATABASE_PROTOCOL:ftpCoop:SQL:SQL_QUERY"//saw that on the internet it works so it's ok

    //both works and gets executed in init.sqf

     

    "extDB3" callExtension format ["0:SQL_QUERY:INSERT INTO main (steamID, lastUsername) VALUES ('%1','%2')",(getPlayerUID player),(profileName)];

    //inserts playerUID (primary key in database) and last username in the database (and other things like date & time, [...]  automatically with CURRENT_TIMESTAMP and other standard values in the database itself)

    //doesn't work if the player is already in  the database, but it doesn't crash everything so it's ok
    "extDB3" callExtension format ["0:SQL_QUERY:UPDATE main SET steamID='%1', lastUsername='%2' WHERE steamID='%3'",(getPlayerUID player),(profileName),(getPlayerUID player)];

    //refreshes data in database

    //tried to execute it on different scripts e.g. onPlayerRespawn.sqf, init.sqf, initPlayerLocal.sqf and initPlayerServer.sqf

     

     

    If I execute the insertion command in the debug console, it only works if I execute it on the server (not local or global). Then the playerUID is empty and the name is 'arma3'.

    The last command doesn't cause any problems if I execute it in the debug console.

     

     

     

     

     

     

     

    found a way

     

    Made script which gets executed in the init.sqf

    In that script there is a infinite loop, first command is 'sleep 300;' so the server doesn't get killed

    I gave every unit a variable name, for example 'aaf1' for an aaf soldier

    Then I wrote that in in the loop:

     

    if(alive aaf1)then{"extDB3" callExtension format["0:SQL_QUERY:INSERT INTO tbl_coopServer (steamID,lastUsername) VALUES ('%1','%2') ON DUPLICATE KEY UPDATE lastTimeUpdate=CURRENT_TIMESTAMP()",(getPlayerUID aaf1),(name aaf1)];};

     

    It works perfectly

     

    I copied and changed the variable name for every unit

    There is a way with a forEach loop and _forEachIndex etc. but this way was easier

    I don't wanted to use 'format' for the if-command, so I copied everything.

  9. Posted

    I can connect the database and the server but it does not make any entries in the database

     

    Code:

     

    "extDB3" callExtension "9:ADD_DATABASE:ftpCoop"//connection to DB,   [ftpCoop] = name in extDB3-conf.ini

    "extDB3" callExtension "9:ADD_DATABASE_PROTOCOL:ftpCoop:SQL:SQL_QUERY"//saw that on the internet it works so it's ok

    //both works and gets executed in init.sqf

     

    "extDB3" callExtension format ["0:SQL_QUERY:INSERT INTO main (steamID, lastUsername) VALUES ('%1','%2')",(getPlayerUID player),(profileName)];

    //inserts playerUID (primary key in database) and last username in the database (and other things like date & time, [...]  automatically with CURRENT_TIMESTAMP and other standard values in the database itself)

    //doesn't work if the player is already in  the database, but it doesn't crash everything so it's ok
    "extDB3" callExtension format ["0:SQL_QUERY:UPDATE main SET steamID='%1', lastUsername='%2' WHERE steamID='%3'",(getPlayerUID player),(profileName),(getPlayerUID player)];

    //refreshes data in database

    //tried to execute it on different scripts e.g. onPlayerRespawn.sqf, init.sqf, initPlayerLocal.sqf and initPlayerServer.sqf

     

     

    If I execute the insertion command in the debug console, it only works if I execute it on the server (not local or global). Then the playerUID is empty and the name is 'arma3'.

    The last command doesn't cause any problems if I execute it in the debug console.

     

     

     

     

     

     

  11. Posted

    Trying to make a pilot restriction script which works in the same way

     

    My problem is that if I type 'typeOf player == "B_pilot_F";' into the debug console, it says 'false'.

    I am "B_soldier_F" it says.

     

    I placed "B_soldier_F" with the editor, but I am using the "new" respawn system where you can choose the class and respawn location while respawning. 

     

    (Example picture of the system from this forum)

     

    CfcfpeWWEAEXsfU.jpg:large

     

    Anyone has ideas?

    Thank you.

     

×