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
```
CORE:
* Changes to the way skillchains are handled.
- now follow primary, secondary, tertiary chain rules (see wiki for details.)
* Also added in the persistence of effect SubPower and Tier for effects that are being read and written to the database.
SCRIPT:
* Removed skillchain.lua and replaced it with magicburst.lua
- This filename describes what it does a bit clearer.
- Contains the new method for determining what elements link with which skillchains.
SQL:
* char_effects.sql added the two new columns to keep SubPower and Tier of an effect saved.
* skillchain_damage_modifiers.sql added 4th level of skillchain. (Light + Light, Dark + Dark)
- Also added in values for magic burst bonus, these still aren't used yet as the lua script calculates the bonus out.
* weapon_skills.sql added three new columns for skillchain progression, primary_sc is the first effect that will try to link, followed by secondary, then tertiary. A side note is the element column was previously used to store these values but lacked a method to store the priority. This column is now free for use to store a weaponskills elemental damage attribute for upcomming elemental damage weaponskills.
SQL: Added table from skillchain_damage_modifiers.sql
- Used to determine skill chain count/level damage modifiers and up-coming magic burst damage bonuses.
SCRIPTS: Added new modifiers for skill chain damage gear/effects.
