query('SELECT ID, StartDate, ExpDate, Clicks, ClicksDone, Display FROM tbl_Banners WHERE Parent_ID='.$_GET['id'])) {
if ($db->numRows() != 0) {
for ($n=0; $n < $db->numRows(); $n++) {
$row = $db->fetchArray();
if ($row['StartDate'] != '') {
$sdate = str_replace(' 00:00:00','',$row['StartDate']);
if ($sdate <= date('Y-m-d')) {
$db->query('UPDATE tbl_Banners SET Display=1 WHERE ID='.$row['ID']);
}
}
if ($row['ExpDate'] != '') {
$edate = str_replace(' 00:00:00','',$row['ExpDate']);
if ($edate == date('Y-m-d') || $row['ClicksDone'] > $row['Clicks']) {
$db->query('UPDATE tbl_Banners SET Display=0 WHERE ID='.$row['ID']);
}
}
}
}
}
if ($db->query('SELECT * FROM tbl_Banners WHERE Parent_ID='.$_GET['id'].' AND Display=1 ORDER BY RAND() LIMIT 1')) {
if ($db->numRows() != 0) {
$bann = $db->fetchArray();
echo "\r\n document.write('![\"".$bann['Title']."\"](\"/bannerdocs/".$bann['StoredImage']."\")
'); \r\n";
} else {
echo "\r\n document.write('![\"no](\"/bannerdocs/noimage.gif\")
'); \r\n";
}
} else {
echo "\r\n document.write(''); \r\n";
}
}
?>