/** * Get picture count * @return int */ public static function getImageCount($tableName, $fieldName, $itemId) { $options['where'] = 'tablenames=' . tx_rnbase_util_DB::fullQuoteStr($tableName, 'tx_dam_mm_ref'); $options['where'] .= ' AND ident=' . tx_rnbase_util_DB::fullQuoteStr($fieldName, 'tx_dam_mm_ref'); $options['where'] .= ' AND uid_foreign=' . (int) $itemId; $options['count'] = 1; $options['enablefieldsoff'] = 1; $ret = tx_rnbase_util_DB::doSelect('count(*) AS \'cnt\'', 'tx_dam_mm_ref', $options, 0); $cnt = count($ret) ? intval($ret[0]['cnt']) : 0; return $cnt; }
/** * Get picture count * @return int */ public static function getImageCount($tableName, $fieldName, $itemId) { $options['where'] = 'tablenames = ' . tx_rnbase_util_DB::fullQuoteStr($tableName, 'sys_file_reference'); $options['where'] .= ' AND fieldname = ' . tx_rnbase_util_DB::fullQuoteStr($fieldName, 'sys_file_reference'); $options['where'] .= ' AND uid_foreign = ' . (int) $itemId; $options['count'] = 1; $options['enablefieldsoff'] = 1; $ret = tx_rnbase_util_DB::doSelect('count(*) AS \'cnt\'', 'sys_file_reference', $options); return empty($ret) ? 0 : (int) $ret[0]['cnt']; }