<?php

require ("/private/database_functions.php");

$db = ConnectDatabase("fsn_content");
$referer = $_SERVER['HTTP_REFERER'];
$ip = $_SERVER['REMOTE_ADDR'];
mysql_query("insert into widget_stats values ('', 'fotd.php.js', '".date("Y-m-d H:i:s")."', '$referer', '$ip')");

CloseDatabase($db);

$db = ConnectDatabase("fsn_content");

$num_flowers = mysql_result(mysql_query("select count(1) from flower_database where status = 'Active' and thumb != '' order by seq"),0);


$day = date("z"); //day of year

$offset = $day % $num_flowers;

$sql = "select common_name, scientific_name, flower_meaning, thumb from flower_database where status = 'Active' and thumb != '' limit 1 offset $offset";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

$image = addslashes($row['thumb']);
$common_name = addslashes($row['common_name']);
$scientific_name = addslashes($row['scientific_name']);
$flower_meaning = addslashes($row['flower_meaning']);

$content .= "<div style=\"width:187px;text-align:center;font-family:Verdana,Arial,Lucida Grande,Lucida Sans Unicode,Lucida,Helvetica,Sans-serif;font-size:11px;\">";
$content .= "<div style=\"border:1px solid #000000;width:187px;text-align:center;\">";
if ($image)
	$content .= "<img src=\"http://www.flowershopnetwork.com/images/meanings/$image\" width=\"187\" height=\"262\"><br>";
$content .= "<div style=\"border-top:1px solid #000000;width:100%;text-align:center;background:#FFFFCC;\">";
$content .= "<b>$common_name</b><br>";
$content .= "<i>$scientific_name</i><br>";
$content .= $flower_meaning;
$content .= "</div>";
$content .= "</div>";
$content .= "<small><a href=\"http://www.fsnmenu.com/27/\">Find a local florist with our directory!</a></small>";
$content .= "</div>";

CloseDatabase($db);

?>

var element=document.getElementById("FSN_FlowerOfTheDay");
if (element) {
	element.innerHTML = '<?php echo $content; ?>';
}