redirect("/");
}
} else {
$strana = 1;
}
$limit = "40";
$celkovy_pocet = $rows1;
$pocet_stran = ceil($celkovy_pocet / $limit);
$pociatok = $strana * $limit - $limit;
$result = dbquery("SELECT * FROM bg_comments ORDER BY comment_id DESC LIMIT {$pociatok}, {$limit}");
if ($strana > $pocet_stran) {
redirect("/");
}
while ($data = dbarray($result)) {
$nameexist = $data["comment_type"] == "A" ? articlename($data["comment_pageid"]) : projektname($data["comment_pageid"]);
$name = $data["comment_type"] == "A" ? articleurl($data["comment_pageid"], articlename($data["comment_pageid"])) : projekturl($data["comment_pageid"], projektname($data["comment_pageid"]), 0, 0);
echo '<tr id="article' . $data["comment_id"] . '" class="' . ($data["comment_delete"] == 1 ? "danger" : ($nameexist == "" ? "warning" : "")) . '">
<td><span class="label label-default">' . $data["comment_id"] . '</span></td>
<td>' . ($nameexist == "" ? "Článok alebo projekt neexistuje" : $name) . '</td>
<td>' . date("j. n. Y", $data["comment_time"]) . '</td>
<td>' . username($data["comment_userid"], 0) . '</td>
<td align="right"><a href="?cdel=' . $data["comment_id"] . '" class="label label-danger">Kôš</a> <span class="label label-default articleinf" data-toggle="popover" data-placement="right" data-trigger="hover" data-html="true" data-content="<div style=\'width:160px\'>' . str_replace("\"", "'", bbcode(badwords(smiley($data["comment_text"])))) . '</div>">Obsah</span></td>
</tr>';
}
echo '</table>';
pagination($rows1, $limit, $pocet_stran, $strana);
} else {
echo "Žiadní užívatelia.<br/>";
}
?>
</div>
<div class="panel panel-default">
<div class="panel-heading">OS používané užívateľmi</div>
<div id="chart_div2"></div>
</div>
<div class="panel panel-default">
<div class="panel-heading">Posledné komentáre</div>
<ul class="list-group">
<?php
$result = dbquery("SELECT * FROM bg_comments WHERE comment_delete='0' ORDER BY comment_id DESC LIMIT 0,8");
$rows1 = dbrows($result);
if ($rows1 >= "1") {
while ($data = dbarray($result)) {
$type = articleurl($data["comment_pageid"], trimlink(articlename($data["comment_pageid"]), 22), 1, 1);
$tname = articlename($data["comment_pageid"]);
echo '<li class="list-group-item">
' . (useravatar($data["comment_userid"]) != "/file/avatars/avatar.png" ? '<img src="' . useravatar($data["comment_userid"]) . '" alt="" class="img-circle pull-left" style="width:40px;margin-right:5px">' : '<img src="' . useravatar($data["comment_userid"]) . '" alt="" class="img-circle pull-left" style="width:40px;margin-right:5px">') . '
<span class="badge">' . timeago($data["comment_time"]) . '</span>
' . username($data["comment_userid"], 1) . ' > <a href="' . $type . '" style="font-size:9px">' . trimlink($tname, 32) . '</a><br>
<small>' . trimlink(bbcoderemove(badwords($data["comment_text"])), 100) . '</small><br>
</li>';
}
} else {
echo "Žiadne komentáre k článkom.";
}
?>
</ul>
</div>
