Skip to main content

Posts

Showing posts with the label wordpress

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' WHERE ( wpp.post_type = 'post' OR wpp.post_type = 'page' ) AND wpp.post_status = 'publish'

VW Blog Network

From Jetta blog to the VW blog network. Use WordPress 3 multi sites feature. http://blogs.vw.com/

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: http://blogs.vw.com/jetta/

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 Site URL: http://wendyshow.com