[02/12/2024 07:22:39], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 07:22:39',login_attempt=0 where id = '7870';
[02/12/2024 07:22:39], [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-12 07:22:39', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 07:22:39], [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='1f88d7ff42700235d26154b1c58170c6e444ffc7d24d9c19245ceb657c648231',create_date='2024-02-12 07:22:39', update_date='2024-02-12 07:22:39',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/12/2024 07:22:42], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 07:22:42' WHERE id= '544';
[02/12/2024 07:35:57], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 07:35:57',login_attempt=0 where id = '7849';
[02/12/2024 07:35:57], [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-12 07:35:57', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 07:35:57], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 07:35:57' WHERE id= '541';
[02/12/2024 07:36:08], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 07:36:08' WHERE id= '541';
[02/12/2024 07:36:12], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 07:36:12' WHERE id= '541';
[02/12/2024 07:36:16], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 07:36:16' WHERE id= '541';
[02/12/2024 07:36:16], [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/25',  departure_date='2024/02/25',  nights='1',  create_date='2024-02-12 :07:36:16',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/12/2024 07:36:21], [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/12_02_2024/request_availability_shiv_qtech_07_36_16_1707723376.json', 'v1/12_02_2024/response_availability_shiv_qtech_07_36_16_1707723376.json', 'v1/12_02_2024/response_header_availability_shiv_qtech_07_36_16_1707723376.json', 'viator', '2024-02-12 07:36:21', '', '', '1389');
[02/12/2024 07:36:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 07:36:23' WHERE id= '541';
[02/12/2024 07:36:23], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 07:36:23' WHERE id= '541';
[02/12/2024 07:36:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 07:36:25' WHERE id= '541';
[02/12/2024 07:36:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/12_02_2024/request_sight_details_shiv_qtech_07_36_25_1707723385.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_07_36_25_1707723385.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_07_36_25_1707723385.json', 'viator', '2024-02-12 07:36:26', '', '', '1389');
[02/12/2024 07:36:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/12_02_2024/request_sight_details_shiv_qtech_07_36_26_1707723386.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_07_36_26_1707723386.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_07_36_26_1707723386.json', 'viator', '2024-02-12 07:36:26', '', '', '1389');
[02/12/2024 07:36:30], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 07:36:30' WHERE id= '541';
[02/12/2024 07:36:31], [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/12_02_2024/request_check_availability_shiv_qtech_07_36_30_1707723390.json', 'v1/12_02_2024/response_check_availability_shiv_qtech_07_36_30_1707723390.json', 'v1/12_02_2024/response_header_check_availability_shiv_qtech_07_36_30_1707723390.json', 'viator', '2024-02-12 07:36:31', '', '', '1389');
[02/12/2024 07:36:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 07:36:37' WHERE id= '541';
[02/12/2024 07:36:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707723397','43.239.53.130');
[02/12/2024 07:57:40], [file name :-/home/otrams/public_html/beta/agent_registration.php],INSERT INTO agents(ip_addr,admin_id,agency_name,first_name,middle_name,last_name,agent_type,
		sort_type,credit_value,credit_usage,address,city,pincode,country,time_zone_offset,enable_dst,
		phone,mobile,fax,email,website,username,designation,iata_status,iata_number,nature_of_business,
		logo,lead_time,password,currency,status,create_date,modify_date,debug,is_super_user,branch_id,parent_agent,can_book,acc_name,acc_email,acc_phone,man_name,man_email,man_phone,res_name,res_email,comp_reg_no,res_phone,referer)
		VALUES('43.239.53.130', 'National Tour And Travel', 'National Tour And Travel', 'Shiv', '', 'Chauhan', 'CS', '', '', '0', 'surat', '106_2219_6215', '400052', '106', '5.5', '', '91-9867847563', '91-7867846587', '', 'shiv.chauhan@qtechsoftware.com', 'www.shivtravel.com', 'Bhavesh_qtech', 'Mumbai Maharashtra', '', '', '0', '', '', '140696a95d1eccc972e476083219014c8553cd19f245ce1a04b27ee9b6e52a2f', '6', 'P', '2024-02-12 07:57:40', '', '', '1', '32', '', '', 'RANJEET MARFATIYA', 'ranjumarfatiya@gmail.com', '2347873345', '', '', '', '', '', '12344342', '', 'https://hotelyards.astrabookings.com/agent_registration.php');
[02/12/2024 07:57:40], [file name :-/home/otrams/public_html/beta/agent_registration.php],update agents set site_id ='21',  wh_main_agent ='7867', branch_id ='32', wh_agent ='yes' where id ='7871' ;
