error_reporting(E_ALL);

<?php 
include ('db.php');
 function  sortByPoints($a,$b)
 {
  
     if($a['points']==$b['points'])
     {
	 
	 $ppg1='SELECT home_score,away_score FROM serp_2012 WHERE tourn="'.$tourn.'" AND tourn_g="'.$group.'" AND sport ="'.$sport.'" AND year ="'.$year.'" AND home="'.$a.'" AND away="'.$b.'"';
	 $ppg2='SELECT home_score,away_score FROM serp_2012 WHERE tourn="'.$tourn.'" AND tourn_g="'.$group.'" AND sport ="'.$sport.'" AND year ="'.$year.'" AND home="'.$b.'" AND away="'.$a.'"';
	 $res_ppg1=mysql_query($ppg1);
	 $res_ppg2=mysql_query($ppg2);
	 $razn1=$res_ppg1['away_score']+$res_ppg2['home_score'];
	 $razn2=$res_ppg2['away_score']+$res_ppg1['home_score'];
	 if(empty($res_ppg1['home_score']) OR empty($res_ppg2['home_score']))
	 {end;}
	 else
	 		{
	 if($razn1<$razn2)
	 {return -1;}
	 elseif($razn1>$razn2)
	 {return 1;}
	 elseif($res_ppg2['away_score']>$res_ppg1['away_score'])
	 {return -1;}
	 else
	 {return 1;}
	 		}
         if($a['difference']==$b['difference'])
         {return 0;}
         elseif($a['difference']>$b['difference'])
         {return -1;}
         else
         {return 1;}
     }
     elseif($a['points']>$b['points'])
     {return -1;}
     else
     {return 1;}
 }

$points='SELECT home, away, home_score, away_score,home_town,away_town FROM serp_2012 WHERE tourn="'.$tourn.'" AND year ="'.$year.'" AND (tourn_g="'.$group_1.'" OR tourn_g="'.$group_2.'")';
 $result=mysql_query($points);
  
 if($result)
 {
     $a=array();
     while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
     {
         $team1=$row['home'];
         $team2=$row['away'];
         if(!isset($a[$team1]))
         {$a[$team1]=array('wins'=>0,'loses'=>0,'goals_a'=>0,'goals_f'=>0,'draws'=>0,'games'=>0,'points'=>0,'difference'=>0);}
         if(!isset($a[$team2]))
         {$a[$team2]=array('wins'=>0,'loses'=>0,'goals_a'=>0,'goals_f'=>0,'draws'=>0,'games'=>0,'points'=>0,'difference'=>0);}
		 if ($row['home_score']!=null AND $row['away_score']!=null)
		 	{$a[$team1]['games']++;
         	$a[$team2]['games']++;}
		 else
		 	{$a[$team1]['games'];
         	$a[$team2]['games'];}
         if($row['home_score']>$row['away_score'])
         	{$a[$team1]['wins']++;
			 $a[$team2]['loses']++;}
         elseif($row['home_score']<$row['away_score'])
         	{$a[$team1]['loses']++;
             $a[$team2]['wins']++;}
         else
         	{if ($row['home_score']!=null AND $row['away_score']!=null)
		 		{$a[$team1]['draws']++;
             	$a[$team2]['draws']++;}
				else
				{$a[$team1]['draws'];
             	$a[$team2]['draws'];}
         	}
         $a[$team1]['points']=+$a[$team1]['wins']*3+$a[$team1]['draws']*1;
         $a[$team2]['points']=+$a[$team2]['wins']*3+$a[$team2]['draws']*1;
         $a[$team1]['goals_a']+=$row['home_score'];
         $a[$team2]['goals_a']+=$row['away_score'];
         $a[$team2]['goals_f']+=$row['home_score'];
         $a[$team1]['goals_f']+=$row['away_score'];
         $a[$team1]['difference']=$a[$team1]['goals_a']-$a[$team1]['goals_f'];
         $a[$team2]['difference']=$a[$team2]['goals_a']-$a[$team2]['goals_f'];
         $a[$team1]['town']=$row['home_town'];
         $a[$team2]['town']=$row['away_town'];

     }
	 
     uasort($a,'sortByPoints');

$q2=array();
echo "<table border=1 cellspacing=0 class=table>";
echo "<tr bgcolor=#CCCCCC>";
echo "<th class=table>№</th><th class=table>Команда</th>";
echo "<th class=table>Игры</th><th class=table>В</th><th class=table>Н</th><th class=table>П</th><th class=table>Голы</th><th class=table>Очки</th></tr>";
$l=1;
foreach($a as $q2team=>$qq2)
{ 
         echo "<tr><td align=center width=20 class=table>$l</td>";
		 echo "<td width=250 class=table align=left>\"$q2team\" ({$qq2['town']})</td>";
   		echo "<td align=center width=50 class=table>{$qq2['games']}</td>";
		echo "<td align=center width=30 class=table>{$qq2['wins']}</td>";
		echo "<td align=center width=30 class=table>{$qq2['draws']}</td>";
		echo "<td align=center width=30 class=table>{$qq2['loses']}</td>";
		echo "<td align=center width=60 class=table>{$qq2['goals_a']}-{$qq2['goals_f']}</td>";
		echo "<td align=center width=45 class=table><strong>{$qq2['points']}</strong></td>";
		echo "</tr>";
		 $l++;
}

echo "</table><br>";
  }
 else
 {
     die(mysql_error());
 }
 mysql_free_result($points);
 mysql_close($points);
?>