Page 1 of 1

Online master server list (Back Online)

PostPosted: 29 Jul 2011, 01:53
by 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.

Re: Online master server list

PostPosted: 30 Jul 2011, 21:09
by 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.

Re: Online master server list

PostPosted: 30 Jul 2011, 21:21
by 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?

Re: Online master server list

PostPosted: 30 Jul 2011, 22:01
by 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.

Re: Online master server list

PostPosted: 31 Jul 2011, 06:05
by qreeves
I agree, may be something worth looking at putting in the main tree eventually. Everyone loves a good graph.

Re: Online master server list (Improved)

PostPosted: 22 Aug 2011, 06:02
by orbitaldecay
bumpity bump (see top post)

Re: Online master server list (Improved)

PostPosted: 22 Aug 2011, 07:49
by fluxord
Looks great! Nice work with the additional info. Finally we can see who is playing, what and where. Nice indeed.

Re: Online master server list (Improved)

PostPosted: 14 Oct 2011, 23:18
by 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 :(

Re: Online master server list (Improved)

PostPosted: 15 Oct 2011, 03:14
by qreeves
ZeroKnight {l Wrote}: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 :)

Re: Online master server list (Improved)

PostPosted: 15 Oct 2011, 06:04
by 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 :)

Re: Online master server list (Improved)

PostPosted: 18 Oct 2011, 03:18
by 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 :D

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).

Re: Online master server list (Back Online)

PostPosted: 23 Oct 2011, 03:46
by 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

Re: Online master server list (Back Online)

PostPosted: 23 Oct 2011, 04:18
by 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

Re: Online master server list (Back Online)

PostPosted: 23 Oct 2011, 05:25
by orbitaldecay
LuckyStrike-Rx {l Wrote}: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

Re: Online master server list (Back Online)

PostPosted: 23 Oct 2011, 05:59
by LuckyStrike-Rx
E-mail sent !
<html>
<title>Red Eclipse Master Server Listing</title>
<head>
</head>
</body>

Opening with a closing </body> :) ?

Re: Online master server list (Back Online)

PostPosted: 23 Oct 2011, 16:50
by orbitaldecay
Responded. Yeah, clearly I'm an HTML expert :P

Re: Online master server list (Back Online)

PostPosted: 23 Oct 2011, 18:59
by 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 ;)

Re: Online master server list (Back Online)

PostPosted: 23 Oct 2011, 19:22
by orbitaldecay
ZeroKnight {l Wrote}: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 ;)


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

Re: Online master server list (Back Online)

PostPosted: 24 Oct 2011, 03:08
by LuckyStrike-Rx
Done :)
Edit> Forget something, be back soon (forget the @fontface)
Edit2 ok, done> http://server.orbitaldecay.com/staging/master.php

Re: Online master server list (Back Online)

PostPosted: 24 Oct 2011, 03:09
by ZeroKnight
That's so sexy! Great work, Lucky! :D
Now we just need to link it on the top of the forums!

Re: Online master server list (Back Online)

PostPosted: 24 Oct 2011, 08:07
by orbitaldecay
Cool. New address is http://redeclipse.orbitaldecay.com. That's a night.

Re: Online master server list (Back Online)

PostPosted: 24 Oct 2011, 11:52
by inpersona64
Ooooh sexy! And makes for nice Windows 7 Taskbar shortcut too :D

Image

Re: Online master server list (Back Online)

PostPosted: 24 Oct 2011, 15:32
by 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

Re: Online master server list (Back Online)

PostPosted: 24 Oct 2011, 17:16
by ZeroKnight
Looking forward to that addition, Lucky :) Thanks for your work ^_^

Re: Online master server list (Back Online)

PostPosted: 25 Oct 2011, 03:16
by LuckyStrike-Rx