Index of /people/lauri/krazykiwi/plugins/serendipity_event_freetag

      Name                    Last modified       Size  Description


[DIR] Parent Directory        21-Mar-2007 13:03      -  
[TXT] ChangeLog               25-May-2008 17:57     1k  
[DIR] UTF-8/                  25-May-2008 17:57      -  
[DIR] img/                    25-May-2008 17:57      -  
[   ] lang_bg.inc.php         25-May-2008 17:57     6k  
[   ] lang_de.inc.php         25-May-2008 17:57     6k  
[   ] lang_en.inc.php         25-May-2008 17:57     6k  
[   ] lang_fr.inc.php         25-May-2008 17:57     6k  
[   ] lang_hu.inc.php         25-May-2008 17:57     6k  
[   ] lang_it.inc.php         25-May-2008 17:57     3k  
[   ] lang_ja.inc.php         25-May-2008 17:57     6k  
[   ] lang_nl.inc.php         25-May-2008 17:57     4k  
[   ] lang_pl.inc.php         25-May-2008 17:57     4k  
[   ] lang_se.inc.php         25-May-2008 17:57     6k  
[   ] serendipity_event_fr..> 25-May-2008 17:57    76k  
[   ] serendipity_plugin_f..> 25-May-2008 17:57     7k  
[   ] wick.js                 25-May-2008 17:57    16k  

Using this subquery you can convert existing categories to tags:

INSERT INTO serendipity_entrytags (entryid, tag) 
  SELECT serendipity_entries.id, serendipity_category.category_name 
    FROM serendipity_entries, serendipity_category, serendipity_entrycat 
   WHERE serendipity_entrycat.entryid = serendipity_entries.id 
     AND serendipity_category.categoryid = serendipity_entrycat.categoryid;

[quoted from: http://pixelated-dreams.com/archives/229-Spring-Cleaning.html]

Or using this script you can convert existing categories to tags:

<?php
include 'serendipity_config.inc.php';

$rows = serendipity_db_query("SELECT e.id, e.title, c.category_name
                                FROM {$serendipity['dbPrefix']}entries AS e
                                JOIN {$serendipity['dbPrefix']}entrycat AS ec
                                  ON ec.entryid = e.id
                                JOIN {$serendipity['dbPrefix']}category AS c
                                  ON ec.categoryid = c.categoryid");

foreach($rows AS $row) {
    serendipity_db_query(
        sprintf(
            "REPLACE INTO {$serendipity['dbPrefix']}entrytags (entryid, tag) VALUES (%d, %s)",
            (int)$row['id'],
            serendipity_db_escape_string($row['category_name'])
        )
    );
    
    printf(
        "Category '%s' added as Tag for Entry #%d, '%s'<br />\n",
        htmlspecialchars($row['category_name']),
        (int)$row['id'],
        htmlspecialchars($row['title'])
    );
}