Location: PHPKode > projects > Blogs manager > blogs/_blogs_view.php
<?php 
ini_set("display_errors","1");
ini_set("display_startup_errors","1");
set_magic_quotes_runtime(0);

include("include/dbcommon.php");
include("include/_blogs_variables.php");


//	check if logged in
if(!@$_SESSION["UserID"] || !CheckSecurity(@$_SESSION["_".$strTableName."_OwnerID"],"Search"))
{ 
	$_SESSION["MyURL"]=$_SERVER["SCRIPT_NAME"]."?".$_SERVER["QUERY_STRING"];
	header("Location: login.php?message=expired"); 
	return;
}

$filename="";	
$message="";

//connect database
$conn = db_connect();

//	Before Process event
if(function_exists("BeforeProcessView"))
	BeforeProcessView($conn);


$keys=array();
$keys["id"]=postvalue("editid1");

//	get current values and show edit controls

$strWhereClause = KeyWhere($keys);


//	select only owned records
$strWhereClause=whereAdd($strWhereClause,SecuritySQL("Search"));

$strSQL=gSQLWhere($strWhereClause);

$strSQLbak = $strSQL;
if(function_exists("BeforeQueryView"))
	BeforeQueryView($strSQL,$strWhereClause);
if($strSQLbak == $strSQL)
	$strSQL=gSQLWhere($strWhereClause);

LogInfo($strSQL);
$rs=db_query($strSQL,$conn);
$data=db_fetch_array($rs);


include('libs/Smarty.class.php');
$smarty = new Smarty();

	$smarty->assign("show_key1", htmlspecialchars(GetData($data,"id", "")));

$keylink="";
$keylink.="&key1=".htmlspecialchars(rawurlencode($data["id"]));

////////////////////////////////////////////
//	username - 
	$value="";
		$value = ProcessLargeText(GetData($data,"username", ""),"","",MODE_VIEW);
	$smarty->assign("show_username",$value);
////////////////////////////////////////////
//	date - Short Date
	$value="";
		$value = ProcessLargeText(GetData($data,"date", "Short Date"),"","",MODE_VIEW);
	$smarty->assign("show_date",$value);
////////////////////////////////////////////
//	TIME - Time
	$value="";
		$value = ProcessLargeText(GetData($data,"TIME", "Time"),"","",MODE_VIEW);
	$smarty->assign("show_TIME",$value);
////////////////////////////////////////////
//	category - 
	$value="";
		if(strlen($data["category"]))
	{
		$strdata = make_db_value("category",$data["category"]);
		$LookupSQL="SELECT ";
					$LookupSQL.="`category`";
		$LookupSQL.=" FROM `_category` WHERE `category` = " . $strdata;
					LogInfo($LookupSQL);
		$rsLookup = db_query($LookupSQL,$conn);
		$lookupvalue=$data["category"];
		if($lookuprow=db_fetch_numarray($rsLookup))
			$lookupvalue=$lookuprow[0];
		$value=ProcessLargeText(GetDataInt($lookupvalue,$data,"category", ""),"field=category".$keylink,"",MODE_VIEW);
	}
	else
		$value="";
	$smarty->assign("show_category",$value);
////////////////////////////////////////////
//	firstline - 
	$value="";
		$value = ProcessLargeText(GetData($data,"firstline", ""),"","",MODE_VIEW);
	$smarty->assign("show_firstline",$value);
////////////////////////////////////////////
//	blog - HTML
	$value="";
		$value = GetData($data,"blog", "HTML");
	$smarty->assign("show_blog",$value);
////////////////////////////////////////////
//	link - Hyperlink
	$value="";
		$value = GetData($data,"link", "Hyperlink");
	$smarty->assign("show_link",$value);
////////////////////////////////////////////
//	picture - HTML
	$value="";
		$value = GetData($data,"picture", "HTML");
	$smarty->assign("show_picture",$value);

$templatefile = "_blogs_view.htm";
if(function_exists("BeforeShowView"))
	BeforeShowView($smarty,$templatefile,$data);

$smarty->display($templatefile);

?>
Return current item: Blogs manager