Publishing systems – WordPress 3.0

Jul 4, 2010Blog, Web design, 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

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';

Set count of comments to 0

UPDATE wp_posts SET comment_count = '0', ping_status = 'closed' WHERE post_date < '2010-01-01' AND post_status = 'publish';

Tips & Tricks For WP-PostRatings

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 maintaining web servers for existing clients and building websites for new clients. In my free time, I learn about Linux, SSH, and WP-CLI and I’m preparing this blog.

Related Posts

25+ Free Fonts for Your Next Design Project

25+ Free Fonts for Your Next Design Project

Looking for some fresh and creative fonts to spice up your design projects in 2023? You’re in luck! In this blog post, we’ve curated a list of 25 free fonts that you can download and use right away. These fonts are suitable for various purposes such as logos,...

Adobe Photoshop Shortcuts – Infographic

Adobe Photoshop Shortcuts – Infographic

Thanks to Amanda from the Consumer Base that she sent us an ultimate Adobe Photoshop shortcuts cheat sheet. If you are a beginner or want to brush up your knowledge on Adobe Photoshop shortcuts then you are at the right place. Have look at it and let us your thoughts...

20 WordPress Tutorial channels on Youtube

20 WordPress Tutorial channels on Youtube

This post will introduce you a useful list of the 20+ best currently active WordPress tutorial related channels on Youtube. These channels are mostly focused on Tutorials and Guides for Developers and Designers that want to learn all about WordPress. Check them out...

12 AI Tools for Graphic and Website Designers

12 AI Tools for Graphic and Website Designers

Artificial intelligence (AI) is transforming the way designers work, from ideation to execution. AI tools can help designers automate tedious tasks, generate new content, and enhance their creativity. In this blog post, I will introduce AI tools that you can use to...

How to Pair Fonts – Tips and Tools for Perfect Font Combinations

How to Pair Fonts – Tips and Tools for Perfect Font Combinations

Font pairing is the art of choosing two or more fonts that work well together and create a harmonious design. Font pairing can make or break your website, logo, poster, or any other project that involves typography. But how do you pair fonts like a pro? In this...

The Ultimate Guide to Color Palettes

The Ultimate Guide to Color Palettes

Color palettes are collections of colors that work well together and create a harmonious visual effect. They are essential for any design and art project, as they help to convey the mood, message, and style of your work. But how do you choose the right color palette...

Show/Hide Comments (0 comments)
L

0 Comments

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.

Social followers

Articles

Visits

Pin It on Pinterest

Shares