That’d be awesome if possible Robin, I’m just doing the upgrade and changing to this plugin now
If I’m not mistaken, it looks like the SitePoint plugin created a topic of the private_message archetype.
I think querying for an OP that is Staff could be doable.
Querying for OP == “self member” could be a bit more. And who knows how many non-staff used the plugin.
I know I have, and being forewarned I’ll copy them over to my Clippings now.
@cpradio maybe a type of general notice is in order? or maybe ignorance will be bliss.
(i,e, an announcement may cause more upset over losing something they never knew they had than it’s worth)
Yeah, I lean towards the latter, that 90% likely don’t use it. I may warn Mentors though, as they’ll lose theirs too.
@santouras, YAY! If you want a group to test the upgrade before releasing it to Production, let me know. I’ll set something up.
I just put together a query
It’s more verbose than it needs to be and there is redundancy, but it could be a start
SELECT topics.id AS topics_id , topics.title AS topics_title , topics.user_id AS topics_user_id , topics.subtype AS topics_subtype , topics.slug AS topics_slug , posts.id AS posts_id , posts.user_id AS posts_user_id , posts.topic_id AS posts_topic_id , users.id AS users_id , users.admin AS users_admin , users.moderator AS users_moderator FROM topics JOIN posts ON topics.user_id = posts.user_id JOIN users ON posts.user_id = users.id WHERE topics.archetype = 'private_message' AND topics.subtype NOT LIKE 'system_message' AND topics.subtype NOT LIKE 'moderator_warning' AND topics.subtype NOT LIKE 'notify_moderators' AND posts.post_number = 1 AND posts.deleted_at IS NULL AND NOT users.admin AND NOT users.moderator
the last 2 "NOT"s find non-staff