DZone Snippets: Shantanuo's Code Snippets

Compare Engines

shantanuo (shantanu oak) — Tue, 22 Jul 2008 05:47:46 GMT

// If you have 2 servers with identical database structure, and some of the tables have different engine type, then create a federated table to connect to the original server and compare the engines type with the current table's engine.



CREATE TABLE test.`TABLES2` (

`TABLE_CATALOG` varchar(512) default NULL,

`TABLE_SCHEMA` varchar(64) NOT NULL default '',

`TABLE_NAME` varchar(64) NOT NULL default '',

`TABLE_TYPE` varchar(64) NOT NULL default '',

`ENGINE` varchar(64) default NULL,

`VERSION` bigint(21) default NULL,

`ROW_FORMAT` varchar(10) default NULL,

`TABLE_ROWS` bigint(21) default NULL,

`AVG_ROW_LENGTH` bigint(21) default NULL,

`DATA_LENGTH` bigint(21) default NULL,

`MAX_DATA_LENGTH` bigint(21) default NULL,

`INDEX_LENGTH` bigint(21) default NULL,

`DATA_FREE` bigint(21) default NULL,

`AUTO_INCREMENT` bigint(21) default NULL,

`CREATE_TIME` datetime default NULL,

`UPDATE_TIME` datetime default NULL,

`CHECK_TIME` datetime default NULL,

`TABLE_COLLATION` varchar(64) default NULL,

`CHECKSUM` bigint(21) default NULL,

`CREATE_OPTIONS` varchar(255) default NULL,

`TABLE_COMMENT` varchar(80) NOT NULL default ''

)

ENGINE=FEDERATED DEFAULT CHARSET=latin1

CONNECTION='mysql://root@172.172.172.172/information_schema/TABLES';



SELECT b.TABLE_SCHEMA as remote_database, b.TABLE_NAME as remote_tableName, b.ENGINE as remote_engine, a.ENGINE AS local_engine 

FROM test.TABLES2 AS a INNER JOIN information_schema.TABLES as b 

ON a.TABLE_SCHEMA = b.TABLE_SCHEMA AND a.TABLE_NAME = b.TABLE_NAME AND a.ENGINE != b.ENGINE;

server monitoring

shantanuo (shantanu oak) — Sat, 07 Jun 2008 14:43:51 GMT

# servers.sh
export MAILSERVERS="server1 server2 server3"
export WEBSERVERS="www1 www2 www3 www4"

#!/bin/bash
### Assess disk space on mail servers
source ./servers.sh
for i in ${MAILSERVERS} ; do
echo =========${i} =============
ssh root@${i} "df"
echo ============ =============
done

# min hour dom month dow command

grep “###” *

Querystring variables

shantanuo (shantanu oak) — Sat, 05 Jan 2008 07:07:32 GMT



// Add Querystring Variable

// A PHP function that will add the querystring variable $key with a 

// value $value to $url. If $key is already specified within $url, 

// it will replace it.



function add_querystring_var($url, $key, $value) {

$url = preg_replace('/(.*)(\?|&)' . $key . '=[^&]+?(&)(.*)/i', '$1$2$4', $url . '&');

$url = substr($url, 0, -1);

if (strpos($url, '?') === false) {

return ($url . '?' . $key . '=' . $value);

} else {

return ($url . '&' . $key . '=' . $value);

}

}



// Remove Querystring Variable

// A PHP function that will remove the variable $key and its value 

// from the given $url.



function remove_querystring_var($url, $key) {

$url = preg_replace('/(.*)(\?|&)' . $key . '=[^&]+?(&)(.*)/i', '$1$2$4', $url . '&');

$url = substr($url, 0, -1);

return ($url);

}

delete empty directories

shantanuo (shantanu oak) — Thu, 08 Nov 2007 13:00:00 GMT



// commands to recursively delete empty directories below the current one

// (use at your own risk, as the slightest mistake WILL destroy 

// all of your data - Linux) 

find -depth -type d -empty -exec rmdir {} \;

Unicode words from online dictionary

shantanuo (shantanu oak) — Sun, 28 Oct 2007 08:55:52 GMT

// list words from unicode dictionary
// you need to add this line in the head section
//



for ( $i = 1; $i <= 45; $i++) {

$url="http://dsal.uchicago.edu/cgi-bin/romadict.pl?page=$i&table=molesworth&display=utf8";

$text=file_get_contents($url);

$myarray = preg_match_all('#(.*?)#i', $text, $matches);

echo implode(' ',$matches[1]); 

}

extract table names from sql log file

shantanuo (shantanu oak) — Fri, 12 Oct 2007 08:23:02 GMT



grep "from " /var/log/mysql/mysqld.log | awk -Ffrom '{print $2}' | awk '{print $1}' | cat > /home/shantanu/testing.txt

Password Protection

shantanuo (shantanu oak) — Thu, 04 Oct 2007 09:52:00 GMT

// Bare Bones demo of password protection



$password = "abc123";

if ($_POST[doddle] == $password) {

        $tell = 1;

} else {

        $tell = 2;

}

if (! is_string($_POST[doddle])) $tell = 0;

?>



A Page that is password protected





 

The page with all the secrets revealed 

 

This is the information that has been revealed to you because you

got the password right!

Although this is a very simple

demo it shows what you can do with just a few lines of PHP.

 



 

A Header page

 

There is a page hidden under a password at this URL. For this demo only

I will tell you that the password is "abc123" so you can try it out!


YOU GOT THE PASSWORD WRONG
"); ?>






Please enter password 





 



 



Well House Consultants, 2007

tinyurl explode

shantanuo (shantanu oak) — Tue, 02 Oct 2007 08:03:51 GMT

// check where tinyurl.com is headed to



    < ?php



    // tinyurl.php?c=



    $num = $_GET['c'];



    if($fp = fsockopen ("tinyurl.com", 80, $errno, $errstr, 30))

    {

    if ($fp) {

    fputs ($fp, "HEAD /$num HTTP/1.0\r\nHost: tinyurl.com\r\n\r\n");

    while (!feof($fp)) {$headers .= fgets ($fp,128);}

    fclose ($fp);

    }

    $arr1=explode("Location:",$headers);

    $arr=explode("\n",trim($arr1[1]));

    echo trim($arr[0]);

    }

    ?>

mysql dump to another server

shantanuo (shantanu oak) — Tue, 02 Oct 2007 07:57:05 GMT

// Using UNIX pipe concept one can dump database to another server securely using ssh protocol.
// All you need remote execution rights for the ‘dd’ command, over SSH.



mysqldump -u USERnAME -p'PASSWORD' YOUR-DATABASE-NAME | ssh user@remote.server.com "dd of=/mysql/$(date +'%d-%m-%y')"

email addresses using egrep

shantanuo (shantanu oak) — Fri, 28 Sep 2007 03:19:19 GMT

// email addresses



egrep "\w+([._-]\w)*@\w+([._-]\w)*\.\w{2,4}"