Skip to content

Instantly share code, notes, and snippets.

View iarp's full-sized avatar

Ian R-P iarp

  • Toronto, Ontario, Canada
View GitHub Profile
@iarp
iarp / gist:6320284
Created August 23, 2013 14:56
Simple encrypt/decrypt functions.
<?php
function decryptRij($text) {
$salt = "my custom key";
return trim(mcrypt_decrypt(MCRYPT_RIJNDAEL_256, $salt, base64_decode($text), MCRYPT_MODE_ECB, mcrypt_create_iv(mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB), MCRYPT_RAND)));
}
function encryptRij($text) {
$salt = "my custom key";
return trim(base64_encode(mcrypt_encrypt(MCRYPT_RIJNDAEL_256, $salt, $text, MCRYPT_MODE_ECB, mcrypt_create_iv(mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB), MCRYPT_RAND))));
}
@iarp
iarp / adminer autologin
Last active January 27, 2022 15:39
A way to allow direct login to adminer
<?php
function adminer_object() {
class AdminerSoftware extends Adminer {
function credentials() {
# You don't need this if statement, but I added it because not having
# it skipped the login screen for everyone.
if ($_GET['username'] == 'username')
return array('127.0.0.1', 'username', 'password');
}
}
@iarp
iarp / EncDec.py
Last active December 23, 2015 18:29
Simpe rijndael encrypt with decrypt ability.
import base64
import rijndael
KEY_SIZE = 16
BLOCK_SIZE = 32
# I change this value, it needs to be a certain length of 16 or 32 characters in length if i remember correctly.
KEY = 'my custom key'
@iarp
iarp / php GM Decode
Last active June 10, 2017 12:10
PHP function that decodes GoldMine's log timestamp values
function Decode($strValueIn) {
$intX = 0;
$intY = 0;
$Temp = "";
$Mod = "";
$intMod =0;
$intTemp = 0;
$ValueOut = "";
$intY = 1;
$strValueOut="";
@iarp
iarp / QuoteCommaExport.vb
Last active June 29, 2016 15:56
Proper Excel CSV Export Macro
Sub QuoteCommaExport()
' Dimension all variables.
Dim DestFile As String
Dim FileNum As Integer
Dim ColumnCount As Long
Dim RowCount As Long
' Prompt user for destination file name.
DestFile = InputBox("Enter the destination filename" _
& Chr(10) & "(with complete path):", "Quote-Comma Exporter", "C:\temp\")
@iarp
iarp / mw-excel-mwtable.py
Created March 5, 2014 01:25
Convert Excel tables into MediaWiki formatted tables.
import os
# Open pasted-data.txt file, read the contents.
# You could potentially change this to reading the clipboard, and then writing the clipboard with the table.
with open('pasted-data.txt', 'r') as text:
data = text.readlines()
# If the first line is blank, remove it and set blank to True.<br /># If data[0] throws an error, we were passed nothing. Exit.
blank = None
try:
@iarp
iarp / gist:9a07561a3b79ed2c7c2e
Last active August 29, 2015 14:06
Backup all USER mysql databases into separate folders, file names are timestamped to the second. Tar the www directory for said database if it exists.
#! /bin/bash
TIMESTAMP=$(date +"%Y%m%d_%H%M%S")
BACKUP_DIR="/home/dev/backups"
MYSQL_USER="root"
MYSQL=/usr/bin/mysql
MYSQL_PASSWORD="password"
MYSQLDUMP=/usr/bin/mysqldump
mkdir -p "$BACKUP_DIR"
@iarp
iarp / CustomDjangoJSONSerializer.py
Last active June 21, 2017 22:13
I needed requests.session to store various datatypes int, float, and datetime. JSON by default does not do that, it converts everything to string and during load it leaves them as strings. This class takes the data and converts the various datatypes into strings (prepended by another string defining its type). During load, it reconverts the data…
import json
from django.contrib.sessions.serializers import BaseJSONSerializer
import traceback
import datetime
class CustomJSONSerializer:
"""
value type to string format
@iarp
iarp / logoff.bat
Created July 2, 2017 00:00
Disconnect RDP from a Windows machine, sending the system back to console so that LogMeIn Hamachi doesn't go offline.
# This script locks the server, disconnects you from the servers RDP session
# sending the session back to console so hamachi does not get disconnected
tscon 0 /dest:console
tscon 1 /dest:console
tscon 2 /dest:console
Rundll32.exe User32.dll,LockWorkStation
@iarp
iarp / ddwrt-delete-traffic.sh
Last active October 10, 2019 02:41
THIS IS AN OLD SCRIPT! I have not used it in many years as I haved moved onto pfSense. The purpose was to remove traffic information from my WRT54GL because the memory had filled up.
#!/bin/sh
# Delete traffic data leaving X number of months, includes current month
# If command line parameter is not provided then default to 1, which keeps current month only
if [ $1 -gt 0 ]; then i=$1; else i=1; fi
# Get current date in a format compatable with the date -d switch
d=`date +%Y.%m.%d-%H:%M`
# Loop back through the calendar X number of months
# each iteration lands at the last day of the previous month
while [ $i -gt 0 ]; do
d=$(date -D %s -d $(( $(date -d $d +%s)-( $(date -d $d +%d)*86400))) +%Y.%m.%d-%H:%M)