Clone wiki

Arma2Net mysql / Home

===================================================
======== ATTENTION !!!!!!!!!!!!!!!!!!!!!!! ========
===================================================
!! This Wikipages are currently work in progress !! 
!! Current content relies on version 0.8.0.0 !!
!! Tested with Arma2Net V 1.9 !!
!! Lot of Syntax changes !!

Welcome to Arma2mysql

Arma2mysql is an addin for the Arma2Net project also hosted on bitbucket.org by Scott_NZ .
This addin will allow you to connect to a MySQL database and execute SQL-Statements against it within Arma2.

Preface

This wiki won't show you how to set up a database server and the database. So you should know how install and configure it. This addin is for the open source MySQL database engine => http://mysql.com/

Installation

At this time, Arma2Net is based on a function witch is only available in a beta version of Arma2OA (Arma 2 beta version 87640 or later). So read the installation instructions from Arma2Net carefully!
Beta downloads are available here => http://www.arma2.com/beta-patch.php

  1. Install Arma2Net from here => https://bitbucket.org/Scott_NZ/arma2net/downloads
  2. Install the MySQL .Net-Connector => http://dev.mysql.com/downloads/connector/net/
  3. Donwnload the latest "Arma2Net_MySqlPlugin_VX_X.zip" and extract the content to your Arma2 folder.
  4. Add -arma2netdev to the command line, where you start Arma2. See Known Problems

Known Problems

You have to add -arma2netdev to the command line for starting Arma2. If you omit this parameter you will get Exceptions while trying to open a database connection and trying to get help information's.
Background:
I can not sign the library with the same key as the author (Scott_NZ ) of Arma2Net does. So all this unsigned/wrong signed addins will be sandboxed by Arma2Net and don't allow the plugin access to the file system and the network resources. But this addin needs read access to the file system (for reading help files) and read/write access to the network while communicating with the database engine.

Working with Arma2mysql

Within Arma2 call

"Arma2Net.Unmanaged" callExtension "mysql [command,Parameter1,Parameter2,...]";

where
command = Function within the mysql addin
ParameterX = Additional parameter for the command. The type of the parameters can differ also the count of the parameter.

For details see Command Reference

Updated