MyBB Community Forums

Is there some sort of script or query that I can run to give me data about my members, for example, how many people get PM email notifications, or how many people use X feature.

To get database information: $db->query("");

More info

I don't know PHP or MySQL, so I don't know anything. Sorry.

I think it'd be something like this:

SELECT COUNT(pmnotify) AS PMEmailNotifications FROM mybb_users WHERE pmnotify='1'

So, using Tom's bit, the query would be this:

$db->query("SELECT COUNT(pmnotify) AS PMEmailNotifications FROM mybb_users WHERE pmnotify='1'");

Am I right??

OK, can I just take the first code and run a Query with it in phpMyAdmin?

Just tested and yes, you can

And I was right, woo!! At least I am learning something here then

(2009-03-07, 09:42 PM)MattRogowski Wrote: [ -> ]I think it'd be something like this:

SELECT COUNT(pmnotify) AS PMEmailNotifications FROM mybb_users WHERE pmnotify='1'

So, using Tom's bit, the query would be this:

$db->query("SELECT COUNT(pmnotify) AS PMEmailNotifications FROM mybb_users WHERE pmnotify='1'");

Am I right??

Yeah Matt, your right.