Le script a débuté sur jeu. 30 juin 2022 07:56:44 CEST ]0;www-lp@vps575036: ~/scriptwww-lp@vps575036:~/script$ ./icirelais.sh PHP Notice: Undefined index: SERVER_NAME in /home/www-lp/www/admin/includes/configure.php on line 15 PHP Notice: Undefined index: SERVER_NAME in /home/www-lp/www/admin/includes/configure.php on line 22 PHP Notice: Undefined index: language in /home/www-lp/www/admin/call_icirelais_file_synchronize.php on line 23 PHP Warning: include_once(includes/languages/french/icirelais_file_synchronize.php): failed to open stream: No such file or directory in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 50 PHP Warning: include_once(): Failed opening 'includes/languages/french/icirelais_file_synchronize.php' for inclusion (include_path='.:/opt/php5.3/php5.3.29/lib/php') in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 50 PHP Notice: Use of undefined constant DOWNLOAD_OK - assumed 'DOWNLOAD_OK' in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 144 PHP Notice: Use of undefined constant UNCOMPRESS_OK - assumed 'UNCOMPRESS_OK' in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 189 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

INSERT INTO icirelais (file_id, relay_id, insee, owner_name, adresse_1, adresse_2, adresse_3, postal_code, city, shop_name, coord_lat, coord_long, pda_equipment, start_validity_date, end_validity_date, last_shippment_date, new_shippment_date, text, monday_opening_hours, tuesday_opening_hours, wednesday_opening_hours, thursday_opening_hours, friday_opening_hours, saturday_opening_hours, sunday_opening_hours, closing_period_start_date_1, closing_period_end_date_1, closing_period_start_date_2, closing_period_end_date_2, closing_period_start_date_3, closing_period_end_date_3, required_time) VALUES

[TEP STOP]

]0;www-lp@vps575036: ~/scriptwww-lp@vps575036:~/script$ ls incl^C ]0;www-lp@vps575036: ~/scriptwww-lp@vps575036:~/script$ ^C ]0;www-lp@vps575036: ~/scriptwww-lp@vps575036:~/script$ cat icirelais.sh #!/bin/bash source $HOME/.bashrc cd $HOME ; php www/admin/call_icirelais_file_synchronize.php /bin/rm -f /tmp/ICIRELAIS* ]0;www-lp@vps575036: ~/scriptwww-lp@vps575036:~/script$ pwd /home/www-lp/script ]0;www-lp@vps575036: ~/scriptwww-lp@vps575036:~/script$ cd ]0;www-lp@vps575036: ~www-lp@vps575036:~$ php www/admin/call_icirelais_file_synchronize.php PHP Notice: Undefined index: SERVER_NAME in /home/www-lp/www/admin/includes/configure.php on line 15 PHP Notice: Undefined index: SERVER_NAME in /home/www-lp/www/admin/includes/configure.php on line 22 PHP Notice: Undefined index: language in /home/www-lp/www/admin/call_icirelais_file_synchronize.php on line 23 PHP Warning: include_once(includes/languages/french/icirelais_file_synchronize.php): failed to open stream: No such file or directory in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 50 PHP Warning: include_once(): Failed opening 'includes/languages/french/icirelais_file_synchronize.php' for inclusion (include_path='.:/opt/php5.3/php5.3.29/lib/php') in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 50 PHP Notice: Use of undefined constant DOWNLOAD_OK - assumed 'DOWNLOAD_OK' in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 144 PHP Notice: Use of undefined constant UNCOMPRESS_OK - assumed 'UNCOMPRESS_OK' in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 189 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

INSERT INTO icirelais (file_id, relay_id, insee, owner_name, adresse_1, adresse_2, adresse_3, postal_code, city, shop_name, coord_lat, coord_long, pda_equipment, start_validity_date, end_validity_date, last_shippment_date, new_shippment_date, text, monday_opening_hours, tuesday_opening_hours, wednesday_opening_hours, thursday_opening_hours, friday_opening_hours, saturday_opening_hours, sunday_opening_hours, closing_period_start_date_1, closing_period_end_date_1, closing_period_start_date_2, closing_period_end_date_2, closing_period_start_date_3, closing_period_end_date_3, required_time) VALUES

