XoopsModules25x / lexikon

              . ' DESC';

    $result = $xoopsDB->query($sql, $options[1], 0);

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

        while (list($entryID, $categoryID, $term, $datesub) = $xoopsDB->fetchRow($result)) {

            $newentries             = array();

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

            $newentries['dir']      = $lexikon->dirname();

            $newentries['linktext'] = $linktext;

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

            $newentries['date']     = formatTimestamp($datesub, $lxConfig['dateformat']);

            $block['newstuff'][] = $newentries;

        }

    }

    return $block;

}

                            . " AND datesub > 0 AND submit = '0' AND offline = '0' AND request = '0' "

                            . $catperms

                            . ' ORDER BY datesub DESC', (int)$xoopsModuleConfig['blocksperpage'], 0);

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

    //while (list( $entryID, $term, $datesub ) = $xoopsDB->fetchRow($result05)) {

    while (list($entryID, $categoryID, $term, $datesub) = $xoopsDB->fetchRow($result05)) {

        $newentries             = array();

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

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

        $newentries['linktext'] = $linktext;

        $newentries['id']       = $entryID;

        $newentries['date']     = formatTimestamp($datesub, 's');

        $block1['newstuff'][] = $newentries;

    }

    $xoopsTpl->assign('block', $block1);

}

// To display the most read entries block

$block2   = array();