Location: PHPKode > projects > SWG MiniBlog > includes/miniblog.php
<?php
/*
	miniblog v 1.0.0
	copyright 2009
*/
if(!defined('IN_BLOG'))
{
	exit;
}

include(PATH . 'includes/config.php');
include(PATH . 'includes/functions.php');

$link = mb_connect($sqlconfig);
unset($sqlconfig);

if(!$link)
{
	die("Could not connect to MySQL database, check the settings in config.php");
}

$config = mb_config();

$post	= (string) mysql_real_escape_string($_GET['post']);
$page	= (int) mysql_real_escape_string(intval($_GET['page']));
$ppp	= (int) intval($config['posts-per-page']);
$from	= (int) intval($ppp * $page);


$sql = ($post == '') ? 'SELECT * FROM `miniblog` WHERE `published` = 1 ORDER BY `date` DESC LIMIT ' . $from . ', ' . $ppp : "SELECT * FROM `miniblog` WHERE `post_slug` = '{$post}' AND `published` = 1";

$result = mysql_query($sql);
$total  = mysql_result(mysql_query("SELECT COUNT(*) FROM `miniblog` WHERE `published` = 1"), 0);

if(mysql_num_rows($result) > 0)
{ 
	while($posts = mysql_fetch_array($result))
	{
		
		$vars = array(
			'$postid$'		=> $posts['post_id'],
			'$posturl$'		=> ($config['use-modrewrite'] == 1) ? $posts['post_slug'] : $config['miniblog-filename'] . '?post=' . $posts['post_slug'],
			'$posttitle$'	=> stripslashes($posts['post_title']),
			'$postdate$'	=> date($config['date-format'], $posts['date']),
			'$postcontent$'	=> stripslashes($posts['post_content']),
		);
		
		$template_vars		= array_keys($vars);
		$template_values	= array_values($vars);
		
		$output = file_get_contents(PATH . 'includes/template.html');
		$output = str_replace($template_vars, $template_values, $output);
		
		$miniblog_posts .= $output;
	}
}

$single = ($post == '') ? false : true;

if($total > ($from + $ppp))
{
	$miniblog_previous = '<a href="' . $config['miniblog-filename'] . '?page=' . ($page + 1)  . '">&laquo; Older posts</a>';
}
if($from > 0)
{
	$miniblog_next = '<a href="' . $config['miniblog-filename'] . '?page=' . ($page - 1)  . '">Recent posts &raquo;</a>';
}
?>
Return current item: SWG MiniBlog