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 ; }