public static function prepareData($item, $mysqli)
{
// page title
$data["title"] = "Alois Sečkár - Blog";
include_once getcwd() . '/web/scripts/page-data/elrh_data_helper.php';
if (empty($item)) {
// if no item selected = show list of all blog entries
$data["entries"] = ELRHDataHelper::retrieveArray($mysqli, "SELECT id, title, date, categories FROM elrh_blog ORDER BY date DESC");
} else {
// still have to determine between blog-id and category-filter
if (is_numeric($item)) {
// notify content renderer, there will be only one blog entry
$data["single"] = true;
// try to find particular blog item
$data["entry"] = ELRHDataHelper::retrieveRow($mysqli, "SELECT id, title, date, time, content FROM elrh_blog WHERE id='" . mysqli_real_escape_string($mysqli, $item) . "'");
if (!empty($data["entry"])) {
// page title adjustment
$data["title"] .= ": " . $data["entry"]["title"];
// notify content renderer, article exists
$data["exists"] = true;
}
} else {
// notify content renderer, filter is active
$data["filter"] = $item;
// category filter is set-up = show list of filtered blog entries
$data["entries"] = ELRHDataHelper::retrieveArray($mysqli, "SELECT id, title, date, categories FROM elrh_blog WHERE categories LIKE '%" . mysqli_real_escape_string($mysqli, $item) . "%' ORDER BY date DESC");
}
}
// save prepared data for renderer
return $data;
}
public static function prepareData($item, $mysqli)
{
// page title
$data["title"] = "Alois Sečkár - Politika online";
include_once getcwd() . '/web/scripts/page-data/elrh_data_helper.php';
// deal with admin input, if any
if (isset($_SESSION["user"])) {
if (isset($_POST["admin_online"]) && isset($_POST["admin_content"])) {
$data["admin_content"] = $_POST["admin_content"];
$result = $mysqli->query("INSERT INTO elrh_onlines_content (online, date, content) VALUES (" . mysqli_real_escape_string($mysqli, $_POST["online"]) . ", now(), '" . mysqli_real_escape_string($mysqli, $_POST["content"]) . "');");
if ($result) {
$data["admin_message"] = '<span style="color: green;">Vložen nový záznam</span>';
} else {
$data["admin_message"] = '<span style="color: red;">Vložení selhalo</span>';
}
}
}
//
// get list of all existing onlines
$data["onlines"] = ELRHDataHelper::retrieveArray($mysqli, "SELECT id, date, name, thumb, status FROM elrh_onlines ORDER BY date DESC");
//
if (!empty($item)) {
// notify content renderer, there will be only one entry
$data["single"] = true;
// find one particular entry and its details
$data["entry"] = ELRHDataHelper::retrieveRow($mysqli, "SELECT id, date, name, dscr, thumb, status FROM elrh_onlines WHERE id='" . mysqli_real_escape_string($mysqli, $item) . "'");
//
if (!empty($data["entry"])) {
// page title adjustment
// too long...
// $data["title"] .= ": ".$data["entry"]["name"];
// notify content renderer, article exists
$data["exists"] = true;
}
// find all content relative to selected online
$data["contents"] = ELRHDataHelper::retrieveArray($mysqli, "SELECT date, content FROM elrh_onlines_content WHERE online='" . mysqli_real_escape_string($mysqli, $item) . "' ORDER BY date DESC");
//
if (!empty($data["contents"])) {
// notify content renderer, there are contents for this online
$data["full"] = true;
}
// memo FOR FUTRE USE when there will be admin-form for inserting
//if (is_numeric($item)) {
//} else {
//}
}
// save prepared data for renderer
return $data;
}
public static function prepareData($item, $mysqli)
{
// page title
$data["title"] = "Alois Sečkár - Glosy";
// deal with admin input, if any
if (isset($_SESSION["user"])) {
if (isset($_POST["admin_quote"]) && isset($_POST["admin_topic"])) {
// prepare values
$data["admin_input"]["quote"] = $_POST["admin_quote"];
$data["admin_input"]["topic"] = $_POST["admin_topic"];
$data["admin_input"]["link"] = "null";
if (isset($_POST["admin_link"]) && $_POST["admin_link"] != "") {
$data["admin_input"]["link"] = $_POST["admin_link"];
}
// insert into db
$result = $mysqli->query("INSERT INTO elrh_quotes (date, content, topic, link) VALUES (now(), '" . mysqli_real_escape_string($mysqli, $data["admin_input"]["quote"]) . "', '" . mysqli_real_escape_string($mysqli, $data["admin_input"]["topic"]) . "', '" . mysqli_real_escape_string($mysqli, $data["admin_input"]["link"]) . "');");
if ($result) {
$mysqli->query("UPDATE elrh_main SET value=now() WHERE var='last_quote'");
$data["admin_message"] = '<span style="color: green;">Vložen nový záznam</span>';
} else {
$data["admin_message"] = '<span style="color: red;">Vložení selhalo</span>';
}
}
}
//
// get quotes
include_once getcwd() . '/web/scripts/page-data/elrh_data_helper.php';
// default amount is 25
// user can load more by clicking
if (is_numeric($item)) {
$data["limit"] = $item;
} else {
$data["limit"] = 25;
}
// last quote inserted
$data["last"] = ELRHDataHelper::retrieveRow($mysqli, "SELECT value FROM elrh_main WHERE var='last_quote'");
// get desired amount of quotes sorted by date inserted
$data["quotes"] = ELRHDataHelper::retrieveArray($mysqli, "SELECT date, content, topic, link FROM elrh_quotes ORDER BY date DESC LIMIT " . $data["limit"]);
// get total amount of quotes
$data["total"] = ELRHDataHelper::retrieveRow($mysqli, "SELECT count(id) AS entries FROM elrh_quotes");
// save prepared data for renderer
return $data;
}
