XoopsModules25x / lexikon

                                   . " AND datesub > 0 AND submit = '1' AND offline = '1' AND request = '0' ORDER BY term");

    $totalSwords = $xoopsDB->getRowsNum($resultS);

    if ($totalSwords > 0) { // If there are definitions

        while (list($entryID, $term) = $xoopsDB->fetchRow($resultS)) {

            $subentries             = array();

            $xoopsModule            = XoopsModule::getByDirname('lexikon');

            $linktext               = mb_ucfirst($myts->htmlSpecialChars($term));

            $subentries['linktext'] = $linktext;

            $subentries['id']       = $entryID;

            $blockS['substuff'][] = $subentries;

        }

        $xoopsTpl->assign('blockS', $blockS);

        $xoopsTpl->assign('wehavesubs', 1);

    } else {

        $xoopsTpl->assign('wehavesubs', 0);

    }

    $blockR      = array();

    $resultR     = $xoopsDB->query('SELECT entryID, term FROM ' . $xoopsDB->prefix('lxentries') . ' WHERE datesub < ' . time() . " AND datesub > 0 AND request = '1' ORDER BY term");

    $resultR     = $xoopsDB->query('SELECT entryID, term FROM ' . $xoopsDB->prefix('lxentries') . ' WHERE datesub < ' . time() . " AND datesub > 0 AND request = '1' ORDER BY term");

    $totalRwords = $xoopsDB->getRowsNum($resultR);

    if ($totalRwords > 0) { // If there are definitions

        while (list($entryID, $term) = $xoopsDB->fetchRow($resultR)) {

            $reqentries             = array();

            $xoopsModule            = XoopsModule::getByDirname('lexikon');

            $linktext               = mb_ucfirst($myts->htmlSpecialChars($term));

            $reqentries['linktext'] = $linktext;

            $reqentries['id']       = $entryID;

            $blockR['reqstuff'][] = $reqentries;

        }

        $xoopsTpl->assign('blockR', $blockR);

        $xoopsTpl->assign('wehavereqs', 1);

    } else {

        $xoopsTpl->assign('wehavereqs', 0);

    }

} else {

    $xoopsTpl->assign('userisadmin', 0);

    $blockR      = array();

    $resultR     = $xoopsDB->query('SELECT entryID, term FROM ' . $xoopsDB->prefix('lxentries') . ' WHERE datesub < ' . time() . " AND datesub > 0 AND request = '1' " . $catperms . ' ORDER BY term');

    $totalRwords = $xoopsDB->getRowsNum($resultR);

    if ($totalRwords > 0) { // If there are definitions

        while (list($entryID, $term) = $xoopsDB->fetchRow($resultR)) {

            $reqentries             = array();

            $xoopsModule            = XoopsModule::getByDirname('lexikon');

            $linktext               = mb_ucfirst($myts->htmlSpecialChars($term));

            $reqentries['linktext'] = $linktext;

            $reqentries['id']       = $entryID;

            $blockR['reqstuff'][] = $reqentries;

        }

        $xoopsTpl->assign('blockR', $blockR);

        $xoopsTpl->assign('wehavereqs', 1);

    } else {

        $xoopsTpl->assign('wehavereqs', 0);

    }

}

// Various strings

$xoopsTpl->assign('lang_modulename', $xoopsModule->name());