private function printPlayerStats($nick, $global = false) { $serverchannel = $this->Server->id . ':' . $this->Channel->id; if ($global) { $sql = "\n\t\t\t\tSELECT\n\t\t\t\t\t`nick`, SUM(`played`) AS `played`, SUM(`started`) AS `started`, SUM(`lost`) AS `lost`, SUM(`clicks`) AS `clicks`\n\t\t\t\tFROM\n\t\t\t\t\t`roulette`\n\t\t\t\tWHERE\n\t\t\t\t\t`nick` = '" . addslashes($nick) . "'\n\t\t\t"; } else { $sql = "\n\t\t\t\tSELECT\n\t\t\t\t\t*\n\t\t\t\tFROM\n\t\t\t\t\t`roulette`\n\t\t\t\tWHERE\n\t\t\t\t\t`serverchannel` ='" . addslashes($serverchannel) . "'\n\t\t\t\t\tAND `nick` = '" . addslashes($nick) . "'\n\t\t\t"; } $data = $this->MySQL->fetchRow($sql); if (!$data) { $this->reply($nick . ' has never played roulette.'); return; } $this->reply(sprintf('%s has played %s, won %d and lost %d. %s started %s, pulled the trigger %s and found the chamber empty on %s.', $data['nick'], libString::plural('game', $data['played']), $data['played'] - $data['lost'], $data['lost'], $data['nick'], libString::plural('game', $data['started']), libString::plural('time', $data['clicks'] + $data['lost']), libString::plural('occasion', $data['clicks']))); }
private function printPlayerStats($nick) { $ranking = $this->getVar('ranking', array()); $stats = false; if (preg_match('/[^0-9]/', $nick)) { foreach ($ranking as $index => $rank) { if ($rank['nick'] == $nick) { $stats = $rank; $stats['rank'] = $index + 1; break; } } if ($stats === false) { $this->reply($nick . ' has never played dice.'); return; } } else { if (isset($ranking[$nick - 1])) { $stats = $ranking[$nick - 1]; $stats['rank'] = $nick; } else { $this->reply("No one is on that rank."); return; } } $text = sprintf("%s has played %s, won %d and lost %d. %s is on rank %d of %d. %s's last game was %s ago.", $stats['nick'], libString::plural('game', $stats['played']), $stats['won'], $stats['played'] - $stats['won'], $stats['nick'], $stats['rank'], sizeof($ranking), $stats['nick'], libTime::secondsToString(time() - $stats['last_played'])); if ($stats['rank'] != 1) { $text .= sprintf(" %s needs to win %s to rankup.", $stats['nick'], libString::plural('more game', $ranking[$stats['rank'] - 2]['won'] - $stats['won'] + 1)); } $this->reply($text); }