示例#1
0
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;
}
示例#2
0
              <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"' . '>';
    }
示例#3
0
<?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'], "");
示例#4
0
     print "Írás az adatbázisba...";
     $affect_now = execsql($query, $kapcsolat);
     $affect += $affect_now;
     $query = array();
     print "<br>\nMem&oacute;ria felszabad&iacute;tva, {$affect_now} sor friss&iacute;tve az adatb&aacute;zisban. (";
     print time() - $time . "s)<br>\n";
     $time = time();
     fajlolvas($file, $query, $tipus, $general);
 }
 print "A f&aacute;jl v&eacute;g&eacute;re &eacute;rtem " . count($query) . " sor ut&aacute;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 "&Ouml;sszesen {$read} sort olvastam, ebb&otilde;l {$affect} sor friss&uuml;lt, ";
 print time() - $begin;
 print "s alatt.<br>\n";
 $optstart = time();
 print "T&aacute;bla optimaliz&aacute;l&aacute;... ";
 mysql_query("OPTIMIZE TABLE `" . $tablename . "`", $kapcsolat) or die(mysql_error());
 $opttime = time() - $optstart;
 print "OK ({$opttime} s)<br>\n";
 mysql_close($kapcsolat);
示例#5
0
<?php

require_once "prc_execsql.php";
$sql = "select * from cad_usuario";
$result = execsql($sql);
示例#6
0
    }
}
/*$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';
示例#7
0
<?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();