XoopsModules25x / lexikon

    echo '</select></div>';

}

    public static function calculateTotals()

    {

        global $xoopsUser, $xoopsDB, $xoopsModule;

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

        $gpermHandler = xoops_getHandler('groupperm');

        $result01 = $xoopsDB->query('SELECT categoryID, total FROM ' . $xoopsDB->prefix('lxcategories') . ' ');

        list($totalcategories) = $xoopsDB->getRowsNum($result01);

        while (list($categoryID, $total) = $xoopsDB->fetchRow($result01)) {

            if ($gpermHandler->checkRight('lexikon_view', $categoryID, $groups, $xoopsModule->getVar('mid'))) {

                $newcount = LexikonUtility::countByCategory($categoryID);

                $xoopsDB->queryF('UPDATE ' . $xoopsDB->prefix('lxcategories') . " SET total = '$newcount' WHERE categoryID = '$categoryID'");

            }

        }

    }

    /**

     * @param $c

    echo "</select></div>";

}

function lx_calculateTotals() {

    global $xoopsUser, $xoopsDB, $xoopsModule;

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

    $gperm_handler = xoops_gethandler('groupperm');

    $result01 = $xoopsDB -> query( "SELECT categoryID, total FROM " . $xoopsDB -> prefix( "lxcategories" ) . " " );

    list ( $totalcategories ) = $xoopsDB -> getRowsNum( $result01 );

    while (list ( $categoryID, $total ) = $xoopsDB -> fetchRow ( $result01 )) {

        if ($gperm_handler->checkRight('lexikon_view', $categoryID, $groups, $xoopsModule->getVar('mid'))) {

            $newcount = lx_countByCategory ( $categoryID );

            $xoopsDB -> queryF( "UPDATE " . $xoopsDB -> prefix( "lxcategories" ) . " SET total = '$newcount' WHERE categoryID = '$categoryID'");

        }

    }

}

function lx_countByCategory( $c ) {

    global $xoopsUser, $xoopsDB, $xoopsModule;