Skip to content

Instantly share code, notes, and snippets.

View karlbunch's full-sized avatar

Karl Bunch karlbunch

23 followers · 11 following
View GitHub Profile
@karlbunch
karlbunch / characters_335a_to_434_convert_currency.sql
Created March 22, 2017 12:02
-- 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;
@karlbunch
karlbunch / characters_335a_to_434_convert_currency.sql
Created March 22, 2017 12:02
-- 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;
@karlbunch
karlbunch / characters_335a_to_434_convert_currency.sql
Created March 21, 2017 11:30
-- 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
@karlbunch
karlbunch / characters_335a_to_434_convert_currency.sql
Created March 21, 2017 11:30
-- 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
@karlbunch
karlbunch / run.txt
Created March 19, 2017 21:09
[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
@karlbunch
karlbunch / 2017_03_19_characters.sql
Created March 19, 2017 21:00
-- BEGIN CURRENCY TOKEN FIXUP
DROP TABLE IF EXISTS temp_currency_items;
CREATE TEMPORARY TABLE temp_currency_items (itemEntry mediumint(8) unsigned);
INSERT INTO temp_currency_items VALUES
-- Add any currency items that need conversion to this list...
(20558),(20559),(20560),(29024),(29434),(37836),(40752),(40753),(41596),(42425),(43016),(43228),(43308),(43589),(44990),(45624),(47395),(47241),(49426),(43949),(41749),(38644),(37742),(37711)
;
DROP FUNCTION IF EXISTS temp_check_currency;
DROP PROCEDURE IF EXISTS temp_currency_item_report;
DROP PROCEDURE IF EXISTS temp_fix_currency;
@karlbunch
karlbunch / screenlog.0
Created March 12, 2017 21:18
wow@tcemu:~/server/bin$ mysql -e 'drop database hotfixes'; mysql -e 'drop database characters'; mysql -e 'drop database world'; mysql -e 'drop database auth'
ERROR 1008 (HY000) at line 1: Can't drop database 'hotfixes'; database doesn't exist
wow@tcemu:~/server/bin$ ./worldserver
TrinityCore rev. 4164d8998069 2017-03-12 14:19:51 +0100 (4.3.4 branch) (Unix, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
@karlbunch
karlbunch / -
Created March 12, 2017 20:59
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 13ffa96..90c5690 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2814,7 +2814,7 @@ CREATE TABLE `updates` (
LOCK TABLES `updates` WRITE;
/*!40000 ALTER TABLE `updates` DISABLE KEYS */;
-INSERT INTO `updates` VALUES ('2014_10_28_00_characters.sql','DCC0367E2784919FBE6ED44D60057179','ARCHIVED','2014-10-28 21:00:00',0),('2015_03_20_00_characters.sql','B761760804EA73BD297F296C5C1919687DF7191C','ARCHIVED','2015-03-21 21:44:15',0),('2015_03_20_01_characters.sql','894F08B70449A5481FFAF394EE5571D7FC4D8A3A','ARCHIVED','2015-03-21 21:44:15',0),('2015_03_20_02_characters.sql','97D7BE0CAADC79F3F11B9FD296B8C6CD40FE593B','ARCHIVED','2015-03-21 21:44:51',0),('2015_06_26_00_characters_335.sql','f8230a59a9e878a6f54f421d6621f1595bd93861','ARCHIVED','2015-03-21 21:44:51',0),('2016_01_11_00_characters_from_335.sql','AAECE4BA6FDCF0C34A57FADD11DB68DAFD8AE9CD','ARCHIVED','2016-01-10 21:57:56',0),('2016
@karlbunch
karlbunch / screenlog.0
Created March 12, 2017 20:36
TrinityCore rev. 4164d8998069 2017-03-12 14:19:51 +0100 (4.3.4 branch) (Unix, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
@karlbunch
karlbunch / screenlog.0
Created March 12, 2017 20:06
TrinityCore rev. 4164d8998069 2017-03-12 14:19:51 +0100 (4.3.4 branch) (Unix, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \