Skip to content

Instantly share code, notes, and snippets.

View skazhikadyadya's full-sized avatar
💭
For The Glory Of Satan!

skazhikadyadya

💭
For The Glory Of Satan!
View GitHub Profile
@skazhikadyadya
skazhikadyadya / gist:5c78f8cfffab22aa08a1b8c1146af1f6
Last active March 22, 2020 16:06
Random strings from DB #mysql
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
@skazhikadyadya
skazhikadyadya / EE-TO-CE_Downgrade
Last active March 22, 2020 16:05 — forked from ProxiBlue/EE-TO-CE_Downgrade
Downgrade script for magento EE to CE #magento
#!/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
#!/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
location ^~ /wp-content/ {
location ~ /wp-content/[^/]*\.php$ {
return 404;
}
location ~ /wp-content/uploads/.+\.php$ {
return 404;
}
}
@skazhikadyadya
skazhikadyadya / sanfrancisco-font.css
Created July 28, 2018 04:57
San Francisco Web Font
/** WARNING - USE AT OWN RISK */
/** IT IS AGAINST APPLE'S POLICY TO USE SF PRO FOR ANYTHING OTHER THAN iOS/tvOS/macOS/watchOS DESIGN & DEVELOPMENT */
/** https://sf.abarba.me/LICENSE.pdf */
/** 1. Copy/import this file into your main css/scss file */
/** 2. Change css font-family: to "SF Text", "SF Display" or "SF Mono" */
/** 3. Apply font-weight or italic to html elements */
/** THANK YOU */
/** I host these fonts on Cloudfront with SSL in all AWS regions for the best performance and reliability */
@skazhikadyadya
skazhikadyadya / media-query.css
Created June 14, 2019 12:34 — forked from gokulkrishh/media-query.css
CSS Media Queries for Desktop, Tablet, Mobile.
/*
##Device = Desktops
##Screen = 1281px to higher resolution desktops
*/
@media (min-width: 1281px) {
//CSS
@skazhikadyadya
skazhikadyadya / Mac Keyboard Symbols.md
Created June 21, 2019 01:37 — forked from Zenexer/Mac Keyboard Symbols.md
List of Mac/Apple keyboard symbols

Common symbols

Modifiers

When a key combination is displayed, the modifiers are written in the order presented here. For example, Control + Option + Shift + Command + Q would be written as ⌃⌥⇧⌘Q.

Sym Key Alt
Control
Option
@skazhikadyadya
skazhikadyadya / magento.stpl
Last active March 22, 2020 16:03 — forked from hidonet/magento.stpl
vestacp magento nginx template #vestacp #magento
# Template Updated At 2019-04-17
upstream php_backend_%domain_idn%_%web_ssl_port% {
server %backend_lsnr%;
#server %backend_lsnr% backup;
}
server {
listen %ip%:%web_ssl_port%;
server_name %domain_idn% %alias_idn%;
@skazhikadyadya
skazhikadyadya / modx_ace_material.txt
Last active March 22, 2020 16:03 — forked from agragregra/modx_ace_material.txt
MODx Ace Material Theme #modx
MODx Ace Material Theme
1. Системные настройки > Пространство имен "ace":
Размер шрифта: 13px
Высота области редактирования: 560
Невидимые символы: Да
Мягкая табуляция: Нет
Размер табуляции: 2
Тема редактора: tomorrow_night
@skazhikadyadya
skazhikadyadya / media-queries-b3.scss
Last active April 10, 2020 19:20 — forked from akolinski/media-queries-b3.scss
Media queries using SCSS in Bootstrap 3 @scss
// Using bootstrap the SASS way. Import your variables.
@import "bower_components/bootstrap-sass-official/assets/stylesheets/bootstrap/variables";
/* http://getbootstrap.com/css/#responsive-utilities */
/* Extra small devices (phones, less than 768px) */
/* No media query since this is the default in Bootstrap */
// Mobile first
body{
border: solid 4px red;