skazhikadyadya

#!/bin/sh
mkdir -p ~/.vim/syntax/
cd ~/.vim/syntax/
wget http://www.vim.org/scripts/download_script.php?src_id=19394
mv download_script.php\?src_id\=19394 nginx.vim
cat > ~/.vim/filetype.vim <<EOF
au BufRead,BufNewFile /etc/nginx/*,/usr/local/nginx/conf/* if &ft == '' | setfiletype nginx | endif
EOF

skazhikadyadya

#!/bin/bash

#first param = db user, second param = db name 

rm -rf app/code/core/Enterprise
rm -rf downloader/template/enterprise
rm -rf app/design/install/default/enterprise
rm -rf app/design/frontend/enterprise
rm -rf app/design/adminhtml/default/default/layout/enterprise  
rm -rf app/design/adminhtml/default/default/template/enterprise

skazhikadyadya

SELECT * FROM table AS r1
JOIN (SELECT (RAND()*(SELECT MAX(id)-MIN(id) FROM table) +
(SELECT MIN(id) FROM table)) AS id) AS r2
WHERE r1.id >= r2.id ORDER BY r1.id ASC LIMIT 300