assign ( 'firstletter', $init );
include_once XOOPS_ROOT_PATH . '/class/pagenav.php';
include_once XOOPS_ROOT_PATH."/modules/".$xoopsModule->dirname()."/include/cleantags.php";
$start = isset( $_GET['start'] ) ? intval( $_GET['start'] ) : 0;
$pubwords = $xoopsDB -> query( "SELECT * FROM " . $xoopsDB -> prefix( "lxentries" ) . " WHERE submit = '0' AND offline ='0' " );
$publishedwords = $xoopsDB -> getRowsNum ( $pubwords );
$xoopsTpl->assign('publishedwords', $publishedwords);
if ($xoopsModuleConfig['multicats'] == 1)
{
$xoopsTpl->assign('multicats', 1);
}
else
{
$xoopsTpl->assign('multicats', 0);
}
// To display the linked letter list
$alpha = lx_alphaArray();
$xoopsTpl->assign('alpha', $alpha);
$sql = $xoopsDB -> query ( "SELECT * FROM " . $xoopsDB -> prefix ( "lxentries") . " WHERE init = '#' " );
$howmanyother = $xoopsDB -> getRowsNum( $sql );
$xoopsTpl->assign('totalother', $howmanyother);
// To display the list of categories
if ( $xoopsModuleConfig['multicats'] == 1 )
{
lx_getallcategories();
}
// No initial: we need to see all letters
if ( !$init )
{
$entriesarray = array();
$pagetype = 0;
// How many entries will we show in this page?
//$queryA = "SELECT * FROM " . $xoopsDB -> prefix( 'lxentries' ) . " WHERE submit ='0' AND offline = '0' ORDER BY term ASC";
$queryA = "SELECT w. * , c.name AS catname FROM ".$xoopsDB -> prefix( 'lxentries' )." w LEFT JOIN ".$xoopsDB -> prefix( 'lxcategories' )." c ON w.categoryID = c.categoryID WHERE w.submit = '0' AND w.offline = '0' ORDER BY w.term ASC";
$resultA = $xoopsDB -> query ($queryA, $xoopsModuleConfig['indexperpage'], $start );
$allentries = $xoopsDB -> query( "SELECT * FROM " . $xoopsDB -> prefix( "lxentries" ) . " WHERE submit ='0' AND offline = '0' ORDER BY term ASC " );
$totalentries = $xoopsDB -> getRowsNum( $allentries );
$xoopsTpl->assign('totalentries', $totalentries );
while (list( $entryID, $categoryID, $term, $init, $definition, $ref, $url, $uid, $submit, $datesub, $counter, $html, $smiley, $xcodes, $breaks, $block, $offline, $notifypub, $request, $comments, $catname ) = $xoopsDB->fetchRow($resultA))
{
$eachentry = array();
$xoopsModule = XoopsModule::getByDirname("lexikon");
$eachentry['dir'] = $xoopsModule->dirname();
if ($xoopsModuleConfig['multicats'] == 1)
{
//$eachentry['catid'] = intval($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 -> makeTboxData4Show( $catname );
// }
}
$eachentry['id'] = intval($entryID);
$eachentry['term'] = ucfirst($myts -> makeTboxData4Show( $term ));
if ($comments != 0) {
$eachentry['comments'] = "".$comments." "._COMMENTS."";
} else {
$eachentry['comments'] = ""._COMMENTS." ?";
}
if ( !XOOPS_USE_MULTIBYTES )
{
//$deftemp = lx_cleanTags($definition);
$deftemp = lx_html2text($definition); // v 1.17
$deftemp = $myts -> displayTarea ( substr ( $deftemp, 0, ( $xoopsModuleConfig['rndlength'] -1 ))) . "...";
$eachentry['definition'] = $deftemp;
}
// Functional links
$microlinks = lx_serviceLinks ( $eachentry );
$eachentry['microlinks'] = $microlinks;
$entriesarray['single'][] = $eachentry;
}
$pagenav = new XoopsPageNav( $totalentries, $xoopsModuleConfig['indexperpage'], $start, 'start');
$entriesarray['navbar'] = '
' . $pagenav -> renderNav() . '
';
$xoopsTpl -> assign ( 'entriesarray', $entriesarray );
$xoopsTpl -> assign ( 'pagetype', '0' );
$xoopsTpl -> assign ( 'pageinitial', _MD_LX_ALL );
// v 1.17
lx_create_pagetitle($myts->htmlSpecialChars(_MD_LX_BROWSELETTER. ' - ' ._MD_LX_ALL));
}
else // $init does exist
{
$pagetype = 1;
// There IS an initial letter, so we want to show just that letter's terms
$entriesarray2 = array();
// How many entries will we show in this page?
if ($init == _MD_LX_OTHER)
{
$queryB = "SELECT * FROM " . $xoopsDB -> prefix( 'lxentries' ) . " WHERE submit ='0' AND offline = '0' AND init = '#' ORDER BY term ASC";
$resultB = $xoopsDB -> query ($queryB, $xoopsModuleConfig['indexperpage'], $start );
}
else
{
$queryB = "SELECT * FROM " . $xoopsDB -> prefix( 'lxentries' ) . " WHERE submit ='0' AND offline = '0' AND init = '$init' AND init != '#' ORDER BY term ASC";
$resultB = $xoopsDB -> query ($queryB, $xoopsModuleConfig['indexperpage'], $start );
}
$entrieshere = $xoopsDB -> getRowsNum( $resultB );
if ( $entrieshere == 0 )
{
redirect_header( "javascript:history.go(-1)", 1, _MD_LX_NOTERMSINLETTER );
exit();
}
if ($init == _MD_LX_OTHER)
{
$allentries = $xoopsDB -> query( "SELECT * FROM " . $xoopsDB -> prefix( 'lxentries' ) . " WHERE init = '#' AND submit ='0' AND offline = '0' ORDER BY term ASC " );
}
else
{
$allentries = $xoopsDB -> query( "SELECT * FROM " . $xoopsDB -> prefix( 'lxentries' ) . " WHERE init = '$init' AND init != '#' AND submit ='0' AND offline = '0' ORDER BY term ASC " );
}
$totalentries = $xoopsDB -> getRowsNum( $allentries );
$xoopsTpl->assign('totalentries', $totalentries );
// v.1.17
lx_create_pagetitle($myts->htmlSpecialChars(_MD_LX_BROWSELETTER. ' - ' .$init['init']));
while (list( $entryID, $categoryID, $term, $init, $definition, $ref, $url, $uid, $submit, $datesub, $counter, $html, $smiley, $xcodes, $breaks, $block, $offline, $notifypub, $request, $comments ) = $xoopsDB->fetchRow($resultB))
{
$eachentry = array();
$xoopsModule = XoopsModule::getByDirname("lexikon");
$eachentry['dir'] = $xoopsModule->dirname();
if ($xoopsModuleConfig['multicats'] == 1)
{
$eachentry['catid'] = intval($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 -> makeTboxData4Show( $name );
}
}
$eachentry['id'] = intval($entryID);
$eachentry['term'] = ucfirst($myts -> makeTboxData4Show( $term ));
$eachentry['init'] = $init;
if ($comments != 0) {
$eachentry['comments'] = "".$comments." "._COMMENTS."";
} else {
$eachentry['comments'] = ""._COMMENTS." ?";
}
if ( !XOOPS_USE_MULTIBYTES )
{
$deftemp = lx_cleanTags($definition);
//Cleantags.new.file only
//$deftemp = $GLOBALS['lexikon_cleanTags']->lx_cleanTags($definition);
//$deftemp = lx_html2text($definition); //clean HTML
//$deftemp = $myts -> displayTarea ( substr ( $deftemp, 0, ( $xoopsModuleConfig['rndlength'] -1 ))) . "...";//shorten
$deftemp = $myts -> addSlashes( $definition ); // show HTML
$eachentry['definition'] = $deftemp;
}
// Functional links
$microlinks = lx_serviceLinks ( $eachentry );
$eachentry['microlinks'] = $microlinks;
$entriesarray2['single'][] = $eachentry;
}
$pagenav = new XoopsPageNav( $totalentries, $xoopsModuleConfig['indexperpage'], $start, 'init='.$eachentry["init"].'&start');
$entriesarray2['navbar'] = '' . $pagenav -> renderNav() . '
';
$xoopsTpl -> assign ( 'entriesarray2', $entriesarray2 );
$xoopsTpl -> assign ( 'pagetype', '1' );
if ($eachentry['init'] == '#')
{
$xoopsTpl -> assign ( 'pageinitial', _MD_LX_OTHER);
//v 1.17
lx_create_pagetitle($myts->htmlSpecialChars(_MD_LX_BROWSELETTER. ' - ' ._MD_LX_OTHER));
}
else
{
$xoopsTpl -> assign ( 'pageinitial', ucfirst($eachentry['init'] ));
}
}
$xoopsTpl -> assign ( 'lang_modulename', $xoopsModule->name() );
$xoopsTpl -> assign ( 'lang_moduledirname', $xoopsModule->dirname() );
$xoopsTpl -> assign ( 'alpha', $alpha );
/*
* Meta data start
*/
$metadefin = substr( lx_html2text($eachentry['definition']),0,15 ). " read more..."; // lenght of definition to show in tags
if ($xoopsModuleConfig['multicats'] == 0 )
{
lx_extract_keywords($xoopsModule->name(). ' ,'.$thisterm['term'].', '.$metadef);
lx_get_metadescription($thisterm['catname'].' '.$thisterm['term']);
} else {
lx_extract_keywords($xoopsModule->name(). ', '.$eachentry['term']. ', '.$metadef);
lx_get_metadescription($eachentry['term'].' '. $metadefin);
}
/* Meta End */
$xoopsTpl->assign("xoops_module_header", '');
include( XOOPS_ROOT_PATH . "/footer.php" );
?>