48 replies to this topic

[Catan]

• Title: Online games list
• Description: Avoids manually inserintg the ip address to connect client and host, by providing scripts to maintain an online available games list
• GM Version: GM 8 / GM 7
• Registered: Yes
• File Type: .gmk
• File Size: 1.3mb
• File Link: Download

This example provides a mix of php,mysql and gml that helps the developers of online games maintaining a list of available games waiting for players. The goal is to show to the player all the games he can join directly in game maker and avoid inserting manually the ip address to join them.



REQUIREMENTS
- Game Maker Pro
- The 39DLL Gex from bobistaken (any other version of the 39dll will do but you must update functions names in the gmk)
- A web space with php and mysql

HOW IT WORKS
In general the system is quite simple: you have a mysql database containing all the games information, game maker (using the 39DLL Gex) connects to some php pages on the server which extract or update the database data. The information required by the database is passed with a GET request to the php scripts.

The following php pages are provided with the example:

list.php: This page retrieves the list of available games, in textual format, with information divided by a separator character. It's up to the developer to split the resulting strings. If you access the page from a browser you can see the list in an html table.
insert.php: Allows to insert, update or keep alive a game in the server. It gets the game name and the player name as parameters. The IP of the host is kept in the database therefore calling this page when you already have a game results in updating it.
delete.php: Deletes a game from the server
config.php: Conrains the data needed to connect to the database

For security reasons, it's not possible to create more than a game per IP address.


USAGE

1.
First of all we need a table containing the games in the mysql database on the server. By default for this example you will need at least the following fields in a table called games:
ip (VARCHAR 255)
name (VARCHAR 255)
player (VARCHAR 255)
last_update (DATETIME)

2.
Edit locally the config.php file by adding the required information about your database like password, name, host etc... And upload the php files to the server

3.
Open the example gmk and edit the create event of "controller_obj" by modifying the "host" variable. You need to insert the domain where you uploaded the php files (eg: "www.bestgameever.com")

4.
Update the scripts get_list_scr, upload_scr, delete_scr. These files contain a line telling where the php files are stored in your server, edit this line to your needs (example: if you have list.php at www.bestgameever.com/game/list.php, you'll need to insert "/game/list.php")

IMPORTANT INFO!
When you create a game on the server, the date and the time is kept in the database. 15 seconds after the creation, the game will be deleted from the list (this is to remove inactive games not removed manually by the programmer). You are supposed to call upload_scr frequently to signal that your game is still alive and waiting for players (you can also change the name of the game in the process).



And that's it, I hope the example is clear enough, questions or suggestions are welcome.

Edited by Catan, 01 February 2010 - 06:06 PM.

[bennelsey]

This is *almost* exactly what i was looking, for DAYS.
Im stuck with an old GM7 copy so i can't get it to GM8 for free ^^

[Catan]

This is *almost* exactly what i was looking, for DAYS.
Im stuck with an old GM7 copy so i can't get it to GM8 for free ^^

Now in the zip you can find a GM7 version

[Dylijn]

Looking good, cant download though cuz Im not at home

[Tuz]

Does this check if players can actually join to the server? I mean if the person who hosts server is behind firewall or router the server is not displayed in the server list...

[Catan]

Does this check if players can actually join to the server? I mean if the person who hosts server is behind firewall or router the server is not displayed in the server list...

No it doesn't, if the host is behind firewall his game will still appear in the list but players won't be able to join. I think it's outside the scope of this example in any case

Edited by Catan, 27 January 2010 - 03:20 PM.

[Koning Stoma]

When the server starts you can let it check if the required ports are open. When the ports are open you let it appear on the list, when the ports are closed you give a warning.

here are 2 scripts that make this possible

Edited by Koning Stoma, 27 January 2010 - 04:16 PM.

[irish7]

Finally I got what I was looking for. tnx to you...
Ill try this one!

[2DLuis]

This looks phenomenal, finally, a serverlist, which link is active!
Good MYSQL/PHP info included too, basic things

Nice clean GUI too!

[ghkdudgk]

wow. nice example.

how would i separate the string that's returned from the php into separate strings consisting of the name, the ip, etc.
cause as far as i can see of the code, it returns 1 long string with name, player, and ip all in 1 string.

[Catan]

wow. nice example.

how would i separate the string that's returned from the php into separate strings consisting of the name, the ip, etc.
cause as far as i can see of the code, it returns 1 long string with name, player, and ip all in 1 string.

I didn't separate the string for simplicity, but you can use one of the many scripts available on the forum or other websites. Here's one: http://www.gmlscript...pt/string_parse

[PrimuS]

Nice example. I was looking for something like that for about two years
But gives a PHP error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in list.php on line 8.

Here's lines 1-8 of list.php:

include('config.php');

	$query = "SELECT ip,name,player FROM games WHERE last_update >= NOW() - INTERVAL 15 SECOND"; 
	$result=mysql_query($query);

	if($_GET['ingame'] == '1') {
		while($row = mysql_fetch_array($result)){

BTW, host has PHP5 and MySQL Server v3.23.32.

Edited by PrimuS, 21 February 2010 - 04:31 PM.

[Catan]

Nice example. I was looking for something like that for about two years
But gives a PHP error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in list.php on line 8.

Here's lines 1-8 of list.php:

include('config.php');

	$query = "SELECT ip,name,player FROM games WHERE last_update >= NOW() - INTERVAL 15 SECOND"; 
	$result=mysql_query($query);

	if($_GET['ingame'] == '1') {
		while($row = mysql_fetch_array($result)){

BTW, host has PHP5 and MySQL Server v3.23.32.

Your mysql version is very old, probably that's the source of your problem, or you have some problems connecting to the database.

Try modifying the query line like this: $result=mysql_query($query); or die(mysql_error());

and adding quotes to the table and fields like this: SELECT `ip`,`name`,`player` FROM `games` WHERE `last_update` >= NOW() - INTERVAL 15 SECOND

[Invero]

I am using GM7 Pro And have GM8 Pro

Looks amazing but I am having trouble with it I installed in the .Gex from the link provided and I get this GM7 Error:
___________________________________________
COMPILATION ERROR in Script: get_list_scr
Error in code at line 1:
//Description: Gets the list of available games from the server//Arguments: nonevar sock_id,new_line,listening,headers,game;ds_list_cl
ear(games_list);sock_id = dll39_tcp_connect(host,80,0);if (!sock_id) { show_message("Impossibile connettersi al server"); exit;}dll39_set_format(sock_id,dll39_format_text,c
hr(13) + chr(10));new_line = chr(13) + chr(10);dll39_buffer_clear(0);//Edit the following line to reflect where your php file is on your serverdll39_write_chars("GET /gm/gameserver/list.php?ingame=1 HTTP/1.0" + new_line,0);dll39_write_chars("Host: " + host + new_line,0);dll39_message_send(sock_id,0,0,0); listening = true;while(listening) { dll39_message_receive(sock_id,0,0); headers = dll39_read_sep(" ",0); if(headers == "") { listening = false; break; }}dll39_set_format(sock_id,dll39_format_none,'');result = "";size = dll39_message_receive(sock_id,10000,0);while(true) { game = dll39_read_sep(chr(10),0); if(game == "") {break;} ds_list_add(games_list,string_replace_all(game,"|", " | "));}dll39_socket_close(sock_id);

at position 167: Unknown function or script: dll39_tcp_connect

-------------------------------------------------------------------------------

As for GM8 I am getting this Error:
___________________________________________
COMPILATION ERROR in Script: upload_scr
Error in code at line 17:
sock_id = dll39_tcp_connect(host,80,0);
^
at position 12: Unknown function or script: dll39_tcp_connect

[Catan]

Have you activated the gex for the example gmk, after installing it? It may sound stupid but that's the only thing I can think of after seeing the error

Edited by Catan, 23 February 2010 - 09:24 PM.

[nbeerbower]

I know I'm digging things up here a little bit, but this is great!

I just got it working and hopefully it will make multiplayer on my games a lot more playable. Thanks a ton, man!

[Noritox]

Awesome, implemented it into my game and it works fine. Thanks for this! Do you have a logo I can put in my credits?

[guppylover]

i could kiss you oh wait i can
i was just about to start making somthing like this but youve save a few day's work thanks
cheers, thanks a bundle, you a legend, thank you from the bottom of my heart!!!!!!!!!!!!!!!

[Noritox]

Ah crap I thought I had it working, I'm a tad bit confused. What's the variable that holds the IP address?

[guppylover]

um im having probs it wont retrive any data!!!? waaaaaah
and to q above in the data base the php or gml?

Edited by guppylover, 21 May 2010 - 08:39 PM.