diff options
| author | czaks <marcin@6irc.net> | 2015-03-10 14:22:47 +0100 |
|---|---|---|
| committer | czaks <marcin@6irc.net> | 2015-03-10 14:22:47 +0100 |
| commit | bf1b6103cf6d3cf7f83e85453aad2d03e03e62da (patch) | |
| tree | 9460a02b2e7629059349fb88cacb1ad54bab1814 /templates/themes/sitemap/theme.php | |
| parent | 6c4d3941fa729558f4a5313081c85b0a06202e54 (diff) | |
| parent | 4bf525599e7c596e7aec7f483664a091ef0db57b (diff) | |
Merge branch 'master' of github.com:vichan-devel/Tinyboard
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..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` 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`, `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); } |