Online master server list (Back Online)

[orbitaldecay]

Available here: http://redeclipse.orbitaldecay.com

The new, permanent address of the master server list will be http://redeclipse.orbitaldecay.com. Feel free to update your links / bookmarks

Edit 5: Now equipped with a shinny new skin, thanks to LuckyStrike-Rx

Edit 4: Up again at a new location (see above). I'm converting the whole thing over to php/mysql. If anyone more design savy than myself wants to work on a pretty page for it, that would be super. Just shoot me an e-mail if you're interested.

Edit 3: Temporarily down until I figure out what's causing the random disconnects on my RE servers

Edit 2: Now generates usage plots for every server on the list, all hyperlinked from the master server list. Slightly better looking (but not much -- I'm a C programmer, I don't understand pretty). Updates data every 60 seconds. Feedback is appreciated.

Edit: Now has a link to the master server list and a link to some usage charts that are generated often.

[orbitaldecay]

Also, play.redeclipse.net server stats for the last hour and 24 hours.

Edit: Time is in EST - these are automatically generated every 60 seconds.

[Kitsune]

what if i dont want my servers shown? or is there a way i can get this on my site showing only my servers?

[orbitaldecay]

Well, its pulling data from the master server list, which is public information. But if anyone really has a problem with their server being listed I suppose it could be removed. I'd be happy to share what I have written so far if you're interested (mostly a big mess of poorly written C code and bash scripts).

Edit: What I think is especially interesting are the automagic usage plots I'm working on - if I have the time I'll clean it all up and release the code.

[qreeves]

I agree, may be something worth looking at putting in the main tree eventually. Everyone loves a good graph.

[orbitaldecay]

bumpity bump (see top post)

[fluxord]

Looks great! Nice work with the additional info. Finally we can see who is playing, what and where. Nice indeed.

[ZeroKnight]

Hey orbital, any idea when you think this'll be back up? I miss having my little bookmark work and see how many people are playing :(

[qreeves]

Hey orbital, any idea when you think this'll be back up? I miss having my little bookmark work and see how many people are playing

Same here, I think we need to work on making something like this official

[ZeroKnight]

I'm sure orbital would be more than happy to let you add this to the main RE page, if you chose to implement it :)
You could just throw it in the header bar with "Forums" and "Tracker" etc. Or integrate it as a box on the page somewhere.
Whatever you decide, you should at least link put a link to it on the forum page.
See this for an example.
See how they have a link right at the top? You could link the stat page like that :)

[orbitaldecay]

Thanks all This kind of turned into one of those back burner projects that I haven't gotten to wrap up. My plan was to rewrite it to dump stats to a mysql database so someone a little more web-savy than myself can build a pretty webpage for it. Perhaps we should coordinate something to coincide with the 1.2 release? Any php/mysql webdesign guys (or gals) in the house?

An even better idea, I think, would be to include this capability in the master server (i.e. have the master server dump server stats to a mysql database that a page queries). Of course, this could also open the door to stat tracking and all sorts of other goodies

I'm interested in working on it, though sadly I won't have much time to dedicate to it until the semester is over (mid-December).

[orbitaldecay]

The new version I'm working on is now up. It is using php and mysql as it is more design friendly. If there are any webdesign guys around who want to work on a frontend for it, let me know. Check it out at http://server.orbitaldecay.com/master.php

[LuckyStrike-Rx]

You can send me the php file, I'll see what I can do

EDIT:
I Did this. is it ok ? I'll eventually add a player model to illustrate a bit

But I'll have to modify the Html to replace the table by div

[orbitaldecay]

You can send me the php file, I'll see what I can do

EDIT:
I Did this. is it ok ? I'll eventually add a player model to illustrate a bit

But I'll have to modify the Html to replace the table by div

Looks great to me. Here's the php in its present form

{l Code}: {l Select All Code}

<html>
<title>Red Eclipse Master Server Listing</title>
<head>
</head>
</body>
<font face="courier">

