Showing posts with label wordpress. Show all posts
Showing posts with label wordpress. Show all posts

Friday, February 28, 2014

How to get WordPress posts permalinks using SQL(database) alone

SELECT wpp.post_title, wpp.post_type, wpp.guid, wpp.post_date, CONCAT( wpo_su.option_value, REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( wpo.option_value, '%year%', DATE_FORMAT( wpp.post_date, '%Y' ) ) ,'%monthnum%', DATE_FORMAT( wpp.post_date, '%m' ) ) , '%day%', DATE_FORMAT( wpp.post_date, '%d' ) ) , '%postname%', wpp.post_name ) , '%category%', wpp.post_type ) ) AS permalink
FROM wp_posts wpp
INNER JOIN wp_options wpo ON wpo.option_name = 'permalink_structure'
INNER JOIN wp_options wpo_su ON wpo_su.option_name = 'siteurl'
wpp.post_type = 'post'
OR wpp.post_type = 'page'
AND wpp.post_status = 'publish'

Thursday, March 24, 2011

VW Blog Network

From Jetta blog to the VW blog network. Use WordPress 3 multi sites feature.

Tuesday, October 5, 2010

VW Jetta Blog

It has been quite busy since I joined Deutsch LA. Today, I finally got some time to update my portfolio. This is another Wordpress blog I finished. First time using Wordpress 3 and its multi-site capability. The blog has poll, some Facebook elements, gallery and a homepage carousel. Found a couple useful plugins such as NextGEN Gallery, Widget Context and Shadow JS.

Development time: 2 weeks.
Site URL:

Friday, July 10, 2009

The Wendy Williams Show

The official site for The Wendy Williams Show. It is built using WordPress which is an excellent tool. I like it better than Drupal. Lots of plugins, user friendly admin tool. Easy to create a customized PHP page using template tags.
Time spent: 3 weeks
Programming: PHP, MySQL, WordPress