Notifications
Clear all

Limited Support

Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.

 

Members List - Export to csv?

9 Posts
3 Users
0 Reactions
417 Views
ffooccuuss
Posts: 30
Topic starter
(@ffooccuuss)
Trusted Member
Joined: 1 year ago

It is trivial to export Wordpress users. What I need is the ability to identify Wordpress users who have not posted in wpForo. The posts count is not in a core Wordpress table. Is it possible to obtain the query that produces the wpForo members list? 

[domain]/wp-admin/admin.php?page=wpforo-members

 

Reply
Posts: 19
(@ww_hoax)
Eminent Member
Joined: 2 months ago

I have tried it, and it works, but without any guarantee.

SELECT
  u.ID,
  u.user_login,
  u.user_email,
  u.user_registered,
  u.user_status,
  u.display_name,
  p.title,
  p.groupid,
  p.secondary_groupids,
  p.avatar,
  p.cover,
  p.posts,
  p.topics,
  p.questions,
  p.answers,
  p.comments,
  p.reactions_in,
  p.reactions_out,
  p.points,
  p.custom_points,
  p.online_time,
  p.timezone,
  p.location,
  p.signature,
  p.about,
  p.occupation,
  p.status          AS wpforo_status,
  p.is_email_confirmed,
  p.is_mention_muted
FROM wp_users AS u
LEFT JOIN wp_wpforo_profiles AS p
       ON p.userid = u.ID;

1. Change the prefix of the tables !! wp_ in ??_

2. After running it, click on “Export” at the bottom

3. Select CSV for Excel

4. OK

 

 

Reply
Page 2 / 2