[02/21/2024 05:01:16], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:01:16' WHERE id= '573';
[02/21/2024 05:01:23], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:01:23' WHERE id= '573';
[02/21/2024 05:01:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:01:27' WHERE id= '573';
[02/21/2024 05:01:34], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:01:34' WHERE id= '573';
[02/21/2024 05:01:35], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:01:35' WHERE id= '573';
[02/21/2024 05:01:36], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:01:36' WHERE id= '573';
[02/21/2024 05:01:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:01:38' WHERE id= '573';
[02/21/2024 05:01:39], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:01:39' WHERE id= '573';
[02/21/2024 05:01:44], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:01:44' WHERE id= '573';
[02/21/2024 05:04:45], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:04:45' WHERE id= '573';
[02/21/2024 05:04:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:04:46' WHERE id= '573';
[02/21/2024 05:04:46], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:04:46' WHERE id= '573';
[02/21/2024 05:05:03], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:05:03' WHERE id= '573';
[02/21/2024 05:05:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:05:07' WHERE id= '573';
[02/21/2024 05:05:07], [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 = 'lucca' , arrival_date='2024/04/25',  departure_date='2024/04/25',  nights='1',  create_date='2024-02-21 :05:05:07',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 05:05:08], [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/21_02_2024/request_availability_Viator_test_05_05_07_1708491907.json', 'v1/21_02_2024/response_availability_Viator_test_05_05_07_1708491907.json', 'v1/21_02_2024/response_header_availability_Viator_test_05_05_07_1708491907.json', 'viator', '2024-02-21 05:05:08', '', '', '1680');
[02/21/2024 05:05:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:05:09' WHERE id= '573';
[02/21/2024 05:05:09], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:05:09' WHERE id= '573';
[02/21/2024 05:05:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:05:13' WHERE id= '573';
[02/21/2024 05:05: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/21_02_2024/request_sight_details_Viator_test_05_05_13_1708491913.json', 'v1/21_02_2024/response_sight_details_Viator_test_05_05_13_1708491913.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_05_05_13_1708491913.json', 'viator', '2024-02-21 05:05:13', '', '', '1680');
[02/21/2024 05:05: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/21_02_2024/request_sight_details_Viator_test_05_05_13_1708491913.json', 'v1/21_02_2024/response_sight_details_Viator_test_05_05_13_1708491913.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_05_05_13_1708491913.json', 'viator', '2024-02-21 05:05:14', '', '', '1680');
[02/21/2024 05:05:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:05:36' WHERE id= '573';
[02/21/2024 05:05:36], [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/21_02_2024/request_check_availability_Viator_test_05_05_36_1708491936.json', 'v1/21_02_2024/response_check_availability_Viator_test_05_05_36_1708491936.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_05_05_36_1708491936.json', 'viator', '2024-02-21 05:05:36', '', '', '1680');
[02/21/2024 05:05:38], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:05:38' WHERE id= '573';
[02/21/2024 05:05:38], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708491938','43.239.53.130');
[02/21/2024 05:06:01], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:06:01' WHERE id= '573';
[02/21/2024 05:06:02], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:06:02' WHERE id= '573';
[02/21/2024 05:07:27], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 05:07:27',login_attempt=0 where id = '7870';
[02/21/2024 05:07:27], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-21 05:07:27', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 05:07:28], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='91565b21724c7e1ea7724ee5bd87be9192bea5fb2996758c257dce4380667c69',create_date='2024-02-21 05:07:28', update_date='2024-02-21 05:07:28',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/21/2024 05:07:46], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:07:46' WHERE id= '578';
[02/21/2024 05:07:49], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:07:49' WHERE id= '578';
[02/21/2024 05:07:50], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:07:50' WHERE id= '578';
[02/21/2024 05:07:51], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:07:51' WHERE id= '578';
[02/21/2024 05:07:54], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:07:54' WHERE id= '578';
[02/21/2024 05:07:54], [file name :-/home/otrams/public_html/beta/quotation.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:07:54' WHERE id= '578';
[02/21/2024 05:07:59], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:07:59' WHERE id= '578';
[02/21/2024 05:08:02], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:08:02' WHERE id= '578';
[02/21/2024 05:08:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:08:12' WHERE id= '578';
[02/21/2024 05:11:17], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:11:17' WHERE id= '578';
[02/21/2024 05:11:22], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:11:22' WHERE id= '578';
[02/21/2024 05:11:26], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:11:26' WHERE id= '578';
[02/21/2024 05:11:42], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:11:42' WHERE id= '578';
[02/21/2024 05:11:42], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 05:11:42',login_attempt=0 where id = '7870';
[02/21/2024 05:11:42], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-21 05:11:42', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 05:11:42], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:11:42' WHERE id= '578';
[02/21/2024 05:11:48], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:11:48' WHERE id= '578';
[02/21/2024 05:11:48], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 05:11:48',login_attempt=0 where id = '7870';
[02/21/2024 05:11:48], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-21 05:11:48', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 05:11:48], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:11:48' WHERE id= '578';
[02/21/2024 05:11:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:11:58' WHERE id= '578';
[02/21/2024 05:13:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:13:42' WHERE id= '573';
[02/21/2024 05:13:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708492422','43.239.53.130');
[02/21/2024 05:14:03], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:14:03' WHERE id= '573';
[02/21/2024 05:14:04], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:14:04' WHERE id= '573';
[02/21/2024 05:14:07], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:14:07' WHERE id= '573';
[02/21/2024 05:14:08], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:14:08' WHERE id= '573';
[02/21/2024 05:20:07], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:20:07' WHERE id= '578';
[02/21/2024 05:20:09], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:20:09' WHERE id= '578';
[02/21/2024 05:20:10], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:20:10' WHERE id= '578';
[02/21/2024 05:23:58], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 05:23:58',login_attempt=0 where id = '7870';
[02/21/2024 05:23:58], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-21 05:23:58', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 05:23:59], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 43.239.53.130') WHERE id= '575';
[02/21/2024 05:24:25], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 05:24:25',login_attempt=0 where id = '7870';
[02/21/2024 05:24:25], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-21 05:24:25', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 05:24:25], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='a6d058a48a997c433c73f91ab2be80df6ad331da0fae0a00d09b716041281426',create_date='2024-02-21 05:24:25', update_date='2024-02-21 05:24:25',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/21/2024 05:24:32], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:24:32' WHERE id= '579';
[02/21/2024 05:24:36], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:24:36' WHERE id= '579';
[02/21/2024 05:25:13], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 05:25:13',login_attempt=0 where id = '7866';
[02/21/2024 05:25:13], [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-02-21 05:25:13', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 05:25:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='72cefffe55365ee44db3eca826685f7548a65d4106068fbb936d567cf282b3f4',create_date='2024-02-21 05:25:13', update_date='2024-02-21 05:25:13',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/21/2024 05:25:18], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:25:18' WHERE id= '580';
[02/21/2024 05:29:31], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 05:29:31',login_attempt=0 where id = '7865';
[02/21/2024 05:29:31], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2024-02-21 05:29:31', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 05:29:31], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='a094fc4eabd1dd70bce46d0529c6dda45249481a03ae1938b63dcad0a587baf1',create_date='2024-02-21 05:29:31', update_date='2024-02-21 05:29:31',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/21/2024 05:29:35], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:29:35' WHERE id= '581';
[02/21/2024 05:31:35], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:31:35' WHERE id= '580';
[02/21/2024 05:31:35], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:31:35' WHERE id= '580';
[02/21/2024 05:31:36], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:31:36' WHERE id= '580';
[02/21/2024 05:31:37], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:31:37' WHERE id= '580';
[02/21/2024 05:31:38], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:31:38' WHERE id= '580';
[02/21/2024 05:31:48], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:31:48' WHERE id= '579';
[02/21/2024 05:32:29], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:32:29' WHERE id= '579';
[02/21/2024 05:37:19], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:37:19' WHERE id= '579';
[02/21/2024 05:37:23], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:37:23' WHERE id= '579';
[02/21/2024 05:37:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:37:32' WHERE id= '579';
[02/21/2024 05:37:42], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:37:42' WHERE id= '579';
[02/21/2024 05:38:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:38:13' WHERE id= '579';
[02/21/2024 05:38:19], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:38:19' WHERE id= '579';
[02/21/2024 05:42:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:42:13' WHERE id= '579';
[02/21/2024 05:42:18], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:42:18' WHERE id= '579';
[02/21/2024 05:43:11], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:43:11' WHERE id= '579';
[02/21/2024 05:43:16], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:43:16' WHERE id= '579';
[02/21/2024 05:43:40], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:43:40' WHERE id= '579';
[02/21/2024 05:43:45], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:43:45' WHERE id= '579';
[02/21/2024 05:44:10], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:44:10' WHERE id= '579';
[02/21/2024 05:44:16], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:44:16' WHERE id= '579';
[02/21/2024 05:44:39], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:44:39' WHERE id= '579';
[02/21/2024 05:44:43], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:44:43' WHERE id= '579';
[02/21/2024 05:47:25], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 05:47:25',login_attempt=0 where id = '7869';
[02/21/2024 05:47:25], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-02-21 05:47:25', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 05:47:25], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7869', session_id='00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9',create_date='2024-02-21 05:47:25', update_date='2024-02-21 05:47:25',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/21/2024 05:48:22], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:22' WHERE id= '582';
[02/21/2024 05:48:34], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 05:48:34',login_attempt=0 where id = '7849';
[02/21/2024 05:48:34], [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-02-21 05:48:34', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 05:48:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7849', session_id='538fd14c2cb5cbbcdd91182d0575134fae1c655c53b816d6ebcec372c557e9be',create_date='2024-02-21 05:48:35', update_date='2024-02-21 05:48:35',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/21/2024 05:48:37], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:37' WHERE id= '582';
[02/21/2024 05:48:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:38' WHERE id= '582';
[02/21/2024 05:48:39], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:39' WHERE id= '583';
[02/21/2024 05:48:44], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:44' WHERE id= '583';
[02/21/2024 05:48:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:47' WHERE id= '582';
[02/21/2024 05:48:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'mumbai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-21 :05:48:47',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 05:48:47], [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/21_02_2024/request_availability_Viator_05_48_47_1708494527.json', 'v1/21_02_2024/response_availability_Viator_05_48_47_1708494527.json', 'v1/21_02_2024/response_header_availability_Viator_05_48_47_1708494527.json', 'viator', '2024-02-21 05:48:47', '', '', '1681');
[02/21/2024 05:48:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:47' WHERE id= '583';
[02/21/2024 05:48:47], [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/29',  departure_date='2024/02/29',  nights='1',  create_date='2024-02-21 :05:48:47',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 05: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/21_02_2024/request_availability_shiv_qtech_05_48_47_1708494527.json', 'v1/21_02_2024/response_availability_shiv_qtech_05_48_47_1708494527.json', 'v1/21_02_2024/response_header_availability_shiv_qtech_05_48_47_1708494527.json', 'viator', '2024-02-21 05:48:48', '', '', '1682');
[02/21/2024 05:48:49], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:49' WHERE id= '582';
[02/21/2024 05:48:49], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:49' WHERE id= '582';
[02/21/2024 05:48:49], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:49' WHERE id= '583';
[02/21/2024 05:48:49], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:49' WHERE id= '583';
[02/21/2024 05:48:51], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:51' WHERE id= '583';
[02/21/2024 05:48:51], [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/21_02_2024/request_sight_details_shiv_qtech_05_48_51_1708494531.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_05_48_51_1708494531.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_05_48_51_1708494531.json', 'viator', '2024-02-21 05:48:51', '', '', '1682');
[02/21/2024 05:48: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/21_02_2024/request_sight_details_shiv_qtech_05_48_51_1708494531.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_05_48_51_1708494531.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_05_48_51_1708494531.json', 'viator', '2024-02-21 05:48:52', '', '', '1682');
[02/21/2024 05:48:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:53' WHERE id= '583';
[02/21/2024 05:48:53], [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/21_02_2024/request_check_availability_shiv_qtech_05_48_53_1708494533.json', 'v1/21_02_2024/response_check_availability_shiv_qtech_05_48_53_1708494533.json', 'v1/21_02_2024/response_header_check_availability_shiv_qtech_05_48_53_1708494533.json', 'viator', '2024-02-21 05:48:53', '', '', '1682');
[02/21/2024 05:48:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:48:54' WHERE id= '582';
[02/21/2024 05:48:54], [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/21_02_2024/request_sight_details_Viator_05_48_54_1708494534.json', 'v1/21_02_2024/response_sight_details_Viator_05_48_54_1708494534.json', 'v1/21_02_2024/response_header_sight_details_Viator_05_48_54_1708494534.json', 'viator', '2024-02-21 05:48:54', '', '', '1681');
[02/21/2024 05: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/21_02_2024/request_sight_details_Viator_05_48_54_1708494534.json', 'v1/21_02_2024/response_sight_details_Viator_05_48_54_1708494534.json', 'v1/21_02_2024/response_header_sight_details_Viator_05_48_54_1708494534.json', 'viator', '2024-02-21 05:48:55', '', '', '1681');
[02/21/2024 05:49:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:49:01' WHERE id= '583';
[02/21/2024 05:49:01], [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/21_02_2024/request_check_availability_shiv_qtech_05_49_01_1708494541.json', 'v1/21_02_2024/response_check_availability_shiv_qtech_05_49_01_1708494541.json', 'v1/21_02_2024/response_header_check_availability_shiv_qtech_05_49_01_1708494541.json', 'viator', '2024-02-21 05:49:01', '', '', '1682');
[02/21/2024 05:49:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:49:08' WHERE id= '582';
[02/21/2024 05:49:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:49:09' WHERE id= '583';
[02/21/2024 05:49:09], [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/21_02_2024/request_sight_details_shiv_qtech_05_49_09_1708494549.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_05_49_09_1708494549.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_05_49_09_1708494549.json', 'viator', '2024-02-21 05:49:09', '', '', '1682');
[02/21/2024 05:49:10], [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/21_02_2024/request_sight_details_shiv_qtech_05_49_09_1708494549.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_05_49_09_1708494549.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_05_49_09_1708494549.json', 'viator', '2024-02-21 05:49:10', '', '', '1682');
[02/21/2024 05:49:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:49:10' WHERE id= '583';
[02/21/2024 05:49:10], [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/21_02_2024/request_check_availability_shiv_qtech_05_49_10_1708494550.json', 'v1/21_02_2024/response_check_availability_shiv_qtech_05_49_10_1708494550.json', 'v1/21_02_2024/response_header_check_availability_shiv_qtech_05_49_10_1708494550.json', 'viator', '2024-02-21 05:49:10', '', '', '1682');
[02/21/2024 05:49:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:49:15' WHERE id= '583';
[02/21/2024 05:49:15], [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/21_02_2024/request_check_availability_shiv_qtech_05_49_15_1708494555.json', 'v1/21_02_2024/response_check_availability_shiv_qtech_05_49_15_1708494555.json', 'v1/21_02_2024/response_header_check_availability_shiv_qtech_05_49_15_1708494555.json', 'viator', '2024-02-21 05:49:15', '', '', '1682');
[02/21/2024 05:49:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:49:20' WHERE id= '583';
[02/21/2024 05:49:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708494560','43.239.53.130');
[02/21/2024 05:49:45], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:49:45' WHERE id= '583';
[02/21/2024 05:49:47], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:49:47' WHERE id= '583';
[02/21/2024 05:50:03], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:03' WHERE id= '583';
[02/21/2024 05:50:05], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:05' WHERE id= '583';
[02/21/2024 05:50:05], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708494605','43.239.53.130');
[02/21/2024 05:50:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:07' WHERE id= '583';
[02/21/2024 05:50:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2968',agent_id='7849',leader_title='Mr',leader_first_name='sddas',leader_last_name='asdsad',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='233721.78',display_currency_code='INR',native_room_rate='3716.73',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 27 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 233721.78  applicable if cancelled after 27 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-21 05:50:07',source_type='viator',expiration_date= '2024-02-27 00:00:00',applied_multiplier='60.1758',applied_markup='4.5000026826769',agent_markup='4.5000026826769',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-02-29',sub_user_id='',check_out_date='2024-02-29',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 03678957422',email_id='priyanka.kolte@qtechsoftware.com',service_type='sightseeing';
[02/21/2024 05:50:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='476',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:3716.73;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:233721.78;s:25:\"displayNightlyRateDisplay\";s:147:\"Rate - 3716.73 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - 4.50%, Markup Amount - 0, Markup Amount in SAR - 0.00,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:148:\"Rate - 3716.73 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - 4.50%, Markup Amount - 0, Markup Amount in SAR - 0.00 ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-02-29',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/21/2024 05:50:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','2968','2024-02-21 05:50:07',0);
[02/21/2024 05:50:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation_sight', 'v1/21_02_2024/request_reservation_sight_shiv_qtech_05_50_07_1708494607.json', 'v1/21_02_2024/response_reservation_sight_shiv_qtech_05_50_07_1708494607.json', 'v1/21_02_2024/response_header_reservation_sight_shiv_qtech_05_50_07_1708494607.json', 'viator', '2024-02-21 05:50:08', '', '', '1682');
[02/21/2024 05:50:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '291';
[02/21/2024 05:50:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7849', applicable_service_tax='0', sub_agent_rate='0', agent_rate='233721.78', supplier_rate='3716.73', uid='', itenirary_id='', confirmation_number='', comment_contract='', current_status='failed', original_source='' where id='476';
[02/21/2024 05:50:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',tour_supplier='',textaddition_activities='N;' where booking_id='476';
[02/21/2024 05:50:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','476','failed','2024-02-21 05:50:08','Sightseeing Booking failed by Agent..7849','7849','43.239.53.130','','','');
[02/21/2024 05:50:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('476','Mr','1','sddas','asdsad','adult','0');
[02/21/2024 05:50:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('476','Mr','1','priyanka','test','adult','0');
[02/21/2024 05:50:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='476' where agent_logs_id='1682' and source_type='viator';
[02/21/2024 05:50:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:14' WHERE id= '583';
[02/21/2024 05:50:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708494614','43.239.53.130');
[02/21/2024 05:50:14], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:14' WHERE id= '583';
[02/21/2024 05:50:14], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 05:50:14',login_attempt=0 where id = '7849';
[02/21/2024 05:50: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-02-21 05:50:14', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 05:50:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:14' WHERE id= '583';
[02/21/2024 05:50:19], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:19' WHERE id= '583';
[02/21/2024 05:50:31], [file name :-/home/otrams/public_html/beta/tms/view_booking_sight.php],UPDATE bookings set current_status='rejected', status_date='2024-02-21 05:50:31' where id='476' and current_status='on_request' and service_type ='sightseeing';
[02/21/2024 05:50:31], [file name :-/home/otrams/public_html/beta/tms/view_booking_sight.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','476','rejected','2024-02-21 05:50:31','Admin Rejected by v3alpha','v3alpha','43.239.53.130','v3alpha','','');
[02/21/2024 05:50:38], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:38' WHERE id= '583';
[02/21/2024 05:50:44], [file name :-/home/otrams/public_html/beta/tms/view_booking_sight.php],UPDATE bookings set current_status='rejected', status_date='2024-02-21 05:50:44' where id='476' and current_status='on_request' and service_type ='sightseeing';
[02/21/2024 05:50:44], [file name :-/home/otrams/public_html/beta/tms/view_booking_sight.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','476','rejected','2024-02-21 05:50:44','Admin Rejected by v3alpha','v3alpha','43.239.53.130','v3alpha','','');
[02/21/2024 05:50:51], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:51' WHERE id= '583';
[02/21/2024 05:50:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:55' WHERE id= '583';
[02/21/2024 05:50:55], [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/29',  departure_date='2024/02/29',  nights='1',  create_date='2024-02-21 :05:50:55',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 05:50:55], [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/21_02_2024/request_availability_shiv_qtech_05_50_55_1708494655.json', 'v1/21_02_2024/response_availability_shiv_qtech_05_50_55_1708494655.json', 'v1/21_02_2024/response_header_availability_shiv_qtech_05_50_55_1708494655.json', 'viator', '2024-02-21 05:50:55', '', '', '1683');
[02/21/2024 05:50:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:57' WHERE id= '583';
[02/21/2024 05:50:57], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:50:57' WHERE id= '583';
[02/21/2024 05:51:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:51:00' WHERE id= '583';
[02/21/2024 05:51:01], [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/21_02_2024/request_sight_details_shiv_qtech_05_51_00_1708494660.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_05_51_00_1708494660.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_05_51_00_1708494660.json', 'viator', '2024-02-21 05:51:01', '', '', '1683');
[02/21/2024 05:51:01], [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/21_02_2024/request_sight_details_shiv_qtech_05_51_01_1708494661.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_05_51_01_1708494661.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_05_51_01_1708494661.json', 'viator', '2024-02-21 05:51:01', '', '', '1683');
[02/21/2024 05:51:05], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:51:05' WHERE id= '583';
[02/21/2024 05:51:05], [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/21_02_2024/request_sight_details_shiv_qtech_05_51_05_1708494665.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_05_51_05_1708494665.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_05_51_05_1708494665.json', 'viator', '2024-02-21 05:51:05', '', '', '1683');
[02/21/2024 05:51: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 ('', 'sight_details', 'v1/21_02_2024/request_sight_details_shiv_qtech_05_51_05_1708494665.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_05_51_05_1708494665.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_05_51_05_1708494665.json', 'viator', '2024-02-21 05:51:06', '', '', '1683');
[02/21/2024 05:51:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:51:08' WHERE id= '583';
[02/21/2024 05:51:09], [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/21_02_2024/request_sight_details_shiv_qtech_05_51_08_1708494668.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_05_51_08_1708494668.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_05_51_08_1708494668.json', 'viator', '2024-02-21 05:51:09', '', '', '1683');
[02/21/2024 05:51:09], [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/21_02_2024/request_sight_details_shiv_qtech_05_51_09_1708494669.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_05_51_09_1708494669.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_05_51_09_1708494669.json', 'viator', '2024-02-21 05:51:09', '', '', '1683');
[02/21/2024 05:51:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:51:13' WHERE id= '583';
[02/21/2024 05:51: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 ('', 'check_availability', 'v1/21_02_2024/request_check_availability_shiv_qtech_05_51_13_1708494673.json', 'v1/21_02_2024/response_check_availability_shiv_qtech_05_51_13_1708494673.json', 'v1/21_02_2024/response_header_check_availability_shiv_qtech_05_51_13_1708494673.json', 'viator', '2024-02-21 05:51:14', '', '', '1683');
[02/21/2024 05:51:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:51:20' WHERE id= '583';
[02/21/2024 05:51: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/21_02_2024/request_check_availability_shiv_qtech_05_51_20_1708494680.json', 'v1/21_02_2024/response_check_availability_shiv_qtech_05_51_20_1708494680.json', 'v1/21_02_2024/response_header_check_availability_shiv_qtech_05_51_20_1708494680.json', 'viator', '2024-02-21 05:51:20', '', '', '1683');
[02/21/2024 05:51:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:51:43' WHERE id= '583';
[02/21/2024 05:51:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708494703','43.239.53.130');
[02/21/2024 05:53:27], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 05:53:27',login_attempt=0 where id = '7851';
[02/21/2024 05:53:27], [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-02-21 05:53:27', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 05:53:28], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:53:28' WHERE id= '573';
[02/21/2024 05:53:31], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:53:31' WHERE id= '573';
[02/21/2024 05:53:36], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:53:36' WHERE id= '573';
[02/21/2024 05:53:39], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:53:39' WHERE id= '573';
[02/21/2024 05:53:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:53:46' WHERE id= '573';
[02/21/2024 05:53:46], [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 = 'lucca' , arrival_date='2024/04/25',  departure_date='2024/04/25',  nights='1',  create_date='2024-02-21 :05:53:46',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 05:53:47], [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/21_02_2024/request_availability_Viator_test_05_53_46_1708494826.json', 'v1/21_02_2024/response_availability_Viator_test_05_53_46_1708494826.json', 'v1/21_02_2024/response_header_availability_Viator_test_05_53_46_1708494826.json', 'viator', '2024-02-21 05:53:47', '', '', '1684');
[02/21/2024 05:53:48], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:53:48' WHERE id= '573';
[02/21/2024 05:53:48], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:53:48' WHERE id= '573';
[02/21/2024 05:54:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:54:00' WHERE id= '573';
[02/21/2024 05:54:01], [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/21_02_2024/request_sight_details_Viator_test_05_54_00_1708494840.json', 'v1/21_02_2024/response_sight_details_Viator_test_05_54_00_1708494840.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_05_54_00_1708494840.json', 'viator', '2024-02-21 05:54:01', '', '', '1684');
[02/21/2024 05:54:01], [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/21_02_2024/request_sight_details_Viator_test_05_54_01_1708494841.json', 'v1/21_02_2024/response_sight_details_Viator_test_05_54_01_1708494841.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_05_54_01_1708494841.json', 'viator', '2024-02-21 05:54:01', '', '', '1684');
[02/21/2024 05:54:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:54:16' WHERE id= '573';
[02/21/2024 05:54: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/21_02_2024/request_check_availability_Viator_test_05_54_16_1708494856.json', 'v1/21_02_2024/response_check_availability_Viator_test_05_54_16_1708494856.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_05_54_16_1708494856.json', 'viator', '2024-02-21 05:54:16', '', '', '1684');
[02/21/2024 05:54:18], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:54:18' WHERE id= '573';
[02/21/2024 05:54:18], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708494858','43.239.53.130');
[02/21/2024 05:54:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:54:42' WHERE id= '573';
[02/21/2024 05:54:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:54:44' WHERE id= '573';
[02/21/2024 05:54:44], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:54:44' WHERE id= '573';
[02/21/2024 05:54:47], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:54:47' WHERE id= '573';
[02/21/2024 05:54:47], [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/21_02_2024/request_sight_details_Viator_test_05_54_47_1708494887.json', 'v1/21_02_2024/response_sight_details_Viator_test_05_54_47_1708494887.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_05_54_47_1708494887.json', 'viator', '2024-02-21 05:54:47', '', '', '1684');
[02/21/2024 05:54:47], [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/21_02_2024/request_sight_details_Viator_test_05_54_47_1708494887.json', 'v1/21_02_2024/response_sight_details_Viator_test_05_54_47_1708494887.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_05_54_47_1708494887.json', 'viator', '2024-02-21 05:54:47', '', '', '1684');
[02/21/2024 05:54:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:54:55' WHERE id= '573';
[02/21/2024 05:54: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 ('', 'check_availability', 'v1/21_02_2024/request_check_availability_Viator_test_05_54_55_1708494895.json', 'v1/21_02_2024/response_check_availability_Viator_test_05_54_55_1708494895.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_05_54_55_1708494895.json', 'viator', '2024-02-21 05:54:56', '', '', '1684');
[02/21/2024 05:54:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:54:57' WHERE id= '573';
[02/21/2024 05:54:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708494897','43.239.53.130');
[02/21/2024 05:55:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:55:02' WHERE id= '573';
[02/21/2024 05:55:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:55:03' WHERE id= '573';
[02/21/2024 05:55:03], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:55:03' WHERE id= '573';
[02/21/2024 05:55:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:55:06' WHERE id= '573';
[02/21/2024 05:55:07], [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/21_02_2024/request_sight_details_Viator_test_05_55_06_1708494906.json', 'v1/21_02_2024/response_sight_details_Viator_test_05_55_06_1708494906.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_05_55_06_1708494906.json', 'viator', '2024-02-21 05:55:07', '', '', '1684');
[02/21/2024 05:55:07], [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/21_02_2024/request_sight_details_Viator_test_05_55_07_1708494907.json', 'v1/21_02_2024/response_sight_details_Viator_test_05_55_07_1708494907.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_05_55_07_1708494907.json', 'viator', '2024-02-21 05:55:07', '', '', '1684');
[02/21/2024 05:55:12], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:55:12' WHERE id= '573';
[02/21/2024 05:55: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 ('', 'check_availability', 'v1/21_02_2024/request_check_availability_Viator_test_05_55_12_1708494912.json', 'v1/21_02_2024/response_check_availability_Viator_test_05_55_12_1708494912.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_05_55_12_1708494912.json', 'viator', '2024-02-21 05:55:13', '', '', '1684');
[02/21/2024 05:55:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:55:39' WHERE id= '583';
[02/21/2024 05:55:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708494939','43.239.53.130');
[02/21/2024 05:56:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 05:56:54' WHERE id= '583';
[02/21/2024 05:56:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708495014','43.239.53.130');
