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

TwentyTen

TwentyTen

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="http://forums.lesterchan.net/index.php?topic=11.0">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 http://bit.ly/cPCsFc
8 New Exciting #WordPress 3.0 Features http://su.pr/1j1qzP
Create your first WordPress Custom Post Type http://bit.ly/9NBCi0
10 Useful #WordPress Security Tweaks (via @smashingmag) http://tinyurl.com/39nbmw8
Wordpress How To: Add Related Posts Section Without Plugin: http://bit.ly/aZLY4j

David

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.

More:

Divi 2.5 WordPress Theme Resource Toolbox It's been two years when Nick Roach from Elegant Themes introduced a unique Divi WordPress theme with an advanced website builder, a number of robust ...
15 WordPress Blogs & Themes sites A list of the 15 Wordpress Blogs & Themes sites from around the web. Weblog Tools Collection WordPress Hacks Lorelle on WordPress Yoast ...
10 Free Graphic Design Resources by Mighty Deals Here's a roundup of a Free Graphic Design Resources collected for your next project or just inspiration. Based out of Vancouver, Canada, MightyDeals h...
How to add WordPress Author Bio & Profile Pag... Today I will show you how you can integrate very nice Author Bio at the end of each article in your wordpress theme and more we take a look how to ma...
4 Areas Of Your Business You Need To Fund Business are difficult things to start, and with more than half of them failing in the first five years, it’s essential to get things right from the b...

Leave a Reply

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


Newsletter

Join our mailing list to receive the latest news and updates.

You have Successfully Subscribed!

Pin It on Pinterest