1: <?php
 2: 
 3: namespace Budabot\Core;
 4: 
 5: /**
 6:  * Authors:
 7:  *  - Tyrence (RK2)
 8:  *
 9:  * @Instance
10:  */
11: class Preferences {
12:     /**
13:      * Name of the module.
14:      * Set automatically by module loader.
15:      */
16:     public $moduleName;
17: 
18:     /** @Inject */
19:     public $db;
20:     
21:     /**
22:      * @Setup
23:      */
24:     public function setup() {
25:         $this->db->loadSQLFile($this->moduleName, 'preferences');
26:     }
27:     
28:     public function save($sender, $name, $value) {
29:         $sender = ucfirst(strtolower($sender));
30:         $name = strtolower($name);
31: 
32:         if ($this->get($sender, $name) === false) {
33:             $this->db->exec("INSERT INTO preferences_<myname> (sender, name, value) VALUES (?, ?, ?)", $sender, $name, $value);
34:         } else {
35:             $this->db->exec("UPDATE preferences_<myname> SET value = ? WHERE sender = ? AND name = ?", $value, $sender, $name);
36:         }
37:     }
38: 
39:     public function get($sender, $name) {
40:         $sender = ucfirst(strtolower($sender));
41:         $name = strtolower($name);
42: 
43:         $row = $this->db->queryRow("SELECT * FROM preferences_<myname> WHERE sender = ? AND name = ?", $sender, $name);
44:         if ($row === null) {
45:             return false;
46:         } else {
47:             return $row->value;
48:         }
49:     }
50: }
51: