Gnet master server

Blitz3D Forums/Blitz3D Programming/Gnet master server

Ferret

(Posted 2010) [#1]

I cant get the gnet.php file to work on mi server, it always gives me the default error.

I created the table, added mi login details to gnet.php and uploaded the file to mi server.

http://www.jferretdesign.com/gamedev/gnet/gnet.php

Mysql used to create the table:

--
-- Table structure for table `gnet_servers`
--

CREATE TABLE gnet_servers (
  game varchar(32) NOT NULL default '',
  server varchar(32) NOT NULL default '',
  extip varchar(32) NOT NULL default '',
  intip varchar(32) NOT NULL default '',
  port smallint(5) unsigned NOT NULL default '0',
  t_time timestamp(14) NOT NULL
) TYPE=MyISAM;

--
-- Dumping data for table `gnet_servers`
--

Contents of gnet.php

<?php
// Code by Mark Sibly

// Replace these 4 lines by your information
$host = "jferretdesign.com.mysql";
$user = "jferretdesign_c";
$password = "";
$base = "jferretdesign_c";

// Connect to the database
$link = mysql_connect ($host, $user, $password);
if (!$link) {
  die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db($base, $link);
if (!$db_selected) {
  die ('Can\'t use Etna: ' . mysql_error());
}


//Assumes DB already open.

function ping(){
	global $ip;

	echo "$ip\n";
	exit();
}

//return a list of all servers
function list_servers(){

	$res=mysql_query( "select game,server,ip from gnet_servers order by t_time desc" );
	while( $row=mysql_fetch_row($res) ){
		echo( "$row[0]\n" );
		echo( "$row[1]\n" );
		echo( "$row[2]\n" );
	}
	echo "\n";
	exit();
}

//add a server
function add_server(){
	global $ip,$game,$server;

	$err="ERROR\n";
	if( $game ){
		if( !$server ) $server="$game@$ip";
		$res=mysql_query( "select count(*) from gnet_servers where game='$game' and ip='$ip'" );
		$row=mysql_fetch_row( $res );
		if( $row[0]==0 ){
			mysql_query( "insert into gnet_servers (game,server,ip,t_time) values ('$game','$server','$ip',now())" );
			$err="OK\n";
		}
	}
	echo $err;
	exit();
}

//refresh a server
function ref_server(){
	global $ip,$game,$server;

	$err="ERROR\n";
	if( $game ){
		if( !$server ) $server="$game@$ip";
		$res=mysql_query( "select count(*) from gnet_servers where game='$game' and ip='$ip'" );
		$row=mysql_fetch_row( $res );
		if( $row[0]==1 ){
			mysql_query( "update gnet_servers set server='$server',t_time=now() where game='$game' and ip='$ip'" );
			$err="OK\n";
		}
	}
	echo $err;
	exit();
}

//remove a server
function rem_server(){
	global $ip,$game,$server;

	$err="ERROR\n";
	if( $game ){
		if( !$server ) $server="$game@$ip";
		$res=mysql_query( "select count(*) from gnet_servers where game='$game' and ip='$ip'" );
		$row=mysql_fetch_row( $res );
		if( $row[0]==1 ){
			mysql_query( "delete from gnet_servers where game='$game' and ip='$ip'" );
			$err="OK\n";
		}
	}
	echo $err;
	exit();
}

//setup some useful globals
if ($_SERVER["HTTP_X_FORWARDED_FOR"]) {
	$ip   = $_SERVER["HTTP_X_FORWARDED_FOR"];
} else {
	$ip   = $_SERVER["REMOTE_ADDR"];
}
$opt=array_key_exists("opt",$_GET) ? $_GET["opt"] : "";
$game=array_key_exists("game",$_GET) ? $_GET["game"] : "";
$server=array_key_exists("server",$_GET) ? $_GET["server"] : "";

//delete 'old' servers
mysql_query( "delete from gnet_servers where time_to_sec(now())-time_to_sec(t_time)>300" );

//begin header...(not sure about the no-cache bit!)
header( "content-type: text/html\ncache-control: no-cache\n\n" );

switch( $opt ){
case "add":add_server();break;
case "ref":ref_server();break;
case "rem":rem_server();break;
case "list":list_servers();break;
case "ping":ping();break;
default:echo "ERROR\n";
}

exit();

?>

I have searched the forums and tryed many things but just cant get it to work.

Last edited 2010

Last edited 2010

RifRaf

(Posted 2010) [#2]

Make sure your server folder & files have permissions set, I've just got out of bed , give me awhile to wake up properly with some coffee and ill take a look at what you posted and compare to what I had working for Tiny Tanks.

Edit :
Dont see any real problems in the code.

Last edited 2010

Ferret

(Posted 2010) [#3]

What permissions should the folder and files have?

Ferret

(Posted 2010) [#4]

I changed the folder and files permissions using a ftp client.
Tryed 0666 and 0777, both did not work.

I played with this before and got it to work using the blitz website and localy using phpdev but never on another remote host.

RifRaf

(Posted 2010) [#5]

depending on your hosting you may not be able to do it yourself.

For me I had to email support and have them set folder permissions for me, because it could not be done remotely.