Advertisement:

Author Topic: User post counts by month?  (Read 231 times)

Offline khigh

  • Jr. Member
  • **
  • Posts: 154
User post counts by month?
« on: December 06, 2017, 06:16:07 PM »
Hi all.

I'm trying to do a raffle, where each post is an entry. Probably some other stuff, too - like topic starts count double - referrals worth 10 - that kind of thing.

Doesn't look like there's any mods for that, and that's fine. I can work the specifics of the drawing. I'm just trying to see post counts per member based on a timeframe somewhere in stats. I got a mod called something like "top ten posters", but that's all I get - just the top ten. Technically a single poster could win, so I need it all the way down to individual posters.

Any way to track that? Quite possibly already built in that I'm overlooking?

Thanks for looking.

Offline Colin

  • Lead Developer
  • SMF Hero
  • *
  • Posts: 7,760
  • Gender: Male
  • SMF Developer
    • colinschoen on GitHub
Re: User post counts by month?
« Reply #1 on: December 06, 2017, 07:06:50 PM »
Hmm, interesting. That seems like a unique idea. There isn't an easy way to get that information now. Seems like a good candidate for the Mod Requests board.
"If everybody is thinking alike, then somebody is not thinking." - Gen. George S. Patton Jr.

Colin

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,340
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: User post counts by month?
« Reply #2 on: December 06, 2017, 07:48:25 PM »
You can do with an SQL query based on the smf_messages table just do a time range and group by id_member
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline khigh

  • Jr. Member
  • **
  • Posts: 154
Re: User post counts by month?
« Reply #3 on: December 06, 2017, 08:40:07 PM »
You can do with an SQL query based on the smf_messages table just do a time range and group by id_member

Is that per member? or I can get a report for all members at once?


Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,340
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: User post counts by month?
« Reply #4 on: December 06, 2017, 08:42:49 PM »
That would get all memember at once .

Sudo code select id_member, count(*) from smf_messages where daterangehere group by id_member
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline khigh

  • Jr. Member
  • **
  • Posts: 154
Re: User post counts by month?
« Reply #5 on: December 06, 2017, 09:22:34 PM »
Hmm, interesting. That seems like a unique idea. There isn't an easy way to get that information now. Seems like a good candidate for the Mod Requests board.

OK - thanks. I don't mind doing it in the MySQL if I can figure out how, but if I can't sort that I'll likely request a mod

Offline khigh

  • Jr. Member
  • **
  • Posts: 154
Re: User post counts by month?
« Reply #6 on: December 06, 2017, 09:24:05 PM »
That would get all memember at once .

Sudo code select id_member, count(*) from smf_messages where daterangehere group by id_member

Is there a way to get it without shell access? like Phpmyadmin? I'm using a hosting service.

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,340
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: User post counts by month?
« Reply #7 on: December 06, 2017, 09:32:24 PM »
yes you can run sql queries in phpmyadmin
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro