Classes/Command/MetaseoCommandController.php
public function clearSitemapCommand($rootPageId)
    {
        $rootPageId = $this->getRootPageIdFromId($rootPageId);

        if ($rootPageId !== null) {
            $query = 'DELETE FROM tx_metaseo_sitemap
                       WHERE page_rootpid = ' . DatabaseUtility::quote($rootPageId, 'tx_metaseo_sitemap') . '
                         AND is_blacklisted = 0';
            DatabaseUtility::exec($query);

            ConsoleUtility::writeLine('Sitemap cleared');
        } else {
            ConsoleUtility::writeErrorLine('No such root page found');
            ConsoleUtility::terminate(1);
        }
    }
public function clearSitemapCommand($rootPageId)
    {
        $rootPageId = $this->getRootPageIdFromId($rootPageId);

        if ($rootPageId !== null) {
            $query = 'DELETE FROM tx_metaseo_sitemap
                       WHERE page_rootpid = ' . DatabaseUtility::quote($rootPageId, 'tx_metaseo_sitemap') . '
                         AND is_blacklisted = 0';
            DatabaseUtility::exec($query);

            ConsoleUtility::writeLine('Sitemap cleared');
        } else {
            ConsoleUtility::writeErrorLine('No such root page found');
            ConsoleUtility::terminate(1);
        }
    }
public function clearSitemapCommand ( $ rootPageId ) { $ rootPageId = $ this -> getRootPageIdFromId ( $ rootPageId ) ; if ( $ rootPageId !== null ) { $ query = 'DELETE FROM tx_metaseo_sitemap
                       WHERE page_rootpid = ' . DatabaseUtility :: quote ( $ rootPageId , 'tx_metaseo_sitemap' ) . '
                         AND is_blacklisted = 0' ; DatabaseUtility :: exec ( $ query ) ; ConsoleUtility :: writeLine ( 'Sitemap cleared' ) ; } else { ConsoleUtility :: writeErrorLine ( 'No such root page found' ) ; ConsoleUtility :: terminate ( 1 ) ; } }
Clear sitemap for one root page

@param   string $rootPageId Site root page id or domain
Clear sitemap for one root page