Lyceum-dev mailing list

[John Joseph Bachir <jjb AT ibiblio.org>]

Lyceum now uses user-specifiable slugs instead of id numbers in urls.

if you are upgrading your code, and you want to keep your database, and 
you have already changed the schema as i mentioned on the dev list a few 
days ago (so that the blogs table has a 'slug' column instead if 
'blogname'), then you can run this query to update all the home options:

(BACK UP YOUR DATABASE FIRST!)

UPDATE options, blogs
SET options.option_value = CONCAT('http://blogs.example.com/', blogs.slug)
WHERE blogs.id=options.blog AND options.option_name = 'home'

let me know if anyone has problems or questions.

John
--
aim/yim/msn/jabber.org: johnjosephbachir
713.494.2704
irc://irc.freenode.net/lyceum
http://lyceum.ibiblio.org/
http://blog.johnjosephbachir.org/
----------------------------------------------------------------------
I love the fact that we're reviled by a guy with a paunch who drives a 
Chevy (as a matter of religious conviction), calls himself the "flannel 
avenger", and earnestly believes in the principals of the confederacy. 
If I have to be anonymously maligned by proxy, then I'm glad this guy's 
the one doing it.  -Joey Carr, re: http://tinyurl.com/zhvbn