[01/15/2024 06:14:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-15 06:14:04',login_attempt=0 where id = '7851';
[01/15/2024 06:14:04], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-01-15 06:14:04', ip = '43.239.53.130', action = 'Login' ;
[01/15/2024 06:14:04], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:14:04' WHERE id= '297';
[01/15/2024 06:14:09], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:14:09' WHERE id= '297';
[01/15/2024 06:14:14], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:14:14' WHERE id= '297';
[01/15/2024 06:14:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:14:19' WHERE id= '297';
[01/15/2024 06:14:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/18',  departure_date='2024/01/18',  nights='1',  create_date='2024-01-15 :06:14:19',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/15/2024 06:14:19], [file name :-/home/otrams/public_html/beta/sight_search_list.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', 'v1/15_01_2024/request_availability_Viator_test_06_14_19_1705299259.json', 'v1/15_01_2024/response_availability_Viator_test_06_14_19_1705299259.json', 'v1/15_01_2024/response_header_availability_Viator_test_06_14_19_1705299259.json', 'viator', '2024-01-15 06:14:19', '', '', '917');
[01/15/2024 06:14:21], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:14:21' WHERE id= '297';
[01/15/2024 06:14:21], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:14:21' WHERE id= '297';
[01/15/2024 06:16:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:16:13' WHERE id= '297';
[01/15/2024 06:16:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/15_01_2024/request_sight_details_Viator_test_06_16_13_1705299373.json', 'v1/15_01_2024/response_sight_details_Viator_test_06_16_13_1705299373.json', 'v1/15_01_2024/response_header_sight_details_Viator_test_06_16_13_1705299373.json', 'viator', '2024-01-15 06:16:13', '', '', '917');
[01/15/2024 06:16:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:16:21' WHERE id= '297';
[01/15/2024 06:16:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/15_01_2024/request_check_availability_Viator_test_06_16_21_1705299381.json', 'v1/15_01_2024/response_check_availability_Viator_test_06_16_21_1705299381.json', 'v1/15_01_2024/response_header_check_availability_Viator_test_06_16_21_1705299381.json', 'viator', '2024-01-15 06:16:21', '', '', '917');
[01/15/2024 06:16:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:16:23' WHERE id= '297';
[01/15/2024 06:16:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705299383','43.239.53.130');
[01/15/2024 06:20:04], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:20:04' WHERE id= '297';
[01/15/2024 06:20:04], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705299604','43.239.53.130');
[01/15/2024 06:20:34], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:20:34' WHERE id= '297';
[01/15/2024 06:20:34], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705299634','43.239.53.130');
[01/15/2024 06:41:10], [file name :-/home/otrams/public_html/beta/tms/currency.php],UPDATE currency_map SET exchange_markup='10' WHERE from_c='6' AND to_c='4';
[01/15/2024 06:41:10], [file name :-/home/otrams/public_html/beta/tms/currency.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-15 06:41:10',`log_type`= 'Currency Exchange Markup Updated',`sql_query`= 'UPDATE currency_map SET exchange_markup=10 WHERE from_c=\&#039;6\&#039; AND to_c=\&#039;4\&#039;',`log_description`= 'Currency Exchange Markup From USD To INR Has Been Changed From 0% To 10%',`ip`= '43.239.53.130';
[01/15/2024 06:50:41], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-15 06:50:41',login_attempt=0 where id = '7866';
[01/15/2024 06:50:41], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'deepak_qtech', user_type = 'A', branch_id = '31', login_datetime = '2024-01-15 06:50:41', ip = '43.239.53.130', action = 'Login' ;
[01/15/2024 06:50:41], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:50:41' WHERE id= '304';
[01/15/2024 06:50:49], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:50:49' WHERE id= '304';
[01/15/2024 06:50:51], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:50:51' WHERE id= '304';
[01/15/2024 06:50:51], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/01/15' , departure_date = '2024/01/16' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-15 06:50:51' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/15/2024 06:50:55], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:50:55' WHERE id= '304';
[01/15/2024 06:50:55], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/15_01_2024/request_availability_Baysan_Tourism_wh_06_50_55_1705301455_36.json', 'e1p/15_01_2024/response_availability_Baysan_Tourism_wh_06_50_55_1705301455_36.json', 'e1p/15_01_2024/response_header_availability_Baysan_Tourism_wh_06_50_55_1705301455_36.json', 'expediapackage', '2024-01-15 06:50:55', '', '5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7', '0');
[01/15/2024 06:50:55], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-15 06:50:55.547'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.324'
            , error_description = ''
            , memory_used = '2090632'
            WHERE id = '28159';
[01/15/2024 06:50:56], [file name :-/home/otrams/public_html/beta/call.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', 'e1/15_01_2024/request_availability_Baysan_Tourism_wh_06_50_55_1705301455_72.json', 'e1/15_01_2024/response_availability_Baysan_Tourism_wh_06_50_55_1705301455_72.json', 'e1/15_01_2024/response_header_availability_Baysan_Tourism_wh_06_50_55_1705301455_72.json', 'expedia', '2024-01-15 06:50:56', '', '5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7', '0');
[01/15/2024 06:50:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-15 06:50:55.548'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.488'
            , error_description = ''
            , memory_used = '2091144'
            WHERE id = '28160';
[01/15/2024 06:50:56], [file name :-/home/otrams/public_html/beta/call.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', 'e1/15_01_2024/request_availability_Baysan_Tourism_wh_06_50_55_1705301455_66.json', 'e1/15_01_2024/response_availability_Baysan_Tourism_wh_06_50_55_1705301455_66.json', 'e1/15_01_2024/response_header_availability_Baysan_Tourism_wh_06_50_55_1705301455_66.json', 'expedia', '2024-01-15 06:50:56', '', '5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7', '0');
[01/15/2024 06:50:57], [file name :-/home/otrams/public_html/beta/call.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', 'e1/15_01_2024/request_availability_Baysan_Tourism_wh_06_50_55_1705301455_60.json', 'e1/15_01_2024/response_availability_Baysan_Tourism_wh_06_50_55_1705301455_60.json', 'e1/15_01_2024/response_header_availability_Baysan_Tourism_wh_06_50_55_1705301455_60.json', 'expedia', '2024-01-15 06:50:57', '', '5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7', '0');
[01/15/2024 06:50:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-15 06:50:55.547'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.188'
            , error_description = ''
            , memory_used = '99334448'
            WHERE id = '28161';
[01/15/2024 06:50:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-15 06:50:55.547'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.321'
            , error_description = ''
            , memory_used = '91442288'
            WHERE id = '28162';
[01/15/2024 06:50:58], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/15_01_2024/request_availability_Baysan_Tourism_wh_06_50_55_1705301455_17.json', 'e1p/15_01_2024/response_availability_Baysan_Tourism_wh_06_50_55_1705301455_17.json', 'e1p/15_01_2024/response_header_availability_Baysan_Tourism_wh_06_50_55_1705301455_17.json', 'expediapackage', '2024-01-15 06:50:58', '', '5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7', '0');
[01/15/2024 06:50:58], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/15_01_2024/request_availability_Baysan_Tourism_wh_06_50_55_1705301455_36.json', 'e1p/15_01_2024/response_availability_Baysan_Tourism_wh_06_50_55_1705301455_36.json', 'e1p/15_01_2024/response_header_availability_Baysan_Tourism_wh_06_50_55_1705301455_36.json', 'expediapackage', '2024-01-15 06:50:58', '', '5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7', '0');
[01/15/2024 06:50:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-15 06:50:55.547'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.049'
            , error_description = ''
            , memory_used = '109386416'
            WHERE id = '28163';
[01/15/2024 06:50:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=5a455c200fc9dfef170ed372c3bde38bae389f286d51c512848f5fe52901b3e7&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-15 06:50:55.548'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.068'
            , error_description = ''
            , memory_used = '101124904'
            WHERE id = '28164';
[01/15/2024 06:51:00], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:51:00' WHERE id= '304';
[01/15/2024 06:51:00], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 06:51:00' WHERE id= '304';
[01/15/2024 06:55:49], [file name :-/home/otrams/public_html/beta/tms/currency.php],UPDATE currency_map SET exchange_markup='2' WHERE from_c='3' AND to_c='4';
[01/15/2024 06:55:49], [file name :-/home/otrams/public_html/beta/tms/currency.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-15 06:55:49',`log_type`= 'Currency Exchange Markup Updated',`sql_query`= 'UPDATE currency_map SET exchange_markup=2 WHERE from_c=\&#039;3\&#039; AND to_c=\&#039;4\&#039;',`log_description`= 'Currency Exchange Markup From EUR To INR Has Been Changed From 0% To 2%',`ip`= '43.239.53.130';
