diff options
| author | czaks <marcin@6irc.net> | 2015-03-10 12:48:59 +0100 |
|---|---|---|
| committer | czaks <marcin@6irc.net> | 2015-03-10 12:48:59 +0100 |
| commit | bdb6001f3f7e93e0b9655c0491bbef6f1df8a5fa (patch) | |
| tree | 4f4007d1b090694746fc6d36a19dd8accfd3f8ca /templates/themes/sitemap/theme.php | |
| parent | eb245c2970062620f349024922f8c48379ffea88 (diff) | |
support for slugified links; may introduce a few bugs
Diffstat (limited to 'templates/themes/sitemap/theme.php')
| -rw-r--r-- | templates/themes/sitemap/theme.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/templates/themes/sitemap/theme.php b/templates/themes/sitemap/theme.php index 3e048dd5..1cebcdb6 100644 --- a/templates/themes/sitemap/theme.php +++ b/templates/themes/sitemap/theme.php @@ -26,7 +26,7 @@ $threads = array(); foreach ($boards as $board) { - $query = query(sprintf("SELECT `id` AS `thread_id`, (SELECT `time` FROM ``posts_%s`` WHERE `thread` = `thread_id` OR `id` = `thread_id` ORDER BY `time` DESC LIMIT 1) AS `lastmod` FROM ``posts_%s`` WHERE `thread` IS NULL", $board, $board)) or error(db_error()); + $query = query(sprintf("SELECT `id`, `slug`, (SELECT `time` FROM ``posts_%s`` WHERE `thread` = `thread_id` OR `id` = `thread_id` ORDER BY `time` DESC LIMIT 1) AS `lastmod` FROM ``posts_%s`` WHERE `thread` IS NULL", $board, $board)) or error(db_error()); $threads[$board] = $query->fetchAll(PDO::FETCH_ASSOC); } |