[SOLVED] show users online

[shaunrigby]

do you both have an IRC client such as mIRC?

[MadTechie]

na, would be easier if i did

[shaunrigby]

dload it mirc.com

 

[alohatofu]

this is so much easier working directly

 

ok updated (again)

 

<?php
$id = $_SESSION['tznUserId'];
$time=time();
$timeout=time()+(60*60); #now+1hour
mysql_query("UPDATE `surv_member` SET timestamp='$timeout' WHERE memberId='$id' LIMIT 1");

$query=mysql_query("SELECT * FROM `surv_member` WHERE `timestamp`>='$time'") or die(mysql_error());
$display = array();
while($row=mysql_fetch_array($query))
{
$display[] = $row['username'];
}

//spit out the results
mysql_close();
foreach($display as $d)
{
print "$d<br />";
}
?>

 

 

Still did not output any message =/

 

btw. I appreciate it Shaun and TEchie

[alohatofu]

do you both have an IRC client such as mIRC?

 

I have GAIM which can handle irc

[shaunrigby]

join #php-coding on irc.freenode.net

[shaunrigby]

madtech u dloadin mIRC?

[MadTechie]

ok

 

na don't use mIRC or any IRc's

 

<?php
$id = $_SESSION['tznUserId'];
mysql_query("UPDATE `surv_member` SET timestamp=NOW() WHERE memberId='$id' LIMIT 1");

$query=mysql_query("SELECT * FROM `surv_member` WHERE (`timestamp`+60*60) >=  NOW()") or die(mysql_error());
$display = array();
while($row=mysql_fetch_array($query))
{
$display[] = $row['username'];
}

//spit out the results
mysql_close();
foreach($display as $d)
{
print "$d<br />";
}
?>

[alohatofu]

Holy crap!!

 

[shaunrigby]

After all of that lol, please rem,ember to set your thread as resolved,

 

TA

[alohatofu]

Thank you so much guys!! AWSOME! it's like magic

[MadTechie]

i had to re-work the dates, they can be a pain sometimes

[MadTechie]

ok 1:21am i'm out night i hope its truly working.

[alohatofu]

yes it's working!!!

 

btw, I don't need the online and timestamp column righgt?

[alohatofu]

Ok, when I logged out it's still showing my username

 

=/

[MadTechie]

correct,

 

runs by time alone if they are inactive for an hour then they are off the list,

 

$query=mysql_query("SELECT * FROM `surv_member` WHERE (`timestamp`+60*60) >=  NOW()") or die(mysql_error());

 

change (`timestamp`+60*60) to (`timestamp`+30*60) for 30 minutes etc

[alohatofu]

cool. that will work. thanks

[MadTechie]

Oh this is used for active members for in the last hour,

 

if you want then to be removed from the list on logout

add this to the logout

 

$id = $_SESSION['tznUserId'];
mysql_query("UPDATE `surv_member` SET timestamp=NOW() WHERE memberId='$id' LIMIT 1");

 

 

Oh this would work better

<?php
$query=mysql_query("SELECT * FROM `surv_member` WHERE `timestamp` <=  (NOW()-60*60)") or die(mysql_error());
?>

 

 

 

OK well i am drained, i need sleep, catch ya later

[otuatail]

this means then that you have not got a field in your table surv_member called 'timestamp'

don't forget case sensitive. In phpmyadmin there is an export button on the top click this and click the

bottom button Go. You will have the text for creating the database table. show it to us.

 

Desmond.

 

[alohatofu]

This issue is resolved thanks