Tons of Twitter rows in my database

Here is a bait-and-switch approach to deleting all those rows: CREATE TABLE wp_posts_new LIKE wp_posts; ALTER TABLE wp_posts_new DISABLE KEYS; INSERT INTO wp_posts_new SELECT * FROM wp_posts WHERE post_type’http’ AND post_title<>’GET http://twitter.com/statuses/user_timeline/@xcentric.json?count=100′; ALTER TABLE wp_posts_new ENABLE KEYS; ALTER TABLE wp_posts RENAME wp_posts_old; ALTER TABLE wp_posts_new RENAME wp_posts; Now start using you website. When you are … Read more

How to display sorted posts in the ‘All Posts’ page

I think this is what you want… This isn’t tested so you may have to fiddle with it. in your functions.php file, add something like this : EDIT (2) After rereading, I saw you’re not using custom post types, so i’ll change my code accordingly. I don’t know how to detect when you’re on the … Read more

How to create multiple version of single post

Create another post under same categories with same title but _hi in last of paramlink. Then add one more tag to all your hindi posts, say hindi. Now exclude all the posts of hindi tag from default search or index. Do the same with your English posts. Give an option to opt language on all … Read more