announcements

Forum > Announcements > Clan ranking sorting
Reply To Thread (login)
Ender [1]
Administrator
2012-09-25 22:29:46
[11 years, 186 days ago]

The main clan rankings page (and the historical ones) is now sortable by all fields.

Thanks to Fishwick for the suggestion!


 
Coco [131]
2012-09-26 04:20:15
[11 years, 186 days ago]

How about each clan sortable by all fields?


 
Jans [87]
2012-09-26 06:15:14
[11 years, 186 days ago]

yay, at least one thing Atreides is number one at!


 
Spazz [111]
2012-09-26 08:10:47
[11 years, 186 days ago]

quick neps, we need 10 more NC's :P


 
Spazz [111]
2012-09-26 08:13:19
[11 years, 186 days ago]

why is there not clan average level? >.>


 
Nosferatu [155]
2012-09-26 15:21:40
[11 years, 186 days ago]

Average level I believe use to be a part of the Clan Jans Index, so it actually merited a spot on the Clan page, since it no longer matters what the clan average level is then I suppose it's another useless stats, adding it based on whether Ender deems it necessary, and considering the limited space to which he has on the clan page I guess he doesn't see the point in adding it.


 
Coco [131]
2012-09-26 17:19:45
[11 years, 185 days ago]

How about a column for total clan EPH?


 
User Name [231]
2012-09-26 18:10:48
[11 years, 185 days ago]

I'd like that a lot Coco, but because of how the system calculates our EPH, I think Ender has stated before that would be difficult to accomplish.


 
Leader2 [100]
2012-09-26 18:12:24
[11 years, 185 days ago]

id like it too :) and how about make it so when you click the clan your viewing make it so wins and etc can be sorted into order


 
MGK [108]
2012-09-26 18:56:33
[11 years, 185 days ago]

The javascript sorter that you use on Edmazur.com/bots would work well for EPH.


 
User Name [231]
2012-09-26 18:57:34
[11 years, 185 days ago]

EPH is calculate don the fly, it's not a hard set number.


 
Leader2 [100]
2012-09-26 19:07:19
[11 years, 185 days ago]

So basically it would be hard to implement the eph one


 
Gpof2 [130]
2012-09-26 19:09:53
[11 years, 185 days ago]

Yup. Also I think it might have been a matter of page load time.


 
Leader2 [100]
2012-09-26 19:17:05
[11 years, 185 days ago]

So instead of taking 0.01 seconds It might take 0.5679 seconds??


 
MGK [108]
2012-09-26 19:37:44
[11 years, 185 days ago]

No. Go to edmazur.com/bots/weapons.php

You can sort each column because of the javascript sorter. It's very very fast. It can sort anything.

I know EPH is on the fly.


 
Leader2 [100]
2012-09-26 19:44:35
[11 years, 185 days ago]

Agh right so what do you mean it will make it slower


 
Gpof2 [130]
2012-09-26 20:08:31
[11 years, 185 days ago]

I just thought I recalled Ender stating something about the load time, I'm not 100% certain.


 
MGK [108]
2012-09-26 20:34:38
[11 years, 185 days ago]

The Javascript Sorter takes no time at all?


 
Gpof2 [130]
2012-09-26 20:38:08
[11 years, 185 days ago]

It doesn't have to calculate the EPH for thousands of bots on there.


 
MGK [108]
2012-09-26 20:39:38
[11 years, 185 days ago]

Right. It's a client add-on. So once Ed loads the EPH for each bot "on the fly", it can then order them however.

It won't however pick the a new "list" of bots with a really EPH. You'll only be able to sort the 100 shown.


 
Nosferatu [155]
2012-09-26 22:00:14
[11 years, 185 days ago]

Do you understand what "on the fly" means? It means every time you look at a page where it displays a bots EPH, it calculates that for you right then or there. Also, the EPH is a constantly moving number. In order for you to be able to sort this it'd have to be just as fluid as EPH is, which I don't think would be very easy considering the way EPH is done.


 
MGK [109]
2012-09-26 22:07:44
[11 years, 185 days ago]

My fuck.

I understand what "on the fly means". Do you understand the power of javascript?

It's what outputs training, the showroom, workshop buttons, buffs, achievements. Etc. The page doesn't load every single output of a fight. It doesn't load every single time you push + on the strength button to increase strength. Let's try this again.

http://i.imgur.com/jg8Vx.png

See that? It's also "on the fly". It's a client side add-on. It doesn't reload the table. You don't get new results. It just orders the current table on the fly. You can only order the 100 results that it initially loads the first time because IT DOESN'T LOAD A NEW PAGE.

