function pendingApprovalUsers($option) {
global $_CB_framework, $_CB_database, $ueConfig;
$isModerator = isModerator( $_CB_framework->myId() );
if($ueConfig['allowModUserApproval']==0) {
echo _UE_FUNCTIONALITY_DISABLED;
exit();
}
if (!$isModerator){
cbNotAuth();
return;
}
$_CB_database->setQuery( "SELECT u.id, u.name, u.username, u.email, u.registerDate "
."\n FROM #__users u, #__comprofiler c "
."\n WHERE u.id=c.id AND c.approved=0 AND c.confirmed=1" );
$rows = $_CB_database->loadObjectList();
HTML_comprofiler::pendingApprovalUsers($option, $rows);
}
function pendingApprovalUsers($option)
{
global $_CB_framework, $_CB_database, $_PLUGINS, $ueConfig;
if ($ueConfig['allowModUserApproval'] == 0) {
$_CB_framework->enqueueMessage(CBTxt::Th('UE_FUNCTIONALITY_DISABLED', 'This functionality is currently disabled.'), 'error');
return;
}
$isModerator = Application::MyUser()->isGlobalModerator();
if (!$isModerator) {
cbNotAuth(true);
return;
}
$_PLUGINS->loadPluginGroup('user');
$query = 'SELECT *' . "\n FROM " . $_CB_database->NameQuote('#__users') . " AS u" . "\n LEFT JOIN " . $_CB_database->NameQuote('#__comprofiler') . " AS c" . ' ON c.' . $_CB_database->NameQuote('id') . ' = u.' . $_CB_database->NameQuote('id') . "\n WHERE " . $_CB_database->NameQuote('approved') . " = 0" . "\n AND " . $_CB_database->NameQuote('confirmed') . " = 1";
$_CB_database->setQuery($query);
$users = $_CB_database->loadObjectList(null, '\\CB\\Database\\Table\\UserTable', array(&$_CB_database));
HTML_comprofiler::pendingApprovalUsers($option, $users);
}
