Ripping Encrypted DVDs

Client wants his DVD published to his video streaming website. First I worked for a while with effmpeg, but kept getting errors. ffmpeg -i concat:VIDEO_TS.VOB\|VTS_01_0.VOB\|VTS_01_1.VOB -vcodec libxvid -q:v 5 -s 640×480 -aspect 640:480 -r 30 -g 300 -bf 2 -acodec libmp3lame -ab 160k -ar 32000 -async 32000 -ac 2 ~/Documents/Clients/Client/test.mp4 [ac3 @ 0x7fae3c027400] exponent 25 … Continued

sshfs requires libfuse.2.dylib error with iExplorer

iExplorer is a great app with which I can load my iPhone as an external disc. It was crashing after OSX upgrade with following issue: sshfs requires libfuse.2.dylib error with iExplorer. I was able to solve it by installing osxfuse. With homebrew: brew cask install osxfuse

Search all WordPress Database for String

Checking all wp_posts for a specific string: SELECT id, post_title, post_status, post_type, SUBSTR(post_content, LOCATE(‘your search string’, post_content) -1, 100) FROM wp_posts WHERE locate(‘your search string’, post_content) > 0

System Cron, Crontab, Cron Service, WordPress, Oh My

Client needs to automatically import data from a Google spreadsheet into a Custom Post Type. I wrote up a quick (largely borrowed) python script to convert to Google Spreadsheet to a CSV file with the desired headers. Found this pro plugin from Smackcoders called WP CSV Import Pro, which can run the CSV to CPT … Continued

Backing Up Trellis Site to AWS s3 Bucket

As a freshman in Roots.io University, I’m still flying by the seat of my pants. Backing up website database and files to Amazon s3 as Ben Word does seems like a more interesting approach than using a service like Updraft Plus, Jetpack or Infinite WP, so I’m giving it a go. Beginning with Ben’s configuration … Continued

Ansible Couldn’t Connect to the Database

Trellis, as of sometime in 2016, simplified the way users it generates the MySQL database and user: USER will be named example_com DATABASE will be named example_com_environment If you, as I had done, end up changing site name in one place or another you may get a message that Ansible couldn’t connect to the database, … Continued

Include a Font in a WordPress Shortcode

Our style sheet was making a call to @import url(‘https://fonts.googleapis.com/css?family=EB+Garamond:700′); for styling the typeface for a single shortcode generated banner. First tried just putting the @import statement between <style></style> tags, but this was ineffective. Fortunately Stack Overflow had a link to this awesome article by Stephen Scaff illustrating how to use Font Squirrel’s Webfont Generater … Continued

Google Circle
Join my Circle on Google+

Plugin by Social Author Bio