Maybe make a new stat? (in General)

Smashure March 27 2005 9:48 AM EST

Not sure how much time it would take Jonathon to implement, but under statistics I would be curios to see who currently has the highest AC.

Chargerz-Back March 27 2005 12:47 PM EST

would be nice to see, i had to search through the people with the biggest MC and Adams to find it about a month ago. and i never did find it lol

I finally see March 27 2005 1:12 PM EST

I like the idea, could be rather interesting.

Will [Retired] March 28 2005 1:27 PM EST

As do I, there are a lot of us who want to know what we are up against in the AC race!

Arorrr March 28 2005 3:27 PM EST

You can go to Stats/Items/Normal. The top 5 of each item display the +. Then look at the characters who own them. That is what you essentially want.

Arorrr March 28 2005 3:31 PM EST

I make a mistake. States/Items/Normal is only for rare item. If you want to look at the highest NW on CML/Adam, go to Community/Item meta-stats then click on the number of the item.

Koko character: 161AC. Biggest at the moment, I think.

golgotha March 28 2005 3:42 PM EST

thank you for acknowledging my character

QBRanger March 28 2005 3:44 PM EST

I have someone with a 168AC. I think i have seen a 181 or so.

QBRanger March 28 2005 3:45 PM EST

Check out Newbie, Descents character- AC 202

Smashure March 29 2005 8:08 AM EST

How much work does it take to add a new stat?

QBsutekh137 March 29 2005 10:19 AM EST

The idea has been asked for before, search CB1 forums.

My take is that it would be a more prohibitive query (for the server) to generate the information. Jon is a master of modular programming and web page design, so adding the visual aspect of the new stat would be child's play. That has never been the issue, to my knowledge.

The issue is with accessing relational data. Let's look at an easy stat like HP:


Doesn't get much simpler than that. I have no idea what Jon's table and column names are, etc., but you get the idea.

AC is not an attribute of the minion (at least I assume it isn't at the moment). Total AC is the sum of all equipment the minion is wearing. That means a query would have to walk the minion table, the association table linking minions to equipment, and the equipment table (which is probably rather large). Then, sum up the base armor and plus on the armor, and there you have a total by minion. This _might_ be possible in a single query, but it would be a large one. Worst case scenario is that a stored procedure would have to be written to iterate through each minion's equipment, and in that case we are talking orders of magnitude on the performance hit.

The alternative would be to store the total AC on each minion, and then be sure to update it in all places where equipment can change and therefore change the number. There is one word for this in the database world: denormalization. There is another word for this in the database world: icky.

But you are saying, "It can't be that hard, it shows on the Inspect page!" That is the difference between on-demand data on a case-by-case basis and batch queries encompassing the entire system. It is easy to do what I mention above on a character by character basis. It's the doing it for everyone every time stats are calculated that is hard on the server.

Who knows, maybe it wouldn't be that hard on the server (and Jon has added functionality before as technology increases to try to keep pace with his genius *smile*). But Jon knows his hardware, he wrote the software, and he knows what he is doing.

Descent March 29 2005 11:42 AM EST

Do I really have the most AC in the game? *beams* I knew I was destined to be at the top of some list in CB, someday. =D
This thread is closed to new posts. However, you are welcome to reference it from a new thread; link this with the html <a href="/bboard/q-and-a-fetch-msg.tcl?msg_id=001GNb">Maybe make a new stat?</a>