Elders Online

Old game due a revival?

Page 1 of 1

3 Replies - 1080 Views - Last Post: 09 July 2009 - 06:10 PM Rate Topic: -----

#1 RudiVisser   User is offline

  • .. does not guess solutions
  • member icon

Reputation: 1010
  • View blog
  • Posts: 3,566
  • Joined: 05-June 09

Elders Online

Posted 09 June 2009 - 04:01 PM

I posted this on another site but there didn't seem to be any (qualifying) interest. The wording may be a little "offish" but any questions feel free to ask..

Info that isn't in the original post (below) is that the game is FULLY WORKING and fully working well. As mentioned it just needs the database reconstructing, but it worked great.


This is a game I made years ago in PHP, it's built terribly and I'm not even sure at what stage it was at... It was kindof a text-based RPG game, pretty cool to play really but as with everything I do I never have time to maintain it. Luckily this was before I had a business + other commitments so development did progress extremely far.

Anyway, the site's down for a long time now, and the database has been completely destroyed - however - if anybody has sufficient PHP/MySQL knowledge to be able to continue the project from it's current state (see below) then post here and I'll choose someone (if there's any interest...) to manage the project soon.

What's Involved
As mentioned above, I only have the source code and no database. You will need to be able to work through the current code and be able to reconstruct a database design from it, of course I'll be able to help out on MSN/Email if needed, but I'd rather have little involvement in this.

You'll need to be extremely knowledgable in PHP/MySQL to decipher the crap code that I made when I was 15. This was the second ever PHP thing that I made so it's messy as hell like so:
function get_stats($username) {
	$link = mysql_connect("localhost", "elders", "SDT3uvG");
	if(!$link) {
		$ret = "FAIL";
		return $ret;
		die();
	}
	mysql_select_db("eldersonline_net", $link);
	$sql = mysql_query("SELECT * FROM users WHERE username = '".$username."' LIMIT 1");
	$ret = mysql_fetch_assoc($sql);
	return $ret;
}
function usersonline() {
	$link = mysql_connect("localhost", "elders", "SDT3uvG");
	if(!$link) {
		$ret = "FAIL";
		return $ret;
		die();
	}
	mysql_select_db("eldersonline_net", $link);
	$sql = mysql_query("SELECT * FROM loggedusers");
	$ret = mysql_num_rows($sql);
	return $ret;
}


Why revive it
It was an awesome little project and I don't want it to die.

What's in it for me
Well that's down to you. If you decide to continue coding it then revive the "power player" option that removes advertisements n stuff.

Legal Stuff
Since another game will be built around the same name you'll be required to give full (real) details and sign an NDA/NCA (for the source) as it will remain a commercial project and naturally you won't be allowed to run off with the source/name/code..

This post has been edited by MageUK: 10 June 2009 - 01:58 AM


Is This A Good Question/Topic? 0
  • +

Replies To: Elders Online

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 16479
  • View blog
  • Posts: 65,313
  • Joined: 12-June 08

Re: Elders Online

Posted 09 June 2009 - 07:48 PM

This can't be all of your game.. All it's doing is checking some databases.


$link = mysql_connect("localhost", "elders", "SDT3uvG");

It looked like you had a database called "elders" with "SDT3uvG" as a password.

$sql = mysql_query("SELECT * FROM users WHERE username = '".$username."' LIMIT 1");

Here we can see you had a table called "users".. with at least one column called 'username'. Since you used SELECT * we cannot decypher any other columns from that table.

$sql = mysql_query("SELECT * FROM loggedusers");

Another table - called 'loggedusers'. Unknown number of columns since a SELECT * was used.
Was This Post Helpful? 0
  • +
  • -

#3 RudiVisser   User is offline

  • .. does not guess solutions
  • member icon

Reputation: 1010
  • View blog
  • Posts: 3,566
  • Joined: 05-June 09

Re: Elders Online

Posted 10 June 2009 - 02:02 AM

Haha

No the point I was trying to make with the example code is that it's ugly and written bad. The fact it's connecting to the database seperately in each function was meant to prove that, as it's like that throughout the whole game, but nevermind :)

The game works primarily through a single file named futgame.php. The whole thing was AJAX based, very, very badly AJAX based. A complete list of the files are below, the game itself was actually pretty neat, but like I say I don't have the database nor time to revive it myself, but also don't want it to die.
Posted Image
Was This Post Helpful? 0
  • +
  • -

#4 sam_benne   User is offline

  • D.I.C Addict
  • member icon

Reputation: 16
  • View blog
  • Posts: 733
  • Joined: 16-January 08

Re: Elders Online

Posted 09 July 2009 - 06:10 PM

I like the look of it. Plus I have a lot of time at the moment so if you want I can revive it for you. I can update it and keep the AJAXness but use jQuery.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1