MyBB Community Forums

I'm a noob in PHP, but would love to make at least ONE plugin.

I would like to know...

How to list not activated users in a table ordered by oldest registration date to newest...

How to add a code into all the site's templates and insert it when a new one is imported or made.



Thank you!

You may use the following query for this;

$query = $db->simple_select("users", "*", "usergroup = '5'", array('order_by' => 'regdate', 'order_dir' => 'desc'));
$fetch = $db->fetch_array($query);

Now you can use $fetch as a $variable to use for various purposes.