Author Topic: TOP 5 PILOTS BY HOURS - PROBLEM - (SLOVED)  (Read 45 times)

jiko

  • Newbie
  • *
  • Posts: 7
    • View Profile
TOP 5 PILOTS BY HOURS - PROBLEM - (SLOVED)
« on: February 10, 2020, 08:32:14 AM »
HELLO !!!

Yesterday i accept 2 new pilot to my VA and ask me to tranfer 3000 hours and 3800 hours the other one, and i do it.

This pilots are not visible to TOP 5 PILOTS BY HOURS statistics.
On top 1 i have a pilot with 2800 hours.
I cant find the problem after 10 hourse of searching . :(
I dont think is the transfer hours the problem because i have other pilots with tranfsfer hours and i show them in TOP 5 PILOTS BY HOURS table.
please somebody help me with this .
thank you
« Last Edit: February 10, 2020, 11:27:21 AM by jiko »

jiko

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: TOP 5 PILOTS BY HOURS - PROBLEM - (SLOVED)
« Reply #1 on: February 10, 2020, 11:25:58 AM »
i find myself the solution.
just replace this 2 lines in top_five_hour.php


Code: [Select]
line 27: $sql = "select callsign , name,surname, round(sum(time),2) + g.transfered_hours as total_time from v_total_data_flight v inner join gvausers g on g.gvauser_id = v.pilot where id_flight is not null and status<>2 group by pilot order by total_time desc limit 5";

line 31: $sql = "select callsign , name,surname, round(sum(time),2) + g.transfered_hours as total_time from v_total_data_flight v inner join gvausers g on g.gvauser_id = v.pilot where id_flight is not null group by pilot order by total_time desc limit 5";

 ;D ;D
« Last Edit: February 11, 2020, 06:50:59 PM by jiko »