Arma2MySQL

[armatech]

might be good practice to return the mysql error

[firefly2442]

I think it should show up in the log file. I didn't think it would be helpful on the Arma side.

[guruabdul]

One question to you firefly. Why is the new addon returning multiple rows as a single array, this seems to be not intended and worked diffrently in previous versions. Is this a bug or just a design of the new addon (Why double arrays then?)?
Thanks for the addon anyway, great work!

[firefly2442]

Are you referring to differences between the original application:

https://dev-heaven.net/projects/arma2-mysql

and the new one:

https://github.com/firefly2442/Arma2NETMySQLPlugin

? If so, then it relates to the processing that was required on the SQF scripting side in order to turn the string into an array of arrays. Now, it's returning the result through Arma2NET. I'm unaware if I can return an array of arrays in Arma2NET. I'll ask.

[guruabdul]

I think I'm refering to the changes between the new one (I use the one from the Persistentdb package its 0.1.0.0? and Arma2NET 1.11 I think) and the previous one that was working on Arma2NET 1.9. If I do a SELECT and it returns multiple rows your addin used to return a string "[[row1],[row2],[row3]...[rown]]", which you could then compile and use in the sqf as an array of arrays, but now it returns data like this "[[row1,row2,row3...rown]]". So the way to access the columns for separate rows gets completly different as you have to iterate through the array of columns from each row [[r1column1,r1column2,r1column3,r2column1,r2column2, r2column3,....]]. If that's the new way of accessing the data then wouldnt it be better to just return "[row1,row2,...]", that's what makes me think it was unintentional. Hope I'm making some sense

[firefly2442]

Yep, makes sense. I'll take a look this weekend if I have some time.

[firefly2442]

Implemented code for returning a two-dimensional array but I'm getting a runtime error. Haven't had time to look at it closely but it's coming along.

[guruabdul]

Waiting impatiently... Kind of excited about the news

[firefly2442]

Well, pushed the changes. Now it should return an array of arrays back to Arma. I haven't tested it much so if anybody wants to be awesome and find the bugs that would be great. Thanks!

[guruabdul]

Well I'll try it out as soon as I download Visual Studio... or maybe is there some other way to compile your code?