='".$GLOBALS['SQLOUS'] -> escape(date('Y',$facialTime)).'-04-01 00:00:00'."'", "plandate<='".$GLOBALS['SQLOUS'] -> escape(date('Y',$facialTime)+1).'-03-31 23:59:59'."'" ); $reqs = $maglous -> getRequest(false); if(array_key_exists('ago',$reqs) && strlen($reqs['ago']) > 0){ $bun = false; $range = array( "plandate>='".$GLOBALS['SQLOUS'] -> escape($reqs['ago']).'-04-01 00:00:00'."'", "plandate<='".$GLOBALS['SQLOUS'] -> escape($reqs['ago']+1).'-03-31 23:59:59'."'" ); } $range = ' AND '.join(' AND ',$range); $html = ''; $meets = array(); $result = array(); $dbs = 'maglous_meeting'; if($GLOBALS['SQLOUS'] -> chktables($dbs)){ $sql = "SELECT * FROM ".$dbs." ORDER BY meetpriority ASC"; $GLOBALS['SQLOUS'] -> query($sql); if($GLOBALS['SQLOUS'] -> getRow() > 0){ while($meetings = $GLOBALS['SQLOUS'] -> fetch()){ $meets[$meetings['no']] = $meetings['meetname']; // $tmp = array($meetings['no'] => $meetings['meetname']); // array_push($meets,$tmp); } } if(is_array($meets)){ $trgdb = 'maglous_planstand'; if($GLOBALS['SQLOUS'] -> chktables($trgdb)){ $resultculms = $GLOBALS['SQLOUS'] -> fields($trgdb); foreach($meets as $meetno => $meetname){ $result[$meetno] = array(); $trgdb = 'maglous_planstand'; $sql = "SELECT * FROM ".$trgdb." WHERE planpublish='1' AND planmeetno='".$GLOBALS['SQLOUS'] -> escape($meetno)."'".$range." ORDER BY plandate ASC"; $GLOBALS['SQLOUS'] -> query($sql); if($GLOBALS['SQLOUS'] -> getRow() > 0){ while($meetplan = $GLOBALS['SQLOUS'] -> fetch()){ if(is_array($resultculms)){ $tmp = array(); foreach($resultculms as $fields){ $tmp[$fields] = $meetplan[$fields]; } $result[$meetno][$tmp['no']] = $tmp; } } if(is_array($result[$meetno])){ $db = 'maglous_planscore'; foreach($result[$meetno] as $pri => $val){ $sql = "SELECT * FROM ".$db." WHERE no=".$GLOBALS['SQLOUS'] -> escape($pri); $GLOBALS['SQLOUS'] -> query($sql); if($GLOBALS['SQLOUS'] -> getRow() > 0){ $tmpo = $GLOBALS['SQLOUS'] -> fetch(); $result[$meetno][$pri]['selfftotal'] = $tmpo['selfftotal']; $result[$meetno][$pri]['opponentftotal'] = $tmpo['opponentftotal']; } } } } } if(is_array($meets)){ foreach($meets as $meetkey => $meetname){ if(count($result[$meetkey]) > 0){ $html .= '