Anydesk 1831373470 KHALIL 1414941741 HANAN https://allwayscharters.com/ https://allwaystravel.net/ www.travelbooklb.com allways allways2024 www.samadonline.com fly@allwaystravel.net allways123 Allways123 https://docs.google.com/spreadsheets/d/1iXV4aqU2DtSh9EdQoc-hJHWXy_uvJVOzc0NqQExCqJk/edit?usp=sharing www.allwaystravel.minisoft-lb.com ================================ minisoft_allwaystravel_DB minisoft_allwaystravel_admin @llwaystravel@t-2o24$ no-reply@minisoft-lb.com n0-r@t-2o24$ Change DB connection from local to on line: =========================================== goto : output\connections\ConnectionManager.php Find : function _setConnectionsData then Update data at lines: 281, 295, 296 and 298 Exemple: $data["connectionString"] = "mysql;localhost;minisoft_allwaystravel_admin;@llway$travel@t-2o24$;;minisoft_allwaystravel_DB;;1"; $data["connInfo"][1] = "minisoft_allwaystravel_admin"; $data["connInfo"][2] = "@llway$travel@t-2o24$"; $data["connInfo"][3] = ""; $data["connInfo"][4] = "minisoft_allwaystravel_DB"; to_airport like '%$_SESSION["filter_destination"]' AND nbr_days like '%$_SESSION["filter_days"]' Beirut Airport,Lebanon Cairo Airport, Egypt Dalaman (DLM),Turkey Sharm El Sheikh (SSH),Egypt SELECT `id`, concat(`full_airline_name`,' ', `flight_number` ,' ', `from_airport`,' ', `to_airport`,' ', `departure_date`,' ', `departure_time`,' ', `arrival_time`,' ', `return_date`, ' ', `return_departure_time`, ' ', `return_arrival_time`), `price`, `seats` FROM `flights` WHERE 1 CREATE VIEW v_reservation as ( SELECT `bookings`.`id`as bookingID, `booking_reference`, `user_id`, `flight_id`, `nbr_adults`, `nbr_children`, `nbr_infants`, `total_price` , `airlines`.`logo` as a_logo, `users`.`id` as userID,`users`.`name`,`users`.`logo`, `flights`.`id` as flightID,`flight_number`, `flights`.`full_airline_name`, `from_airport`, `to_airport`, `departure_date`, `departure_time`, `arrival_time`, `return_flight_number`, `return_date`, `return_departure_time`, `return_arrival_time`, `adult_price`, `child_price`, `infant_price`, `seats`, `remaining_seats`, `nbr_days` , `to_airport` AS `filter_destination`, `nbr_days` AS `filter_days`, `pass_booking_id`,`first_name_01`, `last_name_01`, `phone_01`, `first_name_02`, `last_name_02`, `phone_02`, `first_name_03`, `last_name_03`, `phone_03`, `first_name_04`, `last_name_04`, `phone_04`, `first_name_05`, `last_name_05`, `phone_05`, `first_name_06`, `last_name_06`, `phone_06`, `first_name_07`, `last_name_07`, `phone_07`, `first_name_08`, `last_name_08`, `phone_08`, `first_name_09`, `last_name_09`, `phone_09`, `first_name_10`, `last_name_10`, `phone_10` FROM `bookings`,`airlines`, `flights`,`passengers_list`,`users` WHERE `users`.`id`=`user_id` AND `bookings`.`id`=`pass_booking_id` AND `flights`.`full_airline_name`=`airlines`.`full_airline_name` AND `flights`.`id` =`flight_id`); CREATE VIEW v_reserved as ( SELECT `passengers`.`id` as passenger_ID , CONCAT(`title`, " " ,`first_name`, " ",`father_name` , " ", `last_name`) as full_name, `passengers`.`email` AS p_email,`bookings`.`user_id`, `users`.`name`, `users`.`logo`,`bookings`.`id`as bookingID, `booking_reference`, `bookings`.`booking_date`, `airlines`.`full_airline_name`, `airlines`.`logo` as airline_logo,`flight_number`,`from_airport`, `to_airport`, `departure_date`, DATE_FORMAT(departure_time,'%k:%i'), IF(arrival_time