3
I just found the error
Here is the file x_movie / include / search.inc.php
<?php
// $Id: search.inc.php,v 1.2 2005/03/18 12:52:25 Onokazu Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <https://xoops.org/> //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
function x_movie_search($queryarray, $andor, $limit, $offset, $userid){
global $xoopsDB;
$sql = "SELECT l.lid,l.cid,l.title,l.logourl,l.submitter,l.date,t.description FROM ".$xoopsDB->prefix("x_movie")." l LEFT JOIN ".$xoopsDB->prefix("x_movie_text")." t ON t.lid=l.lid WHERE status>0";
if ( $userid != 0 ) {
$sql .= " AND l.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($queryarray) && $count = count($queryarray) ) {
$sql .= " AND ((l.title LIKE '%$queryarray[0]%' OR t.description LIKE '%$queryarray[0]%')";
for($i=1;$i<$count;$i++){
$sql .= " $andor ";
$sql .= "(l.title LIKE '%$queryarray[$i]%' OR t.description LIKE '%$queryarray[$i]%')";
}
$sql .= ") ";
}
$sql .= "ORDER BY l.date DESC";
$result = $xoopsDB->query($sql,$limit,$offset);
$ret = array();
$i = 0;
while($myrow = $xoopsDB->fetchArray($result)){
$ret[$i]['image'] = "images/playmovie.gif";
$ret[$i]['link'] = "modules/x_movie/x_movie_view.php?cid=".$myrow['cid']."&lid=".$myrow['lid']."'><img src='".$myrow['logourl']."' width='100' height='75'><br /";
$ret[$i]['title'] = $myrow['title'];
$ret[$i]['time'] = $myrow['date'];
$ret[$i]['uid'] = $myrow['submitter'];
$i++;
}
return $ret;
}
?>
the line 52, if I replace
$ret[$i]['link'] = "modules/x_movie/x_movie_view.php?cid=".$myrow['cid']."&lid=".$myrow['lid']."'><img src='".$myrow['logourl']."' width='100' height='75'><br /";
by
$ret[$i]['link'] = "x_movie_view.php?cid=".$myrow['cid']."&lid=".$myrow['lid']."'><img src='".$myrow['logourl']."' width='100' height='75'><br /";
it work ,but
these links no longer works!!
