Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by alyousufi

  1. Hi phpvms : Version 2.1.936 PHP : 5.6 MySql : .6.35-log MySQL Community Server (GPL)
  2. i don't know maybe the problem with JAVA as u said do you know any way that i can solve this problem . i am using old db for my VA just for test in localhost. once everything is fine i upload it to the host .
  3. Hi here from line here from line 308 to 362 337 start with $row->rawdata = unserialize($row->rawdata); /** * Get the number of reports for the last x number of days * Returns 1 row for every day, with the total number of * reports per day */ public static function getCountsForDays($days = 7) { $sql = 'SELECT DISTINCT(DATE(submitdate)) AS submitdate, (SELECT COUNT(*) FROM '.TABLE_PREFIX.'pireps WHERE DATE(submitdate)=DATE(p.submitdate)) AS count FROM '.TABLE_PREFIX.'pireps p WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= p.submitdate'; return DB::get_results($sql); } /** * Get all of the details for a PIREP, including lat/long of the airports */ public static function getReportDetails($pirepid) { $sql = 'SELECT p.*, s.*, s.id AS scheduleid, p.route, p.route_details, u.pilotid, u.firstname, u.lastname, u.email, u.rank, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng, p.code, p.flightnum, p.depicao, p.arricao, p.price AS price, a.id as aircraftid, a.name as aircraft, a.registration, p.flighttime, p.distance, UNIX_TIMESTAMP(p.submitdate) as submitdate, p.accepted, p.log FROM '.TABLE_PREFIX.'pilots u, '.TABLE_PREFIX.'pireps p LEFT JOIN '.TABLE_PREFIX.'airports AS dep ON dep.icao = p.depicao LEFT JOIN '.TABLE_PREFIX.'airports AS arr ON arr.icao = p.arricao LEFT JOIN '.TABLE_PREFIX.'aircraft a ON a.id = p.aircraft LEFT JOIN '.TABLE_PREFIX.'schedules s ON s.code = p.code AND s.flightnum = p.flightnum WHERE p.pilotid=u.pilotid AND p.pirepid='.$pirepid; $row = DB::get_row($sql); $row->rawdata = unserialize($row->rawdata); /* Do any specific replacements here */ if($row) { /* If it's FSFlightKeeper, process the `rawdata` column, which contains array()'d copied of extra data that was sent by the ACARS. Run that through some templates which we've got. This can probably be generic-ized but it's fine now for FSFK. This can probably move through an outside function, but seems OK to stay in getReportDetails() for now, since this is semi-intensive code here (the most expensive is populating the templates, and I wouldn't want to run it for EVERY PIREP which is called by the system. */ if($row->source == 'fsfk') { /* Do data stuff in the logs */ $data = $row->rawdata; /* Process flight data */ if(isset($data['FLIGHTDATA'])) { Template::Set('data', $data['FLIGHTDATA']); $flightdata = Template::Get('fsfk_log_flightdata.tpl', true, true, true); $row->log.=$flightdata; unset($flightdata); }
  4. Hello i am doing some change in VA by design and program a new admin skin i have problem which is i can't add/see pireps comment or do any action like reject / accept / delete the flight as well as i can't accept or reject any pending pilot . it was work fine without problem i am not sure this is because or .js file or jquery when i click for example Log or comment it should open in box but i got this result as shown even accept or reject button dose not work >>
  5. Hello i fixed the problem by new calling to Mysql db in order to get the data from db and display where i want thank you>
  6. Hi guys i need your help , i am trying to display pirep and pilot pending in other page then those 2 page admin/index.php/pirepadmin/viewpending admin/index.php/pilotadmin/pendingpilots for example in other page like Dashboard i think i have to make some change in PilotAdmin/pilotAdmin.php but unfortunately all the time i got error in dashboard. kind regards
  7. Hi guys i need to know how can i fix the problem i got white maps = BLANK Is there any way to fix it before it was work well here is the link http://www.omanair-va.org/index.php/destinations as well as i found in google chrome counsel this error Uncaught ReferenceError: map is not defined at addMarker (destinations:330) at Object.<anonymous> (destinations:316) at Function.each (jquery.min.js:30) at Object.success (destinations:307) at b (jquery.min.js:124) at XMLHttpRequest.x.onreadystatechange (jquery.min.js:129)
  8. Hello all i need to know if someone have the solution when i need to send email to the pilots it go to SPAM folder in tier email like gmail and if the pilot did -THIS IS NOT SPAM- it will come in the normal folder but other pilot still in SPAM guys if u have any solution for this please help
  9. Hello guys I need your help if someone h-ave tours center from CrazyCreative. As I can see the tour system generate a free callsign for the user per leg I need the keep the system to book flight for the user from the schedule not free callsign because some users got callsign with 6 numbers and this is not allowed to connect in Online. As there anyway to change the code to keep book bid per leg direct from our flight schedule?? Kind regards.
  10. Hi everyone guys i am looking for Modules for Pilot monthly roster i mean the system generate flight schedule for each active member to fly per month. if someone has this kind of Modules and can share with me please let me know ASAP.
  11. Hello all, i am doing something in my VA and i need to add new column \ filed in current table example table phpvms_pilot i am already new filed for example total_daily_flights i need to show the result of this filed in profile_main.tpl like <?php echo $userinfo->totalflights?> when i change totalflight to = total_daily_flights , there is NO Change ! please i know i should add new line in some files can you teach me like $this->set('total_daily_flights', $totaldailyflights); but where should be to add ? this is an example to be clear
  12. Thanks friend for your repaly Let wait some detail from other people maybe I can code it by my-self
  13. Hi is that possible to do the connection flight in virtual ? For example the main hub is Dubai and pilot want to fly from Paris to Sydney through Dubai ? for example when search for flight from Paris to Sydney it will show for him 1- EK1 from paris to Dubai 2- EK23 from dubai to Sydney i mean the result should be show the flight with connection flight to sydney is that possible or not if anyone have module or code please share with us
  14. Hi can anyone help me I need tour module freeware if possible
  15. friend can we talk in PM or via Email or whatever you want i have finish something . now when i choose dep and arr airport and click button it will transfer me to FrontSchedules page but without showing any result like it need to repeat and will get the result but in different page
  16. Hi thank you for your responding actually i am using maybe the default module create by * @author Nabeel Shahzad and it has <form> tag do you have any idea that can help me in order make quick search for flight ? I have another page that already work for booking flight <tr> <td>Select Virtual Airline</td> <td><select class="search" name="airline"> <option value="">All Virtual Airline</option> <?php foreach ($airlines as $airline) {echo '<option value="'.$airline->code.'">'.$airline->name.'</option>';} ?> </select> </td> </tr> <tr> <td>Select Aircraft Type</td> <td> <select class="search" name="aircraft"> <option value="">All Aircraft Type</option> <?php foreach ($aircrafts as $aircraft) {echo '<option value="'.$aircraft->icao.'">'.$aircraft->icao.'</option>';} ?> </select> </td> </tr> <tr> <td>Select Departure Airport</td><td> <select class="search" name="depicao"> <option value="">All Departure Airports</option> <?php foreach ($airports as $airport) {echo '<option value="'.$airport->icao.'">'.$airport->icao.' - '.$airport->name.'</option>';} ?> </select> </td> </tr> <tr> <td>Select Arrival Airport</td><td> <select class="search" name="arricao"> <option value="">All Arrival Airports</option> <?php foreach ($airports as $airport) {echo '<option value="'.$airport->icao.'">'.$airport->icao.' - '.$airport->name.'</option>';} ?> </select> </td> </tr> <tr> <td colspan="2"> <center> <input type="hidden" name="action" value="findflight" /> <input type="submit" name="submit" class="btnblue" value="Search Flight" /></center> </td> </tr> </table> but if i copy dep code will not show the airport in frontage.
  17. Hi i am doing some thing for out virtual i am create a form to search a flight in frontpage but i need to know how can i show all dep or arr airport ? below is example code i create it in frontpage but nothing show , like airport to select <div class="field col"> <label>From </label> <div class="inputText"> <tr> <td> <select class="search" name="depicao"> <option value="">All Departure Airports</option> <option value="BIKF">BIKF - Keflavik International Airport</option> <option value="BLKF">BLKF - Keflavik International Airport</option> <option value="EDDF ">EDDF - Frankfurt Intl. Airport</option> <option value="EDDM">EDDM - Franz Josef Strauss International Airport</option> </select> </td> </tr> </div> </div> <!-- End of Field --> <!-- Start of Field --> <div class="field col"> <label>To </label> <div class="inputText"> <tr> <td> <select class="search" name="arricao"> <option value="">All Arrival Airports</option> <option value="BIKF">BIKF - Keflavik International Airport</option> <option value="BLKF">BLKF - Keflavik International Airport</option> <option value="EDDF ">EDDF - Frankfurt Intl. Airport</option> <option value="EDDM">EDDM - Franz Josef Strauss International Airport</option> </select> </td> </tr> </div> </div> <!-- End of Field --> </div> <input> <tr> <td colspan="2"> <center> <input type="hidden" name="action" value="findflight" /> <input type="submit" name="submit" class="btnblue" value="Search Flight" /></center> </td> </tr> </div> once i am click Search flight nothing is happen can anyone help me
  • Create New...