Archive: August, 2008

With the release of WordPress 2.3, there were several major changes to the database structure. Most notably was the new taxonomy schema, which replaced the categories, post2cat, and link2cat tables in favor of a new term based system with three new tables – terms, term_taxonomy, and term_relationships. While there are plenty of guides on the new structure, this is a simple visual guide to the relationships of these tables – specifically for category handling. This information is really only useful for those who are writing plugins or other code that interface with the database directly, and want a handy reminder of the table relationships. More »

This tool allows you to extract the hex color codes from a remote CSS file, displaying both the hex codes and the colors themselves. You can then enter the new color codes you would like to replace them with. The script will then perform a global search and replace on the contents of the file, replacing each color with the code you specified, and displaying the updated CSS. More »