1: <?php
  2: 
  3: namespace Budabot\User\Modules;
  4: 
  5: /**
  6:  * Authors: 
  7:  *  - Tyrence (RK2)
  8:  *  - Jaqueme
  9:  *
 10:  * @Instance
 11:  *
 12:  * Commands this controller contains:
 13:  *  @DefineCommand(
 14:  *      command     = 'research', 
 15:  *      accessLevel = 'all', 
 16:  *      description = 'Show info on Research', 
 17:  *      help        = 'research.txt'
 18:  *  )
 19:  */
 20: class ResearchController {
 21: 
 22:     /**
 23:      * Name of the module.
 24:      * Set automatically by module loader.
 25:      */
 26:     public $moduleName;
 27:     
 28:     /** @Inject */
 29:     public $db;
 30: 
 31:     /** @Inject */
 32:     public $text;
 33:     
 34:     /**
 35:      * This handler is called on bot startup.
 36:      * @Setup
 37:      */
 38:     public function setup() {
 39:         $this->db->loadSQLFile($this->moduleName, 'research');
 40:     }
 41: 
 42:     /**
 43:      * @HandlesCommand("research")
 44:      * @Matches("/^research ([0-9]+)$/i")
 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:      * @HandlesCommand("research")
 74:      * @Matches("/^research ([0-9]+) ([0-9]+)$/i")
 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: