# HG changeset patch
# User Waqas Hussain <waqas20@gmail.com>
# Date 1340394272 -18000
# Node ID 97f6d7c4aaed6d8e2e881026b21b8c0f68615f8c
# Parent  5e71e24e33fc9e46cdc44ab9836d1ab2031b09d7
mod_auth_joomla: Added config option sql.prefix (default = "jos_").

diff -r 5e71e24e33fc -r 97f6d7c4aaed mod_auth_joomla/mod_auth_joomla.lua
--- a/mod_auth_joomla/mod_auth_joomla.lua	Sat Jun 23 00:42:01 2012 +0500
+++ b/mod_auth_joomla/mod_auth_joomla.lua	Sat Jun 23 00:44:32 2012 +0500
@@ -12,6 +12,7 @@
 
 local connection;
 local params = module:get_option("sql");
+local prefix = params and params.prefix or "jos_";
 
 local resolve_relative_path = require "core.configmanager".resolve_relative_path;
 
@@ -79,7 +80,7 @@
 end
 
 local function get_password(username)
-	local stmt, err = getsql("SELECT `password` FROM `jos_users` WHERE `username`=?", username);
+	local stmt, err = getsql("SELECT `password` FROM `"..prefix.."users` WHERE `username`=?", username);
 	if stmt then
 		for row in stmt:rows(true) do
 			return row.password;
@@ -119,7 +120,7 @@
 end
 function provider.set_password(username, password)
 	local hash = joomlaCreateHash(password);
-	local stmt, err = setsql("UPDATE `jos_users` SET `password`=? WHERE `username`=?", hash, username);
+	local stmt, err = setsql("UPDATE `"..prefix.."users` SET `password`=? WHERE `username`=?", hash, username);
 	return stmt and true, err;
 end
 function provider.create_user(username, password)