| 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: <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']; |
| 21 | echo "</a>] "; |
| 22 | } |
| 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']."'>"; |
| 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 | ?> |