- Update to 3865

- Rework the port

PR:		ports/113471 (based on)
Submitted by:	Artem V. Kropachev <neon_cyrex@mail.ru>

7 files changed, 287 insertions, 77 deletions

diff --git a/games/mangos/Makefile b/games/mangos/Makefile
index 1b9b3df1d33..5e122ace55e 100644
--- a/games/mangos/Makefile
+++ b/games/mangos/Makefile
@@ -1,88 +1,95 @@
-# New ports collection makefile for:   mangos
-# Date created:        15 march 2007
-# Whom: neon
+# New ports collection makefile for:	mangos
+# Date created:		15 March 2007
+# Whom:			Artemiy Kropachev <neon_cyrex@mail.ru>
 #
 # $FreeBSD$
 #
 
 PORTNAME=	mangos
-PORTVERSION=	3431
+PORTVERSION=	3865
 CATEGORIES=	games
-MASTER_SITES=	http://neon.heavennet.ru/mangos/
+MASTER_SITES=	CENKES http://mangos-port.by.ru/ \
+		http://neon.heavennet.ru/mangos/
+DISTFILES=	${PORTNAME}-${DISTVERSION}${EXTRACT_SUFX}
+SCRIPTDEV2REV=	54
 
-MAINTAINER=	neon_cyrex@mail.ru
+MAINTAINER=    	neon_cyrex@mail.ru
 COMMENT=	Free dedicated-server for World of Warcraft
 
 OPTIONS=	SCRIPTDEV2	"ScriptDev2"	on \
-		CLI		"Command Line Itrerface support" on \
-		RA		"Remote Administration support" on \
-		DBC		"Install DBC files" on
-
-.include <bsd.port.pre.mk>
-
-SCRIPTDEV2REV=	32
-DISTFILES=${PORTNAME}-${PORTVERSION}.tar.gz
-.if defined(WITH_SCRIPTDEV2)
-    DISTFILES+= ScriptDev2-${SCRIPTDEV2REV}.tar.gz
-.endif
-
-.if defined(WITH_DBC)
-    DISTFILES+= mangos-dbc.tar.gz
-.endif
+		CLI		"Command Line Itrerface support" off \
+		RA		"Remote Administration support" off \
+		DBC		"Install DBC files" on \
+		HONORRATE	"Enable HonorRate patch" on
 
 USE_AUTOTOOLS=	aclocal:19 libtoolize autoconf:261 autoheader:261 automake:19 libtool:15
 ACLOCAL_ARGS=	-I ${LOCALBASE}/share/aclocal
 AUTOMAKE_ARGS=	-a
 USE_MYSQL=	yes
-CFLAGS:=	${CFLAGS:N-O*} -O0
+CFLAGS+=	-O0
 USE_LDCONFIG=	yes
+CPPFLAGS+=	-I${LOCALBASE}/include
+LDFLAGS+=	-L${LOCALBASE}/lib
+CONFIGURE_ARGS= --prefix=${PREFIX} --sysconfdir=${PREFIX}/etc --datadir=${PREFIX}/share
+CONFIGURE_ENV=	CPPFLAGS="${CPPFLAGS}" LDFLAGS="${LDFLAGS}"
 
-CONFIGURE_ARGS=	--prefix=${PREFIX} --sysconfdir=${PREFIX}/etc --datadir=${PREFIX}/share
+.include <bsd.port.pre.mk>
 
-.if defined(WITH_SCRIPTDEV2)
-    EXTRA_PATCHES=${FILESDIR}/configure.ac.patch
+.ifdef WITH_SCRIPTDEV2
+DISTFILES+=	ScriptDev2-${SCRIPTDEV2REV}.tar.gz
+EXTRA_PATCHES=	${FILESDIR}/ScriptDev2.patch
 .endif
-
-.if defined(WITH_CLI)
-    CONFIGURE_ARGS+= --enable-cli
+.ifdef WITH_DBC
+PLIST_SUB+=	DBC=""
+DISTFILES+=	mangos-dbc2.tar.gz
+.else
+PLIST_SUB+=	DBC="@comment "
 .endif
-
-.if defined(WITH_RA)
-    CONFIGURE_ARGS+= --enable-ra
+.ifdef WITH_HONORRATE
+EXTRA_PATCHES+=	${FILESDIR}/HonorRate.patch
+.endif
+.ifdef WITH_CLI
+CONFIGURE_ARGS+=--enable-cli
+.endif
+.ifdef WITH_RA
+CONFIGURE_ARGS+=--enable-ra
 .endif
 
 post-extract:
