yuriorlov Posted March 11, 2008 Share Posted March 11, 2008 historical tracking for your users online page add this code somewhere on your users online page: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. here is the sql for it You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
iseeyou94056 Posted March 11, 2008 Share Posted March 11, 2008 Re: Upgrade Users Online nice little mod Quote Link to comment Share on other sites More sharing options...
yuriorlov Posted March 11, 2008 Author Share Posted March 11, 2008 Re: Upgrade Users Online thanks If I don't get flamed I'll add more, I have used a bunch of stuff from this forum. (granted most of the stuff doesn't work out of the box 90% of the time) If you see a mod from me you can be sure its been tested thoroughly Quote Link to comment Share on other sites More sharing options...
Ghetto Posted March 11, 2008 Share Posted March 11, 2008 Re: Upgrade Users Online Good little feature, But you missed 2 lines of code at the top. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
yuriorlov Posted March 11, 2008 Author Share Posted March 11, 2008 Re: Upgrade Users Online good catch, I guess I selected from the wrong spot to start Quote Link to comment Share on other sites More sharing options...
Haunted Dawg Posted March 11, 2008 Share Posted March 11, 2008 Re: Upgrade Users Online I already had this for my users online it tracks the users online with in 1 minute and all :D but thanks for providing the code to others. :-) Quote Link to comment Share on other sites More sharing options...
Isomerizer Posted March 11, 2008 Share Posted March 11, 2008 Re: Upgrade Users Online To get this working. Once you've create the table. Run this SQL: INSERT INTO `records` ( `recID` , `rec24` , `rec60` , `rec15` ) VALUES ( '1', '1', '1', '1' ); Reason? WHERE recid=1 The table starts empty, with no recID with the value of 1. Quote Link to comment Share on other sites More sharing options...
Krafty Posted March 15, 2008 Share Posted March 15, 2008 Re: Upgrade Users Online You took the words outta my mouth Iso Quote Link to comment Share on other sites More sharing options...
Note i didn't make this mo Posted March 15, 2008 Share Posted March 15, 2008 Re: Upgrade Users Online Very Nice And Well Thought Of ... Quote Link to comment Share on other sites More sharing options...
Guest Anonymous Posted March 15, 2008 Share Posted March 15, 2008 Re: Upgrade Users Online Waste of a table that -- Slap it into one query... SELECT 5 AS minutes, COUNT(username) AS users FROM users WHERE laston >= UNIX_TIMESTAMP() - (5 * 60) UNION SELECT 15 AS minutes, COUNT(username) AS users FROM users WHERE laston >= UNIX_TIMESTAMP() - (15 * 60) UNION SELECT 30 AS minutes, COUNT(username) AS users FROM users WHERE laston >= UNIX_TIMESTAMP() - (30 * 60) Add further UNION statements as appropriate Quote Link to comment Share on other sites More sharing options...
Yuri_orlov Posted April 12, 2008 Share Posted April 12, 2008 Re: Upgrade Users Online the table is only for keeping historic records... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.