All pastes #832511 Raw Edit

Someone

public php v1 · immutable
#832511 ·published 2007-12-26 07:52 UTC
rendered paste body
<?phpheader('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 xtimeFROM        serverinfo,        playersWHERE        players.sid = serverinfo.id AND        LOWER(players.name) LIKE "' . $realname . '"ORDER BY        players.xtime DESCLIMIT        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.');}?>