-.if defined(WITH_SCRIPTDEV2)
-	@(${MV} ${WRKDIR}/ScriptDev2-${SCRIPTDEV2REV}  ${WRKDIR}/${PORTNAME}-${PORTVERSION}/src/bindings/ScriptDev2)
+.ifdef WITH_SCRIPTDEV2
+	@${MV} ${WRKDIR}/ScriptDev2-${SCRIPTDEV2REV} ${WRKSRC}/src/bindings/ScriptDev2/
 .endif
-	${LN} -s ${LTMAIN} ${WRKDIR}/${PORTNAME}-${PORTVERSION}/
-	@${REINPLACE_CMD} -e "s|@MANGOSD_CONFIG@|${PREFIX}/etc/mangosd.conf|g" ${WRKDIR}/${PORTNAME}-${PORTVERSION}/src/shared/SystemConfig.h.in
-	@${REINPLACE_CMD} -e "s|@REALMD_CONFIG@|${PREFIX}/etc/realmd.conf|g" ${WRKDIR}/${PORTNAME}-${PORTVERSION}/src/shared/SystemConfig.h.in
-	@${REINPLACE_CMD} -e "s|@MANGOSD_DATA@|${PREFIX}/share/mangos|g" ${WRKDIR}/${PORTNAME}-${PORTVERSION}/src/mangosd/mangosd.conf.in
+	@${LN} -s ${LTMAIN} ${WRKSRC}/
+
+post-patch:
+	@${REINPLACE_CMD} -Ee 's!../etc/(mangos|realm)d.conf!${PREFIX}/etc/\1d.conf!g' \
+		${WRKSRC}/src/shared/SystemConfig.h.in
+	@${REINPLACE_CMD} -e 's|@MANGOSD_DATA@|${PREFIX}/share/mangos|g' \
+		${WRKSRC}/src/mangosd/mangosd.conf.in
+	@${REINPLACE_CMD} -e '/^sysconf_DATA/,/conf/d' \
+		${WRKSRC}/src/mangosd/Makefile.am ${WRKSRC}/src/realmd/Makefile.am
 
 run-autotools-automake:
 	@(cd ${CONFIGURE_WRKSRC} && ${SETENV} ${AUTOTOOLS_ENV} ${AUTOMAKE} ${AUTOMAKE_ARGS})
-.if defined(WITH_SCRIPTDEV2)
-	@(cd ${CONFIGURE_WRKSRC} && ${SETENV} ${AUTOTOOLS_ENV} ${AUTOMAKE} ${AUTOMAKE_ARGS} src/bindings/ScriptDev2/Makefile)
+.ifdef WITH_SCRIPTDEV2
+	@(cd ${CONFIGURE_WRKSRC} && ${SETENV} ${AUTOTOOLS_ENV} ${AUTOMAKE} \
+		${AUTOMAKE_ARGS} src/bindings/ScriptDev2/Makefile)
 .endif
 
-do-build:
-	@(cd ${BUILD_WRKSRC}; ${SETENV} ${MAKE_ENV} ${MAKE} ${MAKE_FLAGS} ${MAKEFILE} ${MAKE_ARGS} ${ALL_TARGET})
-.if defined(WITH_SCRIPTDEV2)
+.ifdef WITH_SCRIPTDEV2
+post-build:
 	@(cd ${BUILD_WRKSRC}/src/bindings/ScriptDev2; ${SETENV} ${MAKE_ENV} ${MAKE} ${MAKE_FLAGS} ${MAKEFILE} ${MAKE_ARGS} ${ALL_TARGET})
 .endif
 
-do-install:
-	@(cd ${INSTALL_WRKSRC} && ${SETENV} ${MAKE_ENV} ${MAKE} ${MAKE_FLAGS} ${MAKEFILE} ${MAKE_ARGS} ${INSTALL_TARGET})
-.if defined(WITH_SCRIPTDEV2)
+post-install:
+	@for i in mangosd realmd;do cd ${PREFIX}/etc/&&\
+		${INSTALL_DATA} ${WRKSRC}/src/$$i/$$i.conf $$i.conf.sample&&\
+		${CP} -np $$i.conf.sample $$i.conf;done
+.ifdef WITH_SCRIPTDEV2
 	@(cd ${INSTALL_WRKSRC}/src/bindings/ScriptDev2 && ${SETENV} ${MAKE_ENV} ${MAKE} ${MAKE_FLAGS} ${MAKEFILE} ${MAKE_ARGS} ${INSTALL_TARGET})
 .endif
