saganaki

Discovered a code plugin that does half the job:

category magic

puts up links to posts that belong to two categories…. this function call: glmdobcat(‘x’,’y’,’z’)…This call returns the last z numbers of posts that belong to BOTH, x and y, categories.

Next step needed is a function to figure out the number of posts in each category so only locations in that have real estate agents are shown. (eg real estate agents in Tokyo 4, real estate agents in nagasaki 12).Even better would be able to have the category hierarchy displayed, but I guess that complicates things even more…

I am aiming to put together code that takes a category hierarchy, then:
* checks the number of posts at each level that would be displayed by glmdobcat(‘x’,’y’,’99999′)
* if not zero, display the category name, number of posts and builds url to that will trigger glmdobcat(‘x’,’y’,’9999′)
*keep going till at bottom of hierarchy.

@roger

Great coincidence – trying to do a real estate blog too!

Here’s the blog.

This page will eventually contain a big list of real estate agents. All these agents are individual posts tagged with the category real estate agents (To display the single category of posts in combination with static text at the top I’ve used postlists

These agents are located in different regions and I have categories for these regions. I’d like to have a siderbar widget that lists the different regions the agents are listed in, and when clicked, only displays the agents in that region. Be great if I could display it as a list of categories and subcategories, show post counts beside the categories and hide empty parent categories…

Haven’t yet found a widget/plugin combo that does this. I’m not sure if there is a built in WP php function that allows you to do an and function on two categories. I’m pretty sure there’s a function that navigates through categories trees. The code could combine the two with results in an array and display the array results as the list of regions.

Found the cause of the problem.

To use the Language Switcher plugin and have a bi-lingual blog in Japanese and English required changing the DB Charset line in wp-config.php to use an extended characterset.

From define(‘DB_CHARSET’, ‘utf8’);
To define(‘DB_CHARSET’, ‘utf8_general_ci’)

Is this a bug in the plugin itself, has anyone encountered a work around?