Have you ever coded anything? It's javascript. Powerful, light-weight and amazing. Anymore questions?


 
Gpof2 [130]
2012-09-26 22:26:22
[11 years, 185 days ago]

It doesn't reload the table. You don't get new results.

EPH will change every time someone gains energy or loses it. There will be new results constantly, so "on the fly" means everything is calculated the moment you load it. The table you keep referencing is exactly the same every time, there's no new data, ever. That one could be typed in excel for Christ's sake, it barely has anything to do with what javascript can and cannot do.


 
Ender [1]
Administrator
2012-09-27 00:07:40
[11 years, 185 days ago]

How about each clan sortable by all fields?

Whoops, it does appear that that was the original suggestion. I'll work on adding that eventually too.

why is there not clan average level? >.>

I think this got dropped when the clan rankings page got redesigned. The rationale was that the horizontal space was needed for other stuff (and average level doesn't play into anything formula-wise), but eyeballing it now it looks like there is room.

How about a column for total clan EPH?

As others mentioned, this is a technically hard thing to do because calculating a bot's EPH is done on the fly and is a relatively expensive operation. Showing it on the clan rankings page would involve computing it for all bots in clans in the game, which would take too long. That leaves caching, which isn't unreasonable, but not ideal.


 
Nosferatu [155]
2012-09-27 00:07:59
[11 years, 185 days ago]

Hopefully Ender can clear up the confusion we're apparently having in attempting to illustrate to one another why it can or can't be done.


 
MGK [109]
2012-09-27 00:08:46
[11 years, 185 days ago]

The javascript sorting table is the thing to use...


 
User Name [232]
2012-09-27 00:11:32
[11 years, 185 days ago]

Ok, does MGK = Alan?


 
MGK [109]
2012-09-27 00:12:31
[11 years, 185 days ago]

Well damn.


 
Ender [1]
Administrator
2012-09-27 00:31:16
[11 years, 185 days ago]

The issue with sorting clans by EPH is calculating the EPH. Sorting itself is not the hard part, which yes, could be done with JavaScript.


 
Leader2 [100]
2012-09-27 02:36:38
[11 years, 185 days ago]

So you can't implement the eph thing soon then? And your implementing the inside clan sorters aswell??


 
Gpof2 [130]
2012-09-27 02:38:14
[11 years, 185 days ago]

He plans on adding the sorting to clan pages sometime, but EPH sorting seems unlikely.


 
Inferno [100]
2012-09-30 00:49:31
[11 years, 182 days ago]

Having the rank column and monthly energy column is slightly redundant, they both list clans in the same order.

Other than that, I like it :)


 
Spaw4 [87]
2012-09-30 02:20:00
[11 years, 182 days ago]

but... it calculates the EPH when you load the page now... so adding something to sort it after its loaded doesn't seem like it should be that complicated?


 
Jans [87]
2012-09-30 03:38:02
[11 years, 182 days ago]

Yea, the clan's profile shows eph for each member, and could be made sortable. You can sort a table on any column really.


 
Nosferatu [155]
2012-09-30 12:06:40
[11 years, 182 days ago]

I still don't think you all understand EPH and how it's calculated and displayed.


 
Zal [133]
2012-09-30 12:59:15
[11 years, 182 days ago]
I still don't think you all understand EPH and how it's calculated and displayed.

The formula is simple. It's (((black magic)/(wizardry)) x (hoodwinks)) + (Ender's special sauce).


 
Jans [87]
2012-09-30 14:15:21
[11 years, 182 days ago]

@nos; a clan's profile already shows eph per member (since it has all the individual members' data, unlike the clan ranking).


 
MGK [109]
2012-09-30 23:22:31
[11 years, 181 days ago]

Let's try this one more time Nos.

  • You click "Clan Profile"
  • Request sent to server
  • Fancy backend what not making the clan profile
  • EPH formula for each member is calculated
  • Output of server is sent to your browser
  • Browser does everything it needs to make it readable to your eyes
  • Page load done.

Now with the fancy Javascript Sorting Table plugin. All the above is done. THEN.

  • You click on a column, say EPH
  • Javascript takes the table and orders it
  • No page load.

 
User Name [236]
2012-10-01 00:23:13
[11 years, 181 days ago]

Let's try this then. In the amount of time it takes you to "sort" your EPH someones EPH might have changed. Therefor because you're is loading data previously recorded and not "real time" data then the numbers would be off?


 
User Name [236]
2012-10-01 00:23:43
[11 years, 181 days ago]

