r807 - 2016/06/11 Item/Mob SQL Database Update Part 2

[Rytech 392]

If anyone has any problems after this update, please let me know. Be sure to read the patch notes carefully and backup your server and sql data before doing this update.

 

=General
*WARNING!!!!
-A number of changes were done to the TXT and SQL databases for
-items and monsters to clear up some confusion. Please read
-carefully and adjust your files/tables as needed.
-BACKUP YOUR SERVER AND SQL BEFORE UPDATING!!!!
-
-item_db2 had its named changed and is now item_db_custom.
-mob_db2 had its named changed and is now mob_db_custom.
-This is to make clear that this file is where to place customs.
-This applies to both txt versions and the sql table versions.
-
-Added item_db_3ceam and mob_db_3ceam SQL tables.
-Be sure to apply these.
-
-The order that item/mob databases are read is changed.
-For items: item_db --> item_db_3ceam --> item_db_custom.
-For mobs: mob_db --> mob_db_3ceam --> mob_db_custom.
-This was done so things added to 3CeAM's database will not
-override with any customs added.
-
-With these changes its strongly recommended SQL users rebuild
-their item and mob tables. Remember there's now 3 for each one.
-
-Finally, this update will break custom entrys reading for flux
-since it will be looking for item_db2 and mob_db2 which no
-longer exist. Don't worry about this. ill be working on a
-updated flux control pannel for 3CeAM soon. It will still
-read item_db and mob_db.

=SQL
*Updated item_db.sql with all changes made in item_db.txt that
-fixes bugs on supported jobs.

*Fixed a issue where 3CeAM_svn762 and 3CeAM_svn769 had the wrong
-file extension.

*Added 3CeAM_svnr807.
-This update renames your item_db2 table to item_db_custom and
-mob_db2 table to mob_db_custom.

[cookie-rae 6]

Thansk sir already up to date my server