diff options
| author | czaks <marcin@6irc.net> | 2015-03-10 13:34:02 +0100 |
|---|---|---|
| committer | czaks <marcin@6irc.net> | 2015-03-10 13:34:02 +0100 |
| commit | 4aa1d387f8a90d33207d28afc637958759e2ce6e (patch) | |
| tree | dead771cdd2fa089db69c26e7e3295be2fa800e8 /templates/themes/sitemap | |
| parent | e999955d08274efa5d78fd9bda410648dfb2ae12 (diff) | |
...
Diffstat (limited to 'templates/themes/sitemap')
| -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 1cebcdb6..41a7f304 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`, `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()); + $query = query(sprintf("SELECT `id`, `id` AS `thread_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); } |