} } 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);