Exemple #1
0
<?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);
Exemple #2
0
<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");
Exemple #3
0
<?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">
Exemple #4
0
			<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>
Exemple #5
0
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>";
}