<?php
$username = "Ho hum";
$password = "I'm dumb, but not that dumb";
$database = "retool";
mysql_connect(localhost, $username, $password);
@mysql_select_db($database) or die("Unable to select database");
$query = "SELECT * FROM server_list WHERE online=true";
$result = mysql_query($query);
$num = mysql_numrows($result);

$query = "SELECT * FROM player_list";
$presult = mysql_query($query);
$pnum = mysql_numrows($presult);

mysql_close();


echo "<table border=1 cellpadding=5 width=1024>";
echo "<tr>\n";
echo "<td>Name</td>\n";
echo "<td>Players</td>\n";
echo "<td>Mode</td>\n";
echo "<td>Mutators</td>\n";
echo "<td>Address</td>\n";
echo "<td>Ping</td>\n";
echo "</tr>\n";

$i=0;
while ($i < $num) {

$host=mysql_result($result,$i,"host");
$port=mysql_result($result,$i,"port");
$name=mysql_result($result,$i,"name");
$map=mysql_result($result,$i,"map");
$mode=mysql_result($result,$i,"mode");
$muts=mysql_result($result,$i,"muts");
$ping=mysql_result($result,$i,"ping");
$numplayers=mysql_result($result,$i,"numplayers");
$maxplayers=mysql_result($result,$i,"maxplayers");

if ($numplayers > 0) {
    echo "<tr bgcolor=ddffdd>\n";
}
else
{
    echo "<tr>\n";
}
echo "<td>$name</td>\n";
echo "<td>$numplayers/$maxplayers</td>\n";
echo "<td>$mode</td>\n";
echo "<td>$muts</td>\n";
echo "<td>$host:$port</td>\n";
echo "<td>$ping</td>\n";
echo "</tr>";
if ($numplayers > 0) {
    echo "</b>\n";
}

$i++;
}

echo "</table>\n";

echo "<br><i>$pnum players online:</i><br><br>\n";
$i=0;
while ($i < $pnum) {
$name = mysql_result($presult,$i,"name");
$sid = mysql_result($presult,$i,"location");
$location = mysql_result($result,$sid-1,"name");
echo "<b>$name</b> \tis on $location.<br>";
$i++;
}
?>

</table>

</body>
</html>


If it makes life any easier, I can set up an account for you on the server where its hosted.

Edit: Shoot me an e-mail at orbitaldecay@gmail.com

[LuckyStrike-Rx]

E-mail sent !

<html>
<title>Red Eclipse Master Server Listing</title>
<head>
</head>
</body>

Opening with a closing </body> ?

[orbitaldecay]

Responded. Yeah, clearly I'm an HTML expert :P

[ZeroKnight]

Glad to see it's back up, orbital! :D And that's a very nice looking skin, Lucky ^^
Now, if we can apply that skin, and link it to the front page of the forums...then we're in business ;)

[orbitaldecay]

Glad to see it's back up, orbital! And that's a very nice looking skin, Lucky ^^
Now, if we can apply that skin, and link it to the front page of the forums...then we're in business

Yeah, I think we'll have something nice going on soon

[LuckyStrike-Rx]

Done
Edit> Forget something, be back soon (forget the @fontface)
Edit2 ok, done> http://server.orbitaldecay.com/staging/master.php

[ZeroKnight]

That's so sexy! Great work, Lucky! :D
Now we just need to link it on the top of the forums!

[orbitaldecay]

Cool. New address is http://redeclipse.orbitaldecay.com. That's a night.

[inpersona64]

Ooooh sexy! And makes for nice Windows 7 Taskbar shortcut too

[LuckyStrike-Rx]

Now it may be cool to have the map image, can you report the change to the staging repertory ?

i may do <img src='"$map"'.jpg /> but the problem is non official maps, they will get an missing image
Edit - Nevermind I found a JS that do this well

[ZeroKnight]

Looking forward to that addition, Lucky :) Thanks for your work ^_^

[LuckyStrike-Rx]

http://server.orbitaldecay.com/staging/master.php
Now with image