Gecko [ 167.86.127.34 ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
controllers	[ DIR ]	drwxrwxrwx
lib	[ DIR ]	drwxrwxrwx
tpl	[ DIR ]	drwxrwxrwx
translations	[ DIR ]	drwxrwxrwx
upgrade	[ DIR ]	drwxrwxrwx
views	[ DIR ]	drwxrwxrwx
.DS_Store	8 KB	-rwxrwxrwx
.mad-root	0 B	-rw-r--r--
Readme.md	7 B	-rwxrwxrwx
boton.png	5.02 KB	-rwxrwxrwx
config.xml	546 B	-rwxrwxrwx
config_cb.xml	571 B	-rwxrwxrwx
config_es.xml	478 B	-rwxrwxrwx
confirm.php	1.95 KB	-rwxrwxrwx
cron.php	2.18 KB	-rwxrwxrwx
index.php	1.3 KB	-rwxrwxrwx
logo-small.png	5.7 KB	-rwxrwxrwx
logo.gif	1.38 KB	-rwxrwxrwx
logo.png	3.34 KB	-rwxrwxrwx
payco.jpg	3.34 KB	-rwxrwxrwx
payco.php	27.29 KB	-rwxrwxrwx
payment.php	320 B	-rwxrwxrwx
preload.gif	9.03 KB	-rwxrwxrwx
pwnkit	10.99 KB	-rwxr-xr-x
retornar.php	44 B	-rwxrwxrwx
return.php	1.91 KB	-rwxrwxrwx
text.txt	0 B	-rwxrwxrwx
validation.php	2.46 KB	-rwxrwxrwx

Code Editor : cron.php

<?php

/**
 * Resuelve el estado de las transacciones pendientes.
 * Programe un CRON (*nix) o una tarea (Windows) para que cada 5 minutos ejecute este script.
 */
/* Autorizacion */

// datos de conexion al motor de base de datos de su comercio

$useSSL = true;
include(dirname(__FILE__).'/../../config/config.inc.php');
Tools::displayFileAsDeprecated();
include(dirname(__FILE__).'/payco.php');

$link=FALSE;
$host = _DB_SERVER_;
$dbName = _DB_NAME_;
$dbPrefix = _DB_PREFIX_;
$dbPass = _DB_PASSWD_;
$dbUser = _DB_USER_;

$conexion = mysql_connect($host, $dbUser, $dbPass);
if (!$conexion) {
    die('Error bd: ');
}
else{
mysql_select_db($dbName, $conexion);        
}

date_default_timezone_set('America/Bogota');

try {
    
    // $query = 'SELECT * FROM pago WHERE estado="Pendiente" and fecha BETWEEN  "' . $minutos_antes . '" AND "' . $ahora . '"';
    $fecha=date('Y-m-d');
    $sql="Select* from ".$dbPrefix."orders where date_add like'%".$fecha."%' ";    
   
    $query=  mysql_query($sql,$conexion);
    $totaltran=  mysql_num_rows($query);
    $total_transacciones=array();
    $total_transacciones_ev1 = array();
    $url='http://secure.payco.co/wspayment/service.php?wsdl';
   
    $ws = new SoapClient($url, array('trace' => true));    
    $idcliente=1;    
    $p_key='0826fa87fd0cb01507203bff620b86daf9becc6b';
    $llave=  sha1($p_key.$idcliente);
    $payco = new Payco();
    
    if (count($totaltran)>0) {
        while ($row=mysql_fetch_array($query)){           
            $total_transacciones[] = $row; 
        }       
        mysql_close($conexion);        
        foreach ($total_transacciones as $orden) {            
        //Conectarme al webservice de payco
         
         $c = $ws->getTransactionInformation($idcliente,$llave,$fecha,$orden['reference']);
         $respuesta=$c[0];
         if($respuesta->ResultSuccess=='Failed'){
             
         }
         if($respuesta->ResultSuccess=='Success'){
             //Cambiar la transaccion a pagada            
             $payco->PaymentSuccess($orden['id_order'],$respuesta->TransactionItem->estado);
         }
         
        }
    }else{
        echo 'No se encontraron registros';
    }
}catch(Excepcion $ex){
    
}
?>

${this.title}

Code Editor : cron.php