Therefor because yours* is loading data previously recorded and not "real time" data then the numbers would be off.


 
Incorrect [1]
2012-10-01 01:47:15
[11 years, 181 days ago]
Therefor

*Therefore

Therefor

*Therefore

yours*

**yours

.

*?


 
Jans [87]
2012-10-01 02:45:49
[11 years, 181 days ago]
Let's try this then. In the amount of time it takes you to "sort" your EPH someones EPH might have changed.

The same goes for the energy-column and is not the reason why eph isn't on the clan ranking page.

The reason is, it takes a lot more server resources to create a clan ranking page with eph than it does without, because it would need to calculate individual eph's for every member in every clan. That's 2500 additional calculations, just to create a clan ranking page. Which wouldn't be so bad if the page was then cached for a while, but i think it's done on the fly, for every prick that clicks it.

A clan profile does show eph, because all data needed to calculate it is already there, and there's a natural maximum of 20. While the clan ranking page could grow even larger than it is now.


 
MGK [109]
2012-10-01 08:36:34
[11 years, 181 days ago]

I thought we were talking about the clan profile. Not the ranking page.

It depends on how clans are stored. I usually do it like this.

  • Clan table

-- With and Id, Name, founder, treasury amount, founding date

  • User table

-- With a clan Id, that refers to the clan table.

When you loop through the clan ranking page with this set up, you have to loop through every member anyway. An extra formula wouldn't be that big of a deal, since the energy transfer page is still on here.


 
MGK [109]
2012-10-01 08:37:37
[11 years, 181 days ago]

Also, if we are talking about accuracy of the result you are trying to order, why are we not complaining about wins/losses/level ups?

That's in real time also. :P


 
Gpof2 [130]
2012-10-01 09:12:30
[11 years, 181 days ago]

Those don't require calculations or formulas.


 
MGK [109]
2012-10-01 13:46:26
[11 years, 181 days ago]

Level does..


 
Nosferatu [155]
2012-10-01 15:35:17
[11 years, 180 days ago]

Lol...


 
MGK [109]
2012-10-01 15:57:20
[11 years, 180 days ago]

:)


 
Ender [1]
Administrator
2012-10-01 22:23:51
[11 years, 180 days ago]

There's a ton of confusion in this thread and I think a lot of it is because some people are talking about one thing (clan rankings page with all clans, let's call this "clan rankings") and others are talking about another (individual clan pages with members of that clan, let's call this "clan profile"). Here's my attempt at clearing this up:

  • The update that was already made was to make the "clan rankings" page sortable.
  • A later update will make the "clan profile" page sortable as well, including by EPH, which is already a column there. As Jans mentioned, this is fine because the number of bots to calculate EPH for on the "clan profile" page is naturally bounded at 20.
  • There is unlikely to be a later update that makes the "clan rankings" page sortable by EPH, which is not already a column there. EPH is not shown on this page because it is an expensive calculation and doing this for every bot in the game in a clan (an increasing and unbounded number) on every page load is prohibitively expensive. Note that there are potentially caching solutions to this.

 
MGK [109]
2012-10-02 08:31:45
[11 years, 180 days ago]

You could limit the amount of clans to show at 100.
or
Put the energy transfer tables on a different page.

To speed up load times of course. Just sayin.


 
Nosferatu [155]
2012-10-02 08:39:04
[11 years, 180 days ago]

Although that might be a solution MGK, I like the way it is now and the ability to see all of the clans.


 
MGK [109]
2012-10-02 08:44:34
[11 years, 180 days ago]

That's true. Either or.

I like giving ideas. :D


 
User Name [238]
2012-10-02 09:57:45
[11 years, 180 days ago]

A later update will make the "clan profile" page sortable as well, including by EPH, which is already a column there. As Jans mentioned, this is fine because the number of bots to calculate EPH for on the "clan profile" page is naturally bounded at 20.

Does this mean that it would be possible to do a Clan EPH within the Clan information?


 
Jans [87]
2012-10-02 10:38:09
[11 years, 180 days ago]
Does this mean that it would be possible to do a Clan EPH within the Clan information?

You mean like 'total EPH' or 'avg EPH' for the clan? Either way, yes, since EPH of all members has already been calculated at that point.


 
User Name [238]
2012-10-02 11:01:22
[11 years, 180 days ago]

I think Total Clan EPH would be more beneficial.


 
MGK [109]
2012-10-02 12:01:22
[11 years, 180 days ago]

Total Clan EPH would be pretty bad ass.


 
Forum > Announcements > Clan ranking sorting
Reply To Thread (login)