Medals Page: break awarded medals by bronze/silver/gold/tota

[Rall]

I think it would be cool to see how many of each medal people had broken down a little more. If you go to the medals page, it shows 12252 have earned a standard medal. But it would be better if it showed: Bronze - 12252 .... Silver - 4567 .... Gold - 1234

Thanks,
Rall

[lancehoch]

Moved over to the Suggestions forum for you. You may want to fill out the proper form for the forum:

Concise Idea:

General Description:

How it would Help:

[Rall]

Thanks. I still can't figure out how to do the suggestion form thing.

Rall

[lancehoch]

Just copy the text from the three lines I typed and then type out what you want to see.

[Rall]

PLACE A CONCISE DESCRIPTION OF THE SUGGESTION OR BUG IN THE SUBJECT LINE!!!

Concise description:

• I think it would be cool to see how many of each medal people had broken down a little more. If you go to the medals page, it shows 12252 have earned a standard medal. But it would be better if it showed: Bronze - 12252 .... Silver - 4567 .... Gold - 1234
  

Specifics:

• On medals page, show how many have silver medals and gold medals too.

This will improve the following aspects of the site:

• Interesting to see how many gold and silver medals are out there.
• xxxxxxx

[max is gr8]

:goodposting:

[lancehoch]

I merged your two threads together. You do not need to start a new one for the form.

[blakebowling]

I merged your two threads together. You do not need to start a new one for the form.

right, but when you start a new one, the form is there.

[Rall]

I don't get it. Am I done with my suggestion? Sorry I'm a little slow.

Rall

[bedub1]

lol. Your suggestion is fine. The problem is....nobody at CC cares...

BTW...i think your suggestion is fantastic and should be implemented immediately.

[Trephining]

On the Medals Page, could the "awarded medals" stats be broken out by the various levels (bronze/silver/gold, and then total).

For example, if 3300 Assassin medals have been awarded, have four columns showing:

Total Bronze Silver Gold
3300 2700 500 100

Then maybe if you click on the numbers it shows a list of the recipients. That way you can find out who the specialists are or who really has a lot of experience in a particular game.

[ronsizzle]

lmfao......

[Trephining]

lmfao......

Anything to contribute?

[lackattack]

Merged duplicate suggestions

[greenoaks]

Merged duplicate suggestions

why was this rejected ?

[blakebowling]

Merged duplicate suggestions

why was this rejected ?

Lack didn't move it. I did.

Also, it was moved because the MOD doesn't work this way, and the queries required to get this information would drastically increase the load time of the page.

[greenoaks]

Merged duplicate suggestions

why was this rejected ?

Lack didn't move it. I did.

Also, it was moved because the MOD doesn't work this way, and the queries required to get this information would drastically increase the load time of the page.

wouldn't it take about 3 times as long

[blakebowling]

Merged duplicate suggestions

why was this rejected ?

Lack didn't move it. I did.

Also, it was moved because the MOD doesn't work this way, and the queries required to get this information would drastically increase the load time of the page.

wouldn't it take about 3 times as long

The way they are stored in the database is (for those that have more than one medal) 1 row = bronze, 2 rows = silver, and 3 rows = gold. Therefore you would have to search only those with b/s/g and find the users that have exactly 3 matches, then those with exactly 2 matches, then with 1. This would add 4 queries to the page, bringing the load time to around 8 seconds again (the low-end of what it was before I optimized it).

[greenoaks]

wouldn't it take about 3 times as long

The way they are stored in the database is (for those that have more than one medal) 1 row = bronze, 2 rows = silver, and 3 rows = gold. Therefore you would have to search only those with b/s/g and find the users that have exactly 3 matches, then those with exactly 2 matches, then with 1. This would add 4 queries to the page, bringing the load time to around 8 seconds again (the low-end of what it was before I optimized it).

why would you do that ?

wouldn't you just do a count of row 3 for the gold
a count of row 2 for the silver
& a count of row 1 for the bronze

[blakebowling]

wouldn't it take about 3 times as long

The way they are stored in the database is (for those that have more than one medal) 1 row = bronze, 2 rows = silver, and 3 rows = gold. Therefore you would have to search only those with b/s/g and find the users that have exactly 3 matches, then those with exactly 2 matches, then with 1. This would add 4 queries to the page, bringing the load time to around 8 seconds again (the low-end of what it was before I optimized it).

why would you do that ?

wouldn't you just do a count of row 3 for the gold
a count of row 2 for the silver
& a count of row 1 for the bronze

It doesn't work that way. Each award is a row, a silver medal is equal to 2 awards, and a gold is equal to 3. Selecting all this information at one time would drastically increase the page load time.

[Dako]

Can you please send me a dump of the table for medals? Let's say 1000-5000 rows would be ok. I will try to see how complex it will be to build a decent query. Just upload it somewhere and PM me the link.

Also - what about caching the results? Do not say it is that hard.

[blakebowling]

Can you please send me a dump of the table for medals? Let's say 1000-5000 rows would be ok. I will try to see how complex it will be to build a decent query. Just upload it somewhere and PM me the link.

Also - what about caching the results? Do not say it is that hard.

I'm not saying it is impossible, I'm saying that it would require database changes, which are likely to require changes to other parts of the code. We're trying to keep this as compatible as possible with future versions of the MOD.

Also, I don't have the CC table, just the structure of it.

[Dako]

A pity. However, I think is would be wiser to adapt this module to the CC totally, then to hold back because of the future compatibility (which is broken already since you modified some parts of the code).

Well, you should know better because you can see it, so I can just speculate.

[blakebowling]

A pity. However, I think is would be wiser to adapt this module to the CC totally, then to hold back because of the future compatibility (which is broken already since you modified some parts of the code).

Well, you should know better because you can see it, so I can just speculate.

I modified the way displaying them works, however I didn't change the database or the core functions. IF we choose to update in the future though, it shouldn't be too hard to combine the code. However the more that is changed, the more problems we could possibly have.

I will look over the code again, to see if there is something I may have missed that could make this easy. If it is, I'll gladly code it and submit it to lack.

[greenoaks]

would doing it like the scoreboard be difficult ie. working it out once an hour

every view except for the one on the hour would be instantaneous