-
-.if defined(WITH_DBC)
-	@(${MV} ${WRKDIR}/dbc ${PREFIX}/share/mangos/dbc)
-PLIST_SUB+=	DBC=""
-.else
-PLIST_SUB+=	DBC="@comment "
+.ifdef WITH_DBC
+	@${CP} -Rf ${WRKDIR}/dbc ${PREFIX}/share/mangos/dbc
 .endif
 
 .include <bsd.port.post.mk>
diff --git a/games/mangos/distinfo b/games/mangos/distinfo
index 0131fc79104..4b09b9916cb 100644
--- a/games/mangos/distinfo
+++ b/games/mangos/distinfo
@@ -1,9 +1,9 @@
-MD5 (mangos-3431.tar.gz) = 385a7626dba0b1b37146d0126ee46d45
-SHA256 (mangos-3431.tar.gz) = aea647873563c118087539ce1f38ac5c6513c2f19ba8f8c74b507b0933190f44
-SIZE (mangos-3431.tar.gz) = 14081333
-MD5 (ScriptDev2-32.tar.gz) = 6d22d5c2a2e5f7b99a7bdcf0a5678987
-SHA256 (ScriptDev2-32.tar.gz) = 8fff58731d2a3c7ab0c216f081f6af809b764a9745265193f5827a90cbb58b82
-SIZE (ScriptDev2-32.tar.gz) = 315614
-MD5 (mangos-dbc.tar.gz) = dadfdbbef1dd4cf3d641a1ab00b024ce
-SHA256 (mangos-dbc.tar.gz) = bdaa8e5ef1e07f5e886dcd77f95842f16588ef782886b58d0d10483c5827d5de
-SIZE (mangos-dbc.tar.gz) = 2784924
+MD5 (mangos-3865.tar.gz) = 6f322fe3b80acd781a13335ffe57f2e8
+SHA256 (mangos-3865.tar.gz) = 07a376383afadec4748a2aeac659402a646776fdc4b1bcbbd956f0f7dda92550
+SIZE (mangos-3865.tar.gz) = 14570609
+MD5 (ScriptDev2-54.tar.gz) = 2d172a663ddd6bf4451514a69bb5d471
+SHA256 (ScriptDev2-54.tar.gz) = 64db6b4aa73df7414f2cea34da12387c84f9932325a894fe9327f1c5f7edc146
+SIZE (ScriptDev2-54.tar.gz) = 545942
+MD5 (mangos-dbc2.tar.gz) = f0258004858dbf283ed7d37887b7b74d
+SHA256 (mangos-dbc2.tar.gz) = 9f7d0c4138aa81b4e3e785da3879c36340bf8d895d7c52df955065d01d76cde0
+SIZE (mangos-dbc2.tar.gz) = 4107847
diff --git a/games/mangos/files/HonorRate.patch b/games/mangos/files/HonorRate.patch
new file mode 100644
index 00000000000..24b4b8b32dc
--- /dev/null
+++ b/games/mangos/files/HonorRate.patch
@@ -0,0 +1,44 @@
+--- src/game/World.h
++++ src/game/World.h
+@@ -120,6 +120,7 @@
+     RATE_AUCTION_TIME,
+     RATE_AUCTION_DEPOSIT,
+     RATE_AUCTION_CUT,
++    RATE_HONOR,
+     RATE_MINING_AMOUNT,
+     RATE_MINING_NEXT,
+     MAX_RATES
+--- src/mangosd/mangosd.conf.in
++++ src/mangosd/mangosd.conf.in
+@@ -233,6 +233,9 @@
+ Rate.Mining.Amount = 1
+ Rate.Mining.Next   = 1
+ 
++#
++Rate.Honor = 1
++
+ # Save respawn time for creatures at death, for gameobjects at use/open
+ #          0 (save creature/gameobject respawn time at grid unload)
+ # Default: 1 (save creature/gameobject respawn time without waiting grid unload)
+ 
+--- src/game/Player.cpp
++++ src/game/Player.cpp
+@@ -4697,7 +4697,7 @@
+ 
+     UpdateHonorFields();                                    // to prevent CalcluateHonor() on a new day before old honor was UpdateHonorFields()
+ 
+-    float honor = ((float)urand(1,80))/10;                  // honor between: 0.1 - 8.0
++    float honor = ((float)urand(1,80))/10 * sWorld.getRate(RATE_HONOR);                  // honor between: 0.1 - 8.0
+     float approx_honor = honor * (((float)urand(8,12))/10); // approx honor: 80% - 120% of real honor
+     sDatabase.Execute("INSERT INTO `character_kill` (`guid`,`creature_template`,`honor`,`date`) VALUES (%u, %u, %f, %u)", GUID_LOPART(GetGUID()), uVictim->GetEntry(), honor, time(0));
+ 
+--- src/game/World.cpp
++++ src/game/World.cpp
+@@ -257,6 +257,7 @@
+     rate_values[RATE_AUCTION_TIME]  = sConfig.GetFloatDefault("Rate.Auction.Time", 1);
+     rate_values[RATE_AUCTION_DEPOSIT] = sConfig.GetFloatDefault("Rate.Auction.Deposit", 1);
+     rate_values[RATE_AUCTION_CUT] = sConfig.GetFloatDefault("Rate.Auction.Cut", 1);
++    rate_values[RATE_HONOR] = sConfig.GetFloatDefault("Rate.Honor", 1);
+     rate_values[RATE_MINING_AMOUNT] = sConfig.GetFloatDefault("Rate.Mining.Amount",1);
+     rate_values[RATE_MINING_NEXT]   = sConfig.GetFloatDefault("Rate.Mining.Next",1);
+ 
diff --git a/games/mangos/files/ScriptDev2.patch b/games/mangos/files/ScriptDev2.patch
new file mode 100644
index 00000000000..af1cb7b0a08
--- /dev/null
+++ b/games/mangos/files/ScriptDev2.patch
@@ -0,0 +1,35 @@
+--- src/mangosd/Makefile.am
++++ src/mangosd/Makefile.am
+@@ -33,8 +33,8 @@
+ 	WorldRunnable.h
+ 
+ ## Link world daemon against the shared library
+-mangos_worldd_LDADD = ../bindings/universal/libmangosscript.la ../game/libmangosgame.a ../shared/libmangosdatabase.a ../shared/libmangosconfig.a ../shared/libmangosauth.a ../shared/libmangosshared.a ../shared/libmangosnetwork.a ../framework/libmangosframework.a ../../dep/src/zthread/libZThread.la
+-mangos_worldd_LDFLAGS = -L../../dep/src/zthread -L../bindings/universal/ $(MYSQL_LIBS) -L$(libdir) $(ZLIB) $(COMPATLIB) $(SSLLIB) -export-dynamic
++mangos_worldd_LDADD = ../bindings/ScriptDev2/libmangosscript.la ../game/libmangosgame.a ../shared/libmangosdatabase.a ../shared/libmangosconfig.a ../shared/libmangosauth.a ../shared/libmangosshared.a ../shared/libmangosnetwork.a ../framework/libmangosframework.a ../../dep/src/zthread/libZThread.la
++mangos_worldd_LDFLAGS = -L../../dep/src/zthread -L../bindings/ScriptDev2/ $(MYSQL_LIBS) -L$(libdir) $(ZLIB) $(COMPATLIB) $(SSLLIB) -export-dynamic
+ 
+ ## Additional files to include when running 'make dist'
+ #  Include world daemon configuration
+--- configure.ac
++++ configure.ac
+@@ -191,7 +191,10 @@
+    src/mangosd/Makefile
+    src/mangosd/mangosd.conf
+    src/bindings/Makefile
+-   src/bindings/universal/Makefile
++   src/bindings/ScriptDev2/Makefile
++   src/bindings/ScriptDev2/sql/Makefile
++   src/bindings/ScriptDev2/sql/Updates/Makefile
++   
+ ])
+ 
+ ## Disabled Makefiles, until they are ready for a successful make and
+--- src/bindings/Makefile.am
++++ src/bindings/Makefile.am
+@@ -14,4 +14,4 @@
+ # along with this program; if not, write to the Free Software
+ # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+ 
+-SUBDIRS = universal
++SUBDIRS = ScriptDev2
diff --git a/games/mangos/files/configure.ac.patch b/games/mangos/files/configure.ac.patch
deleted file mode 100644
index c99aeb6552e..00000000000
--- a/games/mangos/files/configure.ac.patch
+++ /dev/null
@@ -1,10 +0,0 @@
---- configure.ac.orig	Mon Mar 19 11:08:32 2007
-+++ configure.ac	Mon Mar 19 11:08:43 2007
-@@ -187,6 +187,7 @@
-    src/mangosd/mangosd.conf
-    src/bindings/Makefile
-    src/bindings/universal/Makefile
-+   src/bindings/ScriptDev2/Makefile
- ])
- 
- ## Disabled Makefiles, until they are ready for a successful make and
diff --git a/games/mangos/files/patch-time b/games/mangos/files/patch-time
new file mode 100644
index 00000000000..8024cbfef93
--- /dev/null
+++ b/games/mangos/files/patch-time
@@ -0,0 +1,53 @@
+--- src/shared/EventSystem.cpp	Wed May 23 10:14:13 2007
++++ src/shared/EventSystem.cpp	Wed May 23 10:16:34 2007
+@@ -21,7 +21,7 @@
+ #include "EventSystem.h"
+ 
+ #ifndef WIN32
+-#include <sys/timeb.h>
++#include <sys/time.h>
+ #endif
+ 
+ PeriodicEvent *msPEvents=NULL;
+@@ -103,10 +103,11 @@
+     #if PLATFORM == PLATFORM_WIN32
+     return timeGetTime();
+     #else
+-    struct timeb tp;
+-    ftime(&tp);
++    
++    struct timeval tv;
++    gettimeofday(&tv, (struct timezone*) NULL);
+ 
+-    return  tp.time * 1000 + tp.millitm;
++    return  tv.tv_sec * 1000 + tv.tv_usec / 1000;
+     #endif
+ }
+ 
+--- src/shared/Timer.h	Sat Mar 17 14:26:42 2007
++++ src/shared/Timer.h	Wed May 23 10:43:28 2007
+@@ -27,7 +27,7 @@
+ #   include <time.h>
+ #else
+ # if defined(__FreeBSD__) || defined(__APPLE_CC__)
+-#   include <time.h>
++#   include <sys/time.h>
+ # endif
+ #   include <sys/timeb.h>
+ #endif
+@@ -38,10 +38,11 @@
+     #if PLATFORM == PLATFORM_WIN32
+     time_in_ms = timeGetTime();
+     #else
+-    struct timeb tp;
+-    ftime(&tp);
+-
+-    time_in_ms = tp.time * 1000 + tp.millitm;
++    struct timeval tv;
++    gettimeofday(&tv, (struct timezone*) NULL); 
++    
++    time_in_ms = tv.tv_sec * 1000 + tv.tv_usec / 1000; 
++    
+     #endif
+ 
+     return time_in_ms;
diff --git a/games/mangos/pkg-plist b/games/mangos/pkg-plist
index 3f6ea1275ca..7d07ad4de11 100644
--- a/games/mangos/pkg-plist
+++ b/games/mangos/pkg-plist
@@ -1,7 +1,11 @@
 bin/mangos-worldd
 bin/mangos-realmd
