| @@ 56-67 (lines=12) @@ | ||
| 53 | . ' DESC'; |
|
| 54 | $result = $xoopsDB->query($sql, $options[1], 0); |
|
| 55 | ||
| 56 | if ($totalwords > 0) { // If there are definitions |
|
| 57 | while (list($entryID, $categoryID, $term, $datesub) = $xoopsDB->fetchRow($result)) { |
|
| 58 | $newentries = []; |
|
| 59 | $linktext = ucfirst($myts->htmlSpecialChars($term)); |
|
| 60 | $newentries['dir'] = $lexikon->dirname(); |
|
| 61 | $newentries['linktext'] = $linktext; |
|
| 62 | $newentries['id'] = (int)$entryID; |
|
| 63 | $newentries['date'] = formatTimestamp($datesub, $lxConfig['dateformat']); |
|
| 64 | ||
| 65 | $block['newstuff'][] = $newentries; |
|
| 66 | } |
|
| 67 | } |
|
| 68 | ||
| 69 | return $block; |
|
| 70 | } |
|
| @@ 98-111 (lines=14) @@ | ||
| 95 | . " AND datesub > 0 AND submit = '0' AND offline = '0' AND request = '0' " |
|
| 96 | . $catperms |
|
| 97 | . ' ORDER BY datesub DESC', (int)$xoopsModuleConfig['blocksperpage'], 0); |
|
| 98 | if ($publishedwords > 0) { // If there are definitions |
|
| 99 | //while (list( $entryID, $term, $datesub ) = $xoopsDB->fetchRow($result05)) { |
|
| 100 | while (list($entryID, $categoryID, $term, $datesub) = $xoopsDB->fetchRow($result05)) { |
|
| 101 | $newentries = []; |
|
| 102 | $xoopsModule = XoopsModule::getByDirname('lexikon'); |
|
| 103 | $linktext = mb_ucfirst($myts->htmlSpecialChars($term)); |
|
| 104 | $newentries['linktext'] = $linktext; |
|
| 105 | $newentries['id'] = $entryID; |
|
| 106 | $newentries['date'] = formatTimestamp($datesub, 's'); |
|
| 107 | ||
| 108 | $block1['newstuff'][] = $newentries; |
|
| 109 | } |
|
| 110 | $xoopsTpl->assign('block', $block1); |
|
| 111 | } |
|
| 112 | ||
| 113 | // To display the most read entries block |
|
| 114 | $block2 = []; |
|