試合結果 --- 同志社ラグビー部公式ホームページ

='".$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 .= '

'.$meetname.'

'; foreach($result[$meetkey] as $prino => $planresult){ $left_score = $planresult['planposition'] == 1 ? $planresult['selfftotal']:$planresult['opponentftotal']; $right_score = $planresult['planposition'] != 1 ? $planresult['selfftotal']:$planresult['opponentftotal']; $score_judge = ($planresult['selfftotal'] > $planresult['opponentftotal'] ? '勝利':($planresult['selfftotal'] < $planresult['opponentftotal'] ? '負け':'')); if(strlen($left_score) > 0 && strlen($right_score) > 0){ $meet_judge = $left_score.'-'.$right_score.'で'.$score_judge; }else{ $meet_judge = ''; } $html .= ' '; } $html .= '