askbug raport for admins

Question

Solved5.31K viewsFebruary 14, 2018Generaladmin Anspress feature mysql raport

0

Hello,

Does anyone made or know how to extract the followings from askbug, in order to build a raport:

I’ve tried something directly from mysql database, like:

select user_nicename, user_email, user_registered from wp_users;
select user_nicename, user_registered from wp_users WHERE user_registered > (DATE(NOW()) – INTERVAL 7 DAY);

but for the rest of them I’m a little bit confused because (eg. number 3) I got all the posts, not only the questions and so on.

Thanks,

Question is closed for new answers.

Applying directly to the mysql is not a good idea. It is better to use the standard functions

Applying directly to the mysql is not a good idea. It is better to use the standard functions

score 0 · Answer 1 · 2018-02-08T17:41:23+00:00

2) total of new users registered during a week

$blogusers = get_users(array(‘date_query’ => array( ‘after’ => ‘1 week ago’ )));
echo count($blogusers);

maybe the code is not the most optimized, but it completely solves your problem.