blob: 9fe77d1c822f630bbb18c912b7c0f3d8f67271f4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
<?php
class ModelReportStatistics extends Model {
public function getStatistics() {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "statistics");
return $query->rows;
}
public function getValue($code) {
$query = $this->db->query("SELECT value FROM " . DB_PREFIX . "statistics WHERE `code` = '" . $this->db->escape($code) . "'");
if ($query->num_rows) {
return $query->row['value'];
} else {
return null;
}
}
public function addValue($code, $value) {
$this->db->query("UPDATE " . DB_PREFIX . "statistics SET `value` = (`value` + '" . (float)$value . "') WHERE `code` = '" . $this->db->escape($code) . "'");
}
public function editValue($code, $value) {
$this->db->query("UPDATE " . DB_PREFIX . "statistics SET `value` = '" . (float)$value . "' WHERE `code` = '" . $this->db->escape($code) . "'");
}
public function removeValue($code, $value) {
$this->db->query("UPDATE " . DB_PREFIX . "statistics SET `value` = (`value` - '" . (float)$value . "') WHERE `code` = '" . $this->db->escape($code) . "'");
}
}
|