1: <?php
 2: 
 3: namespace Budabot\User\Modules;
 4: 
 5: /**
 6:  * Authors: 
 7:  *  - Jaqueme
 8:  *  Database adapted from one originally compiled by Malosar for BeBot
 9:  *
10:  * @Instance
11:  *
12:  * Commands this controller contains:
13:  *  @DefineCommand(
14:  *      command     = 'whereis', 
15:  *      accessLevel = 'all', 
16:  *      description = 'Shows where places and NPCs are', 
17:  *      help        = 'whereis.txt'
18:  *  )
19:  */
20: class WhereisController {
21: 
22:     /**
23:      * Name of the module.
24:      * Set automatically by module loader.
25:      */
26:     public $moduleName;
27: 
28:     /** @Inject */
29:     public $text;
30:     
31:     /** @Inject */
32:     public $util;
33:     
34:     /** @Inject */
35:     public $db;
36:     
37:     /**
38:      * This handler is called on bot startup.
39:      * @Setup
40:      */
41:     public function setup() {
42:         $this->db->loadSQLFile($this->moduleName, 'whereis');
43:     }
44: 
45:     /**
46:      * @HandlesCommand("whereis")
47:      * @Matches("/^whereis (.+)$/i")
48:      */
49:     public function whereisCommand($message, $channel, $sender, $sendto, $args) {
50:         $search = $args[1];
51:         $search = strtolower($search);
52:         $words = explode(' ', $search);
53:         list($query1, $params1) = $this->util->generateQueryFromParams($words, 'name');
54:         list($query2, $params2) = $this->util->generateQueryFromParams($words, 'keywords');
55:         $params = array_merge($params1, $params2);
56:         
57:         $sql = "SELECT * FROM whereis w LEFT JOIN playfields p ON w.playfield_id = p.id WHERE ($query1) OR ($query2)";
58:         $data = $this->db->query($sql, $params);
59:         $count = count($data);
60: 
61:         if ($count > 0) {
62:             $blob = "Result of Whereis Search for '$search'\n\n";
63:             forEach ($data as $row) {
64:                 $blob .= "<header2>$row->name<end>\n$row->answer";
65:                 if ($row->playfield_id != 0 && $row->xcoord != 0 && $row->ycoord != 0) {
66:                     $blob .= " " . $this->text->makeChatcmd("waypoint: {$row->xcoord}x{$row->ycoord} {$row->short_name}", "/waypoint {$row->xcoord} {$row->ycoord} {$row->playfield_id}");
67:                 }
68:                 $blob .= "\n\n";
69:             }
70: 
71:             $msg = $this->text->makeBlob("Whereis ($count)", $blob);
72:         } else {
73:             $msg = "There were no matches for your search.";
74:         }
75:         $sendto->reply($msg);
76:     }
77: }
78: