/** * Construtor * @param int $userid * @return void */ function Time($codigo) { $db = new BD(); $sql = sprintf("select\n\t\t\t codigo,\n\t\t\t nome,\n\t\t\t tipo,\n\t\t\t simbolo\n\t\t\t from\n cad_times\n where codigo= %d", $codigo); $db->Query($sql); $db->Next(); $this->Codigo = $codigo; $this->Nome = $db->getValue('nome'); $this->Tipo = $db->getValue('tipo'); $this->Simbolo = $db->getValue('simbolo'); $db->Close(); }
/** * Construtor * @param int $id * @return void */ function Reuniao($id) { $db = new BD(); $sql = sprintf("select\n\t\t\t id,\n\t\t\t data,\n\t\t\t hora,\n\t\t\t local\n\t\t\t from\n cad_reuniao\n where id= %d", $id); $db->Query($sql); if ($db->NumRows() == 0) { $this->Existe = 'N'; } else { $this->Existe = 'S'; $db->Next(); $this->ID = $id; $this->Data = $db->getValue('data'); $this->Hora = $db->getValue('hora'); $this->Local = $db->getValue('local'); } $db->Close(); }
/** * Construtor * @param int $id * @return void */ function Evento($idevento) { $db = new BD(); $sql = sprintf("select\n\t\t\t id,\n\t\t\t data,\n\t\t\t local,\n\t\t\t descricao\n\t\t\t from\n cad_eventos\n where id= %d", $idevento); $db->Query($sql); if ($db->NumRows() == 0) { $this->Existe = 'N'; } else { $this->Existe = 'S'; $db->Next(); $this->ID = $idevento; $this->Data = $db->getValue('data'); $this->Local = $db->getValue('local'); $this->Descricao = $db->getValue('descricao'); } $db->Close(); }
/** * Construtor * @param int $id * @return void */ function Calendario($id) { $db = new BD(); $sql = sprintf("select\n\t\t\t idcalendario,\n\t\t\t dataevento,\n\t\t\t titulo,\n\t\t\t descricao,\n\t\t\t local,\n\t\t\t realizacao\n\t\t\t from\n tb_calendario\n where idcalendario= %d", $id); $db->Query($sql); if ($db->NumRows() == 0) { $this->Existe = 'N'; } else { $this->Existe = 'S'; $db->Next(); $this->ID = $id; $this->Data = $db->getValue('dataevento'); $this->Titulo = $db->getValue('titulo'); $this->Descricao = $db->getValue('descricao'); $this->Local = $db->getValue('local'); $this->Realizacao = $db->getValue('realizacao'); } $db->Close(); }
/** * Construtor * @param int $userid * @return void */ function RodadaCopa($camp, $rod) { $db = new BD(); $sql = sprintf("select distinct \n\t\t\t campeonato,\n\t\t\t rodada,\n\t\t\t jogo\n\t\t\t from\n cad_rodada_copa\n where campeonato = %d\n\t\t\t and rodada = %d", $camp, $rod); $db->Query($sql); $this->Campeonato = $camp; $this->Rodada = $rod; while ($db->Next()) { array_push($this->Jogos, $db->getValue('jogo')); } $db->Close(); }
function getFim() { //Retorna o numero da ultima rodada $datafim = 0; $db = new BD(); $sql = sprintf("select\n\t\t\t\t\t max(addtime(data,hora)) datafim\n\t\t\t\t\t from\n\t\t\t\t\t cad_rodada\n\t\t\t\t\t where \n\t\t\t\t\t campeonato= %d \n\t\t\t\t\t and rodada = %d", $this->getCampeonato(), $this->getRodada()); $db->Query($sql); $db->Next(); $datafim = $db->getValue('datafim'); $db->Close(); return $datafim; }
/** * Construtor * @param int $userid * @return void */ function JogoCopa($camp, $rod, $jg) { $db = new BD(); $sql = sprintf("select \n\t\t\t campeonato,\n\t\t\t rodada,\n\t\t\t jogo,\n\t\t\t tipo,\n\t\t\t userid,\n\t\t\t golsp,\n\t\t\t pontos,\n\t\t\t grupo\n\t\t\t from\n cad_rodada_copa\n where campeonato = %d\n\t\t\t and rodada = %d\n\t\t\t and jogo = %d", $camp, $rod, $jg); $db->Query($sql); $this->Campeonato = $camp; $this->Rodada = $rod; $this->Jogo = $jg; while ($db->Next()) { if ($db->getValue('tipo') == 'M') { $this->Mandante = $db->getValue('userid'); $this->GolsMa = $db->getValue('golsp'); $this->PontosMa = $db->getValue('pontos'); } else { $this->Visitante = $db->getValue('userid'); $this->GolsVi = $db->getValue('golsp'); $this->PontosVi = $db->getValue('pontos'); } $this->Grupo = $db->getValue('grupo'); } $db->Close(); }
function getVotos($op) { // Retorna os votos de cada opção $res = array(); $Votos = 0; $db = new BD(); if (strtoupper($op) == "TOTAL") { $sql = sprintf("select\n\t\t\t\t\t count(*) votos\n\t\t\t\t\t from\n\t\t\t\t\t cad_enquete_votos where\n\t\t\t\t\t numero = %d", $this->getCodigo()); } else { $sql = sprintf("select\n\t\t\t\t\t count(*) votos\n\t\t\t\t\t from\n\t\t\t\t\t cad_enquete_votos where\n\t\t\t\t\t numero = %d and opcao = %d", $this->getCodigo(), $op); } $db->Query($sql); $db->Next(); $Votos = $db->getValue('votos'); $db->Close(); return $Votos; }
function getProximaRodada() { //Retorna o numero da rodada atual $Rodada = 0; $db = new BD(); $sql = sprintf("select ifnull(min(rodada),0) rodada\n\t\t\t\t\t\t\tfrom cad_rodada\n\t\t\t\t\t\t\twhere campeonato = %d\n\t\t\t\t\t\t\tand rodada > %d", $this->Codigo, $this->getRodadaAtual()); $db->Query($sql); $db->Next(); $Rodada = $db->getValue('rodada'); $db->Close(); return $Rodada; }
<?php require_once $_SESSION['DOCROOT'] . "/classes/class.bd.php"; require_once $_SESSION['DOCROOT'] . "/classes/class.usuario.php"; require_once $_SESSION['DOCROOT'] . "/classes/class.campeonato.php"; require_once $_SESSION['DOCROOT'] . "/classes/class.inscricao.php"; $db = new BD(); $sql = sprintf("select i.campeonato,i.userid " . "from " . "cad_inscricao i, " . "cad_usuario u, " . "cad_campeonato c " . "where " . "i.campeonato = c.codigo " . "and i.userid = u.userid " . "and c.flandamento = 'S' and c.codigo = 4 " . "order by " . "c.ano desc," . "i.campeonato," . "i.posefetiva," . "u.username"); $db->Query($sql); $camp = 0; $posant = 0; $pos = 0; if ($db->NumRows() == 0) { echo ' <tr> <td>Não existe campeonatos cadastrados ou em andamento no momento.<br></td> </tr>' . "\n"; } else { while ($db->Next()) { if ($camp != $db->getValue('campeonato')) { if ($camp != 0) { echo "<tr><td colspan=4><br></td></tr>\n"; } $pos = 0; $cmp = new Campeonato($db->getValue('campeonato')); echo "<tr style='background:rgb(250, 252, 188);color:rgb(0, 102, 0);'><td colspan=10 align=center><b>" . $cmp->getDescricaoAno() . "</td></tr>\n"; echo "<tr style='background:rgb(250, 252, 188);color:rgb(0, 102, 0);'><td colspan=3 align=center><b>Classificação do Bolão</td>\n\t\t\t\t\t\t\t</tr>\n"; $camp = $cmp->getCodigo(); echo "<tr class='cabec'><td align=center>Pos</td><td>Participante</td><td align=center>Pontos</td></tr>\n"; } $usr = new Usuario($db->getValue('userid')); $ins = new Inscricao($cmp->getCodigo(), $usr->getUserid()); if ($posant != $ins->getPosicao()) { $pos = $ins->getPosefetiva(); $posant = $ins->getPosicao();
function getJogosCopa($rodada) { $Adv = array(); $db = new BD(); $sql = sprintf("select jogo\n\t\t\t\t\t\t from cad_rodada_copa\n\t\t\t\t\t\t where campeonato = %d\n\t\t\t\t\t\t and rodada = %d\n\t\t\t\t\t\t and userid = %d", $this->getCampeonato(), $rodada, $this->getUserid()); $db->Query($sql); while ($db->Next()) { array_push($Adv, $db->getValue('jogo')); } $db->Close(); return $Adv; }
function LogUsuario($pUserid, $pOrigem, $pLogado) { $gi = geoip_open($_SERVER['DOCUMENT_ROOT'] . "/geoip/GeoLiteCity.dat", GEOIP_STANDARD); $geoip = geoip_record_by_addr($gi, $_SERVER['REMOTE_ADDR']); $db = new BD(); $sql = sprintf("select count(*) qtde from log_usuario\n where\n ip = '%s'\n and sessionid = '%s'", $_SERVER['REMOTE_ADDR'], session_id()); $db->Query($sql); $db->Next(); if ($db->getValue("qtde") == 0) { $sql = sprintf("insert into log_usuario\n\t\t\t\t\t(userid,datahora,origem,logado,ip,sessionid,cidade,estado,pais)\n\t\t\t\t\tvalues (%d,now(),'%s','%s','%s','%s','%s','%s','%s')", $pUserid, $pOrigem, $pLogado, $_SERVER['REMOTE_ADDR'], session_id(), $geoip->city, RetornaEstado($geoip->country_code, $geoip->region), $geoip->country_name); } else { $sql = sprintf("update log_usuario\n\t\t\t\t\t\t\tset userid = %d,\n\t\t\t\t\t\t\t\torigem = '%s',\n\t\t\t\t\t\t\t\tlogado = '%s',\n\t\t\t\t\t\t\t\tqtde = qtde + 1\n\t\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\t\tip = '%s'\n\t\t\t\t\t\t\t\tand sessionid = '%s'", $pUserid, $pOrigem, $pLogado, $_SERVER['REMOTE_ADDR'], session_id()); } $db->Exec($sql); $db->Close(); geoip_close($gi); }
require_once $_SESSION['DOCROOT'] . "/classes/class.usuario.php"; require_once $_SESSION['DOCROOT'] . "/classes/class.inscricao.php"; $db = new BD(); $sql = sprintf("select r2.campeonato campeonato from\n\t\t\t\t\t\t(select max(subtime(addtime(data, hora),'06:00:00')) datarod\n\t\t\t\t\t\t\t\tfrom cad_rodada r,\n\t\t\t\t\t\t\t\tcad_campeonato c\n\t\t\t\t\t\t\t\twhere date_add(now(),interval 1 hour) > subtime(addtime(data, hora),'06:00:00')\n\t\t\t\t\t\t\t\tand c.codigo = r.campeonato\n\t\t\t\t\t\t\t\tand c.`flandamento` = 'S'\n\t\t\t\t\t\t\t\thaving date_add(now(),interval 1 hour) > datarod) r,\n\t\t\t\t\t\t(select campeonato,max(subtime(addtime(data, hora),'06:00:00')) datarod\n\t\t\t\t\t\t\t\tfrom cad_rodada r,\n\t\t\t\t\t\t\t\tcad_campeonato c\n\t\t\t\t\t\t\t\twhere date_add(now(),interval 1 hour) > subtime(addtime(data, hora),'06:00:00')\n\t\t\t\t\t\t\t\tand c.codigo = r.campeonato\n\t\t\t\t\t\t\t\tand c.`flandamento` = 'S'\n\t\t\t\t\t\t\t\tgroup by r.campeonato\n\t\t\t\t\t\t\t\thaving date_add(now(),interval 1 hour) > datarod) r2\n\t\t\t\t\t\twhere r.datarod = r2.datarod"); $db->Query($sql); $db->Next(); $camp = $db->getValue('campeonato'); $db->Close(); $db = new BD(); $sql = sprintf("select ifnull(cr.posicao,0) posicao,username,ifnull(cr.pontos,0) pontos,ra.rodadatual,ifnull(cr.posefetiva,0) posefetiva,i.campeonato,i.userid,c.descricao\n\t\t\t\t\t\tfrom\n\t\t\t\t\t\tcad_inscricao i,\n\t\t\t\t\t\tcad_usuario u,\n\t\t\t\t\t\tcad_campeonato c,\n\t\t\t\t\t\t(select campeonato,rodada,userid from cad_palpite\n\t\t\t\t\t\t group by campeonato,rodada,userid) p,\n\t\t\t\t\t\t(select campeonato,max(rodada) rodadatual from\n\t\t\t\t\t\t(select campeonato,rodada,min(addtime(data, hora)) dataini\n\t\t\t\t\t\tfrom cad_rodada\n\t\t\t\t\t\tgroup by campeonato,rodada\n\t\t\t\t\t\thaving date_add(now(),interval 1 hour) > subtime(dataini,'00:15:00')) r\n\t\t\t\t\t\tgroup by campeonato) ra\n\t\t\t\t\t\tleft join\n\t\t\t\t\t\tcad_claroda cr\n\t\t\t\t\t\t\ton\n\t\t\t\t\t\tra.campeonato = cr.campeonato\n\t\t\t\t\t\tand ra.rodadatual = cr.rodada\n\t\t\t\t\t\tand cr.userid = i.userid\n\t\t\t\t\t\t\t\twhere\n\t\t\t\t\t\ti.userid = u.userid\n\t\t\t\t\t\tand i.campeonato = ra.campeonato\n\t\t\t\t\t\tand i.campeonato = p.campeonato\n\t\t\t\t\t\tand ra.rodadatual = p.rodada\n\t\t\t\t\t\tand ra.campeonato = p.campeonato\n\t\t\t\t\t\tand i.userid = p.userid\n\t\t\t\t\t\tand i.campeonato = c.codigo\n\t\t\t\t\t\tand c.flandamento = 'S'\n\t\t\t\t\t\tand cr.posefetiva <>0\n\t\t\t\t\t\tand c.codigo = %d\n\t\t\t\t\t\torder by posefetiva,username", $camp); $db->Query($sql); $vez = 0; $posant = 0; while ($db->Next()) { if ($vez == 0) { echo "<tr style='background:rgb(250, 252, 188);color:rgb(0, 102, 0);font-size:10px;'><td colspan=3>" . $db->getValue('descricao') . "</td></tr>"; $ln = sprintf(" <tr style='background:rgb(250, 252, 188);color:rgb(0, 102, 0);font-size:10px;'><td colspan=3><span>Classificação Rodada:<b>%02d</span></td></tr>", $db->getValue('rodadatual')); echo $ln; echo "<tr style='background:rgb(0, 102, 0);color:#ffffff'><td>Pos</td><td>Participante</td><td>Pts</td></tr>"; $vez = 1; } $usr = new Usuario($db->getValue('userid')); $ins = new Inscricao($db->getValue('campeonato'), $db->getValue('userid')); if ($posant != $db->getValue('posicao')) { $pos = $db->getValue('posefetiva'); $posant = $db->getValue('posicao'); } else { $pos = " "; } /* if ($row['posicao'] <= 5) $st = 'style="background:rgb(255, 194, 133);font-size:11px;"';
<?php include "sessao.php"; require_once $_SESSION['DOCROOT'] . "/classes/class.bd.php"; $db = new BD(); $sql = sprintf('select email from cad_usuario'); $db->Query($sql); while ($db->Next()) { echo $db->getValue('email') . ' <br/>' . "\n"; } $db->Close(); ?> </div>
$db = new BD(); $sql = sprintf("select r2.campeonato campeonato from\n\t\t\t\t\t\t(select max(subtime(addtime(data, hora),'06:00:00')) datarod\n\t\t\t\t\t\t\t\tfrom cad_rodada r,\n\t\t\t\t\t\t\t\tcad_campeonato c\n\t\t\t\t\t\t\t\twhere date_add(now(),interval 1 hour) > subtime(addtime(data, hora),'06:00:00')\n\t\t\t\t\t\t\t\tand c.codigo = r.campeonato\n\t\t\t\t\t\t\t\tand c.`flandamento` = 'S'\n\t\t\t\t\t\t\t\thaving date_add(now(),interval 1 hour) > datarod) r,\n\t\t\t\t\t\t(select campeonato,max(subtime(addtime(data, hora),'06:00:00')) datarod\n\t\t\t\t\t\t\t\tfrom cad_rodada r,\n\t\t\t\t\t\t\t\tcad_campeonato c\n\t\t\t\t\t\t\t\twhere date_add(now(),interval 1 hour) > subtime(addtime(data, hora),'06:00:00')\n\t\t\t\t\t\t\t\tand c.codigo = r.campeonato\n\t\t\t\t\t\t\t\tand c.`flandamento` = 'S'\n\t\t\t\t\t\t\t\tgroup by r.campeonato\n\t\t\t\t\t\t\t\thaving date_add(now(),interval 1 hour) > datarod) r2\n\t\t\t\t\t\twhere r.datarod = r2.datarod"); $db->Query($sql); $db->Next(); $camp = $db->getValue('campeonato'); $cmp = new Campeonato($camp); $db->Close(); $cab = sprintf('<legend><span style="color:green;"><b>Rodada Atual</b></legend>'); echo $cab . "\n"; ?> <table id=menuadm frame=box bordercolor="white" border="1px" cellspacing="0" style="width:450px;" width="450px"> <tr class="cabec"> <td width="140px" align="right">Mandante</td><td width="40px" align="center">x</td><td width="140px">Visitante</td><td align="center">Data/Hora</td> </tr> <?php $sql = sprintf("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\taddtime(r.data, r.hora) datahora\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_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\twhere\n\t\t\t\t\t\t\t\t\t\t\t\tr.campeonato = %d\n\t\t\t\t\t\t\t\t\t\t\t\tand r.rodada = %d\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", $cmp->getCodigo(), $cmp->getRodadaAtual()); $db = new BD(); $db->Query($sql); while ($db->Next()) { $tm = new Time($db->getValue('cmanda')); $tv = new Time($db->getValue('cvisita')); $linha = sprintf('<td align="right">%s</td>' . '<td align="center">%s x %s</td> ' . '<td>%s</td> ' . '<td>%s %s</td> ', $tm->getLink(), $db->getValue('golsma'), $db->getValue('golsvi'), $tv->getLink(), date("d/m/Y H:i", strtotime($db->getValue('datahora'))), $dw[date("w", strtotime($db->getValue('datahora')))]); echo '<tr class="dettab">' . $linha . '</tr>' . "\n"; } $db->Close(); ?> </fieldset> </table> </td></tr>
$username = ""; $linkexc = ""; $db = new BD(); $db2 = new BD(); $sql = sprintf("select m.codigo,u.userid,email,mensagem,m.userid useridrec from\n\t\t\t\t\t\t\t\tcad_mural m,\n\t\t\t\t\t\t\t\tcad_usuario u\n\t\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\t\tu.recmail = 'S'\n\t\t\t\t\t\t\t\tand u.aprovado = 'S'\n\t\t\t\t\t\t\t\tand (m.codigo,u.userid)\n\t\t\t\t\t\t\t\tnot in\n\t\t\t\t\t\t\t\t(select codigo,userid from log_mural)\n\t\t\t\t\t\t\t\tlimit 45"); $db->Query($sql); while ($db->Next()) { $codigo = $db->getValue('codigo'); $user = $db->getValue('userid'); $userrec = $db->getValue('useridrec'); $email = $db->getValue('email'); $msg = $db->getValue('mensagem'); $sql = sprintf("select username from cad_usuario where userid = %d", $userrec); $db2->Query($sql); $db2->Next(); $username = $db2->getValue('username'); $msg .= "<br><br><br>" . "Mensagem enviada por: <b>" . $username; $msg .= "<br>" . "Opala Clube Franca."; $msg .= "<br><br><br>" . "Se não deseja receber as mensagens por e-mail clique no link abaixo."; $linkexc = sprintf("<a href=http://" . $_SERVER['HTTP_HOST'] . "/prc_excmail.php?usr="******"&id=" . md5(trim(trim($username) . 'lstmailexc' . trim($email))) . ">Clique aquí p/ não receber mais os recados por e-mail</a>"); $msg .= "<br>" . $linkexc; $ln = sprintf("Codigo:%d - User:%d - Username:%s - Email:%s<br>", $codigo, $user, $username, $email); // echo ($ln)."\n"; $st = envmail($email, "Recado Opala Clube Franca", $msg, "*****@*****.**"); $sql = sprintf("insert into log_mural (codigo,userid,dataenvio,status)\n\t\t\t\t\t\tvalues (%d,%d,now(),'%s')", $codigo, $user, $st); $db2->Exec($sql); } $db->Close(); $db2->Close(); foreach (glob("/home/opalaclu/prc_envrecado.php.*") as $filename) { unlink($filename);
<?php require_once $_SERVER['DOCUMENT_ROOT'] . "/sessao.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.bd.php"; include $_SERVER['DOCUMENT_ROOT'] . "/geoipcity.inc"; $gi = geoip_open($_SERVER['DOCUMENT_ROOT'] . "/geoip/GeoLiteCity.dat", GEOIP_STANDARD); $db = new BD(); $db2 = new BD(); $sql = sprintf("select sequencia,ip,datahora,cidade from log_usuario where cidade is null\nand datahora >= '2008-01-01 00:00' and ip is not null order by sequencia"); $db->Query($sql); // $db->Next(); while ($db->Next()) { echo $db->getValue("sequencia") . " " . $db->getValue("ip") . " " . $db->getValue("cidade"); $geoip = geoip_record_by_addr($gi, $db->getValue("ip")); $sql = sprintf("update log_usuario\n\t\t\t \t\t\t\tset cidade='%s',\n\t\t\t\t\t\t\t\testado='%s',\n\t\t\t\t\t\t\t\tpais='%s'\n\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\tsequencia=%d", $geoip->city, RetornaEstado($geoip->country_code, $geoip->region), $geoip->country_name, $db->getValue("sequencia")); $db2->Exec($sql); } $db->Close(); $db2->Close(); geoip_close($gi); function RetornaEstado($pais, $regiao) { require_once $_SERVER['DOCUMENT_ROOT'] . "/geoipregionvars.php"; return $GEOIP_REGION_NAME[$pais][$regiao]; }