- Update to 4742 (SD2-164)

Submitted by:	Artemiy Kropachev <neon_cyrex@mail.ru> (maintainer)

5 files changed, 75 insertions, 480 deletions

diff --git a/games/mangos/Makefile b/games/mangos/Makefile
index 4a8762e1010f..c4195b96be53 100644
--- a/games/mangos/Makefile
+++ b/games/mangos/Makefile
@@ -6,13 +6,13 @@
 #
 
 PORTNAME=	mangos
-PORTVERSION=	4572
+PORTVERSION=	4742
 CATEGORIES=	games
 MASTER_SITES=	CENKES http://mangos-port.by.ru/ \
 		http://wow.omsktele.com/src/ \
 		http://belnetwork.org/mangos/
 DISTFILES=	${PORTNAME}-${DISTVERSION}${EXTRACT_SUFX}
-SCRIPTDEV2REV=	139
+SCRIPTDEV2REV=	164
 
 MAINTAINER=    	neon_cyrex@mail.ru
 COMMENT=	Free dedicated-server for World of Warcraft
@@ -44,7 +44,7 @@ PLIST_SUB+=	SD2="@comment "
 .endif
 .ifdef WITH_DBC
 PLIST_SUB+=	DBC=""
-DISTFILES+=	mangos-dbc2_1_3.tar.gz
+DISTFILES+=	mangos-dbc2_2_3.tar.gz
 .else
 PLIST_SUB+=	DBC="@comment "
 .endif
@@ -60,14 +60,14 @@ post-extract:
 	@${MV} ${WRKDIR}/ScriptDev2-${SCRIPTDEV2REV} ${WRKSRC}/src/bindings/ScriptDev2/
 .endif
 	@${LN} -s ${LTMAIN} ${WRKSRC}/
+	@${RM} ${WRKSRC}/sql/updates/Makefile.am
+	@cd ${WRKSRC}/sql/ && ${TAR} -czf updates.tar.gz updates
 
 post-patch:
 	@${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
-	@cd ${WRKSRC}/sql/updates/&&${REINPLACE_CMD} -e '/pkgdata_DATA/,$$d' Makefile.am\
-		&&${ECHO_CMD} "pkgdata_DATA=`echo *.sql README`">>Makefile.am
 .ifdef WITH_SCRIPTDEV2
 	@cd ${WRKSRC}/src/bindings/ScriptDev2/sql/Updates/&&\
 		${REINPLACE_CMD} -e '/pkgdata_DATA/,$$d' Makefile.am\
diff --git a/games/mangos/distinfo b/games/mangos/distinfo
index 31f9d2193687..485e15418a40 100644
--- a/games/mangos/distinfo
+++ b/games/mangos/distinfo
@@ -1,9 +1,9 @@
-MD5 (mangos-4572.tar.gz) = 454474cf949d08d41487076b5c787e33
-SHA256 (mangos-4572.tar.gz) = 06d8a8b13cd83da774e27845b71e17147b33b0678011b1b283a9bdad8bfd67b8
-SIZE (mangos-4572.tar.gz) = 4412791
-MD5 (ScriptDev2-139.tar.gz) = f658ce31c1cdb0c8fc3f3f2e61ad9057
-SHA256 (ScriptDev2-139.tar.gz) = a6ee03d83c3b168092d9fe3c0c4338b62a29d6708c4d5476b4ed705d064a602a
-SIZE (ScriptDev2-139.tar.gz) = 271781
-MD5 (mangos-dbc2_1_3.tar.gz) = 05eda19e4658f5fe59bb33aa48b83796
-SHA256 (mangos-dbc2_1_3.tar.gz) = 2d7eebbba390f5d853cfe066aa54aea76e7c07217ec949b1aaa16c8b35573aa3
-SIZE (mangos-dbc2_1_3.tar.gz) = 4257454
+MD5 (mangos-4742.tar.gz) = 704ccf9c72a243c3ebd91b6c1add2980
+SHA256 (mangos-4742.tar.gz) = 32b250d32c089a2342a3041344e7158ced875cb34bb2649a88c2e843f68ec65a
+SIZE (mangos-4742.tar.gz) = 4462143
+MD5 (ScriptDev2-164.tar.gz) = f73ad6485bcae05be33515ebf19541e4
+SHA256 (ScriptDev2-164.tar.gz) = a84cc4cb77e9a0b0c7152fe47024d16ccfd64420359a129dd10cb12083ab7722
+SIZE (ScriptDev2-164.tar.gz) = 347461
+MD5 (mangos-dbc2_2_3.tar.gz) = a935f4b8b1dd53bd34b8117979bdde40
+SHA256 (mangos-dbc2_2_3.tar.gz) = f30ae8765b38b1ead330df60a3354dbe5499079d22c2a151d08e67c9cc147061
+SIZE (mangos-dbc2_2_3.tar.gz) = 4314055
diff --git a/games/mangos/files/ScriptDev2.patch b/games/mangos/files/ScriptDev2.patch
index 94b367afc19e..e08278cc4621 100644
--- a/games/mangos/files/ScriptDev2.patch
+++ b/games/mangos/files/ScriptDev2.patch
@@ -1,14 +1,6 @@
---- 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
---- configure.ac
+--- configure.ac.orig
 +++ configure.ac
-@@ -192,7 +192,9 @@
+@@ -222,7 +222,9 @@
     src/mangosd/Makefile
     src/mangosd/mangosd.conf
     src/bindings/Makefile
@@ -19,7 +11,15 @@
  ])
  
  ## Disabled Makefiles, until they are ready for a successful make and
