[Questions] Regarding MySQL saving system

[Col. Ben Sherman 3]

Hi there,

First of I'd like to start with to thank Bohemia Interactive for this fantastic community. I've been working on a game server for a while now and manage to get most things to work and some of my friends told me that it would be more useful to have a save system insted of starting from the begining. I've read about CLServer2Lib but I don't understand a clue at all about it.

I just wonder if there is anyone here that can help me out with a save sytem for "items, vehicles, licenses, etc" I'm even willing to pay for this, don't know if that's against the rules to say so, if that is I'm sorry about that and apologize but this is the only place I know there are good scripters that knows what they are doing and I'm not.

If you are intersted and know things about it either PM me or contact else where and we can discuss this more private.

-Sincerely,

Staffan.

Email: owner[at]everest-community.net

Skype: everest.community

[mikie boy 18]

look at Arma2net and Arma2netMySQLplugin -

easy when you have a good look through. buy yourself a cheap and simplistic book on SQL. (i bought SQL in easy steps)

tear apart the Arma2netmysql demo mission - save weapon script. - and compare the info in the above book to how they made the sql scripts

look at XAMPP and how to set up a server - again loads of tutorials - this one is brilliant

http://www.webassist.com/support/documentation/how-tos/xampp_for_windows.php

much like yourself i wanted to know and wasnt really getting anywhere by simply messing. spent a weekend on it and now ive created a reasonable method of saving anything you want.

Asking people to assist through payment may work but when you need things doing - you will only need to pay more :)

[Col. Ben Sherman 3]

look at Arma2net and Arma2netMySQLplugin -

easy when you have a good look through. buy yourself a cheap and simplistic book on SQL. (i bought SQL in easy steps)

tear apart the Arma2netmysql demo mission - save weapon script. - and compare the info in the above book to how they made the sql scripts

look at XAMPP and how to set up a server - again loads of tutorials - this one is brilliant

http://www.webassist.com/support/documentation/how-tos/xampp_for_windows.php

much like yourself i wanted to know and wasnt really getting anywhere by simply messing. spent a weekend on it and now ive created a reasonable method of saving anything you want.

Asking people to assist through payment may work but when you need things doing - you will only need to pay more :)

Thank you Mikie boy,

I have already alot of experience regarding MySQL, I'm working as a website developer.

I have looked in to Arma2net a few times already but I'm not quite understanding it, when I build the DLL file for it or what I'm building do I need to make a call back or something for my scripts to gather the info from the datorbase or how does it work?

Simple way would be if someone could give me a few tips or a guide on how it works, I've already downloaded a script which is runing with MySQL saving system, but I seem to never find out in any parts of the script how it calls for the values from the datorbase.

Sincerely,

Staffan

[mikie boy 18]

use Arma2netMysqlplugin

thats the easiest way - no need to build any dll - its all done sqf side

https://github.com/firefly2442/Arma2NETMySQLPlugin

download mission - and look at how the functions are called - they use a global CBA method to send and receive. https://github.com/firefly2442/Arma2NetMySQLPlugin-ExampleMission

and look through this forum - http://forums.bistudio.com/showthread.php?128795-Arma2MySQL

hope thats some more help

[Col. Ben Sherman 3]

use Arma2netMysqlplugin

thats the easiest way - no need to build any dll - its all done sqf side

https://github.com/firefly2442/Arma2NETMySQLPlugin

download mission - and look at how the functions are called - they use a global CBA method to send and receive. https://github.com/firefly2442/Arma2NetMySQLPlugin-ExampleMission

and look through this forum - http://forums.bistudio.com/showthread.php?128795-Arma2MySQL

hope thats some more help

Thank you for the help, but some how when I try to rebuild the Arma2NETMySQLPlugin i just get alot of erros missing references, tried to get them online but it says that SqLite is missing just when I rebuild it nothing else, some how I can't figure it. Maybe some one else in here can do help me out with it?

Warning	3	The primary reference "System.Data.SQLite" could not be resolved because it was built against the ".NETFramework,Version=v4.5" framework. This is a higher version than the currently targeted framework ".NETFramework,Version=v4.0".	Arma2NETMySQLPlugin
Error	1	The type or namespace name 'SQLite' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)	C:\Users\Staffan\Desktop\Dev\Arma2NETMySQLPlugin-master\Arma2NETMySQLPlugin\SQLite.cs	21	19	Arma2NETMySQLPlugin
Error	2	The type or namespace name 'SQLiteConnection' could not be found (are you missing a using directive or an assembly reference?)	C:\Users\Staffan\Desktop\Dev\Arma2NETMySQLPlugin-master\Arma2NETMySQLPlugin\SQLite.cs	29	17	Arma2NETMySQLPlugin

[firefly2442 6]

When you open up the Visual Studio project, the references need to point to the "MySql.Data.dll" and "System.Data.SQLite.dll" files. These are from the dependencies. See the readme.html file for details.

[killzone_kid 1329]

Staffan. Have a look here: https://github.com/ShadowDuke/Saintly

Best plugin for MySql I ever used. It allows you to call functions in your database. If you know mySql as you said you can easily make functions and just call them with this extension. To see the examples of how it is used, look through this code: https://github.com/ShadowDuke/Saintly-DayZ

[shinkicker 5]

Does anyone know if any mysql adapters have been ported to Arma 3 yet?

[mikie boy 18]

Using mysqlplugin and arma2net work on arma3

[shinkicker 5]

Using mysqlplugin and arma2net work on arma3

Hmm, I have @Arma2NET installed in the root of Arma 3. I launch with -mod=@Arma2NET and there is not diddly squat to be seen anywhere. The only mention of Arma2NET in the RPT files is the launch parameter.

What version are you using Mikie boy? I have 2.3

Edited May 12, 2013 by shinkicker

[firefly2442 6]

Thanks. It looks like firefly2442 has deleted his github repos. Did anyone get a fork prior to the removal?

I didn't delete it. It was an issue with Github. Should be back online now.

Edited May 12, 2013 by firefly2442