Uses ranges and radius documented in the DAT files.
Tweaked existing values that were slightly off to whole numbers.
20.4 -> 20
16.4 -> 16
12.4 -> 12
104 -> 100
8.4 -> 8
5.8 -> 5
3.4 -> 3
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.
* Change various job point gift only spells to have a zeroed level requirement to disable casting without job points
* Disable Endark II/Enlight II as they have no script
* round 2 of Geo
* human readable table for luopan models
* make action offset more sane
* indi calcs and potency calcs ect
* Add geo to regular spells sql
* change getEquippedItemsMaxModValue > getMaxGearMod
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
```
I had noticed the enmity values were off quite a bit from the O.G. gold standard, Kanican's blog(1). Unfortunately for Ninjas, our reality now is that Square nerfed the enmity for loads of spells in 2013(2). BGWiki has fairly legitimate values for many Ninjutsu spells and Martel, a respectable career tank and poster, has put in time to legitimately test as of 2019(3).
It's not all doom and gloom, as many San spells were lacking enmity values. In the absence of information stating otherwise, they were given the same values seen of their lesser counterparts.
I did not touch Gekka or Yain, as no information could be found for them. The current values do seem fairly high compared to all other Ninjutsu, though.
Also missing here is the enmity boost from Yonin for Utsusemi spells. This will take some additional functionality to override or boost CE and VE inside of spells, something we have available for weaponskills, but not magic currently.
1: https://kanican.livejournal.com/19569.html
2: https://forum.square-enix.com/ffxi/threads/32909-April-30-2013-%28JST%29-Version-Update?p=425562&viewfull=1#post425562
3: https://www.ffxiah.com/forum/topic/29127/random-question-thread-ffxi-related/596/#3434966
