547 replies to this topic

[Smarty]

** DISCONTINUED **


Hello all,

GMSQL is a project that allows you to connect to an online MySQL database server using DLLs. You can log on to the server through TCP/IP or an URL, perform any kind of MySQL query and retrieve ALL supported field types as a two-dimensional array. You can even retrieve binary files and save them locally with the game!

WARNING: For advanced GML scripters with MySQL database experience only.

What can you do with these DLLs?

With enough experience, you can...

• Create simple game play counters or record other game statistics
• Create online highscore lists: insert new scores and highscores and get the top rankings directly in your game without the need to call PHP pages
• Store player statistics and characteristics such as names, logon credentials and stats
• Create MMORPGs... If you're up to it. The tools are here.

The package includes:

• Two DLLs that enable the MySQL database server connection
• Easy access through a GML library file
• GMSQL Console, a console tool in editable GMD format
• A manual with examples in RTF format

Don't forget to read the manual!

** Download link removed **

The DLLs seem pretty stable and you should not encounter the dreaded "unexpected error" during execution. But if you do, please show me the script.

Any questions - only about using the DLL extensions, no generic questions about MySQL please - in this topic. I appreciate any bug reports and errors or omissions in the manual.

Thanks to Nelsobra for the idea and Alasdair Forsythe for providing the online test database.

Merry scripting,

Smarty

<EDIT>
SECURITY ALERT:

Communication between client and MySQL server databases is susceptible to hacks on Internet connections because package sniffers can intercept username and password logon information. Therefore, GMSQL is only relatively safe on LAN connections and when Game Maker is used as a server-side application only.

Use Internet client / server connections at your own risk. This security risk is related to the MySQL client library, not to GMSQL. Therefore there is nothing I can do to fix this.

Client / server connections on the Internet may only be safe if clients have registered IP addresses at the server. Refer to the MySQL manual for more information on how to set this up.

Edit: A translation from GMD to GM6 of the console example, done by homebrewpc, can be downloaded from here. Special present for anyone unable to do a conversion themselves.

Edited by Smarty, 20 August 2008 - 01:01 PM.

[gamefreak1450]

wow... great job. I'm sure this will be a huge success, used in games everywhere soon. A true piece of work

[Smarty]

Thanks guys.

Well... I hope it will be used, eventually. Not many game developers here will put a database online, even though MySQL is free for use.

What would be nice is that when one of the board's members decides to put for example a database online that stores highscore tables. Each game developer could get a table for his game and insert and retrieve the scores there. A kind of a Game Maker highscores database table.

Anyway, I should also say that I made only one of two DLLs - the bridge that connects to the MySQL C++ API and handles all input and output to Game Maker. The big work has still been done by MySQL AB.

Smarty

EDIT:

Unfortunately. I cannot connect to a remote MySQL database, it returns access denied. I have access (well I can access it through PHP).......

The reasons could be a case sensitive user name, password or database that you wish to connect to. It also happens if your host address is not a wildcard.

Edited by Smarty, 23 March 2004 - 12:27 AM.

[PromaneX]

MySql will only let certain "hosts" (or ip addresses) connect to the DB if your ip address is not one of these you cannot connect .

[Smarty]

Well, you connected to the server, otherwise you wouldn't get an 'access denied'. I'm thinking that either you don't have the rights you think you have or the username or password, or both, are wrong.

The 'host' is your own ip or host address. MySQL stores usernames in the user@address format. Your should be maxdgaming_db@% (a wildcard) to allow you to log on from wherever you want.

Can you log on to the server with exactly the same credentials using the MySQL query tool (if you have it) ?

Smarty

[Smarty]

You can't use your host location in the username - MySQL will tell where you are by your connection and decide whether or not you are a valid user.

Those PHPs may be executed from the server location itself. In other words, they are not worth a test because you really can't tell the security settings used with the PHP scripts.

Smarty

[PromaneX]

Arrgh this really sucks, i was hoping to get my highscore system set up tonite before I had to leave... I have to leave in about 15 minutes now, maybe enough time to get this fixed... 

If you get stuck with your DB then i will set you an account up on my sever to allow you from any host

[teenman]

PLEASE REMEMBER THAT SOME HOSTS WILL ONLY ALLOW YOU TO CONNECT VIA LOCALHOST. This is a security issue set on most hosts, not allowing outside connections. Some hosts however, give you the option of allowing outside connections to a MySQL DB (but usually that's only with pay hosts...)

[PromaneX]

Smarty can it be made to work with a proxy ? im using GPRS through my mobile phone for my internet

[Smarty]

I haven't tried it on a proxy, and I am not familiar with configuring one. The system does not depend on HTML pages, so there's no caged information on a proxy. You need a proxy/firewall setup that tunnels the IP packages back and forth between your computer and the server.

Try it and know it.

Smarty

[PromaneX]

It wont do it , it's just trying to go direct to my server , and my isp wont let it nvm lol i'll fix it at some point

i would like to start i site giving users of your dll a db to use on my server would that be ok with you? want to be a partner in the site?

[Smarty]

i would like to start i site giving users of your dll a db to use on my server would that be ok with you? want to be a partner in the site?

Hey, this is what I want people to start doing. All you need is my permission to use GMSQL 1.0, and by putting it online here you basically have it. What project you set up with it is your business.

Since I am not really a hero on managing sites and databases, I think I'll skip the invitation. Thanks anyways.

Smarty

[PromaneX]

Great thanks ill start work in the site right away still think you should be a part of it tho haha

[SkaterD]

AHHHHHHHHHHHHHHH!
I LOVE IT!
WAHHHHHHHHHHHHH!
YOU ROCK!