Classes/Domain/Repository/SitemapRepository.php
private function getRecordsFromDatabase($typoScriptUrlEntry)
    {
        if (!isset($GLOBALS['TCA'][$typoScriptUrlEntry['table']])
            || !is_array($GLOBALS['TCA'][$typoScriptUrlEntry['table']]['ctrl'])
        ) {
            return false;
        }

        $language = '';
        if ((int)$typoScriptUrlEntry['hideIfNotTranslated'] === 1) {
            $language = 'AND (sys_language_uid=\'-1\' OR sys_language_uid="' . (int)GeneralUtility::_GET('L') . '") ';
        }

        return $this->getDatabaseConnection()->exec_SELECTquery(
            '*',
            $typoScriptUrlEntry['table'],
            'pid!=0 ' . $language . ' ' . AdditionalWhereService::getWhereString(
                $typoScriptUrlEntry['additionalWhere']
            ) . $this->pageRepository->enableFields(
                $typoScriptUrlEntry['table']
            ),
            '',
            OrderByService::getOrderByString(
                $typoScriptUrlEntry['orderBy'],
                $typoScriptUrlEntry['table']
            ),
            LimitService::getLimitString(
                $typoScriptUrlEntry['limit']
            )
        );
    }
private function getRecordsFromDatabase($typoScriptUrlEntry)
    {
        if (!isset($GLOBALS['TCA'][$typoScriptUrlEntry['table']])
            || !is_array($GLOBALS['TCA'][$typoScriptUrlEntry['table']]['ctrl'])
        ) {
            return false;
        }

        $language = '';
        if ((int)$typoScriptUrlEntry['hideIfNotTranslated'] === 1) {
            $language = 'AND (sys_language_uid=\'-1\' OR sys_language_uid="' . (int)GeneralUtility::_GET('L') . '") ';
        }

        return $this->getDatabaseConnection()->exec_SELECTquery(
            '*',
            $typoScriptUrlEntry['table'],
            'pid!=0 ' . $language . ' ' . AdditionalWhereService::getWhereString(
                $typoScriptUrlEntry['additionalWhere']
            ) . $this->pageRepository->enableFields(
                $typoScriptUrlEntry['table']
            ),
            '',
            OrderByService::getOrderByString(
                $typoScriptUrlEntry['orderBy'],
                $typoScriptUrlEntry['table']
            ),
            LimitService::getLimitString(
                $typoScriptUrlEntry['limit']
            )
        );
    }
private function getRecordsFromDatabase ( $ typoScriptUrlEntry ) { if ( ! isset ( $ GLOBALS [ 'TCA' ] [ $ typoScriptUrlEntry [ 'table' ] ] ) || ! is_array ( $ GLOBALS [ 'TCA' ] [ $ typoScriptUrlEntry [ 'table' ] ] [ 'ctrl' ] ) ) { return false ; } $ language = '' ; if ( ( int ) $ typoScriptUrlEntry [ 'hideIfNotTranslated' ] === 1 ) { $ language = 'AND (sys_language_uid=\'-1\' OR sys_language_uid="' . ( int ) GeneralUtility :: _GET ( 'L' ) . '") ' ; } return $ this -> getDatabaseConnection ( ) -> exec_SELECTquery ( '*' , $ typoScriptUrlEntry [ 'table' ] , 'pid!=0 ' . $ language . ' ' . AdditionalWhereService :: getWhereString ( $ typoScriptUrlEntry [ 'additionalWhere' ] ) . $ this -> pageRepository -> enableFields ( $ typoScriptUrlEntry [ 'table' ] ) , '' , OrderByService :: getOrderByString ( $ typoScriptUrlEntry [ 'orderBy' ] , $ typoScriptUrlEntry [ 'table' ] ) , LimitService :: getLimitString ( $ typoScriptUrlEntry [ 'limit' ] ) ) ; }
Get records from database

@param $typoScriptUrlEntry
@SuppressWarnings(superglobals)

@return bool|\mysqli_result|object
Get records from database