Author: Mohamed Sharaf

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

  • Delete Orphaned Post Meta Data in WordPress

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

  • 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

  • sdzfsd

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