summaryrefslogtreecommitdiffstats
path: root/application/libraries/Duser/drivers/Duser_db.php
blob: e1df20f1f38024c814125029056d863c493badec (plain)
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
<?php
/*
 * Copyright 2013 Florian "Bluewind" Pritz <bluewind@server-speed.net>
 *
 * Licensed under AGPLv3
 * (see COPYING for full license text)
 *
 */

class Duser_db extends Duser_Driver {

	/* FIXME: If you use this driver as a template, remove can_reset_password
	 * and can_register_new_users. These features require the DB driver and
	 * will NOT work with other drivers.
	 */
	public $optional_functions = array(
		'can_reset_password',
		'can_register_new_users',
		'can_change_email',
		'can_delete_account',
	);

	public function login($username, $password)
	{
		$CI =& get_instance();

		if ($username === null) {
			return false;
		}

		$query = $CI->db->select('username, id, password')
			->from('users')
			->where('username', $username)
			->get()->row_array();

		if (empty($query)) {
			return false;
		}

		if (password_verify($password, $query['password'])) {
			$CI->muser->rehash_password($query['id'], $password, $query['password']);
			return array(
				"username" => $username,
				"userid" => $query["id"]
			);
		} else {
			return false;
		}
	}

	public function username_exists($username)
	{
		$CI =& get_instance();

		if ($username === null) {
			return false;
		}

		$query = $CI->db->select('id')
			->from('users')
			->where('username', $username)
			->get();

		if ($query->num_rows() > 0) {
			return true;
		} else {
			return false;
		}
	}

	public function get_email($userid)
	{
		$CI =& get_instance();

		if ($userid === null) {
			throw new \exceptions\ApiException("libraries/duser/db/get_email-failed", "User does not exist");
		}

		$query = $CI->db->select('email')
			->from('users')
			->where('id', $userid)
			->get()->row_array();

		if (empty($query)) {
			throw new \exceptions\ApiException("libraries/duser/db/get_email-failed", "Failed to get email address from db");
		}

		return $query["email"];
	}

}