[12/01/2023 11:19:45], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-12-01 11:19:45',login_attempt=0 where id = '7865';
[12/01/2023 11:19:45], [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 = '2023-12-01 11:19:45', ip = '43.239.53.130', action = 'Login' ;
[12/01/2023 11:19:45], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:19:45' WHERE id= '186';
[12/01/2023 11:19:49], [file name :-/home/otrams/public_html/beta/flight_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:19:49' WHERE id= '186';
[12/01/2023 11:19:51], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:19:51' WHERE id= '186';
[12/01/2023 11:19:56], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:19:56' WHERE id= '186';
[12/01/2023 11:20:01], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:20:01' WHERE id= '186';
[12/01/2023 11:20:01], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[12/01/2023 11:20:09], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:20:09' WHERE id= '186';
[12/01/2023 11:21:07], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:21:07' WHERE id= '186';
[12/01/2023 11:21:07], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[12/01/2023 11:21:11], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:21:11' WHERE id= '186';
[12/01/2023 11:21:20], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:21:20' WHERE id= '186';
[12/01/2023 11:30:22], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:30:22' WHERE id= '186';
[12/01/2023 11:30:22], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[12/01/2023 11:30:25], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:30:25' WHERE id= '186';
[12/01/2023 11:37:19], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:37:19' WHERE id= '186';
[12/01/2023 11:37:19], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[12/01/2023 11:37:23], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:37:23' WHERE id= '186';
[12/01/2023 11:39:28], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:39:28' WHERE id= '186';
[12/01/2023 11:39:28], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[12/01/2023 11:39:33], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:39:33' WHERE id= '186';
[12/01/2023 11:40:20], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:40:20' WHERE id= '186';
[12/01/2023 11:40:20], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[12/01/2023 11:40:24], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:40:24' WHERE id= '186';
[12/01/2023 11:40:27], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:40:27' WHERE id= '186';
[12/01/2023 11:40:27], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[12/01/2023 11:40:32], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:40:32' WHERE id= '186';
[12/01/2023 11:40:37], [file name :-/home/otrams/public_html/beta/booking_request.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:40:37' WHERE id= '186';
[12/01/2023 11:40:42], [file name :-/home/otrams/public_html/beta/get_cancellation_fee.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:40:42' WHERE id= '186';
[12/01/2023 11:40:46], [file name :-/home/otrams/public_html/beta/note_action.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:40:46' WHERE id= '186';
[12/01/2023 11:40:48], [file name :-/home/otrams/public_html/beta/message_action.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:40:48' WHERE id= '186';
[12/01/2023 11:40:57], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:40:57' WHERE id= '186';
[12/01/2023 11:41:01], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:41:01' WHERE id= '186';
[12/01/2023 11:41:04], [file name :-/home/otrams/public_html/beta/booking_list_flight.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:41:04' WHERE id= '186';
[12/01/2023 11:41:11], [file name :-/home/otrams/public_html/beta/ticketing_booking_flight.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:41:11' WHERE id= '186';
[12/01/2023 11:41:13], [file name :-/home/otrams/public_html/beta/sector_details_flight.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:41:13' WHERE id= '186';
[12/01/2023 11:41:18], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_airline.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:41:18' WHERE id= '186';
[12/01/2023 11:41:22], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:41:22' WHERE id= '186';
[12/01/2023 11:41:24], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:41:24' WHERE id= '186';
[12/01/2023 11:41:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:41:27' WHERE id= '186';
[12/01/2023 11:41:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:41:30' WHERE id= '186';
[12/01/2023 11:41:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/05',  departure_date='2024/01/05',  nights='1',  create_date='2023-12-01 :11:41:30',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[12/01/2023 11:42:00], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:42:00' WHERE id= '186';
[12/01/2023 11:42:08], [file name :-/home/otrams/public_html/beta/terms.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:42:08' WHERE id= '186';
[12/01/2023 11:42:14], [file name :-/home/otrams/public_html/beta/terms.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:42:14' WHERE id= '186';
[12/01/2023 11:42:18], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:42:18' WHERE id= '186';
[12/01/2023 11:42:21], [file name :-/home/otrams/public_html/beta/terms.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:42:21' WHERE id= '186';
[12/01/2023 11:43:01], [file name :-/home/otrams/public_html/beta/terms.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:43:01' WHERE id= '186';
[12/01/2023 11:43:33], [file name :-/home/otrams/public_html/beta/terms.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:43:33' WHERE id= '186';
[12/01/2023 11:43:38], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:43:38' WHERE id= '186';
[12/01/2023 11:43:44], [file name :-/home/otrams/public_html/beta/about_us.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:43:44' WHERE id= '186';
[12/01/2023 11:44:07], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:44:07' WHERE id= '186';
[12/01/2023 11:44:12], [file name :-/home/otrams/public_html/beta/terms.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:44:12' WHERE id= '186';
[12/01/2023 11:44:25], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:44:25' WHERE id= '186';
[12/01/2023 11:44:34], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:44:34' WHERE id= '186';
[12/01/2023 11:44:39], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:44:39' WHERE id= '186';
[12/01/2023 11:44:43], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:44:43' WHERE id= '186';
[12/01/2023 11:44:47], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:44:47' WHERE id= '186';
[12/01/2023 11:44:52], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:44:52' WHERE id= '186';
[12/01/2023 11:44:56], [file name :-/home/otrams/public_html/beta/booking_list_flight.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:44:56' WHERE id= '186';
[12/01/2023 11:45:02], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:45:02' WHERE id= '186';
[12/01/2023 11:45:11], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:45:11' WHERE id= '186';
[12/01/2023 11:45:12], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:45:12' WHERE id= '186';
[12/01/2023 11:46:15], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:46:15' WHERE id= '186';
[12/01/2023 11:46:20], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:46:20' WHERE id= '186';
[12/01/2023 11:46:55], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:46:55' WHERE id= '186';
[12/01/2023 11:46:58], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:46:58' WHERE id= '186';
[12/01/2023 11:47:03], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:47:03' WHERE id= '186';
[12/01/2023 11:47:04], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:47:04' WHERE id= '186';
[12/01/2023 11:47:05], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:47:05' WHERE id= '186';
[12/01/2023 11:47:06], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:47:06' WHERE id= '186';
[12/01/2023 11:47:12], [file name :-/home/otrams/public_html/beta/transfer_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:47:12' WHERE id= '186';
[12/01/2023 11:47:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:47:18' WHERE id= '186';
[12/01/2023 11:47:22], [file name :-/home/otrams/public_html/beta/ajax/get_zone_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:47:22' WHERE id= '186';
[12/01/2023 11:47:30], [file name :-/home/otrams/public_html/beta/ajax/get_zone_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:47:30' WHERE id= '186';
[12/01/2023 11:47:42], [file name :-/home/otrams/public_html/beta/transfer_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 11:47:42' WHERE id= '186';
[12/01/2023 11:47:42], [file name :-/home/otrams/public_html/beta/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = '71649' , arrival_date='',  departure_date='',  nights='1',  create_date='2023-12-01 :11:47:42',  nationality='106',  additional_markup='',  selected_currency='USD',  service_type='transfer',  total_adult='1',  total_children='',  site_id = '20' ;
[12/01/2023 11:47:42], [file name :-/home/otrams/public_html/beta/transfer_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 ('', 'transfer_availability', 'h1/Transfer/01_12_2023/request_transfer_availability_Baysan_Tourism_wh_1701431262_1701431262_10.xml', 'h1/Transfer/01_12_2023/response_transfer_availability_Baysan_Tourism_wh_1701431262_1701431262_10.xml', 'h1/Transfer/01_12_2023/response_header_transfer_availability_Baysan_Tourism_wh_1701431262_1701431262_10.xml', 'hotelbedstransfer', '2023-12-01 11:47:42', '\n', '', '182');
