Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Top posters
Avatar
Stefano Prete
Melbourne, Australia
Member
Free Members
sp_UserOfflineSmall Offline
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!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Apr 22, 2018 - 3:51 pm

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

andy-signature.png
YELLOW
SWORDFISH
Avatar
Stefano Prete
Melbourne, Australia
Member
Free Members
sp_UserOfflineSmall Offline
Apr 22, 2018 - 4:43 pm

Thank you Andy!

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
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...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Stefano Prete
Melbourne, Australia
Member
Free Members
sp_UserOfflineSmall Offline
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...

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
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?

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 618
Members: 17348
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10120
Posts: 79605