Skip to content

Instantly share code, notes, and snippets.

@varnav
varnav / adusers_weblist.php
Last active January 7, 2024 10:24
Web table listing active directory users
<!doctype html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>Список сотрудников</title>
<style>
a {text-decoration : none}
a:link {color : #000000}
@varnav
varnav / queryhhjobs.php
Last active December 22, 2016 16:07
Get amount of jobs with given salaries from hh.ru
#!/usr/bin/php
<?php
// Get amount of jobs with given salaries from hh.ru
// Add this to /etc/cron for every 2 hours check and record:
// 00 */2 * * * user /home/user/queryhhjobs.php >> /home/user/jobs.csv
// or use user-level crontab with "crontab -e"
function getjobcount($salary_from = -1)
; Disallow international with exceptions
exten => _9810800.,1,Goto(outbound-allroutes,${EXTEN},1) ; Toll free ok!
exten => _9810.,1,GotoIf($["${CALLERID(num)}" = "335"]?outbound-allroutes,${EXTEN},1) ; Allow 8-10
exten => _9810.,1,GotoIf($["${CALLERID(num)}" = "336"]?outbound-allroutes,${EXTEN},1) ; Allow 8-10
exten => _9810.,n,Playback(feature-not-avail-line) ; Disallow 8-10
exten => _9810.,n,Hangup()
exten => _900.,1,Playback(feature-not-avail-line) ; Disallow 00
exten => _900.,n,Hangup()
mkdir "c:\program files\zabbix\"
copy zabbix_agentd.conf "c:\program files\zabbix\"
copy zabbix_agentd.exe "c:\program files\zabbix\"
"c:\program files\zabbix\zabbix_agentd.exe" --config "c:\program files\zabbix\zabbix_agentd.conf" --install
"c:\program files\zabbix\zabbix_agentd.exe" --config "c:\program files\zabbix\zabbix_agentd.conf" --start
netsh advfirewall firewall add rule name="Zabbix agent" dir=in action=allow program="c:\program files\zabbix\zabbix_agentd.exe" profile=domain enable=yes
netsh advfirewall firewall add rule name="Zabbix agent" dir=in action=allow program="c:\program files\zabbix\zabbix_agentd.exe" profile=private enable=yes
function Get-WindowsKey {
## function to retrieve the Windows Product Key from any PC
## by Jakob Bindslet (jakob@bindslet.dk)
param ($targets = ".")
$hklm = 2147483650
$regPath = "Software\Microsoft\Windows NT\CurrentVersion"
$regValue = "DigitalProductId4"
Foreach ($target in $targets) {
$productKey = $null
$win32os = $null
@varnav
varnav / zabbix.cnf
Last active October 1, 2020 14:58
MariaDB 10.1 config file for Zabbix 3.0
# MariaDB 10.1 config file for Zabbix 3.0
#
# MariaDB programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, do:
# 'my_print_defaults --help' and see what is printed under
# Default options are read from the following files in the given order:
# More information at: http://dev.mysql.com/doc/mysql/en/option-files.html
#
#!/bin/sh
#
MyBackup="mysql.backup.`date +%Y.%m.%d.at.%H.%M.%S`.tbz"
MyBackup2="etcdir.backup.`date +%Y.%m.%d.at.%H.%M.%S`.tbz"
MyBackup3="wwwdir.backup.`date +%Y.%m.%d.at.%H.%M.%S`.tbz"
MyBackup4="varlib.backup.`date +%Y.%m.%d.at.%H.%M.%S`.tbz"
rm -f /astdb/backups/backup.sql
/usr/bin/mysqldump -udump -pdump --skip-add-drop-table --single-transaction --all-databases > /astdb/backups/backup.sql
cd /astdb/backups/
tar cjf $MyBackup backup.sql
[ $# -eq 0 ] && { echo "Usage: $0 username"; exit 1; }
if [ -d "/opt/clientconfig/$1/" ]; then
echo "Already exists"
exit 1
fi
cd /opt/client-ca
source vars
KEY_EXPIRE=183
./build-key $1
@varnav
varnav / slack_jenkins_build_trigger_proxy.php
Created July 18, 2016 15:46
Will receive web hook from slack and trigger build job at Jenkins
<?php
if (!($_REQUEST['token'] == '')) die('I`m afraid, Dave, I can`t do that.');
$jenkins_url = 'http://jenkins.local';
$job_name = str_replace($_REQUEST['trigger_word'].' ', '', $_REQUEST['text']);
$job_name = str_replace('/', '', $job_name); // Anti-injection
//$job_name = preg_replace('/[^A-Za-z0-9\-]/', '', $job_name); // Remove special chars
$url=$jenkins_url.'/job/'.$job_name.'/build';
@varnav
varnav / gist:20ecf935a2e109fe92ec98e14d2b4d49
Created August 26, 2016 11:03
Sipura/Linksys/Cisco SPA phones BLF line for FreePBX
To add BLF enter in Line Key -> Extended Function
fnc=blf+sd+cp;sub=123@$PROXY;ext=123@$PROXY
where 123 is number to watch.
No additional settings in recent FreePBX versions needed.