diff options
| author | roc13x <roc13x@gmail.com> | 2017-08-17 02:00:42 -0600 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2017-08-20 18:10:11 +0200 |
| commit | e04f75bd962006662bc0f77f0034f061605fb1c6 (patch) | |
| tree | 5e8d1bf38ab41319634e104bdb08dce56d16ac9d /sql/updates | |
| parent | 26d63a276e51db88e293e61b190ca3789fea13db (diff) | |
Core/Players: Several gold handling improvements
* Update gold limit to 10 million
* Updated auction house gold handling to 64-bit
* Fixed some vendor checks for when BuyCount > 1
* Tweaked some checks for available gold space
* Updated guild bank gold handling to 64-bit and fix withdraw limits
* Enforce gold limit on guild bank
* Check correct rank right when withdrawing from bank
* Other small changes to update money to 64-bit
Closes #19195
Closes #20152
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/master/2017_08_20_01_characters.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2017_08_20_01_characters.sql b/sql/updates/characters/master/2017_08_20_01_characters.sql new file mode 100644 index 00000000000..3f37d8a9407 --- /dev/null +++ b/sql/updates/characters/master/2017_08_20_01_characters.sql @@ -0,0 +1,9 @@ +ALTER TABLE `auctionhouse` + CHANGE `buyoutprice` `buyoutprice` bigint(20) unsigned NOT NULL DEFAULT '0', + CHANGE `lastbid` `lastbid` bigint(20) unsigned NOT NULL DEFAULT '0', + CHANGE `startbid` `startbid` bigint(20) unsigned NOT NULL DEFAULT '0', + CHANGE `deposit` `deposit` bigint(20) unsigned NOT NULL DEFAULT '0'; + +ALTER TABLE `guild_member_withdraw` CHANGE `money` `money` bigint(20) unsigned NOT NULL DEFAULT '0'; + +ALTER TABLE `item_refund_instance` CHANGE `paidMoney` `paidMoney` bigint(20) unsigned NOT NULL DEFAULT '0'; |