install new cpanel centos vm xen server from local repos

first this is the iso http://httpupdate.cpanel.net/cPanel-CentOS-6.4-x86_64.iso always get lattest from this url http://httpupdate.cpanel.net/ ok lets start log in to the host server ssh [php] cd / mkdir /isolib wget http://httpupdate.cpanel.net/cPanel-CentOS-6.4-x86_64.iso xe sr-create name-label=isolib type=iso device-config:legacy_mode=true device-config:location=/isolib content-type=iso [/php] finished then go create virtual vm and install centos if any question comment me

MySQL Pivot dynamic table columns

[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 […]

mysql self join

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 […]

about

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

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. […]

block facebook on network home router

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

Best Practices for Speeding Up Your Web Site

Minimize HTTP Requests tag: content 80% of the end-user response time is spent on the front-end. Most of this time is tied up in downloading all the components in the page: images, stylesheets, scripts, Flash, etc. Reducing the number of components in turn reduces the number of HTTP requests required to render the page. This […]