Herself's Webtools

Scripts, HowTos, Templates, Plugins, Widgets, Tips and Useful Information

Archive for September, 2007

Wordpress 2.3 to upgrade or not to upgrade?

without comments

While there has been Much ado over nothing at Slashdot, to upgrade or not is the question now for Wordpress users.

Myself I am holding off. All plugins that use categories are now broken. Why Wordpress didn’t make things backwards compatible I am not sure? Until I, or someone else, re-writes the plugins I use that work with categories. I won’t be upgrading. ( I’m hoping to rewrite several this weekend. Check back next week. )
I strongly suggest you do a test upgrade on your home computer, test your plugins, template etc before upgrading on your webhost.

Old Tables:
wp_post2cat: post_id, category_id
wp_categories: cat_ID, cat_name

New Tables:
wp_term_relationship: object_id, term_taxonomy_id
wp_term_taxonomy: term_taxonomy_id, term_id, taxonomy, description, parent, count
wp_terms: term_id, name, slug, term_group

Before to get category names from a post you went from post2cat->category_id and matched it to wp_categories->cat_ID and grabbed the name.

Now to get category names from a post you go from wp_term_relationship->term_taxonomy_id and match it to wp_term_taxonomy->term_taxonomy_id and fetch term_id after which you must then go to wp_terms match term_id and fetch the name.

So dust off those MySQL books if you have plugins that need fixing.

Written by timestocome

September 28th, 2007 at 5:00 am

How and why you should use anchor tags

without comments

This is one of those HTML things I rarely use.  So I always have to go hunt to figure out how to use when I need them. Anchor links bring you to a section of a document. Let’s say you have this huge list of links. You don’t want to dump someone at the top of a long list that is sorted by subject when you can send them straight to that subject area. Or if you have written the Great American Novel all on one page, you could provide anchor links to individual chapters.

In the long page you create anchors:

<a name=”chapterone”>Chapter One</a>

To send someone straight to Chapter One create this link:

<a href=”http://greatamericannovel.com/index.html#chapterone”> Great American Novel: Chapter One</a>

I use them on the category links to your left. Click on a category link and it will take you to the anchor link for that category on the very large archives page.

Written by timestocome

September 26th, 2007 at 6:00 am

Posted in HTML, how to

Are you using “Google Webmaster Tools”?

without comments

Google Webmaster Tools are useful tools for your websites. Webmaster tools give different information than you will get from Google Analytics which gives visitor information.

Webmaster tools will tell you when you have broken links and what queries people use to find your site.  The statistics page will also show your websites position in the search results for specific queries.

You will find the terms people use when they link to your site and which pages get the links. Google Webmaster Tools also tells you your highest ranking page by month for each site.

Even though you likely already use analytics, this tool too has its uses.  Like all the Google webtools it is free.

If you are not already reading it be sure to check out Google’s Webmaster Blog. Which is full of useful information for webmasters.

Written by timestocome

September 24th, 2007 at 6:00 am

Posted in tools, useful sites