| SELECT * FROM wp_posts p | |
| LEFT JOIN wp_term_relationships tr ON tr.object_id = p.ID | |
| LEFT JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id | |
| LEFT JOIN wp_terms t ON t.term_id = tt.term_id |
| SET @uri_from = 'www.devurl.local'; | |
| SET @uri_to = 'www.liveurl.net'; | |
| UPDATE wp_options SET `option_value` = REPLACE(`option_value`, @uri_from, @uri_to) | |
| WHERE `option_value` LIKE CONCAT( "%", @uri_from, "%" ); | |
| UPDATE wp_posts SET `guid` = REPLACE(`guid`, @uri_from, @uri_to); | |
| UPDATE wp_posts SET `post_content` = REPLACE(`post_content`, @uri_from, @uri_to); | |
| git init && git config receive.denyCurrentBranch ignore |
| (S) = Seen | |
| (M) = Met | |
| # Soho | |
| (S) Jerry Springer | |
| (S) Kyly Minogue | |
| (S) Neil Morrissy | |
| (S) Rod Stuart | |
| (S) Lennie Henry | |
| (S) Jack Whitehall x2 |
Right click Chrome "Omnibar" and go to Edit Search Engines
Add https://www.google.co.uk/search?tbm=isch&tbs=itp:animated&q=%s and call it a keyword like Gif Search and make sure its added to "Default Search Engines"
Type gif then tab then your search terms
| rsync -avz pi@192.168.1.117:/home/pi/mnt/ ~/Desktop/stills/ && find . -name '*.jpg' -size 0 -print0 | xargs -0 rm && ls *.jpg > stills.txt && mencoder -nosound -ovc lavc -lavcopts vcodec=mpeg4:aspect=16/9:vbitrate=8000000 -vf scale=1080:768 -o ~/Desktop/tl_london1.avi -mf type=jpeg:fps=48 mf://@stills.txt && mplayer ../tl_london1.avi |
| avconv -i input.mp4 -f image2 frames/f_%00d.jpg | |
| for F in $(ls frames/) | |
| do | |
| composite -compose atop -gravity SouthWest overlay_frame.png frames/$F out/$F | |
| done | |
| avconv -f image2 -i out/f_%00d.jpg out.mpeg -b 2400kb |
| #include <SPI.h> | |
| #include <Ethernet.h> | |
| #include <PusherClient.h> | |
| byte mac[] = { | |
| 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED }; | |
| PusherClient client; | |
| IPAddress ip(192,168,1,101); | |
| const int parrot = 3; |
| // See http://www.fanjita.org/serendipity/archives/53-Interfacing-with-radio-controlled-mains-sockets-part-2.html | |
| #define PAYLOAD_SIZE 48 | |
| #define DATA_PIN A4 | |
| #define VCC_PIN A5 | |
| #define GND_PIN A3 | |
| #define LED_PIN 13 | |
| #define CHANNEL 1 | |
| #define TURNON 1 |
