Search found 4 matches

by medienluemmel
Tue Aug 05, 2008 9:21 am
Forum: General discussions
Topic: Preparing for import?
Replies: 13
Views: 6495

judebert wrote:Sounds like an interesting script! Perl, I assume?
It's not a script; it's a c++-application with a (user defined) content and category database; with this application you can create the export sql-statements for Serendipity, but also for an older version of Wordpress.
by medienluemmel
Fri Aug 01, 2008 7:50 am
Forum: General discussions
Topic: Preparing for import?
Replies: 13
Views: 6495

Oh, one thing I forgot: To get the authorid with

Code: Select all

(SELECT authorid FROM sp_authors WHERE realname = 'Author-Name')
the name of the author(s) has to be present on your serendipity system.
by medienluemmel
Fri Aug 01, 2008 7:47 am
Forum: General discussions
Topic: Preparing for import?
Replies: 13
Views: 6495

I've written a program to write the complete content offline and then export it to serendipity format. The export output looks like this:

DELETE FROM sp_category;
DELETE FROM sp_entrycat;
DELETE FROM sp_entries;
ALTER TABLE sp_category AUTO_INCREMENT = 1;
ALTER TABLE sp_entrycat AUTO_INCREMENT = 1 ...
by medienluemmel
Fri Jul 25, 2008 12:48 pm
Forum: General discussions
Topic: Links for entries without category on sidebar
Replies: 1
Views: 1503

Links for entries without category on sidebar

On my site I have about five entries with additional informations about the site/blog - all those entries do not belong to any category.

Now: Is it possible to show up a menu on the sidebar containing links to those entries? If I do this by hand in the sidebar.tpl this would look like:

<h3 ...