Skip to content

Instantly share code, notes, and snippets.

Karl Bunch karlbunch

Block or report user

Report or block karlbunch

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@karlbunch
karlbunch / user-data.txt
Created Oct 6, 2017 — forked from heri16/user-data.txt
Docker-CE Cloud-init for Ubuntu 16.04 (LTS)
View user-data.txt
#cloud-config
# Upgrade the instance on first boot
# (ie run apt-get upgrade)
#
# Default: false
# Aliases: apt_upgrade
package_upgrade: true
# Install additional packages on first boot
@karlbunch
karlbunch / boot-from-ram-debian.md
Created Sep 10, 2017 — forked from avinash-oza/boot-from-ram-debian.md
How to boot from RAM on debian
View boot-from-ram-debian.md
View resize.sh
#!/bin/bash
#
# resize - cheap bash implementation of the X11 resize command to avoid installing all the X11 stuff for one command
#
# Author: Karl Bunch <karlbunch@karlbunch.com>
#
# Created: Sat Sep 2 08:30:14 EDT 2017
#
if [ "X$1" = "X-s" -a -n "$2" -a -n "$3" ]; then
echo -ne "\033[8;$2;$3t"
View keybase.md

Keybase proof

I hereby claim:

  • I am karlbunch on github.
  • I am karlbunch (https://keybase.io/karlbunch) on keybase.
  • I have a public key ASCoSLZN0yITsCEVolBDol4-YvF8Ht6j74H1MsBZtyBJTQo

To claim this, I am signing this object:

View keybase.md

Keybase proof

I hereby claim:

  • I am karlbunch on github.
  • I am karlbunch (https://keybase.io/karlbunch) on keybase.
  • I have a public key ASAigm7tkOrtPXPAmmw06cITx2iGPZymQpZNqTaYsGUcYAo

To claim this, I am signing this object:

View characters_335a_to_434_convert_currency.sql
-- BEGIN CURRENCY CONVERSION
-- Convert character tokens/currencies from 3.x to 4.x
-- http://web.archive.org/web/20100918101232/http://forums.worldofwarcraft.com/thread.html?topicId=26850245012&sid=1&pageNo=10
SET @HONOR_RATE = 0.024;
SET @ARENA_RATE = 0.85;
SET @HONOR_HARDCAP = 4000;
SET @HONOR_TO_MONEY = 35;
SET @JUSTICE_HARDCAP = 4000;
SET @JUSTICE_TO_MONEY = 20000;
SET @MAX_MONEY_AMOUNT = 9999999999;
View characters_335a_to_434_convert_currency.sql
-- BEGIN CURRENCY CONVERSION
-- Convert character tokens/currencies from 3.x to 4.x
-- http://web.archive.org/web/20100918101232/http://forums.worldofwarcraft.com/thread.html?topicId=26850245012&sid=1&pageNo=10
SET @HONOR_RATE = 0.024;
SET @ARENA_RATE = 0.85;
SET @HONOR_HARDCAP = 4000;
SET @HONOR_TO_MONEY = 35;
SET @JUSTICE_HARDCAP = 4000;
SET @JUSTICE_TO_MONEY = 20000;
SET @MAX_MONEY_AMOUNT = 9999999999;
View characters_335a_to_434_convert_currency.sql
-- Convert character tokens/currencies from 3.x to 4.x
-- http://web.archive.org/web/20100918101232/http://forums.worldofwarcraft.com/thread.html?topicId=26850245012&sid=1&pageNo=10
SET @HONOR_RATE = 0.024;
SET @ARENA_RATE = 0.85;
SET @HONOR_HARDCAP = 4000;
SET @HONOR_TO_MONEY = 35;
SET @JUSTICE_HARDCAP = 4000;
SET @JUSTICE_TO_MONEY = 20000;
SET @MAX_MONEY_AMOUNT = 9999999999;
DROP TABLE IF EXISTS temp_token_to_money
View characters_335a_to_434_convert_currency.sql
-- Convert character tokens/currencies from 3.x to 4.x
-- http://web.archive.org/web/20100918101232/http://forums.worldofwarcraft.com/thread.html?topicId=26850245012&sid=1&pageNo=10
SET @HONOR_RATE = 0.024;
SET @ARENA_RATE = 0.85;
SET @HONOR_HARDCAP = 4000;
SET @HONOR_TO_MONEY = 35;
SET @JUSTICE_HARDCAP = 4000;
SET @JUSTICE_TO_MONEY = 20000;
SET @MAX_MONEY_AMOUNT = 9999999999;
DROP TABLE IF EXISTS temp_token_to_money
View run.txt
[KARL]:3.3.5> time mysql < ~/WKA/TrinityCore_434/characters-aokromes.sql
real 9m45.036s
user 0m44.295s
sys 0m2.437s
[KARL]:3.3.5> time mysql aokromes < 2017_03_19_characters.sql
Currency Fix Status:
SUCCESS: All currency tokens where properly placed in hidden slots 118-150.
real 0m26.844s
You can’t perform that action at this time.