function newModerator($option, $id = null) { $kunena_app =& JFactory::getApplication(); $kunena_db =& JFactory::getDBO(); //die ("New Moderator"); //$limit = intval(JRequest::getVar( 'limit', 10)); //$limitstart = intval(JRequest::getVar( 'limitstart', 0)); $limit = $kunena_app->getUserStateFromRequest("global.list.limit", 'limit', $kunena_app->getCfg('list_limit'), 'int'); $limitstart = $kunena_app->getUserStateFromRequest("{$option}.limitstart", 'limitstart', 0, 'int'); $kunena_db->setQuery("SELECT COUNT(*) FROM #__users AS a LEFT JOIN #__kunena_users AS b ON a.id=b.userid WHERE b.moderator=1"); $total = $kunena_db->loadResult(); if (KunenaError::checkDatabaseError()) { return; } if ($limitstart >= $total) { $limitstart = 0; } if ($limit == 0 || $limit > 100) { $limit = 100; } $kunena_db->setQuery("SELECT * FROM #__users AS a LEFT JOIN #__kunena_users AS b ON a.id=b.userid WHERE b.moderator=1", $limitstart, $limit); $userList = $kunena_db->loadObjectList(); if (KunenaError::checkDatabaseError()) { return; } $countUL = count($userList); jimport('joomla.html.pagination'); $pageNav = new JPagination($total, $limitstart, $limit); //$id = intval( JRequest::getVar('id') ); //get forum name $forumName = ''; $kunena_db->setQuery("SELECT name FROM #__kunena_categories WHERE id={$id}"); $forumName = $kunena_db->loadResult(); if (KunenaError::checkDatabaseError()) { return; } //get forum moderators $kunena_db->setQuery("SELECT userid FROM #__kunena_moderation WHERE catid={$id}"); $moderatorList = $kunena_db->loadObjectList(); if (KunenaError::checkDatabaseError()) { return; } $moderators = 0; $modIDs[] = array(); if (count($moderatorList) > 0) { foreach ($moderatorList as $ml) { $modIDs[] = $ml->userid; } $moderators = 1; } else { $moderators = 0; } html_Kunena::newModerator($option, $id, $moderators, $modIDs, $forumName, $userList, $countUL, $pageNav); }
function newModerator($option, $id = null) { $app =& JFactory::getApplication(); $kunena_db =& JFactory::getDBO(); //die ("New Moderator"); //$limit = intval(JRequest::getVar( 'limit', 10)); //$limitstart = intval(JRequest::getVar( 'limitstart', 0)); $limit = $app->getUserStateFromRequest("global.list.limit", 'limit', $app->getCfg('list_limit'), 'int'); $limitstart = $app->getUserStateFromRequest("{$option}.limitstart", 'limitstart', 0, 'int'); $kunena_db->setQuery("SELECT COUNT(*) FROM #__users AS a" . "\n LEFT JOIN #__fb_users AS b" . "\n ON a.id=b.userid where b.moderator=1"); $kunena_db->query() or trigger_dberror('Unable to load moderators w/o limit.'); $total = $kunena_db->loadResult(); if ($limitstart >= $total) { $limitstart = 0; } if ($limit == 0 || $limit > 100) { $limit = 100; } $kunena_db->setQuery("SELECT * FROM #__users AS a" . "\n LEFT JOIN #__fb_users AS b" . "\n ON a.id=b.userid" . "\n WHERE b.moderator=1", $limitstart, $limit); $userList = $kunena_db->loadObjectList(); check_dberror('Unable to load moderators.'); $countUL = count($userList); jimport('joomla.html.pagination'); $pageNav = new JPagination($total, $limitstart, $limit); //$id = intval( JRequest::getVar('id') ); //get forum name $forumName = ''; $kunena_db->setQuery("select name from #__fb_categories where id={$id}"); $kunena_db->query() or trigger_dberror('Unable to load forum name.'); $forumName = $kunena_db->loadResult(); //get forum moderators $kunena_db->setQuery("select userid from #__fb_moderation where catid={$id}"); $moderatorList = $kunena_db->loadObjectList(); check_dberror('Unable to load moderator.'); $moderators = 0; $modIDs[] = array(); if (count($moderatorList) > 0) { foreach ($moderatorList as $ml) { $modIDs[] = $ml->userid; } $moderators = 1; } else { $moderators = 0; } html_Kunena::newModerator($option, $id, $moderators, $modIDs, $forumName, $userList, $countUL, $pageNav); }