<?php
header('Content-Type: text/plain');
require('connect.php');

$namepart = mysql_escape_string(trim(strtolower($_REQUEST['player'])));

if(substr($namepart, 0, 3) == '-f ') {
        $namepart = substr($namepart, 3);
        $realname = $namepart;
} else {
        $realname = '%' . $namepart . '%';
}

$servers = mysql_query('
SELECT
        serverinfo.name AS sname,
        players.name AS pname,
        players.xtime AS xtime
FROM
        serverinfo,
        players
WHERE
        players.sid = serverinfo.id AND
        LOWER(players.name) LIKE "' . $realname . '"
ORDER BY
        players.xtime DESC
LIMIT
        1
') or die(mysql_error());
if($server = mysql_fetch_assoc($servers)) {
        $time = (int)((time() - $server['xtime'])/60);
        if($time >= 60*24) {
                print(ereg_replace('0x......', '', trim($server['pname'])) . ' has last been seen on ' . ereg_replace('0x......', '', trim($server['sname'])) . ' ' . ((int)($time/60/24)) . ' day' . ((int)($time/60/24) != 1 ? 's' : '') . ' ' . ((int)(($time % (24*60)) / 60)) . ' hour' . ((int)(($time % (24*60)) / 60) != 1 ? 's' : '') . ' ' . ($time % 60) . ' minute' . ($time % 60 == 1 ? '' : 's') . ' ago.');
        } else if($time >= 60)
                print(ereg_replace('0x......', '', trim($server['pname'])) . ' has last been seen on ' . ereg_replace('0x......', '', trim($server['sname'])) . ' ' . ((int)($time / 60)) . ' hour' . ((int)($time / 60) != 1 ? 's' : '') . ' ' . ($time % 60) . ' minute' . ($time % 60 == 1 ? '' : 's') . ' ago.');
        else if($time > 0)
                print(ereg_replace('0x......', '', trim($server['pname'])) . ' has last been seen on ' . ereg_replace('0x......', '', trim($server['sname'])) . ' ' . $time . ' minute' . ($time == 1 ? '' : 's') . ' ago.');
        else
                print(ereg_replace('0x......', '', trim($server['pname'])) . ' seems to be on ' . ereg_replace('0x......', '', trim($server['sname'])) . ' right now.');
} else {
        print('I haven\'t seen anyone matching “' . $namepart . '” yet, sorry.');
}
?>