$usr = $_GET['usr'];
$dw = array("Dom", "Seg", "Ter", "Qua", "Qui", "Sex", "Sab");
include 'conectadb.php';
$sql = sprintf("select username from cad_usuario where userid = %d", $usr);
$rs = mysql_query($sql) or die('\\nErro consultando campeonato: ' . mysql_error());
$rc = mysql_fetch_assoc($rs);
$usrname = $rc['username'];
mysql_free_result($rs);
$sql = sprintf("select descricao,ano from cad_campeonato where codigo = %d", $camp);
$rs = mysql_query($sql) or die('\\nErro consultando campeonato: ' . mysql_error());
$rc = mysql_fetch_assoc($rs);
echo "<tr><td colspan=2 style='text-decoration: underline;color:blue;font-weight:bold;font-size:15px;' align=center>" . $rc['descricao'] . "-" . $rc['ano'] . "</td></tr>\n";
echo "<tr><td><br></td></tr>";
echo "<tr><td colspan=2 style='color:blue;font-size:15px;font-weight:bold;text-decoration: underline;' align=center>" . $usrname . "</td></tr>\n";
if ($camp == 4) {
clascopa($usr);
}
mysql_free_result($rs);
echo "<tr><td><br></td></tr>\n";
$verifica = sprintf("select * from\n\t\t\t\t\t\t(select r.rodada,r.jogo,r.golsma,r.golsvi,r.manda cmanda,r.visita cvisita, \n\t\t\t\t\t\t\t\t\t\t\t\ttm.nome manda,tv.nome visita,\n\t\t\t\t\t\t\t\t\t\t\t\tp.pmanda, p.pvisita,p.pontos,\n\t\t\t\t\t\t\t\t\t\t\t\taddtime(r.data, r.hora) datahora, ifnull(cr.posicao,0) posicao,gols,dataini\n\t\t\t\t\t\t\t\t\t\t\t\tfrom\n\t\t\t\t\t\t\t\t\t\t\t\tcad_palpite p,\n\t\t\t\t\t\t\t\t\t\t\t\tcad_times tm,\n\t\t\t\t\t\t\t\t\t\t\t\tcad_times tv,\n\t\t\t\t\t\t\t\t\t\t\t\tcad_rodada r,\n\t\t\t\t\t\t\t\t\t\t\t\t\t(select campeonato,rodada,min(addtime(data, hora)) dataini\n \t\t\t\t\t\t\t\t\t\t\t\t\t\tfrom cad_rodada\n \t\t\t\t\t\t\t\t\t\t\t\t\tgroup by campeonato,rodada) i\n\t\t\t\t\t\t \t\t\t\t\tleft join\n\t\t\t\t\t\t \t\t\t\t\tcad_claroda cr\n\t\t\t\t\t\t\t\t\t\t\t\ton\n\t\t\t\t\t\t\t\t\t\t\t\tcr.campeonato = p.campeonato\n\t\t\t\t\t\t\t\t\t\t\t\tand cr.rodada = p.rodada\n\t\t\t\t\t\t\t\t\t\t\t\tand cr.userid = p.userid\n\t\t\t\t\t\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\t\t\t\t\t\tp.campeonato = %d\n\t\t\t\t\t\t\t\t\t\t\t\tand r.campeonato = i.campeonato\n\t\t\t\t\t\t\t\t\t\t\t\tand r.rodada = i.rodada\n\t\t\t\t\t\t\t\t\t\t\t\tand r.campeonato = p.campeonato\n\t\t\t\t\t\t\t\t\t\t\t\tand r.rodada = p.rodada\n\t\t\t\t\t\t\t\t\t\t\t\tand r.jogo = p.jogo\n\t\t\t\t\t\t\t\t\t\t\t\tand r.manda = tm.codigo\n\t\t\t\t\t\t\t\t\t\t\t\tand r.visita = tv.codigo\n\t\t\t\t\t\t\t\t\t\t\t\tand p.userid =%d) usr\n\t\t\t\t\t\tleft join\n\t\t\t\t\t\t(select r.rodada adv_rodada,r.jogo adv_jogo,\n\t\t\t\t\t\t\t\t\t\t\t\tp.pmanda adv_pmanda, p.pvisita adv_pvisita,p.pontos adv_pontos,\n\t\t\t\t\t\t\t\t\t\t\t\tifnull(cr.posicao,0) adv_posicao,gols adv_gols, username adv_username\n\t\t\t\t\t\t\t\t\t\t\t\tfrom\n\t\t\t\t\t\t\t\t\t\t\t\tcad_palpite p,\n\t\t\t\t\t\t\t\t\t\t\t\tcad_rodada r,\n\t\t\t\t\t\t\t\t\t\t\t\tcad_usuario u,\n\t\t\t\t\t\t\t\t\t\t\t\t(select campeonato,rodada,min(addtime(data, hora)) datahora\n\t\t\t\t\t\t \t\t\t\t\t\tfrom cad_rodada\n\t\t\t\t\t\t \t\t\t\t\tgroup by campeonato,rodada) i\n\t\t\t\t\t\t \t\t\t\t\tleft join\n\t\t\t\t\t\t \t\t\t\t\tcad_claroda cr\n\t\t\t\t\t\t\t\t\t\t\t\ton\n\t\t\t\t\t\t\t\t\t\t\t\tcr.campeonato = p.campeonato\n\t\t\t\t\t\t\t\t\t\t\t\tand cr.rodada = p.rodada\n\t\t\t\t\t\t\t\t\t\t\t\tand cr.userid = p.userid\n\t\t\t\t\t\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\t\t\t\t\t\tp.campeonato = %d\n\t\t\t\t\t\t\t\t\t\t\t\tand r.campeonato = i.campeonato\n\t\t\t\t\t\t\t\t\t\t\t\tand r.rodada = i.rodada\n\t\t\t\t\t\t\t\t\t\t\t\tand r.campeonato = p.campeonato\n\t\t\t\t\t\t\t\t\t\t\t\tand r.rodada = p.rodada\n\t\t\t\t\t\t\t\t\t\t\t\tand r.jogo = p.jogo\n\t\t\t\t\t\t\t\t\t\t\t\tand p.userid = u.userid\n\t\t\t\t\t\t\t\t\t\t\t\tand p.userid =(select min(userid) from cad_rodada_copa\n\t\t\t\t\t\t where campeonato = %d\n\t\t\t\t\t\t and rodada = r.rodada\n\t\t\t\t\t\t and userid <> %d\n\t\t\t\t\t\t and jogo = (select min(jogo) from cad_rodada_copa\n\t\t\t\t\t\t where\n\t\t\t\t\t\t rodada = r.rodada\n\t\t\t\t\t\t and userid = %d))) adv\n\t\t\t\t\t\ton\n\t\t\t\t\t\tusr.jogo = adv.adv_jogo\n\t\t\t\t\t\tand usr.rodada = adv.adv_rodada order by rodada desc, jogo", $camp, $usr, $camp, $camp, $usr, $usr);
$result = mysql_query($verifica) or die('\\nErro consultando banco de dados: ' . mysql_error());
$fllin = 0;
$rodant = 0;
$pts = 0;
//Pontos do usuário
$gols = 0;
//Gols do usuário
$posrod = 0;
$fllst = 0;
$golstot = 0;
//Total de Gols do usuário
if ($camp != 4) {
bonifica($camp, $rod);
}
// Calcula bonus por recorde de rodada
classifica($camp);
// Apura classificação geral do bolão
clasatual($camp, $rod);
// Apura classificação geral do bolão até a rodada informada
clasrod($camp, $rod);
// Apura classificação da rodada
if ($camp != 4) {
pontoscopa($camp, $rod);
// Apura pontuação da copa bolão
totalcopa($camp, $rod);
// Totaliza pontuação da copa por grupos
clascopa($camp);
//Processa classificação da copa
estatisticas($camp, $rod);
//Grava informações para ranking
}
/* oitavas($camp,$rod); //Processa oitavas de final
quartas($camp,$rod); //Processa quartas de final*/
$db->Close();
$db2->Close();
$db3->Close();
?>
</table>
<?php
include "bothome.php";
?>
