Queries database then scans corresponding SQL file, replacing values
in INSERT statements with data from the database.
Is not smart about which INSERT statement gets which data; line-end
comments can get shuffled around if SQL file INSERTs are out of order
or missing. If you're doing INSERT or DELETE operations, make sure
to add a blank "INSERT INTO `table` VALUES ();" or manually remove
the INSERT statement respectively before dumping tables.
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.
Percolator costs 2 water element points on the server, the client expects 1 water element point resulting in loss of synchronization and client issues.
This is currently only the SQL implementations. The ability luas will either be done in a later pull, or combined with this submission if I have the time to do it before merge.
Includes some cost (element affinity for attachment) adjustments.
Added inhibitor_ii.lua and tension_spring_iv.lua as well as correct values to match BG, not ffxiwikia on tension_spring_iii.lua.
-added @cs2 command for 0x33 event packets (contain strings)
-added confirmItem(slotID) to lua_trade_container to be used with confirmTrade (lua_baseentity). confirmTrade removes only confirmed items (via confirmItem) from players inventory on trade (alternative to completeTrade)
-temp: add automaton name to CCharEntity (will be moved later) and getAutomatonName (will be replaced with getAutomaton)
SQL: fixed some missing automaton attachments, renamed char_pet_name to char_pet (to store more than just name)
