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); }