Arma2Net - MySqlPlugin

[HeliJunkie]

Arma2NET MySqlPlugin
Current Version: 0.8.0.0 (05/30/2012)

Hello community!

This is a MySqlPlugin for Arma2Net.
So first, a thumb up to Scott_NZ for the great idea writing Arma2Net

With this plugin you are able to establish a connection to a MySql database and execute querys to it inside Arma2.
I think this will give a lot of new possibilities!

Dowload site: https://bitbucket.org/ubruns/arma2net-mysql/downloads
Wiki: https://bitbucket.org/ubruns/arma2net-mysql/wiki/Home (read installation instructions)
Command reference: https://bitbucket.org/ubruns/arma2ne.../wiki/Commands
Issue Tracker: https://bitbucket.org/ubruns/arma2net-mysql/issues

Happy SQL-ing !
HeliJunkie

Changelog see spoiler:
Spoiler:

show spoiler

V0.8.0.0:
+ Mutliple connections possible.
+ Result can extend the 4096 byte length (mutliple calls needed)
+ You can use a ConfigurationFile to seperate MySQL Connection data from mission. (more secure)
! Sytax changes
! Tested with Arma2Net V1.9

V0.5.0.0: Inital Version

[GossamerSolid]

Your wiki and command reference links require me to sign into a website.

Can't we just view the pages without signing in?

[.kju [PvPscene]]

Great stuff HeliJunkie and kudos to Scott

[Jsmuk]

Your wiki and command reference links require me to sign into a website.

Can't we just view the pages without signing in?

Even when logged in its not possible to see them, I think he has set the wiki to private.

[Jedra]

Maybe you could ask Sickboy for some space on DevHeaven? Would there be any plans in the future to support MSSQL Server? What with this and Java over on ToH the possibilities are becoming huge. I just need to think of an application to implement so I can learn it!

[HeliJunkie]

Your wiki and command reference links require me to sign into a website.

Can't we just view the pages without signing in?

Sorry!
Changed it to be public!

---------- Post added at 17:40 ---------- Previous post was at 17:36 ----------

Maybe you could ask Sickboy for some space on DevHeaven?

I prefer bitbucket.

Would there be any plans in the future to support MSSQL Server?

If there MSSQL is requested, I could write another plugin for MSSQL.

What with this and Java over on ToH the possibilities are becoming huge. I just need to think of an application to implement so I can learn it!

I don't own TOH.

[GossamerSolid]

What with this and Java over on ToH the possibilities are becoming huge. I just need to think of an application to implement so I can learn it!

Java should already have some built in database functionality with JDBC

http://www.oracle.com/technetwork/ja...dbc/index.html


Good work HeliJunkie, I'll probably be making use of this


EDIT: Just saw this piece of code

Result = call compile "Arma2Net.Unmanaged" callExtension "mysql [open, MyDBServer, Arma2DB, ArmaDBUser, MyPaSsWoRd]"
if ((Result select 0) == true) {
  hint("Connection successful");
} 
else {
  hint(formatText["Connection failed. Errorinformation:\n%1", Result select 1])
} 

Is it possible to let us use a configuration file alongside the database plugin so we don't have to put our authentication data in plain text within a script? It'd be very easy for somebody to download a mission, dePBO it and get our database auth.

[Jedra]

I don't own TOH.

Just a general comment - wasn't asking for a java plugin!

[HeliJunkie]

Is it possible to let us use a configuration file alongside the database plugin so we don't have to put our authentication data in plain text within a script? It'd be very easy for somebody to download a mission, dePBO it and get our database auth.

Planned for a future version.

But MYSQL can be set up to allow login only from a specific host. So nobody can connect to your database with the login credentials, if the login doesn't come from the defined host.

[GossamerSolid]

Planned for a future version.

But MYSQL can be set up to allow login only from a specifiy host. So nobody can connect to your database with the login credentials, if the login doesn't come from the defined host.

Good point, I overlook these things sometimes.