query_one("SELECT * FROM blog_blogs WHERE alias = '$blog'");
// -----------------------------------------------------------------------------------------------
if ($id == 'items') {
$items = $connect->query("SELECT * FROM blog_items WHERE blogid = ".intval($blog[blogid])." ORDER BY timestamp DESC LIMIT 10");
$blog[title] = "$blog[title] Blog";
$pagetitle = "$blog[title] > Recent Entries";
include('../header.php');
print "$blog[title]
";
while ($item = $connect->fetch_array($items)) {
$item[body] = codeparse($item[body]);
print "".stripslashes($item[title])." - ".
dateformat($item[timestamp])."
".stripslashes($item[body])."
";
}
include('../footer.php');
exit();
}
// -----------------------------------------------------------------------------------------------
if (intval($id)) {
$item = $connect->query_one("SELECT * FROM blog_items WHERE itemid = ".intval($id));
$pagetitle = "$blog[title] > $item[title]";
include('../header.php');
print "$blog[title]
$item[title] - ".dateformat($item[timestamp])."
".codeparse($item[body]);
include('../footer.php');
// -----------------------------------------------------------------------------------------------
} else {
$pagetitle = "$blog[title]";
include('../header.php');
print "$blog[title]
".stripslashes($blog[description]);
$items = $connect->query("SELECT bb.alias, bi.itemid, bi.title, bi.timestamp
FROM blog_blogs bb, blog_items bi
WHERE bb.blogid = bi.blogid
AND bb.alias = '$blog[alias]'
ORDER BY timestamp DESC LIMIT 10");
?>
fetch_array($items)) {
$bgcolor = ($itemcount++ % 2) ? '#F8F8DA' : '#F1F1F1';
?>
| "> |
|