session_start();
$id = 34; $GLOBALS['id'] = 34;
include $_SERVER['DOCUMENT_ROOT'].'/black-magic/c.kprf';
include $_SERVER['DOCUMENT_ROOT'].'/black-magic/uni-fn.php';
$lang = get_lang();
$title = ' | '.($lang=='ru'?'Заметки':'Notes');
$desc = ($lang=='ru'?'Блог дизайнера, который любит кодить, пытается чё-то делать в моушн и умеет не плохо фотографировать.':'Blog about design, motion, webdev, photo, cinemagraphs');
include $_SERVER['DOCUMENT_ROOT'].'/template/partials/html_begin.php';
include $_SERVER['DOCUMENT_ROOT'].'/template/partials/main_begin.php';
function get_hashtags($link, $tags_arr) {
$ids = implode(', ', array_keys($tags_arr));
$query = 'SELECT id, title FROM hashtags WHERE id IN('.$ids.')';
$result = mysqli_query($link, $query);
$temp_arr = array();
while($arr = mysqli_fetch_array($result, MYSQLI_ASSOC)) {$temp_arr[] = $arr;}
$html = '';
foreach ($temp_arr as $c) {
$html .= ''.$c['title'].' '.$tags_arr[intval($c['id'])].'';
}
if(isset($_GET['tag'])) $html .= 'Показать всё';
return '
';
}
function calc_notes($arr) {
$temp = array();
foreach ($arr as $key => $val) {
$val = explode(',', $val);
foreach ($val as $tag) {
$temp[$tag]++;
}
}
return $temp;
}
function get_notes($link, $id, $lang) {
$query = 'SELECT * FROM pg_simple WHERE parent_id = '.$id.' ORDER BY published DESC';
$result = mysqli_query($link, $query);
$temp_arr = array();
while($arr = mysqli_fetch_array($result, MYSQLI_ASSOC)) {$temp_arr[] = $arr;}
$html = '';
$hashtags = array();
$current_hashtag = $_GET['tag']?$_GET['tag']:false;
foreach ($temp_arr as $c) {
if(strrpos($c['hashtags'], $current_hashtag) !== false || $current_hashtag === false) {
$html .= json2html($c['content'], $lang, 'blog-covers', [$c['url'],$c['hashtags'],$c['published']]);
}
$hashtags[] = $c['hashtags'];
}
echo ''.get_hashtags($link, calc_notes($hashtags));
include $_SERVER['DOCUMENT_ROOT'].'/template/partials/mailchimp.php';
echo '
';
echo '
';
}
get_notes($link, $id, $lang);
echo '';
include $_SERVER['DOCUMENT_ROOT'].'/template/partials/main_end.php';
include $_SERVER['DOCUMENT_ROOT'].'/template/partials/html_end.php';
dbExit();
?>