}
}
if (isset($module) && $module == 'add') {
require 'modules/blog/add.php';
} else {
if (!isset($bid) || !is_numeric($bid)) {
VRedirect::go($config['BASE_URL'] . '/error/blog_missing');
}
$sql = "SELECT BID, UID, title, content, total_comments, total_views, addtime FROM blog\n WHERE BID = " . $bid . " AND status = '1' LIMIT 1";
$rs = $conn->execute($sql);
if ($conn->Affected_Rows() != 1) {
VRedirect::go($config['BASE_URL'] . '/error/blog_missing');
}
$blog = $rs->getrows();
$blog = $blog['0'];
$blog['content'] = blog_output($blog['content']);
$uid = intval($blog['UID']);
$sql = "SELECT * FROM signup WHERE UID = " . $uid . " LIMIT 1";
$rs = $conn->execute($sql);
if ($conn->Affected_Rows() != 1) {
session_write_close();
header('Location: ' . $config['BASE_URL'] . '/error/user_missing');
die;
}
$user = $rs->getrows();
$user = $user['0'];
$username = $user['username'];
if (isset($module)) {
require 'modules/blog/' . $module . '.php';
} else {
$sql = "UPDATE blog SET total_views = total_views+1 WHERE BID = " . $bid . " LIMIT 1";
<?php
defined('_VALID') or die('Restricted Access!');
require $config['BASE_DIR'] . '/classes/pagination.class.php';
if ($config['blog_module'] == '0') {
VRedirect::go($config['BASE_URL'] . '/error/page_invalid');
}
$sql = "SELECT COUNT(BID) AS total_blogs FROM blog WHERE status = '1' AND UID = " . $uid;
$rs = $conn->execute($sql);
$total = $rs->fields['total_blogs'];
$pagination = new Pagination(5);
$limit = $pagination->getLimit($total);
$sql = "SELECT BID, title, content, total_views, total_comments, addtime FROM blog\n WHERE status = '1' AND UID = " . $uid . " ORDER BY addtime DESC LIMIT " . $limit;
$rs = $conn->execute($sql);
$blogs = $rs->getrows();
foreach ($blogs as $key => $content) {
$blogs[$key]['content'] = blog_output($blogs[$key]['content']);
}
$page_link = $pagination->getPagination('user/' . $username . '/blog');
$start_num = $pagination->getStartItem();
$end_num = $pagination->getEndItem();
$self_title = $username . '\'s Blog';
$smarty->assign('blogs', $blogs);
$smarty->assign('blogs_total', $total);
$smarty->assign('page_link', $page_link);
$smarty->assign('start_num', $start_num);
$smarty->assign('end_num', $end_num);
