vStatsCenter

[Kyle]

I have it installed, but it is not showing the greased landings, and it is not showing all the pilots who have flown this month. Click here to see.

Mr. Bean, what day is it? July 1st! that's why it's based on by month, and you probably didn't have any PIREPS sent yet for July.

[Cor]

Hiya Kyle,

With me the greased landings also not working, and also the hours are not looking good.

See picture

Regards,

Cor

[Strider]

Whoops, my mistake there has been more then 3 pireps all by the same pilot, but the other problem is there. The greased landings have not been taken no matter which month I select.

[Kyle]

Both of you...

Do any of your current month PIREPs have landing rates? Becasue the query skips out all landing rates with a 0.

[Cor]

Hi Kyle,

Yes there are pireps with landingrates. see picture of another module.

Regards,

Cor

[mseiwald]

Jap i have the same issue with the greased landings

(null)

[Strider]

Yes, 90% of all pireps my va gets are filed via kacars. It is getting the average landing rate fine, just not showing the greased landings.

[Strider]

I think I see the problem you have order by p.landingrate desc, but you have not instructed the query to even look for the landingrate.

[Kyle]

I'm going to have a look a it.

Thanks Guys!

[Kyle]

Okay, I think I may found the issue...

Changes - View Changes

Download - Download Here

Let's hope it will work for you guys!

[Cor]

Hi Kyle,

Still got nothing. Sorry.

Regards,

Cor

[Strider]

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.

[Kyle]

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.

[Strider]

That is a negative on the previous months.

[Kyle]

I'll have to download the module and see what's the issue there...

Thanks guys.

[Kyle]

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.

[Cor]

_{Which phpvms do you use?}

[Kyle]

_{Which phpvms do you use?}

The latest one.. 2.1.934

[michael Kraan]

i have a problem when i add this module than i have that:

what am I doing wrong?

Greets

michael Kraan

[Kyle]

Did you bring in the VAStatsData.class.php into your common folder?

[michael Kraan]

Did you bring in the VAStatsData.class.php into your common folder?

yes i have that,

[Kyle]

Check your url...

www.va.com/index.php/vStatsCenter/?month=7&year=2012

That's the issue here.

[michael Kraan]

Sorry, but i have the error agian. see the screenshot and the link that you have send to me

Greets

michael Kraan

[mseiwald]

michael try to write a </div> at the end of the template.... it looks like you have an open div there somewhere

[michael Kraan]

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

[Cor]

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

[michael Kraan]

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)

Edited July 13, 2012 by michael Kraan

[Kyle]

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.

[Kyle]

AHAHAHAHA!!!!!!!!!!!!!!!!!!!

I FOUND THE ISSUE! Hold on, let me get the updated one on Github.

[Kyle]

Build Released!

Download Here

View Changes Here

=======

It should work now for you guys! There was a new colum added in the beta, so I had to remove the new colum in the query to make it work!

Cheers!