-etc/mangosd.conf
-etc/realmd.conf
+@unexec if cmp -s %D/etc/mangosd.conf %D/etc/mangosd.conf.sample;then rm -f %D/etc/mangosd.conf;fi
+etc/mangosd.conf.sample
+@exec cp -n %D/%F %B/mangosd.conf
+@unexec if cmp -s %D/etc/realmd.conf %D/etc/realmd.conf.sample;then rm -f %D/etc/realmd.conf;fi
+etc/realmd.conf.sample
+@exec cp -n %D/%F %B/realmd.conf
 lib/libZThread.a
 lib/libZThread.la
 lib/libZThread.so
@@ -264,6 +268,66 @@ lib/libmangosscript.so.0
 %%DATADIR%%/sql/updates/3397_creature_template.sql
 %%DATADIR%%/sql/updates/3400.sql
 %%DATADIR%%/sql/updates/3402_creature_onkill_reputation.sql
+%%DATADIR%%/sql/updates/3410_group.sql
+%%DATADIR%%/sql/updates/3424_command.sql
+%%DATADIR%%/sql/updates/3463_mangos.sql
+%%DATADIR%%/sql/updates/3463_realm.sql
+%%DATADIR%%/sql/updates/3474_creature_addon.sql
+%%DATADIR%%/sql/updates/3501.sql
+%%DATADIR%%/sql/updates/3503_creature_movement.sql
+%%DATADIR%%/sql/updates/3512_character_spell_cooldown.sql
+%%DATADIR%%/sql/updates/3514_mail.sql
+%%DATADIR%%/sql/updates/3516_spell_learn_spell.sql
+%%DATADIR%%/sql/updates/3533_command.sql
+%%DATADIR%%/sql/updates/3538_guild_charter_sign.sql
+%%DATADIR%%/sql/updates/3539_item_template.sql
+%%DATADIR%%/sql/updates/3545_creature_movement.sql
+%%DATADIR%%/sql/updates/3547_character_reputation.sql
+%%DATADIR%%/sql/updates/3553_creature_onkill_reputation.sql
+%%DATADIR%%/sql/updates/3562_player_levelstats.sql
+%%DATADIR%%/sql/updates/3605_creature_addon.sql
+%%DATADIR%%/sql/updates/3605_grid.sql
+%%DATADIR%%/sql/updates/3611_spell_learn_skill.sql
+%%DATADIR%%/sql/updates/3616_commands.sql
+%%DATADIR%%/sql/updates/3627_quest_template.sql
+%%DATADIR%%/sql/updates/3631_gameobject_template.sql
+%%DATADIR%%/sql/updates/3636_character_spell.sql
+%%DATADIR%%/sql/updates/3636_playercreateinfo_spell.sql
+%%DATADIR%%/sql/updates/3646_spell_chain.sql
+%%DATADIR%%/sql/updates/3648_command.sql
+%%DATADIR%%/sql/updates/3649_spell_chain.sql
+%%DATADIR%%/sql/updates/3653_spell.sql
+%%DATADIR%%/sql/updates/3655_quest_template.sql
+%%DATADIR%%/sql/updates/3657_command.sql
+%%DATADIR%%/sql/updates/3660_character_kill.sql
+%%DATADIR%%/sql/updates/3700_character.sql
+%%DATADIR%%/sql/updates/3728_spell_proc_event.sql
+%%DATADIR%%/sql/updates/3730_command.sql
+%%DATADIR%%/sql/updates/3732_spell_affect.sql
+%%DATADIR%%/sql/updates/3739_looking_for_group.sql
+%%DATADIR%%/sql/updates/3746_spell_proc_event.sql
+%%DATADIR%%/sql/updates/3747_command.sql
+%%DATADIR%%/sql/updates/3748_command.sql
+%%DATADIR%%/sql/updates/3753_battleground_template.sql
+%%DATADIR%%/sql/updates/3763_spell_affect.sql
+%%DATADIR%%/sql/updates/3766_spell_proc_event.sql
+%%DATADIR%%/sql/updates/3771_creature_template.sql
+%%DATADIR%%/sql/updates/3773.sql
+%%DATADIR%%/sql/updates/3774_playercreateinfo_spell.sql
+%%DATADIR%%/sql/updates/3782_command.sql
+%%DATADIR%%/sql/updates/3784_command.sql
+%%DATADIR%%/sql/updates/3787_spell_proc_event.sql
+%%DATADIR%%/sql/updates/3801_banAccount.sql
+%%DATADIR%%/sql/updates/3801_command.sql
+%%DATADIR%%/sql/updates/3802_arena_teams.sql
+%%DATADIR%%/sql/updates/3802_petitions.sql
+%%DATADIR%%/sql/updates/3805_spell_proc_event.sql
+%%DATADIR%%/sql/updates/3806_petitions.sql
+%%DATADIR%%/sql/updates/3833_quest_template.sql
+%%DATADIR%%/sql/updates/3845_account.sql
+%%DATADIR%%/sql/updates/3845_command.sql
+%%DATADIR%%/sql/updates/3859_spell_affect.sql
+%%DATADIR%%/sql/updates/3862_prospecting_loot_template.sql
 %%DATADIR%%/sql/updates/README
 %%DBC%%%%DATADIR%%/dbc/AnimationData.dbc
 %%DBC%%%%DATADIR%%/dbc/AreaPOI.dbc
