XoopsModules25x / lexikon

    /**

     * @return mixed

     */

public static function countWords()

{

    global $xoopsUser, $xoopsDB;

    $gpermHandler = xoops_getHandler('groupperm');

    $groups       = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;

        /** @var XoopsModuleHandler $moduleHandler */

        $moduleHandler = xoops_getHandler('module');

    $module        = $moduleHandler->getByDirname('lexikon');

    $module_id     = $module->getVar('mid');

    $allowed_cats  = $gpermHandler->getItemIds('lexikon_view', $groups, $module_id);

    $catids        = implode(',', $allowed_cats);

    $catperms      = " AND categoryID IN ($catids) ";

    $pubwords       = $xoopsDB->query('SELECT * FROM ' . $xoopsDB->prefix('lxentries') . " WHERE submit = '0' AND offline ='0' AND request = '0' " . $catperms . ' ');

    $publishedwords = $xoopsDB->getRowsNum($pubwords);

    return $publishedwords;

}

    // To display the list of categories

    /**

    return count($totalcats);

}

function lx_countWords () {

    global $xoopsUser, $xoopsDB;

    $gperm_handler = xoops_gethandler('groupperm');

    $groups = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;

      $module_handler = xoops_gethandler('module');

    $module = $module_handler->getByDirname('lexikon');

    $module_id = $module->getVar('mid');

      $allowed_cats = $gperm_handler->getItemIds("lexikon_view", $groups, $module_id);

      $catids = implode(',', $allowed_cats);

      $catperms = " AND categoryID IN ($catids) ";

    $pubwords = $xoopsDB -> query( "SELECT * FROM " . $xoopsDB -> prefix( "lxentries" ) . " WHERE submit = '0' AND offline ='0' AND request = '0' ".$catperms." " );

    $publishedwords = $xoopsDB -> getRowsNum ( $pubwords );

    return $publishedwords;

}

// To display the list of categories

function lx_CatsArray(){