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 stmt;
DEALLOCATE PREPARE stmt;
[/php]

also this is the db structure may help any

[php]
DROP TABLE IF EXISTS `post`;
CREATE TABLE IF NOT EXISTS `post` (
`id` int(11) DEFAULT NULL,
`name` varchar(10) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL,
`order` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `post` (`id`, `name`, `type`, `order`) VALUES
(1, ‘product1’, ‘first product’, 5),
(2, ‘product2’, ‘second product’, 5);

DROP TABLE IF EXISTS `post_meta`;
CREATE TABLE IF NOT EXISTS `post_meta` (
`post_id` int(11) DEFAULT NULL,
`meta_name` varchar(10) DEFAULT NULL,
`meta_value` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `post_meta` (`post_id`, `meta_name`, `meta_value`) VALUES
(1, ‘size’, ‘\’\’\”),
(1, ‘height’, ‘103’),
(2, ‘size’, ‘L’),
(2, ‘title’, ’13’),
(2, ‘color’, ‘????’);
[/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, 2010 July 6th, 2010 July 6th, 2010 July 6th, 2010 July 6th, 2010 July 6th, 2010
. Review by Nicolas Mollet Nicolas Mollet Nicolas Mollet Nicolas Mollet Nicolas Mollet Nicolas Mollet
. Plugin last update July 3rd, 2010 June 30th, 2010 July 1st, 2010 June 11th, 2010 July 4th, 2010 July 4th, 2010
. License Free Free Free Free Free Premium Free
. Post types Yes Yes Yes Yes Yes Yes
. Taxonomies Yes Yes Yes Yes Yes Yes
. Fields / Meta boxes Yes No No No No No
.
. Post types options
. Permalinks Yes Yes Yes Yes Yes Yes
. Admin UI Columns configuration Yes No No No No No
. Permissions Yes No No No Yes Yes
. Include in search Yes Yes Yes Yes Yes Yes
. Admin UI labels configuration Yes Yes No No Yes Yes
. Default boxes configuration (excerpt, author,…) Yes Yes Yes Yes Yes Yes
. Export post type configuration Yes No No No No No
. Import post type configuration Yes No No No No No
. Generate function No No No No No Yes
.
. Taxonomies options
. Share taxo with other post types Yes Yes No Yes Yes Yes
. Categories (hierarchical) Yes Yes Yes Yes Yes Yes
. Tags (non-hierarchical) Yes Yes Yes Yes Yes Yes
. Generate function No No No No No Yes
.
. Fields / Meta boxes options
. Multiple boxes No No No No No No
. Upload field No No No No No No
. Select field Yes No No No No No
. Date field Yes No No No No No
. Text field 1 line Yes No No No No No
. Text field multilines Yes No No No No No
. Html editor field No No No No No No
. Share boxes with other post types No No No No No No
. Template function get_post_meta Yes No No No No No
.
. Fields / Meta boxes plugins compatibility
. Magic Fields No No No No No No
. More Fields No No No No No No
. Verve Meta Boxes No Yes Yes Yes Yes Yes
. Simple Fields (dropdown buggy) Yes Yes Yes Yes Yes Yes
. Custom Field Template No Yes Yes Yes Yes Yes
.
. Opinion
. Ranking by Nicolas Mollet 5 1 3 2 4

 

 

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 give more memory for self-join, and more rows will fit into working buffers).

If table B is not the same, then it is impossible to compare.

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.

My passion for software development has lead me in to the the field of large scale, enterprise development projects, specialising in high quality, high capacity, and high availability software.
While I have traditionally been designing or building ‘back end’ projects, I have recently taken on a full spectrum project, involving everything from system adminstration to interfacing with external services, and cutting up the design in Photoshop. Versatility is important since the luxury of starting a project from the very beginning is not always possible.

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 is the key to faster pages.

One way to reduce the number of components in the page is to simplify the page’s design. But is there a way to build pages with richer content while also achieving fast response times? Here are some techniques for reducing the number of HTTP requests, while still supporting rich page designs.

Continue reading “Best Practices for Speeding Up Your Web Site”