sfong15

Help please! Nobody is using WXR import or is it just me having this problem?

Parol, like this on the sidebar?

g30rg3x,

Just tried your great plugin on localhost, it works great. One little question forgive my little knowledge my mysql, I have a quick glance on your code it alters db (line 126) and fields of each table (line 128) to utf8. I couldn’t see anything is done to collation of fields of each table?

When I did my little test on localhost collation was changed to utf8_general_ci? What if someone needs a different collation?

Thanks g30rg3x,

Great explanation now I would only use your plugin for my data in the hosting.

Anderapt, thanks for the script. I have a look at yours and the guide in codex, I’m a little confused. Is there any need to convert data type to BLOB first?

I tried a little script from here (not for WP but easy to convert) which worked fine at my localhost. Before I risk my data/database at hosting can someone clarify the need to convert data type to BLOB and back? This little script from sveit.com doesn’t do that step.

Thanks Moshu, I did read that and have solved the problem at one of my sites by removing 2 lines from config.php. I also read in this thread that there could be other issues caused by removing that 2 lines, who knows, so I thought changing table and field collation could be a permanent solution for non-English blogs.

I now found a solution by goggling it see this post here. I have just tried this at localhost and it worked beautifully.

What thomasw98 said earlier here is what happening to me. My host said default charset of latin_swedish_ci can’t be changed and if I want to alter collation I have to get into each and every table and change it manually. I did that for one of my sites, too troublesome. Alternative solution would be exporting your db, create new db (with the charset and collation you want at top level) and import again. That’s also scary and risky and your site will be down for a while.

I just wondered if there are geeks for MySQL around who may know a way to alter collation for all tables in a database, say by running a script file or something like that.

If that’s possible perhaps a plugin for non-English users of WP would welcome that.

greenshady, what you are looking for is here

greenshady, I’ll look out for your solution using jQuery. In fact I’m playing with another blogware which comes with jQuery. It’s nice to use library already available.

I don’t know any answer but I have played with jQuery for a little while. I followed one of their example at the site. The trouble with that is that you click to expand one section but every other sections will also be expanded. I guess it’s hard for me to write javascript to add id to each collapsible section such that only one is expanded when clicked while opened one will be closed…etc.

I used something else, see my way here https://template.sfong.net/?p=75

Hacks should always be turned into a plugin. You’ll soon forget why and how you did the hacks but if it’s a plugin it could be well documented with clean interface. You’ll have nothing to worry about even if you switch between themes.

It’s not difficult at all.

silverelf,

See if you are looking for this, a screen shot here look for the latest version at the download page.

hmnikatz,

Are you looking for something like this, check this post out.

This post may answer your question. A widgetized version is also available now.

Thanks StigRoar for introducing the theme jillij.com. I have now learn from that theme the pure CSS drop-down, modified a bit and used it here at my site. I didn’t use the javascripts that came with jillij’s theme to make it good for IE7 but I think it’s barely OK on IE.

The color scheme is a bit weird for the menu as I want to be sure of my color changes to each block, that was all.