<?PHP

/*
	The Pulpit
	By Jason Nishi

	Article Page Generator
*/

include("common.php");


$errorpage = "error.phtml";
$template = "article.tmpl";
$banneradincludeurl = "http://i360.com/cgi-bin/bannerad/bannerad.pl";

$SQL = "SELECT * FROM $table WHERE id = \"" . mysql_escape_string($id) . "\" LIMIT 1";
$dbmain = connectDBRead();
$dbuser = openUserConnect();
$article_result = @mysql_query($SQL, $dbmain);
if (!$article_result || @mysql_num_rows($article_result) == 0)
{
   include($errorpage);
   exit;
}
$row = @mysql_fetch_array($article_result);
$date = $row["date"];
$delay = $row["delay"];
$by = $row["by"];
$byline = $row["byline"];
$topic = $row["topic"];
$drawline = $row["drawline"];
$title = $row["title"];
$lead = $row["lead"];
$story = $row["story"];

$dateyear = substr($date, 0, 4);
$datemonth = substr($date, 4, 2);
$dateday = substr($date, 6, 2);
$dateformat = "m/d/Y";               // ex: 04/30/2003
$date = date($dateformat, mktime(0, 0, 0, $datemonth, $dateday, $dateyear));

$usersql = "SELECT realname, website FROM people WHERE user = \"" . mysql_escape_string($by) . "\"";
$user_results = @mysql_query($usersql, $dbuser);
if (@mysql_num_rows($user_results) == 0)
{
   $people_realname = "anonymous coward";
   $people_website = "#";
}
else
{
   $userrow = @mysql_fetch_array($user_results);
   $people_realname = $userrow["realname"];
   if ($people_realname == "" || strlen($people_realname) == 0) 
      $people_realname = "anonymous coward";
   $people_website = $userrow["website"];
   if ($people_website == "" || strlen($people_website) == 0) 
      $people_website = "#";
}

if ($byline == "" || strlen($byline) == 0)
   $byline = $people_realname;



$farray = @file($template);
if (!$farray)
{
   include($errorpage);
   exit;
}


//THE FOLLOWING IS A HACK:  DO THE PHP FOR THE BANNER AD IF NECESSARY
if (strpos(implode("", $farray), "<#banner#>"))
   $banneroutput = @implode("", @file($banneradincludeurl));

$farray = str_replace("<#id#>", $id, $farray);
$farray = str_replace("<#date#>", $date, $farray);
$farray = str_replace("<#by#>", $by, $farray);
$farray = str_replace("<#byline#>", $byline, $farray);
$farray = str_replace("<#topic#>", $topic, $farray);
$farray = str_replace("<#drawline#>", $drawline, $farray);
$farray = str_replace("<#title#>", $title, $farray);
$farray = str_replace("<#lead#>", $lead, $farray);
$farray = str_replace("<#story#>", $story, $farray);
$farray = str_replace("<#bylink#>", $people_website, $farray);
$farray = str_replace("<#byrealname#>", $people_realname, $farray);
$farray = str_replace("<#banner#>", $banneroutput, $farray);

for ($i = 0; $i < count($farray); $i++)
   echo $farray[$i];
?>