setQuery("SELECT daynote FROM my_tc_daynotes WHERE CURDATE() + 0 = yyyymmdd AND username='all'");
$dbArray = $database->loadAssocList();
$dbArray = $dbArray[0];
$todays_raid = $dbArray['daynote'];
if(is_null($todays_raid)==true){
echo "No raid has been added for today";
}
else {
echo $todays_raid;
}
$today = date('j');
$thismonth = date('m');
$thisyear = date('Y');
$result = mysql_query("SELECT username from my_tc_templates where substring(template, $today, 1) = 'F' and year = $thisyear and month = $thismonth")
or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$toons = $row[username];
if($toons)$i++;
}
?>
";
$var = $row['groupname']; $$var = $row['count(*)'];
}
?>
";
echo "";
echo " Druids: $Druids
Hunters: $Hunters
Mages: $Mages
Priests: $Priests
Rogues: $Rogues
Shamans: $Shamans
Warlocks: $Warlocks
Warriors: $Warriors',FGCOLOR, '#000000',TEXTCOLOR, '#FFFFFF',BGCOLOR, '#846410');\" onmouseout=\"return nd();\">$i | ";
echo "
";
echo ""
?>