Support Forum

Top posters

1
Stefano Prete
Melbourne, Australia
Member
Free Members
Apr 20, 2018 - 3:16 pm

Hi guys.

I have a few people who used to be members but they are not any longer. They still appear in the stats at the bottom of the page under "Top Posters".

I would love to remove those guys from there, but I cannot find a way...

I looked at the database in phpMyAdmin and I cannot find the table containing those datas.

Can you please tell me what to do?

Thanks!

Yellow Swordfish
Glinton, England
Member
Apr 22, 2018 - 3:51 pm

It is probably not going to be that easy but I will look into the code...

Stefano Prete
Melbourne, Australia
Member
Free Members
Apr 22, 2018 - 4:43 pm

Thank you Andy!

If it's easy OK, otherwise it can stay as it is...

Yellow Swordfish
Glinton, England
Member
Apr 24, 2018 - 4:44 am

The problem, as I see it, is that there is no single method for determining the status of a user. Each forum user may well have a different methodology for doing this. We can, of course, make a determination but the impact on the stats query would not be nice.

But I have no stopped trying to work something out that might do the job...

Stefano Prete
Melbourne, Australia
Member
Free Members
Apr 24, 2018 - 11:57 am

Andy, aren't those names in the database somewhere?

If so, they can be removed from there I suppose...

Yellow Swordfish
Glinton, England
Member
Apr 24, 2018 - 12:32 pm

If you mean is there a database entry specifically to hold the top posters list then yes there is. But it is also re-queried regularly (by default once an hour) so that it is kept up to date and this requery will then change it back to the proper list.

If you mean that these user records exist then yes - again they do. But removing them manually would render their posts orphaned and probably cause chaos al over the place!

The only realistic way of doing this is if we can find a safe way to massage the query.

When one of your users dispenses with their membership, what do you do with them? Do they get moved to a specific SP user group?

1