Kate Kuznetsova kate-kate

## perl-replace
perl -i -pe 's/OLD/NEW/g;' *.html

## Last day of the month
strtotime('31.05.2014')===strtotime('00.06.2014')

## group by interval and campaign
SELECT FLOOR( call.created_at % ( 3600 *24 ) ) AS  `interval` , COUNT( * ) AS c, call.campaign_id, campaign.name
FROM  `call`
LEFT JOIN  `campaign` ON campaign.id = call.campaign_id
WHERE 1
GROUP BY  `interval` , campaign_id

## Best carousel
http://www.jqueryscript.net/slider/Lightweight-Responsive-jQuery-Slider-Plugin-Simple-Slideshow.html

## Перекрытие flash
<param name="wmode" value="opaque" />

## js animation platform
http://www.greensock.com/get-started-js/

## RegExp catalogue
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions?redirectlocale=en-US&redirectslug=JavaScript%2FGuide%2FRegular_Expressions#Using_Simple_Patterns

## Super RegExp for Shantui
public function actionFindTables()
	{
		$res = [];
		$text = file_get_contents('zl30.html', 'web');
		$rows = preg_split('/=+/', $text);
		foreach ($rows as $row) {
			list($title, $body) = preg_split('/-{5,}/', $row);
			$html = '<h1><br />' . $title . '<br /><br /></h1>';
			$html .= '<table border="1" cellspacing="0" cellpadding="4"><colgroup span="5" width="85">';
			$html .= '<thead><tr><td align="left" height="17">№</td><td align="left">Part No.</td>

## Dump with conditions
mysqldump -uroot -proot --where="column=val" dbName tableName > ~/result.sql

## Залить одну таблицу в базу
mysqldump -uroot -proot dbName < one_table.sql
или
mysql -uroot -proot
use dbName
source ~/one_table.sql
	SELECT FLOOR( call.created_at % ( 3600 24 ) ) AS `interval` , COUNT( ) AS c, call.campaign_id, campaign.name
	FROM `call`
	LEFT JOIN `campaign` ON campaign.id = call.campaign_id
	WHERE 1
	GROUP BY `interval` , campaign_id
	public function actionFindTables()
	{
	$res = [];
	$text = file_get_contents('zl30.html', 'web');
	$rows = preg_split('/=+/', $text);
	foreach ($rows as $row) {
	list($title, $body) = preg_split('/-{5,}/', $row);
	$html = '<h1><br />' . $title . '<br /><br /></h1>';
	$html .= '<table border="1" cellspacing="0" cellpadding="4"><colgroup span="5" width="85">';
	$html .= '<thead><tr><td align="left" height="17">№</td><td align="left">Part No.</td>
	mysqldump -uroot -proot dbName < one_table.sql
	или
	mysql -uroot -proot
	use dbName
	source ~/one_table.sql