Online list in guestbook

Последняя активность
Файлы топика
Тема закрыта
247
.
nalajcie
29 апр 2016 г., 8:41
i have question how to display users who are now on guestbook? and when they leave guestbook nick is deleted from online list of users in guestbook.
.
Macabre
29 апр 2016 г., 22:16
Wap Master
Что то типа этого
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `title_online`= 'guest' and `lastdate` > '" . ($realtime - 300) . "'"), 0)>0){
echo'<div class="list1">Кто в гостевой: ';
$onltime=$realtime-300;
$q=@mysql_query("select `id`, `name` from `users` where title_online = 'guest' and lastdate>='".intval($onltime)."' order by lastdate desc;"); 
while ($arr=mysql_fetch_array($q)) {
echo '<a href="'.$home.'/anketa/'.$arr['id'].'">'.$arr['name'].'</a>,&nbsp;';
}
echo'</div>';}
.
nalajcie
30 апр 2016 г., 12:12
@Macabre ill test it later
.
nalajcie
30 апр 2016 г., 14:32
For a little modif it work for me. Thank You @Macabre.
If someone need it here code what work for me:
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `place`= 'guestbook' and `lastdate` > '" . ($realtime - 20) . "'"), 0)>0){
echo'<div class="list1">Who is on chat: ';
$onltime=$realtime-20;
$q=mysql_query("select `id`, `name` from `users` where `place` = 'guestbook' and lastdate>='".intval($onltime)."' order by lastdate desc;"); 
while ($arr=mysql_fetch_array($q))
{echo '<a href="../users/profile.php?user='.$arr['id'].'">'.$arr['name'].'</a>,&nbsp;';}
echo'</div>';}

So thread can be closed.
Всего: 4
© 2024, JohnCMS