function d3downloads_notify_base( $mydirname , $category , $item_id )
{
include_once dirname( __FILE__ ).'/class/user_access.php' ;
include_once dirname( __FILE__ ).'/class/mydownload.php' ;
$db =& Database::getInstance() ;
$module_handler =& xoops_gethandler( 'module' ) ;
$module =& $module_handler->getByDirname( $mydirname ) ;
$user_access = new user_access( $mydirname ) ;
$mydownload = new MyDownload( $mydirname ) ;
if ($category=='global') {
$item['name'] = '';
$item['url'] = '';
return $item;
}
if ( $category=='category' ) {
// Assume we have a valid cat_id
$whr_cat = "cid IN (".implode(",", $user_access->can_read() ).")" ;
$sql = "SELECT title FROM ".$db->prefix( $mydirname."_cat" )." WHERE cid='".$item_id."' AND ($whr_cat)" ;
$result = $db->query( $sql );
$result_array = $db->fetchArray( $result );
$item['name'] = $result_array['title'];
$item['url'] = XOOPS_URL . "/modules/" . $module->getVar('dirname') . "/index.php?cid=".$item_id ;
return $item ;
}
if ( $category=='file' ) {
// Assume we have a valid topid_id
$whr_cat = "cid IN (".implode(",", $user_access->can_read() ).")" ;
$sql = "SELECT cid, title FROM ".$db->prefix( $mydirname."_downloads" )." WHERE lid = '".$item_id."'";
$sql .= " AND ".$mydownload->whr_append( 'Single' )." AND ($whr_cat)" ;
$result = $db->query($sql);
$result_array = $db->fetchArray( $result );
$item['name'] = $result_array['title'];
$item['url'] = XOOPS_URL . "/modules/" . $module->getVar('dirname') . "/index.php?page=singlefile&cid=" . $result_array['cid'] . "&lid=" . $item_id;
return $item ;
}
}
function validate_id( $link_id )
{
include_once dirname( dirname(__FILE__) ).'/class/user_access.php' ;
include_once dirname( dirname(__FILE__) ).'/class/mydownload.php' ;
$db =& Database::getInstance() ;
$mydirname = $this->mydirname ;
$user_access = new user_access( $mydirname ) ;
$mydownload = new MyDownload( $mydirname ) ;
$lid = intval( $link_id ) ;
$whr_cat = "cid IN (".implode(",", $user_access->can_read() ).")" ;
$sql = "SELECT COUNT(*) FROM ".$db->prefix( $mydirname."_downloads" )." WHERE lid='".$lid."' AND ( $whr_cat )" ;
$sql .= " AND ".$mydownload->whr_append( 'Single' )." AND cancomment = '1'" ;
list( $count ) = $db->fetchRow( $db->query( $sql ) ) ;
if( $count <= 0 ) return false ;
else return $lid ;
}
function default_whr_append()
{
include_once dirname( dirname(__FILE__) ).'/class/mydownload.php' ;
$mydownload = new MyDownload( $this->mydirname ) ;
return $mydownload->whr_append( 'Single' ) ;
}
function d3downloads_global_search_base( $mydirname, $keywords, $andor, $limit, $offset, $userid )
{
require_once dirname( __FILE__ ).'/class/d3downloads.textsanitizer.php' ;
include_once dirname( __FILE__ ).'/class/mydownload.php' ;
include_once dirname( __FILE__ ).'/class/user_access.php' ;
$myts =& d3downloadsTextSanitizer::getInstance() ;
$db =& Database::getInstance() ;
$showcontext = isset( $_GET['showcontext'] ) ? $_GET['showcontext'] : 0 ;
$mydownload = new MyDownload( $mydirname ) ;
$user_access = new user_access( $mydirname ) ;
$whr = "cid IN ( ".implode( ",", $user_access->can_read() )." )" ;
if( $showcontext == 1 ){
$sql = "SELECT lid, cid, title, description, submitter, date FROM ".$db->prefix( $mydirname."_downloads" )."" ;
} else {
$sql = "SELECT lid, cid, title, submitter, date, title FROM ".$db->prefix( $mydirname."_downloads" )."" ;
}
$sql .= " WHERE ".$mydownload->whr_append( 'Single' )." AND ( $whr )" ;
if ( $userid != 0 ) $sql .= " AND submitter=".$userid." ";
// because count() returns 1 even if a supplied variable
// is not an array, we must check if $querryarray is really an array
if ( is_array( $keywords ) && $count = count( $keywords ) ) {
$sql .= " AND ( ( title LIKE '%$keywords[0]%' OR description LIKE '%$keywords[0]%' )" ;
for( $i=1; $i<$count; $i++ ){
$sql .= " $andor " ;
$sql .= "( title LIKE '%$keywords[$i]%' OR description LIKE '%$keywords[$i]%' )" ;
}
$sql .= ") " ;
}
$sql .= "ORDER BY date DESC" ;
$result = $db->query( $sql, $limit, $offset ) ;
$ret = array();
while( $myrow = $db->fetchArray( $result ) )
{
$lid = intval( $myrow['lid'] ) ;
$cid = intval( $myrow['cid'] ) ;
$title = $myts->makeTboxData4Show( $myrow['title'] ) ;
$date = intval( $myrow['date'] ) ;
$submitter = intval( $myrow['submitter'] ) ;
$context = '' ;
// get context for module "search"
if( function_exists( 'search_make_context' ) && $showcontext ) {
$body = $myts->displayTarea( $myrow['description'], 0, 1, 1, 1, 1 ) ;
if ( strstr ( $body , '[pagebreak]' ) ){
$str = explode( '[pagebreak]', $body , 2 ) ;
$body = $str[0] ;
}
$full_context = strip_tags( $body ) ;
if( function_exists( 'easiestml' ) ) $full_context = easiestml( $full_context ) ;
$context = search_make_context( $full_context , $keywords ) ;
}
$ret[] = array(
'link' => "index.php?page=singlefile&cid=$cid&lid=$lid" ,
'title' => $title ,
'time' => $date ,
'uid' => $submitter ,
'context' => $context ,
) ;
}
return $ret ;
}