@@ -273,6 +337,7 @@ lib/libmangosscript.so.0
 %%DBC%%%%DATADIR%%/dbc/AttackAnimTypes.dbc
 %%DBC%%%%DATADIR%%/dbc/AuctionHouse.dbc
 %%DBC%%%%DATADIR%%/dbc/BankBagSlotPrices.dbc
+%%DBC%%%%DATADIR%%/dbc/BattlemasterList.dbc
 %%DBC%%%%DATADIR%%/dbc/CameraShakes.dbc
 %%DBC%%%%DATADIR%%/dbc/Cfg_Categories.dbc
 %%DBC%%%%DATADIR%%/dbc/Cfg_Configs.dbc
@@ -281,8 +346,8 @@ lib/libmangosscript.so.0
 %%DBC%%%%DATADIR%%/dbc/CharHairTextures.dbc
 %%DBC%%%%DATADIR%%/dbc/CharSections.dbc
 %%DBC%%%%DATADIR%%/dbc/CharStartOutfit.dbc
+%%DBC%%%%DATADIR%%/dbc/CharTitles.dbc
 %%DBC%%%%DATADIR%%/dbc/CharVariations.dbc
-%%DBC%%%%DATADIR%%/dbc/CharacterCreateCameras.dbc
 %%DBC%%%%DATADIR%%/dbc/CharacterFacialHairStyles.dbc
 %%DBC%%%%DATADIR%%/dbc/ChatChannels.dbc
 %%DBC%%%%DATADIR%%/dbc/ChatProfanity.dbc
