Commit | Line | Data |
---|---|---|
bc13d5d6 H |
1 | <br> |
2 | <?php | |
3 | $set2=$kyberia->query("select user_id from session group by session.user_id"); | |
4 | while ($set2->next()){ | |
5 | $onl[$set2->getString('user_id')]=$set2->getString('user_id'); | |
6 | } | |
7 | $set=$kyberia->query("select DATE_FORMAT(user_forum.last_visit,'%k:%i:%s') AS datetime,user_forum.*,user.login,user.id as user_id from user_forum left join user on user.id=user_forum.user_id where (forum_id='$node_id' and user_bookmark='yes') ORDER by user_forum.submission_count asc "); | |
8 | echo "<table><tr><td colspan='2' align='center' style='color: red'>booked</td><tr><td>user</td><td>not read</td>"; | |
9 | while ($set->next()) { | |
10 | if ($onl[$set->getString('user_id')]) {$onlflag="@";} else {$onlflag="";} | |
11 | if ($friend_array[$set->getString('user_id')]){ | |
12 | echo "<tr><td><b>",$set->getString('login'),"<b> $onlflag</td><td align=center>",$set->getString('submission_count'),"</td></tr>"; | |
13 | }else{ | |
14 | echo "<tr><td>",$set->getString('login')," $onlflag</td><td align=center>",$set->getString('submission_count'),"</td></tr>"; | |
15 | } | |
16 | } | |
17 | echo "</table>"; |