backend_ejabberd_postgres.php

<?php

Class RegistrationBackend {

	protected $dbconn;
	
	function init($config)
	{
		$this->dbconn = pg_connect("host={$config['dbhost']} dbname={$config['dbname']}\
			 user={$config['dbuser']} password={$config['dbpass']}")
		    or die('Could not connect: ' . pg_last_error());
	}

	function validate($user, $pass)
	{
		return FALSE;
	}
	
	function exists($user)
	{
		$result = pg_query_params('SELECT * FROM users WHERE username = $1 LIMIT 1',
			array($user));
		if (pg_num_rows($result) > 0 )
			return TRUE;
		return FALSE;
	}
	
	function create($user, $pass)
	{
		return pg_query_params('INSERT INTO users ("username", "password") VALUES($1, $2)',
			array($user, $pass));
	}
	
	function close()
	{
		pg_close($this->dbconn);
	}
}	

?>