Here is a dll that permits to connect A6 with a MySQL database
Get it here

There is documentation and FULL source code (cause otherwise, you need to compile MySQL and mysql++ to get the libs)

I hope that you will find this usefull.
And feel free to send me a pm if this was usefull to you.
Destop

I have tried to use this in my project and I get:

Quote:

---

A6mysql.dll - no valid Acknex DLL

---

Here is what I do in main:

Code:

---

 function main()
{	
	ifdef server;
		mysql_handle = dll_open("A6mysql.dll");
	endif;

[snip] 

---

I actually hit this barrier writing my own mysql.dll and thought it was my dll creation skills. What am I doing wrong when trying to use this dll please?

A6 commercial - 6.31.4

Andy

Hmm ... I tried the DLL, too. I get the same error. And I have A6 Commercial 6.31.4, too.

I just checked the DLL I compiled on my own and I get the error message with that DLL, too.

Could it be, that the commercial version has a problem with loading DLLs?

Does the DLL work for some people?

Konrad

Ok - it was my fault. The a6mysql.dll works fine now. I just tried it without the mysql Libs available. After installing mysql on my computer, the dll could be loaded without problems.

I installed the whole server - not sure, which DLLs are needed to use that DLL.

Hope that helps a little.

(But then I still don't know, why my DLL couldn't be loaded.)

Konrad

Edit: I should test more before posting You need the libmysql.dll! Just copy it into your project. Then you should be able to load the a6mysql.dll.

Great, that I could help you. And with my quick test, I made the same error. My lib also needed 2 otehr DLLs to be loaded. Not my day

Konrad

This DLL can be handy by creating a register page on your website to store data in a database, so you can let your game retreive information from the database.

I can only see "get" commandos
can this plugin also write in a databse?

By using mySQL_ExecQuery you can perform any legal query you want as though you were entering it directly into your MySQL client. eg.

mySQL_ExecQuery("INSERT INTO `players` (`name`) VALUES ('new_char')");

or

mySQL_ExecQuery("UPDATE `players` SET `passwd`='new_passwd' WHERE `name`='new_char'");

or

mySQL_ExecQuery("DELETE FROM `players` WHERE `name`='new_char'");

etc., etc.

This is an awesome contribution!

Andy

Is mySQL free? Where can I get it?