Jump to content

flyalaska

Members
  • Posts

    1941
  • Joined

  • Last visited

  • Days Won

    17

Posts posted by flyalaska

  1. Ignore the post above, wont let me edit it. I forgot to delete something. Edited by moderator....

     

    Replace your code with this:

     

    public static function TotalPilotMiles($pilotid)
    {
      $key = 'total_miles';
      $key .= '_'.$pilotid;
    
      $total = CodonCache::read($key);
    
      if($total === false)
      {
       $total = 0;
       $sql = "SELECT * FROM ".TABLE_PREFIX."pireps WHERE pilotid='$pilotid' AND accepted=1";
       $results = DB::get_results($sql);
       if($results) { foreach($results as $result) { $total += $result->distance; } }
    
       CodonCache::write($key, $total, '15minute');
      }
      return $total;
    }
    
       public static function getpilotsbestlanding($pilotid)
        {
                $sql = "SELECT landingrate FROM ".TABLE_PREFIX."pireps WHERE pilotid = '$pilotid' AND landingrate < 0 ORDER BY landingrate DESC LIMIT 1";
    
                $result = DB::get_row($sql);
    
                if(!$result)
                {
                    return 0;
                }
    
                $result = $result->landingrate;
    
            return $result;
        }
    
            public static function getpilotsworselanding($pilotid)
        {
            $sql = "SELECT landingrate FROM ".TABLE_PREFIX."pireps WHERE pilotid = '$pilotid' AND landingrate < 0 ORDER BY landingrate ASC LIMIT 1";
    
                $result = DB::get_row($sql);
    
                if(!$result)
                {
                    return 0;
                }
    
                $result = $result->landingrate;
    
            return $result;
    }

     

  2. Thank you for looking at my skin.BlueIce v2 is a major update from previous versions. BlueIce is for php skins only and was tested with SimPilots 5.5 base and ProAvia 5.5 update for php 7 . There are two downloads. One for php 5.6 and the other for php 7.2

    Whats all included:

     - Bootstrap v4.1.3 compatible

     - Font Awesome 5 icons

     - OpenStreet Map

    - Custom public profile

    - Custom Pilot profile/Dashboard

    - Styled tables

    Modules Needed (included):

    You will need to install a few modules for this template to work. (included)

    AirMail 3

    All Awards

    Ranks

    Touchdownstats

    DO NOT install the template files.

    ***PLEASE READ THE DOCUMENTATION FOR INSTALLATION***

     

    Download - php 5.6

    Download php 7.2

    Download  - phpVMS for php 7.2 (Thanks ProAvia)

    BI-1.jpg

     

    BI-2.jpg

     

    BI-3.jpg

     

    BI-4.jpg

  3. 2 hours ago, nicky9499 said:

    I tried to PM @flyalaska (Eddie?) but the forum reported the account is unable to receive PM at this time.

    To reduce the back-and-forth, could we perhaps correspond via my "serious" email? [nic@ccrx.us]

    Thank you in advance for offering to help, I deeply appreciate it.

    Had to be a glitch. Its says your box is full.

    Click the Contact Us link under support.

    https://phpvms.209studios.com/downloads_OceanBlue3.php

×
×
  • Create New...