1 <br><center><b>linky</b></center><br>
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";
6 $set=$kyberia->query($q);
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: <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 " [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'];
23 if ($user_id==$submissions['submission_owner'] or $forumset['forum_owner']==$user_id) {
24 echo " <input class='delete' type=checkbox name=delete[] value='".$submissions['submission_id']."'>";
28 echo "<tr class='content'><td class='content'><a href='",Stripslashes($submissions['link_text']),"'>",Stripslashes($submissions['link_text']),"</a></td></tr>";
30 echo "</td></tr></table>";