[01/31/2024 07:01:08], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:01:08' WHERE id= '483';
[01/31/2024 07:02:10], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:02:10' WHERE id= '483';
[01/31/2024 07:03:51], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-31 07:03:51',login_attempt=0 where id = '7851';
[01/31/2024 07:03:51], [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-31 07:03:51', ip = '43.239.53.130', action = 'Login' ;
[01/31/2024 07:03:51], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7851', session_id='a40814b40953e0bc97c1a435e59d32197e39e6665bad3a511ac28bf568f0c1ef',create_date='2024-01-31 07:03:51', update_date='2024-01-31 07:03:51',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/31/2024 07:03:56], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:03:56' WHERE id= '484';
[01/31/2024 07:04:00], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:04:00' WHERE id= '484';
[01/31/2024 07:04:14], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:04:14' WHERE id= '484';
[01/31/2024 07:04:14], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-31 07:04:14',login_attempt=0 where id = '7849';
[01/31/2024 07:04:14], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'shiv_qtech', user_type = 'A', branch_id = '24', login_datetime = '2024-01-31 07:04:14', ip = '43.239.53.130', action = 'Login' ;
[01/31/2024 07:04:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:04:14' WHERE id= '484';
[01/31/2024 07:04:17], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:04:17' WHERE id= '484';
[01/31/2024 07:04:21], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:04:21' WHERE id= '484';
[01/31/2024 07:04:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:04:26' WHERE id= '484';
[01/31/2024 07:04:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/09',  departure_date='2024/02/09',  nights='1',  create_date='2024-01-31 :07:04:26',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/31/2024 07:04:31], [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/31_01_2024/request_availability_shiv_qtech_07_04_26_1706684666.json', 'v1/31_01_2024/response_availability_shiv_qtech_07_04_26_1706684666.json', 'v1/31_01_2024/response_header_availability_shiv_qtech_07_04_26_1706684666.json', 'viator', '2024-01-31 07:04:31', '', '', '1234');
[01/31/2024 07:04:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:04:32' WHERE id= '484';
[01/31/2024 07:04:32], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:04:32' WHERE id= '484';
[01/31/2024 07:05:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:05:26' WHERE id= '484';
[01/31/2024 07:05:26], [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/31_01_2024/request_sight_details_shiv_qtech_07_05_26_1706684726.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_07_05_26_1706684726.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_07_05_26_1706684726.json', 'viator', '2024-01-31 07:05:26', '', '', '1234');
[01/31/2024 07:05:27], [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/31_01_2024/request_sight_details_shiv_qtech_07_05_26_1706684726.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_07_05_26_1706684726.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_07_05_26_1706684726.json', 'viator', '2024-01-31 07:05:27', '', '', '1234');
[01/31/2024 07:05:43], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:05:43' WHERE id= '484';
[01/31/2024 07:22:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:22:56' WHERE id= '484';
[01/31/2024 07:23:11], [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/31_01_2024/request_sight_details_shiv_qtech_07_22_56_1706685776.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_07_22_56_1706685776.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_07_22_56_1706685776.json', 'viator', '2024-01-31 07:23:11', '', '', '1234');
[01/31/2024 07:23:11], [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/31_01_2024/request_sight_details_shiv_qtech_07_23_11_1706685791.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_07_23_11_1706685791.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_07_23_11_1706685791.json', 'viator', '2024-01-31 07:23:11', '', '', '1234');
[01/31/2024 07:23:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:23:19' WHERE id= '484';
[01/31/2024 07:23:20], [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/31_01_2024/request_check_availability_shiv_qtech_07_23_19_1706685799.json', 'v1/31_01_2024/response_check_availability_shiv_qtech_07_23_19_1706685799.json', 'v1/31_01_2024/response_header_check_availability_shiv_qtech_07_23_19_1706685799.json', 'viator', '2024-01-31 07:23:20', '', '', '1234');
[01/31/2024 07:23:28], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:23:28' WHERE id= '484';
[01/31/2024 07:23:28], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706685808','43.239.53.130');
[01/31/2024 07:24:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:24:13' WHERE id= '484';
[01/31/2024 07:24:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/09',  departure_date='2024/02/09',  nights='1',  create_date='2024-01-31 :07:24:13',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/31/2024 07:24:20], [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/31_01_2024/request_availability_shiv_qtech_07_24_13_1706685853.json', 'v1/31_01_2024/response_availability_shiv_qtech_07_24_13_1706685853.json', 'v1/31_01_2024/response_header_availability_shiv_qtech_07_24_13_1706685853.json', 'viator', '2024-01-31 07:24:20', '', '', '1235');
[01/31/2024 07:24:21], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:24:21' WHERE id= '484';
[01/31/2024 07:24:21], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:24:21' WHERE id= '484';
[01/31/2024 07:27:17], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:27:17' WHERE id= '483';
[01/31/2024 07:27:25], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:27:25' WHERE id= '483';
[01/31/2024 07:27:52], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:27:52' WHERE id= '483';
[01/31/2024 07:28:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:28:32' WHERE id= '483';
[01/31/2024 07:31:38], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:31:38' WHERE id= '483';
[01/31/2024 07:32:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:32:19' WHERE id= '484';
[01/31/2024 07:32:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/09',  departure_date='2024/02/09',  nights='1',  create_date='2024-01-31 :07:32:19',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/31/2024 07:32:22], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:32:22' WHERE id= '483';
[01/31/2024 07:32:25], [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/31_01_2024/request_availability_shiv_qtech_07_32_19_1706686339.json', 'v1/31_01_2024/response_availability_shiv_qtech_07_32_19_1706686339.json', 'v1/31_01_2024/response_header_availability_shiv_qtech_07_32_19_1706686339.json', 'viator', '2024-01-31 07:32:25', '', '', '1236');
[01/31/2024 07:32:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:32:26' WHERE id= '484';
[01/31/2024 07:32:26], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:32:26' WHERE id= '484';
[01/31/2024 07:32:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:32:28' WHERE id= '484';
[01/31/2024 07:32:29], [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/31_01_2024/request_sight_details_shiv_qtech_07_32_28_1706686348.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_07_32_28_1706686348.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_07_32_28_1706686348.json', 'viator', '2024-01-31 07:32:29', '', '', '1236');
[01/31/2024 07:32:29], [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/31_01_2024/request_sight_details_shiv_qtech_07_32_29_1706686349.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_07_32_29_1706686349.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_07_32_29_1706686349.json', 'viator', '2024-01-31 07:32:29', '', '', '1236');
[01/31/2024 07:32:30], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:32:30' WHERE id= '483';
[01/31/2024 07:33:09], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:33:09' WHERE id= '483';
[01/31/2024 07:33:40], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:33:40' WHERE id= '483';
[01/31/2024 07:34:00], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:34:00' WHERE id= '483';
[01/31/2024 07:34:03], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:34:03' WHERE id= '483';
[01/31/2024 07:34:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:34:26' WHERE id= '484';
[01/31/2024 07:34:27], [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/31_01_2024/request_check_availability_shiv_qtech_07_34_26_1706686466.json', 'v1/31_01_2024/response_check_availability_shiv_qtech_07_34_26_1706686466.json', 'v1/31_01_2024/response_header_check_availability_shiv_qtech_07_34_26_1706686466.json', 'viator', '2024-01-31 07:34:27', '', '', '1236');
[01/31/2024 07:34:30], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:34:30' WHERE id= '484';
[01/31/2024 07:34:30], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706686470','43.239.53.130');
[01/31/2024 07:36:51], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:36:51' WHERE id= '483';
[01/31/2024 07:39:49], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:39:49' WHERE id= '483';
[01/31/2024 07:40:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:40:35' WHERE id= '483';
[01/31/2024 07:41:01], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:41:01' WHERE id= '483';
[01/31/2024 07:41:36], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:41:36' WHERE id= '483';
[01/31/2024 07:44:57], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:44:57' WHERE id= '483';
[01/31/2024 07:45:05], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:45:05' WHERE id= '483';
[01/31/2024 07:45:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:45:35' WHERE id= '483';
[01/31/2024 07:51:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:51:58' WHERE id= '483';
[01/31/2024 07:53:42], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:53:42' WHERE id= '483';
[01/31/2024 07:56:42], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:56:42' WHERE id= '483';
[01/31/2024 07:57:38], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:57:38' WHERE id= '483';
[01/31/2024 07:57:48], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 07:57:48' WHERE id= '483';
