Decline Where's BROFIST DATA?

[Konjad]

https://rpgcodex.net/brofists.php

SQL Error
Could not select BROFIST DATA.

Can we have most brofisted posts list back? We need to preserve quality content for future generations of 'dexers.

 

[Catacombs]

works on my machine.

 

[Crispy]

Maybe BLOBERT stopped counting them for us.

 

[DarkUnderlord]

Brofists became reactions. At which point looking into the "likes" and expecting to find a single number no longer works.

But it's ok. Modders will fix it.

 

[Konjad]

Brofists became reactions. At which point looking into the "likes" and expecting to find a single number no longer works.

But it's ok. Modders will fix it.

can you link the current brofist to it?

 

[GrafvonMoltke]

Twiglard probably broke it when he was sticking the forum together with twigs and twine. That's what happens when you scrimp on labour costs

EDIT: DU's denial only makes it more true

 

[Zlaja]

If you wanna know someone's brofist number then click on their reactions count and then click on 'Codex button DLC' tab.

 

[Modron]

He isn't after total brofists received you used to be able to look at most brofisted posts on site and an individual's most brofisted posts. Useful to discover random gems. (Most brofisted members was rendered meaningless anyways, the whole blaine's brofist redistribution farce gave like 20 members millions of them)

 

[Zed Duke of Banville]

He isn't after total brofists received you used to be able to look at most brofisted posts on site and an individual's most brofisted posts. Useful to discover random gems. (Most brofisted members was rendered meaningless anyways, the whole blaine's brofist redistribution farce gave like 20 members millions of them)

This was the first suggestion in the Niggling problems remaining in new Codex thread started in July. At first, we had lost even the distribution of posts by forum/subforum; although this was restored in September, it seems the most brofisted posts list was some sort of custom functionality that can only be recreated with difficulty.

 

[KIss My Ass]

I'm going to humiliate kony in front of everyone.

 

[Konjad]

I'm going to humiliate kony in front of everyone.

Less words, more actions.

 

[BLOBERT]

BROS I ONLYTRU TO BROFISTS OR GOLDFIST POSTS CAOSE THE OTHER RATINGS ARE WEIRD

 

[Twiglard]

Was that a most brofisted user list? When rewriting it, there's probably some more useful data to include such as ranking users by brofist count to post ratio, or creating separate tables for other rating types like 'most racist user

'.

But adding many different lists is more complex than simply exporting all the data and letting you generate your own tables.

If I generated tuples of

Ratee,Rater,Rating,Subforum_id,Count

where any of said columns can be skipped to group the lines differently, it should be enough, and wouldn't require special handling for hidden forums.

So you can ask for:

• subforums ordered by brofist count for user A
• subforums ordered by how many brofists were given to user A by user B
• who gave user A how many brofists
• who received the most brofists from user B

This seems overengineered, but that kind of interface can easily be made as a web form that's comprehensible even to non-technical users, and isn't too hard to write.

But you have your own ideas so let's hear it.

 

[Twiglard]

Alright, the above was a dumb idea.

For the record, here's the data from that old brofists page used to provide.

• Brofists (total)
• Posts
• Ratio (B / P)
• Old phpbb3 brofist count provided separately

The last one isn't possible to implement anymore but the rest looks easy enough.

 

[IDtenT]

Hehe. Injects SQL. Not my problem, kid.

 

[Baron Dupek]

They're all stored

Spoiler

Spoiler

Spoiler

in the balls

 

[Twiglard]

Is anybody missing the most brofisted post display?

 

[Modron]

Is anybody missing the most brofisted post display?

Where should I be looking for this display?

If https://rpgcodex.net/brofists.php is the correct place, it says "Not Logged In - You must be logged in to use this feature."

 

[Twiglard]

Where should I be looking for this display?

It used to be available in the old script. Right now only user stats are enabled.

If https://rpgcodex.net/brofists.php is the correct place, it says "Not Logged In - You must be logged in to use this feature."

Now the data is cached once a day so I removed this condition.

Note to self: check if crontab works. crontab works, they get updated at midnight.

 

[Vic]

rusty is #8 on the brofist list

 

[Modron]

Only 3 people have more posts on the codex to brofist than rusty not shocking.

 

[Abu Antar]

Behead those in the top 100 brofisted list.

 

[Konjad]

Right below Avellone senpai in Brofist ratio

Where should I be looking for this display?

It used to be available in the old script. Right now only user stats are enabled.

If https://rpgcodex.net/brofists.php is the correct place, it says "Not Logged In - You must be logged in to use this feature."

Now the data is cached once a day so I removed this condition.

Note to self: check if crontab works. crontab works, they get updated at midnight.

Thanks for the new stuff, but this is not the functionality I was asking in the OP. I meant most brofisted posts, not people - which is what that page displayed in the past.

 

[Twiglard]

this is not the functionality I was asking in the OP. I meant most brofisted posts, not people - which is what that page displayed in the past.

I'm going to add it as the next thing.

Then there are unmerged forum templates and that's the end of my backlog.

 

[Vic]

that’s a lot of “brofists”

 

[Jonathan "Zee Nekomimi]

Right below Avellone senpai in Brofist ratio

Quick delete your posts so u can get those ratios up

*forum crashes*

 

[Modron]

How is this possible?

It's not really possible anymore, I imagine the majority of his posts were during the olden days when brofists were the only rating. Technically you could probably still do this if all your posts were well done Image LPs, cool mod/translation releases, and giveaways.