|
Server IP : 10.128.40.6 / Your IP : 216.73.216.233 Web Server : Apache System : Linux webd006.cluster128.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : logmcpe ( 111175) PHP Version : 7.3.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/logmcpe/www/TMCPRO/pages/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
// exit() ;
// $a =dbi_query(" SELECT * FROM `PRESTATIONS` WHERE `presta_date_fin` <= 20240926 ORDER BY `PRESTATIONS`.`presta_date_fin` DESC ") ;
// while($prest = dbi_fetch_row($a)){
// echo $prest['presta_id']."===>".$prest['presta_date_fin']."<br/>" ;
// $q =dbi_query(" SELECT * FROM `PRESTATIONS_MODIF` WHERE `presta_id` = ".$prest['presta_id']) ;
// while($modif = dbi_fetch_row($q)){
// echo "----------------".$modif['presta_id']."===>".$modif['date']."<br/>" ;
// dbi_query(" DELETE FROM PRESTATIONS_MODIF WHERE `PRESTATIONS_MODIF`.`presta_id` = ".$prest['presta_id']) ;
// }
// dbi_query(" DELETE FROM PRESTATIONS WHERE `PRESTATIONS`.`presta_id` = ".$prest['presta_id']);
// $q_ex = dbi_query("SELECT * FROM `EXCEPTIONS` WHERE `presta_id` = ".$prest['presta_id']) ;
// while($exp = dbi_fetch_row($q_ex)){
// echo "--------exp--------".$exp['presta_id']."===>".$exp['date_presta']."<br/>" ;
// }
// dbi_query("INSERT INTO `presta_id_table` (`id_t`, `presta_id`) VALUES (NULL, '".$prest['presta_id']."')") ;
// }
// $lay =dbi_query("SELECT DISTINCT(presta_id) FROM `presta_id_table`") ;
// while($yaz=dbi_fetch_row($lay)){
// echo "==>".$yaz['presta_id']."<br/>" ;
// list($nbr) = dbi_fetch_row( dbi_query(" SELECT count(*) as nbr FROM `PRESTATIONS_MODIF` WHERE `presta_id` = ".$yaz['presta_id'])) ;
// echo "==============>".$nbr."<br/>";
// if($nbr>=1){
// dbi_query("DELETE FROM PRESTATIONS_MODIF WHERE `PRESTATIONS_MODIF`.`presta_id` = ".$yaz['presta_id']) ;
// }
// }
// $q = dbi_query("SELECT * FROM `EXCEPTIONS` WHERE `date_presta` <= 20230701 ORDER BY `EXCEPTIONS`.`date_presta` DESC") ;
// while($modif = dbi_fetch_row($q)){
// if($modif['new_presta_id'] >= 1){
// list($nbr) = dbi_fetch_row( dbi_query(" SELECT count(*) as nbr FROM `PRESTATIONS` WHERE `presta_id` = ".$modif['new_presta_id'])) ;
// }
// echo $modif['new_presta_id']."=======>".$nbr."<br/>" ;
// }
phpinfo();
?>