ThaiSEOBoard.com

$this->db->query("INSERT INTO " . DB_PREFIX . "customer SET email = '" . $this->db->escape($data['email']) . "',password = '" . $this->db->escape(sha1($salt . sha1($salt . sha1($data['password'])))) . "';

define('DB_NAME', 'acsite');
define('DB_USER', 'user');
define('DB_HOST', 'localhost');
$table_prefix  = 'ac_';

public function editPassword($email, $password) {
      	$this->db->query("UPDATE " . DB_PREFIX . "customer SET salt = '" . $this->db->escape($salt = substr(md5(uniqid(rand(), true)), 0, 9)) . "', password = '" . $this->db->escape(sha1($salt . sha1($salt . sha1($password)))) . "' WHERE LOWER(email) = '" . $this->db->escape(utf8_strtolower($email)) . "'");
	}