@@ -317,16 +382,20 @@ lib/libmangosscript.so.0
 %%DBC%%%%DATADIR%%/dbc/GMTicketCategory.dbc
 %%DBC%%%%DATADIR%%/dbc/GameObjectArtKit.dbc
 %%DBC%%%%DATADIR%%/dbc/GameObjectDisplayInfo.dbc
+%%DBC%%%%DATADIR%%/dbc/GameTables.dbc
 %%DBC%%%%DATADIR%%/dbc/GameTips.dbc
+%%DBC%%%%DATADIR%%/dbc/GemProperties.dbc
 %%DBC%%%%DATADIR%%/dbc/GroundEffectDoodad.dbc
 %%DBC%%%%DATADIR%%/dbc/GroundEffectTexture.dbc
 %%DBC%%%%DATADIR%%/dbc/HelmetGeosetVisData.dbc
 %%DBC%%%%DATADIR%%/dbc/ItemBagFamily.dbc
 %%DBC%%%%DATADIR%%/dbc/ItemClass.dbc
 %%DBC%%%%DATADIR%%/dbc/ItemDisplayInfo.dbc
+%%DBC%%%%DATADIR%%/dbc/ItemExtendedCost.dbc
 %%DBC%%%%DATADIR%%/dbc/ItemGroupSounds.dbc
 %%DBC%%%%DATADIR%%/dbc/ItemPetFood.dbc
 %%DBC%%%%DATADIR%%/dbc/ItemRandomProperties.dbc
