$postid = $_GET['postid'];
if ($postid == '') {
$mode = "add";
$GLOBALS["pagetitle"]= "Add New Post";
$title = "";
$body ="";
$btimage = 2;
$publication_date=date('Y-m-d H:i:s', time());
} else {
$mode = "edit";
$resultSet = getBlogPost($postid);
$post = $resultSet[0];
//print_r($post);
$GLOBALS["pagetitle"]= 'Edit Post: ' . urldecode($post['posttitle']);
$title = $post['posttitle'];
$body = $post['postbody'];
$btimage = $post['bloguserimage'];
$publication_date=$post['postdatetime'];
}
function getBlogPost($postid) {
$whereclause = "WHERE blogPosts.postid=$postid";
$db =& new BaseDatabaseClass('db');
$sql = "SELECT *,
(Select blogusername from blogUsers where blogUsers.bloguserid = blogPosts.bloguserid ) AS userName
FROM blogPosts
$whereclause";
$db->query($sql);
$resultSet = $db->data;
return $resultSet;
}
// if user has level of 9 or more then they can edit any article
if ($GLOBALS["userLevel"] >= 9) {
$canmanage = true;
$canedit = true;
//echo "canedit, level=" . $GLOBALS["userLevel"] . "
";
} else {
$canmanage = false;
$canedit = false;
//echo "cannot edit, level=" . $GLOBALS["userLevel"] . "
";
}
$formatted_publication_date = formatDate($publication_date);
$btimages_query = "select imageid,description from btimages order by description";
$db =& new BaseDatabaseClass('db');
$db->query($btimages_query);
$btimages_result = $db->data;
$btimageslist = buildSelect($btimages_result,'imageid','description',$btimage);
// get categories list
/*$categories_query = "select categoryid,category from categories order by category";
$db =& new BaseDatabaseClass('db');
$db->query($categories_query);
$categories_result = $db->data;
$categorieslist = buildSelect($categories_result,'categoryid','category','');
*/
?>

