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.
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
Get a list of your commentators emails
SELECT DISTINCT comment_author_email FROM wp_comments;
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';[/sql] <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';[/sql] <a href="http://forums.lesterchan.net/index.php?topic=11.0">Tips & 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