Skip to Content.
Sympa Menu

lyceum-dev - [Lyceum-dev] slugs now in effect

lyceum-dev AT lists.ibiblio.org

Subject: Lyceum-dev mailing list

List archive

Chronological Thread  
  • From: John Joseph Bachir <jjb AT ibiblio.org>
  • To: lyceum-users AT lists.ibiblio.org, lyceum-dev AT lists.ibiblio.org
  • Subject: [Lyceum-dev] slugs now in effect
  • Date: Tue, 28 Mar 2006 17:25:29 -0500 (EST)

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




Archive powered by MHonArc 2.6.24.

Top of Page