backend_ejabberd_postgres.php

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<?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);
	}
}	

?>