Category: General

[php]SET @sql = NULL; SELECT GROUP_CONCAT(DISTINCT CONCAT( ‘MAX(IF(pa.meta_name = ”’, meta_name, ”’, "pa.meta_value", NULL)) AS ‘, meta_name ) ) INTO @sql FROM post_meta; SET @sql = CONCAT(‘SELECT p.id , p.name , p.type, ‘, @sql, ‘ FROM post p LEFT JOIN post_meta AS pa ON p.id = pa.post_id GROUP BY p.id’); PREPARE stmt FROM @sql; EXECUTE…

before you go with this please backup your date i am not responsible about your errors 🙂 enjoy [php] DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL [/php]

WordPress custom post types plugins benchmark : WP plugins benchmark . WordPress custom post types plugins benchmark by Nicolas Mollet . Easy post types Custom post type UI WP post type UI CMS Press GD Custom Posts And Taxonomies Tools Lite GD Custom Posts And Taxonomies Tools Pro More Types . Review date June 23rd,…

Assuming that table B is exact copy of table A, and that all necessary indexes are created, self-join of table A should be a bit faster than join of B with A simply because data from table A and its indexes can be reused from cache in order to perform self-join (this may also implicitly…

My online portfolio features some of the design works and projects that I have completed in the past. To navigate, click on the arrows or thumbnails. To pause the slideshow at any time, hover over the large image. Personal Summary widget

Web development is a much, much deeper subject than simply building websites. It involves project management, agile work methods, and knowledge of a multitude of technologies, from the behind the scenes software that make websites come to life, to the ‘font end’ technologies that make the finished product look and feel welcoming for the user.…

use a sniffer likehttp://www.nirsoft.net/utils/dns_query_sniffer.html This exactly shows in real-time what domains are being queried. But to make your life easier, these are the domains being queried when using the Facebook Messenger for Windows: www.facebook.com orcart.facebook.com fbstatic-a.akamaihd.net api.facebook.com orcart.facebook.com fbexternal-a.akamaihd.net fbcdn-profile-a.akamaihd.net graph.facebook.com fbcdn-dragon-a.akamaihd.net to block chat http://www.facebook.com/ajax/presence *facebook.com/ajax/chat**facebook.com/images/chat**facebook.com/ajax/presence**.channel*.facebook.com/x/*/false/p_* will update this post with the blocking ways

Law #1: If a bad guy can persuade you to run his program on your computer, it’s not your computer anymore Law #2: If a bad guy can alter the operating system on your computer, it’s not your computer anymore Law #3: If a bad guy has unrestricted physical access to your computer, it’s not…

Can you summarize this article in 140 characters? In the event of you being short for time, here’s the tweet-sized summary of this article: Decouple app. architecture w/module,facade & mediator patterns. Mods publish msgs, mediator acts as pub/sub mgr & facade handles security What exactly is a ‘large’ JavaScript application? Before we begin, let us…

No power. No Spin. No Sound. Burning smell. PCB is extremely hot. See burned mark on the printed circuit board. Power surge. Connect the hard drive case to wrong power supply. Hard drive makes “Clicking sound”. Symptoms of PCB failure and the percentage the following symptoms of a media failure are may be results of…