101 lines
3.1 KiB
PHP
101 lines
3.1 KiB
PHP
|
<?php
|
|||
|
|
/*-----------------------------------------------------------------------------
|
|||
|
|
|
|||
|
|
orblog - Simple blog for hidden networks.
|
|||
|
|
|
|||
|
|
Version: 0.1
|
|||
|
|
Git: https://code.fossee.net/chicory/orblog-legacy
|
|||
|
|
Copyright: chicory@fossee.net 2020
|
|||
|
|
License: http://www.apache.org/licenses/LICENSE-2.0
|
|||
|
|
|
|||
|
|
-----------------------------------------------------------------------------*/
|
|||
|
|
|
|||
|
|
/*-- Posts count ----------------------------------------------------------*/
|
|||
|
|
if(!isset($_GET['category']) and !isset($_GET['tag']))
|
|||
|
|
{
|
|||
|
|
$query = 'SELECT COUNT(*) FROM `posts`';
|
|||
|
|
}
|
|||
|
|
else if(isset($_GET['category']))
|
|||
|
|
{
|
|||
|
|
$cat = filter_input(INPUT_GET, 'category', FILTER_SANITIZE_NUMBER_INT);
|
|||
|
|
if ($cat < 0) $cat = 0;
|
|||
|
|
$query = 'SELECT COUNT(*) FROM `posts` WHERE category = '.$cat;
|
|||
|
|
|
|||
|
|
$name = category_name($cat);
|
|||
|
|
}
|
|||
|
|
else if($_GET['tag'])
|
|||
|
|
{
|
|||
|
|
$tag = preg_replace ("/[^a-zA-Zа-яА-ЯёЁ_\-\d]/ui","",$_GET['tag']);
|
|||
|
|
$query = 'SELECT COUNT(*) FROM `posts` WHERE tags LIKE "%'.$tag.'%"';
|
|||
|
|
}
|
|||
|
|
$count = $sqlite -> querySingle($query);
|
|||
|
|
|
|||
|
|
/*-- Pagination -----------------------------------------------------------*/
|
|||
|
|
if($count)
|
|||
|
|
{
|
|||
|
|
if(!$_GET['page']) $page = 0;
|
|||
|
|
else $page = filter_input(INPUT_GET, 'page', FILTER_SANITIZE_NUMBER_INT);
|
|||
|
|
|
|||
|
|
$start = $page * MAXPOSTS;
|
|||
|
|
|
|||
|
|
if($page < 0 or ($page * MAXPOSTS) >= $count )
|
|||
|
|
{
|
|||
|
|
header('Location:'.URL.'index.php?view=404'); exit;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
/*-- Get posts and set pagination links -----------------------------------*/
|
|||
|
|
if(!isset($_GET['category']) and !isset($_GET['tag']))
|
|||
|
|
{
|
|||
|
|
$query = 'SELECT * FROM `posts`
|
|||
|
|
ORDER BY `time` DESC
|
|||
|
|
LIMIT '.$start.', '.MAXPOSTS;
|
|||
|
|
|
|||
|
|
$_TPL['title'] = TITLE;
|
|||
|
|
|
|||
|
|
if(($page - 1) >= 0)
|
|||
|
|
$_TPL['prev_page'] = 'index.php?page='.($page - 1);
|
|||
|
|
if((($page + 1) * MAXPOSTS) < $count)
|
|||
|
|
$_TPL['next_page'] = 'index.php?page='.($page + 1);
|
|||
|
|
}
|
|||
|
|
else if(isset($cat)) // Categories
|
|||
|
|
{
|
|||
|
|
$query = 'SELECT * FROM `posts` WHERE category = '.$cat.'
|
|||
|
|
ORDER BY `time` DESC LIMIT '.$start.', '.MAXPOSTS;
|
|||
|
|
|
|||
|
|
$_TPL['title'] = $name.' | '.TITLE;
|
|||
|
|
if($cat == 0) $_TPL['title'] = $_LANG['without_cat'].' | '.TITLE;
|
|||
|
|
|
|||
|
|
if(($page - 1) >= 0)
|
|||
|
|
$_TPL['prev_page'] = 'index.php?category='.$cat.'&page='.($page - 1);
|
|||
|
|
if((($page + 1) * MAXPOSTS) < $count)
|
|||
|
|
$_TPL['next_page'] = 'index.php?category='.$cat.'&page='.($page + 1);
|
|||
|
|
}
|
|||
|
|
else if(isset($tag)) // Tags
|
|||
|
|
{
|
|||
|
|
$query = 'SELECT * FROM `posts` WHERE tags LIKE "%'.$tag.'%"
|
|||
|
|
ORDER BY `time` DESC LIMIT '.$start.', '.MAXPOSTS;
|
|||
|
|
|
|||
|
|
$_TPL['title'] = '@'.$tag.' | '.TITLE;
|
|||
|
|
|
|||
|
|
if(($page - 1) >= 0)
|
|||
|
|
$_TPL['prev_page'] = 'index.php?tag='.$tag.'&page='.($page - 1);
|
|||
|
|
if((($page + 1) * MAXPOSTS) < $count)
|
|||
|
|
$_TPL['next_page'] = 'index.php?tag='.$tag.'&page='.($page + 1);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
header('Location:'.URL.'index.php'); exit;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
$result = $sqlite -> query($query);
|
|||
|
|
|
|||
|
|
/*-- View posts -----------------------------------------------------------*/
|
|||
|
|
$parser = new Parsedown();
|
|||
|
|
|
|||
|
|
include_template('header');
|
|||
|
|
|
|||
|
|
if($count) view_posts($result);
|
|||
|
|
else include_template('index_empty');
|
|||
|
|
|
|||
|
|
include_template('index_footer');
|