el22or

Gist tips

Search

Search gist for keyword and by specific user

git user:el22or

☛git user:el22or

kloneets

#!/bin/bash

# Take a screenshot of an area of the screen, upload it to dropbox and put the url into the clipboard

# Put file in any directory under your dropbox
# If it is subfolder, than you need to make them manually
FILENAME=~/Dropbox/Public/Screenshots/Screenshot_`date +%Y-%m-%d-%H:%M`.png

# Select an area and save the screenshot
# you need to instal gnome-screenshot

addyosmani

CSS Layout Debugger

A tweet-sized debugger for visualizing your CSS layouts. Outlines every DOM element on your page a random (valid) CSS hex color.

One-line version to paste in your DevTools

Use $$ if your browser aliases it:

~ 108 byte version

el22or

ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEA9k/2nrH/FwFhclJJ0xgzaQr9H0KaxVW5kHgWEyhYCSDcflLVTU4D4Qfo5SPB2cGmcAw+c4MluEzH7Udj7KuWyKdIOKMj+tv8Arr0ufgV3NwsxassTeeTWzgPu635xz7j46JC0wXLG4nA1nzPZIKSKvPulCnwskkzo0lwaE3dHmA4t3yEL6fqn/sOZdjpUT1BSK0cASv+R74A38wS9IJNvC4EJiqruaaF6jgKDVUuyoX5aKeeDYC5FAQOBvMuPBgD6TJa4+CvMQlwS8Qqcy9cgTlx7TOcMlUrLz4OLMh8riYJm+JuK8nNAkRPrxX+LJVBz4XOyV3MasVx5aI9cLENEQ== [email protected]

el22or

## SSH - Remote export > local import
ssh USER@HOST mysqldump -uREMOTEDATABASEUSER -pREMOTEDATABASEPASSWORD -hREMOTEHOST REMOTEDATABASENAME | mysql -uLOCALDATABASEUSER -pLOCALDATABASEPASSWORD LOCALDATABASENAME

## Export to CSV
mysql -uUSER -pPASS DATABASENAME -B -e "select * from \`korisnici\`;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > filename.csv

## Export to CSV 2
mysql -uUSER -pPASS DATABASE -B -e "SELECT users.uid AS 'ID', users.name AS 'Username', users.mail AS 'Email', from_unixtime(users.created) AS 'Created', from_unixtime(users.login) AS 'Last login' FROM users WHERE users.status=1 AND users.login!=0 ORDER BY users.login DESC;" | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > vehicle_categories.csv

## Export to SQL gzipped file with compression

dypsilon

Frontend Development

Attention: the list was moved to

https://github.com/dypsilon/frontend-dev-bookmarks

This page is not maintained anymore, please update your bookmarks.

---