---- src/mangosd/Makefile.am
+--- src/bindings/Makefile.am.orig
++++ 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
+--- src/mangosd/Makefile.am.orig
 +++ src/mangosd/Makefile.am
 @@ -33,8 +33,8 @@
  	WorldRunnable.h
diff --git a/games/mangos/files/patch-sqlupdates b/games/mangos/files/patch-sqlupdates
new file mode 100644
index 000000000000..674dcac36654
--- /dev/null
+++ b/games/mangos/files/patch-sqlupdates
@@ -0,0 +1,37 @@
+--- configure.ac.orig
++++ configure.ac
+@@ -212,7 +212,6 @@
+    doc/Makefile
+    Makefile
+    sql/Makefile
+-   sql/updates/Makefile
+    src/Makefile
+    src/framework/Makefile
+    src/shared/Makefile
+--- sql/Makefile.am.orig
++++ sql/Makefile.am
+@@ -17,7 +17,6 @@
+ ## Process this file with automake to produce Makefile.in
+ 
+ ## Sub-directories to parse
+-SUBDIRS = updates
+ 
+ ## Change installation location
+ #  datadir = mangos/sql
+@@ -30,7 +29,8 @@
+ 	realmd.sql \
+ 	characters.sql \
+ 	create_mysql.sql \
+-	drop_mysql.sql
++	drop_mysql.sql \
++	updates.tar.gz
+ 
+ ## Additional files to include when running 'make dist'
+ #  SQL files for MaNGOS database
+@@ -39,4 +39,5 @@
+ 	drop_mysql.sql \
+ 	characters.sql \
+ 	mangos.sql \
+-	realmd.sql
++	realmd.sql \
++	updates.tar.gz
diff --git a/games/mangos/pkg-plist b/games/mangos/pkg-plist
index 3ce574f5c7b5..b83fbe70ad33 100644
--- a/games/mangos/pkg-plist
+++ b/games/mangos/pkg-plist
@@ -18,460 +18,8 @@ lib/libmangosscript.so.0
 %%DATADIR%%/sql/drop_mysql.sql
 %%DATADIR%%/sql/mangos.sql
 %%DATADIR%%/sql/realmd.sql
