The most fisted?

[Broseph]

It's not working properly.

 

[Abelian]

Infinitron has 28,528 posts since XF, but only 27,084 for all time (didn't notice anyone else with this problem). Also clicking Posts (XF), Ratio (XF) does not sort by the column, by the Brofists column.

 

[DarkUnderlord]

Yeah, I can't make those last two columns sortable until I rework the query.

And not sure on Infinitron's post count. The "Since XF" is an actual count of posts, could be the post number didn't get updated at some times, and given he's such a prolific spammer it's happened so much it became noticeable. Re-building the cache didn't seem to fix it though, will see if there's a way to recount.

Might just run a manual update query and rape the db for a while.

 

[Crane]

Whoever is the most fisted probably has an ass that's in pretty rough shape.

Has that joke been made any time in the past 10 pages?

 

[Abelian]

The query performance will improve with a materialized view that uses the same query, and refreshes once per day. It's not like the relative ranking will significantly change during one day. That will also make the last two columns sortable.

 

[Jasede]

BETTER RATIO THAN DRAQ
MY LIFE IS NOW COMPLETE

 

[Crooked Bee]

WTF is this pointless shit? Can't you take care of our Project Eternity survey(s) instead?

 

[Infinitron]

http://www.rpgcodex.net/brofists.php?sort=ratio

Meaningless.

It's a useless list; it's only useful for people who registered past the date brofists were enabled.

o'rly? Look again.

Query's a bit slow because I haven't optimised it. Yet.

Why do some people have more posts since XF then they have overall?

 

[Gakkone]

Even the fucking database can't keep up with your spamming.

 

[Kz3r0]

http://www.rpgcodex.net/brofists.php?sort=ratio

4Jugashvili