How to check for mass-PM senders

[z0diac]

My forum usually has between 5 and 10 PMs per week (as shown to me in my weekly CodeCall stats mod).

I just started going back through previous weeks, and noticed some weeks have 600+ PMs, then it goes back down to 6 or 7.

I'm guessing it's a spammer account that isn't publicly posting, but is sending PMs instead. (yes I have delay between PMs set to 60 - I just upped it to 300s)

Is there a mod/hack out there that can list users according to how many PMs they've sent? (and even better yet, within a certain time frame, ie: last 7 days)

??

[Lovinmysailor]

If you go to your admin cp>Users>private message stats it will show you the number of messages people have. If you click that it will tell you who has those private messages.

[z0diac]

Originally Posted by Lovinmysailor

If you go to your admin cp>Users>private message stats it will show you the number of messages people have. If you click that it will tell you who has those private messages.

THanks for the reply.

Yes, that will show who HAS pms.. but I want to know who's SENDING all these msgs. If there's any way to list/rank users according to PMs *sent*, that's what I need.

I'm guessing there's a user on there that is mass-PM'ing people and I need to find out who it is (as it's obviously someone spamming my userbase via PMs)

[wolfyman]

good question.

[ChopSuey]

Make an announcement or stickky to your users. Have them report the PM's then you will see the spammers....

[z0diac]

Originally Posted by ChopSuey

Make an announcement or stickky to your users. Have them report the PM's then you will see the spammers....

I would, but most users are inactive and just show up to download the files.

I'll see if I can get someone to write a script that will go through all existing PMs in the dbase and just make up a ranking of sender names.

[Hellspire]

Just passing through here for an unrelated reason but out of boredom decided to show whoever is interested how to do this... in sql the query looks something like this

select p.pmtextid,t.fromuserid,u.username,count(*),t.titl e,t.message from pm as p left join pmtext as t on(p.pmtextid = t.pmtextid) left join user as u on(t.fromuserid=u.userid) group by p.pmtextid ORDER BY count(*) DESC

shows the highest mass pms. integrate this into whatever code you see fit.