Skip to content

Instantly share code, notes, and snippets.

View greenpeas's full-sized avatar

Артёмов Антон greenpeas

View GitHub Profile
@greenpeas
greenpeas / rsagen
Last active August 29, 2015 13:55
Скрипт для генерации ключей и сертификатов OpenVPN
#!/bin/bash
cd /usr/share/easy-rsa/
echo "Введите название клиента латинскими буквами:"
read CLIENTNAME
. ./vars
@greenpeas
greenpeas / del_site.sh
Last active August 29, 2015 13:56
Удаление сайта с сервера
#!/bin/sh
# MySQL root password
ROOTPASS='Пароль рута БД'
###############
echo "Введите имя пользователя сервера, сайт которого будем удалять:"
read USERNAME
@greenpeas
greenpeas / sqldataprovider.php
Last active August 29, 2015 13:56
CSqlDataProvider with sort and pagination
<?php
$sql = "SELECT
`p`.`id`,
getFIOWithInic(`p`.`id`,0) AS `fio`,
`p`.`number` AS `tabel`,
`rpt`.`name_short` AS `type_name`,
`rpc`.`name` AS `cat_name`,
DATE_FORMAT(`p`.`date_start_work`,'%d.%m.%Y') AS `date_start_work`,
`p`.`is_deleted`,
@greenpeas
greenpeas / pdo.php
Created February 25, 2014 06:21
PDO query
<?php
$items = Yii::app()->db->createCommand()
->select(array(
"t.id",
"DATE_FORMAT(`t`.`date_start`,'%d.%m.%Y') AS `date`",
//"DATE_FORMAT(`t`.`date_start`,'%H:%i') AS `time_start`",
//"DATE_FORMAT(`t`.`date_stop`,'%H:%i') AS `time_stop`",
"tr.number AS tr_number",
"s.output",
@greenpeas
greenpeas / db_remote_backup
Last active August 29, 2015 14:04
Резервное копирование нескольких БД
#!/bin/sh
DATE=`date +%Y-%m-%d_%H-%M-%S`
DIR=~/backups/
DB_USER=root
DB_PASS='********'
DB_HOST=localhost
REMOTE_STORAGE_HOST=***.***.244.225
REMOTE_STORAGE_USER=backups
KEY_PATH=~/.ssh/id_rsa
@greenpeas
greenpeas / atomic_install
Created July 18, 2014 07:20
Install atomic
wget -q -O - http://www.atomicorp.com/installers/atomic | sh
yum clean all
rpm --import https://www.atomicorp.com/RPM-GPG-KEY.atomicorp.txt
yum reinstall atomic-release -y
@greenpeas
greenpeas / mssql in php
Created July 22, 2014 18:04
работа с ms sql в php
<?php
$server = '88.xxx.xxx.xxx\SQLEXPRESS';
$link = mssql_connect($server, 'db_username', 'db_password');
if (!$link) {
die('Something went wrong while connecting to MSSQL');
}
mssql_select_db('database_name', $link);
$query_result = mssql_query('SELECT * FROM MenuItems');
@greenpeas
greenpeas / my_iptables_config
Created October 9, 2014 19:47
My iptables config
# Generated by iptables-save v1.3.5 on Wed Jan 23 15:43:00 2013
*nat
:PREROUTING ACCEPT [39:5343]
:POSTROUTING ACCEPT [2:120]
:OUTPUT ACCEPT [3:196]
-A POSTROUTING -o venet0 -j MASQUERADE
COMMIT
# Completed on Wed Jan 23 15:43:00 2013
# Generated by iptables-save v1.3.5 on Wed Jan 23 15:43:00 2013
*filter
@greenpeas
greenpeas / fos_chunk
Created November 2, 2014 19:08
FOS chunk
[[!FormIt?
&hooks=`groupSelector,recaptcha,spam,email,redirect`
&emailTpl=`sentEmailTpl`
&emailSubject=`Сообщение с stav-chip.ru`
&emailTo=`[[+emailAddresses]]`
&emailFrom=`[[+contact_email]]`
&emailSubject = `Сообщение с сайта stav-chip.ru`
&emailFromName = `СтавЧип`
&validate=`contact_name:required,
contact_email:email:required,
@greenpeas
greenpeas / pgsoultgen
Created January 13, 2015 08:49
Генератор пароля и соли
<?php
// Генерируем соль
$salt = '$2a$10$'.substr(str_replace('+', '.', base64_encode(pack('N4', mt_rand(), mt_rand(), mt_rand(),mt_rand()))), 0, 22) . '$';
// Шифруем пароль с применением данной соли
$hashed_password = crypt($password, $salt);