Mercurial > prosody-modules

comparison mod_auth_wordpress/mod_auth_wordpress.lua @ 426:6f2e37d0a1b0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
mod_auth_wordpress: Allow table prefix to be configured
author Kim Alvefur <zash@zash.se>
date Sun, 11 Sep 2011 22:53:23 +0200
parents 34eb9df9e37f
children 35b3ea156156
comparison
equal deleted inserted replaced
425:34eb9df9e37f 426:6f2e37d0a1b0
11 local md5 = require "util.hashes".md5; 11 local md5 = require "util.hashes".md5;
12 local uuid_gen = require "util.uuid".generate; 12 local uuid_gen = require "util.uuid".generate;
13 13
14 local connection; 14 local connection;
15 local params = module:get_option("sql"); 15 local params = module:get_option("sql");
16 local table_prefix = module:get_option_string("wordpress_table_prefix", "wp_");
16 17
17 local resolve_relative_path = require "core.configmanager".resolve_relative_path; 18 local resolve_relative_path = require "core.configmanager".resolve_relative_path;
18 19
19 local function test_connection() 20 local function test_connection()
20 if not connection then return nil; end 21 if not connection then return nil; end
78 if not stmt then return stmt, err; end 79 if not stmt then return stmt, err; end
79 return stmt:affected(); 80 return stmt:affected();
80 end 81 end
81 82
82 local function get_password(username) 83 local function get_password(username)
83 local stmt, err = getsql("SELECT `user_pass` FROM `wp_users` WHERE `user_login`=?", username); 84 local stmt, err = getsql("SELECT `user_pass` FROM `"..table_prefix.."users` WHERE `user_login`=?", username);
84 if stmt then 85 if stmt then
85 for row in stmt:rows(true) do 86 for row in stmt:rows(true) do
86 return row.user_password; 87 return row.user_password;
87 end 88 end
88 end 89 end
188 function provider.get_password(username) 189 function provider.get_password(username)
189 return nil, "Getting password is not supported."; 190 return nil, "Getting password is not supported.";
190 end 191 end
191 function provider.set_password(username, password) 192 function provider.set_password(username, password)
192 local hash = wordpressCreateHash(password); 193 local hash = wordpressCreateHash(password);
193 local stmt, err = setsql("UPDATE `wp_users` SET `user_pass`=? WHERE `user_login`=?", hash, username); 194 local stmt, err = setsql("UPDATE `"..table_prefix.."users` SET `user_pass`=? WHERE `user_login`=?", hash, username);
194 return stmt and true, err; 195 return stmt and true, err;
195 end 196 end
196 function provider.create_user(username, password) 197 function provider.create_user(username, password)
197 return nil, "Account creation/modification not supported."; 198 return nil, "Account creation/modification not supported.";
198 end 199 end