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               = 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();

                            . $catperms

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

// If there are definitions

if ($publishedwords > 0) {

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

        $popentries             = array();

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

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

        $popentries['linktext'] = $linktext;

        $popentries['id']       = $entryID;

        $popentries['counter']  = (int)$counter;

        $block2['popstuff'][] = $popentries;

    }

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

}

// To display the random term block

list($numrows) = $xoopsDB->fetchRow($xoopsDB->query('SELECT COUNT(*) FROM ' . $xoopsDB->prefix('lxentries') . " WHERE submit = 'O' AND offline = '0' " . $catperms . ' '));