diff options
| author | Starla Insigna <hatkirby@fourisland.com> | 2008-12-07 20:25:36 -0500 |
|---|---|---|
| committer | Starla Insigna <hatkirby@fourisland.com> | 2008-12-07 20:25:36 -0500 |
| commit | 25a101d128ada4cac4e634b1c0fdd881551fd376 (patch) | |
| tree | 16189519d01940f01c6a91c4786508c080aefc2f /rss.php | |
| parent | 9a4c37255351aadc223bb9609623888cb01d5fde (diff) | |
| download | fourisland-25a101d128ada4cac4e634b1c0fdd881551fd376.tar.gz fourisland-25a101d128ada4cac4e634b1c0fdd881551fd376.tar.bz2 fourisland-25a101d128ada4cac4e634b1c0fdd881551fd376.zip | |
Redid multiple tag system
This new tag system has a seperate table for tags. This way, a tag cloud can be made much more easily than if using the previous system. This changeset requires manual maintinence.
Diffstat (limited to 'rss.php')
| -rwxr-xr-x | rss.php | 2 |
1 files changed, 1 insertions, 1 deletions
| diff --git a/rss.php b/rss.php index 8dc36b6..1758049 100755 --- a/rss.php +++ b/rss.php | |||
| @@ -118,7 +118,7 @@ if (!isset($_GET['mode']) || ($_GET['mode'] == 'blog')) | |||
| 118 | $getposts = "SELECT * FROM updates WHERE author = \"" . $_GET['author'] . "\" ORDER BY id DESC"; | 118 | $getposts = "SELECT * FROM updates WHERE author = \"" . $_GET['author'] . "\" ORDER BY id DESC"; |
| 119 | } else if ($_GET['blog'] == 'tag') | 119 | } else if ($_GET['blog'] == 'tag') |
| 120 | { | 120 | { |
| 121 | $getposts = "SELECT * FROM updates WHERE tags LIKE '%s:" . strlen($_GET['tag']) . ":\"" . $_GET['tag'] . "\"%' ORDER BY id DESC"; | 121 | $getposts = "SELECT * FROM updates AS u, tags AS t WHERE u.id = t.post_id AND t.post_type = \"published\" AND t.tag = \"" . $_GET['tag'] . "\" ORDER BY u.id DESC"; |
| 122 | } else if (!isset($_GET['blog'])) { | 122 | } else if (!isset($_GET['blog'])) { |
| 123 | $getposts = "SELECT * FROM updates ORDER BY id DESC"; | 123 | $getposts = "SELECT * FROM updates ORDER BY id DESC"; |
| 124 | } | 124 | } |