</tr>
<tr>
<td>Komentárov:</td>
<td>' . dbcount("(comment_id)", "bg_comments", "comment_delete='0' AND comment_userid='" . $puser["user_id"] . "'") . '</td>
</tr>
<tr>
<td>Článkov:</td>
<td>' . dbcount("(article_id)", "bg_articles", "article_suggestion='0' AND article_author='" . $puser["user_id"] . "'") . '</td>
</tr>
<tr>
<td>DeviantArt:</td>
<td>' . ($puser["user_deviantart"] ? urlvalid($puser["user_deviantart"] . ".deviantart.com", $puser["user_deviantart"]) : "Nevyplnené") . '</td>
</tr>
<tr>
<td>Webová stránka:</td>
<td>' . ($puser["user_web"] ? urlvalid($puser["user_web"], "Zobraziť") : "Nevyplnené") . '</td>
</tr>
</table>
</div>
</div>
';
$result_article = dbquery("SELECT * FROM bg_articles WHERE article_author='" . $puser["user_id"] . "' AND article_suggestion='0' ORDER BY article_date DESC LIMIT 0,12");
$result_comments = dbquery("SELECT * FROM bg_comments WHERE comment_userid='" . $puser["user_id"] . "' AND comment_delete='0' ORDER BY comment_time DESC LIMIT 0,12");
$result_forumt = dbquery("SELECT * FROM bg_forumtopic WHERE forumt_userid='" . $puser["user_id"] . "' ORDER BY forumt_time DESC LIMIT 0,12");
$rows_article = dbrows($result_article);
$rows_comments = dbrows($result_comments);
$rows_forumt = dbrows($result_forumt);
echo '
<ul class="nav nav-tabs" role="tablist" id="myTab">
' . ($rows_article > 0 ? '<li><a href="#article" role="tab" data-toggle="tab">Články</a></li>' : '') . '
</div>
<div class="row">
<?php
$result = dbquery("SELECT * FROM bg_projects ORDER BY pr_id DESC LIMIT 0,3");
while ($data = dbarray($result)) {
echo '
<div class="col-md-4">
<div class="panel previewwebsite">
<div class="row">
<div class="col-sm-2 col-xs-3 col-md-3">
<img src="http://fimg-resp.seznam.cz/?spec=ft280x130&url=http://' . urlvalid($data["pr_web"], 0, 0) . '" alt="' . $data["pr_name"] . '" class="img-responsive">
</div>
<div class="col-sm-10 col-xs-8 col-md-9">
<div class="infoweb"><span>' . $data["pr_name"] . '</span><small>' . trimlink($data["pr_type"], 30) . '</small></div>
</div>
<a href="/prezentacia/' . $data["pr_id"] . '/' . bezd($data["pr_name"]) . '" class="webarrow"><i class="fa fa-chevron-right"></i></a>
</div>
</div>
</div>
';
}
?>
</div>