XoopsModules25x / lexikon

    $resultS = $xoopsDB -> query( "SELECT entryID, term FROM " . $xoopsDB -> prefix( "lxentries" ) . " WHERE datesub < ".time()." 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 = 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 = 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 );

    $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 = 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