/**
* Make a query to database. You will receive an array with result rows. All
* database resources are closed after each call.
* A Hidden and Delete-Clause for FE-Requests is added for requested table.
*
* @param $what requested columns
* @param $from either the name of on table or an array with index 0 the from clause
* and index 1 the requested tablename
* @param $where
* @param $groupby
* @param $orderby
* @param $wrapperClass Name einer WrapperKlasse für jeden Datensatz
* @param $limit = '' Limits number of results
* @param $debug = 0 Set to 1 to debug sql-String
* @deprecated use tx_rnbase_util_DB::doSelect()
*/
function queryDB($what, $from, $where, $groupBy = '', $orderBy = '', $wrapperClass = 0, $limit = '', $debug = 0)
{
$tableName = $from;
$fromClause = $from;
if (is_array($from)) {
$tableName = $from[1];
$fromClause = $from[0];
}
$limit = intval($limit) > 0 ? intval($limit) : '';
// Zur Where-Clause noch die gültigen Felder hinzufügen
$contentObjectRendererClass = tx_rnbase_util_Typo3Classes::getContentObjectRendererClass();
$where .= $contentObjectRendererClass::enableFields($tableName);
if ($debug) {
$sql = $GLOBALS['TYPO3_DB']->SELECTquery($what, $fromClause, $where, $groupBy, $orderBy);
tx_rnbase_util_Debug::debug($sql, 'SQL');
tx_rnbase_util_Debug::debug(array($what, $from, $where));
}
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery($what, $fromClause, $where, $groupBy, $orderBy, $limit);
$wrapper = is_string($wrapperClass) ? tx_rnbase::makeInstanceClassName($wrapperClass) : 0;
$rows = array();
while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
$rows[] = $wrapper ? new $wrapper($row) : $row;
}
$GLOBALS['TYPO3_DB']->sql_free_result($res);
if ($debug) {
tx_rnbase_util_Debug::debug(count($rows), 'Rows retrieved');
}
return $rows;
}
