function showTop10() { $category = isset($this->info['text']) ? $this->info['text'] : "chars"; if ($this->info['isQuery']) { $output = "Top10 ('" . $category . "'): "; switch ($category) { case "chars": $sql = "SELECT nick, SUM(chars) number FROM stats GROUP BY nick ORDER BY number DESC LIMIT 10"; break; case "words": $sql = "SELECT nick, SUM(words) number FROM stats GROUP BY nick ORDER BY number DESC LIMIT 10"; break; case "lines": $sql = "SELECT nick, SUM(`lines`) number FROM stats GROUP BY nick ORDER BY number DESC LIMIT 10"; break; case "actions": $sql = "SELECT nick, SUM(actions) number FROM stats GROUP BY nick ORDER BY number DESC LIMIT 10"; break; case "smilies": $sql = "SELECT nick, SUM(smilies) number FROM stats GROUP BY nick ORDER BY number DESC LIMIT 10"; break; case "kicks": $sql = "SELECT nick, SUM(kicks) number FROM stats GROUP BY nick ORDER BY number DESC LIMIT 10"; break; case "kicked": $sql = "SELECT nick, SUM(kicked) number FROM stats GROUP BY nick ORDER BY number DESC LIMIT 10"; break; case "modes": $sql = "SELECT nick, SUM(modes) number FROM stats GROUP BY nick ORDER BY number DESC LIMIT 10"; break; case "topics": $sql = "SELECT nick, SUM(topics) number FROM stats GROUP BY nick ORDER BY number DESC LIMIT 10"; break; case "wpl": $sql = "SELECT nick, ROUND(SUM(words)/SUM(`lines`),2) number FROM stats GROUP BY nick ORDER BY number DESC LIMIT 10"; break; case "cpl": $sql = "SELECT nick, ROUND(SUM(chars)/SUM(`lines`),2) number FROM stats GROUP BY nick ORDER BY number DESC LIMIT 10"; break; default: $this->sendOutput("The category '" . $category . "' doesn't exist."); return; } } else { $output = "Top10 ('" . $category . "') in " . $this->info['channel'] . ": "; $channel = addslashes($this->info['channel']); switch ($category) { case "chars": $sql = "SELECT nick, chars number FROM stats WHERE channel='" . $channel . "' ORDER BY chars DESC LIMIT 10"; break; case "words": $sql = "SELECT nick, words number FROM stats WHERE channel='" . $channel . "' ORDER BY words DESC LIMIT 10"; break; case "lines": $sql = "SELECT nick, `lines` number FROM stats WHERE channel='" . $channel . "' ORDER BY `lines` DESC LIMIT 10"; break; case "actions": $sql = "SELECT nick, actions number FROM stats WHERE channel='" . $channel . "' ORDER BY actions DESC LIMIT 10"; break; case "smilies": $sql = "SELECT nick, smilies number FROM stats WHERE channel='" . $channel . "' ORDER BY smilies DESC LIMIT 10"; break; case "kicks": $sql = "SELECT nick, kicks number FROM stats WHERE channel='" . $channel . "' ORDER BY kicks DESC LIMIT 10"; break; case "kicked": $sql = "SELECT nick, kicked number FROM stats WHERE channel='" . $channel . "' ORDER BY kicked DESC LIMIT 10"; break; case "modes": $sql = "SELECT nick, modes number FROM stats WHERE channel='" . $channel . "' ORDER BY modes DESC LIMIT 10"; break; case "topics": $sql = "SELECT nick, topics number FROM stats WHERE channel='" . $channel . "' ORDER BY topics DESC LIMIT 10"; break; case "wpl": $sql = "SELECT nick, ROUND(words/`lines`,2) number FROM stats WHERE channel='" . $channel . "' ORDER BY number DESC LIMIT 10"; break; case "cpl": $sql = "SELECT nick, ROUND(chars/`lines`,2) number FROM stats WHERE channel='" . $channel . "' ORDER BY number DESC LIMIT 10"; break; default: $this->sendOutput("The category '" . $category . "' doesn't exist."); return; } } $res = $this->MySQL->sendQuery($sql); foreach ($res['result'] as $data) { $output .= libString::softhyphe($data['nick']) . " (" . $data['number'] . "), "; } $output = substr($output, 0, -2); $this->sendOutput($output); }