sasjamal
10-30-2002, 05:23 AM
function blogs($period="current")
{
if ($period=="current")
{
global $bloghistory;
if ($_GET["history"])
{
$bloghistory=$_GET["history"]<=5 ? $_GET["history"] : 5;
}
// because MySQL does not support sub selects...
mysql_query("create temporary table datetemp (dates varchar(25) NOT NULL) type=myisam") or die(mysql_error());
mysql_query("insert into datetemp (dates) select distinct date_format(dateentered,'%Y-%m-%d') as entrydate from blog_entries where active=1 and pinned=0 order by entrydate desc limit $bloghistory") or die(mysql_error());
$query="select be.blogid,be.preview,be.entry,be.dateentered,be.title,be.pageviews,be.usepreview,ba.name,be.pinned from blog_entries be,datetemp inner join blog_authors ba on be.authorid=ba.authorid where date_format(be.dateentered,'%Y-%m-%d')=datetemp.dates and be.active=1 and be.pinned=0 order by be.dateentered desc";
}
elseif ($period=="category")
{
global $catid;
$query="select be.blogid,be.preview,be.entry,be.dateentered,be.title,be.pageviews,be.usepreview,ba.name,be.pinned from blog_entries be inner join blog_authors ba on be.authorid=ba.authorid where catid=$catid and be.active=1 order by be.dateentered desc";
}
else
{
$query="select be.blogid,be.preview,be.entry,be.dateentered,be.title,be.pageviews,be.usepreview,ba.name,be.pinned from blog_entries be inner join blog_authors ba on be.authorid=ba.authorid where date_format(be.dateentered,'%Y-%m')='$period' and be.active=1 order by be.dateentered desc";
}
showblogs($query);
}
{
if ($period=="current")
{
global $bloghistory;
if ($_GET["history"])
{
$bloghistory=$_GET["history"]<=5 ? $_GET["history"] : 5;
}
// because MySQL does not support sub selects...
mysql_query("create temporary table datetemp (dates varchar(25) NOT NULL) type=myisam") or die(mysql_error());
mysql_query("insert into datetemp (dates) select distinct date_format(dateentered,'%Y-%m-%d') as entrydate from blog_entries where active=1 and pinned=0 order by entrydate desc limit $bloghistory") or die(mysql_error());
$query="select be.blogid,be.preview,be.entry,be.dateentered,be.title,be.pageviews,be.usepreview,ba.name,be.pinned from blog_entries be,datetemp inner join blog_authors ba on be.authorid=ba.authorid where date_format(be.dateentered,'%Y-%m-%d')=datetemp.dates and be.active=1 and be.pinned=0 order by be.dateentered desc";
}
elseif ($period=="category")
{
global $catid;
$query="select be.blogid,be.preview,be.entry,be.dateentered,be.title,be.pageviews,be.usepreview,ba.name,be.pinned from blog_entries be inner join blog_authors ba on be.authorid=ba.authorid where catid=$catid and be.active=1 order by be.dateentered desc";
}
else
{
$query="select be.blogid,be.preview,be.entry,be.dateentered,be.title,be.pageviews,be.usepreview,ba.name,be.pinned from blog_entries be inner join blog_authors ba on be.authorid=ba.authorid where date_format(be.dateentered,'%Y-%m')='$period' and be.active=1 order by be.dateentered desc";
}
showblogs($query);
}
