 Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory : /home/gositeme/domains/gositeme.com/public_html/quickqr/php/ |
<?php
// if blog is disable
if(!$config['blog_enable']){
error($lang['PAGE_NOT_FOUND'], __LINE__, __FILE__, 1);
}
if(checkloggedin()) {
update_lastactive();
}
if(!isset($_GET['page']))
$page = 1;
else
$page = $_GET['page'];
$limit = 8;
$search = $archive = $keyword = $category = $author = null;
$title = $lang['BLOG'];
$page_link = $link['BLOG'];
if(isset($_GET['archive'])){
if($_GET['archive'] == 'category' && !empty($_GET['keyword'])){
$archive_cat = ORM::for_table($config['db']['pre'] . 'blog_categories')
->where('slug', $_GET['keyword'])
->find_one();
if(!empty($archive_cat['id'])){
$category = $archive_cat['id'];
$keyword = $archive_cat['title'];
}else{
error($lang['PAGE_NOT_FOUND'], __LINE__, __FILE__, 1);
exit;
}
} else if($_GET['archive'] == 'author') {
$archive_author = ORM::for_table($config['db']['pre'] . 'admins')
->where('username', $_GET['keyword'])
->find_one();
if(!empty($archive_author['id'])){
$author = $archive_author['id'];
$keyword = $archive_author['name'];
}else{
error($lang['PAGE_NOT_FOUND'], __LINE__, __FILE__, 1);
exit;
}
} else {
error($lang['PAGE_NOT_FOUND'], __LINE__, __FILE__, 1);
exit;
}
}
$sql = "SELECT
b.*, u.name, u.username, u.image author_pic, GROUP_CONCAT(c.title) categories, GROUP_CONCAT(c.slug) cat_slugs
FROM `".$config['db']['pre']."blog` b
LEFT JOIN `".$config['db']['pre']."admins` u ON u.id = b.author
LEFT JOIN `" . $config['db']['pre'] . "blog_cat_relation` bc ON bc.blog_id = b.id
LEFT JOIN `" . $config['db']['pre'] . "blog_categories` c ON bc.category_id = c.id
WHERE b.status = 'publish'";
$sql_total = "SELECT COUNT(b.id) as total FROM `".$config['db']['pre']."blog` b
LEFT JOIN `" . $config['db']['pre'] . "blog_cat_relation` bc ON bc.blog_id = b.id
LEFT JOIN `" . $config['db']['pre'] . "blog_categories` c ON bc.category_id = c.id
WHERE b.status = 'publish'";
if($category){
$sql .= " AND bc.category_id = $category";
$sql_total .= " AND bc.category_id = $category";
$title = $lang['CATEGORY'].': '.$keyword;
$page_link = $link['BLOG-CAT'].'/'.$_GET['keyword'];
}
if($author){
$sql .= " AND b.author = $author";
$sql_total .= " AND b.author = $author";
$title = $lang['AUTHOR'].': '.$keyword;
$page_link = $link['BLOG-AUTHOR'].'/'.$_GET['keyword'];
}
if(isset($_GET['s'])){
$search = str_replace("-"," ",$_GET['s']);
$title = $lang['SEARCH_RESULT_FOR'].' “'.$search.'”';
$sql .= " AND (b.title LIKE '%$search%' OR b.description LIKE '%$search%' OR b.tags LIKE '%$search%' )";
$sql_total .= " AND (b.title LIKE '%$search%' OR b.description LIKE '%$search%' OR b.tags LIKE '%$search%' )";
}
$sql .= " GROUP BY b.id ORDER BY b.created_at DESC";
$data = ORM::for_table($config['db']['pre'].'blog')->raw_query($sql_total)->find_many();
$total = $data[0]['total'];
$query = "$sql LIMIT ".($page-1)*$limit.",$limit";
$result = ORM::for_table($config['db']['pre'].'blog')->raw_query($query)->find_many();
$items = array();
$result_found = count($result);
if ($result) {
foreach ($result as $info)
{
$items[$info['id']]['id'] = $info['id'];
$items[$info['id']]['title'] = $info['title'];
$items[$info['id']]['image'] = !empty($info['image'])?$info['image']:'default.png';
$items[$info['id']]['description'] = strlimiter(strip_tags(stripslashes($info['description'])),100);
$items[$info['id']]['author'] = $info['name'];
$items[$info['id']]['author_link'] = $link['BLOG-AUTHOR'].'/'.$info['username'];
$items[$info['id']]['author_pic'] = !empty($info['author_pic'])?$info['author_pic']:'default_user.png';
$items[$info['id']]['created_at'] = timeAgo($info['created_at']);
$items[$info['id']]['link'] = $link['BLOG-SINGLE'].'/'.$info['id'].'/'.create_slug($info['title']);
$categories = explode(',',$info['categories']);
$cat_slugs = explode(',',$info['cat_slugs']);
$arr = array();
for($i = 0; $i < count($categories); $i++){
$arr[] = '<a href="'.$link['BLOG-CAT'].'/'.$cat_slugs[$i].'">'.$categories[$i].'</a>';
}
$items[$info['id']]['categories'] = implode(', ',$arr);
}
}
$pagging = pagenav($total,$page,$limit,$page_link);
if($search){
$pagging = pagenav($total,$page,$limit,$page_link.'?s='.$search,1);
}
// get categories
$sql = "SELECT
c.*, COUNT(bc.blog_id) blog
FROM `".$config['db']['pre']."blog_categories` c
LEFT JOIN `" . $config['db']['pre'] . "blog_cat_relation` bc ON bc.category_id = c.id
LEFT JOIN `" . $config['db']['pre'] . "blog` b ON bc.blog_id = b.id
WHERE c.active = '1' AND b.status = 'publish' GROUP BY c.id ORDER BY c.position";
$result = ORM::for_table($config['db']['pre'].'blog_categories')->raw_query($sql)->find_many();
$blog_cat = array();
foreach($result as $row){
$blog_cat[$row['id']]['id'] = $row['id'];
$blog_cat[$row['id']]['title'] = $row['title'];
$blog_cat[$row['id']]['blog'] = $row['blog'];
$blog_cat[$row['id']]['link'] = $link['BLOG-CAT'].'/'.$row['slug'];
}
// get testimonials
$rows = ORM::for_table($config['db']['pre'] . 'testimonials')
->order_by_desc('id')
->limit(5)
->find_many();
$testimonials = array();
foreach ($rows as $row) {
$testimonials[$row['id']]['id'] = $row['id'];
$testimonials[$row['id']]['name'] = $row['name'];
$testimonials[$row['id']]['designation'] = $row['designation'];
$testimonials[$row['id']]['content'] = $row['content'];
$testimonials[$row['id']]['image'] = !empty($row['image']) ? $row['image'] : 'default_user.png';
}
// get all tags
$rows = ORM::for_table($config['db']['pre'].'blog')
->select('tags')
->where('status', 'publish')
->find_many();
$all_tags = array();
$tag2 = array();
foreach($rows as $row){
if(!empty($row['tags'])) {
$tag = explode(',', $row['tags']);
foreach ($tag as $val) {
//REMOVE SPACE FROM $VALUE ----
$tagTrim = preg_replace("/[\s_]/", "-", trim($val));
$tag2[] = '<a href="' . $link['BLOG'] . '?s=' . $tagTrim . '"><span>' . $val . '</span></a>';
}
}
}
$all_tags = implode(' ', array_unique($tag2));
$page = new HtmlTemplate ('templates/' . $config['tpl_name'] . '/blog.tpl');
$page->SetParameter ('OVERALL_HEADER', create_header($title));
$page->SetParameter ('TITLE', $title);
$page->SetParameter ('SEARCH', $search);
$page->SetParameter ('RESULT_FOUND', $result_found);
$page->SetParameter ('ALL_TAGS', $all_tags);
$page->SetParameter('SHOW_PAGING', (int)($total > $limit));
$page->SetLoop ('BLOG',$items);
$page->SetLoop ('PAGES', $pagging);
$page->SetLoop ('BLOG_CAT', $blog_cat);
$page->SetLoop('TESTIMONIALS', $testimonials);
$page->SetParameter ('OVERALL_FOOTER', create_footer());
$page->CreatePageEcho();
?>