1: <?php
2:
3: namespace Budabot\Core;
4:
5: 6: 7: 8: 9: 10:
11: class Preferences {
12: 13: 14: 15:
16: public $moduleName;
17:
18:
19: public $db;
20:
21: 22: 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: