Mass prune all PMs (queries)

[Jake Bunce]

Jake Bunce submitted a new resource:

Mass prune all PMs (queries) (version 1.x) - Queries to delete all PMs for all users.

Run these queries to delete all PMs for all users.

TRUNCATE TABLE xf_conversation_master;
TRUNCATE TABLE xf_conversation_message;
TRUNCATE TABLE xf_conversation_recipient;
TRUNCATE TABLE xf_conversation_user;
UPDATE xf_user SET conversations_unread = 0;

Backup first.

Read more about this resource...

 

[Blue]

Any way to do this for particular members only?

 

[Cal]

Jake...excuse this question....but how do we run these queries? Are we doing this in PHPMYADMIN.....or is there a super secret debug area of Xen I don't know about....or what?

 

[Jake Bunce]

Are we doing this in PHPMYADMIN

Yep. The SQL tab in phpmyadmin.

 

[eagle eyes]

Does this work for xenfor 1.2.2

 

[Jake Bunce]

Does this work for xenfor 1.2.2

Yes.

 

[rightclickfix]

wow powerful stuff cheers Jake I bookmarked it so I can run it again.

 

[Puntocom]

Is it safe to run this in XenForo 1.3.2?

 

[Jake Bunce]

Is it safe to run this in XenForo 1.3.2?

Yes.

 

[Rob]

Hi @Jake B., is there any way this query can be amended to delete convos older than six months?
I'd like to wrap this all up in a cron to run once a week.

 

[Jake B.]

Hi @Jake B., is there any way this query can be amended to delete convos older than six months?
I'd like to wrap this all up in a cron to run once a week.

Tagged the wrong person

I'll just leave this here for you: @Jake Bunce

 

[Rob]

Doh.... my bad, wasn't looking!

 

[borbole]

Hi @Jake B., is there any way this query can be amended to delete convos older than six months?
I'd like to wrap this all up in a cron to run once a week.

Have a look at this mod. It looks like it does what you want in regard to pruning pm's.

https://xenforo.com/community/resources/icewind-conversation-tools.2882/

 

[SnoSheriff]

I would like to prune PMs for members who have not logged into their account for over 6 months. How can I do this?