Hi Kyle,
Still got nothing. Sorry.
Regards,
Cor
The greased landings is still not working. The SQL Query is still not looking for it.
$query = "SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate,
UNIX_TIMESTAMP(p.modifieddate) as modifieddate,
u.pilotid, u.firstname, u.lastname, u.email, u.rank,
a.id AS aircraftid, a.name as aircraft, a.registration,
dep.name as depname, dep.lat AS deplat, dep.lng AS deplng,
arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng
FROM " . TABLE_PREFIX . "pireps p
LEFT JOIN " . TABLE_PREFIX . "aircraft a ON a.id = p.aircraft
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 . "pilots u ON u.pilotid = p.pilotid
WHERE MONTH(submitdate) = {$month} AND YEAR(submitdate) = {$year} AND p.landingrate != 0 AND p.accepted = 1 AND u.retired = 0
ORDER BY p.landingrate DESC
LIMIT 5";
See the p.landingrate, it is only in the order by and where, it has not been instructed to look for it anywhere else.
Grrr…
I’ll have to have a look at it again, and yes, it’s being instructed to look at the landing rate, maybe not…, but I’ll take a look. Maybe I have to rewritte it…
thanks for letting me know guys, also while I’m looking for the problem, can you go back to different previous months and see if something is showing up.
Thanks.
That is a negative on the previous months.
I’ll have to download the module and see what’s the issue there…
Thanks guys.
Okay,
I still can’t find the issue… I downloaded the module from my Github, and I installed on my VA, I do get the greased landing rates.
I’m not sure what’s the issue on your end guys. My suggestion is to try reinstalling the module and let me know if it not works.
Which phpvms do you use?
Which phpvms do you use?
The latest one.. 2.1.934
i have a problem when i add this module than i have that:
what am I doing wrong?
Greets
michael Kraan
Did you bring in the VAStatsData.class.php into your common folder?
Did you bring in the VAStatsData.class.php into your common folder?
yes i have that,
Sorry, but i have the error agian. see the screenshot and the link that you have send to me
Greets
michael Kraan
michael try to write a </div> at the end of the template… it looks like you have an open div there somewhere
michael try to write a </div> at the end of the template… it looks like you have an open div there somewhere
Thank you!, that is the fix for the problem!
greets
Michael Kraan
The latest one.. 2.1.934
MMm thats what I use. I will try to have a look at it this weekend. I have some time because girlfriend has to
work
Regards,
Cor
Hi Kyle,
the landing rate is not working for now. i see nothing.
Greets
michael Kraan
And i see a other problem,
when you refresh the page than is the date, first month of your airliner. and not a month from now.
is it possible? the current month is on top? (select month)
MMm thats what I use. I will try to have a look at it this weekend. I have some time because girlfriend has to
work
Regards,
Cor
Not a problem! But I think it might be the Stable and Beta issue, I’ll have to have a look.
AHAHAHAHA!!!
I FOUND THE ISSUE! Hold on, let me get the updated one on Github.