+%%DBC%%%%DATADIR%%/dbc/ItemRandomSuffix.dbc
 %%DBC%%%%DATADIR%%/dbc/ItemSet.dbc
 %%DBC%%%%DATADIR%%/dbc/ItemSubClass.dbc
 %%DBC%%%%DATADIR%%/dbc/ItemSubClassMask.dbc
@@ -357,8 +426,10 @@ lib/libmangosscript.so.0
 %%DBC%%%%DATADIR%%/dbc/PaperDollItemFrame.dbc
 %%DBC%%%%DATADIR%%/dbc/PetLoyalty.dbc
 %%DBC%%%%DATADIR%%/dbc/PetPersonality.dbc
+%%DBC%%%%DATADIR%%/dbc/PetitionType.dbc
 %%DBC%%%%DATADIR%%/dbc/QuestInfo.dbc
 %%DBC%%%%DATADIR%%/dbc/QuestSort.dbc
+%%DBC%%%%DATADIR%%/dbc/RandPropPoints.dbc
 %%DBC%%%%DATADIR%%/dbc/Resistances.dbc
 %%DBC%%%%DATADIR%%/dbc/ServerMessages.dbc
 %%DBC%%%%DATADIR%%/dbc/SheatheSoundLookups.dbc
@@ -369,25 +440,24 @@ lib/libmangosscript.so.0
 %%DBC%%%%DATADIR%%/dbc/SkillRaceClassInfo.dbc
 %%DBC%%%%DATADIR%%/dbc/SkillTiers.dbc
 %%DBC%%%%DATADIR%%/dbc/SoundAmbience.dbc
