yuriorlov Posted March 11, 2008 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
iseeyou94056 Posted March 11, 2008 Posted March 11, 2008 Re: Upgrade Users Online nice little mod Quote
yuriorlov Posted March 11, 2008 Author 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
Ghetto Posted March 11, 2008 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
yuriorlov Posted March 11, 2008 Author Posted March 11, 2008 Re: Upgrade Users Online good catch, I guess I selected from the wrong spot to start Quote
Haunted Dawg Posted March 11, 2008 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
Isomerizer Posted March 11, 2008 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
Krafty Posted March 15, 2008 Posted March 15, 2008 Re: Upgrade Users Online You took the words outta my mouth Iso Quote
Note i didn't make this mo Posted March 15, 2008 Posted March 15, 2008 Re: Upgrade Users Online Very Nice And Well Thought Of ... Quote
Guest Anonymous Posted March 15, 2008 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
Yuri_orlov Posted April 12, 2008 Posted April 12, 2008 Re: Upgrade Users Online the table is only for keeping historic records... Quote
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.