boxiky/links.inc

   1 <br><center><b>linky</b></center><br>
   2 <?php
   3 $q="SELECT distinct links.link_text as link_text,forum.forum_name as forum_name,user.login as user_name,user.id as user_id ,user.user_action_param_name as user_action_param_name,user_action_param_id as user_action_param_id,user.user_action as user_action,user.user_mode as user_mode  FROM links left join user on links.link_owner=user.id left join forum on links.link_forum=forum.forum_id";
   4 $q.=" GROUP BY link_text ORDER BY link_id DESC LIMIT 50";
   5
   6 $set=$kyberia->query($q);
   7
   8 while ($set->next()) {
   9         $submissions=$set->getRecord();
  10         echo "<table class='bigitem'><tr><td class='icon'>";
  11         echo "<img alt='",$submissions['user_name'],"' src='/images/users/",strtolower($submissions['user_name']),".gif'>";
  12         echo "</td><td class='item'>";
  13         echo "<table class='item'>";
  14         echo "<td class='header'>";
  15         echo "forum:&nbsp;&nbsp;<a href='?action=forum&forum_id=",$submissions['forum_id'],"'>",$submissions['forum_name'],"</a><br>";
  16         echo $submissions['user_name'];
  17         if ($submissions['user_mode']=="normal" AND ($submissions['user_action'])) {
  18                 echo "&nbsp;[lokacia:<a class='location' href='?action=",$submissions['user_action'];
  19                 if ($submissions['user_action']=="forum") echo "&forum_id=".$submissions['user_action_param_id']."'>",$submissions['user_action_param_name'];
  20                 else echo "'>".$submissions['user_action'];
  21                 echo "</a>]&nbsp;";
  22         }
  23         if ($user_id==$submissions['submission_owner'] or $forumset['forum_owner']==$user_id) {
  24                 echo "&nbsp;&nbsp;&nbsp;&nbsp;<input class='delete' type=checkbox name=delete[] value='".$submissions['submission_id']."'>";
  25         }
  26         echo "</td>";
  27         echo "</tr>";
  28         echo "<tr class='content'><td class='content'><a href='",Stripslashes($submissions['link_text']),"'>",Stripslashes($submissions['link_text']),"</a></td></tr>";
  29         echo "</table>";
  30         echo "</td></tr></table>";
  31 }
  32
  33 ?>