[Idea] web accessible user stats

I've looked around in the forum and I haven't seen anything like what I am imagining, so I'll post it as an idea. I think it would be do-able to have some stats for a server, like online players, and maybe some others to put on a website.

Unfortunately I don't have the coding skill to work on this
Does anyone have any thoughts about it?

 

It's possible. PHP

 

Ok I asked some people, and found http://forums.bukkit.org/threads/minequery-1-1.1358/#post-15797 minequery. It does some basic functions, so that'll work for now.

 

http://forums.bukkit.org/threads/tcp-interface-for-bukkit.746/


You can get information from that. If you have any requests for information you'd like it to get, I can add in things for you.

 

Ok great! I'll work on a list of some stuff that I think would be great to have for a website.

 

I'd like something that I can easily use that will allow me to add another page to my website and show the users on my server and other basic things. Something where I can just upload some files to a new directory in my website, change a few values and be basically done.

 

Can be done. Will have to be more specific than 'other basic things' though.

 

Just the basics as in if server is up, maybe also saying who the admins are.

 

As there is no standard permissions system in Bukkit currently I have no plans to implement that.
Obviously you will not be able to connect if the server is not up.
I'll work on a PHP script for you, gimme ten minutes or so.

Edit: Oh joy, the PHP encoding headache.
2nd edit: I've just found out java uses UTF-16 encoding. -.-

 

Oh lawl. Hey what about other stats like the most active people with how many hours they have been on and maybe the most said words or links. (or top mentioned usernames)

 

Eh, that'd probably require recording join and disconnect messages, then calculating the amount of time they were online for and adding it to the time they already have stored in the database.

Which I can do, but give me a few days to work it out fully. (I'm not quite sure how to use Java's MySQL stuff.)

 

Yes I understand things take time. I have a few other ideas I will be getting to you.

 

PHP:

<?php
$bukkit_host = "localhost";
$bukkit_port = 6790;
$bukkit_password = "password";

$errn = "";
$errs = "";
$timeout = 10;
$sock = fsockopen($bukkit_host, $bukkit_port, $errn, $errs, $timeout);
if($sock){
    echo "Connected to Bukkit!\r\n";
    fgetc($sock);
    fgetc($sock);
    while(!feof($sock)){
        $line = trim(mb_convert_encoding(fgets($sock, 4096), "ASCII"));
        if($line != ""){
            echo $line."\r\n";
            if($line == "Welcome to Bukkit, please authenticate."){
                writeToSocket("pass ".$bukkit_password, $sock);
            }
        }
    }
}
else{
    echo "Error: Could not connect to Bukkit! ".$errn." (".$errs.")";
}

function writeToSocket($text, $sock){
    fwrite($sock, $text."\r\n");
    echo $text."\r\n";
}
?>

 

Nice but how would I use that. (honestly I haven't even used bukkit yet as I was waiting for a full release) I also noticed you put port as 6790, why is that?

 

Because port 6790 is the port my TCP interface plugin listens on by default.