summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Prodromou <evan@status.net>2010-03-25 23:56:09 -0400
committerEvan Prodromou <evan@status.net>2010-06-01 13:52:27 -0700
commit0a04f9d49db4f28ace3f3d94ec0763a926296b44 (patch)
treece67eeccf78451ab3ae45cb4a963839231197fc9
parent524cd9df936bd27d5b64fbf08b219b56cb071122 (diff)
better query for notices by date
-rw-r--r--plugins/Sitemap/SitemapPlugin.php17
-rw-r--r--plugins/Sitemap/noticesitemap.php9
2 files changed, 9 insertions, 17 deletions
diff --git a/plugins/Sitemap/SitemapPlugin.php b/plugins/Sitemap/SitemapPlugin.php
index 8889c8930..bb404cd25 100644
--- a/plugins/Sitemap/SitemapPlugin.php
+++ b/plugins/Sitemap/SitemapPlugin.php
@@ -50,17 +50,6 @@ class SitemapPlugin extends Plugin
/**
* Load related modules when needed
*
- * Most non-trivial plugins will require extra modules to do their work. Typically
- * these include data classes, action classes, widget classes, or external libraries.
- *
- * This method receives a class name and loads the PHP file related to that class. By
- * tradition, action classes typically have files named for the action, all lower-case.
- * Data classes are in files with the data class name, initial letter capitalized.
- *
- * Note that this method will be called for *all* overloaded classes, not just ones
- * in this plugin! So, make sure to return true by default to let other plugins, and
- * the core code, get a chance.
- *
* @param string $cls Name of the class to be loaded
*
* @return boolean hook value; true means continue processing, false means stop.
@@ -99,9 +88,9 @@ class SitemapPlugin extends Plugin
$m->connect('/sitemaps/notice/:year/:month/:day/:index.xml',
array('action' => 'noticesitemap'),
array('year' => '[0-9]{4}',
- 'month' => '[1]?[0-9]',
- 'day' => '[123]?[0-9]',
- 'index' => '[0-9]+'));
+ 'month' => '[01][0-9]',
+ 'day' => '[0123][0-9]',
+ 'index' => '[1-9][0-9]*'));
$m->connect('/sitemaps/user/:index.xml',
array('action' => 'usersitemap'),
diff --git a/plugins/Sitemap/noticesitemap.php b/plugins/Sitemap/noticesitemap.php
index 7eec88636..002408486 100644
--- a/plugins/Sitemap/noticesitemap.php
+++ b/plugins/Sitemap/noticesitemap.php
@@ -68,9 +68,12 @@ class NoticesitemapAction extends SitemapAction
$this->notice = new Notice();
- $this->notice->whereAdd("created > '$y-$m-$d 00:00:00'");
- $this->notice->whereAdd("created <= '$y-$m-$d 11:59:59'");
- $this->notice->whereAdd('is_local = 1');
+ $dt = sprintf('%04d-%02d-%02d', $y, $m, $d);
+
+ $this->notice->whereAdd("created > '$dt 00:00:00'");
+ $this->notice->whereAdd("created <= '$dt 23:59:59'");
+
+ $this->notice->whereAdd('is_local != 0');
$this->notice->orderBy('id');
$this->notice->limit($offset, $limit);