-%%DATADIR%%/sql/updates/1150_character_aura.sql
-%%DATADIR%%/sql/updates/1155_commands.sql
-%%DATADIR%%/sql/updates/1155_npc_option.sql
-%%DATADIR%%/sql/updates/1158_character_inventory.sql
-%%DATADIR%%/sql/updates/1186_game_weather.sql
-%%DATADIR%%/sql/updates/1208_npc_trainer.sql
-%%DATADIR%%/sql/updates/1250_item_template.sql
-%%DATADIR%%/sql/updates/1262_areatrigger_tavern.sql
-%%DATADIR%%/sql/updates/1262_game_graveyard.sql
-%%DATADIR%%/sql/updates/1282_playercreateinfo.sql
-%%DATADIR%%/sql/updates/1282_playercreateinfo_item.sql
-%%DATADIR%%/sql/updates/1292_loot_template.sql
-%%DATADIR%%/sql/updates/1332_character_queststatus.sql
-%%DATADIR%%/sql/updates/1336_item_template.sql
-%%DATADIR%%/sql/updates/1339_areatrigger_city.sql
-%%DATADIR%%/sql/updates/1349_areatrigger_involvedrelation.sql
-%%DATADIR%%/sql/updates/1349_character_aura.sql
-%%DATADIR%%/sql/updates/1349_character_inventory.sql
-%%DATADIR%%/sql/updates/1349_creature_template.sql
-%%DATADIR%%/sql/updates/1349_gameobject_template.sql
-%%DATADIR%%/sql/updates/1356_item_template.sql
-%%DATADIR%%/sql/updates/1411_item_template.sql
-%%DATADIR%%/sql/updates/1447_quest_template.sql
-%%DATADIR%%/sql/updates/1465_build_realmd_db.sql
-%%DATADIR%%/sql/updates/1465_create_realmd_db.sql
-%%DATADIR%%/sql/updates/1465_populate_realmd_db.sql
-%%DATADIR%%/sql/updates/1475_character_aura.sql
-%%DATADIR%%/sql/updates/1511_object_involvedrelation.sql
-%%DATADIR%%/sql/updates/1511_object_questrelation.sql
-%%DATADIR%%/sql/updates/1526_npc_vendor.sql
-%%DATADIR%%/sql/updates/1562_creature_template.sql
-%%DATADIR%%/sql/updates/1576_command.sql
-%%DATADIR%%/sql/updates/1595_area_graveyard.sql
-%%DATADIR%%/sql/updates/1601_game_addons.sql
-%%DATADIR%%/sql/updates/1615_areatrigger_graveyard.sql
-%%DATADIR%%/sql/updates/1635_character.sql
-%%DATADIR%%/sql/updates/1669_character_spell.sql
-%%DATADIR%%/sql/updates/1676_game_graveyard.sql
-%%DATADIR%%/sql/updates/1676_game_tele.sql
-%%DATADIR%%/sql/updates/1687_loot_template.sql
-%%DATADIR%%/sql/updates/1704_item_template.sql
-%%DATADIR%%/sql/updates/1799_quest_template.sql
-%%DATADIR%%/sql/updates/1825_game_corpse.sql
-%%DATADIR%%/sql/updates/1856_command.sql
-%%DATADIR%%/sql/updates/1865_command.sql
-%%DATADIR%%/sql/updates/1880_command.sql
-%%DATADIR%%/sql/updates/1883_quest_template.sql
-%%DATADIR%%/sql/updates/1915_loot_template.sql
-%%DATADIR%%/sql/updates/1935_command.sql
-%%DATADIR%%/sql/updates/1949_corpse.sql
-%%DATADIR%%/sql/updates/1953_playercreateinfo_skill.sql
-%%DATADIR%%/sql/updates/1953_playercreateinfo_spell.sql
-%%DATADIR%%/sql/updates/1956_command.sql
-%%DATADIR%%/sql/updates/2017_quest_template.sql
-%%DATADIR%%/sql/updates/2033_command.sql
-%%DATADIR%%/sql/updates/2041_auctionhouse_bid.sql
-%%DATADIR%%/sql/updates/2041_game_spell.sql
-%%DATADIR%%/sql/updates/2041_game_talent.sql
-%%DATADIR%%/sql/updates/2047_quest_template.sql
-%%DATADIR%%/sql/updates/2054_command.sql
-%%DATADIR%%/sql/updates/2058_command.sql
-%%DATADIR%%/sql/updates/2066_creature_template.sql
-%%DATADIR%%/sql/updates/2069_quest_template.sql
-%%DATADIR%%/sql/updates/2079_command.sql
-%%DATADIR%%/sql/updates/2099_npc_trainer.sql
-%%DATADIR%%/sql/updates/2107_command.sql
-%%DATADIR%%/sql/updates/2113_command.sql
-%%DATADIR%%/sql/updates/2118_playercreateinfo_spell.sql
-%%DATADIR%%/sql/updates/2119_command.sql
-%%DATADIR%%/sql/updates/2130_quest_template.sql
-%%DATADIR%%/sql/updates/2131_command.sql
-%%DATADIR%%/sql/updates/2156_character.sql
-%%DATADIR%%/sql/updates/2164_command.sql
-%%DATADIR%%/sql/updates/2191_npc_trainer.sql
-%%DATADIR%%/sql/updates/2191_playercreateinfo.sql
-%%DATADIR%%/sql/updates/2220_command.sql
-%%DATADIR%%/sql/updates/2297_character_stable.sql
-%%DATADIR%%/sql/updates/2302_player_levelupgains.sql
-%%DATADIR%%/sql/updates/2308_character_pet.sql
-%%DATADIR%%/sql/updates/2330_realmlist.sql
-%%DATADIR%%/sql/updates/2343_areatrigger_template.sql
-%%DATADIR%%/sql/updates/2352_quest_template.sql
-%%DATADIR%%/sql/updates/2357_playercreateinfo_action.sql
-%%DATADIR%%/sql/updates/2359_command.sql
-%%DATADIR%%/sql/updates/2360_creature_template.sql
-%%DATADIR%%/sql/updates/2362_areatrigger_template.sql
-%%DATADIR%%/sql/updates/2367_command.sql
-%%DATADIR%%/sql/updates/2369_creature_template.sql
-%%DATADIR%%/sql/updates/2370_character_queststatus.sql
-%%DATADIR%%/sql/updates/2372_creature_template.sql
-%%DATADIR%%/sql/updates/2382_mail_item.sql
-%%DATADIR%%/sql/updates/2383_auctionhouse_item.sql
-%%DATADIR%%/sql/updates/2418_quest_template.sql
-%%DATADIR%%/sql/updates/2421_quest_template.sql
-%%DATADIR%%/sql/updates/2424_gameobject_template.sql
-%%DATADIR%%/sql/updates/2429_taxi.sql
-%%DATADIR%%/sql/updates/2445_command.sql
-%%DATADIR%%/sql/updates/2448_command.sql
-%%DATADIR%%/sql/updates/2448_game_graveyard.sql
-%%DATADIR%%/sql/updates/2454_command.sql
-%%DATADIR%%/sql/updates/2467_quest_template.sql
-%%DATADIR%%/sql/updates/2468_command.sql
-%%DATADIR%%/sql/updates/2469_skinning_loot_template.sql
-%%DATADIR%%/sql/updates/2479_loot_template.sql
-%%DATADIR%%/sql/updates/2494_command.sql
-%%DATADIR%%/sql/updates/2495_item_loot_template.sql
-%%DATADIR%%/sql/updates/2500_command.sql
-%%DATADIR%%/sql/updates/2513_guild_rank.sql
-%%DATADIR%%/sql/updates/2516_auctionhouse.sql
-%%DATADIR%%/sql/updates/2517_guild_charters.sql
-%%DATADIR%%/sql/updates/2518_guild.sql
-%%DATADIR%%/sql/updates/2530_loot_template.sql
-%%DATADIR%%/sql/updates/2549_character.sql
-%%DATADIR%%/sql/updates/2571_quest_template.sql
-%%DATADIR%%/sql/updates/2572_creature_template.sql
-%%DATADIR%%/sql/updates/2578_character.sql
-%%DATADIR%%/sql/updates/2580_character.sql
-%%DATADIR%%/sql/updates/2580_insatne.sql
-%%DATADIR%%/sql/updates/2584_character.sql
-%%DATADIR%%/sql/updates/2584_instance.sql
-%%DATADIR%%/sql/updates/2597_playercreateinfo_action.sql
-%%DATADIR%%/sql/updates/2597_playercreateinfo_item.sql
-%%DATADIR%%/sql/updates/2597_playercreateinfo_reputation.sql
-%%DATADIR%%/sql/updates/2597_playercreateinfo_skill.sql
-%%DATADIR%%/sql/updates/2597_playercreateinfo_spell.sql
-%%DATADIR%%/sql/updates/2598_playercreateinfo.sql
-%%DATADIR%%/sql/updates/2605_realmd_account.sql
-%%DATADIR%%/sql/updates/2610_character.sql
-%%DATADIR%%/sql/updates/2617_character_spell_cooldown.sql
-%%DATADIR%%/sql/updates/2622_character.sql
-%%DATADIR%%/sql/updates/2622_gameobject.sql
-%%DATADIR%%/sql/updates/2622_transports.sql
-%%DATADIR%%/sql/updates/2630_command.sql
-%%DATADIR%%/sql/updates/2633_character_spell_cooldown.sql
-%%DATADIR%%/sql/updates/2637_auctionhouse.sql
-%%DATADIR%%/sql/updates/2637_mail.sql
-%%DATADIR%%/sql/updates/2641_command.sql
-%%DATADIR%%/sql/updates/2642_loot_template.sql
-%%DATADIR%%/sql/updates/2649_command.sql
-%%DATADIR%%/sql/updates/2660_command.sql
-%%DATADIR%%/sql/updates/2663_command.sql
-%%DATADIR%%/sql/updates/2670_command.sql
-%%DATADIR%%/sql/updates/2674_quest_template.sql
-%%DATADIR%%/sql/updates/2674_scripts.sql
-%%DATADIR%%/sql/updates/2680_game_addons.sql
-%%DATADIR%%/sql/updates/2684_gameobject.sql
-%%DATADIR%%/sql/updates/2684_quest_template.sql
-%%DATADIR%%/sql/updates/2688_command.sql
-%%DATADIR%%/sql/updates/2688_player_levelstats.sql
-%%DATADIR%%/sql/updates/2688_playercreateinfo.sql
-%%DATADIR%%/sql/updates/2689_player_levelstats.sql
-%%DATADIR%%/sql/updates/2691_player_levelupgains.sql
-%%DATADIR%%/sql/updates/2699_character_inventory.sql
-%%DATADIR%%/sql/updates/2703_command.sql
-%%DATADIR%%/sql/updates/2713_quest_template.sql
-%%DATADIR%%/sql/updates/2746_command.sql
-%%DATADIR%%/sql/updates/2746_creature.sql
-%%DATADIR%%/sql/updates/2754_realmd.sql
-%%DATADIR%%/sql/updates/2762_command.sql
-%%DATADIR%%/sql/updates/2765_auctionHouse.sql
-%%DATADIR%%/sql/updates/2765_mail.sql
-%%DATADIR%%/sql/updates/2778_command.sql
-%%DATADIR%%/sql/updates/2787_item_instance.sql
-%%DATADIR%%/sql/updates/2798_command.sql
-%%DATADIR%%/sql/updates/2803_command.sql
-%%DATADIR%%/sql/updates/2808_command.sql
-%%DATADIR%%/sql/updates/2812_character_pet.sql
-%%DATADIR%%/sql/updates/2812_pet_name_generation.sql
-%%DATADIR%%/sql/updates/2815_character_pet.sql
-%%DATADIR%%/sql/updates/2821_raidgroups.sql
-%%DATADIR%%/sql/updates/2828_character.sql
-%%DATADIR%%/sql/updates/2838_corpse_grid.sql
-%%DATADIR%%/sql/updates/2838_creature_grid.sql
-%%DATADIR%%/sql/updates/2838_gameobject_grid.sql
-%%DATADIR%%/sql/updates/2842_character_pet.sql
-%%DATADIR%%/sql/updates/2843_character_pet.sql
-%%DATADIR%%/sql/updates/2850_command.sql
-%%DATADIR%%/sql/updates/2869_command.sql
-%%DATADIR%%/sql/updates/2875_npc_trainer.sql
-%%DATADIR%%/sql/updates/2875_spell_chain.sql
-%%DATADIR%%/sql/updates/2881_spell_chain.sql
-%%DATADIR%%/sql/updates/2885_character.sql
-%%DATADIR%%/sql/updates/2912_areatrigger_template.sql
-%%DATADIR%%/sql/updates/2916_character.sql
-%%DATADIR%%/sql/updates/2938_spell_scripts.sql
-%%DATADIR%%/sql/updates/2940_playercreateinfo_skill.sql
-%%DATADIR%%/sql/updates/2958_command.sql
-%%DATADIR%%/sql/updates/2958_scripts.sql
-%%DATADIR%%/sql/updates/2958_spell_scripts.sql
-%%DATADIR%%/sql/updates/2982_command.sql
-%%DATADIR%%/sql/updates/2993_command.sql
-%%DATADIR%%/sql/updates/3005.sql
-%%DATADIR%%/sql/updates/3010_item_template.sql
-%%DATADIR%%/sql/updates/3017_auctionhouse.sql
-%%DATADIR%%/sql/updates/3020_command.sql
-%%DATADIR%%/sql/updates/3032_creature.sql
-%%DATADIR%%/sql/updates/3044_gameobject_template.sql
-%%DATADIR%%/sql/updates/3054_command.sql
-%%DATADIR%%/sql/updates/3059_pet_levelstats.sql
-%%DATADIR%%/sql/updates/3068_command.sql
-%%DATADIR%%/sql/updates/3075_creature.sql
-%%DATADIR%%/sql/updates/3075_gameobject.sql
-%%DATADIR%%/sql/updates/3090_command.sql
-%%DATADIR%%/sql/updates/3090_creature_template.sql
-%%DATADIR%%/sql/updates/3090_loot_template.sql
-%%DATADIR%%/sql/updates/3091_spell_proc_event.sql
-%%DATADIR%%/sql/updates/3092_quest_template.sql
-%%DATADIR%%/sql/updates/3096_spell_proc_event.sql
-%%DATADIR%%/sql/updates/3106_command.sql
-%%DATADIR%%/sql/updates/3107_playercreateinfo_skill.sql
-%%DATADIR%%/sql/updates/3108_quest_template.sql
-%%DATADIR%%/sql/updates/3110_quest_template.sql
-%%DATADIR%%/sql/updates/3115_quest_template.sql
-%%DATADIR%%/sql/updates/3138_character_inventory.sql
-%%DATADIR%%/sql/updates/3138_disenchaning_loot_template.sql
-%%DATADIR%%/sql/updates/3138_item_template.sql
-%%DATADIR%%/sql/updates/3141_spell_threat.sql
-%%DATADIR%%/sql/updates/3144_command.sql
-%%DATADIR%%/sql/updates/3150_command.sql
-%%DATADIR%%/sql/updates/3162_character_queststatus.sql
-%%DATADIR%%/sql/updates/3162_command.sql
-%%DATADIR%%/sql/updates/3162_quest_template.sql
-%%DATADIR%%/sql/updates/3174_command.sql
-%%DATADIR%%/sql/updates/3179_quest_template.sql
-%%DATADIR%%/sql/updates/3180_spell_proc_event.sql
-%%DATADIR%%/sql/updates/3183_command.sql
-%%DATADIR%%/sql/updates/3186_command.sql
-%%DATADIR%%/sql/updates/3202_character_gifts.sql
-%%DATADIR%%/sql/updates/3205_character_inventory.sql
-%%DATADIR%%/sql/updates/3231_quest_template.sql
-%%DATADIR%%/sql/updates/3245_item_text.sql
-%%DATADIR%%/sql/updates/3245_mail.sql
-%%DATADIR%%/sql/updates/3245_page_text.sql
-%%DATADIR%%/sql/updates/3246_character_reputation.sql
-%%DATADIR%%/sql/updates/3251_commands.sql
-%%DATADIR%%/sql/updates/3252.sql
-%%DATADIR%%/sql/updates/3296_commands.sql
-%%DATADIR%%/sql/updates/3296_playercreateinfo_skill.sql
-%%DATADIR%%/sql/updates/3296_spell_learn_skill.sql
-%%DATADIR%%/sql/updates/3310_spell_learn_spell.sql
-%%DATADIR%%/sql/updates/3316_playercreateinfo_reputation.sql
-%%DATADIR%%/sql/updates/3323.sql
-%%DATADIR%%/sql/updates/3344_playercreateinfo_spell.sql
-%%DATADIR%%/sql/updates/3346_command.sql
-%%DATADIR%%/sql/updates/3348_playercreateinfo_spell.sql
-%%DATADIR%%/sql/updates/3350_command.sql
-%%DATADIR%%/sql/updates/3351_character_pet.sql
-%%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/3860_creature_template.sql
-%%DATADIR%%/sql/updates/3862_prospecting_loot_template.sql
-%%DATADIR%%/sql/updates/3874_spell_scripts.sql
-%%DATADIR%%/sql/updates/3875_item_template.sql
-%%DATADIR%%/sql/updates/3876_character_ticket.sql
-%%DATADIR%%/sql/updates/3884_quest_scripts.sql
-%%DATADIR%%/sql/updates/3891_quest_scripts.sql
-%%DATADIR%%/sql/updates/3906_areatrigger_template.sql
-%%DATADIR%%/sql/updates/3929_spell_affect.sql
-%%DATADIR%%/sql/updates/3932_item_enchantment_template.sql
-%%DATADIR%%/sql/updates/3932_item_template.sql
-%%DATADIR%%/sql/updates/3939_realmd_account.sql
-%%DATADIR%%/sql/updates/3948_realmd_account.sql
-%%DATADIR%%/sql/updates/3951_exploration_basexp.sql
-%%DATADIR%%/sql/updates/3961_uptime.sql
-%%DATADIR%%/sql/updates/3964_command.sql
-%%DATADIR%%/sql/updates/4010_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4012_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4018_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4019_spell_chain.sql
-%%DATADIR%%/sql/updates/4019_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4020_spell_chain.sql
-%%DATADIR%%/sql/updates/4020_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4021_spell_chain.sql
-%%DATADIR%%/sql/updates/4021_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4023_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4026_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4028_spell_chain.sql
-%%DATADIR%%/sql/updates/4028_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4031_spell_chain.sql
-%%DATADIR%%/sql/updates/4031_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4035_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4036_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4037_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4058.sql
-%%DATADIR%%/sql/updates/4059_spell_learn_skill.sql
-%%DATADIR%%/sql/updates/4059_spell_learn_spell.sql
-%%DATADIR%%/sql/updates/4076_playercreateinfo_spell.sql
-%%DATADIR%%/sql/updates/4076_character_spell.sql
-%%DATADIR%%/sql/updates/4081_command.sql
-%%DATADIR%%/sql/updates/4096_pet.sql
-%%DATADIR%%/sql/updates/4116_creature_template.sql
-%%DATADIR%%/sql/updates/4133_command.sql
-%%DATADIR%%/sql/updates/4133_spell_chain.sql
-%%DATADIR%%/sql/updates/4134_command.sql
-%%DATADIR%%/sql/updates/4139_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4140_command.sql
-%%DATADIR%%/sql/updates/4145_character_reputation.sql
-%%DATADIR%%/sql/updates/4154_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4176_character.sql
-%%DATADIR%%/sql/updates/4176_command.sql
-%%DATADIR%%/sql/updates/4187_command.sql
-%%DATADIR%%/sql/updates/4204_command.sql
-%%DATADIR%%/sql/updates/4205_creature_template.sql
-%%DATADIR%%/sql/updates/4224_character_aura.sql
-%%DATADIR%%/sql/updates/4224_pet_aura.sql
-%%DATADIR%%/sql/updates/4235_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4239_spell_chain.sql
-%%DATADIR%%/sql/updates/4239_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4242_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4243_spell_affect.sql
-%%DATADIR%%/sql/updates/4248_spell_chain.sql
-%%DATADIR%%/sql/updates/4248_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4252_spell_threat.sql
-%%DATADIR%%/sql/updates/4255_spell_chain.sql
-%%DATADIR%%/sql/updates/4258_command.sql
-%%DATADIR%%/sql/updates/4259_spell_chain.sql
-%%DATADIR%%/sql/updates/4259_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4262_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4266_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4267_command.sql
-%%DATADIR%%/sql/updates/4270_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4272_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4274_character_pet.sql
-%%DATADIR%%/sql/updates/4275_game_event.sql
-%%DATADIR%%/sql/updates/4288_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4294_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4296_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4317_spell_affect.sql
-%%DATADIR%%/sql/updates/4320_spell_affect.sql
-%%DATADIR%%/sql/updates/4331_spell_chain.sql
-%%DATADIR%%/sql/updates/4331_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4341_game_event.sql
-%%DATADIR%%/sql/updates/4356_command.sql
-%%DATADIR%%/sql/updates/4369_battleground_template.sql
-%%DATADIR%%/sql/updates/4376_battleground_template.sql
-%%DATADIR%%/sql/updates/4392_battleground_template.sql
-%%DATADIR%%/sql/updates/4395_spell_chain.sql
-%%DATADIR%%/sql/updates/4397_command.sql
-%%DATADIR%%/sql/updates/4401_spell_chain.sql
-%%DATADIR%%/sql/updates/4403_reserved_name.sql
-%%DATADIR%%/sql/updates/4407_character.sql
-%%DATADIR%%/sql/updates/4407_character_kill.sql
-%%DATADIR%%/sql/updates/4407_command.sql
-%%DATADIR%%/sql/updates/4414_spell_chain.sql
-%%DATADIR%%/sql/updates/4414_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4417_quest_template.sql
-%%DATADIR%%/sql/updates/4420_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4422_command.sql
-%%DATADIR%%/sql/updates/4425_character.sql
-%%DATADIR%%/sql/updates/4425_command.sql
-%%DATADIR%%/sql/updates/4426_creature_template.sql
-%%DATADIR%%/sql/updates/4430_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4432_item_template.sql
-%%DATADIR%%/sql/updates/4432_spell_chain.sql
-%%DATADIR%%/sql/updates/4432_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4434_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4437_character_aura.sql
-%%DATADIR%%/sql/updates/4437_pet_aura.sql
-%%DATADIR%%/sql/updates/4439_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4446_creature_template.sql
-%%DATADIR%%/sql/updates/4464_instance.sql
-%%DATADIR%%/sql/updates/4464_instance_template.sql
-%%DATADIR%%/sql/updates/4470_command.sql
-%%DATADIR%%/sql/updates/4480_spell_affect.sql
-%%DATADIR%%/sql/updates/4481_spell_affect.sql
-%%DATADIR%%/sql/updates/4482_playercreateinfo.sql
-%%DATADIR%%/sql/updates/4482_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4488_db_version.sql
-%%DATADIR%%/sql/updates/4491_spell_affect.sql
-%%DATADIR%%/sql/updates/4496_spell_script_target.sql
-%%DATADIR%%/sql/updates/4498_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4499_spell_script_target.sql
-%%DATADIR%%/sql/updates/4501.sql
-%%DATADIR%%/sql/updates/4503_spell_chain.sql
-%%DATADIR%%/sql/updates/4503_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4504_spell_affect.sql
-%%DATADIR%%/sql/updates/4504_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4506_spell_learn_spell.sql
-%%DATADIR%%/sql/updates/4507_quest_template.sql
-%%DATADIR%%/sql/updates/4510_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4513_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4517_spell_affect.sql
-%%DATADIR%%/sql/updates/4524_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4537_player_levelstats.sql
-%%DATADIR%%/sql/updates/4540_battleground_template.sql
-%%DATADIR%%/sql/updates/4544_creature_addon.sql
-%%DATADIR%%/sql/updates/4544_creature_template_addon.sql
-%%DATADIR%%/sql/updates/4547_spell_affect.sql
-%%DATADIR%%/sql/updates/4547_spell_proc_event.sql
-%%DATADIR%%/sql/updates/4551_item_template.sql
-%%DATADIR%%/sql/updates/4556_realmlist.sql
-%%DATADIR%%/sql/updates/4561_command.sql
-%%DATADIR%%/sql/updates/4571_button_scripts.sql
-%%DATADIR%%/sql/updates/README
+%%DATADIR%%/sql/characters.sql
+%%DATADIR%%/sql/updates.tar.gz
 %%DBC%%%%DATADIR%%/dbc/AnimationData.dbc
 %%DBC%%%%DATADIR%%/dbc/AreaPOI.dbc
 %%DBC%%%%DATADIR%%/dbc/AreaTable.dbc
