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
```
Was recently noted by @Xaver-DaRed that the northlands skies were blank. It turns out, weather for those zones were not set properly. This PR copies the existing weather of present area zones to their Shadowreign counterparts in Castle Z (S), Glacier (S), and Xarcabard (S). Throne Room (S) had weather set already.
This dumb copy method is made with the assumption of the weather being fairly close due to lack of useful data being present. It definitely corrects the problem for now. At a future time, someone may be able to extract weather data from zone DATs ( @TeoTwawki mentioned it resides there) and ensure everything is 100%.
- 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.
Changes the weather system to store weather in
packed bit-pattern blob instead of 237K DB rows.
Uses a new weather table, so as not to conflict
with older installations.
-added fields for hiding HP bar and making mobs untargetable
-removed untargetable mobs from wide scan
-some basic scripts for Phuabo, Hpemde and Yovra in sea
-changed weather in sea
DATABASE: Added retail positions for Gargoyles, made them NM's. Fixed few wrong status's on elevators/door in Pso'xja. Made Psxjax and Shrouded Maw share weather based on some retail testing (wiki seems to be wrong). Fixed elevator ID's for Pso, and commented out the moving-floor elevators for now (they cause all mobs in the zone to be invisible, until someone can fix this).
SRC: Added a new LUA binding for Close.door so that certain doors can work properly. (Thank you Zedingo for helping me with this) I needed this for the Tile Script in Pso'j to work properly.
- Davoi doesn't have double weather
CONF: @cs now accepts hexadecimal values (0x61) No scripter in the history of the project has wanted to avoid converting the values.
- A new value UNLOCK_OUTPOST_WARPS has been added, as well.
This should reduce some help requests.
SQL: Disabled some invalid weather in zones we don't even use
- Corrected weather in Throne Room. Bug closed.
SCRIPTING:
- Afflatus Solace will now overwrite itself.
- Perfect Dodge now has the correct 60 second duration. Bug closed.
