Bugfix: Google Sitemap Plugin and draft static pages

[frAgor]

(I do not know which forum to use for bugfixes and not bug reports, so I simply use this one )

I wondered why google listed a static page from my blog with state draft.
This was caused by the SQL query in serendipity_event_google_sitemap.php.

So please change (lines 285 - 290) from

Code: Select all

$static_pages = serendipity_db_query(
        'SELECT permalink, '.$sqlnullfunction.'(timestamp, 0)
         FROM '.$serendipity['dbPrefix'].'staticpages
         WHERE CHAR_LENGTH(pass)=0',
    false, 'assoc');

to

Code: Select all

$static_pages = serendipity_db_query(
        'SELECT permalink, '.$sqlnullfunction.'(timestamp, 0)
         FROM '.$serendipity['dbPrefix'].'staticpages
         WHERE CHAR_LENGTH(pass)=0 AND publishstatus != 0',
    false, 'assoc');

Thank you,
Markus

[garvinhicking]

Thanks a lot! Fixed in CVS!

Best regards,
Garvin