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 }