Player top lists.

[delems]

Still don't think the player top lists are honoring all personas, it is just picking one persona.

Also, player top lists don't seem to be honoring the minimum number of sorties required before showing on list, most should require 25 or 50 sorties before being put on a top list.

[Eagletree]

Still don't think the player top lists are honoring all personas, it is just picking one persona.

Also, player top lists don't seem to be honoring the minimum number of sorties required before showing on list, most should require 25 or 50 sorties before being put on a top list.

Take a look at Top Player LMG as of this morning. With a good campaign reset and elimination of the corruptions in the old DB, I was able to get a more accurate query working. It's still quite slow, but it is tolerable. If the LMG looks good, I will be applying the same query to the other weapons. Want input.

[delems]

Since I so rarely use the LMG I can't tell with my stats. Not sure.

[Eagletree]

Since I so rarely use the LMG I can't tell with my stats. Not sure.

I'll apply the same query method to rifleman and smg.

Thanks.

[Eagletree]

SMG and Rifleman are now running the new query, very slow. Give it at least 15 or 20 seconds.

[delems]

Yep - looks much better, good work - keep going!

[Eagletree]

Yep - looks much better' date=' good work - keep going![/quote']

ATR, Mortar, Sniper, Engineer are all updated too now. The general lists also look pretty good (KD, Caps, Kills), but I will assume, some of the same problems will exist in the vehicle oriented weapons. I've yet to start looking at them.

[delems]

The top KD is not working right. I'd take a close look at every top list.

[Eagletree]

The top KD is not working right. I'd take a close look at every top list.

Thanks, will check the rest out.

[delems]

Top DDs and PBs don't seem to show sorties, RTBs or ToM either. Not sure about other top lists. (but looks like most have)

[Eagletree]

The KD report was totally whacked by attempting to use a stored value for KD. It turns out all of the first four reports are using the same method and have incorrect KDs shown. I've corrected the KD report and will fix the other 3 too.

Next step is to start down the list of those reports not yet touched. I'll move down the list from top to bottom.

[Eagletree]

All player top lists appear to be correct excepting Freighters and the Streaks. Streaks are pre-calculated prior to hitting CSR and will require changes (if necessary) when we actually move to the new database.

Freighters is likely okay, but there is frankly too little data at the moment, so I'm going to hold on it. Freighters currently have the same totals as the original CSR1 Freighter top list.

Appreciate your input on these Delems (and separate from this thread, Eddie05 and Nozzred also gave input). Complaints welcome here.

[delems]

Everything looking much better. Top persona DD shows 25 sorties and me in the top list, but top player does not, it should.

[delems]

Just noticed my persona top list DD shows 15-6 for Kills/Deaths; don't think that is right. Doesn't jive with my player summary of 6-2.

[Eagletree]

I'll check that out. Haven't touched the persona lists since they were almost carbon copy queries. The "almost" is probably the operative word.

[delems]

Also noticed there are other players with 25 or more combined DD sorties, but not showing on top player list.

[GOPHUR]

Eagle posted internal yesterday that this was just about 100%.

[Eagletree]

Today I'm applying the updates I made to the player lists back to the persona lists. So far the only validated persona based list is the ATGs.

I checked the DD Player list and I had made a typo. It was requiring 50 sorties rather than the 25 required minimum. Interestingly, you were still the only one to show up, so I'll see if I can identify who else you noticed should be on there.

Edit: I found the next person down to be icetwp with a sortie total of 15, who did you find that should have a combined sortie count of greater than 24?

Edited December 12, 2013 by Eagletree

[delems]

DDs and FMBs should only be 25 sorties to be on player top lists - not sure what other classes use 25 verses 50. I know playtime has more than 25 sorties with all his allied missions combined, around 41.

Edited December 12, 2013 by delems

[Eagletree]

Sorry to take so long on this, pretty wiped out with sickness.

Playtime has his stats hidden. For the most part, I ignore that in my queries, but the top lists inherited that in most cases.

There is a bug I can see, the Destroyers are supposed to based on their performance against the other sea vehicles, instead, the queries all (in the old system and this) appear to be against bombers, destroyers and frieghters, nothing else. Seems convoluted.This was not true, the Fairmiles are included in the opponent list.

Edited December 14, 2013 by Eagletree

[OLDZEKE]

Sorry to take so long on this, pretty wiped out with sickness.

Playtime has his stats hidden. For the most part, I ignore that in my queries, but the top lists inherited that in most cases.

There is a bug I can see, the Destroyers are supposed to based on their performance against the other sea vehicles, instead, the queries all (in the old system and this) appear to be against bombers, destroyers and frieghters, nothing else. Seems convoluted.This was not true, the Fairmiles are included in the opponent list.

I think bombers are included because they can kill DDs. IMO FMBs should not be counted in top DD lists but thats just me.

[Eagletree]

I've just gone through all persona top lists and compared against CSR 1. All are equivalent except for timing differences on CSR 1s batch reporting. The batch report causes minor differences in placement depending on when you hit CSR 1. It's between 5 and 15 minutes off, perhaps a little more after some of the stability updates we did when it was last having failures (had to extended the frequency to keep them from running over the top of one another).

I redid several of the persona queries and some run a bit slower now. The Tanker list was the worst.

The player top lists looked good too last I looked and the only thing not verified was the streak lists. We may have to do those differently when we move to the new DB anyway.

Let me know on anything you see that I missed.

Thanks

[delems]

===

I think bombers are included because they can kill DDs. IMO FMBs should not be counted in top DD lists but thats just me.

===

FMBs can kill DDs; also, they are a sea vessel. (if going by kills, what about 88 or schreck etc.)

Personally, I'd count all air, vehicles, AA, ATG and sea vessels; Just wouldn't count infantry.