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>