arzzen

#! /bin/bash

newUser='testuser'
newDbPassword='testpwd'
newDb='testdb'
host=localhost
#host='%'
 
commands="CREATE DATABASE \`${newDb}\`;CREATE USER '${newUser}'@'${host}' IDENTIFIED BY '${newDbPassword}';GRANT USAGE ON *.* TO '${newUser}'@'${host}' IDENTIFIED BY '${newDbPassword}';GRANT ALL privileges ON \`${newDb}\`.*
TO '${newUser}'@'${host}';FLUSH PRIVILEGES;"

arzzen

#!/bin/sh# 

mysql -e "show variables; show status" | awk '  
{
VAR[$1]=$2  
}
END {  
MAX_CONN = VAR["max_connections"]  
MAX_USED_CONN = VAR["Max_used_connections"]  
BASE_MEM=VAR["key_buffer_size"] + VAR["query_cache_size"] + VAR["innodb_buffer_pool_size"] + VAR["innodb_additional_mem_pool_size"] + VAR["innodb_log_buffer_size"]  

arzzen

#! /bin/sh

paster() {
  while read email; do
    [ -z "$email" ] || echo "$1" "$email"
  done
}

grouper() {
  IFS="<"

arzzen

function commitsByWeekday() {
    optionPicked "Git commits by weekday:"
    echo -e "\tday\tsum"
    local counter=1
    for i in Mon Tue Wed Thu Fri Sat Sun
    do
        echo -en "\t$counter\t$i\t"
        git -c log.showSignature=false shortlog -n $_merges --format='%ad %s' \
            $_since $_until | grep "$i " | wc -l
        counter=$((counter+1)) 

arzzen

#!/bin/bash

LOGFILE="access.log"
LIMIT=10

while getopts l:f: option
do
    case "${option}"
    in
        l) LIMIT=${OPTARG};;

arzzen

#!/usr/bin/env bash

human_size() {
  awk -v sum="$1" 'BEGIN {
    hum[1024^3]="Gb"; 
    hum[1024^2]="Mb"; 
    hum[1024]="Kb"; 
    
    for (x=1024^3; x>=1024; x/=1024) { 
      if (sum>=x) { 

arzzen

var maxSecsRunning = 600;
var dryRun = true;

var currOp = db.currentOp();
for (var oper in currOp.inprog) {
    var op = currOp.inprog[oper-0];
    if (op.secs_running > maxSecsRunning && op.op == "command" ) {
        print("Killing opId: " + op.opid
            + " running for over secs: "
            + op.secs_running

arzzen

admin account info" filetype:log
!Host=*.* intext:enc_UserPassword=* ext:pcf
"# -FrontPage-" ext:pwd inurl:(service | authors | administrators | users) "# -FrontPage-" inurl:service.pwd
"AutoCreate=TRUE password=*"
"http://*:*@www” domainname
"index of/" "ws_ftp.ini" "parent directory"
"liveice configuration file" ext:cfg -site:sourceforge.net
"parent directory" +proftpdpasswd
Duclassified" -site:duware.com "DUware All Rights reserved"
duclassmate" -site:duware.com

arzzen

##
## How to install mcrypt in php7.2 / php7.3
## Linux / MacOS / OSX
##

## https://lukasmestan.com/install-mcrypt-extension-in-php7-2/



# 

arzzen

#!/bin/bash
dir=$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )

if [ "$1" != "" ]; then
	letter1=$(echo ${1,,}|cut -b1)
	if [[ $letter1 == [a-zA-Z0-9] ]]; then
		if [ -f "$dir/data/$letter1" ]; then
			cat "$dir/data/$letter1" | awk -F":" '{print $1"||"$2}' | grep -ai "$2$1$3"
		else
			letter2=$(echo ${1,,}|cut -b2)