henno

delete from ticketlines;
delete from ticketlines;
delete from tickets;
delete from taxlines;
delete from payments;
delete from stockdiary;
delete from stockcurrent;
delete from reservation_customers;
delete from reservations;
delete from receipts;

henno

#
# cat /etc/nginx/sites-enabled/projects.example.com
#

# Define variable $topdir (top level directory name)
map $request_uri $topdir {
	~(?<captured_topdir>^/[a-zA-Z0-9]+)[/] $captured_topdir;
}

server {

henno

#!/bin/sh
# Execute this on your local development machine
ssh -R 9000:localhost:9000 virt50123@mylivesite.com

henno

$Users = Import-Csv -Delimiter ";" -Path "C:\Users\Administrator\Desktop\users.csv"            
foreach ($User in $Users)            
{            
    $Displayname = $User.'Firstname' + " " + $User.'Lastname'            
    $UserFirstname = $User.'Firstname'            
    $UserLastname = $User.'Lastname'            
    $OU = $User.'OU'            
    $SAM = $User.'SAM'            
    $UPN = $User.'Firstname' + "." + $User.'Lastname' + "@" + $User.'Maildomain'            
    $Password = $User.'Password'            

henno

1. Export new (renewed) Let's Encrypt certificate from \Certificates (Local Computer)\Web Hosting\Certificates to a file
2. Import the certificate from file to \Certificates (Local Computer)\Personal
3. Execute C:\> netsh http show sslcert and copy the certificate hash of the binding that uses a certificate from WebHosting store
4. Execute C:\>Netsh ras set sstp-ssl-cert hash=xxxxxxxxxxxxxxx
5. Restart RRAS service

henno

http://www.catalog.update.microsoft.com/search.aspx?q=kb2952664

henno

#!/usr/bin/env bash
# This file can do one of two things:
#    - reset a MySQL database back to original state from a dump file at given location and
#    - create a new dump file from the current contents of given MySQL database
#
# Usage for resetting a database from dump:
#
#  refresh_database.sh yourdatabasename
#
#

henno

# Mikrotik config derived from the default factory config
# Features:
# - Ether1 is for Internet (WAN) and has DHCP client enabled
# - Ether 2-5 and wlan1 and wlan2 are in a bridge called bridge
# - This bridge has a DHCP server activated serving IPs from $myLanSubnet.10-$myLanSubnet.254
# - Wireless is set up with $mySSID using WPA2 and Sinimustvalge
# - Custom admin user tvv with klaabu is set to protect against hacking
# - Get an email when a user breaks the Internet by connecting his router's WAN port to your LAN
#

henno

xdebug.remote_enable=1
xdebug.remote_host=localhost
xdebug.remote_port=9000
xdebug.remote_autostart=1

; with sane limits
xdebug.var_display_max_depth = 10
xdebug.var_display_max_children = 512
xdebug.var_display_max_data = 1024 

henno

@echo off

SET DUMP_FILE_LOCATION=doc\database.sql
SET MYSQL=c:\xampp\mysql\bin\mysql.exe
SET MYSQLDUMP=c:\xampp\mysql\bin\mysqldump.exe
IF "%1"=="" GOTO ERROR
SET DATABASE_NAME="%1"
IF "%2"=="--dump" GOTO :DUMP