[01/29/2024 07:00:40], [file name :-/home/otrams/public_html/beta/tms/add_local_supplier.php],INSERT INTO psa_users set updated='2024-01-29 07:00:40' ,lname='' ,fname='travelclick' ,mname='' ,email='' ,phone='987685678' ,time_zone_offset='5.5' ,enable_dst='' ,id='travelclick' ,pass='49ab29194f8edd1451459d8b83545571' ,hash='6b0cdee84d111a084aadc3da1c275c57' ,groups='6,7' ,active='Y' ,expiration='' ,branch_id='' ,can_debug='' ,allow_book_under_cancellation='' ,allow_cancellation_after_voucher='' ,all_bookings='' ,user_type='supplier' ,site_id='' ;
[01/29/2024 07:00:40], [file name :-/home/otrams/public_html/beta/tms/add_local_supplier.php],INSERT INTO psa_pass_recover (question, answer, id) VALUES ('', '', '6b0cdee84d111a084aadc3da1c275c57');


[01/29/2024 07:08:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:08:12' WHERE id= '461';
[01/29/2024 07:08:12], [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/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :07:08:12',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 07:08:13], [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/29_01_2024/request_availability_Viator_test_07_08_12_1706512092.json', 'v1/29_01_2024/response_availability_Viator_test_07_08_12_1706512092.json', 'v1/29_01_2024/response_header_availability_Viator_test_07_08_12_1706512092.json', 'viator', '2024-01-29 07:08:13', '', '', '1166');
[01/29/2024 07:08:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:08:14' WHERE id= '461';
[01/29/2024 07:08:14], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:08:14' WHERE id= '461';
[01/29/2024 07:10:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:10:53' WHERE id= '461';
[01/29/2024 07:10: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/29_01_2024/request_sight_details_Viator_test_07_10_53_1706512253.json', 'v1/29_01_2024/response_sight_details_Viator_test_07_10_53_1706512253.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_07_10_53_1706512253.json', 'viator', '2024-01-29 07:10:54', '', '', '1166');
[01/29/2024 07:12:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:12:02' WHERE id= '461';
[01/29/2024 07:12:02], [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/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :07:12:02',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 07:12:03], [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/29_01_2024/request_availability_Viator_test_07_12_02_1706512322.json', 'v1/29_01_2024/response_availability_Viator_test_07_12_02_1706512322.json', 'v1/29_01_2024/response_header_availability_Viator_test_07_12_02_1706512322.json', 'viator', '2024-01-29 07:12:03', '', '', '1167');
[01/29/2024 07:12:04], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:12:04' WHERE id= '461';
[01/29/2024 07:12:05], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:12:05' WHERE id= '461';
[01/29/2024 07:12:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:12:07' WHERE id= '461';
[01/29/2024 07:12: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/29_01_2024/request_sight_details_Viator_test_07_12_07_1706512327.json', 'v1/29_01_2024/response_sight_details_Viator_test_07_12_07_1706512327.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_07_12_07_1706512327.json', 'viator', '2024-01-29 07:12:07', '', '', '1167');
[01/29/2024 07:12:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:12:52' WHERE id= '461';
[01/29/2024 07:12:52], [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/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :07:12:52',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 07:12:52], [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/29_01_2024/request_availability_Viator_test_07_12_52_1706512372.json', 'v1/29_01_2024/response_availability_Viator_test_07_12_52_1706512372.json', 'v1/29_01_2024/response_header_availability_Viator_test_07_12_52_1706512372.json', 'viator', '2024-01-29 07:12:52', '', '', '1168');
[01/29/2024 07:12:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:12:55' WHERE id= '461';
[01/29/2024 07:12:55], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:12:55' WHERE id= '461';
[01/29/2024 07:12:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:12:57' WHERE id= '461';
[01/29/2024 07:12:57], [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/29_01_2024/request_sight_details_Viator_test_07_12_57_1706512377.json', 'v1/29_01_2024/response_sight_details_Viator_test_07_12_57_1706512377.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_07_12_57_1706512377.json', 'viator', '2024-01-29 07:12:57', '', '', '1168');
[01/29/2024 07:15:45], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:15:45' WHERE id= '459';
[01/29/2024 07:15:57], [file name :-/home/otrams/public_html/beta/flight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:15:57' WHERE id= '459';
[01/29/2024 07:16:01], [file name :-/home/otrams/public_html/beta/ajax/get_airport_info.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:01' WHERE id= '459';
[01/29/2024 07:16:05], [file name :-/home/otrams/public_html/beta/ajax/get_airport_info.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:05' WHERE id= '459';
[01/29/2024 07:16:10], [file name :-/home/otrams/public_html/beta/m1_flight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:10' WHERE id= '459';
[01/29/2024 07:16:10], [file name :-/home/otrams/public_html/beta/m1_flight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '123.253.233.242' , service_type = 'Airline' , arrival_date = '2024/01/30' , departure_date = '2024/01/31' , create_date = '2024-01-29 :07:16:10' , origin = 'CGK' , destination = 'SUB' , site_id = '21' ;
[01/29/2024 07:16:10], [file name :-/home/otrams/public_html/beta/flight_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:10' WHERE id= '459';
[01/29/2024 07:16:10], [file name :-/home/otrams/public_html/beta/m1_flight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:10' WHERE id= '459';
[01/29/2024 07:16:11], [file name :-/home/otrams/public_html/beta/flight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:11' WHERE id= '459';
[01/29/2024 07:16:23], [file name :-/home/otrams/public_html/beta/ajax/get_airport_info.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:23' WHERE id= '459';
[01/29/2024 07:16:27], [file name :-/home/otrams/public_html/beta/m1_flight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:27' WHERE id= '459';
[01/29/2024 07:16:27], [file name :-/home/otrams/public_html/beta/m1_flight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '123.253.233.242' , service_type = 'Airline' , arrival_date = '2024/01/31' , departure_date = '2024/02/01' , create_date = '2024-01-29 :07:16:27' , origin = 'CGK' , destination = 'DPS' , site_id = '21' ;
[01/29/2024 07:16:27], [file name :-/home/otrams/public_html/beta/flight_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:27' WHERE id= '459';
[01/29/2024 07:16:27], [file name :-/home/otrams/public_html/beta/m1_flight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:27' WHERE id= '459';
[01/29/2024 07:16:28], [file name :-/home/otrams/public_html/beta/flight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:28' WHERE id= '459';
[01/29/2024 07:16:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:34' WHERE id= '461';
[01/29/2024 07:16:34], [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/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :07:16:34',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 07:16:35], [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/29_01_2024/request_availability_Viator_test_07_16_35_1706512595.json', 'v1/29_01_2024/response_availability_Viator_test_07_16_35_1706512595.json', 'v1/29_01_2024/response_header_availability_Viator_test_07_16_35_1706512595.json', 'viator', '2024-01-29 07:16:35', '', '', '1171');
[01/29/2024 07:16:36], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:36' WHERE id= '461';
[01/29/2024 07:16:36], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:36' WHERE id= '461';
[01/29/2024 07:16:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:38' WHERE id= '461';
[01/29/2024 07:16:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_07_16_38_1706512598.json', 'v1/29_01_2024/response_sight_details_Viator_test_07_16_38_1706512598.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_07_16_38_1706512598.json', 'viator', '2024-01-29 07:16:39', '', '', '1171');
[01/29/2024 07:16:45], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-29 07:16:45',login_attempt=0 where id = '7868';
[01/29/2024 07:16:45], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards', user_type = 'A', branch_id = '1', login_datetime = '2024-01-29 07:16:45', ip = '123.253.233.242', action = 'Login' ;
[01/29/2024 07:16:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:46' WHERE id= '457';
[01/29/2024 07:16:52], [file name :-/home/otrams/public_html/beta/flight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:52' WHERE id= '457';
[01/29/2024 07:16:58], [file name :-/home/otrams/public_html/beta/ajax/get_airport_info.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:16:58' WHERE id= '457';
[01/29/2024 07:17:01], [file name :-/home/otrams/public_html/beta/ajax/get_airport_info.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:01' WHERE id= '457';
[01/29/2024 07:17:04], [file name :-/home/otrams/public_html/beta/m1_flight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:04' WHERE id= '457';
[01/29/2024 07:17:04], [file name :-/home/otrams/public_html/beta/m1_flight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '123.253.233.242' , service_type = 'Airline' , arrival_date = '2024/02/02' , departure_date = '2024/02/03' , create_date = '2024-01-29 :07:17:04' , origin = 'CGK' , destination = 'DPS' , site_id = '21' ;
[01/29/2024 07:17:04], [file name :-/home/otrams/public_html/beta/flight_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:04' WHERE id= '457';
[01/29/2024 07:17:04], [file name :-/home/otrams/public_html/beta/m1_flight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:04' WHERE id= '457';
[01/29/2024 07:17:04], [file name :-/home/otrams/public_html/beta/flight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:04' WHERE id= '457';
[01/29/2024 07:17:07], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:07' WHERE id= '457';
[01/29/2024 07:17:10], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:10' WHERE id= '457';
[01/29/2024 07:17:15], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:15' WHERE id= '457';
[01/29/2024 07:17:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:15' WHERE id= '461';
[01/29/2024 07:17:15], [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/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :07:17:15',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 07:17:16], [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/29_01_2024/request_availability_Viator_test_07_17_15_1706512635.json', 'v1/29_01_2024/response_availability_Viator_test_07_17_15_1706512635.json', 'v1/29_01_2024/response_header_availability_Viator_test_07_17_15_1706512635.json', 'viator', '2024-01-29 07:17:16', '', '', '1173');
[01/29/2024 07:17:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:18' WHERE id= '461';
[01/29/2024 07:17:18], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:18' WHERE id= '461';
[01/29/2024 07:17:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:20' WHERE id= '461';
[01/29/2024 07:17: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 ('', 'sight_details', 'v1/29_01_2024/request_sight_details_Viator_test_07_17_20_1706512640.json', 'v1/29_01_2024/response_sight_details_Viator_test_07_17_20_1706512640.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_07_17_20_1706512640.json', 'viator', '2024-01-29 07:17:20', '', '', '1173');
[01/29/2024 07:17:21], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:21' WHERE id= '457';
[01/29/2024 07:17:24], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:24' WHERE id= '457';
[01/29/2024 07:17:24], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/29/2024 07:17:24], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:24' WHERE id= '457';
[01/29/2024 07:17:25], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:25' WHERE id= '457';
[01/29/2024 07:17:27], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:17:27' WHERE id= '457';
[01/29/2024 07:22:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:22:08' WHERE id= '461';
[01/29/2024 07:22:08], [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/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :07:22:08',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 07:22: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/29_01_2024/request_availability_Viator_test_07_22_08_1706512928.json', 'v1/29_01_2024/response_availability_Viator_test_07_22_08_1706512928.json', 'v1/29_01_2024/response_header_availability_Viator_test_07_22_08_1706512928.json', 'viator', '2024-01-29 07:22:08', '', '', '1174');
[01/29/2024 07:22:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:22:09' WHERE id= '461';
[01/29/2024 07:22:09], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:22:09' WHERE id= '461';
[01/29/2024 07:22:12], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:22:12' WHERE id= '461';
[01/29/2024 07:22:12], [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/29_01_2024/request_sight_details_Viator_test_07_22_12_1706512932.json', 'v1/29_01_2024/response_sight_details_Viator_test_07_22_12_1706512932.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_07_22_12_1706512932.json', 'viator', '2024-01-29 07:22:12', '', '', '1174');
[01/29/2024 07:24:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:24:26' WHERE id= '461';
[01/29/2024 07:24:26], [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/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :07:24:26',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 07:24:26], [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/29_01_2024/request_availability_Viator_test_07_24_26_1706513066.json', 'v1/29_01_2024/response_availability_Viator_test_07_24_26_1706513066.json', 'v1/29_01_2024/response_header_availability_Viator_test_07_24_26_1706513066.json', 'viator', '2024-01-29 07:24:26', '', '', '1175');
[01/29/2024 07:24:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:24:29' WHERE id= '461';
[01/29/2024 07:24:29], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:24:29' WHERE id= '461';
[01/29/2024 07:24:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:24:31' WHERE id= '461';
[01/29/2024 07:24:32], [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/29_01_2024/request_sight_details_Viator_test_07_24_31_1706513071.json', 'v1/29_01_2024/response_sight_details_Viator_test_07_24_31_1706513071.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_07_24_31_1706513071.json', 'viator', '2024-01-29 07:24:32', '', '', '1175');
[01/29/2024 07:27:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:27:30' WHERE id= '461';
[01/29/2024 07:27:30], [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/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :07:27:30',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 07:27:30], [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/29_01_2024/request_availability_Viator_test_07_27_30_1706513250.json', 'v1/29_01_2024/response_availability_Viator_test_07_27_30_1706513250.json', 'v1/29_01_2024/response_header_availability_Viator_test_07_27_30_1706513250.json', 'viator', '2024-01-29 07:27:30', '', '', '1176');
[01/29/2024 07:27:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:27:31' WHERE id= '461';
[01/29/2024 07:27:32], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:27:32' WHERE id= '461';
[01/29/2024 07:27:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:27:33' WHERE id= '461';
[01/29/2024 07:27: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/29_01_2024/request_sight_details_Viator_test_07_27_33_1706513253.json', 'v1/29_01_2024/response_sight_details_Viator_test_07_27_33_1706513253.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_07_27_33_1706513253.json', 'viator', '2024-01-29 07:27:34', '', '', '1176');
[01/29/2024 07:28:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:28:02' WHERE id= '461';
[01/29/2024 07:28:02], [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/02/03',  departure_date='2024/02/03',  nights='1',  create_date='2024-01-29 :07:28:02',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/29/2024 07:28:02], [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/29_01_2024/request_availability_Viator_test_07_28_02_1706513282.json', 'v1/29_01_2024/response_availability_Viator_test_07_28_02_1706513282.json', 'v1/29_01_2024/response_header_availability_Viator_test_07_28_02_1706513282.json', 'viator', '2024-01-29 07:28:02', '', '', '1177');
[01/29/2024 07:28:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:28:03' WHERE id= '461';
[01/29/2024 07:28:04], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:28:04' WHERE id= '461';
[01/29/2024 07:28:05], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-29 07:28:05' WHERE id= '461';
[01/29/2024 07:28: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/29_01_2024/request_sight_details_Viator_test_07_28_05_1706513285.json', 'v1/29_01_2024/response_sight_details_Viator_test_07_28_05_1706513285.json', 'v1/29_01_2024/response_header_sight_details_Viator_test_07_28_05_1706513285.json', 'viator', '2024-01-29 07:28:05', '', '', '1177');
[01/29/2024 07:28:35], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-29 07:28:35' , ip = '43.239.53.130' , action = 'Logout'  ;

[01/29/2024 07:36:16], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into agent_allowed_countries SET agent_id= '7869',allowed_countries= 'United Arab Emirates';
[01/29/2024 07:36:16], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET  accounting_id='7869',cd_credit_limit=credit_limit-'7869' , expiry_date = '2'7869'24-'7869'4-28 '7869'7:36:16',cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ? and site_id = ''7869'';
[01/29/2024 07:36:59], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-29 07:36:59' , ip = '43.239.53.130' , action = 'Logout'  ;


[01/29/2024 07:38:38], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into user_log_link Set `user_logs_id`='664', `entity`='Agents', `value`='7869' ;
[01/29/2024 07:38:48], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-29 07:38:48' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/29/2024 07:39:19], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-29 07:39:19',login_attempt=0 where id = '7869';
[01/29/2024 07:39:19], [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-01-29 07:39:19', ip = '43.239.53.130', action = 'Login' ;
[01/29/2024 07:39:19], [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='4232534e9a0e526d9c244855211f484e87f76adcead453f2092975e4aa76e95e',create_date='2024-01-29 07:39:19', update_date='2024-01-29 07:39:19',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/29/2024 07:42:56], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `psa_users` set  `id`='Viator', `lname`='Test', `mname`='', `fname`='Viator', `email`='pranali.mhatre@qtechsoftware.com', `time_zone_offset`='1', `phone`='9898909878', `connection`='', `pass`='e08adaa7d2453db64988f87657cd13d5', `hash`='7a2a934d3346cab9153165713abda251', `user_type`='admin', `active`='N', `can_debug`='', `allow_book_under_cancellation`='1', `allow_cancellation_after_voucher`='1', `all_bookings`='branch_booking', `is_booking_email_received`='1', `updated`='2024-01-29 07:42:56', `created_by`='v3alpha', `create_date`='2024-01-29 07:42:56', `site_id`='',`consultant_acc_id`='',`consultant_image`='',`messenger_type`='',`messenger_id`='',`user_description`='123',`cal_hashcode`='28d85ba16f0cd21e552493fe6d567d0077827328d79f9f1569b466d0858cf044',`designation`='';
[01/29/2024 07:42:56], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into psa_pass_recover set  id = '7a2a934d3346cab9153165713abda251' ;
[01/29/2024 07:42:56], [file name :-/home/otrams/public_html/beta/tms/user.php],DELETE FROM consultant_branches WHERE consultant_id ='Viator';
[01/29/2024 07:42:56], [file name :-/home/otrams/public_html/beta/tms/user.php],INSERT INTO consultant_branches(consultant_id,branch_id,create_time,modified_time) SELECT 'Viator','1','2024-01-29 07:42:56','2024-01-29 07:42:56';
[01/29/2024 07:42:56], [file name :-/home/otrams/public_html/beta/tms/user.php],update psa_users set groups='30,41,31,32,33,35,36,28,43,6,8' where id='Viator';
[01/29/2024 07:42:56], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-29 07:42:56',`log_type`= 'User',`sql_query`= 'INSERT INTO consultant_branches(consultant_id,branch_id,create_time,modified_time) SELECT \&#039;Viator\&#039;,\&#039;1\&#039;,\&#039;2024-01-29 07:42:56\&#039;,\&#039;2024-01-29 07:42:56\&#039;',`log_description`= 'User added For  -id=Viator&groups=30%2C41%2C31%2C32%2C33%2C35%2C36%2C28%2C43%2C6%2C8&lname=Test&fname=Viator&mname=&email=pranali.mhatre%40qtechsoftware.com&time_zone_offset=1&enable_dst=0&phone=9898909878&pass=&hash=7a2a934d3346cab9153165713abda251&active=N&connection=&lockcount=0&expiration=&updated=2024-01-29+07%3A42%3A56&branch_id=0&can_debug=&allow_book_under_cancellation=1&allow_cancellation_after_voucher=1&all_bookings=branch_booking&site_id=0&user_type=admin&created_by=v3alpha&create_date=2024-01-29+07%3A42%3A56&consultant_acc_id=&consultant_image=&cal_hashcode=28d85ba16f0cd21e552493fe6d567d0077827328d79f9f1569b466d0858cf044&allow_to_change_expiration_date=0&is_booking_email_received=1&messenger_type=&messenger_id=&user_description=123&designation=',`ip`= '43.239.53.130';
[01/29/2024 07:43:07], [file name :-/home/otrams/public_html/beta/tms/user.php],update psa_users set active='Y' where id='Viator';
[01/29/2024 07:43:07], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-29 07:43:07',`log_type`= 'User Activated',`sql_query`= 'update psa_users set active=\&#039;Y\&#039; where id=\&#039;Viator\&#039;',`log_description`= 'User Viator Activated',`ip`= '43.239.53.130';
[01/29/2024 07:43:15], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-29 07:43:15' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/29/2024 07:47:00], [file name :-/home/otrams/public_html/beta/tms/user.php],update psa_users set pass= 'e08adaa7d2453db64988f87657cd13d5', modify_date= '2024-01-29 07:47:00',modify_by= 'v3alpha' where id = 'Viator';

[01/29/2024 07:47:07], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-29 07:47:07' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/29/2024 07:49:38], [file name :-/home/otrams/public_html/beta/tms/user.php],update  `psa_users` set  `consultant_acc_id` ='', `lname`='Test', `mname`='', `fname`='Viator', `email`='pranali.mhatre@qtechsoftware.com', `time_zone_offset`='1', `phone`='9898909878', `messenger_type`='', `messenger_id`='', `user_description`='123', `connection`='', `modify_by`='v3alpha', `user_type`='admin', `allow_book_under_cancellation`='1', `allow_cancellation_after_voucher`='1', `is_booking_email_received`='1', `all_bookings`='branch_booking', `designation`='', `updated`='2024-01-29 07:49:38', `modify_date`='2024-01-29 07:49:38'  where `site_id`='' and `id` ='Viator' ;
[01/29/2024 07:49:38], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-29 07:49:38',`log_type`= 'User',`sql_query`= 'update  `psa_users` set  `consultant_acc_id` =:accounting_id, `lname`=:last_name, `mname`=:middle_name, `fname`=:first_name, `email`=:email, `time_zone_offset`=:time_zone_offset, `phone`=:phone, `messenger_type`=:messenger_type, `messenger_id`=:messenger_id, `user_description`=:user_description, `connection`=:connection, `modify_by`=:modify_by, `user_type`=:user_type, `allow_book_under_cancellation`=:allow_book_under_cancellation, `allow_cancellation_after_voucher`=:allow_cancellation_after_voucher, `is_booking_email_received`=:is_booking_email_received, `all_bookings`=:all_bookings, `designation`=:designation, `updated`=:updated, `modify_date`=:modify_date  where `site_id`=:site_id and `id` =:user_id ',`log_description`= 'User Viator updated For  - updated=2024-01-29+07%3A42%3A56&modify_date=2024-01-29+07%3A47%3A00 changed to - updated=2024-01-29+07%3A49%3A38&modify_date=2024-01-29+07%3A49%3A38',`ip`= '43.239.53.130';
[01/29/2024 07:49:49], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-29 07:49:49' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/29/2024 07:54:19], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-29 07:54:19',login_attempt=0 where id = '7869';
[01/29/2024 07:54:19], [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-01-29 07:54:19', ip = '43.239.53.130', action = 'Login' ;
[01/29/2024 07:54:19], [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='b59d1aa5c20b56b461cf6d46d890063e4d4f4287069fdacb9e5034ccaf5a029e',create_date='2024-01-29 07:54:19', update_date='2024-01-29 07:54:19',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/29/2024 07:55:34], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-29 07:55:34' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/29/2024 07:56:28], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'VIATOR' , user_type = 'VIATOR'_type , branch_id = '' , login_datetime = '2024-01-29 07:56:28' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/29/2024 07:57:25], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'VIATOR' , user_type = 'VIATOR'_type , branch_id = '' , login_datetime = '2024-01-29 07:57:25' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/29/2024 07:58:16], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-01-29 07:58:16', ip = '205.210.31.176', action = 'Login' ;
[01/29/2024 07:58:43], [file name :-/home/otrams/public_html/beta/tms/profile_access.php],update psa_users set groups='8' where id='Viator';
[01/29/2024 07:58:43], [file name :-/home/otrams/public_html/beta/tms/profile_access.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-29 07:58:43',`log_type`= 'User',`sql_query`= '',`log_description`= 'User Viator has been Updated. Previous Details -  id-6 ## name- Local Supplier ==&lt;br&gt;== id-8 ## name- Super Admin ==&lt;br&gt;== id-28 ## name- Admin test ==&lt;br&gt;== id-30 ## name- 1. Bookings Menu ==&lt;br&gt;== id-31 ## name- 2. Agents Menu ==&lt;br&gt;== id-32 ## name- 3. Suppliers Menu ==&lt;br&gt;== id-33 ## name- 4. Accounts Menu ==&lt;br&gt;== id-35 ## name- 6. Markup Menu ==&lt;br&gt;== id-36 ## name- 7. Masters Menu ==&lt;br&gt;== id-41 ## name- 11. Reports Menu ==&lt;br&gt;== id-43 ## name- Branch Admin Profile ',`ip`= '43.239.53.130';
[01/29/2024 07:58:56], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-29 07:58:56' , ip = '43.239.53.130' , action = 'Logout'  ;
