Bug #22077 ยป 13457.diff
| t3lib/class.t3lib_fullsearch.php (working copy) | ||
|---|---|---|
|
while(list($field,)=each($conf['columns'])) {
|
||
|
$list[]=$field;
|
||
|
}
|
||
|
// Get query
|
||
|
$qp = $GLOBALS['TYPO3_DB']->searchQuery(array($swords), $list, $table);
|
||
|
// Count:
|
||
|
$count = $GLOBALS['TYPO3_DB']->exec_SELECTcountRows('*', $table, $qp . t3lib_BEfunc::deleteClause($table));
|
||
|
if($count || $showAlways) {
|
||
|
// Output header:
|
||
|
$out.='<strong>TABLE:</strong> '.$GLOBALS['LANG']->sL($conf['ctrl']['title']).'<BR>';
|
||
|
$out.='<strong>Results:</strong> '.$count.'<BR>';
|
||
|
if (count($list) > 0) {
|
||
|
// Get query
|
||
|
$qp = $GLOBALS['TYPO3_DB']->searchQuery(array($swords), $list, $table);
|
||
|
// Show to limit
|
||
|
if ($count) {
|
||
|
$rowArr = array();
|
||
|
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid,'.$conf['ctrl']['label'], $table, $qp.t3lib_BEfunc::deleteClause($table), '', '', $limit);
|
||
|
while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
|
||
|
$rowArr[]=$this->resultRowDisplay($row,$conf,$table);
|
||
|
$lrow=$row;
|
||
|
// Count:
|
||
|
$count = $GLOBALS['TYPO3_DB']->exec_SELECTcountRows('*', $table, $qp . t3lib_BEfunc::deleteClause($table));
|
||
|
if($count || $showAlways) {
|
||
|
// Output header:
|
||
|
$out .= '<strong>TABLE:</strong> ' . $GLOBALS['LANG']->sL($conf['ctrl']['title']) . '<br />';
|
||
|
$out .= '<strong>Results:</strong> ' . $count . '<br />';
|
||
|
// Show to limit
|
||
|
if ($count) {
|
||
|
$rowArr = array();
|
||
|
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid,' . $conf['ctrl']['label'], $table, $qp . t3lib_BEfunc::deleteClause($table), '', '', $limit);
|
||
|
while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
|
||
|
$rowArr[] = $this->resultRowDisplay($row, $conf, $table);
|
||
|
$lrow = $row;
|
||
|
}
|
||
|
$out .= '<table border="0" cellpadding="2" cellspacing="1">' . $this->resultRowTitles($lrow, $conf, $table) . implode(chr(10), $rowArr) . '</table>';
|
||
|
}
|
||
|
$out.='<table border="0" cellpadding="2" cellspacing="1">'.$this->resultRowTitles($lrow,$conf,$table).implode(chr(10),$rowArr).'</table>';
|
||
|
$out .= '<hr />';
|
||
|
}
|
||
|
$out.='<HR>';
|
||
|
}
|
||
|
}
|
||
|
}
|
||