[mirrors/Kyberia-bloodline.git] / boxiky / userinfo.inc

<?php
if ($show=="karma") {

	$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";
	$q.=" ORDER BY submission_k desc";
	$set=$kyberia->query($q);

	while ($set->next()) {
		$submissions=$set->getRecord();
		echo "<table class='bigitem'><tr><td class='icon'>";
	//	$submissions['submission_text'] = preg_replace ("/<img src=(.*?)>/","obrazok: <a href=\\1>\\1</a>",$submissions['submission_text']);
		echo "<img alt='",$submissions['user_name'],"' src='/images/users/",strtolower($submissions['user_name']),".gif'>";
		echo "<center><font color='red'>",$submissions['submission_k']," K</font></center>";
		echo "</td><td class='item'>";
		echo "<table class='item'>";
		echo "<td class='header'>";
		echo "forum:&nbsp;&nbsp;<a href='?action=forum&node_id=",$submissions['forum_id'],"'>",$submissions['forum_name'],"</a><br>";
		echo $submissions['user_name'];
		if ($submissions['user_mode']=="normal" AND ($submissions['user_action'])) {
		 Showz::showLocation($submissions['user_action'],$submissions['user_action_id'],$submissions['user_action_name']);
		}
		Showz::showDate($submissions['submission_timestamp']);

		echo "</td>";
		echo "</tr>";
		echo "<tr class='content'><td class='content'>",Stripslashes($submissions['submission_text']),"</td></tr>";
		echo "</table>";
		echo "</td></tr></table>";
	}


}
elseif ($show=="submissions") {
	if (!$_GET['offset']) $offset=0;
	else $offset=$_GET['offset'];
	echo "<br><br><center><b>uzivatelove prispevky</b></center>";
	echo "<br><Br><center>";
	if ($offset) echo "<a href='".SCRIPT."?action=userinfo&node_id=$node_id&show=submissions&offset=".($offset-23)."'><<predchadzajuce</a>&nbsp;&nbsp;&nbsp;";
	echo "<a href='".SCRIPT."?action=userinfo&node_id=$node_id&show=submissions&offset=".($offset+23)."'>dalsi >></a>";
	echo "</center><br><br>";
	$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."' ";
	$q.=" ORDER BY submission_timestamp desc limit $offset,23";
	$set=$kyberia->query($q);

	while ($set->next()) {
		$submissions=$set->getRecord();
		echo "<table class='bigitem'><tr><td class='icon'>";
	//	$submissions['submission_text'] = preg_replace ("/<img src=(.*?)>/","obrazok: <a href=\\1>\\1</a>",$submissions['submission_text']);
		echo "<img alt='",$submissions['user_name'],"' src='/images/users/",strtolower($submissions['user_name']),".gif'>";
		echo "<center><font color='red'>",$submissions['submission_k']," K</font></center>";
		echo "</td><td class='item'>";
		echo "<table class='item'>";
		echo "<td class='header'>";
		echo "forum:&nbsp;&nbsp;<a href='?action=forum&node_id=",$submissions['forum_id'],"'>",$submissions['forum_name'],"</a><br>";
		echo $submissions['user_name'];
		if ($submissions['user_mode']=="normal" AND ($submissions['user_action'])) {
		 Showz::showLocation($submissions['user_action'],$submissions['user_action_id'],$submissions['user_action_name']);
		}
		Showz::showDate($submissions['submission_timestamp']);

		echo "</td>";
		echo "</tr>";
		echo "<tr class='content'><td class='content'>",Stripslashes($submissions['submission_text']),"</td></tr>";
		echo "</table>";
		echo "</td></tr></table>";
	}


}


elseif ($show=="bookmarks") {
	echo "<br><br><center><b>uzivatelove kluby</b></center>";
	$q="SELECT * from forum WHERE forum.forum_owner='$node_id'";
	$q.=" order by forum_name ";
	$forumset=$kyberia->query($q);
	while ($forumset->next()) {
		echo "<br>&nbsp;&nbsp;&nbsp;&nbsp;<a href='?action=forum&node_id=",$forumset->getString('forum_id'),"'>",$forumset->getString('forum_name'),"</a>&nbsp;&nbsp;(".$forumset->getString('forum_submissions')."&nbsp;submissionz ";
		if ($forumset->getString('submission_count'))  echo "- <font color='red'>".$forumset->getString('submission_count')." NEW</font>";
		echo ")";
	}
	?>
	<br><br><center><b>uzivatelove bookmarknute kluby</b></center>
	<?php
	$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')";
	$q.=" WHERE user_forum.user_bookmark='yes' and forum.forum_owner != '$node_id'";
	$q.=" order by forum_name ";
	$forumset=$kyberia->query($q);
	while ($forumset->next()) {
		echo "<br>&nbsp;&nbsp;&nbsp;&nbsp;<a href='?action=forum&node_id=",$forumset->getString('forum_id'),"'>",$forumset->getString('forum_name'),"</a>&nbsp;&nbsp;(".$forumset->getString('login')."&nbsp;&nbsp;::&nbsp;&nbsp;".$forumset->getString('forum_submissions')."&nbsp;submissionz ";
		if ($forumset->getString('submission_count'))  echo "- <font color='red'>".$forumset->getString('submission_count')." NEW</font>";
		echo ")";
	}
}


elseif($show=="friends") {
	$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'");

	while ($row=mysql_fetch_array($result)) {
		echo "<table class='bigitem'><tr><td class='icon'>";
		echo "<img alt='",$row['friend_name'],"' src='/images/users/",strtolower($row['friend_name']),".gif'>";
		echo "</td><td class='item'>";
		echo "<table class='item'>";
		echo "<td class='header'><a href='?action=userinfo&node_id=",$row['friend_id'],"'>",$row['friend_name'],"</a>";
		if ($row['user_action']) {
			echo "&nbsp;[lokacia:<a class='location' href='?action=",$row['user_action'];
			if ($row['user_action']=="forum") echo "&node_id=".$row['user_action_id']."'>",$row['user_action_name'];
			else echo "'>".$row['user_action'];
			echo "</a>]&nbsp;";
		}
		echo "</td>";
		echo "</tr>";
		echo "<tr class='content'><td class='content'>",Stripslashes($row['friend_text']),"</td></tr>";
		echo "</table>";
		echo "</td></tr></table>";

	}

}
else {
	echo "<table width='100%' class='box'><tr><td>".$userinfo['user_info']."</td></tr></table><br>";
	$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'");

	while ($row=mysql_fetch_array($result)) {
		echo "<table class='bigitem'><tr><td class='icon'>";
		echo "<img alt='",$row['friend_name'],"' src='/images/users/",strtolower($row['friend_name']),".gif'>";
		echo "</td><td class='item'>";
		echo "<table class='item'>";
		echo "<td class='header'><a href='?action=userinfo&node_id=",$row['user_id'],"'>",$row['friend_name'],"</a>";
		if ($row['user_action']) {
			echo "&nbsp;[lokacia:<a class='location' href='?action=",$row['user_action'];
			if ($row['user_action']=="forum") echo "&node_id=".$row['user_action_id']."'>",$row['user_action_name'];
			else echo "'>".$row['user_action'];
			echo "</a>]&nbsp;";
		}
		echo "</td>";
		echo "</tr>";
		echo "<tr class='content'><td class='content'>",Stripslashes($row['friend_text']),"</td></tr>";
		echo "</table>";
		echo "</td></tr></table>";

	}
}

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