Is the banner management the same as advanced ad management or a totally different mod?
// BANNERS
mysql_connect( "localhost", "xxx", "xxx" );
mysql_select_db( "xxx" );
$sql = "SELECT * FROM __banners WHERE bannerType='b' and bannerStatus='a' ORDER BY RAND() LIMIT 4";
$result = mysql_query( $sql );
$sql = "UPDATE __banners SET bannerViews=bannerViews+1 WHERE ";
echo "<center><table width=940 border=0 cellpadding=0 cellspacing=2>";
echo "<tr><td width=470>";
$rs = mysql_fetch_object( $result );
echo "$rs->bannerText";
$sql .= "bid=$rs->bid or ";
echo "<br style='font-size:1px;'><a href='
http://www.code4gold.com/advertise.php?xz=1' title='Advertise on Code4Gold'>Rotate Your banner ad here ($5 per day - $25 per week) - click for info</a>";
$rs = mysql_fetch_object( $result );
echo "$rs->bannerText";
$sql .= "bid=$rs->bid or ";
echo "<br style='font-size:1px;'><a href='
http://www.code4gold.com/advertise.php?xz=1' title='Advertise on Code4Gold'>Rotate Your banner ad here ($5 per day - $25 per week) - click for info</a>";
echo "</td><td width=470>";
$rs = mysql_fetch_object( $result );
echo "$rs->bannerText";
$sql .= "bid=$rs->bid or ";
echo "<br style='font-size:1px;'><a href='
http://www.code4gold.com/advertise.php?xz=1' title='Advertise on Code4Gold'>Rotate Your banner ad here ($5 per day - $25 per week) - click for info</a>";
$rs = mysql_fetch_object( $result );
echo "$rs->bannerText";
$sql .= "bid=$rs->bid";
echo "<br style='font-size:1px;'><a href='
http://www.code4gold.com/advertise.php?xz=1' title='Advertise on Code4Gold'>Rotate Your banner ad here ($5 per day - $25 per week) - click for info</a>";
echo "</td></tr><tr><td colspan=2>
<center><br style='font-size:1px;'><!--<img src=/banners/728-Banner.jpg>-->";
$sql2 = "SELECT * FROM __banners WHERE bannerType='l' and bannerStatus='a' ORDER BY RAND() LIMIT 1";
$result2 = mysql_query( $sql2 );
$rs2 = mysql_fetch_object( $result2 );
echo "$rs2->bannerText";
$sql .= " or bid=$rs2->bid";
echo "
<br style='font-size:1px;'><a href='
http://www.code4gold.com/advertise.php?xz=3' title='Advertise on Code4Gold'>Purchase This Banner ($10 per day - $50 per week) - 0 of 3 available - click for info</a>
</center>";
echo "</td></tr></table></center>";
$result = mysql_query( $sql );