I've changed the range of the limited shop to be substantially lower. The numbers are NOT retail accurate. Neither are the existing ones, because retail changed most of this long ago in multiple waves of QoL changes. The "max" the npc will pay a players price is 1/3 what the sql column says when there is zero in stock.
Closes#1173
MyISAM = table level locking, fast but not safe for multiple simultaneous writes
InnoDB = row level locking, slow, but is safe for multiple simultaneous writes
```
Features MyISAM InnoDB
Type Non-Transactional Transactional
Locking Table locking Row-level locking
Foreign keys No Yes
Table, index, data storage Three separate files Combined Tablespace
ACID No Yes
```
- Rebranding.
- Migrate to GitLab.
- Add support for database updates when using Docker.
- Give purpose to version.h (adjust minor version with client updates).
- Add an in-game `!ver` command.
- Remove references to AGPL.
updated guild vendors to use npc_util (I haven't verified that it doesn't break anything but would appreciate some feedback from a Tester):
* Cletae
* Celestina
to tables inside shop.lua
Added generalGuild function in shop.lua to work with the guild vendors
that are open 24 hours. Log is set to -1 by default as there's no price
change
Lowered sell price for Mandrel as it's being sold for a cheaper price
- in some cases min_price,max_price was lower than the item sell price
- attempted to move min_price to 133% of the sell price
- arbitrary max_price if necessary
I got on retail using someone elses account to check firsthand: ffxiclopedia is wrong, ffxiah is wrong.
I may be slightly off from minimal fame differences.
Better than it was.
Also fixed Droprates of High Level efts in Bibiki Bay, and most Antlion types on Aht. Chasm
- Lowered Defenders HP to proper value
- Fixed droplist loot prioritys of sky gods & the other Abjuration HNM's (no more rare/ex items auto-dropping because of loot table overflow), fixed a few dolls in sky facing wrong way (Aggroing variety)
- Removed a comment on Windy fishing guild so Mithran Fish Rod can be sold
- 3 Beastman Kings + their PH NMs: fixed loot tables, gave 2hrs if needed, made Zu Dha larger, gave text IDs (commented out until I can get messagePublic working..)
This should complete all of the work on guilds at the Lua and SQL level. A core modification is required for these NPCs to do anything other than talk or show you their stock.
