Monthly Archives: August 2015

Change all mysql db tables and sub tables collation to utf8

SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') AS mySQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= "myschema" AND TAB...

Fastest way to get 1 random post in WordPress

So all you need is simply 1 random post, 1 random post->ID or 1 post link, you dont need to go through all the hoops. (Update: added $wpdb function to tests) Jump to conclusion ...

memcached port and csf

Actually, you do not want to open memcached port in your firewall. #ref: http://serverfault.com/questions/530051/memcached-ports-and-csf...

nstest

Change all users Cpanel theme to paper lantern from WHM

Go to: Multi Account Functions » Modify/Upgrade Multiple Accounts There is no “check all” box so, do a quick search for “x3” and “select matching user...

Loading an array from file into a variable

Ways to load an array from file into a variable: 1- $var = require 'myarray.php'; // or include // myarray.php contents return array("test","test2"); 2 – require 'myarray.php...