shop.balmet.com

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | README

api.php (833B)


      1 <?php
      2 class ModelAccountApi extends Model {
      3 	public function login($username, $key) {
      4 		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "api` WHERE `username` = '" . $this->db->escape($username) . "' `key` = '" . $this->db->escape($key) . "' AND status = '1'");
      5 
      6 		return $query->row;
      7 	}
      8 
      9 	public function addApiSession($api_id, $session_id, $ip) {
     10 		$this->db->query("INSERT INTO `" . DB_PREFIX . "api_session` SET api_id = '" . (int)$api_id . "', session_id = '" . $this->db->escape($session_id) . "', ip = '" . $this->db->escape($ip) . "', date_added = NOW(), date_modified = NOW()");
     11 
     12 		return $this->db->getLastId();
     13 	}
     14 
     15 	public function getApiIps($api_id) {
     16 		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "api_ip` WHERE api_id = '" . (int)$api_id . "'");
     17 
     18 		return $query->rows;
     19 	}
     20 }