Mass rename database tables MySQL. Php-Script

Problem "one database - many sites" solved when use prefix in table names.

Drupal (and other CMS) provides settings to specify the database table prefix during the installation. This prefix after the installation set in /sites/default/settings.php - and if you are going to add or change the table names prefix, you need to correct file settings.php.

(The text is translated by Google Translate and corrected by tlito.)

CDNs made simple, fast & cheap - Murray Woodman

Difficulty level: 

If you test the speed of loading pages in loadimpact, pingdom, google pagespeed insignts, you may notice that the pictures, style files, Javascript are not loaded in parallel. This slows page loading and page displaying to the user's screen.
To speed up the loading of pages, you need to divide pictures, css files, JS files to CDN server. You can use subdomains of your site or third-party CDN servers.

Security of the Drupal site. Basic concepts + Video from Acquia How to Secure Drupal Sites That Cannot Fail

Difficulty level: 

Some aspects of network security for developers and website owners. Also video testimonials how to make a Drupal website safe (for a detailed discussion of methods).
The sites are of interest not only for their owners and visitors, but also for hackers who may have their own thoughts about why they need to hack sites. Drupal is one of the reliable systems of free engines in PHP. Vulnerabilities that may affect the performance of your website (if will be discovered by hackers and used, exploited) are in the following locations:

Optimizing images when creating nodes. Converting PNG to JPG in Drupal

Difficulty level: 

Disk usage sometimes requires optimization when the disk space is not cheap, but you have a lot of images. Basic function of image optimization is the option "Maximum image resolution" in the settings of field Image. Setting, say a maximum of 1200 by 1500 pixels, you will force Drupal to compress large images to this size.

But what if you want to convert PNG (which weigh 3-4 times larger than JPG) in JPG format? How to tune the compression feature pictures?

How to bypass copy protection on the site?

How do people can copy content from any good site if there is no right click menu or impossible to select text? If you do not want to violate the laws and regulations of the sites from which you just want to copy the text, you can use then the following advice. If you want to blatantly steal content, you don't need to use the next tip.

To disallow copying can be used, for example, a script like this:


Very simple way to add function private messages to your site. This module has no AJAX, but you can try to use it with Node.js or others.