| 1 | <?php |
| 2 | if ($show=="karma") { |
| 3 | |
| 4 | $q="select submissions.*,user.login as user_name,forum.forum_name as forum_name from submissions left join forum on submissions.forum_id=forum.forum_id left join user on submissions.submission_owner=user.id where submission_owner='".$node_id."' and submission_k>0"; |
| 5 | $q.=" ORDER BY submission_k desc"; |
| 6 | $set=$kyberia->query($q); |
| 7 | |
| 8 | while ($set->next()) { |
| 9 | $submissions=$set->getRecord(); |
| 10 | echo "<table class='bigitem'><tr><td class='icon'>"; |
| 11 | // $submissions['submission_text'] = preg_replace ("/<img src=(.*?)>/","obrazok: <a href=\\1>\\1</a>",$submissions['submission_text']); |
| 12 | echo "<img alt='",$submissions['user_name'],"' src='/images/users/",strtolower($submissions['user_name']),".gif'>"; |
| 13 | echo "<center><font color='red'>",$submissions['submission_k']," K</font></center>"; |
| 14 | echo "</td><td class='item'>"; |
| 15 | echo "<table class='item'>"; |
| 16 | echo "<td class='header'>"; |
| 17 | echo "forum: <a href='?action=forum&node_id=",$submissions['forum_id'],"'>",$submissions['forum_name'],"</a><br>"; |
| 18 | echo $submissions['user_name']; |
| 19 | if ($submissions['user_mode']=="normal" AND ($submissions['user_action'])) { |
| 20 | Showz::showLocation($submissions['user_action'],$submissions['user_action_id'],$submissions['user_action_name']); |
| 21 | } |
| 22 | Showz::showDate($submissions['submission_timestamp']); |
| 23 | |
| 24 | echo "</td>"; |
| 25 | echo "</tr>"; |
| 26 | echo "<tr class='content'><td class='content'>",Stripslashes($submissions['submission_text']),"</td></tr>"; |
| 27 | echo "</table>"; |
| 28 | echo "</td></tr></table>"; |
| 29 | } |
| 30 | |
| 31 | |
| 32 | } |
| 33 | elseif ($show=="submissions") { |
| 34 | if (!$_GET['offset']) $offset=0; |
| 35 | else $offset=$_GET['offset']; |
| 36 | echo "<br><br><center><b>uzivatelove prispevky</b></center>"; |
| 37 | echo "<br><Br><center>"; |
| 38 | if ($offset) echo "<a href='".SCRIPT."?action=userinfo&node_id=$node_id&show=submissions&offset=".($offset-23)."'><<predchadzajuce</a> "; |
| 39 | echo "<a href='".SCRIPT."?action=userinfo&node_id=$node_id&show=submissions&offset=".($offset+23)."'>dalsi >></a>"; |
| 40 | echo "</center><br><br>"; |
| 41 | $q="select submissions.*,user.login as user_name,forum.forum_name as forum_name,forum.forum_public as forum_public from submissions left join forum on submissions.forum_id=forum.forum_id left join user on submissions.submission_owner=user.id where forum_public='public' and submission_owner='".$node_id."' "; |
| 42 | $q.=" ORDER BY submission_timestamp desc limit $offset,23"; |
| 43 | $set=$kyberia->query($q); |
| 44 | |
| 45 | while ($set->next()) { |
| 46 | $submissions=$set->getRecord(); |
| 47 | echo "<table class='bigitem'><tr><td class='icon'>"; |
| 48 | // $submissions['submission_text'] = preg_replace ("/<img src=(.*?)>/","obrazok: <a href=\\1>\\1</a>",$submissions['submission_text']); |
| 49 | echo "<img alt='",$submissions['user_name'],"' src='/images/users/",strtolower($submissions['user_name']),".gif'>"; |
| 50 | echo "<center><font color='red'>",$submissions['submission_k']," K</font></center>"; |
| 51 | echo "</td><td class='item'>"; |
| 52 | echo "<table class='item'>"; |
| 53 | echo "<td class='header'>"; |
| 54 | echo "forum: <a href='?action=forum&node_id=",$submissions['forum_id'],"'>",$submissions['forum_name'],"</a><br>"; |
| 55 | echo $submissions['user_name']; |
| 56 | if ($submissions['user_mode']=="normal" AND ($submissions['user_action'])) { |
| 57 | Showz::showLocation($submissions['user_action'],$submissions['user_action_id'],$submissions['user_action_name']); |
| 58 | } |
| 59 | Showz::showDate($submissions['submission_timestamp']); |
| 60 | |
| 61 | echo "</td>"; |
| 62 | echo "</tr>"; |
| 63 | echo "<tr class='content'><td class='content'>",Stripslashes($submissions['submission_text']),"</td></tr>"; |
| 64 | echo "</table>"; |
| 65 | echo "</td></tr></table>"; |
| 66 | } |
| 67 | |
| 68 | |
| 69 | } |
| 70 | |
| 71 | |
| 72 | elseif ($show=="bookmarks") { |
| 73 | echo "<br><br><center><b>uzivatelove kluby</b></center>"; |
| 74 | $q="SELECT * from forum WHERE forum.forum_owner='$node_id'"; |
| 75 | $q.=" order by forum_name "; |
| 76 | $forumset=$kyberia->query($q); |
| 77 | while ($forumset->next()) { |
| 78 | echo "<br> <a href='?action=forum&node_id=",$forumset->getString('forum_id'),"'>",$forumset->getString('forum_name'),"</a> (".$forumset->getString('forum_submissions')." submissionz "; |
| 79 | if ($forumset->getString('submission_count')) echo "- <font color='red'>".$forumset->getString('submission_count')." NEW</font>"; |
| 80 | echo ")"; |
| 81 | } |
| 82 | ?> |
| 83 | <br><br><center><b>uzivatelove bookmarknute kluby</b></center> |
| 84 | <?php |
| 85 | $q="SELECT user_forum.submission_count,user.login,forum.* from forum left join user on forum.forum_owner=user.id left join user_forum on (forum.forum_id=user_forum.forum_id and user_forum.user_id='$node_id')"; |
| 86 | $q.=" WHERE user_forum.user_bookmark='yes' and forum.forum_owner != '$node_id'"; |
| 87 | $q.=" order by forum_name "; |
| 88 | $forumset=$kyberia->query($q); |
| 89 | while ($forumset->next()) { |
| 90 | echo "<br> <a href='?action=forum&node_id=",$forumset->getString('forum_id'),"'>",$forumset->getString('forum_name'),"</a> (".$forumset->getString('login')." :: ".$forumset->getString('forum_submissions')." submissionz "; |
| 91 | if ($forumset->getString('submission_count')) echo "- <font color='red'>".$forumset->getString('submission_count')." NEW</font>"; |
| 92 | echo ")"; |
| 93 | } |
| 94 | } |
| 95 | |
| 96 | |
| 97 | elseif($show=="friends") { |
| 98 | $result=mysql_query("select session.user_action,session.user_action_id,session.user_action_name,friends.*,user.login as friend_name from friends left join user on user.id=friends.friend_id left join session on session.user_id=friends.friend_id where friends.user_id='$node_id'"); |
| 99 | |
| 100 | while ($row=mysql_fetch_array($result)) { |
| 101 | echo "<table class='bigitem'><tr><td class='icon'>"; |
| 102 | echo "<img alt='",$row['friend_name'],"' src='/images/users/",strtolower($row['friend_name']),".gif'>"; |
| 103 | echo "</td><td class='item'>"; |
| 104 | echo "<table class='item'>"; |
| 105 | echo "<td class='header'><a href='?action=userinfo&node_id=",$row['friend_id'],"'>",$row['friend_name'],"</a>"; |
| 106 | if ($row['user_action']) { |
| 107 | echo " [lokacia:<a class='location' href='?action=",$row['user_action']; |
| 108 | if ($row['user_action']=="forum") echo "&node_id=".$row['user_action_id']."'>",$row['user_action_name']; |
| 109 | else echo "'>".$row['user_action']; |
| 110 | echo "</a>] "; |
| 111 | } |
| 112 | echo "</td>"; |
| 113 | echo "</tr>"; |
| 114 | echo "<tr class='content'><td class='content'>",Stripslashes($row['friend_text']),"</td></tr>"; |
| 115 | echo "</table>"; |
| 116 | echo "</td></tr></table>"; |
| 117 | |
| 118 | } |
| 119 | |
| 120 | } |
| 121 | else { |
| 122 | echo "<table width='100%' class='box'><tr><td>".$userinfo['user_info']."</td></tr></table><br>"; |
| 123 | $result=mysql_query("select session.user_action,session.user_action_id,session.user_action_name,friends.*,user.login as friend_name from friends left join user on user.id=friends.user_id left join session on session.user_id=friends.user_id where friend_id='$node_id'"); |
| 124 | |
| 125 | while ($row=mysql_fetch_array($result)) { |
| 126 | echo "<table class='bigitem'><tr><td class='icon'>"; |
| 127 | echo "<img alt='",$row['friend_name'],"' src='/images/users/",strtolower($row['friend_name']),".gif'>"; |
| 128 | echo "</td><td class='item'>"; |
| 129 | echo "<table class='item'>"; |
| 130 | echo "<td class='header'><a href='?action=userinfo&node_id=",$row['user_id'],"'>",$row['friend_name'],"</a>"; |
| 131 | if ($row['user_action']) { |
| 132 | echo " [lokacia:<a class='location' href='?action=",$row['user_action']; |
| 133 | if ($row['user_action']=="forum") echo "&node_id=".$row['user_action_id']."'>",$row['user_action_name']; |
| 134 | else echo "'>".$row['user_action']; |
| 135 | echo "</a>] "; |
| 136 | } |
| 137 | echo "</td>"; |
| 138 | echo "</tr>"; |
| 139 | echo "<tr class='content'><td class='content'>",Stripslashes($row['friend_text']),"</td></tr>"; |
| 140 | echo "</table>"; |
| 141 | echo "</td></tr></table>"; |
| 142 | |
| 143 | } |
| 144 | } |
| 145 | |
| 146 | ?> |