Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

alyousufi's Achievements


Newbie (1/14)

  • Week One Done Rare
  • One Month Later Rare
  • One Year In Rare

Recent Badges



  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
  • Create New...