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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
|
<?php
/**
* MySQL authentication backend
*
* PHP's MySQL extension is needed
*
* @license GPL 2 (http://www.gnu.org/licenses/gpl.html)
* @author Andreas Gohr <andi@splitbrain.org>
*/
//check for MySQL extension on load
if(!function_exists('mysql_connect'))
msg("MySQL extension not found",-1);
/**
* Execute SQL
*
* Executes SQL statements and returns the results as list
* of hashes. Returns false on error. Returns auto_increment
* IDs on INSERT statements.
*
* @author Andreas Gohr <andi@splitbrain.org>
*/
function auth_mysql_runsql($sql_string) {
global $conf;
$cnf = $conf['auth']['mysql'];
$link = @mysql_connect ($cnf['server'], $cnf['user'], $cnf['password']);
if(!$link){
msg('MySQL: Connection to database failed!',-1);
return false;
}
$result = @mysql_db_query($cnf['database'],$sql_string,$link);
if(!$result){
msg('MySQL: '.mysql_error($link));
return false;
}
//mysql_db_query returns 1 on a insert statement -> no need to ask for results
if ($result != 1) {
for($i=0; $i< mysql_num_rows($result); $i++) {
$temparray = mysql_fetch_assoc($result);
$resultarray[]=$temparray;
}
mysql_free_result ($result);
} elseif (mysql_insert_id($link)) {
$resultarray = mysql_insert_id($link); //give back ID on insert
} else
$resultarray = 0; // asure that the return value is valid
mysql_close ($link);
return $resultarray;
}
/**
* Check user+password [required auth function]
*
* Checks if the given user exists and the given
* plaintext password is correct. Furtheron it
* might be checked wether the user is member of
* the right group
*
* @author Andreas Gohr <andi@splitbrain.org>
* @author Matthias Grimm <matthiasgrimm@users.sourceforge.net>
* @return bool
*/
function auth_checkPass($user,$pass){
global $conf;
$cnf = $conf['auth']['mysql'];
$sql = str_replace('%u',addslashes($user),$cnf['passcheck']);
$sql = str_replace('%g',addslashes($conf['defaultgroup']),$sql);
$result = auth_mysql_runsql($sql);
if(count($result)){
return(auth_verifyPassword($pass,$result[0]['pass']));
}else{
return(false);
}
}
/**
* Return user info [required auth function]
*
* Returns info about the given user needs to contain
* at least these fields:
*
* name string full name of the user
* mail string email addres of the user
* grps array list of groups the user is in
*
* @author Andreas Gohr <andi@splitbrain.org>
*/
function auth_getUserData($user){
global $conf;
$cnf = $conf['auth']['mysql'];
$sql = str_replace('%u',addslashes($user),$cnf['userinfo']);
$result = auth_mysql_runsql($sql);
if(!count($result)) return false;
$info = $result[0];
$sql = str_replace('%u',addslashes($user),$cnf['groups']);
$result = auth_mysql_runsql($sql);
if(!count($result)){
$info['grps'][] = $conf['defaultgroup'];
}else{
foreach($result as $row){
$info['grps'][] = $row['group'];
}
}
return $info;
}
/**
* Create a new User [required auth function]
*
* user string username
* pass string password
* name string full name of the user
* mail string email address
*
* Returns false if the user already exists, null when an error
* occoured and the cleartext password of the new user if
* everything went well.
*
* The user HAS TO be added to the default group by this
* function
*
* @author Matthias Grimm <matthiasgrimm@users.sourceforge.net>
*/
function auth_createUser($user,$pass,$name,$mail){
global $conf;
$cnf = $conf['auth']['mysql'];
//check if user exists
$info = auth_getUserData($user);
if ($info != false) return false;
//get groupid of default group
if($cnf['getgroupid']){
$sql = str_replace('%g',addslashes($conf['defaultgroup']),$cnf['getgroupid']);
$result = auth_mysql_runsql($sql);
if($result === false) return null;
if (count($result) == 1){
$gid = $result[0]['gid'];
}else{
msg("MySQL: Couldn't find the default group",-1);
return null;
}
}
//prepare the insert
$sql = str_replace('%u' ,addslashes($user),$cnf['adduser']);
$sql = str_replace('%p' ,addslashes(auth_cryptPassword($pass)),$sql);
$sql = str_replace('%n' ,addslashes($name),$sql);
$sql = str_replace('%e' ,addslashes($mail),$sql);
$sql = str_replace('%gid',addslashes($gid),$sql);
$sql = str_replace('%g' ,addslashes($conf['defaultgroup']),$sql);
//do the insert
$uid = auth_mysql_runsql($sql);
if($uid == 0){
msg("Registering of the new user '$user' failed!", -1);
return null;
}
//add to default group
if ($cnf['addusergroup']) {
$sql = str_replace('%uid',addslashes($uid),$cnf['addusergroup']);
$sql = str_replace('%u' ,addslashes($user),$sql);
$sql = str_replace('%gid',addslashes($gid),$sql);
$sql = str_replace('%g' ,addslashes($conf['defaultgroup']),$sql);
$result = auth_mysql_runsql($sql);
if($result === false) msg("MySQL: couldn't add user to the default group");
}
return $pass;
}
//Setup VIM: ex: et ts=2 enc=utf-8 :
|
