Grand Manitou grandmanitou
grandmanitou
/ gist:7993601
Created
December 16, 2013 20:15
Dump all databases from mysql - one file per database - then compress to zip
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysql -s -r -uadmin -p`cat /etc/psa/.psa.shadow` -e 'show databases' | while read db; do mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` $db -r ${db}.sql; [[ $? -eq 0 ]] && zip ${db}.zip ${db}.sql -r9; done |
grandmanitou
/ gist:7993667
Last active
December 31, 2015 13:29
Log into MySQL with root / admin account via command line
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # classic connection | |
| mysql -uadmin -p`cat /etc/psa/.psa.shadow` | |
| # classic dump | |
| mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` viacombi_eu_forum > viacombi_eu_forum.sql |
grandmanitou
/ gist:7994542
Created
December 16, 2013 21:13
Upload recursively a wholde directory structure to a remote FTP server via command line.
Requires lftp
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| lftp ftp://user:password@domain.ltd -e "mirror -e -R /local/folder /remote/folder ; quit" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| find . -name '*.DS_Store' -type f -delete |
grandmanitou
/ gist:8521246
Created
January 20, 2014 14:57
PHP convert numbers to capital letters (useful to create excel tables)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function num2alpha($n) { | |
| $r = ''; | |
| for ($i = 1; $n >= 0 && $i < 10; $i++) { | |
| $r = chr(0x41 + ($n % pow(26, $i) / pow(26, $i - 1))) . $r; | |
| $n -= pow(26, $i); | |
| } | |
| return $r; | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| public function beforeRender() { | |
| // Enable HABTM validation | |
| $model = Inflector::singularize($this->name); | |
| foreach($this->{$model}->hasAndBelongsToMany as $k=>$v) { | |
| if(isset($this->{$model}->validationErrors[$k])) | |
| { | |
| $this->{$model}->{$k}->validationErrors[$k] = $this->{$model}->validationErrors[$k]; | |
| } | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function highlight($text, $words) { | |
| preg_match_all('~\w+~', $words, $m); | |
| if(!$m) | |
| return $text; | |
| $re = '~\\b(' . implode('|', $m[0]) . ')\\b~'; | |
| return preg_replace($re, '<b>$0</b>', $text); | |
| } | |
| $text = ' | |
| Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod |
grandmanitou
/ gist:8859378
Created
February 7, 2014 09:02
Cakephp 2.x validation of french phone number
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Validation rules | |
| * | |
| * @var array | |
| */ | |
| public $validate = array( | |
| 'phone_number_1' => array( | |
| 'notEmpty' => array( | |
| 'rule' => array('notEmpty'), |
grandmanitou
/ gist:8859900
Created
February 7, 2014 09:51
Convert first page of PDF to JPG using ImageMagick through command line
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| convert source.pdf[0] output.jpeg |
grandmanitou
/ gist:8863248
Created
February 7, 2014 14:10
Place multiple markers with infowindow on Google Maps API v3, use external links to trigger click and center map on desired location.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?language=fra&sensor=false"></script> | |
| <script type="text/javascript"> | |
| var map; | |
| var Markers = {}; | |
| var infowindow; | |
| var locations = [ | |
| [ | |
| 'Samsung Store Madeleine', | |
| '<strong>Samsung Store Madeleine</strong><p>5 Boulevard Malesherbes, 75008 Paris<br>10h – 20h</p>', | |
| 48.8701925, |
OlderNewer