Gridrunner Revolution OUT NOW }:-).

[gravy]

But you know it does not work "so simply" on the PC, you have to set up things all in some way and do it in a way the
user possibly has "nothing to do".

You don't need any mysql stuff on windows. It just doesn't work like that.

You're sending the score to the web server and it's PHP that receives that score and puts it in the database and you do that via standard web access via port 80.

All it boils down to is being able to send XML text to the web server in form of a small XML packet. You could hand roll that code yourself or use something really simple like libcurl to do it. It is easy on ANY OS.

What you're implying is that the mysql server would be on the web publicly and that would be an insane thing to do.

Probably best to ask how these things are done rather than just assume.

[gilesgoat]

But you know it does not work "so simply" on the PC, you have to set up things all in some way and do it in a way the
user possibly has "nothing to do".

You don't need any mysql stuff on windows. It just doesn't work like that.

You're sending the score to the web server and it's PHP that receives that score and puts it in the database and you do that via standard web access via port 80.

All it boils down to is being able to send XML text to the web server in form of a small XML packet. You could hand roll that code yourself or use something really simple like libcurl to do it. It is easy on ANY OS.

What you're implying is that the mysql server would be on the web publicly and that would be an insane thing to do.

Probably best to ask how these things are done rather than just assume.

So you are doing a kind of "HTML post" like "http://banana.score/score.php?score=pippo,user=banana,cippe=..."
and then you do all server side ?

Is that's what you mean ?

[Sickboy]

Ummmmmmmm, is there going to be a Mac version then?

[gravy]

So you are doing a kind of "HTML post" like "http://banana.score/score.php?score=pippo,user=banana,cippe=..."
and then you do all server side ?

Is that's what you mean ?

Sort of like that. There's a few niceties you need to do as well.

I run it on a separate thread so if the server isn't available then the game doesn't block. But it's all pretty basic stuff.

I also get the client to send their registration details and don't let people who don't have a registered copy post. I check against the sales database to see if it's a registration key I've generated or not.

I also did a fair bit more and sent the players machine specs and average frame rates as well so I could

I also store the latest version of the game in the database and GR++ checks to see if there's a new version when it boots up and advises you to download it if there is.

That last thing is probably more important that the leaderboards IMHO. You've no test team so you're bound to have quite a few bugs pop up in the first few days after release. If you have that sort of functionality in it makes it a lot easier to make sure everyone gets the latest version.

It's all doable, I put this stuff in GR++ on the mac in my spare time so it'd certainly be doable if you're working on a project full time.

[limb_clock]

Ummmmmmmm, is there going to be a Mac version then?

If there is, i hope the keys will work on them as well

[Yak]

It's all academic anyway as the game is released now. We simply can't afford to be spending time on fiddling about with an already finished game adding stuff from people's wish lists.

Maybe we'll look at this kind of stuff for whatever comes next .

[gravy]

As I said that's completely fair.

Hopefully it'll be more likely to get done for future games now it's clear just how much easier it is than was originally assumed

[gravy]

Ummmmmmmm, is there going to be a Mac version then?

Well between the two of us me and Kor own the rights to do this and SG on the Mac but given how stupidly hectic our work's got it's not looking likely to get done Both games run brilliantly under bootcamp on most macs tho

[gilesgoat]

Ummmmmmmm, is there going to be a Mac version then?

Well between the two of us me and Kor own the rights to do this and SG on the Mac but given how stupidly hectic our work's got it's not looking likely to get done Both games run brilliantly under bootcamp on most macs tho

I can't recall being a deal for Gridrunner Rev, the deal was only for SG if I am not wrong.

[Sickboy]

Ummmmmmmm, is there going to be a Mac version then?

Well between the two of us me and Kor own the rights to do this and SG on the Mac but given how stupidly hectic our work's got it's not looking likely to get done Both games run brilliantly under bootcamp on most macs tho

Yeah, it looked wonderful on Fuse's Mac with Boot Camp the other day. Gonna have to get it set up...

[gravy]

Well between the two of us me and Kor own the rights to do this and SG on the Mac but given how stupidly hectic our work's got it's not looking likely to get done Both games run brilliantly under bootcamp on most macs tho

I can't recall being a deal for Gridrunner Rev, the deal was only for SG if I am not wrong.

No you are wrong, you got a fairly big cheque for it. Email sent

[RiK]

I just spent a little under 20 minutes on the scores thing, and in that time I wrote an app in Blitz that took a name, score and validation code and wrote it out thus:

Code: Select all

http://www.olpin.net/validatescores.php?name=IvorBiggun&score=123456789&code=abcde12345

then 5 mins for a php script to grab that and chuck it at a database.

Piece of piss, you could test the php just by echoing the values like this:

Code: Select all

<?php
$from_program="abcde12345";
$name = $_GET['name'];
$score = $_GET['score'];
$validation_code = $_GET['code'];

if($validation_code == $from_program){
	echo "\nName is $name <br>Score is $score<br>Code is $validation_code"; 	
}
?>

or actually write it into a DB with something like this:

Code: Select all

<?php

$host = "DBHostName";
$database = "DBname";
$username = "DBusername";
$password = "DBpassword";

$from_program="abcde12345";  // sample validation code, obv. would be generated in the game and actually validated here
$name = $_GET['name'];
$score = $_GET['score'];
$validation_code = $_GET['code'];

if($validation_code == $from_program){

    mysql_connect($host, $username, $password);
    @mysql_select_db($database) or die( "Unable to select database");

     if ($score > 0) {
	     $query="INSERT INTO buttonscores
		VALUES ('null', '$name', '$score', CURRENT_TIMESTAMP)";
	     $result=mysql_query($query);
     }
}

?>

Honestly, that's just 20 mins pissing about over a cuppa on a sunday afternoon.
I really don't see what all the fuss is about!

[bcass]

It's all academic anyway as the game is released now. We simply can't afford to be spending time on fiddling about with an already finished game adding stuff from people's wish lists.

Even if people are prepared to pay a bit extra for it?

[disciple]

I'm guessing it would be difficult to hack in, user mods and such?

[bcass]

I suppose you could hack the save file and write an app to upload to a fans server, but then the scores would be open to abuse/tampering, and not everyone would use the app...