Code: Selecteer alles
// BEGIN BANNER EXCHANGE
//
################################################################################
# Choose a random banner from the database
$sql = "SELECT * FROM phpbb2_banners ORDER BY RAND();";
# Run the above Query
$result = mysql_query($sql);
# End of querying
################################################################################
# Give the variables the data if the SQL query worked
if ($result){
$row = mysql_fetch_array($result);
$imglink = $row['banner_http://www.rc-news.be/foto/banner.swf'];
$imgwww = $row["banner_http://www.rc-store.net"];
$imagedesc = $row["banner_rc-store.net"];}
# If it failed give it some default values so it doesnt display a broken picture
else{
$imglink = ('http://www.rc-news.be/foto/banner.swf');
$imgwww = ("http://www.rc-store.net");
$imagedesc = ("");}
# End of variable setting
################################################################################
# Put all the data into one variable to be used by the board (make life easy ;-)
$banner = "<a title='".$imagedesc."' href='".$imgwww."'><img src='".$imglink."'></a>";
# End of variable setting!
################################################################################
//
// END BANNER EXCHANGE
//