Silentsean14

Would you be willing to share the fixed class? :)

I'm thinking about getting a dedi for arma 3, would anyone be able to clarify what sort of spec would be required to run it? It would only be running one instance of arma 3 of about 50 slots Cheers

The problem is that it's returning unwanted characters that shouldn't even be in there, and are not in the database

Yeah Ive done that, http://pastebin.com/ekST5GuB

The variable type also happens to be a string and not an array, so it doesn't work when I try this. Appreciate the help though! :)

I managed to get it working now :) Only thing is, it's returning the playerid from the database as [[["78436529386389"]]] for some odd reason, is there a way to remove the [[[" and "]]] so that the id is just a number?

That's the part I don't understand, I've been telling it to wait until it's not nil.. Yet it seems to continue on even though it is nil

Yeah, I've found out that "_pid" is coming up nil every time. I have no idea why this is happening :(

I changed the query/command to: _query = format["SELECT pid FROM instructors WHERE pid='%1'", _pid]; _verifyUser = "Arma2Net.Unmanaged" callExtension format ["Arma2NETMySQLCommand ['training', '%1']", _query]; And still gives the same error as before for some reason

Yeah, I've looked through it. I'm trying to run it like this: http://pastebin.com/ZFDXVnhi

Yeah, it does have the quote. It's just not picking it up for some reason.. This is the query: _query = format["SELECT * FROM instructors WHERE pid='%1'", _pid];

Hey firefly, I get an error when I try to pass a variable from Arma 3 into a query, done the same way as your example mission using the "format" command. This is the error from the log: Info: 16:28:58 - Received - Database: training SQL Query: SELECT * FROM instructors WHERE pid=' Warning: 16:28:58 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at Arma2NETMySQLPlugin.MySQL.RunOnDatabase(MySqlCommand command, Int32 maxResultSize)

Yeah, I can get it to show up when any key is pressed, just not key specific

Yeah, Ive been trying stuff similar to that. But nothing seems to happen for some reason, I'm pretty new to scripting etc xD

Awesome script! Is if possible however, to have it be able to open/close via a key bind instead of addaction?