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;
}