[09/01/2020 04:12:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-09-01 04:12:50', '', '', '');
[09/01/2020 04:14:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotel_supplier_mapping SET channel_manager = '',ip_addr='203.192.209.211' WHERE SupplierId = 'S000000078' AND hotel_id = '53704' AND status = 'A';
[09/01/2020 04:14:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-01 04:14:47',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;\&#039;,ip_addr=\&#039;203.192.209.211\&#039; WHERE SupplierId = \&#039;S000000078\&#039; AND hotel_id = \&#039;53704\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '203.192.209.211';
[09/01/2020 04:14:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-01 04:14:47',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;\&#039;,ip_addr=\&#039;203.192.209.211\&#039; WHERE SupplierId = \&#039;S000000078\&#039; AND hotel_id = \&#039;53704\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '203.192.209.211';
[09/01/2020 04:14:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3605', `entity`='Hotels', `value`='53704' ;
[09/01/2020 04:14:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3605', `entity`='Suppliers', `value`='S000000078' ;
[09/01/2020 04:14:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotels SET weekend='6,7',infant_lower_limit='0',infant_upper_limit='2',tiny_child_lower_limit='3',tiny_child_upper_limit='4',child_lower_limit='5',child_upper_limit='6',teen_child_lower_limit='7',teen_child_upper_limit='11',booking_closing_time='',timezone='8' where id= '53704';
[09/01/2020 04:14:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-01 04:14:47',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=\&#039;0\&#039;,infant_upper_limit=\&#039;2\&#039;,tiny_child_lower_limit=\&#039;3\&#039;,tiny_child_upper_limit=\&#039;4\&#039;,child_lower_limit=\&#039;5\&#039;,child_upper_limit=\&#039;6\&#039;,teen_child_lower_limit=\&#039;7\&#039;,teen_child_upper_limit=\&#039;11\&#039;,booking_closing_time=\&#039;\&#039;,timezone=\&#039;8\&#039; where id= \&#039;53704\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '203.192.209.211';
[09/01/2020 04:14:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-01 04:14:47',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=\&#039;0\&#039;,infant_upper_limit=\&#039;2\&#039;,tiny_child_lower_limit=\&#039;3\&#039;,tiny_child_upper_limit=\&#039;4\&#039;,child_lower_limit=\&#039;5\&#039;,child_upper_limit=\&#039;6\&#039;,teen_child_lower_limit=\&#039;7\&#039;,teen_child_upper_limit=\&#039;11\&#039;,booking_closing_time=\&#039;\&#039;,timezone=\&#039;8\&#039; where id= \&#039;53704\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '203.192.209.211';
[09/01/2020 04:14:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3607', `entity`='Hotels', `value`='53704' ;
[09/01/2020 04:14:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3607', `entity`='Suppliers', `value`='S000000078' ;
[09/01/2020 04:15:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-09-01 04:15:05', '', '', '');
[09/01/2020 04:15:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-09-01 04:15:25', '', '', '');
[09/01/2020 04:15:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-09-01 04:15:32', '', '', '');
[09/01/2020 04:27:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-09-01 04:27:22', '', '', '');
[09/01/2020 04:38:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-09-01 04:38:45', '', '', '');
[09/01/2020 04:48:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-09-01 04:48:07', '', '', '');
[09/01/2020 04:52:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-09-01 04:52:52', '', '', '');
