[01/17/2024 12:00:13], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:00:13' WHERE id= '309';
[01/17/2024 12:00:13], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705492813','43.239.53.130');
[01/17/2024 12:01:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:01:37' WHERE id= '309';
[01/17/2024 12:01:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705492897','43.239.53.130');
[01/17/2024 12:02:17], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:02:17' WHERE id= '309';
[01/17/2024 12:02:17], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-17 12:02:17',login_attempt=0 where id = '7851';
[01/17/2024 12:02:17], [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-17 12:02:17', ip = '43.239.53.130', action = 'Login' ;
[01/17/2024 12:02:17], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:02:17' WHERE id= '309';
[01/17/2024 12:02:20], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:02:20' WHERE id= '309';
[01/17/2024 12:02:24], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:02:24' WHERE id= '309';
[01/17/2024 12:02:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:02:29' WHERE id= '309';
[01/17/2024 12:02:29], [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/20',  departure_date='2024/01/20',  nights='1',  create_date='2024-01-17 :12:02:29',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/17/2024 12:02:29], [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/17_01_2024/request_availability_Viator_test_12_02_29_1705492949.json', 'v1/17_01_2024/response_availability_Viator_test_12_02_29_1705492949.json', 'v1/17_01_2024/response_header_availability_Viator_test_12_02_29_1705492949.json', 'viator', '2024-01-17 12:02:29', '', '', '966');
[01/17/2024 12:02:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:02:30' WHERE id= '309';
[01/17/2024 12:02:31], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:02:31' WHERE id= '309';
[01/17/2024 12:02:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:02:33' WHERE id= '309';
[01/17/2024 12:02:34], [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/17_01_2024/request_sight_details_Viator_test_12_02_34_1705492954.json', 'v1/17_01_2024/response_sight_details_Viator_test_12_02_34_1705492954.json', 'v1/17_01_2024/response_header_sight_details_Viator_test_12_02_34_1705492954.json', 'viator', '2024-01-17 12:02:34', '', '', '966');
[01/17/2024 12:02:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:02:38' WHERE id= '309';
[01/17/2024 12:02:38], [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/17_01_2024/request_check_availability_Viator_test_12_02_38_1705492958.json', 'v1/17_01_2024/response_check_availability_Viator_test_12_02_38_1705492958.json', 'v1/17_01_2024/response_header_check_availability_Viator_test_12_02_38_1705492958.json', 'viator', '2024-01-17 12:02:38', '', '', '966');
[01/17/2024 12:02:41], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:02:41' WHERE id= '309';
[01/17/2024 12:02:41], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705492961','43.239.53.130');
[01/17/2024 12:03:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:03:03' WHERE id= '309';
[01/17/2024 12:03:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705492983','43.239.53.130');
[01/17/2024 12:03:06], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:03:06' WHERE id= '309';
[01/17/2024 12:03:06], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705492986','43.239.53.130');
[01/17/2024 12:03:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:03:32' WHERE id= '309';
[01/17/2024 12:03:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493012','43.239.53.130');
[01/17/2024 12:03:50], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:03:50' WHERE id= '309';
[01/17/2024 12:03:50], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493030','43.239.53.130');
[01/17/2024 12:05:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:05:57' WHERE id= '309';
[01/17/2024 12:05:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493157','43.239.53.130');
[01/17/2024 12:07:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:07:20' WHERE id= '309';
[01/17/2024 12:07:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493240','43.239.53.130');
[01/17/2024 12:07:31], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:07:31' WHERE id= '309';
[01/17/2024 12:07:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493252','43.239.53.130');
[01/17/2024 12:07:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:07:51' WHERE id= '309';
[01/17/2024 12:07:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493271','43.239.53.130');
[01/17/2024 12:08:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:08:06' WHERE id= '309';
[01/17/2024 12:08:06], [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/20',  departure_date='2024/01/20',  nights='1',  create_date='2024-01-17 :12:08:06',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/17/2024 12:08:06], [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/17_01_2024/request_availability_Viator_test_12_08_06_1705493286.json', 'v1/17_01_2024/response_availability_Viator_test_12_08_06_1705493286.json', 'v1/17_01_2024/response_header_availability_Viator_test_12_08_06_1705493286.json', 'viator', '2024-01-17 12:08:06', '', '', '967');
[01/17/2024 12:08:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:08:08' WHERE id= '309';
[01/17/2024 12:08:08], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:08:08' WHERE id= '309';
[01/17/2024 12:08:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:08:14' WHERE id= '309';
[01/17/2024 12:08:14], [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/17_01_2024/request_sight_details_Viator_test_12_08_14_1705493294.json', 'v1/17_01_2024/response_sight_details_Viator_test_12_08_14_1705493294.json', 'v1/17_01_2024/response_header_sight_details_Viator_test_12_08_14_1705493294.json', 'viator', '2024-01-17 12:08:14', '', '', '967');
[01/17/2024 12:08:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:08:17' WHERE id= '309';
[01/17/2024 12:08: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/17_01_2024/request_check_availability_Viator_test_12_08_17_1705493297.json', 'v1/17_01_2024/response_check_availability_Viator_test_12_08_17_1705493297.json', 'v1/17_01_2024/response_header_check_availability_Viator_test_12_08_17_1705493297.json', 'viator', '2024-01-17 12:08:18', '', '', '967');
[01/17/2024 12:08:22], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:08:22' WHERE id= '309';
[01/17/2024 12:08:22], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493302','43.239.53.130');
[01/17/2024 12:08:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:08:49' WHERE id= '309';
[01/17/2024 12:08:50], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493330','43.239.53.130');
[01/17/2024 12:10:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:10:27' WHERE id= '309';
[01/17/2024 12:10:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493427','43.239.53.130');
[01/17/2024 12:11:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:11:20' WHERE id= '309';
[01/17/2024 12:11:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493480','43.239.53.130');
[01/17/2024 12:11:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:11:43' WHERE id= '309';
[01/17/2024 12:11:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493503','43.239.53.130');
[01/17/2024 12:12:05], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:12:05' WHERE id= '309';
[01/17/2024 12:12:05], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-17 12:12:05',login_attempt=0 where id = '7851';
[01/17/2024 12:12:05], [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-17 12:12:05', ip = '43.239.53.130', action = 'Login' ;
[01/17/2024 12:12:06], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:12:06' WHERE id= '309';
[01/17/2024 12:12:15], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:12:15' WHERE id= '309';
[01/17/2024 12:12:22], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:12:22' WHERE id= '309';
[01/17/2024 12:12:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:12:33' WHERE id= '309';
[01/17/2024 12:12:33], [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/20',  departure_date='2024/01/20',  nights='1',  create_date='2024-01-17 :12:12:33',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/17/2024 12:12:36], [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/17_01_2024/request_availability_Viator_test_12_12_33_1705493553.json', 'v1/17_01_2024/response_availability_Viator_test_12_12_33_1705493553.json', 'v1/17_01_2024/response_header_availability_Viator_test_12_12_33_1705493553.json', 'viator', '2024-01-17 12:12:36', '', '', '968');
[01/17/2024 12:12:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:12:37' WHERE id= '309';
[01/17/2024 12:12:38], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:12:38' WHERE id= '309';
[01/17/2024 12:12:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:12:44' WHERE id= '309';
[01/17/2024 12:12: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/17_01_2024/request_sight_details_Viator_test_12_12_44_1705493564.json', 'v1/17_01_2024/response_sight_details_Viator_test_12_12_44_1705493564.json', 'v1/17_01_2024/response_header_sight_details_Viator_test_12_12_44_1705493564.json', 'viator', '2024-01-17 12:12:44', '', '', '968');
[01/17/2024 12:12:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:12:49' WHERE id= '309';
[01/17/2024 12:12:49], [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/17_01_2024/request_check_availability_Viator_test_12_12_49_1705493569.json', 'v1/17_01_2024/response_check_availability_Viator_test_12_12_49_1705493569.json', 'v1/17_01_2024/response_header_check_availability_Viator_test_12_12_49_1705493569.json', 'viator', '2024-01-17 12:12:49', '', '', '968');
[01/17/2024 12:12:52], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:12:52' WHERE id= '309';
[01/17/2024 12:12:52], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493572','43.239.53.130');
[01/17/2024 12:13:28], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:13:28' WHERE id= '309';
[01/17/2024 12:13:28], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493608','43.239.53.130');
[01/17/2024 12:13:58], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:13:58' WHERE id= '309';
[01/17/2024 12:13:58], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493638','43.239.53.130');
[01/17/2024 12:16:08], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:16:08' WHERE id= '309';
[01/17/2024 12:16:08], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493768','43.239.53.130');
[01/17/2024 12:19:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:19:23' WHERE id= '309';
[01/17/2024 12:19:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705493963','43.239.53.130');
[01/17/2024 12:21:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:21:40' WHERE id= '309';
[01/17/2024 12:21:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705494100','43.239.53.130');
[01/17/2024 12:22:30], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:22:30' WHERE id= '309';
[01/17/2024 12:22:30], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705494150','43.239.53.130');
[01/17/2024 12:24:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:24:40' WHERE id= '309';
[01/17/2024 12:24:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705494280','43.239.53.130');
[01/17/2024 12:26:33], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:26:33' WHERE id= '309';
[01/17/2024 12:26:33], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705494393','43.239.53.130');
[01/17/2024 12:27:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:27:35' WHERE id= '309';
[01/17/2024 12:27:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705494455','43.239.53.130');
[01/17/2024 12:29:06], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:29:06' WHERE id= '309';
[01/17/2024 12:29:06], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705494546','43.239.53.130');
[01/17/2024 12:29:47], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:29:47' WHERE id= '309';
[01/17/2024 12:29:47], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705494587','43.239.53.130');
[01/17/2024 12:37:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:37:20' WHERE id= '309';
[01/17/2024 12:37:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705495040','43.239.53.130');
[01/17/2024 12:37:31], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:37:31' WHERE id= '309';
[01/17/2024 12:37:31], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-17 12:37:31',login_attempt=0 where id = '7851';
[01/17/2024 12:37:31], [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-17 12:37:31', ip = '43.239.53.130', action = 'Login' ;
[01/17/2024 12:37:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:37:32' WHERE id= '309';
[01/17/2024 12:37:34], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:37:34' WHERE id= '309';
[01/17/2024 12:37:37], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:37:37' WHERE id= '309';
[01/17/2024 12:37:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:37:41' WHERE id= '309';
[01/17/2024 12:37:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:37:41' WHERE id= '309';
[01/17/2024 12:37:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:37:46' WHERE id= '309';
[01/17/2024 12:37:47], [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/20',  departure_date='2024/01/20',  nights='1',  create_date='2024-01-17 :12:37:47',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/17/2024 12:37:50], [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/17_01_2024/request_availability_Viator_test_12_37_47_1705495067.json', 'v1/17_01_2024/response_availability_Viator_test_12_37_47_1705495067.json', 'v1/17_01_2024/response_header_availability_Viator_test_12_37_47_1705495067.json', 'viator', '2024-01-17 12:37:50', '', '', '969');
[01/17/2024 12:37:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:37:52' WHERE id= '309';
[01/17/2024 12:37:52], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:37:52' WHERE id= '309';
[01/17/2024 12:37:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:37:58' WHERE id= '309';
[01/17/2024 12:37:58], [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/17_01_2024/request_sight_details_Viator_test_12_37_58_1705495078.json', 'v1/17_01_2024/response_sight_details_Viator_test_12_37_58_1705495078.json', 'v1/17_01_2024/response_header_sight_details_Viator_test_12_37_58_1705495078.json', 'viator', '2024-01-17 12:37:58', '', '', '969');
[01/17/2024 12:38:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:38:01' WHERE id= '309';
[01/17/2024 12:38:02], [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/17_01_2024/request_check_availability_Viator_test_12_38_01_1705495081.json', 'v1/17_01_2024/response_check_availability_Viator_test_12_38_01_1705495081.json', 'v1/17_01_2024/response_header_check_availability_Viator_test_12_38_01_1705495081.json', 'viator', '2024-01-17 12:38:02', '', '', '969');
[01/17/2024 12:38:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:38:03' WHERE id= '309';
[01/17/2024 12:38:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705495083','43.239.53.130');
[01/17/2024 12:39:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:39:10' WHERE id= '309';
[01/17/2024 12:39:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705495150','43.239.53.130');
[01/17/2024 12:42:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:42:21' WHERE id= '309';
[01/17/2024 12:42:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705495341','43.239.53.130');
[01/17/2024 12:44:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:44:02' WHERE id= '309';
[01/17/2024 12:44:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705495442','43.239.53.130');
[01/17/2024 12:45:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:45:48' WHERE id= '309';
[01/17/2024 12:45:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705495548','43.239.53.130');
[01/17/2024 12:46:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:46:23' WHERE id= '309';
[01/17/2024 12:46:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705495583','43.239.53.130');
[01/17/2024 12:47:25], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:47:25' WHERE id= '309';
[01/17/2024 12:47:25], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705495645','43.239.53.130');
[01/17/2024 12:53:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 12:53:02' WHERE id= '309';
[01/17/2024 12:53:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705495982','43.239.53.130');
[01/17/2024 12:59:51], [file name :-/home/otrams/public_html/beta/tms/currency.php],UPDATE currency_map SET exchange_markup='1' WHERE from_c='11' AND to_c='11';
[01/17/2024 12:59:51], [file name :-/home/otrams/public_html/beta/tms/currency.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-17 12:59:51',`log_type`= 'Currency Exchange Markup Updated',`sql_query`= 'UPDATE currency_map SET exchange_markup=1 WHERE from_c=\&#039;11\&#039; AND to_c=\&#039;11\&#039;',`log_description`= 'Currency Exchange Markup From AED To AED Has Been Changed From 0% To 1%',`ip`= '43.239.53.130';
