Digest Archives By Date
m_DBQuery ("select ii_pkdigest, ic_date from digests where ic_date like '$vn_year$vn_month%' order by ic_date", "digest")) {
do {
echo "| | a_Data["ii_pkdigest"];
echo "\">";
echo cstod ($db->a_Data["ic_date"]);
echo " | a_Data["ii_pkdigest"];
echo "\">";
echo $db->a_Data["ii_pkdigest"];
echo " |
\n";
} while ($db->m_Next ("digest"));
}
}
function doyear ($vn_year) {
global $db, $month;
if ($db->m_DBQuery ("select substring(ic_date,5,2) as month, min(ii_pkdigest) as first, max(ii_pkdigest) as last from digests where ic_date like '$vn_year%' group by month order by month", "month")) {
do {
echo "| | ";
if ($month == $db->a_Data["month"])
echo "![](\"images/bl_bullet.gif\") ";
else
echo " | ";
switch ($db->a_Data["month"]) {
case "01":
echo "";
echo "January";
echo "";
break;
case "02":
echo "";
echo "February";
echo "";
break;
case "03":
echo "";
echo "March";
echo "";
break;
case "04":
echo "";
echo "April";
echo "";
break;
case "05":
echo "";
echo "May";
echo "";
break;
case "06":
echo "";
echo "June";
echo "";
break;
case "07":
echo "";
echo "July";
echo "";
break;
case "08":
echo "";
echo "August";
echo "";
break;
case "09":
echo "";
echo "September";
echo "";
break;
case "10":
echo "";
echo "October";
echo "";
break;
case "11":
echo "";
echo "November";
echo "";
break;
case "12":
echo "";
echo "December";
echo "";
break;
default:
echo "Unknown";
break;
}
if ($month == $db->a_Data["month"]) {
//echo " | |
\n";
domonth ($vn_year, $month);
echo "| | |
\n";
} else {
echo "Digests ";
echo $db->a_Data["first"];
echo " - ";
echo $db->a_Data["last"];
echo " | \n";
}
} while ($db->m_Next ("month"));
//echo "\n";
} else {
echo "Error!";
}
}
//empty ($year) ? $year=date("Y") : $year;
empty ($year) ? $year=1900 : $year;
empty ($month) ? $month=0 : $month;
$ln_DigestCount = 0;
if ($db->m_DBQuery ("select min(ii_pkdigest) as first, max(ii_pkdigest) as last, left (ic_date,4) as year from digests group by year order by year desc", "year")) {
//$ln_DigestCount = $db->a_Data["digestcount"];
//echo $ln_DigestCount;
?>
a_Data["year"])
echo "| ";
else
echo " |
| ";
echo "a_Data["year"] . "\">";
echo $db->a_Data["year"];
echo " | ";
if ($year == $db->a_Data["year"]) {
//echo " |
\n";
doyear($year);
echo "
| |
\n";
} else {
echo " | Digests " . $db->a_Data["first"] . " - " . $db->a_Data["last"] . " | ";
}
echo "\n";
} while ($db->m_Next("year") && $debug < 10);
echo "
\n";
} else {
echo "Failed!!";
}
$db->m_Disconnect ();
include ("foot.php");
?>