[01/14/2024 04:20:20], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-01-14 16:20:20', ip = '154.47.30.132', action = 'Login' ;
[01/14/2024 04:38:24], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-01-14 16:38:24', ip = '146.70.129.110', action = 'Login' ;
[01/14/2024 04:48:12], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-14 04:48:12',login_attempt=0 where id = '7851';
[01/14/2024 04:48:13], [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-14 16:48:13', ip = '43.239.53.130', action = 'Login' ;
[01/14/2024 04:48:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:48:13' WHERE id= '297';
[01/14/2024 04:48:31], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:48:31' WHERE id= '297';
[01/14/2024 04:48:35], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:48:35' WHERE id= '297';
[01/14/2024 04:48:45], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:48:45' WHERE id= '297';
[01/14/2024 04:48:45], [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/17',  departure_date='2024/01/17',  nights='1',  create_date='2024-01-14 :16:48:45',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/14/2024 04:48:48], [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/14_01_2024/request_availability_Viator_test_16_48_45_1705250925.json', 'v1/14_01_2024/response_availability_Viator_test_16_48_45_1705250925.json', 'v1/14_01_2024/response_header_availability_Viator_test_16_48_45_1705250925.json', 'viator', '2024-01-14 04:48:48', '', '', '913');
[01/14/2024 04:48:49], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:48:49' WHERE id= '297';
[01/14/2024 04:48:49], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:48:49' WHERE id= '297';
[01/14/2024 04:48:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:48:54' WHERE id= '297';
[01/14/2024 04:48:55], [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/14_01_2024/request_sight_details_Viator_test_16_48_54_1705250934.json', 'v1/14_01_2024/response_sight_details_Viator_test_16_48_54_1705250934.json', 'v1/14_01_2024/response_header_sight_details_Viator_test_16_48_54_1705250934.json', 'viator', '2024-01-14 04:48:55', '', '', '913');
[01/14/2024 04:49:05], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:49:05' WHERE id= '297';
[01/14/2024 04:49:06], [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/14_01_2024/request_check_availability_Viator_test_16_49_05_1705250945.json', 'v1/14_01_2024/response_check_availability_Viator_test_16_49_05_1705250945.json', 'v1/14_01_2024/response_header_check_availability_Viator_test_16_49_05_1705250945.json', 'viator', '2024-01-14 04:49:06', '', '', '913');
[01/14/2024 04:49:08], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:49:08' WHERE id= '297';
[01/14/2024 04:49:08], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705250948','43.239.53.130');
[01/14/2024 04:50:50], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:50:50' WHERE id= '297';
[01/14/2024 04:50:50], [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/17',  departure_date='2024/01/17',  nights='1',  create_date='2024-01-14 :16:50:50',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/14/2024 04:50:51], [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/14_01_2024/request_availability_Viator_test_16_50_50_1705251050.json', 'v1/14_01_2024/response_availability_Viator_test_16_50_50_1705251050.json', 'v1/14_01_2024/response_header_availability_Viator_test_16_50_50_1705251050.json', 'viator', '2024-01-14 04:50:51', '', '', '914');
[01/14/2024 04:50:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:50:53' WHERE id= '297';
[01/14/2024 04:50:53], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:50:53' WHERE id= '297';
[01/14/2024 04:50:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:50:58' WHERE id= '297';
[01/14/2024 04:50:59], [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/14_01_2024/request_sight_details_Viator_test_16_50_58_1705251058.json', 'v1/14_01_2024/response_sight_details_Viator_test_16_50_58_1705251058.json', 'v1/14_01_2024/response_header_sight_details_Viator_test_16_50_58_1705251058.json', 'viator', '2024-01-14 04:50:59', '', '', '914');
[01/14/2024 04:51:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:51:07' WHERE id= '297';
[01/14/2024 04:51:08], [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/14_01_2024/request_check_availability_Viator_test_16_51_07_1705251067.json', 'v1/14_01_2024/response_check_availability_Viator_test_16_51_07_1705251067.json', 'v1/14_01_2024/response_header_check_availability_Viator_test_16_51_07_1705251067.json', 'viator', '2024-01-14 04:51:08', '', '', '914');
[01/14/2024 04:51:12], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:51:12' WHERE id= '297';
[01/14/2024 04:51: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/14_01_2024/request_sight_details_Viator_test_16_51_12_1705251072.json', 'v1/14_01_2024/response_sight_details_Viator_test_16_51_12_1705251072.json', 'v1/14_01_2024/response_header_sight_details_Viator_test_16_51_12_1705251072.json', 'viator', '2024-01-14 04:51:13', '', '', '914');
[01/14/2024 04:51:18], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:51:18' WHERE id= '297';
[01/14/2024 04:51:18], [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/14_01_2024/request_check_availability_Viator_test_16_51_18_1705251078.json', 'v1/14_01_2024/response_check_availability_Viator_test_16_51_18_1705251078.json', 'v1/14_01_2024/response_header_check_availability_Viator_test_16_51_18_1705251078.json', 'viator', '2024-01-14 04:51:18', '', '', '914');
[01/14/2024 04:51:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:51:21' WHERE id= '297';
[01/14/2024 04:51:22], [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/14_01_2024/request_sight_details_Viator_test_16_51_21_1705251081.json', 'v1/14_01_2024/response_sight_details_Viator_test_16_51_21_1705251081.json', 'v1/14_01_2024/response_header_sight_details_Viator_test_16_51_21_1705251081.json', 'viator', '2024-01-14 04:51:22', '', '', '914');
[01/14/2024 04:51:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:51:38' WHERE id= '297';
[01/14/2024 04:51:39], [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/14_01_2024/request_sight_details_Viator_test_16_51_38_1705251098.json', 'v1/14_01_2024/response_sight_details_Viator_test_16_51_38_1705251098.json', 'v1/14_01_2024/response_header_sight_details_Viator_test_16_51_38_1705251098.json', 'viator', '2024-01-14 04:51:39', '', '', '914');
[01/14/2024 04:51:48], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:51:48' WHERE id= '297';
[01/14/2024 04:51:48], [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/14_01_2024/request_check_availability_Viator_test_16_51_48_1705251108.json', 'v1/14_01_2024/response_check_availability_Viator_test_16_51_48_1705251108.json', 'v1/14_01_2024/response_header_check_availability_Viator_test_16_51_48_1705251108.json', 'viator', '2024-01-14 04:51:48', '', '', '914');
[01/14/2024 04:51:52], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:51:52' WHERE id= '297';
[01/14/2024 04:51:52], [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/14_01_2024/request_sight_details_Viator_test_16_51_52_1705251112.json', 'v1/14_01_2024/response_sight_details_Viator_test_16_51_52_1705251112.json', 'v1/14_01_2024/response_header_sight_details_Viator_test_16_51_52_1705251112.json', 'viator', '2024-01-14 04:51:52', '', '', '914');
[01/14/2024 04:51:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:51:55' WHERE id= '297';
[01/14/2024 04:51:56], [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/14_01_2024/request_sight_details_Viator_test_16_51_55_1705251115.json', 'v1/14_01_2024/response_sight_details_Viator_test_16_51_55_1705251115.json', 'v1/14_01_2024/response_header_sight_details_Viator_test_16_51_55_1705251115.json', 'viator', '2024-01-14 04:51:56', '', '', '914');
[01/14/2024 04:51:59], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:51:59' WHERE id= '297';
[01/14/2024 04:52:00], [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/14_01_2024/request_sight_details_Viator_test_16_51_59_1705251119.json', 'v1/14_01_2024/response_sight_details_Viator_test_16_51_59_1705251119.json', 'v1/14_01_2024/response_header_sight_details_Viator_test_16_51_59_1705251119.json', 'viator', '2024-01-14 04:52:00', '', '', '914');
[01/14/2024 04:52:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:52:16' WHERE id= '297';
[01/14/2024 04:52:16], [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/14_01_2024/request_check_availability_Viator_test_16_52_16_1705251136.json', 'v1/14_01_2024/response_check_availability_Viator_test_16_52_16_1705251136.json', 'v1/14_01_2024/response_header_check_availability_Viator_test_16_52_16_1705251136.json', 'viator', '2024-01-14 04:52:16', '', '', '914');
[01/14/2024 04:57:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:57:37' WHERE id= '297';
[01/14/2024 04:57:37], [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/17',  departure_date='2024/01/17',  nights='1',  create_date='2024-01-14 :16:57:37',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/14/2024 04:57:37], [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/14_01_2024/request_availability_Viator_test_16_57_37_1705251457.json', 'v1/14_01_2024/response_availability_Viator_test_16_57_37_1705251457.json', 'v1/14_01_2024/response_header_availability_Viator_test_16_57_37_1705251457.json', 'viator', '2024-01-14 04:57:37', '', '', '915');
[01/14/2024 04:57:40], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:57:40' WHERE id= '297';
[01/14/2024 04:57:41], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:57:41' WHERE id= '297';
[01/14/2024 04:57:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:57:44' WHERE id= '297';
[01/14/2024 04:57:44], [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/14_01_2024/request_sight_details_Viator_test_16_57_44_1705251464.json', 'v1/14_01_2024/response_sight_details_Viator_test_16_57_44_1705251464.json', 'v1/14_01_2024/response_header_sight_details_Viator_test_16_57_44_1705251464.json', 'viator', '2024-01-14 04:57:44', '', '', '915');
[01/14/2024 04:57:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:57:54' WHERE id= '297';
[01/14/2024 04:57:55], [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/14_01_2024/request_check_availability_Viator_test_16_57_54_1705251474.json', 'v1/14_01_2024/response_check_availability_Viator_test_16_57_54_1705251474.json', 'v1/14_01_2024/response_header_check_availability_Viator_test_16_57_54_1705251474.json', 'viator', '2024-01-14 04:57:55', '', '', '915');
[01/14/2024 04:57:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-14 04:57:59' WHERE id= '297';
[01/14/2024 04:57:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705251479','43.239.53.130');
