XoopsModules25x / lexikon

if( ! defined( 'XOOPS_ROOT_PATH' ) ) die( 'XOOPS root path not defined' ) ;

function b_lxentries_new_show( $options ) {

    global $xoopsDB,$xoopsUser;

    $myts = & MyTextSanitizer :: getInstance();

    $module_handler = &xoops_gethandler('module');

    $lexikon = &$module_handler->getByDirname('lexikon');

    if (!isset($lxConfig)) {

        $config_handler = &xoops_gethandler('config');

        $lxConfig = &$config_handler->getConfigsByCat(0, $lexikon->getVar('mid'));

    }

    $groups = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;

    $gperm_handler =& xoops_gethandler('groupperm');

    $module_id = $lexikon->getVar('mid');

    $allowed_cats = $gperm_handler->getItemIds("lexikon_view", $groups, $module_id);

    $catids = implode(',', $allowed_cats);

    $catperms = " AND categoryID IN ($catids) ";

    $words = $xoopsDB -> query( "SELECT entryID FROM " . $xoopsDB -> prefix( "lxentries" ) . " WHERE offline = '0' AND submit='0' AND request='0' AND block = '1' " );

    $totalwords = $xoopsDB -> getRowsNum( $words );

    $block = array();

    $block['marquee'] = ($options[2]==1)? 1:0;

    $block['alternate'] = ($options[3]==1)? 1:0;

    $block['showdate'] = ($options[4]==1)? 1:0;

    $block['direction'] = $options[5];

    $block['speed'] = isset($options[6]) && $options[6] != '' ?  $options[6] : '2';

    $block['bgcolor'] = isset($options[7]) && $options[7] != '' ?  $options[7] : '#FFFFFF';

    $sql = "SELECT entryID, categoryID, term, datesub FROM " . $xoopsDB -> prefix( "lxentries" ) . " WHERE datesub < ".time()." AND datesub > 0 AND offline = '0' ".$catperms." ORDER BY " . $options[0] . " 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'] = intval($entryID);

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

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

        }

    }

    return $block;

}

function b_lxentries_new_edit( $options ) {

    $form  = "<table width='100%' border='0'  class='bg2'>";

if( ! defined( 'XOOPS_ROOT_PATH' ) ) die( 'XOOPS root path not defined' ) ;

function b_lxentries_top_show( $options ) {

    global $xoopsDB, $xoopsUser;

    $myts = & MyTextSanitizer :: getInstance();

    $module_handler = &xoops_gethandler('module');

    $lexikon = &$module_handler->getByDirname('lexikon');

    if (!isset($lxConfig)) {

        $config_handler = &xoops_gethandler('config');

        $lxConfig = &$config_handler->getConfigsByCat(0, $lexikon->getVar('mid'));

    }

    $groups = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;

    $gperm_handler =& xoops_gethandler('groupperm');

    $module_id = $lexikon->getVar('mid');

    $allowed_cats = $gperm_handler->getItemIds("lexikon_view", $groups, $module_id);

    $catids = implode(',', $allowed_cats);

    $catperms = " AND categoryID IN ($catids) ";

    $words = $xoopsDB -> query( "SELECT entryID FROM " . $xoopsDB -> prefix( "lxentries" ) . " WHERE offline = '0' AND submit='0' AND request='0' AND block = '1'");

    $totalwords = $xoopsDB -> getRowsNum( $words );

    $block = array();

    $block['marquee'] = ($options[2]==1)? 1:0;

    $block['alternate'] = ($options[3]==1)? 1:0;

    $block['showcounter'] = ($options[4]==1)? 1:0;

    $block['direction'] = $options[5];

    $block['speed'] = isset($options[6]) && $options[6] != '' ?  $options[6] : '2';

    $block['bgcolor'] = isset($options[7]) && $options[7] != '' ?  $options[7] : '#FFFFFF';

    $sql = "SELECT entryID, categoryID, term, counter FROM " . $xoopsDB -> prefix( "lxentries" ) . " WHERE datesub < ".time()." AND datesub > 0 AND offline = '0' ".$catperms." ORDER BY " . $options[0] . " DESC";

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

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

    {

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

            $popentries = array();

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

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

            $popentries['linktext'] = $linktext;

            $popentries['id'] = intval($entryID);

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

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

        }

    }

    return $block;

}

function b_lxentries_top_edit( $options ) {

    $form  = "<table width='100%' border='0'  class='bg2'>";