/** * @param string $account * @return null|Account */ public function getAccountByAccount($account) { $sql_array = array('SELECT' => '*', 'FROM' => array('sp_account' => 'a'), 'WHERE' => $this->db->sql_in_set('account', $account), 'ORDER_BY' => 'account_id'); $sql = $this->db->sql_build_query('SELECT', $sql_array); $result = $this->db->sql_query_limit($sql, 1); $row = $this->db->sql_fetchrow(); $this->db->sql_freeresult($result); return $row ? Account::load($row) : null; }