[01/17/2024 10:11:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:11:01' WHERE id= '309';
[01/17/2024 10:11:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/17_01_2024/request_check_availability_Viator_test_10_11_01_1705486261.json', 'v1/17_01_2024/response_check_availability_Viator_test_10_11_01_1705486261.json', 'v1/17_01_2024/response_header_check_availability_Viator_test_10_11_01_1705486261.json', 'viator', '2024-01-17 10:11:02', '', '', '957');
[01/17/2024 10:12:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:12:44' WHERE id= '309';
[01/17/2024 10:12:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/17_01_2024/request_check_availability_Viator_test_10_12_44_1705486364.json', 'v1/17_01_2024/response_check_availability_Viator_test_10_12_44_1705486364.json', 'v1/17_01_2024/response_header_check_availability_Viator_test_10_12_44_1705486364.json', 'viator', '2024-01-17 10:12:45', '', '', '957');
[01/17/2024 10:12:47], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:12:47' WHERE id= '309';
[01/17/2024 10:12:47], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705486367','43.239.53.130');
[01/17/2024 10:13:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:13:48' WHERE id= '309';
[01/17/2024 10:13:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705486428','43.239.53.130');
[01/17/2024 10:13:50], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:13:50' WHERE id= '309';
[01/17/2024 10:13:50], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705486430','43.239.53.130');
[01/17/2024 10:15:19], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:15:19' WHERE id= '309';
[01/17/2024 10:15:19], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705486519','43.239.53.130');
[01/17/2024 10:15:31], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:15:31' WHERE id= '309';
[01/17/2024 10:15:31], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705486531','43.239.53.130');
[01/17/2024 10:20:18], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:20:18' WHERE id= '309';
[01/17/2024 10:20:18], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705486818','43.239.53.130');
[01/17/2024 10:20:58], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-01-17 10:20:58', ip = '52.167.144.189', action = 'Login' ;
[01/17/2024 10:24:23], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:24:23' WHERE id= '309';
[01/17/2024 10:24:23], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-17 10:24:23',login_attempt=0 where id = '7851';
[01/17/2024 10:24:23], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-01-17 10:24:23', ip = '43.239.53.130', action = 'Login' ;
[01/17/2024 10:24:23], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:24:23' WHERE id= '309';
[01/17/2024 10:24:26], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:24:26' WHERE id= '309';
[01/17/2024 10:24:29], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:24:29' WHERE id= '309';
[01/17/2024 10:24:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:24:34' WHERE id= '309';
[01/17/2024 10:24: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/01/20',  departure_date='2024/01/20',  nights='1',  create_date='2024-01-17 :10:24:34',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/17/2024 10:24:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/17_01_2024/request_availability_Viator_test_10_24_34_1705487074.json', 'v1/17_01_2024/response_availability_Viator_test_10_24_34_1705487074.json', 'v1/17_01_2024/response_header_availability_Viator_test_10_24_34_1705487074.json', 'viator', '2024-01-17 10:24:41', '', '', '958');
[01/17/2024 10:24:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:24:42' WHERE id= '309';
[01/17/2024 10:24:42], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:24:42' WHERE id= '309';
[01/17/2024 10:24:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:24:44' WHERE id= '309';
[01/17/2024 10:24:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/17_01_2024/request_sight_details_Viator_test_10_24_44_1705487084.json', 'v1/17_01_2024/response_sight_details_Viator_test_10_24_44_1705487084.json', 'v1/17_01_2024/response_header_sight_details_Viator_test_10_24_44_1705487084.json', 'viator', '2024-01-17 10:24:44', '', '', '958');
[01/17/2024 10:24:47], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:24:47' WHERE id= '309';
[01/17/2024 10:24:48], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/17_01_2024/request_check_availability_Viator_test_10_24_47_1705487087.json', 'v1/17_01_2024/response_check_availability_Viator_test_10_24_47_1705487087.json', 'v1/17_01_2024/response_header_check_availability_Viator_test_10_24_47_1705487087.json', 'viator', '2024-01-17 10:24:48', '', '', '958');
[01/17/2024 10:24:52], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:24:52' WHERE id= '309';
[01/17/2024 10:24:52], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705487092','43.239.53.130');
[01/17/2024 10:24:53], [file name :-/home/otrams/public_html/beta/tms/currency.php],UPDATE currency_map SET exchange_markup='3' WHERE from_c='3' AND to_c='4';
[01/17/2024 10:24:53], [file name :-/home/otrams/public_html/beta/tms/currency.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-17 10:24:53',`log_type`= 'Currency Exchange Markup Updated',`sql_query`= 'UPDATE currency_map SET exchange_markup=3 WHERE from_c=\&#039;3\&#039; AND to_c=\&#039;4\&#039;',`log_description`= 'Currency Exchange Markup From EUR To INR Has Been Changed From 5% To 3%',`ip`= '43.239.53.130';
[01/17/2024 10:25:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:25:37' WHERE id= '309';
[01/17/2024 10:25:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705487137','43.239.53.130');
[01/17/2024 10:29:58], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:29:58' WHERE id= '309';
[01/17/2024 10:29:58], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705487398','43.239.53.130');
[01/17/2024 10:33:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:33:59' WHERE id= '309';
[01/17/2024 10:33:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705487639','43.239.53.130');
[01/17/2024 10:35:44], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:35:44' WHERE id= '309';
[01/17/2024 10:35:44], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705487744','43.239.53.130');
[01/17/2024 10:36:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:36:42' WHERE id= '309';
[01/17/2024 10:36:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705487802','43.239.53.130');
[01/17/2024 10:42:56], [file name :-/home/otrams/public_html/beta/tms/currency.php],UPDATE currency_map SET exchange_markup='1' WHERE from_c='3' AND to_c='4';
[01/17/2024 10:42:56], [file name :-/home/otrams/public_html/beta/tms/currency.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-17 10:42:56',`log_type`= 'Currency Exchange Markup Updated',`sql_query`= 'UPDATE currency_map SET exchange_markup=1 WHERE from_c=\&#039;3\&#039; AND to_c=\&#039;4\&#039;',`log_description`= 'Currency Exchange Markup From EUR To INR Has Been Changed From 3% To 1%',`ip`= '43.239.53.130';
[01/17/2024 10:51:10], [file name :-/home/otrams/public_html/beta/tms/currency.php],UPDATE currency_map SET exchange_markup='2' WHERE from_c='3' AND to_c='4';
[01/17/2024 10:51:10], [file name :-/home/otrams/public_html/beta/tms/currency.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-17 10:51:10',`log_type`= 'Currency Exchange Markup Updated',`sql_query`= 'UPDATE currency_map SET exchange_markup=2 WHERE from_c=\&#039;3\&#039; AND to_c=\&#039;4\&#039;',`log_description`= 'Currency Exchange Markup From EUR To INR Has Been Changed From 1% To 2%',`ip`= '43.239.53.130';
[01/17/2024 10:53:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:53:32' WHERE id= '309';
[01/17/2024 10:53:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705488812','43.239.53.130');
[01/17/2024 10:57:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-17 10:57:49' WHERE id= '309';
[01/17/2024 10:57:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705489069','43.239.53.130');
