Differences

This shows you the differences between two versions of the page.

--- wiki:auth:mysql_nucleus [2007-01-07 18:51] – created 85.176.177.97
+++ auth:mysql_nucleus [2008-12-09 20:48] – 70.103.232.219
@@ Line 1: / Line 1: @@
+====== Nucleus ======
+This configuration worked for me with MySQL version 5 and Nucleus 3.24. //[[mischins@imi.uni-luebeck.de|Andreas Mischinski]] 2007-01-07 18:50//
+<code php>
+$conf['auth']['mysql']['checkPass']= "SELECT mpassword AS login
+                                        FROM nucleus_member
+                                        WHERE mname='%{user}'
+                                        AND mpassword=MD5('%{pass}')";
+$conf['auth']['mysql']['getUserInfo'] = "SELECT mpassword AS pass, mname AS name, memail AS mail
+                                        FROM nucleus_member
+                                        WHERE mname='%{user}'";
+$conf['auth']['mysql']['getGroups']   = "SELECT bname as `group`
+                                        FROM nucleus_blog a, nucleus_member b, nucleus_team c
+                                        WHERE b.mnumber = c.tnumber
+                                        AND a.bnumber = c.tblog
+                                        AND b.mname='%{user}'";
+</code>