XoopsModules25x / lexikon

    if ($thisterm['offline'] == 1 && !$xoopsUserIsAdmin) {

        redirect_header('javascript:history.go(-1)', 3, _MD_LEXIKON_ENTRYISOFF);

    }

    if ($xoopsModuleConfig['multicats'] == 1) {

        $thisterm['categoryID'] = (int)$categoryID;

        $catname                = $xoopsDB->query('SELECT name FROM '

                                                  . $xoopsDB->prefix('lxcategories')

                                                  . " WHERE categoryID = $categoryID ");

        while (list($name) = $xoopsDB->fetchRow($catname)) {

            $thisterm['catname'] = $myts->htmlSpecialChars($name);

        }

    }

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

        $eachentry['dir'] = $xoopsModule->dirname();

        if ($xoopsModuleConfig['multicats'] == 1) {

            $eachentry['catid'] = (int)$categoryID;

            $resultF            = $xoopsDB->query('SELECT name FROM '

                                                  . $xoopsDB->prefix('lxcategories')

                                                  . " WHERE categoryID = $categoryID ORDER BY name ASC");

            while (list($name)  = $xoopsDB->fetchRow($resultF)) {

                $eachentry['catname'] = $myts->htmlSpecialChars($name);

            }

        }

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

        $eachentry['dir'] = $xoopsModule->dirname();

        if ($xoopsModuleConfig['multicats'] == 1) {

            $eachentry['catid'] = (int)$categoryID;

            $resultF            = $xoopsDB->query('SELECT name FROM '

                                                  . $xoopsDB->prefix('lxcategories')

                                                  . " WHERE categoryID = $categoryID ORDER BY name ASC");

            while (list($name) = $xoopsDB->fetchRow($resultF)) {

                $eachentry['catname'] = $myts->htmlSpecialChars($name);

            }

        }

        $eachentry['id']   = (int)$entryID;

                            . $xoopsDB->prefix('lxentries')

                            . " WHERE entryID=$entryID");

$sqlfetch = $xoopsDB->fetchArray($sqlQuery);

if ($xoopsModuleConfig['multicats'] == 1) {

    $cID       = $sqlfetch['categoryID'];

    $sqlquery2 = $xoopsDB->query('SELECT name FROM '

                                  . $xoopsDB->prefix('lxcategories')

                                  . " WHERE categoryID = $cID");

    $sqlfetch2 = $xoopsDB->fetchArray($sqlquery2);

    $catname   = $myts->htmlSpecialChars($sqlfetch2['name']);

}

$term       = $myts->htmlSpecialChars($sqlfetch['term']);