Publishing systems – WordPress 3.0

Jul 4, 2010Blog, Webdesign, WordPress

WordPress WordPress version 3.0 labeled Thelonious came out on June 17 2010. Key new features in this release include a new default theme called TwentyTen, which allows to easily implement custom backgrounds, headers, multilevel menu, but also our own content types. Was integrated and multi-user version that allows you to run one blog or ten million from the same installation. As a user, you will love the new lighter admin interface, the contextual help on every screen, 1,217 bug fixes and improvements to many other features such as bulk updates so you can upgrade 15 plugins at once with one click.




WordPress – database optimization

The following are tips for optimizing database. You can delete all revisions contributions, pingback and trackbacks, unnecessary comments, or such data left in some database plugin, you no longer use.

A Detailed Look Into WordPress Database Optimization

Delete Post Revision

DELETE a,b,c FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'

Delete all Pingback / Trackback

DELETE FROM wp_comments WHERE comment_type = 'pingback';

Delete all Spam Comments

DELETE FROM wp_comments WHERE comment_approved = 'spam';

0 = Comment Awaiting Moderation
1 = Approved Comment
spam = Comment marked as Spam

WordPress : 10+ life saving SQL queries

Get a list of your commentators emails

SELECT DISTINCT comment_author_email FROM wp_comments;

WordPress Discussion Management: Enable or Disable Comments and Pingbacks via SQL

Globally enable/disable comments, pingbacks and trackbacks before a certain date

UPDATE wp_posts SET comment_status = 'closed' WHERE post_date < '2008-01-01' AND post_status = 'publish';&#91;/sql&#93;

<strong>Set count of comments to 0</strong>

UPDATE wp_posts SET comment_count = '0', ping_status = 'closed' WHERE post_date < '2010-01-01' AND post_status = 'publish';&#91;/sql&#93;

<a href="">Tips &amp; Tricks For WP-PostRatings</a>

Users who want to remove all the post rating data from their posts now can simply use a little MySQL code thanks to vexx.

DELETE FROM wp_postmeta WHERE meta_key = 'ratings_score' OR meta_key ='ratings_users' OR meta_key = 'ratings_average'

WordPress – themes

Make your theme compatible with WordPress 3.0 menus
Goodbye, headaches. Hello, menus!
Open functions.php and add the following line:

add_theme_support( 'nav-menus' );

Once added, you can use the brand new wp_nav_menu() function in your theme files:

wp_nav_menu( array( 'sort_column' => 'menu_order', 'container_class' => 'navigation' ) );

Related from Twitter:

WordPress 3.0 Upgrade: What to Expect | Webdesigner Depot
8 New Exciting #WordPress 3.0 Features
Create your first WordPress Custom Post Type
10 Useful #WordPress Security Tweaks (via @smashingmag)
Wordpress How To: Add Related Posts Section Without Plugin:


Graphic and website designer, currently, I attend to the maintenance of about thirty sites for existing clients as well as creating websites for the new ones. In my free time, I get into the secrets of the world of Linux, SSH, WP-CLI and I’m preparing this blog.

Related Posts



Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Pin It on Pinterest