Big Bad Code

Hey everyone, I’ve been testing Lyceum which is a multi user wordpress blogging system for an upcoming project at work. I needed to create a lot of blogs quickly and fortunately there is a handy import users feature which creates blogs for everyone.

Unfortunately it names the new blogs in an ugly way, http://multi.lyceumblog.com/username_blog_183

So I’m posting a couple of SQL Scripts for other people to use that updates the blog names to just the user name.

UPDATE options, usermeta, users
SET options.option_value  = concat('http://multi.lyceumblog.com/' , users.user_login)
WHERE options.option_name = 'home'
AND options.blog = usermeta.blog
AND usermeta.user_id = users.id
 
UPDATE blogs, usermeta, users
SET blogs.slug =  users.user_login
WHERE blogs.id = usermeta.blog AND
usermeta.user_id = users.id
 
UPDATE options, usermeta, users
SET options.option_value  = users.user_login
WHERE options.option_name = 'blogname'
AND options.blog = usermeta.blog
AND usermeta.user_id = users.id

A little info about Lyceum from the site:

Developed by ibiblio.org, Lyceum is a stand-alone mutli-user blogging application, designed for the enterprise.