[EDK4] Corp Pilot Stats

[MrWhitei]

I saw this requested a while ago and none seemed to pick it up.

So, here it is.
Based largely off the allcorpstats_page mod.
The mod adds a link to the corp detail page menu "Corp Pilot Stats", just like the alicorpstats mod adds a link to the alliance detail page.
(e.g Corp page with link added in menu box: http://kb.heretic-army.biz/?a=corp_detail&crp_id=3)

Corp Pilot Stats page
http://kb.heretic-army.biz/?a=pilot_stats&crp_id=3

The settings are similar to the alicorpstats_page mod with the irrelevant ones removed.

UPDATE:
v1.1 - Added a list of active campaigns to see how a corp is doing.
v1.1.1 - Fixed bug where losses were calculated incorrectly
v1.2
-Added Corp name to Template
-Ability to limit number of pilots displayed (show all by default)
-Ability to show corp list at the bottom of the corp detail page (off by default)
-Option to show campaign list or hide it (hidden by default)
v1.3 - Added option to hide POS Modules on settings page
v1.3.1
- Added link on stats page. Option in settings page must be unticked to see the link.
- Fixed display issue on settings page
v1.3.2
- Fixed Campaign filter to use Campaign Start/End Dates

All settings configurable within the mod admin section


Upload to your mods directory and unzip
Enable and specify whatever settings you want for the mod in the admin section.

[Kiddow]

could this mod be modified to show a pilots efficiency not for Weeks but for a Campaign ??

[MrWhitei]

could this mod be modified to show a pilots efficiency not for Weeks but for a Campaign ??

Yeh, should be no problem.
Ill get working on that.

[MrWhitei]

Mod updated with the campaign stuff

[raze]

thenk u! waiting this mod so long

[raze]

I think u have some bug in loses count:
Statistic for May in u mod:

Statistic for May in corp stats:


For example: Gwyn'bleid 110 loses in u mod, but only 18 in corp stats (real).

[MrWhitei]

Yep,
I messed up the SQL.
It seems to be counting the loss as many times as there was people on that mail.

Will get this fixed when i get home from work

EDIT: Fixed this issue

[AndyTibs]

Working great! Thanks for this!

[Zagdul]

awesome mod!

Could you add the corp name in the header?

I was trying to insert the table into the corp stats page but failed miserably. Potentially instead of this creating it's own page you could have it be inserted into the corp page.

I got it to insert into the page and told smarty to call your template, however the way you built the mod, it just adds a page on top of a page and jacks everything up.

[MrWhitei]

awesome mod!

Could you add the corp name in the header?

I was trying to insert the table into the corp stats page but failed miserably. Potentially instead of this creating it's own page you could have it be inserted into the corp page.

I got it to insert into the page and told smarty to call your template, however the way you built the mod, it just adds a page on top of a page and jacks everything up.

done and done