function getLocalStreamPath($stream_id, $quality = '')
{
global $mvStreamTable, $mvLocalVideoLoc;
//grab streamFile
$stream =& mvGetMVStream(array('id' => $stream_id));
$stream->db_load_stream();
$streamFile = new MV_StreamFile($stream);
return $streamFile->getLocalPath();
}
function do_stream_file_check($old_stream = false)
{
global $mvgIP, $mvVideoArchivePaths;
$stream_set = array();
if ($old_stream == false) {
$stream_set = get_all_mv_streams();
} else {
$stream_set = array($old_stream);
}
foreach ($stream_set as $stream) {
$mvStream =& mvGetMVStream(array('name' => $stream->name, 'duration' => $stream->duration));
$file_list = $mvStream->getFileList();
//print 'f:do_stream_file_check:' . $stream->name . ' dur: ' . $mvStream->getDuration() . "\n";
// @@todo have multiple file locations for same file?
$set = array();
foreach ($mvVideoArchivePaths as $path) {
if (url_exists($path . $stream->name . '.ogg')) {
$set['mv_ogg_low_quality'] = $path . $stream->name . '.ogg';
// force cap1 path @@todo remove!:
// $set['mv_ogg_low_quality']='http://128.114.20.64/media/' . $stream->name . '.ogg';
}
if (url_exists($path . $stream->name . '.HQ.ogg')) {
$set['mv_ogg_high_quality'] = $path . $stream->name . '.HQ.ogg';
// force cap1 path @@todo remove!:
// $set['mv_ogg_high_quality']='http://128.114.20.64/media/' . $stream->name . '.HQ.ogg';
}
if (url_exists($path . $stream->name . '.flv')) {
$path = str_replace('/media/', '', $path);
$set['mv_flash_low_quality'] = $path . '/mvFlvServer.php/' . $stream->name . '.flv';
// force cap1 path @@todo remove!:
// $set['mv_ogg_high_quality']='http://128.114.20.64/media/' . $stream->name . '.HQ.ogg';
}
}
//check archive.org paths:
if (count($set) == 0) {
// no files present (remove stream)
print 'no files present should remove: ' . $stream->name . "\n";
continue;
}
$dbw = wfGetDB(DB_WRITE);
$sql = "DELETE FROM `mv_stream_files` WHERE `stream_id`=" . $mvStream->id . " AND " . "(`file_desc_msg`='mv_ogg_high_quality' " . " OR `file_desc_msg`='mv_ogg_low_quality' " . " OR `file_desc_msg`='mv_flash_low_quality')";
$dbw->query($sql);
// update files:
if (!isset($set['mv_ogg_low_quality'])) {
print "Missing lowQ ogg for: " . $stream->name . "\n";
}
if (!isset($set['mv_ogg_high_quality'])) {
print "Missing highQ ogg for: " . $stream->name . "\n";
}
if (!isset($set['mv_flash_low_quality'])) {
print "Missing flash for: " . $stream->name . "\n";
}
foreach ($set as $qf => $path_url) {
do_insert_stream_file($mvStream, $path_url, $qf);
}
}
}
function doFiltersQuery(&$filters)
{
global $mvIndexTableName, $mvMediaFilesTable, $mvDefaultClipLength, $wgRequest, $mvDo_SQL_CALC_FOUND_ROWS, $mvSpokenByInSearchResult, $mvMediaSearchResultsLimit;
$dbr =& wfGetDB(DB_SLAVE);
//organize the queries (group full-text searches and category/attributes)
//if the attribute is not a numerical just add it to the fulltext query
$ftq_match_asql = $last_person_aon = $ftq_match = $ftq = $snq = $toplq_cat = $date_range_join = $date_range_where = $asql = '';
//top query and full text query =''
if ($filters == '') {
return array();
}
$selOpt = $mvDo_SQL_CALC_FOUND_ROWS ? 'SQL_CALC_FOUND_ROWS' : '';
list($this->limit, $this->offset) = $wgRequest->getLimitOffset(20, 'searchlimit');
if ($this->limit > $mvMediaSearchResultsLimit) {
$this->limit = $mvMediaSearchResultsLimit;
}
$group_spoken = true;
$categoryTable = $dbr->tableName('categorylinks');
foreach ($filters as $f) {
//proocc and or for fulltext:
if (!isset($f['a'])) {
$f['a'] = 'and';
}
switch ($f['a']) {
case 'and':
$aon = '+';
$asql = 'AND';
break;
case 'or':
$aon = '';
$asql = 'OR';
break;
case 'not':
$aon = '-';
$asql = 'NOT';
break;
}
//add to the fulltext query:
switch ($f['t']) {
case 'spoken_by':
//if we have an OR set prev to OR
if ($last_person_aon == '+' && $aon == '') {
$ftq = str_replace('+"spoken by', '"spoken by', $ftq);
$group_spoken = false;
}
//full text based semantic query:
$ftq .= ' ' . $aon . '"spoken by ' . mysql_escape_string($f['v']) . '"';
//table based query:
$last_person_aon = $aon;
break;
case 'match':
$ftq_match .= ' ' . $aon . '"' . mysql_escape_string($f['v']) . '"';
//only need to split out ftq match if spoken by is more than one
if ($ftq_match_asql != '') {
$ftq_match_asql = $asql;
}
break;
//top level queries (sets up time ranges )
//top level queries (sets up time ranges )
case 'category':
//full text based category query:
$toplq .= ' ' . $aon . '"category ' . mysql_escape_string($f['v']) . '" ';
//$ftq.=' '.$aon.'category:'.mysql_escape_string($f['v']);
//table based query:
switch ($f['a']) {
case 'and':
$toplq_cat = 'AND';
break;
case 'or':
$toplq_cat = 'OR';
break;
case 'not':
$toplq_cat = 'NOT';
break;
}
$toplq_cat .= " {$categoryTable}.`cl_to`='" . mysql_escape_string($f['v']) . "'";
break;
case 'date_range':
$date_range_join = ' JOIN `mv_streams` ' . 'ON `' . $mvIndexTableName . '`.`stream_id` =`mv_streams`.`id` ';
list($month, $day, $year) = explode('/', $f['vs']);
$sts = mktime(0, 0, 0, $month, $day, $year);
list($month, $day, $year) = explode('/', $f['ve']);
$ets = mktime(0, 0, 0, $month, $day + 1, $year);
//(the start of the next day)
$date_range_where .= '( `mv_streams`.`date_start_time` > ' . mysql_escape_string($sts) . ' AND `mv_streams`.`date_start_time` < ' . mysql_escape_string($ets) . ')';
$date_range_andor = ' ' . $asql . ' ';
break;
case 'stream_name':
if ($snq != '') {
switch ($f['a']) {
case 'and':
$snq = 'AND';
break;
case 'or':
$snq = 'OR';
break;
case 'not':
$snq = 'NOT';
break;
}
}
//get stream name:
//print "f: " . $f['v'];
$stream =& mvGetMVStream($f['v']);
$snq .= " `stream_id` = {$stream->getStreamId()} ";
break;
case 'smw_property':
//more complicated query work needed ;)
break;
}
}
$searchindexTable = $dbr->tableName('searchindex');
$ret_ary = array();
//a join operation to restrict search results to streams with files
$join_streams_with_low_ogg_sql = "JOIN `{$mvStreamFilesTable}` ON (`{$mvIndexTableName}`.`stream_id` = `{$mvStreamFilesTable}`.`stream_id`) JOIN `{$mvMediaFilesTable}` ON (`{$mvStreamFilesTable}`.`file_id`= `{$mvMediaFilesTable}`.`id` AND `{$mvMediaFilesTable}`.`file_desc_msg`='mv_ogg_low_quality') ";
//only run the top range query if we have no secondary query
if ($toplq_cat != '' && $ftq == '') {
//@@todo unify top query with ranged query ... kind of tricky
//@@todo we should only look in annotative layer for top level queries? ...
//@@todo paging for top level queries? ... 200 hit limit is probably ok
$sql = "SELECT `mv_page_id` as `id`, `{$mvIndexTableName}`.`stream_id`,`start_time`,`end_time`, `wiki_title`, {$searchindexTable}.`si_text` as `text`\n\t \t\t\tFROM `{$mvIndexTableName}` \n\t \t\t\t{$date_range_join}\n\t \t\t\tJOIN {$categoryTable} ON `{$mvIndexTableName}`.`mv_page_id` = {$categoryTable}.`cl_from`\n\t\t\t\t{$join_streams_with_low_ogg_sql} \n\t \t\t\tLEFT JOIN {$searchindexTable} ON `{$mvIndexTableName}`.`mv_page_id` = {$searchindexTable}.`si_page` \n\t \t\t\tWHERE \n\t\t\t\t`mvd_type`='Anno_en' " . " {$toplq_cat} " . " {$snq} " . "{$date_range_andor} {$date_range_where} " . "LIMIT 0, 200";
//echo "topQ: $sql \n\n";
$top_result = $dbr->query($sql, 'MV_Index:doFiltersQuery_topQ');
if ($dbr->numRows($top_result) == 0) {
return array();
}
//set up ranges sql query
$sql = "SELECT {$selOpt} `mv_page_id` as `id`, `{$mvIndexTableName}`.`stream_id`,`start_time`,`end_time`, `wiki_title`, {$searchindexTable}.`si_text` as `text` ";
if ($mvSpokenByInSearchResult) {
$sql .= ",`smw_relations`.`object_title` as `spoken_by` ";
}
$sql .= "FROM `{$mvIndexTableName}` " . $join_streams_with_low_ogg_sql . "JOIN {$searchindexTable} ON `{$mvIndexTableName}`.`mv_page_id` = {$searchindexTable}.`si_page` ";
if ($mvSpokenByInSearchResult) {
$sql .= "LEFT JOIN `smw_relations` ON (`mv_mvd_index`.`mv_page_id`=`smw_relations`.`subject_id` " . "AND `smw_relations`.`relation_title`='Spoken_By') ";
}
$sql .= "WHERE ";
$or = '';
$sql .= '( ';
while ($row = $dbr->fetchObject($top_result)) {
//also set initial sranges:
if (!isset($ret_ary[$row->stream_id])) {
$ret_ary[$row->stream_id] = array();
}
//insert into return ary:
$insertRow = $ftq == '' ? true : false;
//add that its a top level query to the row:
$row->toplq = true;
MV_Index::insert_merge_range($ret_ary[$row->stream_id], $ret_ary, $row, $insertRow);
$sql .= $or . " (`{$mvIndexTableName}`.`stream_id`='{$row->stream_id}' AND " . '`start_time`>=' . $row->start_time . ' AND ' . '`end_time`<=' . $row->end_time . ' ) ';
$or = ' OR ';
}
$sql .= ') ';
//if($ftq!='')
// $sql.=" AND MATCH (text)
// AGAINST('$ftq' IN BOOLEAN MODE) ";
$sql .= "LIMIT {$this->offset}, {$this->limit} ";
} else {
//add the top query to the base query:
$ftq .= $toplq;
$sql = "SELECT {$selOpt} `mv_page_id` as `id`,`{$mvIndexTableName}`.`stream_id`,`start_time`,`end_time`, `wiki_title`, {$searchindexTable}.`si_text` AS `text` ";
if ($mvSpokenByInSearchResult) {
$sql .= ",`smw_relations`.`object_title` as `spoken_by` ";
}
$sql .= "FROM `{$mvIndexTableName}` \n\t \t\t\tJOIN {$searchindexTable} ON `{$mvIndexTableName}`.`mv_page_id` = {$searchindexTable}.`si_page` \n\t\t\t\t{$join_streams_with_low_ogg_sql} \n\t \t\t\t{$date_range_join} ";
//include spoken by relation in results (LEFT JOIN should not be *that* costly )
if ($mvSpokenByInSearchResult) {
$sql .= "LEFT JOIN `smw_relations` ON (`mv_mvd_index`.`mv_page_id`=`smw_relations`.`subject_id` " . "AND `smw_relations`.`relation_title`='Spoken_By') ";
}
$sql .= "WHERE {$snq} ";
$two_part_anor = '';
if ($group_spoken) {
$ftq .= $ftq_match;
} else {
if ($ftq_match_asql) {
$sql .= ' ' . $ftq_match_asql . ' ';
}
if ($ftq_match != '') {
$sql .= "\tMATCH ( {$searchindexTable}.`si_text` ) \n\t\t\t \t\t\t\tAGAINST('{$ftq_match}' IN BOOLEAN MODE) ";
if ($ftq != '') {
$sql .= ' AND ';
}
}
}
if ($ftq != '') {
$sql .= "\tMATCH ( {$searchindexTable}.`si_text` ) \n\t\t \t\t\tAGAINST('{$ftq}' IN BOOLEAN MODE) ";
}
//date range stuff is SLOW when its the only filter (pulls up matches for everything)
if ($snq != '' || $ftq != '' && isset($date_range_andor)) {
$sql .= $date_range_andor;
}
$sql .= " {$date_range_where} ";
$sql .= "LIMIT {$this->offset}, {$this->limit} ";
}
//echo "SQL:".$sql." \n";
$result = $dbr->query($sql, 'MV_Index:doFiltersQuery_base');
$this->numResults = $dbr->numRows($result);
if ($dbr->numRows($result) == 0) {
return array();
}
if ($mvDo_SQL_CALC_FOUND_ROWS) {
$resFound = $dbr->query('SELECT FOUND_ROWS() as `count`;');
$found = $dbr->fetchObject($resFound);
$this->numResultsFound = $found->count;
} else {
$this->numResultsFound = null;
}
//@@TODO hide empty categories (if limit > rows found )
//group by time range in a given stream
//while($row = $dbr->fetchObject( $result )){
// $ret_ary[]=$row;
//}
//return $ret_ary;
//group by stream_name & time range:
while ($row = $dbr->fetchObject($result)) {
if (!isset($ret_ary[$row->stream_id])) {
$ret_ary[$row->stream_id] = array();
}
if (count($ret_ary[$row->stream_id]) == 0) {
$new_srange = array('s' => $row->start_time, 'e' => $row->end_time, 'rows' => array($row));
$ret_ary[$row->stream_id][] = $new_srange;
} else {
MV_Index::insert_merge_range($ret_ary[$row->stream_id], $ret_ary, $row);
}
}
//throw out empty top level ranges
foreach ($ret_ary as &$stream_set) {
foreach ($stream_set as $k => &$srange) {
if (count($srange['rows']) == 0) {
//print "throw out: ". $srange['s'] . $srange['e'];
unset($stream_set[$k]);
}
}
}
return $ret_ary;
}
function getNearStreamName($range = '', $length = '')
{
global $mvDefaultClipLength, $mvDefaultClipRange;
$stream =& mvGetMVStream($this->stream_name);
if ($range == '') {
$range = $mvDefaultClipRange;
}
if ($length == '') {
$length = $mvDefaultClipLength;
}
//subtract $range seconds from the start time:
$start_t = $this->getStartTimeSeconds() - $range;
if ($start_t < 0) {
$start_t = 0;
}
$start_ntp = seconds2ntp($start_t);
//add $range seconds to the end time:
if (isset($this->end_time)) {
$end_t = $this->getEndTimeSeconds() + $range;
if ($end_t > $stream->getDuration()) {
$end_t = $stream->getDuration();
}
$end_ntp = '/' . seconds2ntp($this->getEndTimeSeconds() + $range);
} else {
//make the end time the default Clip length
$end_ntp = '/' . seconds2ntp($this->getStartTimeSeconds() + $length + $range);
}
return $this->stream_name . '/' . $start_ntp . $end_ntp;
}
function list_stream_files()
{
global $wgOut;
$html = '';
$stream =& mvGetMVStream(array('name' => $this->stream_name));
$stream->db_load_stream();
$stream_files = $stream->getFileList();
if (count($stream_files) == 0) {
$html .= wfMsg('mv_no_stream_files');
$wgOut->addHTML($html);
return;
}
//output filedset container:
$html .= '<fieldset><legend>' . wfMsg('mv_file_list') . '</legend>' . "\n";
$html .= '<table width="600" border="0">';
foreach ($stream_files as $sf) {
$html .= '<tr>';
$html .= '<td width="150">' . $sf->getFullURL() . '</td>';
$html .= '<td>' . $sf->get_desc() . '</td>';
$html .= '</tr>';
}
$html .= '</table></fieldset>';
$wgOut->addHTML($html);
return '';
}
function doUnifiedFiltersQuery(&$filters, $metaDataIncludes = null)
{
global $mvDefaultClipLength, $wgRequest, $mvDo_SQL_CALC_FOUND_ROWS, $mvMediaSearchResultsLimit;
global $mvSpokenByInSearchResult, $mvCategoryInSearchResult, $mvBillInSearchResult;
// init vars
$from_tables = '';
$vars = $conds = $options = array();
// init top range generation query
$from_tables_top = '';
$vars_top = $conds_top = $options_top = array();
$do_top_range_query = false;
$dbr = wfGetDB(DB_SLAVE);
// organize the queries (group full-text searches and category/attributes)
// if the attribute is not a numerical just add it to the fulltext query
$ftq_match_asql = $last_person_aon = $ftq_match = $ftq = $snq = $toplq = $toplq_cat = $date_range_join = $date_range_where = $asql = '';
// top query and full text query =''
if ($filters == '') {
return array();
}
$ftq_match_asql = $date_cond = '';
$date_range_join = true;
// $selOpt = ($mvDo_SQL_CALC_FOUND_ROWS)?'SQL_CALC_FOUND_ROWS':'';
if ($mvDo_SQL_CALC_FOUND_ROWS) {
$options[] = 'SQL_CALC_FOUND_ROWS';
}
// set limit offset:
list($this->limit, $this->offset) = $wgRequest->getLimitOffset(20, 'searchlimit');
if ($this->limit > $mvMediaSearchResultsLimit) {
$this->limit = $mvMediaSearchResultsLimit;
}
$this->order = strtolower($wgRequest->getVal('order'));
// force order type:
if (!($this->order == 'relevant' || $this->order == 'recent' || $this->order == 'viewed')) {
$this->order = 'recent';
}
$group_spoken = true;
// $categoryTable = ;
$valid_filter_count = 0;
foreach ($filters as $f) {
// proocc and or for fulltext:
if (!isset($f['a'])) {
$f['a'] = 'and';
}
switch ($f['a']) {
case 'and':
$aon = '+';
$asql = 'AND';
break;
case 'or':
$aon = '';
$asql = 'OR';
break;
case 'not':
$aon = '-';
$asql = 'NOT';
break;
}
// add to the fulltext query:
switch ($f['t']) {
case 'speech_by':
case 'spoken_by':
$skey = str_replace('_', ' ', $f['t']);
// skip if empty value:
if (trim($f['v']) == '') {
continue;
}
// if we have an OR set prev to OR
if ($last_person_aon == '+' && $aon == '') {
$ftq = str_replace('+"' . $skey, '"' . $skey, $ftq);
$group_spoken = false;
}
// full text based semantic query:
$ftq .= ' ' . $aon . '"' . $skey . ' ' . mysql_real_escape_string($f['v']) . '" ';
// table based query:
$last_person_aon = $aon;
$valid_filter_count++;
// $conds[]=
break;
case 'bill':
// skip if empty value:
if (trim($f['v']) == '') {
continue;
}
$f['v'] = str_replace(array('.', '_', ':'), ' ', $f['v']);
// full text based semantic query:
$ftq .= ' ' . $aon . '"bill ' . mysql_real_escape_string($f['v']) . '" ';
// table based query:
$last_person_aon = $aon;
$valid_filter_count++;
// $conds[]=
break;
case 'match':
// skip if empty value:
if (trim($f['v']) == '') {
continue;
}
$mwords = explode(' ', $f['v']);
$space = '';
foreach ($mwords as $word) {
$ftq_match .= $space . $aon . mysql_real_escape_string($word);
$space = ' ';
}
// only need to split out ftq match if spoken by is more than one
if ($ftq_match_asql != '') {
$ftq_match_asql = $asql;
}
$valid_filter_count++;
break;
// top level queries (sets up time ranges )
// top level queries (sets up time ranges )
case 'category':
// skip if empty value:
if (trim($f['v']) == '') {
continue;
}
$do_top_range_query = true;
// full text based category query:
$toplq .= ' ' . $aon . '"category ' . mysql_real_escape_string($f['v']) . '" ';
// $ftq.=' '.$aon.'category:'.mysql_escape_string($f['v']);
// table based query:
switch ($f['a']) {
case 'and':
$toplq_cat = 'AND';
break;
case 'or':
$toplq_cat = 'OR';
break;
case 'not':
$toplq_cat = 'NOT';
break;
}
$toplq_cat .= $dbr->tableName('categorylinks') . '.cl_to=' . $dbr->addQuotes($f['v']);
$valid_filter_count++;
break;
case 'date_range':
list($month, $day, $year) = explode('/', $f['vs']);
$sts = mktime(0, 0, 0, $month, $day, $year);
list($month, $day, $year) = explode('/', $f['ve']);
$ets = mktime(0, 0, 0, $month, $day + 1, $year);
// (the start of the next day)
// add date condtion:
// note dissable and or for date range for now: $asql
$conds[] = ' ( `mv_streams`.`date_start_time` > ' . $dbr->addQuotes($sts) . ' AND `mv_streams`.`date_start_time` < ' . $dbr->addQuotes($ets) . ') ';
// print $date_cond;
$valid_filter_count++;
break;
case 'stream_name':
// skip if empty value:
if (trim($f['v']) == '') {
continue;
}
$stream =& mvGetMVStream($f['v']);
// add stream cond
$conds[] = $asql . " stream_id = " . $dbr->addQuotes($stream->getStreamId());
$valid_filter_count++;
break;
case 'smw_property':
//@@todo merge doUnifiedFiltersQuery function with SMW Ask more complicated query work needed
break;
}
}
if ($valid_filter_count == 0) {
return array();
}
// add the top query to the base query:
$ftq .= $toplq;
$vars = "mv_page_id as id," . $dbr->tableName('mv_mvd_index') . '.stream_id,
(' . $dbr->tableName('mv_streams') . '.date_start_time+' . $dbr->tableName('mv_mvd_index') . '.start_time) AS mvd_date_start_time, ' . 'start_time, end_time, view_count, wiki_title,' . $dbr->tableName('searchindex') . '.si_text AS `text` ';
/*if ( $mvSpokenByInSearchResult )
$vars .= ', smw_relations.object_title as spoken_by ';*/
$from_tables .= $dbr->tableName('mv_mvd_index') . ' ';
$from_tables .= 'JOIN ' . $dbr->tableName('searchindex') . ' ON (' . $dbr->tableName('mv_mvd_index') . '.mv_page_id = ' . $dbr->tableName('searchindex') . '.si_page ) ';
if ($date_range_join) {
$from_tables .= 'LEFT JOIN ' . $dbr->tableName('mv_streams') . ' ON (' . $dbr->tableName('mv_mvd_index') . '.stream_id = ' . $dbr->tableName('mv_streams') . '.id ) ';
}
// print "FROM TABLES:". $from_tables;
// restrict to streams with valid $mvDefaultVideoQualityKey files:
global $mvDefaultVideoQualityKey, $mvDefaultFlashQualityKey;
$from_tables .= 'JOIN ' . $dbr->tableName('mv_stream_files') . ' ON ' . '( ' . $dbr->tableName('mv_mvd_index') . '.stream_id = ' . $dbr->tableName('mv_stream_files') . '.stream_id ' . ' AND (' . $dbr->tableName('mv_stream_files') . '.file_desc_msg = ' . $dbr->addQuotes($mvDefaultVideoQualityKey) . ')' . ') ';
// date range join:
// include spoken by relation in results (LEFT JOIN should not be *that* costly )
/*if ( $mvSpokenByInSearchResult ) {
//$sql.="LEFT JOIN `smw_relations` ON (`mv_mvd_index`.`mv_page_id`=`smw_relations`.`subject_id` " .
// "AND `smw_relations`.`relation_title`='Spoken_By') ";
$from_tables .= 'LEFT JOIN ' . $dbr->tableName( 'smw_relations' ) .
' ON ' .
'( ' . $dbr->tableName( 'mv_mvd_index' ) . '.mv_page_id = ' .
$dbr->tableName( 'smw_relations' ) . '.subject_id ' .
' AND ' . $dbr->tableName( 'smw_relations' ) . '.relation_title = \'Spoken_By\'' .
') ';
}*/
// add conditions to last condition element (cuz we have to manually mannage and or):
$conds[count($conds)] = ' ' . $dbr->tableName('mv_mvd_index') . '.mvd_type = \'ht_en\' ' . ' OR ' . $dbr->tableName('mv_mvd_index') . '.mvd_type=\'anno_en\' ';
// limit to ht_en & anno_en (for now) (future allow selection
// $conds_inx = (count($conds)==0)?0:count($conds)-1;
$two_part_anor = '';
if ($group_spoken) {
$ftq .= $ftq_match;
} else {
if ($ftq_match != '') {
$conds[] .= $ftq_match_asql . ' MATCH ( ' . $dbr->tableName('searchindex') . '.si_text )' . ' AGAINST(\'' . $ftq_match . '\' IN BOOLEAN MODE) ';
// if($ftq!='')$sql.=' AND ';
}
}
if ($ftq != '') {
$conds[] .= "\tMATCH ( " . $dbr->tableName('searchindex') . '.si_text ) ' . ' AGAINST(\'' . $ftq . '\' IN BOOLEAN MODE) ';
}
// print_r($conds);
// die;
// date range stuff is SLOW when its the only filter (pulls up matches for everything)
/*if($snq!='' || $ftq!='' && isset($date_range_andor))
$sql.=$date_range_andor;
$sql.=" $date_range_where ";*/
switch ($this->order) {
case 'relevant':
// @@todo need to add in some relevence metrics
break;
case 'recent':
$options['ORDER BY'] = 'mvd_date_start_time DESC ';
break;
case 'viewed':
$options['ORDER BY'] = 'view_count DESC ';
break;
}
// echo $this->order;
// $sql.="LIMIT {$this->offset}, {$this->limit} ";
$options['LIMIT'] = $this->limit;
$options['OFFSET'] = $this->offset;
$options['GROUP BY'] = 'mv_page_id';
$result = $dbr->select($from_tables, $vars, $conds, __METHOD__, $options);
//echo "SQL:".$dbr->lastQuery($result)." \n";
//die;
// $result = $dbr->query($sql, 'MV_Index:doFiltersQuery_base');
$this->numResults = $dbr->numRows($result);
if ($dbr->numRows($result) == 0) {
return array();
}
if ($mvDo_SQL_CALC_FOUND_ROWS) {
$resFound = $dbr->query('SELECT FOUND_ROWS() as `count`;');
$found = $dbr->fetchObject($resFound);
$this->numResultsFound = $found->count;
} else {
$this->numResultsFound = null;
}
// @@TODO hide empty categories (if limit > rows found )
// while($row = $dbr->fetchObject( $result )){
// $ret_ary[]=$row;
// }
// return $ret_ary;
// group by stream_name & time range:
// init ret_ary & stream_group
$ret_ary = $stream_groups = array();
while ($row = $dbr->fetchObject($result)) {
$ret_ary[$row->id] = $row;
if (!isset($stream_groups[$row->stream_id])) {
$stream_groups[$row->stream_id] = array();
}
if (count($stream_groups[$row->stream_id]) == 0) {
$new_srange = array('s' => $row->start_time, 'e' => $row->end_time, 'rows' => array($row));
$stream_groups[$row->stream_id][] = $new_srange;
} else {
MV_Index::insert_merge_range($stream_groups[$row->stream_id], $stream_groups, $row);
}
}
if ($mvCategoryInSearchResult) {
$or = '';
$conds = '';
$options = array();
//build the category query conditions:
foreach ($ret_ary as $row) {
if (!isset($ret_ary[$row->id]->category)) {
$ret_ary[$row->id]->categories = array();
}
$conds .= $or . ' cl_from =' . $dbr->addQuotes($row->id);
$or = ' OR ';
}
//do the lookup:
$from_tables = $dbr->tableName('categorylinks');
$from_tables .= ' LEFT JOIN ' . $dbr->tableName('mv_mvd_index') . ' ON ( ' . $dbr->tableName('categorylinks') . '.cl_from = ' . $dbr->tableName('mv_mvd_index') . '.mv_page_id' . ' ) ';
$vars = array('cl_from', 'cl_to');
$options['LIMIT'] = 2000;
// max avarage 5 categories per page
$result_cat = $dbr->select($from_tables, $vars, $conds, __METHOD__, $options);
while ($cat_row = $dbr->fetchObject($result_cat)) {
$ret_ary[$cat_row->cl_from]->categories[$cat_row->cl_to] = true;
}
}
if ($mvSpokenByInSearchResult || $mvBillInSearchResult) {
// slow especially for lots of query results but join Query is crazy complicated for SMW >= 1.2
// (and I have not been able to construct it without hitting exessive number of rows in the EXPLIN)
// @@todo these queries should be merged with semantic wiki Ask with some ~special~ keywords for fulltext search
$smwStore =& smwfGetStore();
foreach ($ret_ary as &$row) {
//@@todo this is all very hackish but this is because SMW changed the db schema causing a few hacks:
// obviously this should be rewritten to use some SMW based query system.
$smw_properties = array();
if ($mvSpokenByInSearchResult && strtolower(substr($row->wiki_title, 0, 2)) == 'ht') {
$smw_properties[] = 'Spoken_By';
}
if ($mvSpokenByInSearchResult && strtolower(substr($row->wiki_title, 0, 4)) == 'anno') {
$smw_properties[] = 'Speech_by';
}
if ($mvBillInSearchResult) {
$smw_properties[] = 'Bill';
}
$rowTitle = Title::newFromText($row->wiki_title, MV_NS_MVD);
foreach ($smw_properties as $propKey) {
if ($propKey != 'category') {
//print "on key: $propKey";
$propTitle = Title::newFromText($propKey, SMW_NS_PROPERTY);
$smwProps = $smwStore->getPropertyValues($rowTitle, $propTitle);
// just a temp hack .. we need to think about this abstraction a bit..
//print_r($smwProps);
if (count($smwProps) != 0) {
if ($propKey == 'Spoken_By' || $propKey == 'Speech_by') {
$v = current($smwProps);
$row->spoken_by = $v->getXSDValue();
} elseif ($propKey == 'Bill') {
$row->bills = array();
foreach ($smwProps as $v) {
$row->bills[$v->getXSDValue()] = true;
}
}
}
}
}
}
}
foreach ($ret_ary as $k => $v) {
$ret_ary[$k]->text = str_replace(array('u800', 'u82e'), '', $v->text);
}
return $ret_ary;
}
function mv_frame_server($stream_name = '', $req_time = '', $req_size = '')
{
global $wgRequest;
$stream_id = '';
// try loading vals from $wgRequest if not set
$stream_name = $stream_name == '' ? $wgRequest->getVal('stream_name') : $stream_name;
if ($stream_name == null) {
$stream_id = $wgRequest->getVal('stream_id');
}
$req_time = $req_time == '' ? $wgRequest->getVal('t') : $req_time;
$req_size = $req_size == '' ? $wgRequest->getVal('size') : $req_size;
$redirect_req = $wgRequest->getVal('redirect') == 'true' ? true : false;
if ($stream_id == '') {
$mvStream = mvGetMVStream($stream_name);
$stream_id = $mvStream->getStreamId();
} else {
$mvStream = new MV_Stream(array('id' => $stream_id));
}
if ($mvStream->db_load_stream()) {
global $mvServeImageRedirect, $mvExternalImages;
if ($mvServeImageRedirect || $redirect_req || $mvExternalImages) {
header("Location:" . MV_StreamImage::getStreamImageURL($stream_id, $req_time, $req_size, true));
} else {
// serve up the image directly
MV_StreamImage::getStreamImageRaw($stream_id, $req_time, $req_size, true);
}
exit;
} else {
return 'error: invalid stream name';
}
}
function add_stream($stream = null)
{
$out = '';
$mvTitle = new MV_Title($this->stream_name);
// fist check if the given stream name already exists
if ($mvTitle->doesStreamExist()) {
$mv_page = Title::newFromText($this->stream_name, MV_NS_STREAM);
return '<span class="error">' . wfMsg('mv_stream_already_exists', $this->stream_name, $mv_page->getFullURL()) . '</span> ';
} else {
// get the stream pointer
if (!$stream) {
$stream =& mvGetMVStream(array('name' => $this->stream_name));
}
// if the stream is inserted proced with page insertion
if ($stream->insertStream($this->stream_type)) {
global $wgUser;
$sk = $wgUser->getSkin();
// insert page
$streamTitle = Title::newFromText($this->stream_name, MV_NS_STREAM);
$article = new Article($streamTitle);
$status = $article->doEdit($this->stream_desc, wfMsg('mv_summary_add_stream'));
if ($status === true || is_object($status) && $status->isOK()) {
// stream inserted sucesfully report to output
$out = wfMsg('mv_stream_added', $sk->makeLinkObj($streamTitle, htmlspecialchars($this->stream_name)));
} else {
$out = wfMsg('mv_error_stream_insert');
}
} else {
// stream failed insert
}
}
return $out;
}
function do_stream_file_check(&$old_stream)
{
global $mvgIP, $mvVideoArchivePaths;
$mvStream =& mvGetMVStream(array('name' => $old_stream->name));
$file_list = $mvStream->getFileList();
//if ($old_stream->trascoded != 'none') {
//print "transcode is: " . $old_stream->trascoded;
/*if ($old_stream->trascoded == 'low')
$set = array (
'mv_ogg_low_quality'
);
if ($old_stream->trascoded == 'high')
$set = array (
'mv_ogg_high_quality'
);
if ($old_stream->trascoded == 'all')
$set = array (
'mv_ogg_high_quality',
'mv_ogg_low_quality'
);*/
//find the files and check for them on the servers:
//@@todo have multiple file locations for same file?
$set = array();
foreach ($mvVideoArchivePaths as $path) {
if (url_exists($path . $old_stream->name . '.ogg')) {
$set['mv_ogg_low_quality'] = $path . $old_stream->name . '.ogg';
//force cap1 path @@todo remove!:
//$set['mv_ogg_low_quality']='http://128.114.20.64/media/' . $old_stream->name . '.ogg';
}
if (url_exists($path . $old_stream->name . '.HQ.ogg')) {
$set['mv_ogg_high_quality'] = $path . $old_stream->name . '.HQ.ogg';
//force cap1 path @@todo remove!:
//$set['mv_ogg_high_quality']='http://128.114.20.64/media/' . $old_stream->name . '.HQ.ogg';
}
}
if (count($set) == 0) {
//no files present (remove stream)
print 'no files present should remove: ' . $old_stream->name . "\n";
//make a valid mv title (with requted time: )
/*$mvTitle = new MV_Title( $old_stream->name);
$streamTitle = Title::newFromText( $old_stream->name, MV_NS_STREAM);
//print " new title: " . $streamTitle . "\n";
$article = new MV_StreamPage($streamTitle, $mvTitle);
$article->doDelete('no files present for stream');*/
}
//print "set: " . print_r($set);
//remove old file pointers:
$dbw = wfGetDB(DB_WRITE);
$sql = "DELETE FROM `mv_stream_files` WHERE `stream_id`=" . $mvStream->id . " AND " . "(`file_desc_msg`='mv_ogg_high_quality' OR `file_desc_msg`='mv_ogg_low_quality')";
$dbw->query($sql);
//update files:
foreach ($set as $qf => $path_url) {
do_insert_stream_file($mvStream, $path_url, $qf);
}
//}
//check for archive.org stuff too..
/*if($old_stream->archive_org!=''){
$found=false;
foreach($file_list as $file){
if($file->path_type =='ext_archive_org'){
$found=true;
}
}
if(!$found)do_insert_stream_file($mvStream, $old_stream, 'mv_archive_org_link');
}*/
}
function add_stream()
{
global $mvgIP;
$out = '';
require_once $mvgIP . '/includes/MV_Title.php';
$mvTitle = new mvTitle($this->stream_name);
//fist check if the given stream name already exists
if ($mvTitle->doesStreamExists()) {
$mv_page = Title::newFromText($this->stream_name, MV_NS_STREAM);
return '<span class="error">' . wfMsg('mv_stream_already_exists', $this->stream_name, $mv_page->getFullURL()) . '</span> ';
} else {
//get the stream pointer
$stream =& mvGetMVStream(array('name' => $this->stream_name));
//if the stream is inserted procced with page insertion
if ($stream->insertStream($this->stream_type)) {
global $wgUser;
$sk = $wgUser->getSkin();
//insert page
$streamTitle = Title::newFromText($this->stream_name, MV_NS_STREAM);
$wgArticle = new Article($streamTitle);
$success = $wgArticle->doEdit($this->stream_desc, wfMsg('mv_summary_add_stream'));
if ($success) {
//stream inserted succesfully report to output
$streamLink = $sk->makeLinkObj($streamTitle, $this->stream_name);
$out = 'stream ' . $streamLink . ' added';
} else {
$out = wfMsg('mv_error_stream_insert');
}
} else {
//stream failed insert
}
}
return $out;
}
