Added support for a variable amount of tags

Previously, the blogging engine only allowed for three tags per post, and it also stored each in seperate fields. Now, all tags are stored in one
field and there can be more than three. The only functionality that has been removed because of this is that now, on archive pages, tags are not
shown next to the current month's posts as they used to be, because the Four Island templating system does not yet support sub-blocks of sub-blocks.

1 files changed, 1 insertions, 3 deletions

@@ -118,14 +118,12 @@ if (!isset($_GET['mode']) || ($_GET['mode'] == 'blog'))
                 $getposts = "SELECT * FROM updates WHERE author = \"" . $_GET['author'] . "\" ORDER BY id DESC";
         } else if ($_GET['blog'] == 'tag')
         {
-                $getposts = "SELECT * FROM updates WHERE tag1 = \"" . $_GET['tag'] . "\" OR tag2 = \"" . $_GET['tag'] . "\" OR tag3 = \"" . $_GET['tag'] . "\" ORDER BY id DESC";
+                $getposts = "SELECT * FROM updates WHERE tags LIKE '%s:" . strlen($_GET['tag']) . ":\"" . $_GET['tag'] . "\"%' ORDER BY id DESC";
         } else if (!isset($_GET['blog'])) {
                 $getposts = "SELECT * FROM updates ORDER BY id DESC";
         }
         $getposts2 = mysql_query($getposts);
 
-//      $si = $i;
-
         while (($items[$i] = mysql_fetch_array($getposts2)))
         {
                 $items[$i]['sortDate'] = strtotime($items[$i]['pubDate']);