@@ -675,7 +223,17 @@ lib/libmangosscript.so.0
 %%SD2%%share/scriptdev2/sql/updates/r134.sql
 %%SD2%%share/scriptdev2/sql/updates/r136.sql
 %%SD2%%share/scriptdev2/sql/updates/r139.sql
-@dirrm %%DATADIR%%/sql/updates
+%%SD2%%share/scriptdev2/sql/updates/r142.sql
+%%SD2%%share/scriptdev2/sql/updates/r144.sql
+%%SD2%%share/scriptdev2/sql/updates/r145.sql
+%%SD2%%share/scriptdev2/sql/updates/r149.sql
+%%SD2%%share/scriptdev2/sql/updates/r150.sql
+%%SD2%%share/scriptdev2/sql/updates/r152.sql
+%%SD2%%share/scriptdev2/sql/updates/r153.sql
+%%SD2%%share/scriptdev2/sql/updates/r157.sql
+%%SD2%%share/scriptdev2/sql/updates/r161.sql
+%%SD2%%share/scriptdev2/sql/updates/r163.sql
+%%SD2%%share/scriptdev2/sql/updates/r164.sql
 @dirrm %%DATADIR%%/sql
 %%DBC%%@dirrm %%DATADIR%%/dbc
 @dirrm %%DATADIR%%