Lite-C MySQL Plugin *beta*

The 'LCmySQL' MySQL plugin for use with A7 Lite-C 1.5 or higher has been released.

Thanks for working so hard on that one and keeping it up to date

WOW!...thanks man.great effort...this is very handy indeed.

i just couldnt get it work.

im using mysql 5.0.45 and a7.06 comm.
Created the a datbase and ran the sql command inluded.

as i can see from the acklog.txt it crashes when it calls a dll function.

it crased at mySQL_Connectdb function, I commented the line to see if mySQL_IsConnected function working, and it crased again.

One week before the new year i've switched to a host in Canada. So I need to upload everything again. This will take some time. I will try the dll today on another system, but i'm sure it's working fine like last time. Can you show me your script? Also make sure you are using LCmySQL.dll for Lite-C.

i am using te demo.c included in this file : http://a7-files.nixip.com/gsmysql/BETA/LCmySQL.zip

just edited the mySQL_Connectdb line to macth my server info.

Just tried LCmySQL and it is working fine. Do you want me to make a video tutorial how to setup a database on MySQL, insert a player and then have it displayed inside GameStudio engine window?

Some things that come to mind are:

#1 Your MySQL Database server doesn't allow remote connections
#2 You have entered wrong credentials for the connection*
#3 While running from SED/VC you have blocked the application by firewall

* On my remote host (a7-files.nixip.com) a username becomes nixipcom_username

Use this Code:

---

mySQL_Connectdb("nixipcom_gsa7db","67.159.44.57","nixipcom_pip","SGz9QeRi5");

---

inside demo.c for testing remote connections with the LCmySQL.dll and when the application is loaded hit "SPACEBAR" to activate login. Enter for both username and password: demo

This will be available until someone cripple the database. I could use Cron to create anew, but its on my previous host so I not really use their services anymore and this allows you to test the LCmySQL.dll engine extension.

well,
now im sure its not about server.

used mySQL_Connectdb("nixipcom_gsa7db","67.159.44.57","nixipcom_pip","SGz9QeRi5");

as line281 at demo.c it,crashed again. It cant load dll's properly or something?

there is no firewall or antivirus software working in background.

True I now tested on a clean XP Home SP2b system and come to notice that you will be needing to install vcredistx86 for 32bit Windows. If you don't like to install the vcredist, which is actually used by more applications than just this MySQL engine extension. I can compile a dll for you that doesn't require the vcredist at all when I get back to work next week.

If you are creating a real application/game with GameStudio and use this dll you can always distribute the vcredist with your software. If required you can also silently install it, while installing your game on the end-user system.

It will be more useful when vcredist is not need but as u said some other applications installs it too and most people wont reject installing a microsft redist. pack. so its not a problem

thank you D3D ill give it another try now.

Yes. it works now.

Great cont. D3D

thank you for your support & effort.

Intresting.
I have never used this plugin before, and I have started learning Lite-C.
So this plugin will come with a lot of possibilities for my future games.
Thank you for this contribution!
I will test it soon.

Really nice Contribution!

But the connect und get-functions crash under Windows Server 2003 without any error-messages - even with installed VS2008 redistributable - do have any idea what could cuase this?

The video tutorial would be really nice lol, i've never used MySQL and I hear alot of good things.

Florian: Sorry, but I only have Windows98SE/XP/Vista at my disposal so I can't really help with debug. Maybe you can tell me if you are using A6/A7 GameStudio? Include important detail from acklog and how you are connecting to the mysql database server, the version etc. I did compile the dll with platform sdk r2 which should work with XP/2003/Vista 32bit.

PrenceOfDarkness: I will make a video which shows how the demo login is setup very soon.

Here is a quick video and i'll finish the rest end of the week, but i'm very bussy atm

Some people requested a plugin for using MySQL with Litec that does not require the vcredist installed on the end-user system. So here it is! If you like to try gsmysql. Download the beta with simple demo here.

Note:

This release is made for Litec. The plugin is not compatible with Windows 64bit systems.

The video link appears to be broken

the link is broken, oh :\ re link please.

Anyone can send me this? i need this..

the link is broken, oh :\ re link please.

where can i get this DLL?