[TEP STOP]

]0;www-lp@vps575036: ~www-lp@vps575036:~$ ]0;www-lp@vps575036: ~www-lp@vps575036:~$ ]0;www-lp@vps575036: ~www-lp@vps575036:~$ ]0;www-lp@vps575036: ~www-lp@vps575036:~$ vi ^C ]0;www-lp@vps575036: ~www-lp@vps575036:~$ find -na. -name icirelais_file_synchronize.php ./www/exapaq/catalog/admin/includes/languages/french/icirelais_file_synchronize.php ./www/exapaq/catalog/admin/includes/languages/english/icirelais_file_synchronize.php ./www/admin/includes/languages/french/icirelais_file_synchronize.php ./www/admin/includes/languages/english/icirelais_file_synchronize.php ]0;www-lp@vps575036: ~www-lp@vps575036:~$ vi /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php [?1000h[?1049h[?1h=▽ ]11;?[?12;25h[?12l[?25h[?25l"~/www/admin/includes/classes/icirelais_file_synchronize_V2.php" 345L, 10521C[>c}//=========================================================================================================================/** * @param string $value * @return string */function _valueFilter($value) {if($value == '-') {$value = null;}return $value;}//=========================================================================================================================function _icirelais_fields () {return array( 'file_id','relay_id','insee','owner_name','adresse_1','adresse_2','adresse_3','postal_code','city','shop_name','coord_lat','coord_long','pda_equipment','start_validity_date','end_validity_date','last_shippment_date','new_shippment_date','text','monday_opening_hours','tuesday_opening_hours','wednesday_opening_hours','thursday_opening_hours','friday_opening_hours','saturday_opening_hours','sunday_opening_hours','closing_period_start_date_1','closing_period_end_date_1','closing_period_start_date_2','closing_period_end_date_2','closing_period_start_date_3','closing_period_end_date_3',305,18-60 94% "~/www/admin/includes/classes/icirelais_file_synchronize_V2.php" 345L, 10521C [?1000l[?1002h[?12l[?25h[?25l::[?12l[?25h1[?25l[?12l[?25h8[?25l[?12l[?25h9[?25l[?12l[?25h [?25l// Open the local file$file = $this->_download_dir.DIRECTORY_SEPARATOR.$input['local_file'];if(!($handle2 = @fopen($file, 'w+'))) {return array('result' => false, 'msg' => FOPEN_FAILED.$file);}if($this->_tmpFile === null) {return array('result' => false, 'msg' => FILE_DOESNOT_EXIST.$this->_tmpFile);}// Open the compresses fileif(!$zp = @gzopen($this->_tmpFile, 'r')){return array('result' => false, 'msg' => GZOPEN_FAILED.$this->_tmpFile);}// read the compress temporary file and write it in an uncompressed oneif(!@fwrite($handle2, gzread($zp, 9999999))) {return array('result' => false, 'msg' => FWRITE_FAILED.$input['local_file']);}@fclose($handle2);@gzclose($zp);return array('result' => true, 'msg' => UNCOMPRESS_OK.$input['remote_file']);}//=========================================================================================================================/** * Get ICI Relais files content, truncate table and insert new datas * * @return array * - 'result' boolean * - 'msg' varchar */function get_content_and_save ($input) {$local_file = $this->_download_dir.DIRECTORY_SEPARATOR.$input['local_file'];// check if it is a fileif(!is_file($local_file)) {return array('result' => false, 'msg' => NOT_A_FILE.$local_file);}// check if the file is emptyif(filesize($local_file) == 0) {return array('result' => false, 'msg' => FILE_EMPTY.$local_file);189,3-17 55%[?12l[?25h[?25lk 8,2-16[?12l[?25h[?25lk 7,3-17[?12l[?25h[?25lk 6[?12l[?25h[?25lk 5,2-16[?12l[?25h[?25lk {}4,3-17[?12l[?25h[?25lk {}3,3-24[?12l[?25h[?25lk 2,3-17[?12l[?25h[?25lk 1[?12l[?25h[?25lk 0,0-1 [?12l[?25h[?25lk {}79,3-17[?12l[?25h[?25lk {}8,3-24[?12l[?25h[?25lk 7,3-17[?12l[?25h[?25lk 6[?12l[?25h[?25lk 5,2-16[?12l[?25h[?25lk {}4,3-17[?12l[?25h[?25lk {}3,3-24[?12l[?25h[?25lk 2,3-17[?12l[?25h[?25lk 1,2-16[?12l[?25h[?25lk {}0,3-17[?12l[?25h[?25lk }{}169,3-24 55%[?12l[?25h[?25lk @chmod($this->_download_dir, 0777);168,3-17 54%[?12l[?25h[?25lk } else {167,3-17 54%[?12l[?25h[?25lk @mkdir($this->_download_dir, 0777, true);166,3-17 54%[?12l[?25h[?25lk if(!is_dir($this->_download_dir)) {165,2-16 53%[?12l[?25h[?25lk // If the download directory doesn't exist, create it{}164,3-17 53%[?12l[?25h[?25lk {}163,3-24 53%[?12l[?25h[?25lk function uncompress($input) {{}162,3-17 52%[?12l[?25h[?25lk {}161,3-24 52%[?12l[?25h[?25lk  */160,3-17 52%[?12l[?25h[?25lk  * - 'msg' varchar159,3-17 51%[?12l[?25h[?25lk  * - 'result' boolean158,2-16 51%[?12l[?25h[?25lk  * @return array157,10-17 51%[?12l[?25h[?25lk  *156,1-850%[?12l[?25h[?25lk  * Uncompress ICI Relais files in temporary files155,5-12 50%[?12l[?25h[?25lk /**154,6-24 50%[?12l[?25h[?25lk 153,6-24 49%[?12l[?25h[?25lk //=========================================================================================================================152,10-17 49%[?12l[?25h[?25lk 151,4-11 49%[?12l[?25h[?25lk }150,10-17 48%[?12l[?25h[?25lk return array('result' => true, 'msg' => DOWNLOAD_OK.$input['remote_file']);149,4-11 48%[?12l[?25h[?25lk 148,1-848%[?12l[?25h[?25lk @ftp_close($conn);147,10-17 47%[?12l[?25h[?25lk @fclose($handle);146,1-847%[?12l[?25h[?25lk 145,2-947%[?12l[?25h[?25lk }144,3-17 46%[?12l[?25h[?25lk return array('result' => false, 'msg' => FTP_GET_FAILED.$input['remote_file']);143,2-16 46%[?12l[?25h[?25lk if(!@ftp_fget($conn, $handle, $input['remote_file'], FTP_BINARY, 0)) {142,3-17 46%[?12l[?25h[?25lk // Get the compressed file in the temporary file141,3-17 45%[?12l[?25h[?25lk 140,2-16 45%[?12l[?25h[?25lk }{}139,3-17 45%[?12l[?25h[?25lk return array('result' => false, 'msg' => FOPEN_FAILED.$this->_tmpFile);{}138,3-24 44%[?12l[?25h[?25lk if(!($handle = @fopen($this->_tmpFile, 'w+'))) {137,3-17 44%[?12l[?25h[?25lk $this->_tmpFile = tempnam('/tmp', 'ICIRELAIS');136,3-17 44%[?12l[?25h[?25lk // Create a temporary file for the compressed file135,2-16 43%[?12l[?25h[?25lk {}134,3-17 43%[?12l[?25h[?25lk }{}133,3-24 43%[?12l[?25h[?25l::[?12l[?25hq[?25l[?12l[?25h [?25l[?1002l[?1l>[?12l[?25h[?1049l]0;www-lp@vps575036: ~www-lp@vps575036:~$ vi ^C ]0;www-lp@vps575036: ~www-lp@vps575036:~$ find . (-name -name '*.hp'php' -exec grep 'INTO icirelais (file_id, relay_id' {} \; -print ]0;www-lp@vps575036: ~www-lp@vps575036:~$ find . -name '*.php' -exec grep 'INTO icirelais (file_id, relay_id' {} \; -print ]0;www-lp@vps575036: ~www-lp@vps575036:~$ find . -name '*.php' -exec grep '(file_id, relay_id' {} \; -print[15@INTO icirelais  ]0;www-lp@vps575036: ~www-lp@vps575036:~$ find . -name '*.php' -exec grep 'INTO icirelais' {} \; -print // -> 0000003: icirelais/exapaq require_once(DIR_WS_FUNCTIONS . 'icirelais_function.php'); ./old/www/includes/application_top.php // -> 0000003: icirelais/exapaq // -> 0000003: icirelais/exapaq if($tab_shipping[0] == 'icirelais') { $check_address_query = tep_db_query("select count(*) as total from icirelais where relay_id = '" . $tab_shipping[1] . "' "); //$sendto = $HTTP_POST_VARS['shipping']; if we rewrite sentdo, icirelais_get_point will find the wrong address // -> 0000003: icirelais/exapaq if($tab_shipping[0] == 'icirelais') { $icirelais_id = null; $icirelais_id = $key; 'title' => (($free_shipping == true) ? $quote[0]['methods'][$icirelais_id]['title'] : (isset($quote[0]['methods'][$icirelais_id]['text']) ? $quote[0]['methods'][$icirelais_id]['text'] : $quote[0]['module'] . ' (' . $quote[0]['methods'][$icirelais_id]['title'] . ')')), 0000003: icirelais/exapaq ?> - 1/ on conserve ce code déclarant Prototype, (styles CSS, script JS et plugin Window JS), mais on le commente, on ne commente pas icirelais.css ou icirelais.js ni maps.google.com - ce faux-bouton-texte est censé afficher une MODALE via la fonction openDialog() déclarée dans: /includes/icirelais.js -1- /exapaq/catalog/includes/classes/icirelais_get_point_PHP5.php -2- /includes/classes/icirelais_get_point_PHP5.php -3- /exapaq/catalog/includes/classes/icirelais_get_point.php -4- /includes/classes/icirelais_get_point.php donc commenter ce code me paraît plus qu'important, à l'exception du /includes/icirelais.js - intercepter et réécrire (tout en masquant) l'ancien système d'affichage de détail du point-relais icirelais - 24/ on a besoin de traiter différemment l'affichage des moyens d'expéditions, certains comme icirelais ou devisChronopost sont alors traités différemment, voir les étapes respectives pour tout ça 0000003: icirelais/exapaq ?> // -> 0000003: icirelais/exapaq if($quotes[$i]['id'] == 'icirelais') { 0000003: icirelais/exapaq ?> // -> 0000003: icirelais/exapaq if($quotes[$i]['id'] == 'icirelais') { case 'icirelais': ./www/checkout_shipping.php if($tab_shipping[0] == 'icirelais') { $check_address_query = tep_db_query("select count(*) as total from icirelais where relay_id = '" . $tab_shipping[1] . "' "); //$sendto = $HTTP_POST_VARS['shipping']; if we rewrite sentdo, icirelais_get_point will find the wrong address if($tab_shipping[0] == 'icirelais') { $icirelais_id = null; $icirelais_id = $key; 'title' => (($free_shipping == true) ? $quote[0]['methods'][$icirelais_id]['title'] : (isset($quote[0]['methods'][$icirelais_id]['text']) ? $quote[0]['methods'][$icirelais_id]['text'] : $quote[0]['module'] . ' (' . $quote[0]['methods'][$icirelais_id]['title'] . ')')), if($quotes[$i]['id'] == 'icirelais') { if($quotes[$i]['id'] == 'icirelais') { ./www/exapaq/catalog/checkout_shipping.php ' ' . (empty($statuses['comments']) ? ' ' : /*icirelais_function optionnal */ display_htmllink_if_web_address(nl2br(tep_output_string_protected($statuses['comments'])))) . '' . "\n" . ./www/exapaq/catalog/account_history_info.php class icirelais { function icirelais() { $this->code = 'icirelais'; require_once(DIR_WS_CLASSES.'icirelais_get_point.php'); $icirelais_get_point = new icirelais_get_point(array( $this->quotes = $icirelais_get_point->get_point(); if (file_exists(DIR_FS_CATALOG_LANGUAGES . $language . '/modules/shipping/icirelais.php')) { require_once(DIR_FS_CATALOG_LANGUAGES . $language . '/modules/shipping/icirelais.php'); require_once(DIR_FS_CATALOG_LANGUAGES . '/english/modules/shipping/icirelais.php'); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('', 'MODULE_SHIPPING_ICIRELAIS_SYNC', '
', '', '6', '14', 'disappear(', now())"); ./www/exapaq/catalog/includes/modules/shipping/icirelais.php require_once(DIR_WS_FUNCTIONS . 'icirelais_function.php'); ./www/exapaq/catalog/includes/application_top.php from icirelais ./www/exapaq/catalog/includes/functions/icirelais_function.php * @package icirelais_shipping_mode class icirelais_get_point { function icirelais_get_point($input){ require_once('includes/languages/'.$input['language'].'/modules/shipping/icirelais.php'); FROM icirelais ./www/exapaq/catalog/includes/classes/icirelais_get_point_PHP5.php if($tab[0] == 'icirelais') { from icirelais ab ./www/exapaq/catalog/includes/classes/order.php * @package icirelais_shipping_mode class icirelais_get_point { function icirelais_get_point($input){ require_once('includes/languages/'.$input['language'].'/modules/shipping/icirelais.php'); FROM icirelais ./www/exapaq/catalog/includes/classes/icirelais_get_point.php require_once(DIR_WS_FUNCTIONS . 'icirelais_function.php'); ./www/exapaq/catalog/admin/includes/application_top.php * Calling to icirelais_file_synchronize's class in order to * - truncate tables icirelais (relais point and backup) * - insert new icirelais datas class icirelais_file_synchronize { 'table_name' => 'icirelais' include_once('includes/languages/'.$input['language'].'/icirelais_file_synchronize.php'); * - truncate tables icirelais (relais point and backup) * - insert new icirelais datas protected function _icirelais_fields () { ./www/exapaq/catalog/admin/includes/classes/icirelais_file_synchronize_V1.php * Calling to icirelais_file_synchronize's class in order to * - truncate tables icirelais (relais point and backup) * - insert new icirelais datas class icirelais_file_synchronize { 'table_name' => 'icirelais' function icirelais_file_synchronize($input){ include_once('includes/languages/'.$input['language'].'/icirelais_file_synchronize.php'); * - truncate tables icirelais (relais point and backup) * - insert new icirelais datas function _icirelais_fields () { ./www/exapaq/catalog/admin/includes/classes/icirelais_file_synchronize_V2.php * Calling to icirelais_file_synchronize's class in order to * - truncate tables icirelais (relais point and backup) * - insert new icirelais datas require_once(DIR_WS_CLASSES . 'icirelais_file_synchronize_V2.php'); $icirelais_file_synchronize = new icirelais_file_synchronize(array( $res_icirelais_file_synchronize = $icirelais_file_synchronize->file_synchronize_action(); if(!alert("'.$res_icirelais_file_synchronize['msg'].'")) { document.location.href="modules.php?set=shipping&module=icirelais"; document.location.href="modules.php?set=shipping&module=icirelais"; ./www/exapaq/catalog/admin/call_icirelais_file_synchronize.php ' ' . /*icirelais_function optionnal */ display_htmllink_if_web_address(nl2br(tep_db_output($orders_history['comments']))) . ' ' . "\n" . ./www/exapaq/catalog/admin/orders.php if($tab[0] == 'icirelais') { ./www/exapaq/catalog/checkout_process.php // -> 0000003: icirelais/exapaq . (empty($statuses['comments']) ? ' ' : /*icirelais_function optionnal */ display_htmllink_if_web_address(nl2br(tep_output_string_protected($statuses['comments'])))) . ./www/account_history_info.php class icirelais { function icirelais() { $this->code = 'icirelais'; $this->icon = DIR_WS_DESIGN . 'logo/logo_icirelais_50x50.png'; if ( file_exists(DIR_WS_CLASSES.'icirelais_get_point.php') ) require_once(DIR_WS_CLASSES.'icirelais_get_point.php'); $icirelais_get_point = new icirelais_get_point(array( $this->quotes = $icirelais_get_point->get_point(); if (file_exists(DIR_FS_CATALOG_LANGUAGES . $language . '/modules/shipping/icirelais.php')) { require_once(DIR_FS_CATALOG_LANGUAGES . $language . '/modules/shipping/icirelais.php'); require_once(DIR_FS_CATALOG_LANGUAGES . '/english/modules/shipping/icirelais.php'); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('', 'MODULE_SHIPPING_ICIRELAIS_SYNC', '
', '', '6', '14', 'disappear(', now())"); ./www/includes/modules/shipping/icirelais.php // -> 0000003: icirelais/exapaq ./www/includes/languages/french/checkout_shipping.php // -> 0000003: icirelais/exapaq ./www/includes/languages/english/checkout_shipping.php // -> 0000003: icirelais/exapaq require_once(DIR_WS_FUNCTIONS . 'icirelais_function.php'); ./www/includes/application_top.php from icirelais ./www/includes/functions/icirelais_function.php * @package icirelais_shipping_mode class icirelais_get_point { function icirelais_get_point($input){ require_once('includes/languages/'.$input['language'].'/modules/shipping/icirelais.php'); FROM icirelais ./www/includes/classes/icirelais_get_point_PHP5.php // -> 0000003: icirelais/exapaq if($tab[0] == 'icirelais') { from icirelais ab ./www/includes/classes/order.php * @package icirelais_shipping_mode class icirelais_get_point { function icirelais_get_point($input){ require_once('includes/languages/'.$input['language'].'/modules/shipping/icirelais.php'); FROM icirelais ./www/includes/classes/icirelais_get_point.php if ( strstr($row_orders['shipping_module'], "icirelais_" ) != "" ) { $point_relais = str_replace("icirelais_", "", $row_orders['shipping_module']); ./www/admin/exportexapaq.php // -> 0000003: icirelais/exapaq ./www/admin/includes/languages/french/orders_backup.php // -> 0000003: icirelais/exapaq ./www/admin/includes/languages/french/edit_orders.php // -> 0000003: icirelais/exapaq ./www/admin/includes/languages/french/orders.php // -> 0000003: icirelais/exapaq ./www/admin/includes/languages/english/edit_orders.php // -> 0000003: icirelais/exapaq ./www/admin/includes/languages/english/orders.php // -> 0000003: icirelais/exapaq require_once(DIR_WS_FUNCTIONS . 'icirelais_function.php'); ./www/admin/includes/application_top.php * Calling to icirelais_file_synchronize's class in order to * - truncate tables icirelais (relais point and backup) * - insert new icirelais datas class icirelais_file_synchronize { 'table_name' => 'icirelais' include_once('includes/languages/'.$input['language'].'/icirelais_file_synchronize.php'); * - truncate tables icirelais (relais point and backup) * - insert new icirelais datas protected function _icirelais_fields () { ./www/admin/includes/classes/icirelais_file_synchronize_V1.php * Calling to icirelais_file_synchronize's class in order to * - truncate tables icirelais (relais point and backup) * - insert new icirelais datas class icirelais_file_synchronize { 'table_name' => 'icirelais' function icirelais_file_synchronize($input){ include_once('includes/languages/'.$input['language'].'/icirelais_file_synchronize.php'); * - truncate tables icirelais (relais point and backup) * - insert new icirelais datas function _icirelais_fields () { ./www/admin/includes/classes/icirelais_file_synchronize_V2.php * Calling to icirelais_file_synchronize's class in order to * - truncate tables icirelais (relais point and backup) * - insert new icirelais datas require_once(DIR_WS_CLASSES . 'icirelais_file_synchronize_V2.php'); $icirelais_file_synchronize = new icirelais_file_synchronize(array( $res_icirelais_file_synchronize = $icirelais_file_synchronize->file_synchronize_action(); if(!alert("'.$res_icirelais_file_synchronize['msg'].'")) { document.location.href="modules.php?set=shipping&module=icirelais"; document.location.href="modules.php?set=shipping&module=icirelais"; ./www/admin/call_icirelais_file_synchronize.php 0000003: icirelais/exapaq ?> ./www/admin/commissions.php 0000003: icirelais/exapaq ?> // -> 0000003: icirelais/exapaq 0000003: icirelais/exapaq ?> ./www/admin/edit_orders.php // -> 0000003: icirelais/exapaq ./www/admin/modules.php 0000003: icirelais/exapaq ?> // -> 0000003: icirelais/exapaq ' ' . /*icirelais_function optionnal */ display_htmllink_if_web_address(nl2br(tep_db_output($orders_history['comments']))) . ' ' . "\n" . 0000003: icirelais/exapaq ?> ./www/admin/orders.php // -> 0000003: icirelais/exapaq if($tab[0] == 'icirelais') { ./www/checkout_process.php // -> 0000003: icirelais/exapaq if($tab[0] == 'icirelais') { ./www/ext/modules/payment/Etransactions/Etransactions.php ]0;www-lp@vps575036: ~www-lp@vps575036:~$ vi ./www/admin/includes/classes/icirelais_file_synchronize_V2.php [?1000h[?1049h[?1h=▽ ]11;?[?12;25h[?12l[?25h[?25l"./www/admin/includes/classes/icirelais_file_synchronize_V2.php" 345L, 10521C[>cfunction download($input) {// FTP Connection $conn = @ftp_connect($this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_HOST'], 0, 5);if(!$conn) {return array('result' => false, 'msg' => FTP_CONNECT_FAILED);}// FTP loginif(!@ftp_login($conn, (string)$this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_USER'], (string)$this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_PASSWORD'])) {return array('result' => false, 'msg' => FTP_AUTHENTIFICATION_FAILED);}// FTP Passive mode active (in case of firewall)@ftp_pasv($conn, true);// FTP change directoryif(!@ftp_chdir($conn, (string)$this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_DIRECTORY'])){return array('result' => false, 'msg' => FTP_CHDIR_FAILED);}// Create a temporary file for the compressed file$this->_tmpFile = tempnam('/tmp', 'ICIRELAIS');if(!($handle = @fopen($this->_tmpFile, 'w+'))) {return array('result' => false, 'msg' => FOPEN_FAILED.$this->_tmpFile);}// Get the compressed file in the temporary fileif(!@ftp_fget($conn, $handle, $input['remote_file'], FTP_BINARY, 0)) {return array('result' => false, 'msg' => FTP_GET_FAILED.$input['remote_file']);}@fclose($handle);@ftp_close($conn);return array('result' => true, 'msg' => DOWNLOAD_OK.$input['remote_file']);}//=========================================================================================================================/** * Uncompress ICI Relais files in temporary files * * @return array * - 'result' boolean * - 'msg' varchar */function uncompress($input) {133,3-24 36% "./www/admin/includes/classes/icirelais_file_synchronize_V2.php" 345L, 10521C [?1000l[?1002h[?12l[?25h[?25l//[?12l[?25hI[?25lI133,53-74 36%[?12l[?25hN[?25lIIN137,61-75 36%[?12l[?25hS[?25lfunction get_content_and_save ($input) {$local_file = $this->_download_dir.DIRECTORY_SEPARATOR.$input['local_file'];// check if it is a fileif(!is_file($local_file)) {return array('result' => false, 'msg' => NOT_A_FILE.$local_file);}// check if the file is emptyif(filesize($local_file) == 0) {return array('result' => false, 'msg' => FILE_EMPTY.$local_file);}// truncate table$query = "TRUNCATE ".$input['table_name'];$truncate_table = tep_db_query($query);// get table fields$function = "_".$input['table_name']."_fields";$fields = $this->$function();// Query construction 1/2 (field part)$insert = "INSERT INTO ".$input['table_name']." (";foreach($fields as $filed_name) {$insert .= $filed_name.", ";}$insert = substr($insert,0,strlen($insert)-2).") VALUES ";// Read file, get content into a variable and send frequently to the database$has_begin = 0;$has_end = 0;$i = 0;$values = "";$handle = @fopen($local_file, "r");if ($handle) {while (!feof($handle)) {// Save to database frequentlyif($i == 1000){$values = substr($values,0,strlen($values)-1);$insert_to_database = tep_db_query($insert.$values);$values = "";$i = 0;}// Get the current line$line = fgets($handle);if(substr($line,0,1) == "D"){226,14-28 68% /INS[?12l[?25hE[?25lE226,14-28 68%[?12l[?25hR[?25lR226,14-28 68%[?12l[?25hT[?25lT226,14-28 68%[?12l[?25h [?25lINSERT226,14-28 68%[?12l[?25h[?25lj 7[?12l[?25h[?25lj 8,7-28 [?12l[?25h[?25lj {}9,3-17[?12l[?25h[?25lj {}30,14-28[?12l[?25h[?25lj 1,2-16 [?12l[?25h[?25lj 2,14-28[?12l[?25h[?25lj 3[?12l[?25h[?25lj 4[?12l[?25h[?25lj 5,9-23 [?12l[?25h[?25lj 6,14-28[?12l[?25h[?25lj 7,2-16 [?12l[?25h[?25lj 8,14-28[?12l[?25h[?25lj ()9[?12l[?25h[?25lj ()40,7-28 [?12l[?25h[?25lj 1,4-32[?12l[?25h[?25lj 2[?12l[?25h[?25lj 3[?12l[?25h[?25lj 4[?12l[?25h[?25lj 5[?12l[?25h[?25lj 6[?12l[?25h[?25lj  // The file has a good begenning247,4-32 68%[?12l[?25h[?25lj  $has_begin = 1;248,4-32 68%[?12l[?25h[?25lj  } elseif(substr($line,0,1) == "F"){249,4-32 69%[?12l[?25h[?25lj  // The file has a good end250,4-32 69%[?12l[?25h[?25lj  $has_end = 1;251,4-32 69%[?12l[?25h[?25lj  } else {252,4-32 70%[?12l[?25h[?25lj  $data = explode(";",$line);253,4-32 70%[?12l[?25h[?25lj  // We have to check $data[0] because empty line can't be treated254,4-32 70%[?12l[?25h[?25lj  if(is_array($data) && !empty($data[0])){255,4-32 71%[?12l[?25h[?25lj  $values .= "(";256,4-32 71%[?12l[?25h[?25lj  foreach($data as $value) {257,4-32 71%[?12l[?25h[?25lj  $values .= "'".$this->_valueFilter($value)."',";258,4-32 72%[?12l[?25h[?25lj  }259,4-32 72%[?12l[?25h[?25lj  $values = substr($values,0,strlen($values)-1)."),";260,4-32 72%[?12l[?25h[?25lj  $i++;261,4-32 73%[?12l[?25h[?25lj  }262,4-32 73%[?12l[?25h[?25lj  }263,4-32 73%[?12l[?25h[?25lj  264,4-32 74%[?12l[?25h[?25lj  }265,4-32 74%[?12l[?25h[?25lj  fclose($handle);266,4-32 74%[?12l[?25h[?25lj  $values = substr($values,0,strlen($values)-1);267,4-32 75%[?12l[?25h[?25lj  $insert_to_database = tep_db_query($insert.$values);268,4-32 75%[?12l[?25h[?25lj  }269,4-32 75%[?12l[?25h[?25lj  {}270,4-25 76%[?12l[?25h[?25lj  {}if($has_begin == 1 && $has_end == 1){271,7-28 76%[?12l[?25h[?25lj  return array('result' => true, 'msg' => GET_CONTENT_OK.$local_file.' s\'est bien déroulée');272,7-28 76%[?12l[?25h[?25lj  } else {273,7-28 77%[?12l[?25h[?25lj  {}return array('result' => true, 'msg' => GET_CONTENT_NEARLY_OK.$local_file);274,3-17 77%[?12l[?25h[?25lj  {}}275,0-177%[?12l[?25h[?25lj  276,14-28 78%[?12l[?25h[?25lj  }277,7-28 78%[?12l[?25h[?25lj  {}278,10-24 78%[?12l[?25h[?25lj  {}//=========================================================================================================================279,7-28 79%[?12l[?25h[?25lj  {}280,3-17 79%[?12l[?25h[?25lj  {}/**281,2-16 80%[?12l[?25h[?25lj   * @param string $value282,2-980%[?12l[?25h[?25lj   * @return string283,1-880%[?12l[?25h[?25lj   */284,21-28 81%[?12l[?25h[?25lj  function _valueFilter($value) {285,1-881%[?12l[?25h[?25lk 4,21-28[?12l[?25h[?25lk 3,1-8 [?12l[?25h[?25lk 2,2-9[?12l[?25h[?25lk 1,2-16[?12l[?25h[?25lk {}0,3-17[?12l[?25h[?25lk {}79,7-28[?12l[?25h[?25lk {}8,10-24[?12l[?25h[?25lk {}7,7-28 [?12l[?25h[?25lk 6,14-28[?12l[?25h[?25lk 5,0-1 [?12l[?25h[?25lk 4,3-17[?12l[?25h[?25lk 3,7-28[?12l[?25h[?25lk 2[?12l[?25h[?25lk 1[?12l[?25h[?25lk 0,4-25[?12l[?25h[?25lk 69,4-32[?12l[?25h[?25lk 8[?12l[?25h[?25lk 7[?12l[?25h[?25lk 6[?12l[?25h[?25lk 5[?12l[?25h[?25lk 4[?12l[?25h[?25lk 3[?12l[?25h[?25lk 2[?12l[?25h[?25lk 1[?12l[?25h[?25lk 0[?12l[?25h[?25lk 59[?12l[?25h[?25lk 8[?12l[?25h[?25lk 7[?12l[?25h[?25lk 6[?12l[?25h[?25lk 5[?12l[?25h[?25lk 4[?12l[?25h[?25lk 3[?12l[?25h[?25lk 2[?12l[?25h[?25lk 1[?12l[?25h[?25lk 0[?12l[?25h[?25lk 49[?12l[?25h[?25lk 8[?12l[?25h[?25lk 7[?12l[?25h[?25lk 6[?12l[?25h[?25lk while (!feof($handle)) {245,4-32 81%[?12l[?25h[?25lk if ($handle) {244,4-32 80%[?12l[?25h[?25lk $handle = @fopen($local_file, "r");243,4-32 80%[?12l[?25h[?25lk 242,4-32 80%[?12l[?25h[?25lk $values = "";241,4-32 79%[?12l[?25h[?25lk $i = 0;240,7-28 79%[?12l[?25h[?25lk $has_end = 0;()239,14-28 78%[?12l[?25h[?25lk $has_begin = 0;()238,14-28 78%[?12l[?25h[?25lk // Read file, get content into a variable and send frequently to the database237,2-16 78%[?12l[?25h[?25lk 236,14-28 77%[?12l[?25h[?25lk $insert = substr($insert,0,strlen($insert)-2).") VALUES ";235,9-23 77%[?12l[?25h[?25lk }234,14-28 77%[?12l[?25h[?25lk $insert .= $filed_name.", ";233,14-28 76%[?12l[?25h[?25lk foreach($fields as $filed_name) {232,14-28 76%[?12l[?25h[?25lk $insert = "INSERT INTO ".$input['table_name']." (";231,2-16 76%[?12l[?25h[?25lk // Query construction 1/2 (field part)230,14-28 75%[?12l[?25h[?25lk {}229,3-17 75%[?12l[?25h[?25lk $fields = $this->$function();{}228,7-28 75%[?12l[?25h[?25lk $function = "_".$input['table_name']."_fields";227,14-28 74%[?12l[?25h[?25lk // get table fields226,14-28 74%[?12l[?25h[?25lk 225,14-28 74%[?12l[?25h[?25lk $truncate_table = tep_db_query($query);224,2-16 73%[?12l[?25h[?25lk $query = "TRUNCATE ".$input['table_name'];223,14-28 73%[?12l[?25h[?25lk // truncate table222,14-28 73%[?12l[?25h[?25lk 221,14-28 72%[?12l[?25h[?25lk }220,2-16 72%[?12l[?25h[?25lk return array('result' => false, 'msg' => FILE_EMPTY.$local_file);219,14-28 72%[?12l[?25h[?25lk if(filesize($local_file) == 0) {218,14-28 71%[?12l[?25h[?25lk // check if the file is empty217,14-28 71%[?12l[?25h[?25lk 216,2-16 71%[?12l[?25h[?25lk }{}215,3-17 70%[?12l[?25h[?25lk return array('result' => false, 'msg' => NOT_A_FILE.$local_file);{}214,7-28 70%[?12l[?25h[?25lk if(!is_file($local_file)) {()213,14-28 70%[?12l[?25h[?25lk // check if it is a file()212,14-28 69%[?12l[?25h[?25lk 211,2-16 69%[?12l[?25h[?25lk $local_file = $this->_download_dir.DIRECTORY_SEPARATOR.$input['local_file'];{}210,3-17 69%[?12l[?25h[?25lk {}209,7-28 68%[?12l[?25h[?25lk function get_content_and_save ($input) {()208,14-28 68%[?12l[?25h[?25lk ()207,14-28 68%[?12l[?25h[?25lk 206,2-16 67%[?12l[?25h[?25lk  */205,14-28 67%[?12l[?25h[?25lk  * - 'msg' varchar204,2-16 67%[?12l[?25h[?25lk  * - 'result' boolean203,21-28 66%[?12l[?25h[?25lk  * @return array202,1-866%[?12l[?25h[?25lk  *201,1-866%[?12l[?25h[?25lk  * Get ICI Relais files content, truncate table and insert new datas200,5-12 65%[?12l[?25h[?25lk /**199,10-28 65%[?12l[?25h[?25lk 198,10-28 65%[?12l[?25h[?25lk //=========================================================================================================================197,18-25 64%[?12l[?25h[?25lk 196,4-11 64%[?12l[?25h[?25lk }195,21-28 64%[?12l[?25h[?25lj 6,4-11 [?12l[?25h[?25lj 7,18-25[?12l[?25h[?25lj 8,10-28[?12l[?25h[?25lj 9[?12l[?25h[?25lj 200,5-12 [?12l[?25h[?25lj 1,1-8 [?12l[?25h[?25lj 2[?12l[?25h[?25lj 3,21-28[?12l[?25h[?25lj 4,2-16 [?12l[?25h[?25lj 5,14-28[?12l[?25h[?25lj 6,2-16 [?12l[?25h[?25lj 7,14-28[?12l[?25h[?25lj ()8[?12l[?25h[?25lj ()9,7-28 [?12l[?25h[?25lj {}10,3-17[?12l[?25h[?25lj {}1,2-16[?12l[?25h[?25lj 2,14-28[?12l[?25h[?25lj ()3[?12l[?25h[?25lj ()4,7-28 [?12l[?25h[?25lj {}5,3-17[?12l[?25h[?25lj {}6,2-16[?12l[?25h[?25lj 7,14-28[?12l[?25h[?25lj 8[?12l[?25h[?25lj 9[?12l[?25h[?25lj 20,2-16 [?12l[?25h[?25l19,14-28[?12l[?25h[?25ll 5-29[?12l[?25h[?25lk 8[?12l[?25h[?25lk 7[?12l[?25h[?25lk 6,2-16 [?12l[?25h[?25lk {}5,3-17[?12l[?25h[?25lk {}4,8-29[?12l[?25h[?25lk 3,15-29[?12l[?25h[?25lk 2[?12l[?25h[?25lk 1,2-16 [?12l[?25h[?25lk {}0,3-17[?12l[?25h[?25lk {}09,8-29[?12l[?25h[?25lk 8,15-29[?12l[?25h[?25lk 7[?12l[?25h[?25lk 6,2-16 [?12l[?25h[?25lk 5,15-29[?12l[?25h[?25lk 4,2-16 [?12l[?25h[?25lk 3,22-29[?12l[?25h[?25l*/\La recherche a atteint le BAS, et continue en HAUTset_time_limit(0);// FTP param controlif((!isset($this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_HOST']) || $this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_HOST'] == '')&& (!isset($this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_USER']) || $this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_USER'] == '' )&& (!isset($this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_PASSWORD']) || $this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_PASSWORD'] == '')){return array('result' => false, 'msg' => FTP_PARAM_EMPTY);}foreach($this->_files as $current_file_info){// step 1 : download the file$res_download = $this->download($current_file_info);if($res_download['result'] !== true) {return array('result' => false, 'msg' => $res_download['msg']);}// step 2 : uncompress the file$res_uncompress = $this->uncompress($current_file_info);if($res_uncompress['result'] !== true) {return array('result' => false, 'msg' => $res_uncompress['msg']);}// step 3 : ckeck$res_init = $this->get_content_and_save($current_file_info);if($res_init['result'] !== true) {return array('result' => false, 'msg' => $res_init['msg']);}}return array('result' => true, 'msg' => SYNC_OK);}//=========================================================================================================================/** * Download ICI Relais files from FTP * * @return array * - 'result' boolean * - 'msg' varchar */function download($input) {// FTP Connection $conn = @ftp_connect($this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_HOST'], 0, 5);if(!$conn) {89,23-44 21% La recherche a atteint le BAS, et continue en HAUT89,23-44 21%[?12l[?25h[?25ln/\}// read the compress temporary file and write it in an uncompressed oneif(!@fwrite($handle2, gzread($zp, 9999999))) {return array('result' => false, 'msg' => FWRITE_FAILED.$input['local_file']);}@fclose($handle2);@gzclose($zp);return array('result' => true, 'msg' => UNCOMPRESS_OK.$input['remote_file']);}//=========================================================================================================================/** * Get ICI Relais files content, truncate table and insert new datas * * @return array * - 'result' boolean * - 'msg' varchar */function get_content_and_save ($input) {$local_file = $this->_download_dir.DIRECTORY_SEPARATOR.$input['local_file'];// check if it is a fileif(!is_file($local_file)) {return array('result' => false, 'msg' => NOT_A_FILE.$local_file);}// check if the file is emptyif(filesize($local_file) == 0) {return array('result' => false, 'msg' => FILE_EMPTY.$local_file);}// truncate table$query = "TRUNCATE ".$input['table_name'];$truncate_table = tep_db_query($query);// get table fields$function = "_".$input['table_name']."_fields";$fields = $this->$function();// Query construction 1/2 (field part)$insert = "INSERT INTO ".$input['table_name']." (";foreach($fields as $filed_name) {$insert .= $filed_name.", ";203,11-18 60%[?12l[?25h[?25ln/\La recherche a atteint le BAS, et continue en HAUTset_time_limit(0);// FTP param controlif((!isset($this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_HOST']) || $this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_HOST'] == '')&& (!isset($this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_USER']) || $this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_USER'] == '' )&& (!isset($this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_PASSWORD']) || $this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_PASSWORD'] == '')){return array('result' => false, 'msg' => FTP_PARAM_EMPTY);}foreach($this->_files as $current_file_info){// step 1 : download the file$res_download = $this->download($current_file_info);if($res_download['result'] !== true) {return array('result' => false, 'msg' => $res_download['msg']);}// step 2 : uncompress the file$res_uncompress = $this->uncompress($current_file_info);if($res_uncompress['result'] !== true) {return array('result' => false, 'msg' => $res_uncompress['msg']);}// step 3 : ckeck$res_init = $this->get_content_and_save($current_file_info);if($res_init['result'] !== true) {return array('result' => false, 'msg' => $res_init['msg']);}}return array('result' => true, 'msg' => SYNC_OK);}//=========================================================================================================================/** * Download ICI Relais files from FTP * * @return array * - 'result' boolean * - 'msg' varchar */function download($input) {// FTP Connection $conn = @ftp_connect($this->_configuration_key['MODULE_SHIPPING_ICIRELAIS_FTP_HOST'], 0, 5);if(!$conn) {89,23-44 21% La recherche a atteint le BAS, et continue en HAUT89,23-44 21%[?12l[?25h[?25lk 8,20-41[?12l[?25h[?25lk 7,3-24 [?12l[?25h[?25lk {}6,4-25[?12l[?25h[?25lk {}5,16-44[?12l[?25h[?25lk 4,23[?12l[?25h[?25lk 3[?12l[?25h[?25lk 2[?12l[?25h[?25lk 1,3-24 [?12l[?25h[?25lk {}0,4-25[?12l[?25h[?25lk {}79,16-44[?12l[?25h[?25lk 8,23[?12l[?25h[?25l::[?12l[?25h[?25l78,23-44 21%[?12l[?25h[?25l::[?12l[?25hQ[?25l[?12l[?25h [?25lE492: Commande inconnue: Q78,23-44 21%[?12l[?25h[?25l::[?12l[?25hq[?25l[?12l[?25h [?25l[?1002l[?1l>[?12l[?25h[?1049l]0;www-lp@vps575036: ~www-lp@vps575036:~$ vi ./www/admin/includes/classes/icirelais_file_synchronize_V2.php find . -name '*.php' -exec grep 'icirelais' {} \; -print[5@INTO [4@(file_id, relay_id^C ]0;www-lp@vps575036: ~www-lp@vps575036:~$ touch /tmp/gophop ]0;www-lp@vps575036: ~www-lp@vps575036:~$ touch /tmp/hopvi ./www/admin/includes/classes/icirelais_file_synchronize_V2.php find . -name '*.php' -exec grep 'icirelais' {} \; -print[5@INTO [4@(file_id, relay_id[15@INTO icirelais  vi /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php find . -name icirelais_file_synchronize.php php www/admin/call_icirelais_file_synchronize.php cdpwdcdphp www/admin/call_icirelais_file_synchronize.php PHP Notice: Undefined index: SERVER_NAME in /home/www-lp/www/admin/includes/configure.php on line 15 PHP Notice: Undefined index: SERVER_NAME in /home/www-lp/www/admin/includes/configure.php on line 22 PHP Notice: Undefined index: language in /home/www-lp/www/admin/call_icirelais_file_synchronize.php on line 23 PHP Warning: include_once(includes/languages/french/icirelais_file_synchronize.php): failed to open stream: No such file or directory in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 50 PHP Warning: include_once(): Failed opening 'includes/languages/french/icirelais_file_synchronize.php' for inclusion (include_path='.:/opt/php5.3/php5.3.29/lib/php') in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 50 PHP Notice: Use of undefined constant DOWNLOAD_OK - assumed 'DOWNLOAD_OK' in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 144 PHP Notice: Use of undefined constant UNCOMPRESS_OK - assumed 'UNCOMPRESS_OK' in /home/www-lp/www/admin/includes/classes/icirelais_file_synchronize_V2.php on line 189 f1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

INSERT INTO icirelais (file_id, relay_id, insee, owner_name, adresse_1, adresse_2, adresse_3, postal_code, city, shop_name, coord_lat, coord_long, pda_equipment, start_validity_date, end_validity_date, last_shippment_date, new_shippment_date, text, monday_opening_hours, tuesday_opening_hours, wednesday_opening_hours, thursday_opening_hours, friday_opening_hours, saturday_opening_hours, sunday_opening_hours, closing_period_start_date_1, closing_period_end_date_1, closing_period_start_date_2, closing_period_end_date_2, closing_period_start_date_3, closing_period_end_date_3, required_time) VALUES

[TEP STOP]

i]0;www-lp@vps575036: ~www-lp@vps575036:~$ find . -newe /tmper /tmp/hop ./script/typescript ./www/download/relais.txt ]0;www-lp@vps575036: ~www-lp@vps575036:~$ exit exit Script terminé sur jeu. 30 juin 2022 08:04:56 CEST