Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - b4 active user bug
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

b4 active user bug

 Post Reply Post Reply Page  <12
Author
fernan82 View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 17 November 2002
Location: United States
Status: Offline
Points: 362
Post Options Post Options   Thanks (0) Thanks(0)   Quote fernan82 Quote  Post ReplyReply Direct Link To This Post Posted: 24 March 2003 at 8:37am

I add a new stored procedure to check the user ID instead of the IP and change the code in active_users_inc.asp to this:

If lngActiveUsersID <> 2 Then
If strDatabaseType = "SQLServer" Then
 strSQL = "EXECUTE wwfSpActiveUsersWhereIDis @lngActiveUsersID = '" & lngActiveUsersID & "'"
Else
 strSQL = "SELECT " & strDbTable & "ActiveUser.* From " & strDbTable & "ActiveUser WHERE Author_ID='" & lngActiveUsersID & "';"
End If
Else
If strDatabaseType = "SQLServer" Then
 strSQL = "EXECUTE " & strDbProc & "ActiveUsersWhereIPis @strIPAddress = '" & strIPAddress & "'"
Else
 strSQL = "SELECT " & strDbTable & "ActiveUser.* From " & strDbTable & "ActiveUser WHERE IP='" & strIPAddress & "';"
End If
End If

That way if the user is a guest it checks the IP and if the user is not a guest it checks the user ID, it should make it more accurate and shouldn't affect performance, what you think?



Edited by fernan82
FeRnAN
Back to Top
vdub View Drop Down
Senior Member
Senior Member
Avatar

Joined: 23 February 2003
Location: United States
Status: Offline
Points: 275
Post Options Post Options   Thanks (0) Thanks(0)   Quote vdub Quote  Post ReplyReply Direct Link To This Post Posted: 24 March 2003 at 10:59am

Originally posted by doublelfan doublelfan wrote:

Could be with aol users running through the proxy...but then shouldn't that effect the session as well?

AOL dose that alot. one person can look like 400 people. each hit has a difrent IP

Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.