/** * Get settings data from DB. * * @access private * @return array */ private function getDataFromDB() { $data = array(); $query = $this->db->query("\n\t\t\tSELECT setting_name, setting_value\n\t\t\tFROM ts_system_settings\n\t\t\tORDER BY id\n\t\t"); while (($row = $this->db->fetchAssoc($query)) != NULL) { $data[$row['setting_name']] = $row['setting_value']; } return $data; }
/** * Calculate the number of pages. * * @access public * @return int */ public function getNumPages() { if ($this->user->ugroup == 1) { $query = "SELECT COUNT(1) AS total FROM ts_tickets_view WHERE status_name = 'Opened'"; $total = $this->db->fetchAssoc($query); } else { $query = "SELECT COUNT(1) AS total FROM ts_tickets_view WHERE author_id = " . $this->db->escapeVal($this->user->id); $total = $this->db->fetchAssoc($query); } $this->totalEntryNum = (int) $total['total']; $this->numPages = ceil($this->totalEntryNum / $this->entryPerPage); return $this->numPages; }
/** * Get all available categories. * * @access public * @return array */ public function displayCategories() { $allCats = $this->db->query("SELECT id, category_name FROM ts_ticket_category ORDER BY id"); $keys = array(); $values = array(); while (($categories = $this->db->fetchAssoc($allCats)) != NULL) { //array_push($keys, (int)$categories['id']); //array_push($values, $categories['category_name']); $keys[] = (int) $categories['id']; $values[] = $categories['category_name']; } return array_combine($keys, $values); }
/** * Search for user in database. Check whether user is * a numeric value, for example user id or is it an array * of user attributes. * * @access public * @param int | array * @return array | bool */ public function chkUserExistance($user) { if (is_numeric($user)) { $query = "\n\t\t\t\tSELECT id, username, userpass, email, ugroup\n\t\t\t\tFROM ts_users\n\t\t\t\tWHERE id = " . $this->db->escapeVal($user) . "\n\t\t\t\tLIMIT 1\n\t\t\t"; return $query; } else { if (is_array($user)) { $query = "\n\t\t\t\tSELECT id, username, userpass, email, ugroup\n\t\t\t\tFROM ts_users\n\t\t\t\tWHERE username = '******'username']) . "'\n\t\t\t\tOR email = '" . $this->db->escapeVal($user['email']) . "'\n\t\t\t\tLIMIT 1\n\t\t\t"; # If user not found if (!($row = $this->db->fetchAssoc($query))) { return false; } return true; } } }