boxiky/forumstats.inc

   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>";