2
<?php
/**
* $Id: search.inc.php v 1.0 8 May 2004 hsalazar Exp $
* Module: Wordbook
* Version: v 1.00
* Release Date: 8 May 2004
* Author: hsalazar
* Licence: GNU
*/
function wb_search( $queryarray, $andor, $limit, $offset, $userid )
{
global $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB, $xoopsModule, $xoopsModuleConfig;
$sql = "SELECT entryID, term, definition, ref, uid, datesub FROM " . $xoopsDB -> prefix( "wbentries" ) . " WHERE submit = 0 AND offline = 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 ((term LIKE '%$queryarray[0]%' OR definition LIKE '%$queryarray[0]%' OR ref LIKE '%$queryarray[0]%')";
for ( $i = 1; $i < $count; $i++ )
{
$sql .= " $andor ";
$sql .= "(term LIKE '%$queryarray[$i]%' OR definition LIKE '%$queryarray[$i]%' OR ref LIKE '%$queryarray[$i]%')";
}
$sql .= ") ";
}
$sql .= "ORDER BY entryID DESC";
$result = $xoopsDB -> query( $sql, $limit, $offset );
$ret = array();
$i = 0;
while ( $myrow = $xoopsDB -> fetchArray( $result ) )
{
$ret[$i]['image'] = "images/wb.png";
$ret[$i]['link'] = "entry.php?entryID=" . $myrow['entryID'];
$ret[$i]['title'] = $myrow['term'];
$ret[$i]['time'] = $myrow['datesub'];
$ret[$i]['uid'] = $myrow['uid'];
$i++;
}
return $ret;
}
?>
3
good point. this would be a possible solution:
edit search.inc.php, delete l.16-19
add before '// because count() ...'
edit search.inc.php, delete l.16-19
if ( $userid != 0 )
{
return $ret;
}
add before '// because count() ...'
if ( $userid != 0 ) {
$sql .= " AND uid = " .$userid. "";
}
4
This version uses the autocomplete-function from script.acul.us.
Autocomplete looks like => Google Suggest
It works fine in XOOPS 2.2x and 2.0.16, but not 2.0.13. I guess it's because of the inline-Javascript. nevermind.
wordbook_1.17_rc4_ajax.zip
wordbook_1.17_rc4.zip
Autocomplete looks like => Google Suggest
It works fine in XOOPS 2.2x and 2.0.16, but not 2.0.13. I guess it's because of the inline-Javascript. nevermind.
wordbook_1.17_rc4_ajax.zip
wordbook_1.17_rc4.zip
5
thanks for the hint!
[EDIT]
your suggestion works but gives an error-message.
I guess a makeshift solution would be:
$sform -> addElement( new XoopsFormHidden( '$categoryID', $categoryID ) );
or if you like as a workaround:
$sform -> addElement( new XoopsFormHidden('', $categoryID ) );
[EDIT]
I applied this and uploaded the new file.
[EDIT]
your suggestion works but gives an error-message.
I guess a makeshift solution would be:
$sform -> addElement( new XoopsFormHidden( '$categoryID', $categoryID ) );
or if you like as a workaround:
$sform -> addElement( new XoopsFormHidden('', $categoryID ) );
[EDIT]
I applied this and uploaded the new file.
7
Having done a lot of testing here finally is the first RC of Wordbook 1.17.
This version includes a number of bugfixes, a script to upgrade from 1.16 and several static templates.
the function 'cleantags' has been revised as well and/or replaced where necessary.
Please see changelog for full list of changes.
Download Wordbook 1.17 RC 1 here.
feel free to report any bugs.
This version includes a number of bugfixes, a script to upgrade from 1.16 and several static templates.
the function 'cleantags' has been revised as well and/or replaced where necessary.
Please see changelog for full list of changes.
Download Wordbook 1.17 RC 1 here.
feel free to report any bugs.
9
sorry there won't be subcategories.
I got somewhat tired of searching and not finding the error in the autolinks that I packed the changes separately.
Take the update you need or install the *Temporary files removed* that includes all changes of the 4 updatepacks:
*Temporary files removed*
These updates are for the original version of wordbook 1.16.
[edit]
Edited per yerres request to remove nonworking links gediminasbyt
[/edit]
I got somewhat tired of searching and not finding the error in the autolinks that I packed the changes separately.
Take the update you need or install the *Temporary files removed* that includes all changes of the 4 updatepacks:
*Temporary files removed*
These updates are for the original version of wordbook 1.16.
[edit]
Edited per yerres request to remove nonworking links gediminasbyt
[/edit]
10
I will check it on php5.
Did you try the hack for site-wide autolinking with wordbook? I may work with multibyte-languages. I included the files.
In the current version (same download address) there are more additions.
If you're on previous versions it might be worthwhile downloading again:
Categories and Letters are now sortable by Name, Date or Popularity (like in mylinks)
I added as well the XFG-Hack (Xoops for Google): Entry, Category, Definition generate automatically Pagetitle, Meta-keywords and Meta-description. (still have to adapt this for XOOPS 2.0.15).
I will continue updating the file. so please check for changes from time to time.
This is how looks like right now.
Did you try the hack for site-wide autolinking with wordbook? I may work with multibyte-languages. I included the files.
In the current version (same download address) there are more additions.
If you're on previous versions it might be worthwhile downloading again:
Categories and Letters are now sortable by Name, Date or Popularity (like in mylinks)
I added as well the XFG-Hack (Xoops for Google): Entry, Category, Definition generate automatically Pagetitle, Meta-keywords and Meta-description. (still have to adapt this for XOOPS 2.0.15).
I will continue updating the file. so please check for changes from time to time.
This is how looks like right now.
Login
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $100.00 |
| Due Date: | Apr 30 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|