public static function mainPage()
{
$allCount = self::$db->query("SELECT COUNT(*) as cnt, c.`contentID`, cc.`contentID` FROM `content` as c, " . "`content_category` as cc WHERE cc.`contentID`=c.`contentID` AND c.`showOnSite`='Y'")->fetch();
$sqlData = blog::getPosts(core::pagination($allCount["cnt"]))->fetchAll();
//if ($sqlData)
//{
//blog::highlightCode ($sqlData, "short");
//}
return $sqlData;
}
function date()
{
system::setParam("page", "blogByDate");
$offset = 1;
if (isset($this->get["offset"])) {
$offset = intval($this->get["offset"]);
}
$cacheID = "DTSELECT|ARTICLE|dateoffset_{$offset}";
if (isset($this->args[1])) {
$date = preg_replace("/[^0-9.]/uims", '', $this->args[1]);
$cacheID = $date . "|" . $cacheID;
}
$this->smarty->setCacheID($cacheID);
if (!$this->smarty->isCached()) {
$allCount = $this->db->query("SELECT COUNT(*) as cnt FROM `content` as c, `content_category` as cc, `categories` as cts WHERE \n cc.`contentID`=c.`contentID` AND c.`type`='article' AND cts.`categoryID`=cc.`catID` AND c.`showOnSite`='Y' AND c.`dt` >= \n STR_TO_DATE ('?', '%d.%m.%Y')", $date)->fetch();
$posts = news::getPostsByDate($date, core::pagination($allCount["cnt"], $offset), "article")->fetchAll();
$this->smarty->assign("posts", $posts);
$this->smarty->assign("date", $date);
}
}
public static function buildList($target, $type = "", array $clause = array())
{
if ($type) {
if ($target == "categories") {
// временный костыль
$clause[] = "`catType`='{$type}'";
} else {
$clause[] = "`type`='{$type}'";
}
}
$clauseSTR = "";
if ($clause) {
$clauseSTR = implode(" AND ", $clause);
}
if ($clauseSTR) {
$clauseSTR = "WHERE {$clauseSTR}";
}
$columns = self::$db->query("SHOW COLUMNS FROM `{$target}`")->fetchAll();
if (isset($_GET["action"])) {
switch ($_GET["action"]) {
case "delete":
$id = array_keys($_GET);
$keyName = $id[count($_GET) - 1];
$id = intval($_GET[$keyName]);
self::$db->query("DELETE FROM `{$target}` WHERE `?`=?", $keyName, $id);
if ($target == "content") {
self::$db->query("DELETE FROM `content_category` WHERE `id`=?", $id);
self::$smarty->clearCache(null, "MAINPAGE|SEARCH_RES|BLOG|CATSELECT|RSS");
}
break;
}
}
if (isset($_POST["groupDelete"]) && !empty($_POST["rows"])) {
self::$db->query("DELETE FROM `{$target}` WHERE `" . $columns[0]["Field"] . "` IN (" . implode(",", $_POST["rows"]) . ")");
}
$mysqlLimits = array();
$offset = 0;
$allCount = self::$db->query("SELECT COUNT(*) as cnt FROM `{$target}` {$clauseSTR}")->fetch();
$mysqlLimits = core::pagination($allCount["cnt"]);
$sort = $columns[0]["Field"];
$direction = "DESC";
if (isset($_GET["direction"]) && $_GET["direction"]) {
if ($_GET["direction"] == "DESC") {
$direction = "ASC";
} else {
if ($_GET["direction"] == "ASC") {
$direction = "DESC";
}
}
}
if (isset($_GET["sort"]) && $_GET["sort"]) {
$sort = $_GET["sort"];
}
self::$smarty->assign("direction", $direction);
self::$smarty->assign("sort", $sort);
$res = self::$db->query("SELECT * FROM `{$target}` {$clauseSTR} ORDER BY `{$sort}` {$direction} LIMIT \n\t\t\t{$mysqlLimits["start"]},{$mysqlLimits["end"]}");
if ($target != "categories") {
$res->runAfterFetchAll[] = array("blog", "makeSlug");
}
$data = $res->fetchAll();
self::$smarty->assign("list", $data);
return $data;
}
public static function mailOutbox($offset = 1)
{
$userID = intval($_SESSION["user"]["userID"]);
$_SESSION["user"]["mail"]["box"] = "outbox";
$cntOut = self::$db->query("SELECT COUNT(*) as cnt FROM `messages`,`users` WHERE `userID`=`senderID` AND `userID`=?", $userID)->fetch();
$cntIn = self::$db->query("SELECT COUNT(*) as cnt FROM `messages` WHERE `receiverID`=?", $userID)->fetch();
self::$smarty->assign("cntOut", $cntOut["cnt"]);
self::$smarty->assign("cntIn", $cntIn["cnt"]);
$limits = core::pagination($cntIn["cnt"], $offset);
return self::$db->query("SELECT * FROM `messages` as m LEFT JOIN " . "`users` as u ON u.`userID`=m.`receiverID` WHERE m.`senderID`=? ORDER BY m.`dt` DESC LIMIT " . implode(",", $limits), $userID);
}
