yakka/storage-providers/YakkaMySqlUserAdapter.php

<?php

require_once("YakkaMySqlDatabase.php");
require_once("library/YakkaUser.php");

class YakkaMySqlUserAdapter extends YakkaMySqlDatabase {
        var $table;
        var $roleTable;
        var $roleAssignmentTable;

        function YakkaMySqlUserAdapter($parameters = null) {
                $this->YakkaMySqlDatabase();

                if ($parameters)
                        $this->connect($parameters["host"], $parameters["database"], $parameters["user"], $parameters["password"]);

                if (!$prefix = $parameters["table-prefix"]) {
                        $this->table = "users";
                        $this->roleTable = "roles";
                        $this->roleAssignmentTable = "user_role_asgs";
                } else {
                        $this->table = $prefix."users";
                        $this->roleTable = $prefix."roles";
                        $this->roleAssignmentTable = $prefix."user_role_asgs";
                }
        }

        function loadUser($id) {
                $id = $this->escapeString($id);
                $sql = 
<<<MYSQL
SELECT
        user_tag,
        user_name
FROM
        $this->table
WHERE
        user_tag = '$id'
LIMIT 1
MYSQL;
                if ($result = $this->queryRecord($sql))
                        return array(
                                "id" => $result["user_tag"],
                                "name" => $result["user_name"]
                        );

                return null;
        }

        function authenticateUser($username, $password) {
                $username = $this->escapeString($username);
                $password = $this->escapeString(md5($password));
                $sql =
<<<MYSQL
SELECT
        user_tag,
        user_name
FROM
        $this->table
WHERE
        user_username = '$username'
AND
        user_password = '$password'
LIMIT 1
MYSQL;
                if ($result = $this->queryRecord($sql))
                        return array(
                                "id" => $result["user_tag"],
                                "name" => $result["user_name"]
                        );

                return null;
        }

        function loadUserRoles($id) {
                $id = $this->escapeString($id);
                $sql = 
<<<MYSQL
SELECT
        role_tag as id
FROM
        $this->roleTable,
        $this->roleAssignmentTable,
        $this->table
WHERE
        user_tag = '$id'
AND
        user_id = uras_user_id
AND
        uras_role_id = role_id
MYSQL;
                if ($result = $this->queryRecordset($sql))
                        return $result;

                return null;
        }

        function loadRole($id) {
                $id = $this->escapeString($id);
                $sql = 
<<<MYSQL
SELECT
        role_tag,
        role_name,
        role_comment
FROM
        $this->roleTable
WHERE
        role_tag = '$id'
LIMIT 1
MYSQL;

                if ($result = $this->queryRecord($sql))
                        return array(
                                "id" => $result["role_tag"],
                                "name" => $result["role_name"],
                                "comment" => $result["role_comment"]
                        );

                return null;
        }
}

?>
1	bareface	1.1	<?php
2
3			require_once("YakkaMySqlDatabase.php");
4			require_once("library/YakkaUser.php");
5
6			class YakkaMySqlUserAdapter extends YakkaMySqlDatabase {
7			var $table;
8			var $roleTable;
9			var $roleAssignmentTable;
10
11			function YakkaMySqlUserAdapter($parameters = null) {
12			$this->YakkaMySqlDatabase();
13
14			if ($parameters)
15			$this->connect($parameters["host"], $parameters["database"], $parameters["user"], $parameters["password"]);
16
17			if (!$prefix = $parameters["table-prefix"]) {
18			$this->table = "users";
19			$this->roleTable = "roles";
20			$this->roleAssignmentTable = "user_role_asgs";
21			} else {
22			$this->table = $prefix."users";
23			$this->roleTable = $prefix."roles";
24			$this->roleAssignmentTable = $prefix."user_role_asgs";
25			}
26			}
27
28			function loadUser($id) {
29			$id = $this->escapeString($id);
30			$sql =
31			<<<MYSQL
32			SELECT
33			user_tag,
34			user_name
35			FROM
36			$this->table
37			WHERE
38			user_tag = '$id'
39			LIMIT 1
40			MYSQL;
41			if ($result = $this->queryRecord($sql))
42			return array(
43			"id" => $result["user_tag"],
44			"name" => $result["user_name"]
45			);
46
47			return null;
48			}
49
50			function authenticateUser($username, $password) {
51			$username = $this->escapeString($username);
52			$password = $this->escapeString(md5($password));
53			$sql =
54			<<<MYSQL
55			SELECT
56			user_tag,
57			user_name
58			FROM
59			$this->table
60			WHERE
61			user_username = '$username'
62			AND
63			user_password = '$password'
64			LIMIT 1
65			MYSQL;
66			if ($result = $this->queryRecord($sql))
67			return array(
68			"id" => $result["user_tag"],
69			"name" => $result["user_name"]
70			);
71
72			return null;
73			}
74
75			function loadUserRoles($id) {
76			$id = $this->escapeString($id);
77			$sql =
78			<<<MYSQL
79			SELECT
80			role_tag as id
81			FROM
82			$this->roleTable,
83			$this->roleAssignmentTable,
84			$this->table
85			WHERE
86			user_tag = '$id'
87			AND
88			user_id = uras_user_id
89			AND
90			uras_role_id = role_id
91			MYSQL;
92			if ($result = $this->queryRecordset($sql))
93			return $result;
94
95			return null;
96			}
97
98			function loadRole($id) {
99			$id = $this->escapeString($id);
100			$sql =
101			<<<MYSQL
102			SELECT
103			role_tag,
104			role_name,
105			role_comment
106			FROM
107			$this->roleTable
108			WHERE
109			role_tag = '$id'
110			LIMIT 1
111			MYSQL;
112
113			if ($result = $this->queryRecord($sql))
114			return array(
115			"id" => $result["role_tag"],
116			"name" => $result["role_name"],
117			"comment" => $result["role_comment"]
118			);
119
120			return null;
121			}
122			}
123
124			?>
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26