Server Help

L.C.

Well the project I'm involved in is developing the Public Biller of mine into as more of an identical biller to the SSC Billing as possible and possibly better. What we're working on right now is Online Generation of Statistics, etc. As identical to http://web.archive.org/web/20060104050528/http://edome.fi.soneraplaza.net/subspace/scores.html as possible.

So far these are the columns we're going to be using: Playername, Squad, Wins, Losses, Ratio, Average, Points, Flag Points, Total Points.

However, we kind of ran into a problem. I asked an SVS player in Chaos for what Average is calculated for; he said it was the sum of all bounty from the players you killed divided by your wins. Unfortunately this data isn't recorded in the database files. How do we go about accomplishing this efficiently?

Just a note to self (please correct me if I'm wrong); bounty should be recorded at deaths. When a player dies, the bounty he died with will be recorded in some manner. If PlayerA (100) kills PlayerB (100), then we've already got 100 kill bounty in the stash. PlayerA gets 1 bounty for the kill (by settings of arena). If PlayerA (101) then kills PlayerC (9

, we now have 198 in the stash. 198/2=(99.0=Average).

Mine GO BOOM · Posted: Sun Nov 26, 2006 5:04 am Post subject:

There are two points recorded by Subspace, normal points and flag points. Average is just normal points / number of kills. Total points is just normal + flag points.

L.C. · Posted: Tue Nov 28, 2006 6:44 pm Post subject:

Have another question. Look at the archive.org link given in Post #1.

What's "rating"?

Does anybody have a sketch / saved backups of any of the statistic pages?

Thanks.

Smong · Posted: Tue Nov 28, 2006 6:47 pm Post subject:

Rating: (points from kills x 10 + (wins-losses) x 100) / (wins + 100)

Edit: DAWS is based off the "subspace scores" site, only it is per arena, not per-zone. I tried to copy most of the layout with a few changes. I removed the links from the left and put the searches there, then that left space for the results to appear in the right/center. Live example at http://pirates.sszones.com/stats.php.
_________________
ss news

L.C. · Posted: Thu Nov 30, 2006 9:28 pm Post subject:

Another question. Look at the archive.org link given in Post #1.

How was the "w:l ratio" displayed? Just simply 63:23 (example)?

Smong · Posted: Fri Dec 01, 2006 6:49 am Post subject:

I don't know about that. Why not try and make something better than what it was before, you make the rules as you go along.

L.C. · Posted: Fri Dec 01, 2006 11:30 am Post subject:

It's my style to be strictly professional and formal, following along as exact precision and accuracy to the original design that is being modeled after.

However, I've been having agreeble considerations of omitting the "w:l ratio;" could use the extra space.