Statistics: Blog

Comments Posted By Lester Chan

Displaying 0 To 0 Of 0 Comments

Popular Sites Using My Plugins

thanks for the compliments. But unfortunately you are not able to apply it outside of WP because of the way it works.

» Posted By Lester Chan On 19th October 2008 @ 12:26

Thanks Paul =)

Stanley, they always leave the extra stuff to be done by plugins. But in WP2.7, the incorporated sticky feature

» Posted By Lester Chan On 11th October 2008 @ 11:14

Right To Left Language Support

The translation are all for 1.40/2.40 which are not yet released and hence I have not uploaded it

» Posted By Lester Chan On 7th October 2008 @ 18:40

Confirmed WordPress 2.7 Features

I think the new admin panel will be even better as it support resolutions larger than 1024

I have no idea on that part as I have not tried it myself. I am waiting for the beta

» Posted By Lester Chan On 14th September 2008 @ 21:50

WordPress 2.6.2

2.6.2 contains a security fix, if you ask me. I would recommend you to update =D

» Posted By Lester Chan On 11th September 2008 @ 14:05

WordPress 2.6.1

Ops =p

» Posted By Lester Chan On 28th August 2008 @ 10:02

Check your error_log if it does not load to see what is the problem

» Posted By Lester Chan On 28th August 2008 @ 00:45

WordPress 2.7 Will Feature Sticky Post

That is not really within my reach with regards to the notification. I updated all the plugins at the same time and apparently only WP-RelativeDate got updated

» Posted By Lester Chan On 15th December 2008 @ 23:55

You can try using WP-Sticky on WordPress 2.7, you need to rename function is_sticky() to function is_sticky2()

It is untested.

» Posted By Lester Chan On 5th December 2008 @ 11:54

It will be the same thing (duplicate functionality) and it is like re-inventing the wheel. There will be conflicts in the function calls as well.

» Posted By Lester Chan On 30th November 2008 @ 01:00

You can have more than 1 sticky post and it will stick to the front page.

» Posted By Lester Chan On 19th November 2008 @ 21:17

WordPress App For iPhone/iPod Touch

Hi Matt,

Thank You So much for the link, I appreciate that =D

» Posted By Lester Chan On 22nd July 2008 @ 21:07

How To Turn Off Post Revision In WordPress 2.6

There is no way of knowing unless you know the IDs of the post.

» Posted By Lester Chan On 11th November 2008 @ 02:36

That code will only delete away the revisions but not the custom meta along with the revision.

» Posted By Lester Chan On 10th November 2008 @ 23:44

It is not recommended to touch the core files as you will lose them if you upgrade

» Posted By Lester Chan On 26th October 2008 @ 23:38

it will still autosave, but it will not create the revisions

» Posted By Lester Chan On 13th October 2008 @ 14:58

I am using WP-Syntax, http://wordpress.org/extend/plugins/wp-syntax/

» Posted By Lester Chan On 7th October 2008 @ 15:18

Hi Binh, I think there is a plugin by DD32 that controls the revision. You can run the sql query to remove the revisions =)

» Posted By Lester Chan On 27th September 2008 @ 13:38

Ops my bad, updated.

» Posted By Lester Chan On 27th August 2008 @ 22:51

Hmm glad it works. But it is quite weird

» Posted By Lester Chan On 25th August 2008 @ 14:21

What about after that change back to false again, does it work? I am using false lol

» Posted By Lester Chan On 25th August 2008 @ 02:20

I have updated to 2.6.1 and it still works for me. I don’t see why it do not work for you. You overwrite the wp-config.php?

» Posted By Lester Chan On 24th August 2008 @ 15:33

Hmm I have not come accross any diagrams of that sort yet. If no post_id is NULL, i am guessing that there is no left over term and postmeta.

» Posted By Lester Chan On 19th August 2008 @ 22:20

I just tested on my localhost, it seems to work fine. What version of MYSQL u are using?

» Posted By Lester Chan On 19th August 2008 @ 13:13

Hi Robert,

I hope you did a backup before you ran the code just in case 🙂

» Posted By Lester Chan On 19th August 2008 @ 10:24

Ops my bad, try this code:
DELETE b, c
FROM wp_term_relationships b LEFT JOIN wp_postmeta c ON (c.post_id = b.object_id) WHERE post_id IS NULL
I tested it, it should work

» Posted By Lester Chan On 18th August 2008 @ 22:02

Hi Robert,

No idea whether this code works, you want to try to see if it returns any results first.

SELECT a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.id IS NULL

» Posted By Lester Chan On 18th August 2008 @ 14:36

Thanks updated =D

» Posted By Lester Chan On 31st July 2008 @ 01:52

@oldengine Thanks, I have updated the code.

» Posted By Lester Chan On 30th July 2008 @ 23:09

@oldengine Yours is more detailed, as mine only cleans up wp_post table and not the term_relationships table and wp_postmeta table.

Did the code work for you?

» Posted By Lester Chan On 30th July 2008 @ 14:19