Last week I wrote up a post to review the Real-Time Find and Replace Plugin and the comments on that story about other methods to make site wide changes permanent sent me in search of another way to search and replace information in my SQL database.
Now I consider myself pretty decent at geeky things but directly editing and messing with my site’s SQL database does not top my list of things to do. Neither does manually going through nearly 1,000 postings to make changes.
What I found was a terrific plug-in that lets me perform a few different functions to make corrections or change info throughout my site.
Caveat: Before I get started – this plugin does make changes to your database. Play it safe and back up your info to protect your original data.
With that said let me now introduce you to the Search Regex Plugin written by John Godley.
The […]
Original post by Richard Hay
Technorati Tags: blog
Like most of you, I have experimented with many WordPress plugins. I have seen a lot of great plugins and also a lot of bad plugins. I am a bit of a WordPress plugin developer myself, and I admit that I borrow many ideas from other good WordPress plugins. From that experience I have consolidated these good ideas into a checklist that you can follow when reviewing or coding a new WordPress plugin. Here are my picks of the top characteristics that make a great WordPress plugin.
10. Easy Installation
I have seen plugins that require you to modify code after plugin activation to be able to get it to work properly. The instructions were documented clearly in the readme.txt file, but most of the users seem to have missed it (I could tell from the frustration in the plugin support thread). Not everybody reads the […]
Original post by Thaya Kareeson
Technorati Tags: blog
I’ve seen a number of people tell others that WordPress 2.5 will have little to no database schema changes. It looks like that is no longer the case as MichaelH has pointed out.
Changes to database schema from Version 2.3 to 2.5.
*Table: comments
Changed ‘comment_approved’ to varchar(20) NOT NULL default ‘1′
Added KEY ‘comment_approved_date_gmt’ (comment_approved, comment_date_gmt)
Added KEY ‘comment_date_gmt’ (comment_date_gmt)
*Table: links
Changed ‘link_visible’ to varchar(20) NOT NULL default ‘Y’
*Table: options
Changed ‘autoload’ to varchar(20) NOT NULL default ‘yes’
*Table: posts
Changed ‘post_status’ to varchar(20) NOT NULL default ‘publish’
Changed ‘comment_status’ to varchar(20) NOT NULL default ‘open’
Changed ‘ping_status’ to varchar(20) NOT NULL default ‘open’
*Table: term_relationships
Added ‘term_order’ int(11) NOT NULL default 0
Thanks to MichaelH for putting these changes together. This information is especially useful to plugin and theme authors as it lets them know if their particular project will break.
Technorati Tags: blog
Original post by Jeffro2pt0
Technorati Tags: blog
