Serious cross-site request forgery vulnerability found in Gmail
ars technica via Juha
Firmware update likely to make unlocked iPhones "permanently inoperable"
WordPress 2.3 Released
Tekstiviesti kertoi Finnairin koneen myöhästyvän, kone lähti ajallaan
Notepad++ v4.3 Released
FileZilla (client) 3.0.1 Released (Windows)
Jpegcrop: lossless cropping for JPEG pictures (Windows)
Hacker Finds Serious Security Flaw in Adobe PDF
Fixing my plugin's SQL for WordPress 2.3
I just upgraded WordPress to version 2.3 RC 1 at my test blog, and found out that changes in the taxonomy schema break my Parental Control plugin in a nasty way. Fortunately, it was quite easy to fix.
I added a test for WordPress’ version and branched the SQL accordingly:
if (version_compare(get_bloginfo('version'), '2.3-RC1', '<')) { $text .= " AND ( '".$jupc_excluded_cat."' ALL (SELECT category_id FROM $wpdb->post2cat WHERE $wpdb->post2cat.post_id = $wpdb->posts.ID) )"; } else { $text .= " AND ( '".$jupc_excluded_cat."' ALL (SELECT term_taxonomy_id FROM $wpdb->term_relationships WHERE $wpdb->term_relationships.object_id = $wpdb->posts.ID) )"; }
The code above reserved for versions 2.3 RC1 and above would probably work with the 2.3 Betas as well, but as I don’t have any interest in testing already obsolete versions, I decided to draw the line to 2.3 RC1, so the code above probably won’t work with 2.3 trunk versions below RC1.