Commit | Line | Data |
---|---|---|
bc13d5d6 H |
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 | ?> |