-%%DBC%%%%DATADIR%%/dbc/SoundCharacterMacroLines.dbc
 %%DBC%%%%DATADIR%%/dbc/SoundEntries.dbc
 %%DBC%%%%DATADIR%%/dbc/SoundProviderPreferences.dbc
 %%DBC%%%%DATADIR%%/dbc/SoundSamplePreferences.dbc
 %%DBC%%%%DATADIR%%/dbc/SoundWaterType.dbc
 %%DBC%%%%DATADIR%%/dbc/SpamMessages.dbc
 %%DBC%%%%DATADIR%%/dbc/Spell.dbc
-%%DBC%%%%DATADIR%%/dbc/SpellAuraNames.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellCastTimes.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellCategory.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellChainEffects.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellDispelType.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellDuration.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellEffectCameraShakes.dbc
-%%DBC%%%%DATADIR%%/dbc/SpellEffectNames.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellFocusObject.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellIcon.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellItemEnchantment.dbc
+%%DBC%%%%DATADIR%%/dbc/SpellItemEnchantmentCondition.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellMechanic.dbc
+%%DBC%%%%DATADIR%%/dbc/SpellMissileMotion.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellRadius.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellRange.dbc
 %%DBC%%%%DATADIR%%/dbc/SpellShapeshiftForm.dbc
@@ -406,6 +476,7 @@ lib/libmangosscript.so.0
 %%DBC%%%%DATADIR%%/dbc/TaxiPathNode.dbc
 %%DBC%%%%DATADIR%%/dbc/TerrainType.dbc
 %%DBC%%%%DATADIR%%/dbc/TerrainTypeSounds.dbc
+%%DBC%%%%DATADIR%%/dbc/TotemCategory.dbc
 %%DBC%%%%DATADIR%%/dbc/TransportAnimation.dbc
 %%DBC%%%%DATADIR%%/dbc/UISoundLookups.dbc
 %%DBC%%%%DATADIR%%/dbc/UnitBlood.dbc
@@ -418,12 +489,22 @@ lib/libmangosscript.so.0
 %%DBC%%%%DATADIR%%/dbc/WorldMapArea.dbc
 %%DBC%%%%DATADIR%%/dbc/WorldMapContinent.dbc
 %%DBC%%%%DATADIR%%/dbc/WorldMapOverlay.dbc
+%%DBC%%%%DATADIR%%/dbc/WorldMapTransforms.dbc
 %%DBC%%%%DATADIR%%/dbc/WorldSafeLocs.dbc
 %%DBC%%%%DATADIR%%/dbc/WorldStateUI.dbc
 %%DBC%%%%DATADIR%%/dbc/WowError_Strings.dbc
 %%DBC%%%%DATADIR%%/dbc/ZoneIntroMusicTable.dbc
 %%DBC%%%%DATADIR%%/dbc/ZoneMusic.dbc
+%%DBC%%%%DATADIR%%/dbc/gtChanceToMeleeCrit.dbc
+%%DBC%%%%DATADIR%%/dbc/gtChanceToMeleeCritBase.dbc
+%%DBC%%%%DATADIR%%/dbc/gtChanceToSpellCrit.dbc
+%%DBC%%%%DATADIR%%/dbc/gtChanceToSpellCritBase.dbc
+%%DBC%%%%DATADIR%%/dbc/gtCombatRatings.dbc
+%%DBC%%%%DATADIR%%/dbc/gtOCTRegenHP.dbc
+%%DBC%%%%DATADIR%%/dbc/gtOCTRegenMP.dbc
+%%DBC%%%%DATADIR%%/dbc/gtRegenHPPerSpt.dbc
+%%DBC%%%%DATADIR%%/dbc/gtRegenMPPerSpt.dbc
 @dirrm %%DATADIR%%/sql/updates
 @dirrm %%DATADIR%%/sql
-@dirrm %%DATADIR%%/dbc
+%%DBC%%@dirrm %%DATADIR%%/dbc
 @dirrm %%DATADIR%%