I know this has been discussed before...and I remember Jerry Su addressing this in the past (but I can't seem to find the relevant Thread) and I did search the Links SQL FAQ site, but couldn't find the relevant link.
Here is the problem....
Users are logging in twice to my site and thus creating duplicate Session records in the Sessions table. I know this because I wrote a script over the weekend that shows online users:
http://vlib.anthrotech.com/bin/online.cgi
and as you can see by clicking on either link, User with the ID of 143 is logged in twice.
Would somebody direct me to the relevant Thread or link in the FAQ site that may provide a fix for this? I thought about adding in codes in the sub login_user routine in the user.cgi script that checks the Session table first with the Username used to login and if there is a duplicate, then ignore the Session creation codes. But if this has already been addressed before, then it would save me time hacking the script.
Thanks in advance.
Regards,
Eliot Lee
Here is the problem....
Users are logging in twice to my site and thus creating duplicate Session records in the Sessions table. I know this because I wrote a script over the weekend that shows online users:
http://vlib.anthrotech.com/bin/online.cgi
and as you can see by clicking on either link, User with the ID of 143 is logged in twice.
Would somebody direct me to the relevant Thread or link in the FAQ site that may provide a fix for this? I thought about adding in codes in the sub login_user routine in the user.cgi script that checks the Session table first with the Username used to login and if there is a duplicate, then ignore the Session creation codes. But if this has already been addressed before, then it would save me time hacking the script.
Thanks in advance.
Regards,
Eliot Lee