This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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. | |
______ __ | |
/\__ _\ __ __/\ \__ | |
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ | |
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
TrinityCore rev. 4164d8998069 2017-03-12 14:19:51 +0100 (4.3.4 branch) (Unix, Release, Static) (worldserver-daemon) | |
<Ctrl-C> to stop. | |
______ __ | |
/\__ _\ __ __/\ \__ | |
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ | |
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ | |
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ | |
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ | |
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
TrinityCore rev. 4164d8998069 2017-03-12 14:19:51 +0100 (4.3.4 branch) (Unix, Release, Static) (worldserver-daemon) | |
<Ctrl-C> to stop. | |
______ __ | |
/\__ _\ __ __/\ \__ | |
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ | |
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ | |
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ | |
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ | |
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
0x00aa1e3f: int $3 | |
Modules: | |
Module Address Debug info Name (278 modules) | |
PE 400000- 19bf000 Export swgemu | |
PE 21100000-21164000 Deferred mss32 | |
PE 22300000-2232b000 Deferred msseax.m3d | |
PE 22400000-22419000 Deferred msssoft.m3d | |
PE 24100000-24121000 Deferred mssdsp.flt | |
PE 26f00000-26f2c000 Deferred mssmp3.asi | |
PE 40001000-401b7000 Stabs libwine.1.0.dylib |