<?php require "inc/settings.php"; if (!ctype_digit($_GET['id'])) { redirect("/"); } if (userperm("4") or userperm("2") or userperm("5")) { $resultc = dbquery("SELECT * FROM bg_articles WHERE article_id='" . strip_tags((int) $_GET["id"]) . "'"); $deaktivate = 0; } else { $resultc = dbquery("SELECT * FROM bg_articles WHERE article_id='" . strip_tags((int) $_GET["id"]) . "' AND article_suggestion='0'"); $deaktivate = 1; } $datacla = dbarray($resultc); $deaktivate = $datacla["article_suggestion"] == 0 ? 1 : 0; $header = (object) ["title" => $datacla["article_name"], "metaimage" => isset($datacla["article_img"]) ? "http://data.desart.sk/articles/" . $datacla["article_img"] : "", "desc" => isset($datacla["article_minitxt"]) ? $datacla["article_minitxt"] : $setting["description"], "atags" => isset($datacla["article_target"]) ? $setting["keywords"] . ", " . $datacla["article_target"] : $setting["keywords"], "id" => $datacla["article_id"], "url" => "http://desart.sk/clanok/" . $datacla["article_id"] . "/" . bezd($datacla["article_name"]), "socialmeta" => 1]; $panelchange = "panel.php"; require "inc/header.php"; $rows1 = dbrows($resultc); if ($rows1 == "1") { if (isset($_GET["n"]) && $_GET["n"] != bezd($datacla["article_name"])) { redirect("/clanok/" . $datacla["article_id"] . "/" . bezd($datacla["article_name"])); } if ($datacla["article_series"] != 0) { if (dbcount("(article_id)", "bg_articles", " article_series='" . $datacla["article_series"] . "'") >= 2) { $clanokprvy_result = dbquery("SELECT * FROM bg_articles WHERE article_suggestion='0' AND article_series='" . $datacla["article_series"] . "' ORDER BY article_date ASC"); $datacc = array(); while ($row = dbarray($clanokprvy_result)) { $datacc[] = $row["article_id"]; } $najdiclanok = array_search($datacla["article_id"], $datacc);
<div class="list-group"> <?php $result = dbquery("SELECT * FROM bg_forumtopicpost GROUP BY post_topicid ORDER BY post_time DESC LIMIT 0,5"); $rows1 = dbrows($result); if ($rows1 >= "1") { while ($data = dbarray($result)) { $type = "/tema/" . $data["post_topicid"] . "/" . bezd(forumtopicname($data["post_topicid"])); echo '<a href="' . $type . '" class="list-group-item">' . forumtopicname($data["post_topicid"]) . '<br/><small>' . timeago($data["post_time"]) . ' od ' . username($data["post_userid"], 0) . '</small></a>'; } } ?> </div> <?php if (userperm("5")) { if (isset($_POST["editmod"])) { if ($_POST["modset"] == 1) { dbquery("DELETE FROM bg_forumtopicread WHERE forumr_tid='" . $dataf2["forumt_id"] . "'"); dbquery("UPDATE bg_forumtopic SET forumt_locked='1',forumt_lockuserid='" . $userinfo["user_id"] . "' WHERE forumt_id='" . $dataf2["forumt_id"] . "'"); redirect("/tema/" . $dataf2["forumt_id"] . "/" . bezd($dataf2["forumt_name"])); } if ($_POST["modset"] == 2) { dbquery("UPDATE bg_forumtopic SET forumt_locked='0' WHERE forumt_id='" . $dataf2["forumt_id"] . "'"); redirect("/tema/" . $dataf2["forumt_id"] . "/" . bezd($dataf2["forumt_name"])); } if ($_POST["modset"] == 3) { dbquery("DELETE FROM bg_forumtopic WHERE forumt_id='" . $dataf2["forumt_id"] . "'"); dbquery("DELETE FROM bg_forumtopicpost WHERE post_topicid='" . $dataf2["forumt_id"] . "'"); dbquery("DELETE FROM bg_forumtopicread WHERE forumr_tid='" . $dataf2["forumt_id"] . "'"); redirect("/forum");
<?php $titlew = "Vytvoriť / Upraviť článok"; require "../inc/settings.php"; require "inc/header.php"; if (!userperm("4") && !userperm("2")) { redirect("/"); } if (isset($_GET["edit"]) == "") { // article add if (isset($_POST["add"]) and $_POST["nazov"] != "" and $_POST["text"] != "") { $nazov = dbescape(strip_tags($_POST["nazov"])); $kat = $_POST["kat"]; $img = $_POST["img"]; $target = dbescape(strip_tags($_POST["target"])); $text = addslashes($_POST["text"]); $mtext = addslashes($_POST["minitext"]); $autor = $userinfo["user_id"]; $navrh = 1; dbquery("INSERT INTO bg_articles(article_minitxt, article_img,article_name, article_cat, article_author, article_txt, article_date, article_suggestion, article_target)\n \t\t\tVALUES('" . $mtext . "','" . $img . "','" . $nazov . "','" . $kat . "','" . $autor . "','" . $text . "','" . time() . "','" . $navrh . "','" . $target . "')"); echo '<div class="alert alert-success">Článok <b>' . $nazov . '</b> bol pridaný.</div>'; } echo ' <form name="form1" method="post" action="?add"> <div class="panel panel-default"> <div class="panel-heading">Vytvoriť článok <input name="add" value="Vytvoriť článok" class="btn btn-success btn-xs pull-right" type="submit"></div> <div class="panel-body"> <div class="form-group"> <label for="nazov">Názov článku:</label> <input type="text" class="form-control" id="nazov" name="nazov">
<li><a href="/clanky">Články</a></li> <li><a href="/serieclankov">Série článkov</a></li> <li><a href="/subory">Súbory</a></li> </ul> <ul class="nav navbar-nav pull-right"> <?php if (MEMBER) { $unreadmessages = dbcount("(mes_id)", "bg_messages", "mes_touserid='" . $userinfo["user_id"] . "' AND mes_read='0'"); echo ' <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown"><img src="' . useravatar($userinfo["user_id"]) . '" class="img-circle" alt="avatar" width="20" height="20"/> ' . $userinfo["user_nick"] . ' <span class="caret"></span></a> <ul class="dropdown-menu"> <li><a role="menuitem" tabindex="-1" class="profillink" data-target="' . $userinfo["user_id"] . '"><i class="fa fa-eye"></i> Zobraziť profil</a></li> <li><a role="menuitem" tabindex="-1" href="/uzivatel/profil"><i class="fa fa-wrench"></i> Nastavenia profilu</a></li> <li><a role="menuitem" tabindex="-1" href="#chat" id="showchat"><i class="fa fa-comments-o"></i> Správy <span class="badge">' . $unreadmessages . '</span></a></li>'; if (userperm("4") or userperm("2") or userperm("3")) { echo ' <li role="presentation"><a role="menuitem" tabindex="-1" href="/manager"><i class="fa fa-gears"></i> Administrácia</a></li>'; } echo '<li class="divider"></li> <li role="presentation"><a role="menuitem" tabindex="-1" href="/uzivatel/pridatclanok"><i class="fa fa-font"></i> Napísať článok</a></li>'; echo '<li class="divider"></li> <li><a role="menuitem" tabindex="-1" href="?logout"><i class="fa fa-power-off"></i> Odhlásiť</a></li> </ul> </li> '; } else { echo '<li><button type="button" data-toggle="modal" data-target="#login" class="btn btn-default navbar-btn btn-sm">Prihlásiť sa</button></li>'; } ?> </ul> </div>
function komentare($clanok, $type = "A", $link = "") { global $userinfo; echo '<div class="komentare" id="komentare">'; if (MEMBER) { if (isset($_GET["komentar"]) && isset($_GET["zmazat"]) && $_GET["zmazat"] != "") { if (!ctype_digit($_GET['zmazat'])) { redirect("/"); } $result66 = dbquery("SELECT * FROM bg_comments WHERE comment_id='" . strip_tags((int) $_GET["zmazat"]) . "' AND comment_type='" . $type . "'"); $rows55 = dbrows($result66); $data8 = dbarray($result66); if ($rows55 == 1) { if (!userperm("5")) { if ($data8["comment_userid"] == $userinfo["user_id"]) { dbquery("UPDATE bg_comments SET comment_delete='1' WHERE comment_id='" . strip_tags((int) $_GET["zmazat"]) . "' AND comment_type='" . $type . "'"); if ($link == "") { redirect("/clanok/" . $_GET["id"] . "/" . strip_tags($_GET["n"]) . "#komentare"); } else { redirect($link); } } else { redirect("/"); } } else { dbquery("UPDATE bg_comments SET comment_delete='1' WHERE comment_id='" . strip_tags((int) $_GET["zmazat"]) . "' AND comment_type='" . $type . "'"); dbquery("UPDATE bg_comments SET comment_delete='1' WHERE comment_type='" . $type . "' AND comment_reply='" . strip_tags((int) $_GET["zmazat"]) . "'"); if ($link == "") { redirect("/clanok/" . $_GET["id"] . "/" . strip_tags($_GET["n"]) . "#komentare"); } else { redirect($link); } } } else { redirect("/"); } } $antispamnum = rand(1, 99); if (isset($_POST["addcomment"]) && $_POST["textarea"] != "") { $text = trim(htmlspecialchars($_POST["textarea"], ENT_QUOTES, "UTF-8")); $reply = isset($_GET["reply"]) ? strip_tags((int) $_GET["reply"]) : "0"; if ($reply != 0) { $resultcom = dbquery("SELECT * FROM bg_comments WHERE comment_id='" . strip_tags((int) $_GET["reply"]) . "' AND comment_type='" . $type . "'"); $rows5com = dbrows($resultcom); if ($rows5com != 1) { if ($link == "") { redirect("/clanok/" . $_GET["id"] . "/" . strip_tags($_GET["n"]) . "#komentare"); } else { redirect($link); } } } if (!dbcount("(comment_id)", "bg_comments", "comment_userid='" . $userinfo["user_id"] . "' AND comment_time > " . strtotime("-30 seconds") . "")) { if ($text != "" and strlen($text) >= 8) { dbquery("INSERT INTO bg_comments(comment_userid, comment_text, comment_time, comment_pageid, comment_type, comment_reply)\n VALUES('" . $userinfo["user_id"] . "','" . $text . "','" . time() . "','" . $clanok . "','" . $type . "','" . $reply . "')"); } } if ($link == "") { redirect("/clanok/" . $_GET["id"] . "/" . strip_tags($_GET["n"]) . "#komentare"); } else { redirect($link); } } if (isset($_GET['reply'])) { if (!ctype_digit($_GET['reply'])) { redirect("/"); } } if (dbcount("(comment_id)", "bg_comments", "comment_userid='" . $userinfo["user_id"] . "' AND comment_time > " . strtotime("-30 seconds") . "")) { echo '<div class="alert alert-danger">O 30 sekúnd môžeš znova komentovať.</div>'; } echo '<div class="list-group komentboxarea ' . (isset($_GET['reply']) ? "showdiv" : "hidediv") . '" id="komreply"> <form name="form" action="#komentare" method="POST"> <div class="list-group-item list-group-item-info">Pridaj komentár</div> <textarea name="textarea" class="list-group-item" maxLength="800" rows="1" placeholder="text komentáru..." style="width:100%;padding:10px;font-size:12px;resize:vertical"></textarea> <div class="list-group-item"> <span class="bbcody"> <a href="javascript:addText(\'textarea\', \'[b]\', \'[/b]\', \'form\');" class="btn btn-default btn-sm" data-toggle="tooltip" data-placement="top" title="[b]tučný[/b]"><i class="fa fa-bold"></i></a> <a href="javascript:addText(\'textarea\', \'[i]\', \'[/i]\', \'form\');" class="btn btn-default btn-sm" data-toggle="tooltip" data-placement="top" title="[i]kurzíva[/i]"><i class="fa fa-italic"></i></a> <a href="javascript:addText(\'textarea\', \'[u]\', \'[/u]\', \'form\');" class="btn btn-default btn-sm" data-toggle="tooltip" data-placement="top" title="[u]podčiarknuté[/u]"><i class="fa fa-underline"></i></a> <a href="javascript:addText(\'textarea\', \'[url]\', \'[/url]\', \'form\');" class="btn btn-default btn-sm" data-toggle="tooltip" data-placement="top" title="[url]odkaz[/url]"><i class="fa fa-link"></i></a> </span> <span class="pull-right"> ' . (isset($_GET["reply"]) ? ' <a href="' . ($link == "" ? "/clanok/" . $_GET["id"] . "/" . strip_tags($_GET["n"]) . "#komentare" : $link) . '" class="btn btn-warning btn-sm">Zrušiť odpoveď</a>' : "") . ' <input name="addcomment" class="btn btn-success btn-sm" value="' . (isset($_GET["reply"]) ? 'Odpovedať na komentár ID #' . strip_tags((int) $_GET["reply"]) . '' : "Pridať komentár") . '" type="submit"> </span> <div class="clearfix"></div> </div> </form> </div> '; } else { echo '<div class="alert alert-info">Pred pridaním komentára sa musíš <a href="/registracia">zaregistrovať</a> alebo prihlásiť.</div>'; } echo ' <div class="page-header"> <h5>Komentáre ' . (!isset($_GET['reply']) ? '<a id="showcommentarea" class="btn btn-success btn-xs pull-right">Pridať komentár</a>' : '') . ' </h5> </div> '; if (isset($_GET["vsetkykomentare"]) && $_GET["vsetkykomentare"] == "zobrazit") { $comlimit = ""; } else { $comlimit = "LIMIT 0,7"; } $result2 = dbquery("SELECT * FROM bg_comments WHERE comment_delete='0' AND comment_pageid='" . $clanok . "' AND comment_type='" . $type . "' AND comment_reply='0' ORDER BY comment_id DESC"); $rows3 = dbrows($result2); if ($rows3 >= 1) { $result3 = dbquery("SELECT * FROM bg_comments WHERE comment_delete='0' AND comment_pageid='" . $clanok . "' AND comment_type='" . $type . "' AND comment_reply='0' ORDER BY comment_id DESC " . $comlimit); while ($data2 = dbarray($result3)) { $resultreply = dbquery("SELECT * FROM bg_comments WHERE comment_delete='0' AND comment_pageid='" . $clanok . "' AND comment_type='" . $type . "' AND comment_reply='" . $data2["comment_id"] . "' ORDER BY comment_id DESC"); // def reply $rowsrep = dbrows($resultreply); // def reply echo ' <div class="media komentar"> <a class="pull-left"> <img class="media-object img-circle" src="' . useravatar($data2["comment_userid"]) . '" alt="' . username($data2["comment_userid"]) . '"> </a> <div class="media-body"> <h4 class="media-heading">' . username($data2["comment_userid"], 1) . ' <span class="time">' . timeago($data2["comment_time"]) . '</span></h4> ' . wordwrap(bbcode(badwords(smiley($data2["comment_text"]))), 100, " ", 1) . ' <div class="clearfix"></div> <div class="buttonsinfo"> '; if (MEMBER) { echo '<a href="?reply=' . $data2["comment_id"] . '#komreply" class="btn btn-default btn-xs"><i class="fa fa-share"></i> Odpovedať</a> '; } if (SADMIN or MEMBER && $data2["comment_userid"] == $userinfo["user_id"]) { echo '<a href="?zmazat=' . $data2["comment_id"] . '&komentar" onclick="return confirm(\'Zmazať komentár užívateľa ' . username($data2["comment_userid"]) . ' ?\');" title="Odstrániť komentár" class="btn btn-default btn-xs"><i class="fa fa-ban"></i> Odstrániť komentár</a>'; } echo $rowsrep >= 3 ? ' <a class="btn btn-default btn-xs sreply" data-comid="' . $data2["comment_id"] . '"><i class="fa fa-level-down"></i> Zobraziť ďaľšie odpovede (' . ($rowsrep - 1) . ')</a>' : ""; echo '</div>'; $schovaj = $rowsrep >= 3 ? 'hidencom kom' . $data2["comment_id"] : ""; if ($rowsrep >= 1) { $i = 0; while ($datareply = dbarray($resultreply)) { echo ' <div class="media komentarreply ' . ($i == 0 ? "" : $schovaj) . '"> <a class="pull-left"> <img class="media-object img-circle" src="' . useravatar($datareply["comment_userid"]) . '" alt="' . username($datareply["comment_userid"]) . '"> </a> <div class="media-body"> <h4 class="media-heading">' . username($datareply["comment_userid"], 1) . ' <span class="time">' . timeago($datareply["comment_time"]) . '</span></h4> ' . wordwrap(bbcode(badwords(smiley($datareply["comment_text"]))), 100, " ", 1) . ' <div class="clearfix"></div> <div class="buttonsinfo"> '; if (SADMIN or MEMBER && $datareply["comment_userid"] == $userinfo["user_id"]) { echo '<a href="?zmazat=' . $datareply["comment_id"] . '&komentar" onclick="return confirm(\'Zmazať komentár užívateľa ' . username($datareply["comment_userid"]) . ' ?\');" title="Odstrániť komentár" class="btn btn-default btn-xs"><i class="fa fa-ban"></i> Odstrániť komentár</a>'; } echo ' </div> </div> </div> '; $i++; } } echo ' </div> </div> '; } if ($rows3 > "7") { if (isset($_GET["vsetkykomentare"]) && $_GET["vsetkykomentare"] == "zobrazit") { echo "<a href='?vsetkykomentare=skryt#komentare' class='buttonf'>Skryť všetky komentáre</a>"; } else { echo "<a href='?vsetkykomentare=zobrazit#komentare' class='buttonf'>Zobraziť všetky komentáre</a>"; } } } else { echo "<p style='padding: 10px;'>Žiadny komentár ešte nebol pridaný. Buďte prvý kto pridá komentár.</p>"; } echo "</div>"; }