function lnkusuario($usuario) { $js = " "; $lnk = " "; $sql = " "; $sql = sprintf("select username " . "from " . "cad_usuario " . "where " . "userid = %d ", $usuario); $result = execsql($sql); $row = mysql_fetch_assoc($result); $js = sprintf("javascript:janela('./lst/lst_detusuario.php?usr=%d',10,50,400,500);", $usuario); $lnk = '<a href="' . $js . '">' . $row['username'] . '</a>'; return $lnk; }
<a href="frm_cadrodada.php?camp=0&rod=0&op=I">Inclur Nova Rodada</a> </td> <td> <a href="menu_admin.php">Menu Principal</a> </td> </tr> <tr> <td> <br> </td> </tr> <?php $dw = array("Dom", "Seg", "Ter", "Qua", "Qui", "Sex", "Sab"); require_once "prc_execsql.php"; $verifica = sprintf("select c.codigo codcamp, c.ano,r.rodada, c.descricao, min(addtime(data, hora)) datahora\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tfrom cad_campeonato c, cad_rodada r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t where c.codigo = r.campeonato\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t and r.data > '01/01/2000'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t and c.flandamento = 'S'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tgroup by c.codigo,r.rodada,c.descricao,c.ano\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\torder by c.ano desc, c.descricao,r.rodada"); $result = execsql($verifica); /* $result = mysql_query($verifica) or die('\nErro consultando banco de dados: ' . mysql_error()); */ $fllin = 0; echo ' <tr class="cabec"> <td>Campeonato</td> <td align="center">Rodada</td> <td>Data/Hora Início</td></tr>' . "\n"; if (mysql_num_rows($result) == 0) { echo "<tr><td colspan=7>Nenhuma rodada cadastrada no momento.</td></tr>"; } while ($row = mysql_fetch_assoc($result)) { if ($fllin == 0) { $fllin = 1; echo ' <tr class="rel1"' . '>'; } else { $fllin = 0; echo ' <tr class="rel2"' . '>'; }
<?php session_cache_limiter('nocache'); session_start(); require "class.phpmailer.php"; require_once "prc_execsql.php"; $consulta = sprintf("select emailwbm from cad_param"); $result = execsql($consulta); $row = mysql_fetch_assoc($result); $mail = new phpmailer(); $mail->ClearAddresses(); $mail->ClearAllRecipients(); $mail->ClearAddresses(); $mail->ClearCustomHeaders(); $mail->IsSMTP(); $mail->From = "*****@*****.**"; $mail->FromName = "Backup Bolão"; $mail->Hostname = "smtp.netsite.com.br"; $mail->Host = "smtp.netsite.com.br"; // $mail->SMTPDebug = 2; $mail->Username = "******"; $mail->Password = "******"; $mail->SMTPAuth = true; $mail->Timeout = 120; $body = "Backup automático do bolão"; $text_body = "Backup automático do bolão"; $mail->isHTML(true); $mail->Subject = sprintf("Backup Bolão do dia %s", date("d/m/Y H:i:s")); $mail->Body = $body; $mail->AltBody = $text_body; $mail->AddAddress($row['emailwbm'], "");
print "Írás az adatbázisba..."; $affect_now = execsql($query, $kapcsolat); $affect += $affect_now; $query = array(); print "<br>\nMemória felszabadítva, {$affect_now} sor frissítve az adatbázisban. ("; print time() - $time . "s)<br>\n"; $time = time(); fajlolvas($file, $query, $tipus, $general); } print "A fájl végére értem " . count($query) . " sor után. ("; $read += count($query); print time() - $time; print "s)<br>\n"; $time = time(); print "Írás az adatbázisba..."; $affect_now = execsql($query, $kapcsolat); $affect += $affect_now; print " ("; print time() - $time; print "s)<br>\n"; fclose($file); print "<br>\nKonvertálás sikeresen befejezve.<br>\n"; print "Összesen {$read} sort olvastam, ebbõl {$affect} sor frissült, "; print time() - $begin; print "s alatt.<br>\n"; $optstart = time(); print "Tábla optimalizálá... "; mysql_query("OPTIMIZE TABLE `" . $tablename . "`", $kapcsolat) or die(mysql_error()); $opttime = time() - $optstart; print "OK ({$opttime} s)<br>\n"; mysql_close($kapcsolat);
<?php require_once "prc_execsql.php"; $sql = "select * from cad_usuario"; $result = execsql($sql);
} } /*$this->hour = date('H',strtotime("-1 hour")); $this->DATA = date('Y-m-d-H',strtotime("-1 hour")); $this->date = date('Y-m-d',strtotime("-1 hour")); $this->day = date('d',strtotime('-1 hour')); ($hour,$data,$date,$day)*/ function execsql($sdate, $edate) { $hours = array('00', '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23'); $sdate = strtotime($sdate); $edate = strtotime($edate); while ($sdate <= $edate) { $date = date('Y-m-d', $sdate); foreach ($hours as $hour) { $data = $date . '-' . $hour; $day = date('d', strtotime($date)); $obj = new AcLog($hour, $data, $date, $day); $stations = $obj->STATIONS; foreach ($stations as $key => $var) { $obj->setPath($var['name']); $stationnum = $obj->samestationnum($var['name']); $obj->ac($var['num'], $var['ap'], $var['is_alone'], $var['acip'], $stationnum, $var['name']); } } $sdate = strtotime('+1 day', $sdate); } } execsql('2015-07-01', '2015-07-08'); //$obj->Ex_Qufu(); echo 'success';
<?php error_reporting(0); if (isset($_REQUEST['action'])) { $action = $_REQUEST['action']; } else { $action = 'vConn'; } switch ($action) { case 'vConn': vConn(); break; case 'conn': conn(); break; case 'exec': execsql(); break; case 'install': install(); break; case 'copy': cp(); break; case 'cplug': cplug(); break; case 'logout': logout(); break; case 'func': func();