diff options
Diffstat (limited to 'src')
193 files changed, 0 insertions, 1643 deletions
diff --git a/src/bindings/scripts/sql/Updates/09_BraveWindfeather.sql b/src/bindings/scripts/sql/Updates/09_BraveWindfeather.sql deleted file mode 100644 index ae78c707323..00000000000 --- a/src/bindings/scripts/sql/Updates/09_BraveWindfeather.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET`ScriptName` = '' WHERE `entry` = 3209;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/11_SilvaFilnaveth.sql b/src/bindings/scripts/sql/Updates/11_SilvaFilnaveth.sql deleted file mode 100644 index 9900466b717..00000000000 --- a/src/bindings/scripts/sql/Updates/11_SilvaFilnaveth.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature` SET `id` = 11798, `curhealth` = 3857 WHERE `guid` = 46833;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/27_Vaelastraz.sql b/src/bindings/scripts/sql/Updates/27_Vaelastraz.sql deleted file mode 100644 index e57ed2107d9..00000000000 --- a/src/bindings/scripts/sql/Updates/27_Vaelastraz.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE creature_template SET faction=35 WHERE entry=13020; -UPDATE creature_template SET npcflag=65 WHERE entry=13020;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/Makefile.am b/src/bindings/scripts/sql/Updates/Makefile.am deleted file mode 100644 index e8389337a6a..00000000000 --- a/src/bindings/scripts/sql/Updates/Makefile.am +++ /dev/null @@ -1,215 +0,0 @@ -# Copyright (C) 2005,2006,2007 MaNGOS <http://www.mangosproject.org/> -# -# This program is free software; you can redistribute it and/or modify -# it under the terms of the GNU General Public License as published by -# the Free Software Foundation; either version 2 of the License, or -# (at your option) any later version. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -# GNU General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program; if not, write to the Free Software -# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -## Process this file with automake to produce Makefile.in - -## Sub-directories to parse - -## Change installation location -# datadir = scriptdev2/sql/updates -pkgdatadir = $(datadir)/scriptdev2/sql/updates - -## Files to be installed -# Install basic SQL files to datadir -pkgdata_DATA = \ - 09_BraveWindfeather.sql \ - 11_SilvaFilnaveth.sql \ - 27_Vaelastraz.sql \ - r56.sql \ - r59.sql \ - r63.sql \ - r65.sql \ - r72.sql \ - r78.sql \ - r81.sql \ - r91.sql \ - r92.sql \ - r97.sql \ - r108.sql \ - r110.sql \ - r121.sql \ - r123.sql \ - r124.sql \ - r125.sql \ - r128.sql \ - r131.sql \ - r134.sql \ - r136.sql \ - r139.sql \ - r142.sql \ - r144.sql \ - r145.sql \ - r149.sql \ - r150.sql \ - r152.sql \ - r153.sql \ - r157.sql \ - r161.sql \ - r163.sql \ - r169.sql \ - r170.sql \ - r171.sql \ - r172.sql \ - r174.sql \ - r176.sql \ - r177.sql \ - r178.sql \ - r181.sql \ - r182.sql \ - r183.sql \ - r184.sql \ - r186.sql \ - r187.sql \ - r189.sql \ - r191.sql \ - r192.sql \ - r197.sql \ - r204.sql \ - r206.sql \ - r211.sql \ - r213.sql \ - r214.sql \ - r215.sql \ - r218.sql \ - r219.sql \ - r221_scriptdev2.sql \ - r227_scriptdev2.sql \ - r230_mangos.sql \ - r234_mangos.sql \ - r237_mangos.sql \ - r238_mangos.sql \ - r239_mangos.sql \ - r240_scriptdev2.sql \ - r241_mangos.sql \ - r242_mangos.sql \ - r243_mangos.sql \ - r249_mangos.sql \ - r250_mangos.sql \ - r253_mangos.sql \ - r255_mangos.sql \ - r256_mangos.sql \ - r257_mangos.sql \ - r258_mangos.sql \ - r260_mangos.sql \ - r261_mangos.sql \ - r262_mangos.sql \ - r263_mangos.sql \ - r264_mangos.sql \ - r265_mangos.sql \ - r269_mangos.sql \ - r270_mangos.sql \ - r271_mangos.sql \ - r272_mangos.sql \ - r273_mangos.sql \ - r274_mangos.sql \ - r275_mangos.sql \ - r281_scriptdev2.sql \ - r282_mangos.sql \ - r286_mangos.sql \ - r289_mangos.sql \ - r291_mangos.sql \ - r295_mangos.sql \ - r297_mangos.sql \ - r298_scriptdev2.sql \ - r299_scriptdev2.sql \ - r304_mangos.sql \ - r306_scriptdev2.sql \ - r307_mangos.sql \ - r308_mangos.sql \ - r309_mangos.sql \ - r311_mangos.sql \ - r312_mangos.sql \ - r318_mangos.sql \ - r324_mangos.sql \ - r327_mangos.sql \ - r332_scriptdev2.sql \ - r333_mangos.sql \ - r334_mangos.sql \ - r336_mangos.sql \ - r352_mangos.sql \ - r355_mangos.sql \ - r358_mangos.sql \ - r364_mangos.sql \ - r367_mangos.sql \ - r368_mangos.sql \ - r369_mangos.sql \ - r374_mangos.sql \ - r386_mangos.sql \ - r417_mangos.sql \ - r428_mangos.sql \ - r431_mangos.sql \ - r444_mangos.sql \ - r445_mangos.sql \ - r446_mangos.sql \ - r448_scriptdev2.sql \ - r462_mangos.sql \ - r465_mangos.sql \ - r467_mangos.sql \ - r473_mangos.sql \ - r476_mangos.sql \ - r477_mangos.sql \ - r479_mangos.sql \ - r482_mangos.sql \ - r484_mangos.sql \ - r486_mangos.sql \ - r487_mangos.sql \ - r494_mangos.sql \ - r501_mangos.sql \ - r513_mangos.sql \ - r514_mangos.sql \ - r515_mangos.sql \ - r516_mangos.sql \ - r517_mangos.sql \ - r518_mangos.sql \ - r519_mangos.sql \ - r520_mangos.sql \ - r521_mangos.sql \ - r522_mangos.sql \ - r526_mangos.sql \ - r528_mangos.sql \ - r533_mangos.sql \ - r538_scriptdev2.sql \ - r547_mangos.sql \ - r554_mangos.sql \ - r555_mangos.sql \ - r575_mangos.sql \ - r576_mangos.sql \ - r578_mangos.sql \ - r584_mangos.sql \ - r590_mangos.sql \ - r591_mangos.sql \ - r593_mangos.sql \ - r594_mangos.sql \ - r596_mangos.sql \ - r610_mangos.sql \ - r615_scriptdev2.sql \ - r617_mangos.sql \ - r621_mangos.sql \ - r628_mangos.sql \ - r632_mangos.sql \ - r633_mangos.sql \ - r634_scriptdev2.sql \ - r636_mangos.sql \ - r637_mangos.sql \ - r638_mangos.sql \ - r639_mangos.sql \ - r642_mangos.sql \ - r643_mangos.sql \ - r646_mangos.sql \ - r647_scriptdev2.sql \ - r656_scriptdev2.sql \ - r658_mangos.sql \ - r659_mangos.sql diff --git a/src/bindings/scripts/sql/Updates/Makefile.in b/src/bindings/scripts/sql/Updates/Makefile.in deleted file mode 100644 index 9b43048f032..00000000000 --- a/src/bindings/scripts/sql/Updates/Makefile.in +++ /dev/null @@ -1,383 +0,0 @@ -# Makefile.in generated by automake 1.9.6 from Makefile.am. -# @configure_input@ - -# Copyright (C) 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, -# 2003, 2004, 2005 Free Software Foundation, Inc. -# This Makefile.in is free software; the Free Software Foundation -# gives unlimited permission to copy and/or distribute it, -# with or without modifications, as long as this notice is preserved. - -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY, to the extent permitted by law; without -# even the implied warranty of MERCHANTABILITY or FITNESS FOR A -# PARTICULAR PURPOSE. - -@SET_MAKE@ - -# Copyright (C) 2005,2006,2007 MaNGOS <http://www.mangosproject.org/> -# -# This program is free software; you can redistribute it and/or modify -# it under the terms of the GNU General Public License as published by -# the Free Software Foundation; either version 2 of the License, or -# (at your option) any later version. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -# GNU General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program; if not, write to the Free Software -# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -srcdir = @srcdir@ -top_srcdir = @top_srcdir@ -VPATH = @srcdir@ -pkglibdir = $(libdir)/@PACKAGE@ -pkgincludedir = $(includedir)/@PACKAGE@ -top_builddir = ../../../../.. -am__cd = CDPATH="$${ZSH_VERSION+.}$(PATH_SEPARATOR)" && cd -INSTALL = @INSTALL@ -install_sh_DATA = $(install_sh) -c -m 644 -install_sh_PROGRAM = $(install_sh) -c -install_sh_SCRIPT = $(install_sh) -c -INSTALL_HEADER = $(INSTALL_DATA) -transform = $(program_transform_name) -NORMAL_INSTALL = : -PRE_INSTALL = : -POST_INSTALL = : -NORMAL_UNINSTALL = : -PRE_UNINSTALL = : -POST_UNINSTALL = : -build_triplet = @build@ -host_triplet = @host@ -subdir = src/bindings/ScriptDev2/sql/Updates -DIST_COMMON = $(srcdir)/Makefile.am $(srcdir)/Makefile.in -ACLOCAL_M4 = $(top_srcdir)/aclocal.m4 -am__aclocal_m4_deps = $(top_srcdir)/configure.ac -am__configure_deps = $(am__aclocal_m4_deps) $(CONFIGURE_DEPENDENCIES) \ - $(ACLOCAL_M4) -mkinstalldirs = $(install_sh) -d -CONFIG_HEADER = $(top_builddir)/config.h -CONFIG_CLEAN_FILES = -SOURCES = -DIST_SOURCES = -am__vpath_adj_setup = srcdirstrip=`echo "$(srcdir)" | sed 's|.|.|g'`; -am__vpath_adj = case $$p in \ - $(srcdir)/*) f=`echo "$$p" | sed "s|^$$srcdirstrip/||"`;; \ - *) f=$$p;; \ - esac; -am__strip_dir = `echo $$p | sed -e 's|^.*/||'`; -am__installdirs = "$(DESTDIR)$(pkgdatadir)" -pkgdataDATA_INSTALL = $(INSTALL_DATA) -DATA = $(pkgdata_DATA) -DISTFILES = $(DIST_COMMON) $(DIST_SOURCES) $(TEXINFOS) $(EXTRA_DIST) - -# datadir = scriptdev2/sql/updates -pkgdatadir = $(datadir)/scriptdev2/sql/updates -ACLOCAL = @ACLOCAL@ -AMDEP_FALSE = @AMDEP_FALSE@ -AMDEP_TRUE = @AMDEP_TRUE@ -AMTAR = @AMTAR@ -AR = @AR@ -AUTOCONF = @AUTOCONF@ -AUTOHEADER = @AUTOHEADER@ -AUTOMAKE = @AUTOMAKE@ -AWK = @AWK@ -CC = @CC@ -CCDEPMODE = @CCDEPMODE@ -CFLAGS = @CFLAGS@ -COMPATLIB = @COMPATLIB@ -CPP = @CPP@ -CPPFLAGS = @CPPFLAGS@ -CXX = @CXX@ -CXXCPP = @CXXCPP@ -CXXDEPMODE = @CXXDEPMODE@ -CXXFLAGS = @CXXFLAGS@ -CYGPATH_W = @CYGPATH_W@ -DEFS = @DEFS@ -DEPDIR = @DEPDIR@ -DOXYGENPATH = @DOXYGENPATH@ -ECHO = @ECHO@ -ECHO_C = @ECHO_C@ -ECHO_N = @ECHO_N@ -ECHO_T = @ECHO_T@ -EGREP = @EGREP@ -EXEEXT = @EXEEXT@ -F77 = @F77@ -FFLAGS = @FFLAGS@ -GREP = @GREP@ -INSTALL_DATA = @INSTALL_DATA@ -INSTALL_PROGRAM = @INSTALL_PROGRAM@ -INSTALL_SCRIPT = @INSTALL_SCRIPT@ -INSTALL_STRIP_PROGRAM = @INSTALL_STRIP_PROGRAM@ -LDFLAGS = @LDFLAGS@ -LIBOBJS = @LIBOBJS@ -LIBS = @LIBS@ -LIBTOOL = @LIBTOOL@ -LN_S = @LN_S@ -LTLIBOBJS = @LTLIBOBJS@ -MAINT = @MAINT@ -MAINTAINER_MODE_FALSE = @MAINTAINER_MODE_FALSE@ -MAINTAINER_MODE_TRUE = @MAINTAINER_MODE_TRUE@ -MAKEINFO = @MAKEINFO@ -MANGOSD_DEBUG_INFO = @MANGOSD_DEBUG_INFO@ -MANGOSD_ENABLE_CLI = @MANGOSD_ENABLE_CLI@ -MANGOSD_ENABLE_RA = @MANGOSD_ENABLE_RA@ -MYSQL_CONFIG = @MYSQL_CONFIG@ -MYSQL_INCLUDES = @MYSQL_INCLUDES@ -MYSQL_LIBS = @MYSQL_LIBS@ -OBJEXT = @OBJEXT@ -PACKAGE = @PACKAGE@ -PACKAGE_BUGREPORT = @PACKAGE_BUGREPORT@ -PACKAGE_NAME = @PACKAGE_NAME@ -PACKAGE_STRING = @PACKAGE_STRING@ -PACKAGE_TARNAME = @PACKAGE_TARNAME@ -PACKAGE_VERSION = @PACKAGE_VERSION@ -PATH_SEPARATOR = @PATH_SEPARATOR@ -RANLIB = @RANLIB@ -SET_MAKE = @SET_MAKE@ -SHELL = @SHELL@ -SSLLIB = @SSLLIB@ -STRIP = @STRIP@ -USE_DOXYGEN_FALSE = @USE_DOXYGEN_FALSE@ -USE_DOXYGEN_TRUE = @USE_DOXYGEN_TRUE@ -VERSION = @VERSION@ -ZLIB = @ZLIB@ -ac_ct_CC = @ac_ct_CC@ -ac_ct_CXX = @ac_ct_CXX@ -ac_ct_F77 = @ac_ct_F77@ -am__fastdepCC_FALSE = @am__fastdepCC_FALSE@ -am__fastdepCC_TRUE = @am__fastdepCC_TRUE@ -am__fastdepCXX_FALSE = @am__fastdepCXX_FALSE@ -am__fastdepCXX_TRUE = @am__fastdepCXX_TRUE@ -am__include = @am__include@ -am__leading_dot = @am__leading_dot@ -am__quote = @am__quote@ -am__tar = @am__tar@ -am__untar = @am__untar@ -bindir = @bindir@ -build = @build@ -build_alias = @build_alias@ -build_cpu = @build_cpu@ -build_os = @build_os@ -build_vendor = @build_vendor@ -datadir = @datadir@ -datarootdir = @datarootdir@ -docdir = @docdir@ -dvidir = @dvidir@ -exec_prefix = @exec_prefix@ -host = @host@ -host_alias = @host_alias@ -host_cpu = @host_cpu@ -host_os = @host_os@ -host_vendor = @host_vendor@ -htmldir = @htmldir@ -includedir = @includedir@ -infodir = @infodir@ -install_sh = @install_sh@ -libdir = @libdir@ -libexecdir = @libexecdir@ -localedir = @localedir@ -localstatedir = @localstatedir@ -mandir = @mandir@ -mkdir_p = @mkdir_p@ -oldincludedir = @oldincludedir@ -pdfdir = @pdfdir@ -prefix = @prefix@ -program_transform_name = @program_transform_name@ -psdir = @psdir@ -sbindir = @sbindir@ -sharedstatedir = @sharedstatedir@ -sysconfdir = @sysconfdir@ -target_alias = @target_alias@ - -# Install basic SQL files to datadir -pkgdata_DATA = \ - 09_BraveWindfeather.sql \ - 11_SilvaFilnaveth.sql \ - 27_Vaelastraz.sql - -all: all-am - -.SUFFIXES: -$(srcdir)/Makefile.in: @MAINTAINER_MODE_TRUE@ $(srcdir)/Makefile.am $(am__configure_deps) - @for dep in $?; do \ - case '$(am__configure_deps)' in \ - *$$dep*) \ - cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh \ - && exit 0; \ - exit 1;; \ - esac; \ - done; \ - echo ' cd $(top_srcdir) && $(AUTOMAKE) --gnu src/bindings/ScriptDev2/sql/Updates/Makefile'; \ - cd $(top_srcdir) && \ - $(AUTOMAKE) --gnu src/bindings/ScriptDev2/sql/Updates/Makefile -.PRECIOUS: Makefile -Makefile: $(srcdir)/Makefile.in $(top_builddir)/config.status - @case '$?' in \ - *config.status*) \ - cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh;; \ - *) \ - echo ' cd $(top_builddir) && $(SHELL) ./config.status $(subdir)/$@ $(am__depfiles_maybe)'; \ - cd $(top_builddir) && $(SHELL) ./config.status $(subdir)/$@ $(am__depfiles_maybe);; \ - esac; - -$(top_builddir)/config.status: $(top_srcdir)/configure $(CONFIG_STATUS_DEPENDENCIES) - cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh - -$(top_srcdir)/configure: @MAINTAINER_MODE_TRUE@ $(am__configure_deps) - cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh -$(ACLOCAL_M4): @MAINTAINER_MODE_TRUE@ $(am__aclocal_m4_deps) - cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh - -mostlyclean-libtool: - -rm -f *.lo - -clean-libtool: - -rm -rf .libs _libs - -distclean-libtool: - -rm -f libtool -uninstall-info-am: -install-pkgdataDATA: $(pkgdata_DATA) - @$(NORMAL_INSTALL) - test -z "$(pkgdatadir)" || $(mkdir_p) "$(DESTDIR)$(pkgdatadir)" - @list='$(pkgdata_DATA)'; for p in $$list; do \ - if test -f "$$p"; then d=; else d="$(srcdir)/"; fi; \ - f=$(am__strip_dir) \ - echo " $(pkgdataDATA_INSTALL) '$$d$$p' '$(DESTDIR)$(pkgdatadir)/$$f'"; \ - $(pkgdataDATA_INSTALL) "$$d$$p" "$(DESTDIR)$(pkgdatadir)/$$f"; \ - done - -uninstall-pkgdataDATA: - @$(NORMAL_UNINSTALL) - @list='$(pkgdata_DATA)'; for p in $$list; do \ - f=$(am__strip_dir) \ - echo " rm -f '$(DESTDIR)$(pkgdatadir)/$$f'"; \ - rm -f "$(DESTDIR)$(pkgdatadir)/$$f"; \ - done -tags: TAGS -TAGS: - -ctags: CTAGS -CTAGS: - - -distdir: $(DISTFILES) - @srcdirstrip=`echo "$(srcdir)" | sed 's|.|.|g'`; \ - topsrcdirstrip=`echo "$(top_srcdir)" | sed 's|.|.|g'`; \ - list='$(DISTFILES)'; for file in $$list; do \ - case $$file in \ - $(srcdir)/*) file=`echo "$$file" | sed "s|^$$srcdirstrip/||"`;; \ - $(top_srcdir)/*) file=`echo "$$file" | sed "s|^$$topsrcdirstrip/|$(top_builddir)/|"`;; \ - esac; \ - if test -f $$file || test -d $$file; then d=.; else d=$(srcdir); fi; \ - dir=`echo "$$file" | sed -e 's,/[^/]*$$,,'`; \ - if test "$$dir" != "$$file" && test "$$dir" != "."; then \ - dir="/$$dir"; \ - $(mkdir_p) "$(distdir)$$dir"; \ - else \ - dir=''; \ - fi; \ - if test -d $$d/$$file; then \ - if test -d $(srcdir)/$$file && test $$d != $(srcdir); then \ - cp -pR $(srcdir)/$$file $(distdir)$$dir || exit 1; \ - fi; \ - cp -pR $$d/$$file $(distdir)$$dir || exit 1; \ - else \ - test -f $(distdir)/$$file \ - || cp -p $$d/$$file $(distdir)/$$file \ - || exit 1; \ - fi; \ - done -check-am: all-am -check: check-am -all-am: Makefile $(DATA) -installdirs: - for dir in "$(DESTDIR)$(pkgdatadir)"; do \ - test -z "$$dir" || $(mkdir_p) "$$dir"; \ - done -install: install-am -install-exec: install-exec-am -install-data: install-data-am -uninstall: uninstall-am - -install-am: all-am - @$(MAKE) $(AM_MAKEFLAGS) install-exec-am install-data-am - -installcheck: installcheck-am -install-strip: - $(MAKE) $(AM_MAKEFLAGS) INSTALL_PROGRAM="$(INSTALL_STRIP_PROGRAM)" \ - install_sh_PROGRAM="$(INSTALL_STRIP_PROGRAM)" INSTALL_STRIP_FLAG=-s \ - `test -z '$(STRIP)' || \ - echo "INSTALL_PROGRAM_ENV=STRIPPROG='$(STRIP)'"` install -mostlyclean-generic: - -clean-generic: - -distclean-generic: - -test -z "$(CONFIG_CLEAN_FILES)" || rm -f $(CONFIG_CLEAN_FILES) - -maintainer-clean-generic: - @echo "This command is intended for maintainers to use" - @echo "it deletes files that may require special tools to rebuild." -clean: clean-am - -clean-am: clean-generic clean-libtool mostlyclean-am - -distclean: distclean-am - -rm -f Makefile -distclean-am: clean-am distclean-generic distclean-libtool - -dvi: dvi-am - -dvi-am: - -html: html-am - -info: info-am - -info-am: - -install-data-am: install-pkgdataDATA - -install-exec-am: - -install-info: install-info-am - -install-man: - -installcheck-am: - -maintainer-clean: maintainer-clean-am - -rm -f Makefile -maintainer-clean-am: distclean-am maintainer-clean-generic - -mostlyclean: mostlyclean-am - -mostlyclean-am: mostlyclean-generic mostlyclean-libtool - -pdf: pdf-am - -pdf-am: - -ps: ps-am - -ps-am: - -uninstall-am: uninstall-info-am uninstall-pkgdataDATA - -.PHONY: all all-am check check-am clean clean-generic clean-libtool \ - distclean distclean-generic distclean-libtool distdir dvi \ - dvi-am html html-am info info-am install install-am \ - install-data install-data-am install-exec install-exec-am \ - install-info install-info-am install-man install-pkgdataDATA \ - install-strip installcheck installcheck-am installdirs \ - maintainer-clean maintainer-clean-generic mostlyclean \ - mostlyclean-generic mostlyclean-libtool pdf pdf-am ps ps-am \ - uninstall uninstall-am uninstall-info-am uninstall-pkgdataDATA - -# Tell versions [3.59,3.63) of GNU make to not export all variables. -# Otherwise a system limit (for SysV at least) may be exceeded. -.NOEXPORT: diff --git a/src/bindings/scripts/sql/Updates/r104.sql b/src/bindings/scripts/sql/Updates/r104.sql deleted file mode 100644 index 29372b726b7..00000000000 --- a/src/bindings/scripts/sql/Updates/r104.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `gameobject_template` SET `ScriptName`='go_orb_of_command' WHERE `entry`='179879';
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r108.sql b/src/bindings/scripts/sql/Updates/r108.sql deleted file mode 100644 index 7c50fe13d77..00000000000 --- a/src/bindings/scripts/sql/Updates/r108.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_dementeddruids' WHERE `entry` = 15260;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r110.sql b/src/bindings/scripts/sql/Updates/r110.sql deleted file mode 100644 index d5bd73a2fa2..00000000000 --- a/src/bindings/scripts/sql/Updates/r110.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_illusionofjandicebarov' WHERE `entry` = 11439;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r121.sql b/src/bindings/scripts/sql/Updates/r121.sql deleted file mode 100644 index 597bf532508..00000000000 --- a/src/bindings/scripts/sql/Updates/r121.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mobs_spectral_ghostly_citizen' WHERE `entry` IN (10384, 10385); - diff --git a/src/bindings/scripts/sql/Updates/r123.sql b/src/bindings/scripts/sql/Updates/r123.sql deleted file mode 100644 index 14f73d1e2d3..00000000000 --- a/src/bindings/scripts/sql/Updates/r123.sql +++ /dev/null @@ -1,4 +0,0 @@ -UPDATE creature_template SET ScriptName = 'dashel_stonefist' WHERE entry = '4961'; -UPDATE creature_template SET ScriptName = 'blood_knight_stillblade' WHERE entry = '17768'; -UPDATE creature_template SET ScriptName = 'shattered_rumbler' WHERE entry = '17157'; -UPDATE `creature_template` SET `ScriptName`='neltharaku' WHERE `entry`='21657';
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r124.sql b/src/bindings/scripts/sql/Updates/r124.sql deleted file mode 100644 index 4b5f5cb5794..00000000000 --- a/src/bindings/scripts/sql/Updates/r124.sql +++ /dev/null @@ -1,13 +0,0 @@ --- BT Trash Mobs -UPDATE `creature_template` SET `scriptname`='mob_blacktemple' WHERE `entry` IN (22844,22845,22846,22849,22853,22855,22869,22873,22875,22876,22877,22878,22880,22881,22882,22883,22884,22945,22953,22954,23337,23339); - --- The Eye Trash Mobs -UPDATE `creature_template` SET `scriptname`='mob_the_eye' WHERE `entry` IN (20031,20032,20033,20034,20035,20039,20041,20043,20046,20052); -UPDATE `creature_template` SET `scriptname`='mob_crystalcore_devastator' WHERE `entry`='20040'; - --- Uldaman Trash Mobs -UPDATE `creature_template` SET `scriptname`='mob_uldaman' WHERE `entry` IN (4847,4852,4853,4854,4860,4861,6910,7011,7012,7022,7030,7078,7291); -UPDATE `creature_template` SET `scriptname`='mob_jadespine_basilisk' WHERE `entry`='4863'; - --- Uldaman Boss Ironaya -UPDATE `creature_template` SET `scriptname`='boss_ironaya' WHERE `entry`='7228';
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r125.sql b/src/bindings/scripts/sql/Updates/r125.sql deleted file mode 100644 index 85477c24e08..00000000000 --- a/src/bindings/scripts/sql/Updates/r125.sql +++ /dev/null @@ -1,24 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_infested_root_walker' WHERE `entry` = 22095; -UPDATE `creature_template` SET `ScriptName` = 'mob_rotting_forest_rager' WHERE `entry` = 22307; -UPDATE `creature_template` SET `ScriptName` = 'mob_netherweb_victim' WHERE `entry` = 22355; - -UPDATE `creature_template` SET `ScriptName` = 'mobs_shadow_council_covert' WHERE `entry` IN (18716, 18717, 18719); -UPDATE `creature_template` SET `npcflag` = 1 WHERE `entry` IN (18716, 18717, 18719); - -UPDATE `creature_template` SET `ScriptName` = 'mob_gurok_the_usurper' WHERE `entry` = 18182; -UPDATE `creature_template` SET `ScriptName` = 'mob_shattered_rumbler' WHERE `entry` = '17157'; -UPDATE `creature_template` SET `ScriptName` = 'mobs_kilsorrow_agent' WHERE `entry` IN (17146, 17147, 17148, 18397, 18658); -UPDATE `creature_template` SET `ScriptName` = 'npc_altruis_the_sufferer' WHERE `entry` = 18417; - -UPDATE `creature_template` SET `ScriptName` = 'npcs_ashyen_and_keleth' WHERE `entry` IN (17900, 17901); -UPDATE `creature_template` SET `npcflag` = 1 WHERE `entry` IN (17900,17901); -UPDATE `creature_template` SET `ScriptName` = 'npc_elder_kuruti' WHERE `entry` = 18197; -UPDATE `creature_template` SET `npcflag` = 1 WHERE `entry` = 18197; - -UPDATE `creature_template` SET `ScriptName` = 'mob_lunaclaw' WHERE `entry` = 12138; - -UPDATE `creature_template` SET `ScriptName` = 'npc_steward_of_time' WHERE `entry` = 20142; - -UPDATE `creature_template` SET `ScriptName` = 'boss_death_knight_darkreaver' WHERE `entry` = 14516; - -UPDATE `creature_template` SET `ScriptName` = 'mob_yenniku' WHERE `entry` = 2530; diff --git a/src/bindings/scripts/sql/Updates/r128.sql b/src/bindings/scripts/sql/Updates/r128.sql deleted file mode 100644 index f652fa16f10..00000000000 --- a/src/bindings/scripts/sql/Updates/r128.sql +++ /dev/null @@ -1 +0,0 @@ -update `creature_template` SET `scriptname`='npc_guardian' WHERE `entry`='5764';
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r131.sql b/src/bindings/scripts/sql/Updates/r131.sql deleted file mode 100644 index 0899dae38bc..00000000000 --- a/src/bindings/scripts/sql/Updates/r131.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_henze_faulk' WHERE `entry`= 6172;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r134.sql b/src/bindings/scripts/sql/Updates/r134.sql deleted file mode 100644 index eac5bb78415..00000000000 --- a/src/bindings/scripts/sql/Updates/r134.sql +++ /dev/null @@ -1,15 +0,0 @@ - -UPDATE `instance_template` SET `script` = 'instance_molten_core' WHERE `map`= 409; -UPDATE `instance_template` SET `script` = 'instance_blackwing_lair' WHERE `map`= 469; -UPDATE `instance_template` SET `script` = 'instance_zulgurub' WHERE `map`= 309; -UPDATE `instance_template` SET `script` = 'instance_ruins_of_ahnqiraj' WHERE `map`= 509; -UPDATE `instance_template` SET `script` = 'instance_temple_of_ahnqiraj' WHERE `map`= 531; -UPDATE `instance_template` SET `script` = 'instance_naxxramas' WHERE `map`= 533; - -UPDATE `instance_template` SET `script` = 'instance_karazhan' WHERE `map`= 532; -UPDATE `instance_template` SET `script` = 'instance_hyjal' WHERE `map`= 534; -UPDATE `instance_template` SET `script` = 'instance_gruuls_lair' WHERE `map`= 565; -UPDATE `instance_template` SET `script` = 'instance_magtheridons_lair' WHERE `map`= 544; -UPDATE `instance_template` SET `script` = 'instance_serpent_shrine' WHERE `map`= 548; -UPDATE `instance_template` SET `script` = 'instance_the_eye' WHERE `map`= 550; -UPDATE `instance_template` SET `script` = 'instance_black_temple' WHERE `map`= 564;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r136.sql b/src/bindings/scripts/sql/Updates/r136.sql deleted file mode 100644 index 52a9d87d6de..00000000000 --- a/src/bindings/scripts/sql/Updates/r136.sql +++ /dev/null @@ -1,55 +0,0 @@ - --- AQ40 bosses -- - --- Skeram 15263 -UPDATE `creature_template` SET `ScriptName` = 'boss_skeram' WHERE `entry` = 15263; - --- Vem, Yauj, Kri --- Vem 15544 -UPDATE `creature_template` SET `ScriptName` = 'boss_vem' WHERE `entry` = 15544; --- Yauj 15543 -UPDATE `creature_template` SET `ScriptName` = 'boss_yauj' WHERE `entry` = 15543; --- Yauj Brood 15621 -UPDATE `creature_template` SET `ScriptName` = 'mob_yauj_brood' WHERE `entry` = 15621; --- Kri 15511 -UPDATE `creature_template` SET `ScriptName` = 'boss_kri' WHERE `entry` = 15511; - --- Sartura 15516 -UPDATE `creature_template` SET `ScriptName` = 'boss_sartura' WHERE `entry` = 15516; --- Sartura's Royal Guard 15984 -UPDATE `creature_template` SET `ScriptName` = 'mob_sartura_royal_guard' WHERE `entry` = 15984; - --- Fankriss 15510 -UPDATE `creature_template` SET `ScriptName` = 'boss_fankriss' WHERE `entry` = 15510; --- Spawn of Fankriss 15630 -UPDATE `creature_template` SET `ScriptName` = 'mob_spawn_of_fankriss' WHERE `entry` = 15630; - --- Viscidus 15299 -UPDATE `creature_template` SET `ScriptName` = 'boss_viscidus' WHERE `entry` = 15299; --- Glob of Viscidus 15667 -UPDATE `creature_template` SET `ScriptName` = 'boss_glob_of_viscidus' WHERE `entry` = 15667; - --- Huhuran 15509 -UPDATE `creature_template` SET `ScriptName` = 'boss_huhuran' WHERE `entry` = 15509; - --- Veklor & Veknilash --- Veklor 15276 -UPDATE `creature_template` SET `ScriptName` = 'boss_veklor' WHERE `entry` = 15276; --- Veknilash 15275 -UPDATE `creature_template` SET `ScriptName` = 'boss_veknilash' WHERE `entry` = 15275; - --- Ouro 15517 -UPDATE `creature_template` SET `ScriptName` = 'boss_ouro' WHERE `entry` = 15517; - --- C'thun --- Eye 15589 --- Body 15727 - -UPDATE creature_template SET ScriptName='boss_eye_of_cthun' WHERE entry=15589; -UPDATE creature_template SET ScriptName='mob_claw_tentacle' WHERE entry=15725; -UPDATE creature_template SET ScriptName='mob_eye_tentacle' WHERE entry=15726; - -UPDATE creature_template SET ScriptName='boss_cthun' WHERE entry=15727; -UPDATE creature_template SET ScriptName='mob_giant_claw_tentacle' WHERE entry=15728; -UPDATE creature_template SET ScriptName='mob_giant_eye_tentacle' WHERE entry=15334; -UPDATE creature_template SET ScriptName='mob_giant_flesh_tentacle' WHERE entry=15802;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r139.sql b/src/bindings/scripts/sql/Updates/r139.sql deleted file mode 100644 index 73c013f1a1f..00000000000 --- a/src/bindings/scripts/sql/Updates/r139.sql +++ /dev/null @@ -1,35 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_lokhtos_darkbargainer' WHERE `entry` = 12944; - -UPDATE creature_template SET ScriptName='npc_lady_jaina_proudmoore' WHERE entry=4968; - -UPDATE `creature_template` SET `ScriptName` = 'mobs_spitelashes' WHERE entry IN (6190,6193,6194,6195,6196,7885,7886,12204,12205); - -UPDATE creature_template SET npcflag=1, ScriptName='npc_beaten_corpse' WHERE entry=10668; -UPDATE quest_template SET SpecialFlags=8, ReqCreatureOrGOId1=10668, ReqCreatureOrGOCount1=1 WHERE entry=4921; - -UPDATE creature_template SET ScriptName='boss_rokmar_the_crackler' WHERE entry=17991; -UPDATE creature_template SET ScriptName='boss_warlord_kalithresh' WHERE entry=17798; - -UPDATE `creature_template` SET `ScriptName` = 'boss_midnight' WHERE `entry` = 16151; -UPDATE `creature_template` SET `ScriptName` = 'boss_attumen' WHERE `entry` = 15550; -UPDATE `creature_template` SET `ScriptName` = 'boss_moroes' WHERE `entry` = 15687; -UPDATE `creature_template` SET `ScriptName` = 'boss_maiden_of_virtue' WHERE `entry` = 16457; -UPDATE `creature_template` SET `ScriptName` = 'boss_curator' WHERE `entry` = 15691; -UPDATE `creature_template` SET `ScriptName` = 'boss_big_bad_wolf' WHERE `entry` = 17521; -UPDATE `creature_template` SET `ScriptName` = 'boss_julianne' WHERE `entry` = 17534; -UPDATE `creature_template` SET `ScriptName` = 'boss_romulo' WHERE `entry` = 17533; -UPDATE `creature_template` SET `ScriptName` = 'boss_dorothee' WHERE `entry` = 17535; -UPDATE `creature_template` SET `ScriptName` = 'boss_strawman' WHERE `entry` = 17543; -UPDATE `creature_template` SET `ScriptName` = 'boss_tinhead' WHERE `entry` = 17547; -UPDATE `creature_template` SET `ScriptName` = 'boss_tito' WHERE `entry` = 17548; -UPDATE `creature_template` SET `ScriptName` = 'boss_roar' WHERE `entry` = 17546; -UPDATE `creature_template` SET `ScriptName` = 'boss_crone' WHERE `entry` = 18168; -UPDATE `creature_template` SET `ScriptName` = 'boss_terestian_illhoof' WHERE `entry` = 15688; -UPDATE `creature_template` SET `ScriptName` = 'boss_shade_of_aran' WHERE `entry` = 16524; -UPDATE `creature_template` SET `ScriptName` = 'boss_netherspite' WHERE `entry` = 15689; -UPDATE `creature_template` SET `ScriptName` = 'boss_malchezaar' WHERE `entry` = 15690; -UPDATE `creature_template` SET `ScriptName` = 'boss_nightbane' WHERE `entry` = 17225; - -UPDATE `creature_template` SET `ScriptName` = 'mob_homunculus' WHERE `entry` = 16539; -UPDATE `creature_template` SET `ScriptName` = 'mob_kilrek' WHERE `entry` = 17229; -UPDATE `creature_template` SET `ScriptName` = 'netherspite_infernal' WHERE `entry` = 17646;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r142.sql b/src/bindings/scripts/sql/Updates/r142.sql deleted file mode 100644 index 2cd9b29e6ec..00000000000 --- a/src/bindings/scripts/sql/Updates/r142.sql +++ /dev/null @@ -1,11 +0,0 @@ --- VoidReaver 19516 -UPDATE `creature_template` SET `ScriptName` = 'boss_void_reaver' WHERE `entry` = 19516; - --- Arcane Orb Target -REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (19577, 16946, 16946, 'Arcane Orb Target', '', 70, 70, 1, 1, 0, 0, 0, 35, 35, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 'mob_arcane_orb_target'); - -UPDATE `creature_template` SET `ScriptName` = 'boss_omor_the_unscarred' WHERE `entry` = 17308; -UPDATE `creature_template` SET `ScriptName` = 'boss_watchkeeper_gargolmar' WHERE `entry` = 17306; - -UPDATE `creature_template` SET `ScriptName` = 'boss_hungarfen' WHERE `entry` = 17770; -UPDATE `creature_template` SET `ScriptName` = 'mob_underbog_mushroom' WHERE `entry` = 17990;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r144.sql b/src/bindings/scripts/sql/Updates/r144.sql deleted file mode 100644 index ddf354b9ea1..00000000000 --- a/src/bindings/scripts/sql/Updates/r144.sql +++ /dev/null @@ -1,5 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_the_maker' WHERE `entry` = 17381; -UPDATE `creature_template` SET `ScriptName` = 'boss_broggok' WHERE `entry` = 17380; -UPDATE `creature_template` SET `ScriptName` = 'boss_kelidan_the_breaker' WHERE `entry` = 17377; -UPDATE `creature_template` SET `ScriptName` = 'mob_broggok_poisoncloud' WHERE `entry` = 17662; -UPDATE `creature_template` SET minlevel = 63, maxlevel = 63 WHERE `entry` = 17662;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r145.sql b/src/bindings/scripts/sql/Updates/r145.sql deleted file mode 100644 index d2d79974048..00000000000 --- a/src/bindings/scripts/sql/Updates/r145.sql +++ /dev/null @@ -1,4 +0,0 @@ - -UPDATE `creature_template` SET `ScriptName` = 'mob_shadow_of_aran' WHERE `entry` = 18254; -UPDATE `creature_template` SET `ScriptName` = 'mob_aran_elemental' WHERE `entry` = 17167; -UPDATE `creature_template` SET `ScriptName` = 'mob_aran_blizzard' WHERE `entry` = 17161;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r149.sql b/src/bindings/scripts/sql/Updates/r149.sql deleted file mode 100644 index a6311a14e9c..00000000000 --- a/src/bindings/scripts/sql/Updates/r149.sql +++ /dev/null @@ -1 +0,0 @@ -INSERT INTO `spell_script_target` VALUES (30834, 1, 17646); diff --git a/src/bindings/scripts/sql/Updates/r150.sql b/src/bindings/scripts/sql/Updates/r150.sql deleted file mode 100644 index eb1eb180622..00000000000 --- a/src/bindings/scripts/sql/Updates/r150.sql +++ /dev/null @@ -1,19 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_grand_warlock_nethekurse' WHERE `entry` = 16807; -UPDATE `creature_template` SET `ScriptName` = 'mob_nethe_shadowfissure' WHERE `entry` = 17471; - -UPDATE `creature_template` SET `scriptname`='mob_phoenix' WHERE `entry`='21362'; -UPDATE `creature_template` SET `scriptname`='mob_phoenix_egg' WHERE `entry`='21364'; - -UPDATE `item_template` SET `ScriptName` = 'vorenthals_presence' WHERE `entry`= 30259; - -UPDATE `creature_template` SET `ScriptName` = 'boss_hydromancer_thespia' WHERE `entry` = 17797; -UPDATE `creature_template` SET `ScriptName` = 'mob_coilfang_waterelemental' WHERE `entry` = 17917; - -UPDATE `creature_template` SET `ScriptName` = 'mob_ethereal_beacon' WHERE `entry` = 18431; -UPDATE `creature_template` SET `ScriptName` = 'mob_ethereal_apprentice' WHERE `entry` = 18430; - -UPDATE `creature_template` SET `ScriptName` = 'boss_tavarok' WHERE `entry` = 18343; -UPDATE `creature_template` SET `ScriptName` = 'boss_pandemonius' WHERE `entry` = 18341; -UPDATE `creature_template` SET `ScriptName` = 'boss_nexusprince_shaffar' WHERE `entry` = 18344; - -UPDATE `creature_template` SET `ScriptName` = 'boss_ghazan' WHERE `entry` = 18105;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r152.sql b/src/bindings/scripts/sql/Updates/r152.sql deleted file mode 100644 index 9efdb9f53c4..00000000000 --- a/src/bindings/scripts/sql/Updates/r152.sql +++ /dev/null @@ -1,12 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_syth_fire' WHERE `entry` = 19203; -UPDATE `creature_template` SET `ScriptName` = 'mob_syth_arcane' WHERE `entry` = 19205; -UPDATE `creature_template` SET `ScriptName` = 'mob_syth_frost' WHERE `entry` = 19204; -UPDATE `creature_template` SET `ScriptName` = 'mob_syth_shadow' WHERE `entry` = 19206; - -UPDATE `creature_template` SET `ScriptName` = 'boss_tailonking_ikiss' WHERE `entry` = 18473; -UPDATE `creature_template` SET `ScriptName` = 'boss_darkweaver_syth' WHERE `entry` = 18472; - -UPDATE creature_template SET ScriptName = 'npc_shattrathflaskvendors' WHERE entry = '23483'; -UPDATE creature_template SET ScriptName = 'npc_shattrathflaskvendors' WHERE entry = '23484'; - -UPDATE `creature_template` SET ScriptName='innkeeper' WHERE `npcflag` & 128<>0;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r153.sql b/src/bindings/scripts/sql/Updates/r153.sql deleted file mode 100644 index fb59c996edf..00000000000 --- a/src/bindings/scripts/sql/Updates/r153.sql +++ /dev/null @@ -1,33 +0,0 @@ --- Fishing net -UPDATE item_template SET ScriptName = 'draenei_fishing_net' WHERE entry = 23654; - --- Auchenai Crypts -UPDATE `creature_template` set `scriptname` = 'boss_shirrak_the_dead_watcher' where `entry` = '18371'; -UPDATE `creature_template` set `scriptname` = 'boss_shirrak_the_dead_watcher' where `entry` = '20318'; - --- Old Hillsbrad -UPDATE `creature_template` set `scriptname` = 'mob_lieutenant_drake' where `entry` = '17848'; -UPDATE `creature_template` set `scriptname` = 'mob_epoch_hunter' where `entry` = '18096'; -UPDATE `creature_template` SET `ScriptName` = 'boss_captain_skarloc' WHERE `entry`=17862; - --- The Black Morass -UPDATE `creature_template` set `ScriptName` = 'boss_chrono_lord_deja' where `entry` = '17879'; -UPDATE `creature_template` SET `ScriptName` = 'boss_aeonus' WHERE `entry`=17881; -UPDATE `creature_template` set `ScriptName` = 'boss_temporus' where `entry` = '17880'; - --- Deadmines -UPDATE `creature_template` SET `ScriptName` = 'boss_deadmines' WHERE `entry`=645; -UPDATE `creature_template` SET `ScriptName` = 'boss_deadmines' WHERE `entry`=1763; -UPDATE `creature_template` SET `ScriptName` = 'boss_deadmines' WHERE `entry`=599; -UPDATE `creature_template` SET `ScriptName` = 'boss_deadmines' WHERE `entry`=3586; - --- Wailing Caverns -UPDATE `creature_template` SET `ScriptName` = 'boss_wailing_caverns' WHERE `entry`=3654; - --- Gruul's Lair -UPDATE `creature_template` SET `ScriptName` = 'boss_high_king_maulgar' WHERE `entry`=18831; -UPDATE `creature_template` SET `ScriptName` = 'boss_kiggler_the_crazed' WHERE `entry`=18835; -UPDATE `creature_template` SET `ScriptName` = 'boss_blindeye_the_seer' WHERE `entry`=18836; -UPDATE `creature_template` SET `ScriptName` = 'boss_olm_the_summoner' WHERE `entry`=18834; -UPDATE `creature_template` SET `ScriptName` = 'boss_krosh_firehand' WHERE `entry`=18832; -UPDATE `instance_template` SET `script`="instance_gruuls_lair" WHERE `map`=565;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r157.sql b/src/bindings/scripts/sql/Updates/r157.sql deleted file mode 100644 index 05c8299529c..00000000000 --- a/src/bindings/scripts/sql/Updates/r157.sql +++ /dev/null @@ -1,7 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_hydross_the_unstable' WHERE `entry`=21216; -UPDATE `creature_template` SET `ScriptName` = 'boss_leotheras_the_blind' WHERE `entry`=21215; - --- Magtheridon's Lair -UPDATE `gameobject_template` SET `ScriptName`='go_manticron_cube' WHERE `entry`='181713'; -UPDATE `creature_template` SET `ScriptName` = 'boss_magtheridon' WHERE `entry`=17257; -UPDATE `creature_template` SET `ScriptName` = 'mob_hellfire_channeler' WHERE `entry`=17256; diff --git a/src/bindings/scripts/sql/Updates/r161.sql b/src/bindings/scripts/sql/Updates/r161.sql deleted file mode 100644 index 0bb31ee2ba0..00000000000 --- a/src/bindings/scripts/sql/Updates/r161.sql +++ /dev/null @@ -1,12 +0,0 @@ --- shadow labyrinth -UPDATE `instance_template` SET `script` = 'instance_shadow_labyrinth' WHERE `map`= 555; -UPDATE `creature_template` SET `ScriptName` = 'boss_murmur' WHERE `entry` = 18708; -UPDATE `creature_template` SET `ScriptName` = 'boss_ambassador_hellmaw' WHERE `entry` = 18731; -UPDATE `creature_template` SET `ScriptName` = 'boss_grandmaster_vorpil' WHERE `entry` = 18732; -UPDATE `creature_template` SET `ScriptName` = 'boss_blackheart_the_inciter' WHERE `entry` = 18667; - --- fathomlord karathress -UPDATE `creature_template` SET `ScriptName` = 'boss_fathomlord_karathress' WHERE `entry`=21214; -UPDATE `creature_template` SET `ScriptName` = 'boss_fathomguard_sharkkis' WHERE `entry`=21966; -UPDATE `creature_template` SET `ScriptName` = 'boss_fathomguard_tidalvess' WHERE `entry`=21965; -UPDATE `creature_template` SET `ScriptName` = 'boss_fathomguard_caribdis' WHERE `entry`=21964; diff --git a/src/bindings/scripts/sql/Updates/r163.sql b/src/bindings/scripts/sql/Updates/r163.sql deleted file mode 100644 index 9f8253e3cd3..00000000000 --- a/src/bindings/scripts/sql/Updates/r163.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE creature_template SET npcflag=npcflag|1, ScriptName='npc_cairne_bloodhoof' WHERE entry=3057; -UPDATE `gameobject_template` SET `ScriptName`='go_barov_journal' WHERE `entry`=180794;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r164.sql b/src/bindings/scripts/sql/Updates/r164.sql deleted file mode 100644 index 30b7a6a05a6..00000000000 --- a/src/bindings/scripts/sql/Updates/r164.sql +++ /dev/null @@ -1,10 +0,0 @@ --- gruuls lair trash mobs -UPDATE `creature_template` SET `ScriptName` = 'mob_gruuls_lair' WHERE `entry` IN (19389, 21350); - --- morogrim tidewalker -UPDATE `creature_template` SET `ScriptName` = 'boss_morogrim_tidewalker' WHERE `entry`=21213; --- Water Globule -UPDATE `creature_template` SET `ScriptName` = 'mob_water_globule' WHERE `entry`=21913; - --- Serpentshrine Cavern Trash Mobs -UPDATE `creature_template` SET `ScriptName` = 'mob_serpentshrine_cavern' WHERE `entry` IN (21246, 21339, 21221, 21224, 21227, 21228, 21226, 21225, 21298, 21299);
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r165.sql b/src/bindings/scripts/sql/Updates/r165.sql deleted file mode 100644 index 69401cdb8f4..00000000000 --- a/src/bindings/scripts/sql/Updates/r165.sql +++ /dev/null @@ -1,8 +0,0 @@ - --- the steam vault -UPDATE `instance_template` SET `script` = 'instance_steam_vault' WHERE `map` = 545; - --- right old hillsbrad foothills bosses script name -UPDATE `creature_template` SET `ScriptName` = 'boss_lieutenant_drake' WHERE `entry` = 17848; -UPDATE `creature_template` SET `ScriptName` = 'boss_epoch_hunter' WHERE `entry` = 18096; - diff --git a/src/bindings/scripts/sql/Updates/r169.sql b/src/bindings/scripts/sql/Updates/r169.sql deleted file mode 100644 index d5511e82106..00000000000 --- a/src/bindings/scripts/sql/Updates/r169.sql +++ /dev/null @@ -1,4 +0,0 @@ --- hellfire peninsula special taxi path -UPDATE `creature_template` SET `ScriptName` = 'npc_wing_commander_brack' WHERE `entry` = 19401; -UPDATE `creature_template` SET `ScriptName` = 'npc_wing_commander_dabiree' WHERE `entry` = 19409; -UPDATE `creature_template` SET `ScriptName` = 'npc_gryphoneer_windbellow' WHERE `entry` = 20235; diff --git a/src/bindings/scripts/sql/Updates/r170.sql b/src/bindings/scripts/sql/Updates/r170.sql deleted file mode 100644 index c397c160065..00000000000 --- a/src/bindings/scripts/sql/Updates/r170.sql +++ /dev/null @@ -1,2 +0,0 @@ --- special taxi path netherstorm -UPDATE `creature_template` SET `ScriptName` = 'npc_protectorate_nether_drake' WHERE `entry` = 20903; diff --git a/src/bindings/scripts/sql/Updates/r171.sql b/src/bindings/scripts/sql/Updates/r171.sql deleted file mode 100644 index 5a7adb61514..00000000000 --- a/src/bindings/scripts/sql/Updates/r171.sql +++ /dev/null @@ -1,2 +0,0 @@ --- multi kill quest mobs hfp -UPDATE `creature_template` SET `ScriptName` = 'mobs_shattered_hand_orc' WHERE `entry` IN (19411, 19410, 19413, 19414, 16867, 19295, 16870, 16878, 19415); diff --git a/src/bindings/scripts/sql/Updates/r172.sql b/src/bindings/scripts/sql/Updates/r172.sql deleted file mode 100644 index 4cac983026d..00000000000 --- a/src/bindings/scripts/sql/Updates/r172.sql +++ /dev/null @@ -1,3 +0,0 @@ --- support multikill bladespire and bloodmaul ogres -UPDATE `creature_template` SET `ScriptName` = 'mobs_bladespire_ogre' WHERE `entry` IN (19998, 20334, 21296, 21975); -UPDATE `creature_template` SET `ScriptName` = 'mobs_bloodmaul_ogre' WHERE `entry` IN (19948, 19952, 19957); diff --git a/src/bindings/scripts/sql/Updates/r174.sql b/src/bindings/scripts/sql/Updates/r174.sql deleted file mode 100644 index 57dde5a0fd2..00000000000 --- a/src/bindings/scripts/sql/Updates/r174.sql +++ /dev/null @@ -1,8 +0,0 @@ --- multikill creatures -UPDATE `creature_template` SET `ScriptName` = 'mobs_dragonmaw_orc' WHERE `entry` IN (21717, 21718, 21719, 21720, 22331); -UPDATE `creature_template` SET `ScriptName` = 'mobs_shadowmoon_valley_wildlife' WHERE `entry` IN (21878, 21879); -UPDATE `creature_template` SET `ScriptName` = 'mobs_gordunni_ogre' WHERE `entry` IN (22143, 22144, 22148, 23022); --- vendor -UPDATE `creature_template` SET `ScriptName` = 'npc_drake_dealer_hurlunk' WHERE `entry` = 23489; -UPDATE `creature_template` SET `ScriptName` = 'npc_rivern_frostwind' WHERE `entry` = 10618; - diff --git a/src/bindings/scripts/sql/Updates/r176.sql b/src/bindings/scripts/sql/Updates/r176.sql deleted file mode 100644 index 58e75375c12..00000000000 --- a/src/bindings/scripts/sql/Updates/r176.sql +++ /dev/null @@ -1,5 +0,0 @@ --- tales and stories -UPDATE `creature_template` SET `ScriptName` = 'npc_tirion_fordring' WHERE `entry` = 1855; -UPDATE `creature_template` SET `ScriptName` = 'npc_loramus_thalipedes' WHERE `entry` = 7783; -UPDATE `creature_template` SET `ScriptName` = 'npc_fallen_hero_of_horde' WHERE `entry` = 7572; -UPDATE `creature_template` SET `ScriptName` = 'npc_lorax' WHERE `entry` = 10918; diff --git a/src/bindings/scripts/sql/Updates/r177.sql b/src/bindings/scripts/sql/Updates/r177.sql deleted file mode 100644 index 3914679aa3b..00000000000 --- a/src/bindings/scripts/sql/Updates/r177.sql +++ /dev/null @@ -1,2 +0,0 @@ --- kalaran windblade -UPDATE `creature_template` SET `ScriptName` = 'npc_kalaran_windblade' WHERE `entry` = 8479; diff --git a/src/bindings/scripts/sql/Updates/r178.sql b/src/bindings/scripts/sql/Updates/r178.sql deleted file mode 100644 index f20a4366885..00000000000 --- a/src/bindings/scripts/sql/Updates/r178.sql +++ /dev/null @@ -1,2 +0,0 @@ --- kharan mighthammer -UPDATE `creature_template` SET `ScriptName` = 'npc_kharan_mighthammer' WHERE `entry` = 9021; diff --git a/src/bindings/scripts/sql/Updates/r181.sql b/src/bindings/scripts/sql/Updates/r181.sql deleted file mode 100644 index 4807582d1a4..00000000000 --- a/src/bindings/scripts/sql/Updates/r181.sql +++ /dev/null @@ -1,2 +0,0 @@ --- npc_lantresor_of_the_blade -UPDATE `creature_template` SET `ScriptName` = 'npc_lantresor_of_the_blade' WHERE `entry` = 18261; diff --git a/src/bindings/scripts/sql/Updates/r182.sql b/src/bindings/scripts/sql/Updates/r182.sql deleted file mode 100644 index 5d0a3c68fd2..00000000000 --- a/src/bindings/scripts/sql/Updates/r182.sql +++ /dev/null @@ -1,2 +0,0 @@ --- npc_ragged_john -UPDATE `creature_template` SET `ScriptName` = 'npc_ragged_john' WHERE `entry` = 9563; diff --git a/src/bindings/scripts/sql/Updates/r183.sql b/src/bindings/scripts/sql/Updates/r183.sql deleted file mode 100644 index 79c175d0996..00000000000 --- a/src/bindings/scripts/sql/Updates/r183.sql +++ /dev/null @@ -1,5 +0,0 @@ --- revert to original specialflags + flag 4 for mangos support, script no longer needed for quest -UPDATE `quest_template` SET `SpecialFlags`= 140 WHERE `entry` IN (10040, 10041); -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (18716, 18717, 18719); --- gossip only, key to searing gorge discussion -UPDATE `creature_template` SET `ScriptName` = 'npc_mountaineer_pebblebitty' WHERE `entry` = 3836; diff --git a/src/bindings/scripts/sql/Updates/r184.sql b/src/bindings/scripts/sql/Updates/r184.sql deleted file mode 100644 index 599fd9f3c0e..00000000000 --- a/src/bindings/scripts/sql/Updates/r184.sql +++ /dev/null @@ -1,2 +0,0 @@ --- revert to default database values -UPDATE `quest_template` SET `SpecialFlags`= 10, `ReqCreatureOrGOId1` = 0, `ReqCreatureOrGOId2` = 0, `ReqCreatureOrGOId3`= 0, `ReqCreatureOrGOId4`= 0, `ReqCreatureOrGOCount1` = 0, `ReqCreatureOrGOCount2` = 0, `ReqCreatureOrGOCount3` = 0, `ReqCreatureOrGOCount4`= 0, `ReqSpellCast1` = 0, `ReqSpellCast2` = 0, `ReqSpellCast3` = 0, `ReqSpellCast4` = 0 WHERE `entry` IN (5929, 5930); diff --git a/src/bindings/scripts/sql/Updates/r186.sql b/src/bindings/scripts/sql/Updates/r186.sql deleted file mode 100644 index a225e6850fc..00000000000 --- a/src/bindings/scripts/sql/Updates/r186.sql +++ /dev/null @@ -1,2 +0,0 @@ --- leotheras the blind demonform -UPDATE `creature_template` SET `ScriptName` = 'boss_leotheras_the_blind_demonform' WHERE `entry` = 21845;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r187.sql b/src/bindings/scripts/sql/Updates/r187.sql deleted file mode 100644 index 2b34b1c84bf..00000000000 --- a/src/bindings/scripts/sql/Updates/r187.sql +++ /dev/null @@ -1,12 +0,0 @@ --- test of lore quest npcs -UPDATE `creature_template` SET `ScriptName` = 'npc_parqual_fintallas' WHERE `entry` = 4488; -UPDATE `creature_template` SET `ScriptName` = 'npc_braug_dimspirit' WHERE `entry` = 4489; --- quest Scratches -UPDATE `creature_template` SET `ScriptName` = 'npc_daranelle' WHERE `entry` = 21469; - --- no comments of malfuntion, implementing mount vendors script -UPDATE `creature_template` SET `ScriptName` = 'npc_mount_vendor' WHERE `entry` IN (384, 1261, 1460, 2357, 3362, 3685, 4730, 4731, 4885, 7952, 7955, 16264, 17584); - --- one time update, this is database related sql and should be included in any database -UPDATE `creature_template` SET `npcflag` = `npcflag`|1 WHERE `entry` IN (4488, 4489, 21469); -INSERT IGNORE `spell_teleport` VALUES (6766, 1,-2354.03,-1902.07,95.78,4.6); diff --git a/src/bindings/scripts/sql/Updates/r189.sql b/src/bindings/scripts/sql/Updates/r189.sql deleted file mode 100644 index 51fc09abcd2..00000000000 --- a/src/bindings/scripts/sql/Updates/r189.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'go_field_repair_bot' where `entry`=179552; -UPDATE `creature_template` SET `ScriptName` = 'boss_doomwalker' WHERE `entry` = 17711; -UPDATE `creature_template` SET `ScriptName` = 'boss_exarch_maladaar' WHERE `entry` = 18373;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r191.sql b/src/bindings/scripts/sql/Updates/r191.sql deleted file mode 100644 index f5d563bc272..00000000000 --- a/src/bindings/scripts/sql/Updates/r191.sql +++ /dev/null @@ -1,5 +0,0 @@ - -/* THE MECHANAR */ -UPDATE `creature_template` SET `ScriptName` = 'boss_gatewatcher_iron_hand' WHERE `entry` = 19710; -UPDATE `creature_template` SET `ScriptName` = 'boss_nethermancer_sepethrea' WHERE `entry` = 19221; -UPDATE `creature_template` SET `ScriptName` = 'mob_ragin_flames' WHERE `entry` = 20481;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r192.sql b/src/bindings/scripts/sql/Updates/r192.sql deleted file mode 100644 index beb8aa31eb8..00000000000 --- a/src/bindings/scripts/sql/Updates/r192.sql +++ /dev/null @@ -1,9 +0,0 @@ --- lady vashj event -UPDATE `creature_template` SET `ScriptName` = 'boss_lady_vashj' WHERE `entry` = 21212; -UPDATE `creature_template` SET `ScriptName` = 'mob_enchanted_elemental' WHERE `entry` = 21958; -UPDATE `creature_template` SET `ScriptName` = 'mob_tainted_elemental' WHERE `entry` = 22009; -UPDATE `creature_template` SET `ScriptName` = 'mob_coilfang_elite' WHERE `entry` = 22055; -UPDATE `creature_template` SET `ScriptName` = 'mob_coilfang_strider' WHERE `entry` = 22056; -UPDATE `creature_template` SET `ScriptName` = 'mob_fathom_sporebat' WHERE `entry` = 22120; - -UPDATE `gameobject_template` SET `ScriptName` = 'go_shield_generator' WHERE `entry` IN (185052, 185053, 185051, 185054); diff --git a/src/bindings/scripts/sql/Updates/r197.sql b/src/bindings/scripts/sql/Updates/r197.sql deleted file mode 100644 index 800595abd59..00000000000 --- a/src/bindings/scripts/sql/Updates/r197.sql +++ /dev/null @@ -1,5 +0,0 @@ --- scholomance script -UPDATE `instance_template` SET `script` = 'instance_scholomance' WHERE `map` = 289; - --- arcatraz script -UPDATE `instance_template` SET `script` = 'instance_arcatraz' WHERE `map` = 552;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r204.sql b/src/bindings/scripts/sql/Updates/r204.sql deleted file mode 100644 index 960ba366f18..00000000000 --- a/src/bindings/scripts/sql/Updates/r204.sql +++ /dev/null @@ -1,7 +0,0 @@ --- lady vashj event -UPDATE `gameobject_template` SET `type`=0,`ScriptName`='' WHERE `entry` IN (185052, 185053, 185051, 185054); -UPDATE `item_template` SET `ScriptName` = 'item_tainted_core' WHERE `entry` = 31088; -UPDATE `creature_template` SET `ScriptName` = 'mob_shield_generator_channel' WHERE `entry` = 19870; - --- BWL trash mobs -UPDATE `creature_template` SET `ScriptName` = 'mob_blackwing_lair' WHERE `entry` IN (14265, 12457, 13996, 12459, 14261, 14263, 12467, 12463, 12461, 12464, 12460, 12465, 14262, 14264); diff --git a/src/bindings/scripts/sql/Updates/r206.sql b/src/bindings/scripts/sql/Updates/r206.sql deleted file mode 100644 index 9adcb76a6a3..00000000000 --- a/src/bindings/scripts/sql/Updates/r206.sql +++ /dev/null @@ -1,16 +0,0 @@ --- Zul'Gurub Bosses Part 1 + Trash Mobs -UPDATE `creature_template` SET `ScriptName` = 'boss_jeklik' WHERE `entry` = 14517; -UPDATE `creature_template` SET `ScriptName` = 'boss_venoxis' WHERE `entry` = 14607; -UPDATE `creature_template` SET `ScriptName` = 'boss_marli' WHERE `entry` = 14510; -UPDATE `creature_template` SET `ScriptName` = 'boss_mandokir' WHERE `entry` = 11382; -UPDATE `creature_template` SET `ScriptName` = 'boss_gahzranka' WHERE `entry` = 15114; -UPDATE `creature_template` SET `ScriptName` = 'boss_jindo' WHERE `entry` = 11380; - -/* Spawn of Marli */ -UPDATE `creature_template` SET `ScriptName` = 'mob_spawn_of_marli' WHERE `entry` = 15041; -/* Jeklik Batrider */ -UPDATE `creature_template` SET `ScriptName` = 'mob_batrider' WHERE `entry` = 14965; - - --- Darkmaster Ganling -UPDATE `creature_template` SET `ScriptName` = 'boss_darkmaster_gandling' WHERE `entry` = 1853;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r211.sql b/src/bindings/scripts/sql/Updates/r211.sql deleted file mode 100644 index ceb91171b9a..00000000000 --- a/src/bindings/scripts/sql/Updates/r211.sql +++ /dev/null @@ -1,6 +0,0 @@ --- kael'thas event -UPDATE `creature_template` SET `ScriptName` = 'boss_kaelthas' WHERE `entry` = 19622; -UPDATE `creature_template` SET `ScriptName` = 'boss_thaladred_the_darkener' WHERE `entry` = 20064; -UPDATE `creature_template` SET `ScriptName` = 'boss_lord_sanguinar' WHERE `entry` = 20060; -UPDATE `creature_template` SET `ScriptName` = 'boss_grand_astromancer_capernian' WHERE `entry` = 20062; -UPDATE `creature_template` SET `ScriptName` = 'boss_master_engineer_telonicus' WHERE `entry` = 20063; diff --git a/src/bindings/scripts/sql/Updates/r213.sql b/src/bindings/scripts/sql/Updates/r213.sql deleted file mode 100644 index b512cfd5044..00000000000 --- a/src/bindings/scripts/sql/Updates/r213.sql +++ /dev/null @@ -1,11 +0,0 @@ --- Zul'Gurub Part II -UPDATE `creature_template` SET `ScriptName` = "boss_hakkar" WHERE `creature_template`.`entry` = 15295; -UPDATE `creature_template` SET `ScriptName` = "boss_thekal" WHERE `creature_template`.`entry` = 14509; -UPDATE `creature_template` SET `ScriptName` = "boss_arlokk" WHERE `creature_template`.`entry` = 14515; -UPDATE `creature_template` SET `ScriptName` = "mob_zealot_lorkhan" WHERE `creature_template`.`entry` = 11347; -UPDATE `creature_template` SET `ScriptName` = "mob_zealot_zath" WHERE `creature_template`.`entry` = 11348; -UPDATE `creature_template` SET `ScriptName` = "mob_healing_ward" WHERE `creature_template`.`entry` = 14987; -UPDATE `creature_template` SET `Scriptname` = "mobs_zulgurub" WHERE `creature_template`.`entry` IN (11340 ,11352 , 11350, 11830, 11372, 11351, 14750); - - - diff --git a/src/bindings/scripts/sql/Updates/r214.sql b/src/bindings/scripts/sql/Updates/r214.sql deleted file mode 100644 index 24b5aa393d3..00000000000 --- a/src/bindings/scripts/sql/Updates/r214.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = "boss_hakkar" WHERE `creature_template`.`entry` = 14834; - diff --git a/src/bindings/scripts/sql/Updates/r215.sql b/src/bindings/scripts/sql/Updates/r215.sql deleted file mode 100644 index 90bfbf0e86b..00000000000 --- a/src/bindings/scripts/sql/Updates/r215.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `item_template` SET `ScriptName` = 'item_skin_of_purest_water' WHERE `entry` = 23751; diff --git a/src/bindings/scripts/sql/Updates/r218.sql b/src/bindings/scripts/sql/Updates/r218.sql deleted file mode 100644 index e6eeb7782aa..00000000000 --- a/src/bindings/scripts/sql/Updates/r218.sql +++ /dev/null @@ -1,5 +0,0 @@ --- misc quest related -UPDATE `creature_template` SET `ScriptName` = 'npc_restless_apparition' WHERE `entry` = 23861; -UPDATE `creature_template` SET `ScriptName` = 'mobs_direhorn_grimtotem' WHERE `entry` = 23595; -UPDATE `creature_template` SET `ScriptName` = 'mobs_risen_husk_spirit' WHERE `entry` IN (23554, 23555); - diff --git a/src/bindings/scripts/sql/Updates/r219.sql b/src/bindings/scripts/sql/Updates/r219.sql deleted file mode 100644 index 8b01dd43784..00000000000 --- a/src/bindings/scripts/sql/Updates/r219.sql +++ /dev/null @@ -1,3 +0,0 @@ -/* Fix for Wrong ZG Update */ -UPDATE `creature_template` SET `ScriptName` = ' ' WHERE `entry` = 14607; -UPDATE `creature_template` SET `ScriptName` = ' ' WHERE `entry` = 15295;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r221_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r221_scriptdev2.sql deleted file mode 100644 index 06cd4334508..00000000000 --- a/src/bindings/scripts/sql/Updates/r221_scriptdev2.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `eventai_Scripts` RENAME TO `eventai_scripts`;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r227_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r227_scriptdev2.sql deleted file mode 100644 index 4e600fc3df8..00000000000 --- a/src/bindings/scripts/sql/Updates/r227_scriptdev2.sql +++ /dev/null @@ -1,29 +0,0 @@ -ALTER TABLE `eventai_scripts` - DROP PRIMARY KEY, - DROP `id`, - ADD `id` int(11) unsigned NOT NULL COMMENT 'Identifier' PRIMARY KEY AUTO_INCREMENT FIRST, - - MODIFY `event_param1` int(11) signed NOT NULL default '0', - MODIFY `event_param2` int(11) signed NOT NULL default '0', - MODIFY `event_param3` int(11) signed NOT NULL default '0', - - MODIFY `action1_param1` int(11) signed NOT NULL default '0', - MODIFY `action1_param2` int(11) signed NOT NULL default '0', - MODIFY `action1_param3` int(11) signed NOT NULL default '0', - - MODIFY `action2_param1` int(11) signed NOT NULL default '0', - MODIFY `action2_param2` int(11) signed NOT NULL default '0', - MODIFY `action2_param3` int(11) signed NOT NULL default '0', - - MODIFY `action3_param1` int(11) signed NOT NULL default '0', - MODIFY `action3_param2` int(11) signed NOT NULL default '0', - MODIFY `action3_param3` int(11) signed NOT NULL default '0', - - ADD `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment'; - -ALTER TABLE `localized_texts` - DROP PRIMARY KEY, - DROP `id`, - ADD `id` int(11) unsigned NOT NULL COMMENT 'Identifier' PRIMARY KEY AUTO_INCREMENT FIRST, - ADD `comment` varchar(255) NOT NULL default '' COMMENT 'Text Comment'; -
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r230_mangos.sql b/src/bindings/scripts/sql/Updates/r230_mangos.sql deleted file mode 100644 index 4db44512536..00000000000 --- a/src/bindings/scripts/sql/Updates/r230_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_deserter_agitator' WHERE `entry` = 23602; -UPDATE `gameobject_template` SET `ScriptName` = 'go_field_repair_bot_74A' where `entry`= 179552; diff --git a/src/bindings/scripts/sql/Updates/r234_mangos.sql b/src/bindings/scripts/sql/Updates/r234_mangos.sql deleted file mode 100644 index 8a72910adbe..00000000000 --- a/src/bindings/scripts/sql/Updates/r234_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_screecher_spirit' WHERE `entry` = 8612; -UPDATE `item_template` SET `ScriptName` = 'item_yehkinyas_bramble' WHERE `entry`= 10699; diff --git a/src/bindings/scripts/sql/Updates/r237_mangos.sql b/src/bindings/scripts/sql/Updates/r237_mangos.sql deleted file mode 100644 index 265bde22802..00000000000 --- a/src/bindings/scripts/sql/Updates/r237_mangos.sql +++ /dev/null @@ -1,6 +0,0 @@ --- new -UPDATE `creature_template` SET `ScriptName` = 'guard_azuremyst' WHERE `entry` = 18038; -UPDATE `creature_template` SET `ScriptName` = 'guard_eversong' WHERE `entry` = 16221; --- update -UPDATE `creature_template` SET `ScriptName` = 'guard_durotar' WHERE `entry` = 5953; -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (3210, 3211, 3213, 3214, 1736, 1739, 1737); diff --git a/src/bindings/scripts/sql/Updates/r238_mangos.sql b/src/bindings/scripts/sql/Updates/r238_mangos.sql deleted file mode 100644 index d148e11f863..00000000000 --- a/src/bindings/scripts/sql/Updates/r238_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ --- revert previously bad sql -UPDATE `creature_template` SET `ScriptName` = '' WHERE `ScriptName` LIKE '%innkeeper%' AND `npcflag` & 128<>0; diff --git a/src/bindings/scripts/sql/Updates/r239_mangos.sql b/src/bindings/scripts/sql/Updates/r239_mangos.sql deleted file mode 100644 index 8936e4d8f6c..00000000000 --- a/src/bindings/scripts/sql/Updates/r239_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `item_template` SET `ScriptName` = '' WHERE `entry` = 23268; diff --git a/src/bindings/scripts/sql/Updates/r240_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r240_scriptdev2.sql deleted file mode 100644 index 635ee46b18e..00000000000 --- a/src/bindings/scripts/sql/Updates/r240_scriptdev2.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `eventai_scripts` -ADD `event_inverse_phase_mask` int(11) signed NOT NULL default '0', COMMENT 'Mask which phases this event will not trigger in';
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r241_mangos.sql b/src/bindings/scripts/sql/Updates/r241_mangos.sql deleted file mode 100644 index ffc99c200d5..00000000000 --- a/src/bindings/scripts/sql/Updates/r241_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_skyguard_handler_irena' WHERE `entry` = 23413; -UPDATE `creature_template` SET `ScriptName` = 'npc_skyguard_handler_deesak' WHERE `entry` = 23415; diff --git a/src/bindings/scripts/sql/Updates/r242_mangos.sql b/src/bindings/scripts/sql/Updates/r242_mangos.sql deleted file mode 100644 index 49465a656e9..00000000000 --- a/src/bindings/scripts/sql/Updates/r242_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_zamael_lunthistle' WHERE `entry` = 8436; -UPDATE `creature_template` SET `ScriptName` = 'npc_lothos_riftwaker' WHERE `entry` = 14387; diff --git a/src/bindings/scripts/sql/Updates/r243_mangos.sql b/src/bindings/scripts/sql/Updates/r243_mangos.sql deleted file mode 100644 index 6b1ad08d0a0..00000000000 --- a/src/bindings/scripts/sql/Updates/r243_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_marin_noggenfogger' WHERE `entry` = 7564; diff --git a/src/bindings/scripts/sql/Updates/r249_mangos.sql b/src/bindings/scripts/sql/Updates/r249_mangos.sql deleted file mode 100644 index cf0c36ef468..00000000000 --- a/src/bindings/scripts/sql/Updates/r249_mangos.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_flamewaker_priest' WHERE `entry` = 11662; -UPDATE `creature_template` SET `ScriptName` = 'boss_datrohan_balnazzar' WHERE `entry` = 10812; - diff --git a/src/bindings/scripts/sql/Updates/r250_mangos.sql b/src/bindings/scripts/sql/Updates/r250_mangos.sql deleted file mode 100644 index 841e39d71b3..00000000000 --- a/src/bindings/scripts/sql/Updates/r250_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_dathrohan_balnazzar' WHERE `entry` = 10812; -
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r253_mangos.sql b/src/bindings/scripts/sql/Updates/r253_mangos.sql deleted file mode 100644 index 424237be238..00000000000 --- a/src/bindings/scripts/sql/Updates/r253_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `item_template` SET `ScriptName` = 'item_zezzaks_shard' WHERE `entry` = 31463;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r255_mangos.sql b/src/bindings/scripts/sql/Updates/r255_mangos.sql deleted file mode 100644 index 7019586eb96..00000000000 --- a/src/bindings/scripts/sql/Updates/r255_mangos.sql +++ /dev/null @@ -1,5 +0,0 @@ -UPDATE instance_template SET script = 'instance_zulaman' WHERE map = 568; -UPDATE creature_template SET scriptname='boss_janalai' WHERE entry=23578; -UPDATE creature_template SET scriptname='mob_jandalai_firebomb' WHERE entry=23920; -UPDATE creature_template SET scriptname='mob_amanishi_hatcher' WHERE entry=23818; -UPDATE creature_template SET scriptname='mob_hatchling' WHERE entry=23598;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r256_mangos.sql b/src/bindings/scripts/sql/Updates/r256_mangos.sql deleted file mode 100644 index 4207454117e..00000000000 --- a/src/bindings/scripts/sql/Updates/r256_mangos.sql +++ /dev/null @@ -1,35 +0,0 @@ -UPDATE creature_template SET ScriptName = 'npc_tyrande_whisperwind' WHERE entry = 17948; -UPDATE creature_template SET ScriptName = 'npc_thrall' WHERE entry = 17852; -UPDATE creature_template SET ScriptName = 'npc_jaina_proudmoore' WHERE entry = 17772; - -UPDATE creature_template SET ScriptName = 'npc_akama_shade' WHERE entry = 23089; -- Akama at Shade of Akama -UPDATE creature_template SET ScriptName = 'npc_akama_illidan' WHERE entry = 22990; -- Akama at Illidan -UPDATE creature_template SET ScriptName = 'illidari_council' WHERE entry = 23426; -- Illidari Council controller mob -UPDATE creature_template SET ScriptName = 'boss_veras_darkshadow' WHERE entry = 22952; -- Rogue of Illidari Council -UPDATE creature_template SET ScriptName = 'boss_teron_gorefiend' WHERE entry = 22871; -- Teron Gorefiend -UPDATE creature_template SET ScriptName = 'boss_supremus' WHERE entry = 22898; -- Supremus -UPDATE creature_template SET ScriptName = 'boss_shade_of_akama' WHERE entry = 22841; -- Shade of Akama -UPDATE creature_template SET ScriptName = 'boss_reliquary_of_souls' WHERE entry = 22856; -- Reliquary Controller Mob -UPDATE creature_template SET ScriptName = 'boss_essence_of_suffering' WHERE entry = 23418; -- Essence Of Suffering -UPDATE creature_template SET ScriptName = 'boss_essence_of_desire' WHERE entry = 23419; -- Essence of Desire -UPDATE creature_template SET ScriptName = 'boss_essence_of_anger' WHERE entry = 23420; -- Essence of Anger -UPDATE creature_template SET ScriptName = 'boss_najentus' WHERE entry = 22887; -- High Warlord Naj'entus -UPDATE creature_template SET ScriptName = 'boss_gurtogg_bloodboil' WHERE entry = 22948; -- Gurtogg Bloodboil -UPDATE creature_template SET ScriptName = 'boss_mother_shahraz' WHERE entry = 22947; -- Mother Shahraz -UPDATE creature_template SET ScriptName = 'boss_lady_malande' WHERE entry = 22951; -- Priest <3 at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_illidan_stormrage' WHERE entry = 22917; -- Illidan The Betrayer! -UPDATE creature_template SET ScriptName = 'boss_high_nethermancer_zerevor' WHERE entry = 22950; -- Mage at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_gathios_the_shatterer' WHERE entry = 22949; -- Paladin at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_maiev_shadowsong' WHERE entry = 23197; -- Maiev Shadowsong -UPDATE creature_template SET ScriptName = 'mob_blaze' WHERE entry = 23259; -- Blaze mob in Illidan Phase 2 -UPDATE creature_template SET ScriptName = 'mob_flame_of_azzinoth' WHERE entry = 22997; -- Flame of Azzinoth (Illidan Phase 2) -UPDATE creature_template SET ScriptName = 'mob_demon_fire' WHERE entry = 23069; -- Demon Fire in Illidan Phase 2 -UPDATE creature_template SET ScriptName = 'mob_flame_crash' WHERE entry = 23336; -- Flame Crash in Illidan Normal Form -UPDATE creature_template SET ScriptName = 'mob_cage_trap_trigger' WHERE entry = 23304; -- Cage Trap mob in Illidan Phase 3/4 Normal -UPDATE creature_template SET ScriptName = 'mob_shadow_demon' WHERE entry = 23375; -- Shadow Demon in Illidan Demon Form -UPDATE creature_template SET ScriptName = 'npc_volcano' WHERE entry = 23085; -- Supremus Volcano -UPDATE creature_template SET ScriptName = 'molten_flame' WHERE entry = 23095; -- Molten Flame in SUpremus -UPDATE creature_template SET ScriptName = 'mob_ashtongue_channeler' WHERE entry = 23421; -- Ashtongue CHanneler in Shade of AKama -UPDATE creature_template SET ScriptName = 'mob_ashtongue_sorcerer' WHERE entry = 23215; -- Ashtongue Sorcerer in Shade of Akama -UPDATE creature_template SET ScriptName = 'npc_enslaved_soul' WHERE entry = 23469; -- Enslaved Soul in Reliquary Event --- UPDATE creature_template SET ScriptName = 'mob_najentus_spine' WHERE entry = 500000; -- Workaround creature for spine in Najentus event
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r257_mangos.sql b/src/bindings/scripts/sql/Updates/r257_mangos.sql deleted file mode 100644 index 1bed2c9f098..00000000000 --- a/src/bindings/scripts/sql/Updates/r257_mangos.sql +++ /dev/null @@ -1,4 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_archmage_malin' WHERE `entry` = 2708; -UPDATE `creature_template` SET `ScriptName` = 'npc_dashel_stonefist' WHERE `entry` = 4961; -UPDATE `creature_template` SET `ScriptName` = 'npc_doctor' WHERE `entry` IN (12939, 12920); -UPDATE `creature_template` SET `ScriptName` = 'npc_injured_patient' WHERE `entry` IN (12936, 12937, 12938, 12923, 12924, 12925); diff --git a/src/bindings/scripts/sql/Updates/r258_mangos.sql b/src/bindings/scripts/sql/Updates/r258_mangos.sql deleted file mode 100644 index 18970d669da..00000000000 --- a/src/bindings/scripts/sql/Updates/r258_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_deathly_usher' WHERE `entry` = 8816; diff --git a/src/bindings/scripts/sql/Updates/r260_mangos.sql b/src/bindings/scripts/sql/Updates/r260_mangos.sql deleted file mode 100644 index e96598d09e1..00000000000 --- a/src/bindings/scripts/sql/Updates/r260_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_lady_katrana_prestor' WHERE `entry` = 1749; diff --git a/src/bindings/scripts/sql/Updates/r261_mangos.sql b/src/bindings/scripts/sql/Updates/r261_mangos.sql deleted file mode 100644 index b1c8e6312a9..00000000000 --- a/src/bindings/scripts/sql/Updates/r261_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_general_marcus_jonathan' WHERE `entry` = 466; diff --git a/src/bindings/scripts/sql/Updates/r262_mangos.sql b/src/bindings/scripts/sql/Updates/r262_mangos.sql deleted file mode 100644 index 225b7c38437..00000000000 --- a/src/bindings/scripts/sql/Updates/r262_mangos.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_royal_historian_archesonus' WHERE `entry` = 8879; -UPDATE `creature_template` SET `ScriptName` = 'npc_bunthen_plainswind' WHERE `entry` = 11798; -UPDATE `creature_template` SET `ScriptName` = 'npc_silva_filnaveth' WHERE `entry` = 11800; diff --git a/src/bindings/scripts/sql/Updates/r263_mangos.sql b/src/bindings/scripts/sql/Updates/r263_mangos.sql deleted file mode 100644 index a3ff56a0bd7..00000000000 --- a/src/bindings/scripts/sql/Updates/r263_mangos.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'go_northern_crystal_pylon' WHERE `entry` = 164955; -UPDATE `gameobject_template` SET `ScriptName` = 'go_western_crystal_pylon' WHERE `entry` = 164956; -UPDATE `gameobject_template` SET `ScriptName` = 'go_eastern_crystal_pylon' WHERE `entry` = 164957; diff --git a/src/bindings/scripts/sql/Updates/r264_mangos.sql b/src/bindings/scripts/sql/Updates/r264_mangos.sql deleted file mode 100644 index 410f1de42d5..00000000000 --- a/src/bindings/scripts/sql/Updates/r264_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_astor_hadren' WHERE `entry` = 6497; diff --git a/src/bindings/scripts/sql/Updates/r265_mangos.sql b/src/bindings/scripts/sql/Updates/r265_mangos.sql deleted file mode 100644 index 4eaed94ee10..00000000000 --- a/src/bindings/scripts/sql/Updates/r265_mangos.sql +++ /dev/null @@ -1,9 +0,0 @@ -UPDATE `item_template` SET `ScriptName` = 'item_nether_wraith_beacon' WHERE `entry` = 31742; -UPDATE `item_template` SET `ScriptName` = 'item_area_52_special' WHERE `entry` = 28132; -UPDATE `item_template` SET `ScriptName` = 'item_vorenthals_presence' WHERE `entry` = 30259; -UPDATE `item_template` SET `ScriptName` = 'item_draenei_fishing_net' WHERE `entry` = 23654; -UPDATE `item_template` SET `ScriptName` = 'item_skin_of_purest_water' WHERE `entry` = 23751; -UPDATE `item_template` SET `ScriptName` = 'item_yehkinyas_bramble' WHERE `entry` = 10699; -UPDATE `item_template` SET `ScriptName` = 'item_zezzaks_shard' WHERE `entry` = 31463; -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (40100,40101,40102,40103,40104,40105,40106,40107,40108,40109,40110,40111,40112,40113); -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (40200,40201,40202,40203,40204,40205,40206,40207,40208,40209,40210,40211,40212,40213); diff --git a/src/bindings/scripts/sql/Updates/r269_mangos.sql b/src/bindings/scripts/sql/Updates/r269_mangos.sql deleted file mode 100644 index 95ed715301a..00000000000 --- a/src/bindings/scripts/sql/Updates/r269_mangos.sql +++ /dev/null @@ -1,6 +0,0 @@ --- removing old script names that does no longer exist -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (12198,14982,857,12197,7427,347,15007,2804); -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (9564,12136,3149,12137,9566,3150,9559,9558); -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` = 197; -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (11328, 11260); -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (80, 1236, 3578, 40, 1358, 1360, 5996, 1426, 1094, 674); diff --git a/src/bindings/scripts/sql/Updates/r270_mangos.sql b/src/bindings/scripts/sql/Updates/r270_mangos.sql deleted file mode 100644 index 2d7ffe0c432..00000000000 --- a/src/bindings/scripts/sql/Updates/r270_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_overseer_nuaar' WHERE `entry` = 21981; diff --git a/src/bindings/scripts/sql/Updates/r271_mangos.sql b/src/bindings/scripts/sql/Updates/r271_mangos.sql deleted file mode 100644 index 74fcb02284d..00000000000 --- a/src/bindings/scripts/sql/Updates/r271_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_greatmother_geyah' WHERE `entry` = 18141; diff --git a/src/bindings/scripts/sql/Updates/r272_mangos.sql b/src/bindings/scripts/sql/Updates/r272_mangos.sql deleted file mode 100644 index 3e5313f20e0..00000000000 --- a/src/bindings/scripts/sql/Updates/r272_mangos.sql +++ /dev/null @@ -1,8 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_kaelthas' WHERE `entry` = 23054; -UPDATE `creature_template` SET `ScriptName` = 'boss_thaladred_the_darkener' WHERE `entry` = 20064; -UPDATE `creature_template` SET `ScriptName` = 'boss_lord_sanguinar' WHERE `entry` = 20060; -UPDATE `creature_template` SET `ScriptName` = 'boss_grand_astromancer_capernian' WHERE `entry` = 20062; -UPDATE `creature_template` SET `ScriptName` = 'boss_master_engineer_telonicus' WHERE `entry` = 20063; -UPDATE `creature_template` SET `ScriptName` = 'mob_phoenix' WHERE `entry` = 21362; -UPDATE `creature_template` SET `ScriptName` = 'mob_nether_vapor' WHERE `entry` = 21002; -UPDATE `creature_template` SET `ScriptName` = 'mob_kael_flamestrike' WHERE `entry` = 21369;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r273_mangos.sql b/src/bindings/scripts/sql/Updates/r273_mangos.sql deleted file mode 100644 index db98e282f09..00000000000 --- a/src/bindings/scripts/sql/Updates/r273_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_saikkal_the_elder' WHERE `entry` = 22932; diff --git a/src/bindings/scripts/sql/Updates/r274_mangos.sql b/src/bindings/scripts/sql/Updates/r274_mangos.sql deleted file mode 100644 index fef98f84e11..00000000000 --- a/src/bindings/scripts/sql/Updates/r274_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_blackwing_lair' WHERE `entry` = 12557; diff --git a/src/bindings/scripts/sql/Updates/r275_mangos.sql b/src/bindings/scripts/sql/Updates/r275_mangos.sql deleted file mode 100644 index 618666b80e1..00000000000 --- a/src/bindings/scripts/sql/Updates/r275_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_shade_of_jindo' WHERE `entry` = 14986; diff --git a/src/bindings/scripts/sql/Updates/r281_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r281_scriptdev2.sql deleted file mode 100644 index 719d1ee7852..00000000000 --- a/src/bindings/scripts/sql/Updates/r281_scriptdev2.sql +++ /dev/null @@ -1,35 +0,0 @@ -ALTER TABLE eventai_scripts -ADD event_chance tinyint(3) unsigned NOT NULL default 100 AFTER event_inverse_phase_mask; - --- EVENT_T_TIMER_REPEAT -UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 0 AND event_param3 < 0; - --- EVENT_T_TIMER_SINGLE -UPDATE eventai_scripts SET event_chance = event_param2 WHERE event_type = 1; - --- EVENT_T_TIMER_OOC_REPEAT -UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 2 AND event_param3 < 0; - --- EVENT_T_TIMER_OOC_SINGLE -UPDATE eventai_scripts SET event_chance = event_param2 WHERE event_type = 3; - --- EVENT_T_HP_SINGLE -UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 4 AND event_param3 < 0; - --- EVENT_T_MANA_SINGLE -UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 5 AND event_param3 < 0; - --- EVENT_T_AGGRO -UPDATE eventai_scripts SET event_chance = event_param1 WHERE event_type = 6; - --- EVENT_T_KILL -UPDATE eventai_scripts SET event_chance = event_param2 WHERE event_type = 7; - --- EVENT_T_DEATH -UPDATE eventai_scripts SET event_chance = event_param1 WHERE event_type = 8; - --- EVENT_T_EVADE -UPDATE eventai_scripts SET event_chance = event_param1 WHERE event_type = 9; - --- EVENT_T_SPELLHIT -UPDATE eventai_scripts SET event_chance = event_param3 WHERE event_type = 10;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r282_mangos.sql b/src/bindings/scripts/sql/Updates/r282_mangos.sql deleted file mode 100644 index 93ea058523a..00000000000 --- a/src/bindings/scripts/sql/Updates/r282_mangos.sql +++ /dev/null @@ -1,38 +0,0 @@ -UPDATE creature_template SET ScriptName = 'npc_tyrande_whisperwind' WHERE entry = 17948; -UPDATE creature_template SET ScriptName = 'npc_thrall' WHERE entry = 17852; -UPDATE creature_template SET ScriptName = 'npc_jaina_proudmoore' WHERE entry = 17772; - -UPDATE creature_template SET ScriptName = 'npc_akama_shade' WHERE entry = 23089; -- Akama at Shade of Akama -UPDATE creature_template SET ScriptName = 'npc_akama_illidan' WHERE entry = 22990; -- Akama at Illidan -UPDATE creature_template SET ScriptName = 'illidari_council' WHERE entry = 23426; -- Illidari Council controller mob -UPDATE creature_template SET ScriptName = 'boss_veras_darkshadow' WHERE entry = 22952; -- Rogue of Illidari Council -UPDATE creature_template SET ScriptName = 'boss_teron_gorefiend' WHERE entry = 22871; -- Teron Gorefiend -UPDATE creature_template SET ScriptName = 'boss_supremus' WHERE entry = 22898; -- Supremus -UPDATE creature_template SET ScriptName = 'boss_shade_of_akama' WHERE entry = 22841; -- Shade of Akama -UPDATE creature_template SET ScriptName = 'boss_reliquary_of_souls' WHERE entry = 22856; -- Reliquary Controller Mob -UPDATE creature_template SET ScriptName = 'boss_essence_of_suffering' WHERE entry = 23418; -- Essence Of Suffering -UPDATE creature_template SET ScriptName = 'boss_essence_of_desire' WHERE entry = 23419; -- Essence of Desire -UPDATE creature_template SET ScriptName = 'boss_essence_of_anger' WHERE entry = 23420; -- Essence of Anger -UPDATE creature_template SET ScriptName = 'boss_najentus' WHERE entry = 22887; -- High Warlord Naj'entus -UPDATE creature_template SET ScriptName = 'boss_gurtogg_bloodboil' WHERE entry = 22948; -- Gurtogg Bloodboil -UPDATE creature_template SET ScriptName = 'boss_mother_shahraz' WHERE entry = 22947; -- Mother Shahraz -UPDATE creature_template SET ScriptName = 'boss_lady_malande' WHERE entry = 22951; -- Priest <3 at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_illidan_stormrage' WHERE entry = 22917; -- Illidan The Betrayer! -UPDATE creature_template SET ScriptName = 'boss_high_nethermancer_zerevor' WHERE entry = 22950; -- Mage at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_gathios_the_shatterer' WHERE entry = 22949; -- Paladin at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_maiev_shadowsong' WHERE entry = 23197; -- Maiev Shadowsong -UPDATE creature_template SET ScriptName = 'mob_blaze' WHERE entry = 23259; -- Blaze mob in Illidan Phase 2 -UPDATE creature_template SET ScriptName = 'mob_flame_of_azzinoth' WHERE entry = 22997; -- Flame of Azzinoth (Illidan Phase 2) -UPDATE creature_template SET ScriptName = 'mob_blade_of_azzinoth' WHERE entry = 22996; -- Blade of Azzinoth (Illidan Phase 2) -UPDATE creature_template SET ScriptName = 'mob_demon_fire' WHERE entry = 23069; -- Demon Fire in Illidan Phase 2 -UPDATE creature_template SET ScriptName = 'mob_flame_crash' WHERE entry = 23336; -- Flame Crash in Illidan Normal Form -UPDATE creature_template SET ScriptName = 'mob_cage_trap_trigger' WHERE entry = 23304; -- Cage Trap mob in Illidan Phase 3/4 Normal -UPDATE creature_template SET ScriptName = 'mob_shadow_demon' WHERE entry = 23375; -- Shadow Demon in Illidan Demon Form -UPDATE creature_template SET ScriptName = 'npc_volcano' WHERE entry = 23085; -- Supremus Volcano -UPDATE creature_template SET ScriptName = 'molten_flame' WHERE entry = 23095; -- Molten Flame in SUpremus -UPDATE creature_template SET ScriptName = 'mob_ashtongue_channeler' WHERE entry = 23421; -- Ashtongue CHanneler in Shade of AKama -UPDATE creature_template SET ScriptName = 'mob_ashtongue_sorcerer' WHERE entry = 23215; -- Ashtongue Sorcerer in Shade of Akama -UPDATE creature_template SET ScriptName = 'npc_enslaved_soul' WHERE entry = 23469; -- Enslaved Soul in Reliquary Event -UPDATE creature_template SET ScriptName = 'mob_doom_blossom' WHERE entry = 23123; -- Doom Blossoms in Teron Gorefiend's encounter --- UPDATE creature_template sET ScriptName = 'mob_shadowy_construct' WHERE entry = 23111; -- Shadowy Construct in Teron Gorefiend's encounter. Commented until Mind Control is implemented. --- UPDATE creature_template SET ScriptName = 'mob_najentus_spine' WHERE entry = 500000; -- Workaround creature for spine in Najentus event diff --git a/src/bindings/scripts/sql/Updates/r286_mangos.sql b/src/bindings/scripts/sql/Updates/r286_mangos.sql deleted file mode 100644 index d1d0a14dfa5..00000000000 --- a/src/bindings/scripts/sql/Updates/r286_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Items -UPDATE `item_template` SET `ScriptName` = '' WHERE `entry` = 23751; -- Remove script for Skin of Purest Water
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r289_mangos.sql b/src/bindings/scripts/sql/Updates/r289_mangos.sql deleted file mode 100644 index 48e08ebb878..00000000000 --- a/src/bindings/scripts/sql/Updates/r289_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `scriptname` = 'npc_creditmarker_visit_with_ancestors' WHERE `entry` IN (18840,18841,18842,18843);
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r291_mangos.sql b/src/bindings/scripts/sql/Updates/r291_mangos.sql deleted file mode 100644 index a85fb7bf34c..00000000000 --- a/src/bindings/scripts/sql/Updates/r291_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_spawn_of_fankriss' WHERE `entry` = 15630;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r295_mangos.sql b/src/bindings/scripts/sql/Updates/r295_mangos.sql deleted file mode 100644 index b992e0ee630..00000000000 --- a/src/bindings/scripts/sql/Updates/r295_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `instance_template` SET `script` = 'instance_stratholme' WHERE `map` = 329; -UPDATE `creature_template` SET `ScriptName` = 'boss_silver_hand_bosses' WHERE `entry` IN (17910, 17911, 17912, 17913, 17914); diff --git a/src/bindings/scripts/sql/Updates/r297_mangos.sql b/src/bindings/scripts/sql/Updates/r297_mangos.sql deleted file mode 100644 index 702013c465b..00000000000 --- a/src/bindings/scripts/sql/Updates/r297_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_berthold' WHERE `entry` = 16153; diff --git a/src/bindings/scripts/sql/Updates/r298_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r298_scriptdev2.sql deleted file mode 100644 index 953baee559b..00000000000 --- a/src/bindings/scripts/sql/Updates/r298_scriptdev2.sql +++ /dev/null @@ -1,2 +0,0 @@ --- EVENT_T_SPELLHIT -UPDATE eventai_scripts SET event_param3 = event_param2, event_param2 = -1 WHERE event_type = 10;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r299_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r299_scriptdev2.sql deleted file mode 100644 index 8b835b0ed7c..00000000000 --- a/src/bindings/scripts/sql/Updates/r299_scriptdev2.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE `eventai_summons` ( -`id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT, -`position_x` float NOT NULL default '0', -`position_y` float NOT NULL default '0', -`position_z` float NOT NULL default '0', -`orientation` float NOT NULL default '0', -`spawntimesecs` int(11) unsigned NOT NULL default '120', -PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations';
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r304_mangos.sql b/src/bindings/scripts/sql/Updates/r304_mangos.sql deleted file mode 100644 index 2a6ed9c0f60..00000000000 --- a/src/bindings/scripts/sql/Updates/r304_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (15440, 15612); diff --git a/src/bindings/scripts/sql/Updates/r306_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r306_scriptdev2.sql deleted file mode 100644 index 60eac88d01e..00000000000 --- a/src/bindings/scripts/sql/Updates/r306_scriptdev2.sql +++ /dev/null @@ -1,4 +0,0 @@ -DROP TABLE IF EXISTS `db_version`; -CREATE TABLE `db_version` ( -`version` varchar(255) NOT NULL default '' COMMENT 'Database version string' -) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r307_mangos.sql b/src/bindings/scripts/sql/Updates/r307_mangos.sql deleted file mode 100644 index e239d40700d..00000000000 --- a/src/bindings/scripts/sql/Updates/r307_mangos.sql +++ /dev/null @@ -1,4 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npcs_dithers_and_arbington' WHERE `entry` IN (11056, 11057); -UPDATE `creature_template` SET `ScriptName` = 'npc_witch_doctor_mauari' WHERE `entry` = 10307; -UPDATE `creature_template` SET `ScriptName` = 'npcs_riverbreeze_and_silversky' WHERE `entry` IN (9528, 9529); -UPDATE `creature_template` SET `ScriptName` = 'npc_sayge' WHERE `entry` = 14822; diff --git a/src/bindings/scripts/sql/Updates/r308_mangos.sql b/src/bindings/scripts/sql/Updates/r308_mangos.sql deleted file mode 100644 index b3c16a91402..00000000000 --- a/src/bindings/scripts/sql/Updates/r308_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_nat_pagle' WHERE `entry` = 12919; diff --git a/src/bindings/scripts/sql/Updates/r309_mangos.sql b/src/bindings/scripts/sql/Updates/r309_mangos.sql deleted file mode 100644 index 03bd078c7ab..00000000000 --- a/src/bindings/scripts/sql/Updates/r309_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_webbed_creature' WHERE `entry` = 17680; diff --git a/src/bindings/scripts/sql/Updates/r311_mangos.sql b/src/bindings/scripts/sql/Updates/r311_mangos.sql deleted file mode 100644 index 22cb325623b..00000000000 --- a/src/bindings/scripts/sql/Updates/r311_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_invis_legion_teleporter' WHERE `entry` = 21807; diff --git a/src/bindings/scripts/sql/Updates/r312_mangos.sql b/src/bindings/scripts/sql/Updates/r312_mangos.sql deleted file mode 100644 index 978152764bd..00000000000 --- a/src/bindings/scripts/sql/Updates/r312_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_captured_sunhawk_agent' WHERE `entry` = 17824; -UPDATE `creature_template` SET `ScriptName` = 'npc_neltharaku' WHERE `entry` = 21657; diff --git a/src/bindings/scripts/sql/Updates/r318_mangos.sql b/src/bindings/scripts/sql/Updates/r318_mangos.sql deleted file mode 100644 index 5ce2afca20f..00000000000 --- a/src/bindings/scripts/sql/Updates/r318_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npcs_flanis_swiftwing_and_kagrosh' WHERE `entry` IN (21725, 21727); diff --git a/src/bindings/scripts/sql/Updates/r324_mangos.sql b/src/bindings/scripts/sql/Updates/r324_mangos.sql deleted file mode 100644 index 4b9fb91dc2d..00000000000 --- a/src/bindings/scripts/sql/Updates/r324_mangos.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_mortog_steamhead' WHERE `entry` = 23373; -UPDATE `creature_template` SET `ScriptName` = 'npc_veronia' WHERE `entry` = 20162; -UPDATE `creature_template` SET `ScriptName` = 'npc_susurrus' WHERE `entry` = 17435; diff --git a/src/bindings/scripts/sql/Updates/r327_mangos.sql b/src/bindings/scripts/sql/Updates/r327_mangos.sql deleted file mode 100644 index d2d56fdfc3c..00000000000 --- a/src/bindings/scripts/sql/Updates/r327_mangos.sql +++ /dev/null @@ -1,5 +0,0 @@ --- Sunspring Villagers. -UPDATE `creature_template` SET `ScriptName` = 'mob_sunspring_villager' WHERE `entry` = 18240; - --- Terestian Illhoof -UPDATE `creature_template` SET `ScriptName` = 'mob_demon_chain' WHERE `entry` = 17248; diff --git a/src/bindings/scripts/sql/Updates/r332_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r332_scriptdev2.sql deleted file mode 100644 index ea67d3e7392..00000000000 --- a/src/bindings/scripts/sql/Updates/r332_scriptdev2.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE eventai_summons -ADD `comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment' AFTER spawntimesecs;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r333_mangos.sql b/src/bindings/scripts/sql/Updates/r333_mangos.sql deleted file mode 100644 index 48a7f673fad..00000000000 --- a/src/bindings/scripts/sql/Updates/r333_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_oronok_tornheart' WHERE `entry` = 21183; diff --git a/src/bindings/scripts/sql/Updates/r334_mangos.sql b/src/bindings/scripts/sql/Updates/r334_mangos.sql deleted file mode 100644 index 5d010c62209..00000000000 --- a/src/bindings/scripts/sql/Updates/r334_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `instance_template` SET `script` = 'instance_sethekk_halls' WHERE `map` = 556; diff --git a/src/bindings/scripts/sql/Updates/r336_mangos.sql b/src/bindings/scripts/sql/Updates/r336_mangos.sql deleted file mode 100644 index 993b954bb4b..00000000000 --- a/src/bindings/scripts/sql/Updates/r336_mangos.sql +++ /dev/null @@ -1,9 +0,0 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'go_tablet_of_madness' WHERE `entry` = 180368; -UPDATE `creature_template` SET `ScriptName` = 'boss_grilek' WHERE `entry` = 15082; -UPDATE `creature_template` SET `ScriptName` = 'boss_hazzarah' WHERE `entry` = 15083; -UPDATE `creature_template` SET `ScriptName` = 'boss_renataki' WHERE `entry` = 15084; -UPDATE `creature_template` SET `ScriptName` = 'boss_wushoolay' WHERE `entry` = 15085; -UPDATE `creature_template` SET `ScriptName` = 'mobs_zulgurub' WHERE `entry` = 14883; -UPDATE `creature_template` SET `ScriptName` = 'mob_blackwing_lair' WHERE `entry` = 12468; - - diff --git a/src/bindings/scripts/sql/Updates/r352_mangos.sql b/src/bindings/scripts/sql/Updates/r352_mangos.sql deleted file mode 100644 index a40281bcd33..00000000000 --- a/src/bindings/scripts/sql/Updates/r352_mangos.sql +++ /dev/null @@ -1,23 +0,0 @@ --- Moroes -update creature_template set scriptname = "boss_moroes" where entry = 15687; -update creature_template set scriptname = "boss_baroness_dorothea_millstipe" where entry = 19875; -update creature_template set scriptname = "boss_baron_rafe_dreuger" where entry = 19874; -update creature_template set scriptname = "boss_lady_catriona_von_indi" where entry = 19872; -update creature_template set scriptname = "boss_lady_keira_berrybuck" where entry = 17007; -update creature_template set scriptname = "boss_lord_robin_daris" where entry = 19876; -update creature_template set scriptname = "boss_lord_crispin_ference" where entry = 19873; - --- Barnes -update creature_template set scriptname = "npc_barnes" where entry = 16812; --- Oz Event -update creature_template set scriptname = "boss_dorothee" where entry = 17535; -update creature_template set scriptname = "boss_strawman" where entry = 17543; -update creature_template set scriptname = "boss_tinhead" where entry = 17547; -update creature_template set scriptname = "boss_roar" where entry = 17546; -update creature_template set scriptname = "boss_crone" where entry = 18168; --- Hood Event -update creature_template set scriptname = "npc_grandmother" where entry = 17603; -update creature_template set scriptname = "boss_bigbadwolf" where entry = 17521; --- Romeo and Juliet disabled for now --- update creature_template set scriptname = "boss_julianne" where entry = 17543; --- update creature_template set scriptname = "boss_romulo" where entry = 17533; diff --git a/src/bindings/scripts/sql/Updates/r355_mangos.sql b/src/bindings/scripts/sql/Updates/r355_mangos.sql deleted file mode 100644 index a40281bcd33..00000000000 --- a/src/bindings/scripts/sql/Updates/r355_mangos.sql +++ /dev/null @@ -1,23 +0,0 @@ --- Moroes -update creature_template set scriptname = "boss_moroes" where entry = 15687; -update creature_template set scriptname = "boss_baroness_dorothea_millstipe" where entry = 19875; -update creature_template set scriptname = "boss_baron_rafe_dreuger" where entry = 19874; -update creature_template set scriptname = "boss_lady_catriona_von_indi" where entry = 19872; -update creature_template set scriptname = "boss_lady_keira_berrybuck" where entry = 17007; -update creature_template set scriptname = "boss_lord_robin_daris" where entry = 19876; -update creature_template set scriptname = "boss_lord_crispin_ference" where entry = 19873; - --- Barnes -update creature_template set scriptname = "npc_barnes" where entry = 16812; --- Oz Event -update creature_template set scriptname = "boss_dorothee" where entry = 17535; -update creature_template set scriptname = "boss_strawman" where entry = 17543; -update creature_template set scriptname = "boss_tinhead" where entry = 17547; -update creature_template set scriptname = "boss_roar" where entry = 17546; -update creature_template set scriptname = "boss_crone" where entry = 18168; --- Hood Event -update creature_template set scriptname = "npc_grandmother" where entry = 17603; -update creature_template set scriptname = "boss_bigbadwolf" where entry = 17521; --- Romeo and Juliet disabled for now --- update creature_template set scriptname = "boss_julianne" where entry = 17543; --- update creature_template set scriptname = "boss_romulo" where entry = 17533; diff --git a/src/bindings/scripts/sql/Updates/r358_mangos.sql b/src/bindings/scripts/sql/Updates/r358_mangos.sql deleted file mode 100644 index 01db3736d2e..00000000000 --- a/src/bindings/scripts/sql/Updates/r358_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -update creature_template set scriptname = "mob_cyclone" where entry = 18412;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r364_mangos.sql b/src/bindings/scripts/sql/Updates/r364_mangos.sql deleted file mode 100644 index d893f4d923c..00000000000 --- a/src/bindings/scripts/sql/Updates/r364_mangos.sql +++ /dev/null @@ -1,7 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_ayren_cloudbreaker' WHERE `entry` = 25059; -UPDATE `creature_template` SET `ScriptName` = 'npc_unrestrained_dragonhawk' WHERE `entry` = 25236; -UPDATE `creature_template` SET `ScriptName` = 'npc_sputtervalve' WHERE `entry` = 3442; -UPDATE `creature_template` SET `ScriptName` = 'npc_budd_nedreck' WHERE `entry` = 23559; -UPDATE `creature_template` SET `ScriptName` = 'npc_blood_knight_dawnstar' WHERE `entry` = 17832; -UPDATE `creature_template` SET `ScriptName` = 'npc_stone_watcher_of_norgannon' WHERE `entry` = 7918; -UPDATE `creature_template` SET `ScriptName` = 'npc_lore_keeper_of_norgannon' WHERE `entry` = 7172; diff --git a/src/bindings/scripts/sql/Updates/r367_mangos.sql b/src/bindings/scripts/sql/Updates/r367_mangos.sql deleted file mode 100644 index 29a27c7d745..00000000000 --- a/src/bindings/scripts/sql/Updates/r367_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_aquementas' WHERE `entry` = 9453; diff --git a/src/bindings/scripts/sql/Updates/r368_mangos.sql b/src/bindings/scripts/sql/Updates/r368_mangos.sql deleted file mode 100644 index b4cf82da064..00000000000 --- a/src/bindings/scripts/sql/Updates/r368_mangos.sql +++ /dev/null @@ -1,5 +0,0 @@ -UPDATE `instance_template` SET `script` = 'instance_shadowfang_keep' WHERE `map` = 33; -UPDATE `creature_template` SET `ScriptName` = 'boss_fenrus' WHERE `entry` = 4274; -UPDATE `creature_template` SET `ScriptName` = 'boss_nandos' WHERE `entry` = 3927; -UPDATE `creature_template` SET `ScriptName` = 'boss_rethilgore' WHERE `entry` = 3914; -UPDATE `creature_template` SET `ScriptName` = 'npc_shadowfang_prisoner' WHERE `entry` IN (3849, 3850); diff --git a/src/bindings/scripts/sql/Updates/r369_mangos.sql b/src/bindings/scripts/sql/Updates/r369_mangos.sql deleted file mode 100644 index 1d053e5f583..00000000000 --- a/src/bindings/scripts/sql/Updates/r369_mangos.sql +++ /dev/null @@ -1,5 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_rage_winterchill' WHERE `entry` = 17767; -UPDATE `creature_template` SET `ScriptName` = 'boss_anetheron' WHERE `entry` = 17808; -UPDATE `creature_template` SET `ScriptName` = 'boss_kazrogal' WHERE `entry` = 17888; -UPDATE `creature_template` SET `ScriptName` = 'boss_azgalor' WHERE `entry` = 17842; -UPDATE `creature_template` SET `ScriptName` = 'mob_echo_of_archimonde' WHERE `entry` = 13083;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r374_mangos.sql b/src/bindings/scripts/sql/Updates/r374_mangos.sql deleted file mode 100644 index f430c086f00..00000000000 --- a/src/bindings/scripts/sql/Updates/r374_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_the_scourge_cauldron' WHERE `entry` = 11152; diff --git a/src/bindings/scripts/sql/Updates/r386_mangos.sql b/src/bindings/scripts/sql/Updates/r386_mangos.sql deleted file mode 100644 index 7913666b5ce..00000000000 --- a/src/bindings/scripts/sql/Updates/r386_mangos.sql +++ /dev/null @@ -1,7 +0,0 @@ -UPDATE `item_template` SET `ScriptName` = 'item_Sparrowhawk_Net' WHERE `entry` = 32321; -UPDATE `item_template` SET `ScriptName` = 'item_Blackwhelp_Net' WHERE `entry` = 31129; - -UPDATE `creature_template` SET `ScriptName` = 'npc_spirit_of_olum' WHERE `entry` = 23411; - -UPDATE creature_template SET ScriptName='boss_warp_splinter' WHERE entry='17977'; -UPDATE creature_template SET ScriptName='mob_warp_splinter_treant' WHERE entry='19949';
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r417_mangos.sql b/src/bindings/scripts/sql/Updates/r417_mangos.sql deleted file mode 100644 index c9c08fe598b..00000000000 --- a/src/bindings/scripts/sql/Updates/r417_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `item_template` SET `ScriptName` = 'item_tame_beast_rods' WHERE `entry` IN (15908,15911,15913,15914,15915,15916,15917,15919,15920,15921,15922,15923,23697,23702,23703,23896,23897,23898); diff --git a/src/bindings/scripts/sql/Updates/r428_mangos.sql b/src/bindings/scripts/sql/Updates/r428_mangos.sql deleted file mode 100644 index 997c636332d..00000000000 --- a/src/bindings/scripts/sql/Updates/r428_mangos.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Quest Support 10804 (Kindness) -UPDATE creature_template SET scriptname = 'mob_mature_netherwing_drake' WHERE entry = 21648; --- Quest Support 10854 (The Force of Neltharaku) -UPDATE creature_template SET scriptname = 'mob_enslaved_netherwing_drake' WHERE entry = 21722;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r431_mangos.sql b/src/bindings/scripts/sql/Updates/r431_mangos.sql deleted file mode 100644 index bd8481815eb..00000000000 --- a/src/bindings/scripts/sql/Updates/r431_mangos.sql +++ /dev/null @@ -1,4 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_zephyr' WHERE `entry`=25967; -UPDATE `instance_template` SET `script`='instance_old_hillsbrad' WHERE `map`=560; -UPDATE `creature_template` SET `ScriptName`='npc_brazen' WHERE `entry`=18725; -UPDATE `creature_template` SET `ScriptName`='npc_erozion' WHERE `entry`=18723; diff --git a/src/bindings/scripts/sql/Updates/r444_mangos.sql b/src/bindings/scripts/sql/Updates/r444_mangos.sql deleted file mode 100644 index c45fa7b9620..00000000000 --- a/src/bindings/scripts/sql/Updates/r444_mangos.sql +++ /dev/null @@ -1,5 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=22120; -UPDATE `creature_template` SET `ScriptName`='mob_fathom_sporebat' WHERE `entry`=22140; -UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=20318; -UPDATE `creature_template` SET `ScriptName`='mob_eventai' WHERE `entry` IN (3927,3914,4274); -UPDATE `creature_template` SET `ScriptName`='mob_eventai' WHERE `entry` IN (21717,21718,21719,21720,22331,21878,21879,18371,18343,13083,17808); diff --git a/src/bindings/scripts/sql/Updates/r445_mangos.sql b/src/bindings/scripts/sql/Updates/r445_mangos.sql deleted file mode 100644 index 5ca5011dd4e..00000000000 --- a/src/bindings/scripts/sql/Updates/r445_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_high_astromancer_solarian' WHERE `entry`=18805; -UPDATE `creature_template` SET `ScriptName`='mob_solarium_priest' WHERE `entry`=18806; diff --git a/src/bindings/scripts/sql/Updates/r446_mangos.sql b/src/bindings/scripts/sql/Updates/r446_mangos.sql deleted file mode 100644 index a8a819e3b67..00000000000 --- a/src/bindings/scripts/sql/Updates/r446_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Set ACID (mob_eventai) ScriptName for 4 Hyjal-wave bosses -UPDATE `creature_template` SET `ScriptName` = 'mob_eventai' WHERE `entry` IN (17767, 17808, 17888, 17842); diff --git a/src/bindings/scripts/sql/Updates/r448_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r448_scriptdev2.sql deleted file mode 100644 index 66d78082aa0..00000000000 --- a/src/bindings/scripts/sql/Updates/r448_scriptdev2.sql +++ /dev/null @@ -1,5 +0,0 @@ -DROP TABLE IF EXISTS `db_version`; -DROP TABLE IF EXISTS `sd2_db_version`; -CREATE TABLE `sd2_db_version` ( -`version` varchar(255) NOT NULL default '' COMMENT 'Database version string' -) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r462_mangos.sql b/src/bindings/scripts/sql/Updates/r462_mangos.sql deleted file mode 100644 index 6d8ac269de3..00000000000 --- a/src/bindings/scripts/sql/Updates/r462_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_taretha' WHERE `entry`=18887; -UPDATE `creature_template` SET `ScriptName`='npc_thrall_old_hillsbrad' WHERE `entry`=17876; diff --git a/src/bindings/scripts/sql/Updates/r465_mangos.sql b/src/bindings/scripts/sql/Updates/r465_mangos.sql deleted file mode 100644 index 35d7d3834f1..00000000000 --- a/src/bindings/scripts/sql/Updates/r465_mangos.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_harbinger_skyriss' WHERE `entry`=20912; -UPDATE `creature_template` SET `ScriptName`='npc_warden_mellichar' WHERE `entry`=20904; -UPDATE `creature_template` SET `ScriptName`='npc_millhouse_manastorm' WHERE `entry`=20977; diff --git a/src/bindings/scripts/sql/Updates/r467_mangos.sql b/src/bindings/scripts/sql/Updates/r467_mangos.sql deleted file mode 100644 index 711bba7cc94..00000000000 --- a/src/bindings/scripts/sql/Updates/r467_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `item_template` SET `ScriptName`='item_flying_machine' WHERE `entry` IN (34060,34061); diff --git a/src/bindings/scripts/sql/Updates/r473_mangos.sql b/src/bindings/scripts/sql/Updates/r473_mangos.sql deleted file mode 100644 index f9918bc1b71..00000000000 --- a/src/bindings/scripts/sql/Updates/r473_mangos.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `item_template` SET `ScriptName`='item_soul_cannon' WHERE `entry`=32825; -UPDATE `item_template` SET `ScriptName`='item_sparrowhawk_net' WHERE `entry`=32321; -UPDATE `item_template` SET `ScriptName`='item_blackwhelp_net' WHERE `entry`=31129; diff --git a/src/bindings/scripts/sql/Updates/r476_mangos.sql b/src/bindings/scripts/sql/Updates/r476_mangos.sql deleted file mode 100644 index 998045f2193..00000000000 --- a/src/bindings/scripts/sql/Updates/r476_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_engineer_spark_overgrind' WHERE `entry`=17243; diff --git a/src/bindings/scripts/sql/Updates/r477_mangos.sql b/src/bindings/scripts/sql/Updates/r477_mangos.sql deleted file mode 100644 index 0f9c76c5336..00000000000 --- a/src/bindings/scripts/sql/Updates/r477_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=19577; diff --git a/src/bindings/scripts/sql/Updates/r479_mangos.sql b/src/bindings/scripts/sql/Updates/r479_mangos.sql deleted file mode 100644 index 216fe068317..00000000000 --- a/src/bindings/scripts/sql/Updates/r479_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_chicken_cluck' WHERE `entry`=620; diff --git a/src/bindings/scripts/sql/Updates/r482_mangos.sql b/src/bindings/scripts/sql/Updates/r482_mangos.sql deleted file mode 100644 index b431b85c90e..00000000000 --- a/src/bindings/scripts/sql/Updates/r482_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_dancing_flames' WHERE `entry`=25305; diff --git a/src/bindings/scripts/sql/Updates/r484_mangos.sql b/src/bindings/scripts/sql/Updates/r484_mangos.sql deleted file mode 100644 index 1f4fefd7fa1..00000000000 --- a/src/bindings/scripts/sql/Updates/r484_mangos.sql +++ /dev/null @@ -1,8 +0,0 @@ --- Quest support 9678 -UPDATE `gameobject_template` SET `ScriptName`='go_gilded_brazier' WHERE `entry` = '181956'; - --- Archimonde with related creatures. -UPDATE `creature_template` SET `Scriptname` = "boss_archimonde" WHERE `entry` = 17968; -UPDATE `creature_template` SET `ScriptName` = "mob_doomfire" WHERE `entry` = 18095; -UPDATE `creature_template` SET `Scriptname` = "mob_doomfire_targetting" WHERE `entry` = 18104; -UPDATE `creature_template` SET `ScriptName` = "mob_ancient_wisp" WHERE `entry` = 17946; diff --git a/src/bindings/scripts/sql/Updates/r486_mangos.sql b/src/bindings/scripts/sql/Updates/r486_mangos.sql deleted file mode 100644 index 28920abf0db..00000000000 --- a/src/bindings/scripts/sql/Updates/r486_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `gameobject_template` SET `ScriptName`='' WHERE `entry`=181956; diff --git a/src/bindings/scripts/sql/Updates/r487_mangos.sql b/src/bindings/scripts/sql/Updates/r487_mangos.sql deleted file mode 100644 index 229be423977..00000000000 --- a/src/bindings/scripts/sql/Updates/r487_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_prospector_anvilward' WHERE `entry`=15420; diff --git a/src/bindings/scripts/sql/Updates/r494_mangos.sql b/src/bindings/scripts/sql/Updates/r494_mangos.sql deleted file mode 100644 index c8f5aef5d9a..00000000000 --- a/src/bindings/scripts/sql/Updates/r494_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'gameobject_cage_trap' WHERE `entry` = 185916; diff --git a/src/bindings/scripts/sql/Updates/r501_mangos.sql b/src/bindings/scripts/sql/Updates/r501_mangos.sql deleted file mode 100644 index 7242f3b8a7b..00000000000 --- a/src/bindings/scripts/sql/Updates/r501_mangos.sql +++ /dev/null @@ -1,4 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_prof_alchemy' WHERE `entry` IN (17909,19052,22427); -UPDATE `creature_template` SET `ScriptName`='npc_prof_blacksmith' WHERE `entry` IN (5164,11145,11146,11176,11177,11178,11191,11192,11193); -UPDATE `creature_template` SET `ScriptName`='npc_prof_leather' WHERE `entry` IN (7866,7867,7868,7869,7870,7871); -UPDATE `creature_template` SET `ScriptName`='npc_prof_tailor' WHERE `entry` IN (22208,22212,22213); diff --git a/src/bindings/scripts/sql/Updates/r513_mangos.sql b/src/bindings/scripts/sql/Updates/r513_mangos.sql deleted file mode 100644 index fcc3433fa59..00000000000 --- a/src/bindings/scripts/sql/Updates/r513_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_salsalabim' WHERE `entry`=18584; diff --git a/src/bindings/scripts/sql/Updates/r514_mangos.sql b/src/bindings/scripts/sql/Updates/r514_mangos.sql deleted file mode 100644 index 108948250d9..00000000000 --- a/src/bindings/scripts/sql/Updates/r514_mangos.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_raliq_the_drunk' WHERE `entry`=18585; -UPDATE `creature_template` SET `ScriptName`='npc_cooshcoosh' WHERE `entry`=18586; -UPDATE `creature_template` SET `ScriptName`='npc_floon' WHERE `entry`=18588; diff --git a/src/bindings/scripts/sql/Updates/r515_mangos.sql b/src/bindings/scripts/sql/Updates/r515_mangos.sql deleted file mode 100644 index 8860641d493..00000000000 --- a/src/bindings/scripts/sql/Updates/r515_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_murkblood_overseer' WHERE `entry`=23309; diff --git a/src/bindings/scripts/sql/Updates/r516_mangos.sql b/src/bindings/scripts/sql/Updates/r516_mangos.sql deleted file mode 100644 index 76bd7b83780..00000000000 --- a/src/bindings/scripts/sql/Updates/r516_mangos.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_neeru_fireblade' WHERE `entry`=3216; -UPDATE `creature_template` SET `ScriptName`='npc_shenthul' WHERE `entry`=3401; -UPDATE `creature_template` SET `ScriptName`='npc_thrall_warchief' WHERE `entry`=4949; diff --git a/src/bindings/scripts/sql/Updates/r517_mangos.sql b/src/bindings/scripts/sql/Updates/r517_mangos.sql deleted file mode 100644 index 2077e416c81..00000000000 --- a/src/bindings/scripts/sql/Updates/r517_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_taskmaster_fizzule' WHERE `entry`=7233; diff --git a/src/bindings/scripts/sql/Updates/r518_mangos.sql b/src/bindings/scripts/sql/Updates/r518_mangos.sql deleted file mode 100644 index 5930aba9256..00000000000 --- a/src/bindings/scripts/sql/Updates/r518_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_rathis_tomber' WHERE `entry`=16224; diff --git a/src/bindings/scripts/sql/Updates/r519_mangos.sql b/src/bindings/scripts/sql/Updates/r519_mangos.sql deleted file mode 100644 index fa408a043ec..00000000000 --- a/src/bindings/scripts/sql/Updates/r519_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_calvin_montague' WHERE `entry`=6784; diff --git a/src/bindings/scripts/sql/Updates/r520_mangos.sql b/src/bindings/scripts/sql/Updates/r520_mangos.sql deleted file mode 100644 index 959ac79be55..00000000000 --- a/src/bindings/scripts/sql/Updates/r520_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `item_template` SET `ScriptName`='item_disciplinary_rod' WHERE `entry`=22473; -UPDATE `item_template` SET `ScriptName`='item_protovoltaic_magneto_collector' WHERE `entry`=30656; diff --git a/src/bindings/scripts/sql/Updates/r521_mangos.sql b/src/bindings/scripts/sql/Updates/r521_mangos.sql deleted file mode 100644 index 37d09546b0a..00000000000 --- a/src/bindings/scripts/sql/Updates/r521_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_gregan_brewspewer' WHERE `entry`=7775; diff --git a/src/bindings/scripts/sql/Updates/r522_mangos.sql b/src/bindings/scripts/sql/Updates/r522_mangos.sql deleted file mode 100644 index 159e6e83826..00000000000 --- a/src/bindings/scripts/sql/Updates/r522_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='guard_shattrath_aldor' WHERE `entry`=18549; -UPDATE `creature_template` SET `ScriptName`='guard_shattrath_scryer' WHERE `entry`=18568; diff --git a/src/bindings/scripts/sql/Updates/r526_mangos.sql b/src/bindings/scripts/sql/Updates/r526_mangos.sql deleted file mode 100644 index 2171bed6570..00000000000 --- a/src/bindings/scripts/sql/Updates/r526_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_injured_draenei' WHERE `entry`=16971; diff --git a/src/bindings/scripts/sql/Updates/r528_mangos.sql b/src/bindings/scripts/sql/Updates/r528_mangos.sql deleted file mode 100644 index 90b63aabe40..00000000000 --- a/src/bindings/scripts/sql/Updates/r528_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_skorn_whitecloud' WHERE `entry`=3052; -UPDATE `creature_template` SET `ScriptName`='npc_blood_knight_stillblade' WHERE `entry`=17768; diff --git a/src/bindings/scripts/sql/Updates/r533_mangos.sql b/src/bindings/scripts/sql/Updates/r533_mangos.sql deleted file mode 100644 index a05d4bfb732..00000000000 --- a/src/bindings/scripts/sql/Updates/r533_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_augustus_the_touched' WHERE `entry`=12384; diff --git a/src/bindings/scripts/sql/Updates/r538_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r538_scriptdev2.sql deleted file mode 100644 index 92ef9ea24ff..00000000000 --- a/src/bindings/scripts/sql/Updates/r538_scriptdev2.sql +++ /dev/null @@ -1,60 +0,0 @@ --- Structure updates - -ALTER TABLE eventai_scripts -ADD event_flags tinyint(3) unsigned NOT NULL default '0' AFTER event_chance; - -ALTER TABLE eventai_scripts -ADD event_param4 int(11) signed NOT NULL default '0' AFTER event_param3; - --- Event updates - --- EVENT_T_TIMER_REPEAT -UPDATE eventai_scripts SET event_param4 = event_param3+event_param1, event_param3 = event_param1, event_param1 = event_param2, event_flags = 1 WHERE event_type = 0; - --- EVENT_T_TIMER_SINGLE -UPDATE eventai_scripts SET event_param4 = event_param3+event_param1, event_param3 = event_param1, event_param1 = event_param2, event_type = 0 WHERE event_type = 1; - --- EVENT_T_TIMER_OOC_REPEAT -UPDATE eventai_scripts SET event_param4 = event_param3+event_param1, event_param3 = event_param1, event_param1 = event_param2, event_flags = 1, event_type = 1 WHERE event_type = 2; - --- EVENT_T_TIMER_OOC_SINGLE -UPDATE eventai_scripts SET event_param4 = event_param3+event_param1, event_param3 = event_param1, event_param1 = event_param2, event_type = 1 WHERE event_type = 3; - --- EVENT_T_HP_SINGLE -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 0, event_type = 2 WHERE event_type = 4; - --- EVENT_T_MANA_SINGLE -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 0, event_type = 3 WHERE event_type = 5; - --- EVENT_T_AGGRO -UPDATE eventai_scripts SET event_type = 4 WHERE event_type = 6; - --- EVENT_T_KILL -UPDATE eventai_scripts SET event_param2 = event_param1, event_flags = 1, event_type = 5 WHERE event_type = 7; - --- EVENT_T_DEATH -UPDATE eventai_scripts SET event_type = 6 WHERE event_type = 8; - --- EVENT_T_EVADE -UPDATE eventai_scripts SET event_type = 7 WHERE event_type = 9; - --- EVENT_T_SPELLHIT -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 1, event_type = 8 WHERE event_type = 10; - --- EVENT_T_RANGE -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 1, event_type = 9 WHERE event_type = 11; - --- EVENT_T_OOC_LOS -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 1, event_type = 10 WHERE event_type = 12; - --- EVENT_T_SPAWNED -UPDATE eventai_scripts SET event_type = 11 WHERE event_type = 13; - --- EVENT_T_TARGET_HP -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 1, event_type = 12 WHERE event_type = 14; - --- EVENT_T_TARGET_CASTING -UPDATE eventai_scripts SET event_param2 = event_param1, event_flags = 1, event_type = 13 WHERE event_type = 15; - --- EVENT_T_FRIENDLY_HP -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 1, event_type = 14 WHERE event_type = 16;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r547_mangos.sql b/src/bindings/scripts/sql/Updates/r547_mangos.sql deleted file mode 100644 index cc98862022e..00000000000 --- a/src/bindings/scripts/sql/Updates/r547_mangos.sql +++ /dev/null @@ -1,22 +0,0 @@ -/* Magister's Terrace */ -UPDATE `instance_template` SET `script` = 'instance_magisters_terrace' WHERE `map` = 585; -UPDATE `creature_template` SET `ScriptName` = 'boss_selin_fireheart' WHERE `entry` = 24723; -UPDATE `creature_template` SET `ScriptName` = 'mob_fel_crystal' WHERE `entry` = 24722; -UPDATE `creature_template` SET `ScriptName` = 'boss_vexallus' WHERE `entry` = 24744; -UPDATE `creature_template` SET `ScriptName` = 'mob_pure_energy' WHERE `entry` = 24745; -UPDATE `creature_template` SET `ScriptName` = 'boss_priestess_delrissa' WHERE `entry` = 24560; -UPDATE `creature_template` SET `ScriptName` = 'boss_kagani_nightstrike' WHERE `entry` = 24557; -UPDATE `creature_template` SET `ScriptName` = 'boss_ellris_duskhallow' WHERE `entry` = 24558; -UPDATE `creature_template` SET `ScriptName` = 'mob_imp' WHERE `entry` = 24656; -UPDATE `creature_template` SET `ScriptName` = 'boss_eramas_brightblaze' WHERE `entry` = 24554; -UPDATE `creature_template` SET `ScriptName` = 'boss_yazzai' WHERE `entry` = 24561; -UPDATE `creature_template` SET `ScriptName` = 'boss_warlord_salaris' WHERE `entry` = 24559; -UPDATE `creature_template` SET `ScriptName` = 'boss_garaxxas' WHERE `entry` = 24555; -UPDATE `creature_template` SET `ScriptName` = 'mob_sliver' WHERE `entry` = 24552; -UPDATE `creature_template` SET `ScriptName` = 'boss_apoko' WHERE `entry` = 24553; -UPDATE `creature_template` SET `ScriptName` = 'boss_zelfan' WHERE `entry` = 24556; -UPDATE `creature_template` SET `ScriptName` = 'boss_felblood_kaelthas' WHERE `entry` = 24664; -UPDATE `creature_template` SET `ScriptName` = 'mob_arcane_sphere' WHERE `entry` = 24708; -UPDATE `creature_template` SET `ScriptName` = 'mob_felkael_phoenix' WHERE `entry` = 24674; -UPDATE `creature_template` SET `ScriptName` = 'mob_felkael_phoenix_egg' WHERE `entry` = 24675; -UPDATE `creature_template` SET `ScriptName` = 'mob_felkael_flamestrike' WHERE `entry` = 24666;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r554_mangos.sql b/src/bindings/scripts/sql/Updates/r554_mangos.sql deleted file mode 100644 index b6beac3adce..00000000000 --- a/src/bindings/scripts/sql/Updates/r554_mangos.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_mekgineer_steamrigger' WHERE `entry`=17796; -UPDATE `creature_template` SET `ScriptName`='mob_steamrigger_mechanic' WHERE `entry`=17951; -UPDATE `creature_template` SET `ScriptName`='mob_naga_distiller' WHERE `entry`=17954; diff --git a/src/bindings/scripts/sql/Updates/r555_mangos.sql b/src/bindings/scripts/sql/Updates/r555_mangos.sql deleted file mode 100644 index f0284ddd037..00000000000 --- a/src/bindings/scripts/sql/Updates/r555_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `gameobject_template` SET `ScriptName`='go_manaforge_control_console' WHERE `entry` IN (183770,183956,184311,184312); -UPDATE `creature_template` SET `ScriptName`='npc_manaforge_control_console' WHERE `entry` IN (20209,20417,20418,20440); diff --git a/src/bindings/scripts/sql/Updates/r56.sql b/src/bindings/scripts/sql/Updates/r56.sql deleted file mode 100644 index 69e31e9e21c..00000000000 --- a/src/bindings/scripts/sql/Updates/r56.sql +++ /dev/null @@ -1,2 +0,0 @@ -/* Remove guildmaster script from npc's. Core has full support */ -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (4974,5054,4613); diff --git a/src/bindings/scripts/sql/Updates/r575_mangos.sql b/src/bindings/scripts/sql/Updates/r575_mangos.sql deleted file mode 100644 index bbf52bd5c96..00000000000 --- a/src/bindings/scripts/sql/Updates/r575_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `item_template` SET `ScriptName`='item_gor_dreks_ointment' WHERE `entry`=30175; diff --git a/src/bindings/scripts/sql/Updates/r576_mangos.sql b/src/bindings/scripts/sql/Updates/r576_mangos.sql deleted file mode 100644 index 0df34443309..00000000000 --- a/src/bindings/scripts/sql/Updates/r576_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `item_template` SET `ScriptName`='item_muiseks_vessel' WHERE `entry` IN (9606,9618,9619,9620,9621); diff --git a/src/bindings/scripts/sql/Updates/r578_mangos.sql b/src/bindings/scripts/sql/Updates/r578_mangos.sql deleted file mode 100644 index f82ea62c26e..00000000000 --- a/src/bindings/scripts/sql/Updates/r578_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_forest_frog' WHERE `entry`=24396; diff --git a/src/bindings/scripts/sql/Updates/r584_mangos.sql b/src/bindings/scripts/sql/Updates/r584_mangos.sql deleted file mode 100644 index 0980b86cc4e..00000000000 --- a/src/bindings/scripts/sql/Updates/r584_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `item_template` SET `ScriptName`='item_voodoo_charm' WHERE `entry`=8149; diff --git a/src/bindings/scripts/sql/Updates/r59.sql b/src/bindings/scripts/sql/Updates/r59.sql deleted file mode 100644 index 219f96220b1..00000000000 --- a/src/bindings/scripts/sql/Updates/r59.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_narm_faulk' WHERE `entry`= 6177; -UPDATE `creature_template` SET `ScriptName` = 'npc_q8304' WHERE `entry` IN (15170, 15171); -UPDATE `creature_template` SET `ScriptName` = 'npc_q8507_q8731' WHERE `entry` IN (15440, 15612);
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r590_mangos.sql b/src/bindings/scripts/sql/Updates/r590_mangos.sql deleted file mode 100644 index 72348756d91..00000000000 --- a/src/bindings/scripts/sql/Updates/r590_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_sergeant_bly' WHERE `entry`=7604; -UPDATE `creature_template` SET `ScriptName`='npc_weegli_blastfuse' WHERE `entry`=7607; diff --git a/src/bindings/scripts/sql/Updates/r591_mangos.sql b/src/bindings/scripts/sql/Updates/r591_mangos.sql deleted file mode 100644 index 253fe3ed53b..00000000000 --- a/src/bindings/scripts/sql/Updates/r591_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='mobs_nether_drake' WHERE `entry` IN (20021,21817,21820,21821,21823); diff --git a/src/bindings/scripts/sql/Updates/r593_mangos.sql b/src/bindings/scripts/sql/Updates/r593_mangos.sql deleted file mode 100644 index ec6730e3d4e..00000000000 --- a/src/bindings/scripts/sql/Updates/r593_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `gameobject_template` SET `ScriptName`='go_tablet_of_the_seven' WHERE `entry`=169294; diff --git a/src/bindings/scripts/sql/Updates/r594_mangos.sql b/src/bindings/scripts/sql/Updates/r594_mangos.sql deleted file mode 100644 index 3315fd47241..00000000000 --- a/src/bindings/scripts/sql/Updates/r594_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='mob_anubisath_sentinel' WHERE `entry`=15264;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r596_mangos.sql b/src/bindings/scripts/sql/Updates/r596_mangos.sql deleted file mode 100644 index 2f0e4587883..00000000000 --- a/src/bindings/scripts/sql/Updates/r596_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_ambassador_hellmaw' WHERE `entry`=18731; diff --git a/src/bindings/scripts/sql/Updates/r610_mangos.sql b/src/bindings/scripts/sql/Updates/r610_mangos.sql deleted file mode 100644 index 1aa9f4b50b4..00000000000 --- a/src/bindings/scripts/sql/Updates/r610_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_lady_sylvanas_windrunner' WHERE `entry`=10181; -UPDATE `creature_template` SET `ScriptName`='npc_highborne_lamenter' WHERE `entry`=21628; diff --git a/src/bindings/scripts/sql/Updates/r615_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r615_scriptdev2.sql deleted file mode 100644 index 5c5625860f8..00000000000 --- a/src/bindings/scripts/sql/Updates/r615_scriptdev2.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Structure updates - -ALTER TABLE localized_texts -ADD `locale_8` varchar(255) NOT NULL default '' AFTER locale_7;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r617_mangos.sql b/src/bindings/scripts/sql/Updates/r617_mangos.sql deleted file mode 100644 index 7a30f9c553d..00000000000 --- a/src/bindings/scripts/sql/Updates/r617_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `item_template` SET `ScriptName`='item_razorthorn_flayer_gland' WHERE `entry`=34255; diff --git a/src/bindings/scripts/sql/Updates/r621_mangos.sql b/src/bindings/scripts/sql/Updates/r621_mangos.sql deleted file mode 100644 index 822de701ebb..00000000000 --- a/src/bindings/scripts/sql/Updates/r621_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_talon_king_ikiss' WHERE `entry`=18473; diff --git a/src/bindings/scripts/sql/Updates/r628_mangos.sql b/src/bindings/scripts/sql/Updates/r628_mangos.sql deleted file mode 100644 index 47d286d2718..00000000000 --- a/src/bindings/scripts/sql/Updates/r628_mangos.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `instance_template` SET `script`='instance_shattered_halls' WHERE `map`=540; -UPDATE `creature_template` SET `ScriptName`='mob_fel_orc_convert' WHERE `entry`=17083; -UPDATE `creature_template` SET `ScriptName`='mob_lesser_shadow_fissure' WHERE `entry`=17471; diff --git a/src/bindings/scripts/sql/Updates/r63.sql b/src/bindings/scripts/sql/Updates/r63.sql deleted file mode 100644 index 4627d40067b..00000000000 --- a/src/bindings/scripts/sql/Updates/r63.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_bartleby' WHERE `entry` IN (6090);
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r632_mangos.sql b/src/bindings/scripts/sql/Updates/r632_mangos.sql deleted file mode 100644 index 4ea0c35e6ea..00000000000 --- a/src/bindings/scripts/sql/Updates/r632_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_warbringer_omrogg' WHERE `entry`=16809; -UPDATE `creature_template` SET `ScriptName`='mob_omrogg_heads' WHERE `entry` IN (19523,19524); diff --git a/src/bindings/scripts/sql/Updates/r633_mangos.sql b/src/bindings/scripts/sql/Updates/r633_mangos.sql deleted file mode 100644 index bbf75d1f961..00000000000 --- a/src/bindings/scripts/sql/Updates/r633_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_rogue_trainer' WHERE `entry` IN (918,4163,3328,4583,5165,5167,13283,16684); diff --git a/src/bindings/scripts/sql/Updates/r634_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r634_scriptdev2.sql deleted file mode 100644 index 31791a57084..00000000000 --- a/src/bindings/scripts/sql/Updates/r634_scriptdev2.sql +++ /dev/null @@ -1,35 +0,0 @@ -DROP TABLE IF EXISTS `script_texts`; -CREATE TABLE `script_texts` ( -`ScriptName` varchar(255) NOT NULL default '', -`Id` int(11) unsigned NOT NULL default '0', -`Sound` int(11) unsigned NOT NULL default '0', -`Type` int(11) unsigned NOT NULL default '0', -`Language` int(11) unsigned NOT NULL default '0', -`Text` varchar(255) NOT NULL default '', -`Comment` varchar(255) NOT NULL default '', -PRIMARY KEY (`ScriptName`,`Id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'; - - -DROP TABLE IF EXISTS `script_localized_texts`; -CREATE TABLE `script_localized_texts` ( -`id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier', -`locale_1` varchar(255) NOT NULL default '', -`locale_2` varchar(255) NOT NULL default '', -`locale_3` varchar(255) NOT NULL default '', -`locale_4` varchar(255) NOT NULL default '', -`locale_5` varchar(255) NOT NULL default '', -`locale_6` varchar(255) NOT NULL default '', -`locale_7` varchar(255) NOT NULL default '', -`locale_8` varchar(255) NOT NULL default '', -`comment` varchar(255) NOT NULL default '' COMMENT 'Text Comment', -PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Localized Script Text'; - - -DROP TABLE IF EXISTS `eventai_texts`; -CREATE TABLE `eventai_texts` AS SELECT `id`, `locale_0` AS `text`, `comment` FROM `localized_texts`; -TRUNCATE TABLE `localized_texts`; -DROP TABLE IF EXISTS `eventai_localized_texts`; -ALTER TABLE `localized_texts` RENAME TO `eventai_localized_texts`; -ALTER TABLE `eventai_localized_texts` DROP COLUMN `locale_0`;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r636_mangos.sql b/src/bindings/scripts/sql/Updates/r636_mangos.sql deleted file mode 100644 index 55eea42bf2a..00000000000 --- a/src/bindings/scripts/sql/Updates/r636_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_laj' WHERE `entry`=17980; diff --git a/src/bindings/scripts/sql/Updates/r637_mangos.sql b/src/bindings/scripts/sql/Updates/r637_mangos.sql deleted file mode 100644 index 03a53749cab..00000000000 --- a/src/bindings/scripts/sql/Updates/r637_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_high_botanist_freywinn' WHERE `entry`=17975; diff --git a/src/bindings/scripts/sql/Updates/r638_mangos.sql b/src/bindings/scripts/sql/Updates/r638_mangos.sql deleted file mode 100644 index cf20d33e957..00000000000 --- a/src/bindings/scripts/sql/Updates/r638_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `item_template` SET `ScriptName`='item_attuned_crystal_cores' WHERE `entry`=34368; -UPDATE `creature_template` SET `ScriptName`='npc_converted_sentry' WHERE `entry`=24981; diff --git a/src/bindings/scripts/sql/Updates/r639_mangos.sql b/src/bindings/scripts/sql/Updates/r639_mangos.sql deleted file mode 100644 index 7946ac237ed..00000000000 --- a/src/bindings/scripts/sql/Updates/r639_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_ravenholdt' WHERE `entry`=13936; diff --git a/src/bindings/scripts/sql/Updates/r642_mangos.sql b/src/bindings/scripts/sql/Updates/r642_mangos.sql deleted file mode 100644 index b9963728279..00000000000 --- a/src/bindings/scripts/sql/Updates/r642_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='mob_shadowmoon_channeler' WHERE `entry`=17653; diff --git a/src/bindings/scripts/sql/Updates/r643_mangos.sql b/src/bindings/scripts/sql/Updates/r643_mangos.sql deleted file mode 100644 index 8659ebcb850..00000000000 --- a/src/bindings/scripts/sql/Updates/r643_mangos.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='mob_stolen_soul' WHERE `entry`=18441; -UPDATE `creature_template` SET `ScriptName`='mob_avatar_of_martyred' WHERE `entry`=18478; diff --git a/src/bindings/scripts/sql/Updates/r646_mangos.sql b/src/bindings/scripts/sql/Updates/r646_mangos.sql deleted file mode 100644 index 3f43d49bc32..00000000000 --- a/src/bindings/scripts/sql/Updates/r646_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_harbinger_skyriss_illusion' WHERE `entry` IN (21466,21467); diff --git a/src/bindings/scripts/sql/Updates/r647_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r647_scriptdev2.sql deleted file mode 100644 index bd259718b81..00000000000 --- a/src/bindings/scripts/sql/Updates/r647_scriptdev2.sql +++ /dev/null @@ -1,10 +0,0 @@ -DROP TABLE IF EXISTS `script_texts`; -CREATE TABLE `script_texts` ( -`id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier', -`sound` int(11) unsigned NOT NULL default '0', -`type` int(11) unsigned NOT NULL default '0', -`language` int(11) unsigned NOT NULL default '0', -`text` varchar(255) NOT NULL default '', -`comment` varchar(255) NOT NULL default '', -PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r65.sql b/src/bindings/scripts/sql/Updates/r65.sql deleted file mode 100644 index 2c878bfed56..00000000000 --- a/src/bindings/scripts/sql/Updates/r65.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `npcflag`='3', `ScriptName`='npc_lothos_riftwalker' WHERE `entry`='14387'; -UPDATE creature_template SET ScriptName="boss_gruul" WHERE entry=19044;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r656_scriptdev2.sql b/src/bindings/scripts/sql/Updates/r656_scriptdev2.sql deleted file mode 100644 index 96fcd146d76..00000000000 --- a/src/bindings/scripts/sql/Updates/r656_scriptdev2.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE -`eventai_localized_texts` ADD COLUMN `locale_8` varchar(255) NOT NULL default '' AFTER locale_7; - -ALTER TABLE -`script_localized_texts` ADD COLUMN `locale_8` varchar(255) NOT NULL default '' AFTER locale_7;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r658_mangos.sql b/src/bindings/scripts/sql/Updates/r658_mangos.sql deleted file mode 100644 index 50ae5fcbd4c..00000000000 --- a/src/bindings/scripts/sql/Updates/r658_mangos.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_custodian_of_time' WHERE `entry`=20129; diff --git a/src/bindings/scripts/sql/Updates/r659_mangos.sql b/src/bindings/scripts/sql/Updates/r659_mangos.sql deleted file mode 100644 index feb9379b8af..00000000000 --- a/src/bindings/scripts/sql/Updates/r659_mangos.sql +++ /dev/null @@ -1,4 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_akama_shade' WHERE `entry`=22990; -- Akama at Shade of Akama -UPDATE `creature_template` SET `ScriptName`='npc_akama_illidan' WHERE `entry`=23089; -- Akama at Illidan -UPDATE `creature_template` SET `ScriptName`='mob_illidari_council' WHERE `entry`=23426; -- Illidari Council controller mob -UPDATE `creature_template` SET `ScriptName`='mob_blood_elf_council_voice_trigger' WHERE `entry` = 23499; -- Voice Trigger Mob (Controls Aggro + Enrage yells) diff --git a/src/bindings/scripts/sql/Updates/r72.sql b/src/bindings/scripts/sql/Updates/r72.sql deleted file mode 100644 index fd79e95cd66..00000000000 --- a/src/bindings/scripts/sql/Updates/r72.sql +++ /dev/null @@ -1,4 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mobs_mana_tapped' WHERE `entry` IN (15273,15274,15294,15298,15367); -UPDATE `creature_template` SET `ScriptName` = 'mobs_ghoul_flayer' WHERE `entry` IN (8530, 8531, 8532); -UPDATE `creature_template` SET `ScriptName` = 'mobs_bonechewer_orc' WHERE `entry` IN (16876, 16925, 18952, 19701); -UPDATE `item_template` SET `ScriptName` = 'purification_mixture' WHERE `entry`= 23268;
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r78.sql b/src/bindings/scripts/sql/Updates/r78.sql deleted file mode 100644 index 783482aed8e..00000000000 --- a/src/bindings/scripts/sql/Updates/r78.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `item_template` SET `ScriptName` = 'nether_wraith_beacon' WHERE `entry` = 31742; -UPDATE `item_template` SET `ScriptName` = 'area_52_special' WHERE `entry` = 28132; -UPDATE `creature_template` SET `ScriptName` = 'guard_shattrath' WHERE `entry` = 19687; diff --git a/src/bindings/scripts/sql/Updates/r81.sql b/src/bindings/scripts/sql/Updates/r81.sql deleted file mode 100644 index c1785f088d8..00000000000 --- a/src/bindings/scripts/sql/Updates/r81.sql +++ /dev/null @@ -1,35 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_gyth' WHERE `entry` = 10339; -UPDATE `creature_template` SET `ScriptName` = 'boss_rend_blackhand' WHERE `entry` = 10429; -UPDATE `creature_template` SET `ScriptName` = 'boss_pyroguard_emberseer' WHERE `entry` = 9816; -UPDATE `creature_template` SET `ScriptName` = 'mob_chromatic_elite_guard' WHERE `entry` = 10814; -UPDATE `creature_template` SET `ScriptName` = 'mob_ancient_core_hound' WHERE `entry` = 11673; -UPDATE `creature_template` SET `ScriptName` = 'mob_core_rager' WHERE `entry` = 11672; -UPDATE `creature_template` SET `ScriptName` = 'mob_firesworn' WHERE `entry` = 12099; -UPDATE `creature_template` SET `ScriptName` = 'mob_firewalker' WHERE `entry` = 11666; -UPDATE `creature_template` SET `ScriptName` = 'mob_flame_guard' WHERE `entry` = 11667; -UPDATE `creature_template` SET `ScriptName` = 'mob_flamewaker' WHERE `entry` = 11661; -UPDATE `creature_template` SET `ScriptName` = 'mob_flamewaker_elite' WHERE `entry` = 11664; -UPDATE `creature_template` SET `ScriptName` = 'mob_flamewaker_healer' WHERE `entry` = 11663; -UPDATE `creature_template` SET `ScriptName` = 'mob_flamewaker_protector' WHERE `entry` = 12119; -UPDATE `creature_template` SET `ScriptName` = 'mob_lavaspawn' WHERE `entry` = 12265; -UPDATE `creature_template` SET `ScriptName` = 'mob_molten_destroyer' WHERE `entry` = 11659; -UPDATE `creature_template` SET `ScriptName` = 'mob_molten_giant' WHERE `entry` = 11658; -UPDATE `creature_template` SET `ScriptName` = 'boss_azuregos' WHERE `entry` = 6109; - - - - - - - - - - - - - - - - - -
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r91.sql b/src/bindings/scripts/sql/Updates/r91.sql deleted file mode 100644 index bd7fc1131ac..00000000000 --- a/src/bindings/scripts/sql/Updates/r91.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_great_bear_spirit' WHERE `entry` = 11956; -UPDATE `creature_template` SET `ScriptName` = 'npcs_rutgar_and_frankal.cpp' WHERE `entry` IN (15170, 15171);
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r92.sql b/src/bindings/scripts/sql/Updates/r92.sql deleted file mode 100644 index b149b69c19c..00000000000 --- a/src/bindings/scripts/sql/Updates/r92.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npcs_rutgar_and_frankal' WHERE `entry` IN (15170, 15171);
\ No newline at end of file diff --git a/src/bindings/scripts/sql/Updates/r97.sql b/src/bindings/scripts/sql/Updates/r97.sql deleted file mode 100644 index 95934d6ce15..00000000000 --- a/src/bindings/scripts/sql/Updates/r97.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npcs_captains_blackanvil_and_skullsplit' WHERE `entry` IN (15440, 15612); |