openside("pavadinimas");
 
$siandien = date('Y-m-d', time());
$laimeta = mysql_fetch_array(mysql_query("SELECT laimetojas, laimeta FROM laimetojai2  WHERE data='$siandien' ORDER BY laimeta DESC"));
if ($laimeta[0]){
echo"
<center><a href='".BASEDIR."komanda.php?te_id=$laimeta[0]'><img src='http://nba23.vhost.lt/stats/images/teams_mid/$laimeta[0].png' border='0'></a><br>
<br>";
 
$tm_info = mysql_query("SELECT * FROM ".DB_PREFIX."teams WHERE te_id='$laimeta[0]'");
while ($q = mysql_fetch_array($tm_info))
{
$te_name = $q['te_name'];
$te_city = $q['te_city'];
$te_id = $q['te_id'];
$te_abbrev = $q['te_abbrev'];
$te_overall = $q['te_overall'];
}
echo "<a href='".BASEDIR."komanda.php?te_id=$te_id'><span style='color:white'>$te_city $te_name</span></a>
<br>
Laimėjo varžybų: <b>$laimeta[1]</b>.<br/>
";
 
$savget = mysql_query("SELECT * FROM savininkai WHERE komandos_id='".$te_id."'");
$users_name_array = mysql_fetch_array($savget);
$user_name_tm = trim($users_name_array['nick']);
 
 
$sav = mysql_query("SELECT * FROM ".DB_PREFIX."users WHERE user_name='$user_name_tm'");
 
while ($u = mysql_fetch_array($sav))
{
$user_id = $u['user_id'];
$user_aim = $u['user_aim'];
}
 
 
$tm_info2 = mysql_query("SELECT * FROM laimetojai WHERE data='$siandien' and laimetojas='$laimeta[0]'");
echo "<table border='0'>
<tr>
 
</tr>";
$n = 0;
while ($r = mysql_fetch_array($tm_info2))
{
$n++;
 
 
$zaidimas = $r['ga_date'];
$bendras = mysql_fetch_array(mysql_query("SELECT ga_home_id, ga_away_id, ga_home_score, ga_away_score, ga_id FROM ".DB_PREFIX."games WHERE ga_date='$zaidimas' ORDER BY ga_date DESC LIMIT 6"));
 
 
$home = $bendras[0];
$away = $bendras[1];
$home_pts = $bendras[2];
$away_pts = $bendras[3];
$idasss = $bendras[4];
 
 
echo "<tr>
<td><span style='color:white'><center><b>$n</b>.</center></span></td>
<td><center><b><a href='".BASEDIR."komanda.php?te_id=$home'><img src='http://nba23.vhost.lt/stats/tm_numbers/$home.gif' border='0'></a></b></center></td>
<td><center><b><a href='".BASEDIR."rezultatas.php?ga_id=$idasss'><span style='color:white'>$home_pts - $away_pts</span></b></a></center></td>
<td><center><a href='".BASEDIR."komanda.php?te_id=$away'><img src='http://nba23.vhost.lt/stats/tm_numbers/$away.gif' border='0'></a></center></td>
</tr>";
}
echo "</table>";
 
 
echo "<br>Savininkas: <a href='".BASEDIR."profile.php?lookup=$user_id'><span style='color:white'>$user_name_tm</span></a> (<a href='skype:$user_aim?chat' class='$user_aim' title='$user_aim'><span style='color:white'>$user_aim</span></a>)
 
";
}else{
echo "<center><b>.</b></center>";
}
closeside();