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.');}?>