function xwords_search_base( $mydirname, $queryarray, $andor, $limit, $offset, $userid ) { include_once XOOPS_ROOT_PATH."/modules/$mydirname/class/xwords.textsanitizer.php" ; $myts =& XwordsTextSanitizer::getInstance(); $xoopsDB =& Database::getInstance(); $xoopsModule = XoopsModule::getByDirname("{$mydirname}"); $ret = array(); // XOOPS Search module $showcontext = empty( $_GET['showcontext'] ) ? 0 : 1 ; $select4con = $showcontext ? "definition, html, smiley, xcodes, breaks, " : "" ; $sql = "SELECT entryID, categoryID, term, $select4con uid, datesub FROM " . $xoopsDB -> prefix( "{$mydirname}_ent" ) . " WHERE datesub < '".time()."' AND datesub > '0' AND submit = '0' AND offline = '0' AND request = '0' "; if ( $userid != 0 && strlen($userid) < 9) { $sql .= " AND uid = '".$userid."' "; } // because count() returns 1 even if a supplied variable // is not an array, we must check if $querryarray is really an array $count = count( $queryarray ); if ( $count > 0 && is_array( $queryarray ) ) { $sql .= "AND ("; for ( $i = 0; $i < $count; $i++ ) { $binary = (preg_match('/^[[:alnum:]]+$/',$queryarray[$i])) ? "":"BINARY"; $sql .= ($i > 0) ? " $andor " : ""; $sql .= (strlen($userid) > 8) ? "(term LIKE $binary '%$queryarray[$i]%')" : "(term LIKE $binary '%$queryarray[$i]%' OR proc LIKE $binary '%,%$queryarray[$i]%' OR definition LIKE $binary '%$queryarray[$i]%')" ; } $sql .= ') '; } $sql .= 'ORDER BY entryID DESC'; $result = $xoopsDB -> query( $sql, $limit, $offset ); $ret = array() ; $context = '' ; $i = 0; while ( $myrow = $xoopsDB -> fetchArray( $result ) ) { $ret[$i]['image'] = 'images/xw.gif'; $ret[$i]['link'] = 'entry.php?entryID='.$myrow['entryID'].'&categoryID='.$myrow['categoryID']; $ret[$i]['title'] = $myrow['term']; $ret[$i]['time'] = $myrow['datesub']; $ret[$i]['uid'] = $myrow['uid']; if( function_exists( 'search_make_context' ) && $showcontext ) { $context = strip_tags($myts->displayTarea($myrow['definition'], intval($myrow['html']), intval($myrow['smiley']), intval($myrow['xcodes']), 1, intval($myrow['breaks']))); $ret[$i]['context'] = search_make_context($context,$queryarray); } $i++; } return $ret; }
$mydirname = basename( dirname( dirname( __FILE__ ) ) ) ; $MYDIRNAME = strtoupper($mydirname); include ( '../../../include/cp_header.php' ); include_once ( XOOPS_ROOT_PATH."/modules/$mydirname/include/functions.php" ); include_once ( XOOPS_ROOT_PATH."/class/xoopsmodule.php" ); include_once ( XOOPS_ROOT_PATH."/class/xoopstree.php" ); include_once ( XOOPS_ROOT_PATH."/class/xoopslists.php" ); include_once ( XOOPS_ROOT_PATH."/class/xoopsformloader.php" ); $xoopsModule = XoopsModule::getByDirname("$mydirname"); $cat_table = $xoopsDB -> prefix ("{$mydirname}_cat") ; $ent_table = $xoopsDB -> prefix ("{$mydirname}_ent") ; if ( file_exists(XOOPS_ROOT_PATH."/modules/$mydirname/language/".$xoopsConfig['language']."/main.php") ) { include XOOPS_ROOT_PATH."/modules/$mydirname/language/".$xoopsConfig['language']."/main.php"; } else { include XOOPS_ROOT_PATH."/modules/$mydirname/language/english/main.php"; } if( ! class_exists( 'XwordsTextSanitizer' ) ) { include_once( XOOPS_ROOT_PATH . "/modules/$mydirname/class/xwords.textsanitizer.php" ) ; } $myts = & XwordsTextSanitizer::getInstance(); ?>
function catlinksArray () { $mydirname = basename( dirname( dirname( __FILE__ ) ) ) ; $xoopsDB =& Database::getInstance(); $cat_table = $xoopsDB -> prefix ("{$mydirname}_cat") ; if( ! class_exists( 'XwordsTextSanitizer' ) ) { include_once( XOOPS_ROOT_PATH . "/modules/$mydirname/class/xwords.textsanitizer.php" ) ; } $myts = & XwordsTextSanitizer::getInstance(); // $myts =& MyTextSanitizer::getInstance(); $block0 = array(); $catlinks = array(); $resultcat = $xoopsDB -> query ( "SELECT categoryID, name, description, total FROM $cat_table ORDER BY weight ASC" ); while (list( $catID, $name, $description,$total) = $xoopsDB->fetchRow($resultcat)) { $catlinks['id'] = $catID; $catlinks['total'] = intval($total); $catlinks['linktext'] = $myts -> makeTboxData4Show( $name ); $catlinks['desc'] = $myts -> displayTarea( $description,1,1,1,1,1,1); // $catlinks['desc'] = $myts -> makeTboxData4Show( $description ); $block0['categories'][] = $catlinks; } return $block0; }
function xwords_b_entries_random_show_base( $mydirname ) { $MYDIRNAME = strtoupper($mydirname); $xoopsDB =& Database::getInstance(); $cat_table = $xoopsDB -> prefix ("{$mydirname}_cat") ; $ent_table = $xoopsDB -> prefix ("{$mydirname}_ent") ; global $xoopsUser; $hModule =& xoops_gethandler('module'); $hModConfig =& xoops_gethandler('config'); $xwModule =& $hModule->getByDirname("$mydirname"); $module_id = $xwModule -> getVar( 'mid' ); $module_name = $xwModule -> getVar( 'dirname' ); $xwConfig =& $hModConfig->getConfigsByCat(0, $xwModule->getVar('mid')); if( ! class_exists( 'XwordsTextSanitizer' ) ) { include_once( XOOPS_ROOT_PATH . "/modules/$mydirname/class/xwords.textsanitizer.php" ) ; } $myts = & XwordsTextSanitizer::getInstance(); $block = array(); $rndlength = isset($xwConfig['rndlength']) ? intval($xwConfig['rndlength']) : 100 ; // $randomterm['title'] = constant("_MB_{$MYDIRNAME}_RANDOMTITLE"); list ( $numrows ) = $xoopsDB -> fetchRow( $xoopsDB -> query ( "SELECT COUNT(*) FROM $ent_table WHERE datesub < '".time()."' AND datesub > '0' AND submit = '0' AND offline = '0' AND request = '0'")); if ($numrows > 1) { $numrows = $numrows - 1; mt_srand((double)microtime()*1000000); $entrynumber = mt_rand(0, $numrows); } else { $entrynumber = 0; } $result = $xoopsDB -> query ( "SELECT e.entryID, e.categoryID, e.term, e.definition, e.html, e.smiley, e.xcodes, e.breaks, e.uid, c.name FROM $ent_table e LEFT JOIN $cat_table c ON e.categoryID = c.categoryID WHERE datesub < '".time()."' AND datesub > '0' AND submit = '0' AND offline = '0' AND request = '0' LIMIT $entrynumber, 1"); while ($myrow = $xoopsDB->fetchArray($result)) { $uid = intval($myrow['uid']); $randomterm['entryID'] = intval($myrow['entryID']); $randomterm['term'] = $myts->makeTboxData4Show($myrow['term']); $definition = strip_tags($myts->displayTarea($myrow['definition'], intval($myrow['html']), intval($myrow['smiley']), intval($myrow['xcodes']), 1, intval($myrow['breaks']))); if ( !XOOPS_USE_MULTIBYTES ) { $randomterm['definition'] = substr ( $definition, 0, $rndlength -1 ) . "..."; } else { $randomterm['definition'] = xoops_substr( $definition, 0, $rndlength +2 ); } $randomterm['categoryID'] = intval($myrow['categoryID']); $randomterm['categoryname'] = $myts -> makeTboxData4Show($myrow['name']); $randomterm['adminlinks'] = ''; $randomterm['userlinks'] = ''; // Functional links if ( is_object($xoopsUser) ) { if ( $xoopsUser->isAdmin($xwModule->getVar('mid')) ) { $randomterm['adminlinks'] = "<a href=\"".XOOPS_URL."/modules/$mydirname/admin/entry.php?op=mod&entryID=".$randomterm['entryID']."\" target=\"_blank\"><img src=\"".XOOPS_URL."/modules/$mydirname/images/edit.gif\" border=\"0\" alt=\"".constant("_MB_{$MYDIRNAME}_EDITTERM")."\" width=\"15\" height=\"11\" /></a> <a href=\"".XOOPS_URL."/modules/$mydirname/admin/entry.php?op=del&entryID=".$randomterm['entryID']."\" target=\"_blank\"><img src=\"".XOOPS_URL."/modules/$mydirname/images/delete.gif\" border=\"0\" alt=\"".constant("_MB_{$MYDIRNAME}_DELTERM")."\" width=\"15\" height=\"11\" /></a> "; } elseif ( $uid == $xoopsUser -> getVar( 'uid' )) { $randomterm['userlinks'] = "<a href=\"".XOOPS_URL."/modules/$mydirname/submit.php?entryID=".$randomterm['entryID']."\" target=\"_blank\"><img src=\"".XOOPS_URL."/modules/$mydirname/images/edit.gif\" border=\"0\" alt=\"".constant("_MB_{$MYDIRNAME}_EDITTERM")."\" width=\"15\" height=\"11\" /></a> "; } } $randomterm['multicats'] = $xwConfig['multicats']; $randomterm['seemore'] = constant("_MB_{$MYDIRNAME}_SEEMORE"); $randomterm['dir'] = $mydirname; $block['randomstuff'][] = $randomterm; } return $block; }