Viewing file:  procesarPC1.php (3.16 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
date_default_timezone_set('Europe/Madrid');
$Dorsal= $_POST['name'];
$Tipo= $_POST['tipo'];
include('class.MySqliDB.php');
include('globals.php');
$ConnectionArray= array('Server'=>Server,
'Usser'=>User,
'Pass'=>Pass,
'Db'=>Db);
$ConnMysql= new MysqliDB($ConnectionArray);
date_default_timezone_set('Europe/Madrid');
$fp = fopen('logs/marcasCronoPC1.log', 'a');
if($Tipo == 'I')
{
if((int)$Dorsal < 500)
{
$Sql= '';
$Sql= "SELECT `Dorsal`,`IdLlave`,`Carrera` FROM `".Db."`.`gestionrfid` WHERE `Dorsal`= '".$Dorsal."'";
$ConnMysql->EnviarQuery($Sql);
$ConnMysql->ResultadoObjetoU();
//echo "<pre>";print_r($ConnMysql);die();
if($ConnMysql->MySqliResult->num_rows != 0)
{
$Sql= sprintf("INSERT INTO `".Db."`.`cronometrajepc1` (`DORSAL`,`RFID`,`CRONO`,`CARRERA`) VALUES ('%s','%s',NOW(),'%s');",
$ConnMysql->ArrayResultado->Dorsal,$ConnMysql->ArrayResultado->IdLlave,$ConnMysql->ArrayResultado->Carrera);
$ConnMysql->EnviarInsert($Sql);
if($ConnMysql->ConnMysqli->affected_rows > 0)
{
echo $Dorsal;
unset($String);$String= 'RFID: '.$ConnMysql->ArrayResultado->IdLlave.' DORSAL: '.$Dorsal.' - I OK - '.date('Y-m-d H:i:s').chr(10);
fwrite($fp,$String);
}
else
{
echo 0;
unset($String);$String= 'DORSAL: '.$Dorsal.' - I NOK - '.date('Y-m-d H:i:s').chr(10);
fwrite($fp,$String);
}
}
//echo "<pre>";print_r($ConnMysql);
/*
*/
}
else
{
$Sql= '';
$Sql= "INSERT INTO `".Db."`.`cronometrajepc1` (`RFID`, `CRONO`) VALUES (".(string)$Dorsal.", NOW())";
$ConnMysql->EnviarInsert($Sql);
//echo "<pre>";print_r($ConnMysql);
if($ConnMysql->ConnMysqli->affected_rows > 0)
{
$Sql= '';
$Sql= "SELECT `Dorsal` FROM `".Db."`.`gestionrfid` WHERE `IdLlave`= '".$Dorsal."'";
$ConnMysql->EnviarQuery($Sql);
$ConnMysql->ResultadoObjetoU();
echo $ConnMysql->ArrayResultado->Dorsal;
unset($String);$String= 'RFID: '.$Dorsal.' *** DORSAL: '.$ConnMysql->ArrayResultado->Dorsal.' - I OK - '.date('Y-m-d H:i:s').chr(10);
fwrite($fp,$String);
}
else
{
echo 0;
unset($String);$String= 'RFID: '.$Dorsal.' - I NOK - '.date('Y-m-d H:i:s').chr(10);
fwrite($fp,$String);
}
}
}
if($Tipo == 'D')
{
$Sql= "DELETE FROM `".Db."`.`cronometrajepc1` WHERE `DORSAL`='".$Dorsal."'";
$ConnMysql->EnviarInsert($Sql);
//echo "<pre>";print_r($ConnMysql);
if($ConnMysql->ConnMysqli->affected_rows > 0)
{
echo $Dorsal;
unset($String);$String= 'DORSAL: '.$Dorsal.' - D OK - '.date('Y-m-d H:i:s').chr(10);
fwrite($fp,$String);
}
else
{
echo 0;
unset($String);$String= 'DORSAL: '.$Dorsal.' - D NOK - '.date('Y-m-d H:i:s').chr(10);
fwrite($fp,$String);
}
}
fclose($fp);
/*$con = mysql_connect('localhost','root','t0rr3c3rr3d0') or die('Error en conexion a la DB');
mysql_select_db('carrerarobles2015 ', $con) or die('Error al seleccionar la DB');
//$Crono = $_POST['pwd'];
$res = mysql_query("INSERT INTO `carrerarobles2015 `.`cronometraje` (`DORSAL`, `CRONO`) VALUES (".$Dorsal.", NOW())");
if(mysql_affected_rows()>0){
echo $Dorsal;
}
else{
echo 0;
}*/
?>
|