Singel Signon MYSQL Authentication

maxhorizon · Joined: 28 Aug 2007 Posts: 7

I used the MySQL Module .. i can login to Thyme using my user table.. but i want to be able to login to thyme using my own login page .. can I do that ?

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi,

It depends on how you are storing their user information. When they log into your site, how does it keep track of who has logged in?

maxhorizon · Joined: 28 Aug 2007 Posts: 7

I have a session variable called $_SESSION['kt_login_id'] that I always validate to make sure it's alive and not empty.

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi,

Is that the numeric id or the userid?

maxhorizon · Joined: 28 Aug 2007 Posts: 7

$_SESSION['kt_login_id'] is numeric value while the user name text value is stored in $_SESSION['kt_login_user']

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi,

You'll want to place this in your MySQL authentication module below line 83:

maxhorizon · Joined: 28 Aug 2007 Posts: 7

Thanks for the fast reply
This works perfectly .. I think to logout the thyme system I need to make the $_SESSION['uid'] null in my own logout mechanism .. right?

Thanks again .. wonderful software

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

It really depends. Can you explain your site's logout mechanism a little please?

maxhorizon · Joined: 28 Aug 2007 Posts: 7

It's simple actually. I use the following logic to check the login status

if (!isset($_SESSION['kt_login_user'])) then {NOT_LOGGED} else {LOGGED}

So I basically make the variables $_SESSION['kt_login_user'] and $_SESSION['kt_login_id'] null at the logout to make sure I don't go through the LOGGED code block.

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Then yes, you could probably do something more simple actually: