Unnamed

<HTML>
<HEAD>
<TITLE>z0mg</TITLE>
</HEAD>
<BODY>
<?php
/**
*
* @version 1.0
* Mambo is Free Software
*/
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );
global $ueConfig, $my, $mosConfig_lang, $mosConfig_absolute_path, $mosConfig_live_site;
$database->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++;
}
?>
<?php
$result2 = mysql_query("select count(*),my_tc_user_group.groupname from my_tc_user_group,my_tc_templates where substring(my_tc_templates.template, $today, 1) = 'F' and year = $thisyear and month = $thismonth and my_tc_templates.username = my_tc_user_group.username group by groupname") or die(mysql_error());

while ($row = mysql_fetch_assoc($result2)) { 
//echo "{$row['groupname']}: {$row['count(*)']}<br/>"; 
$var = $row['groupname']; $$var = $row['count(*)'];
}
?>
<?php
echo "<table bgcolor=#00FF00>";
echo "<tr>";
echo "<td><a href=\"javascript:void(0);\" onmouseover=\"return overlib('$i are good to go today. <br> Druids: $Druids <br> Hunters: $Hunters <br> Mages: $Mages <br> Priests: $Priests <br> Rogues: $Rogues <br> Shamans: $Shamans <br> Warlocks: $Warlocks <br> Warriors: $Warriors',FGCOLOR, '#000000',TEXTCOLOR, '#FFFFFF',BGCOLOR, '#846410');\" onmouseout=\"return nd();\"><span style=\"color: #000000;\">$i</span></a></td>";
echo "</tr>";
echo "</table>"
?>
</BODY>
</HTML>