1: <?php
2:
3: namespace Budabot\User\Modules;
4:
5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19:
20: class ResearchController {
21:
22: 23: 24: 25:
26: public $moduleName;
27:
28:
29: public $db;
30:
31:
32: public $text;
33:
34: 35: 36: 37:
38: public function setup() {
39: $this->db->loadSQLFile($this->moduleName, 'research');
40: }
41:
42: 43: 44: 45:
46: public function researchSingleCommand($message, $channel, $sender, $sendto, $args) {
47: $level = $args[1];
48: if ($level < 1 || $level > 10) {
49: return false;
50: } else {
51: $sql = "SELECT * FROM research WHERE level = ?";
52: $row = $this->db->queryRow($sql, $level);
53:
54: $levelcap = $row->levelcap;
55: $sk = $row->sk;
56: $xp = $sk * 1000;
57: $capxp = round($xp * .1);
58: $capsk = round($sk * .1);
59: $xp = number_format($xp);
60: $sk = number_format($sk);
61:
62: $blob = "You must be <highlight>Level $levelcap<end> to reach <highlight>Research Level $level<end>.\n";
63: $blob .= "You need <highlight>$sk SK<end> to reach <highlight>Research Level $level<end> per research line.\n\n";
64: $blob .= "This equals <highlight>$xp XP<end>.\n\n";
65: $blob .= "Your research will cap at <highlight>~$capxp XP<end> or <highlight>~$capsk SK<end>.";
66: $msg = $this->text->makeBlob("Research Level $level", $blob);
67: }
68:
69: $sendto->reply($msg);
70: }
71:
72: 73: 74: 75:
76: public function researchDoubleCommand($message, $channel, $sender, $sendto, $args) {
77: $lolevel = $args[1];
78: $hilevel = $args[2];
79: if ($lolevel < 0 || $lolevel > 10 || $hilevel < 0 || $hilevel > 10) {
80: return false;
81: } else {
82: $sql =
83: "SELECT
84: SUM(sk) totalsk,
85: MAX(levelcap) levelcap
86: FROM
87: research
88: WHERE
89: level > ? AND level <= ?";
90: $row = $this->db->queryRow($sql, $lolevel, $hilevel);
91:
92: $xp = number_format($row->totalsk * 1000);
93: $sk = number_format($row->totalsk);
94:
95: $blob = "You must be <highlight>Level $row->levelcap<end> to reach Research Level <highlight>$hilevel.<end>\n";
96: $blob .= "It takes <highlight>$sk SK<end> to go from Research Level <highlight>$lolevel<end> to Research Level <highlight>$hilevel<end> per research line.\n\n";
97: $blob .= "This equals <highlight>$xp XP<end>.";
98: $msg = $this->text->makeBlob("Research Levels $lolevel - $hilevel", $blob);
99: }
100:
101: $sendto->reply($msg);
102: }
103: }
104: