karlbunch

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

-- 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

-- 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

[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

-- 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

-- 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

-- 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

-- 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

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:

karlbunch

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: