From 9b1c0e006f20091f28f3f468cfcab1feb51286bd Mon Sep 17 00:00:00 2001 From: Neo2003 Date: Thu, 2 Oct 2008 16:23:55 -0500 Subject: [svn] * Proper SVN structure --HG-- branch : trunk --- .../scripts/sql/Updates/09_BraveWindfeather.sql | 1 + .../scripts/sql/Updates/11_SilvaFilnaveth.sql | 1 + src/bindings/scripts/sql/Updates/27_Vaelastraz.sql | 2 + src/bindings/scripts/sql/Updates/Makefile.am | 215 ++++++++++++ src/bindings/scripts/sql/Updates/Makefile.in | 383 +++++++++++++++++++++ src/bindings/scripts/sql/Updates/r104.sql | 1 + src/bindings/scripts/sql/Updates/r108.sql | 1 + src/bindings/scripts/sql/Updates/r110.sql | 1 + src/bindings/scripts/sql/Updates/r121.sql | 2 + src/bindings/scripts/sql/Updates/r123.sql | 4 + src/bindings/scripts/sql/Updates/r124.sql | 13 + src/bindings/scripts/sql/Updates/r125.sql | 24 ++ src/bindings/scripts/sql/Updates/r128.sql | 1 + src/bindings/scripts/sql/Updates/r131.sql | 1 + src/bindings/scripts/sql/Updates/r134.sql | 15 + src/bindings/scripts/sql/Updates/r136.sql | 55 +++ src/bindings/scripts/sql/Updates/r139.sql | 35 ++ src/bindings/scripts/sql/Updates/r142.sql | 11 + src/bindings/scripts/sql/Updates/r144.sql | 5 + src/bindings/scripts/sql/Updates/r145.sql | 4 + src/bindings/scripts/sql/Updates/r149.sql | 1 + src/bindings/scripts/sql/Updates/r150.sql | 19 + src/bindings/scripts/sql/Updates/r152.sql | 12 + src/bindings/scripts/sql/Updates/r153.sql | 33 ++ src/bindings/scripts/sql/Updates/r157.sql | 7 + src/bindings/scripts/sql/Updates/r161.sql | 12 + src/bindings/scripts/sql/Updates/r163.sql | 2 + src/bindings/scripts/sql/Updates/r164.sql | 10 + src/bindings/scripts/sql/Updates/r165.sql | 8 + src/bindings/scripts/sql/Updates/r169.sql | 4 + src/bindings/scripts/sql/Updates/r170.sql | 2 + src/bindings/scripts/sql/Updates/r171.sql | 2 + src/bindings/scripts/sql/Updates/r172.sql | 3 + src/bindings/scripts/sql/Updates/r174.sql | 8 + src/bindings/scripts/sql/Updates/r176.sql | 5 + src/bindings/scripts/sql/Updates/r177.sql | 2 + src/bindings/scripts/sql/Updates/r178.sql | 2 + src/bindings/scripts/sql/Updates/r181.sql | 2 + src/bindings/scripts/sql/Updates/r182.sql | 2 + src/bindings/scripts/sql/Updates/r183.sql | 5 + src/bindings/scripts/sql/Updates/r184.sql | 2 + src/bindings/scripts/sql/Updates/r186.sql | 2 + src/bindings/scripts/sql/Updates/r187.sql | 12 + src/bindings/scripts/sql/Updates/r189.sql | 3 + src/bindings/scripts/sql/Updates/r191.sql | 5 + src/bindings/scripts/sql/Updates/r192.sql | 9 + src/bindings/scripts/sql/Updates/r197.sql | 5 + src/bindings/scripts/sql/Updates/r204.sql | 7 + src/bindings/scripts/sql/Updates/r206.sql | 16 + src/bindings/scripts/sql/Updates/r211.sql | 6 + src/bindings/scripts/sql/Updates/r213.sql | 11 + src/bindings/scripts/sql/Updates/r214.sql | 2 + src/bindings/scripts/sql/Updates/r215.sql | 1 + src/bindings/scripts/sql/Updates/r218.sql | 5 + src/bindings/scripts/sql/Updates/r219.sql | 3 + .../scripts/sql/Updates/r221_scriptdev2.sql | 1 + .../scripts/sql/Updates/r227_scriptdev2.sql | 29 ++ src/bindings/scripts/sql/Updates/r230_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r234_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r237_mangos.sql | 6 + src/bindings/scripts/sql/Updates/r238_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r239_mangos.sql | 1 + .../scripts/sql/Updates/r240_scriptdev2.sql | 2 + src/bindings/scripts/sql/Updates/r241_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r242_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r243_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r249_mangos.sql | 3 + src/bindings/scripts/sql/Updates/r250_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r253_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r255_mangos.sql | 5 + src/bindings/scripts/sql/Updates/r256_mangos.sql | 35 ++ src/bindings/scripts/sql/Updates/r257_mangos.sql | 4 + src/bindings/scripts/sql/Updates/r258_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r260_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r261_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r262_mangos.sql | 3 + src/bindings/scripts/sql/Updates/r263_mangos.sql | 3 + src/bindings/scripts/sql/Updates/r264_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r265_mangos.sql | 9 + src/bindings/scripts/sql/Updates/r269_mangos.sql | 6 + src/bindings/scripts/sql/Updates/r270_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r271_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r272_mangos.sql | 8 + src/bindings/scripts/sql/Updates/r273_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r274_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r275_mangos.sql | 1 + .../scripts/sql/Updates/r281_scriptdev2.sql | 35 ++ src/bindings/scripts/sql/Updates/r282_mangos.sql | 38 ++ src/bindings/scripts/sql/Updates/r286_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r289_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r291_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r295_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r297_mangos.sql | 1 + .../scripts/sql/Updates/r298_scriptdev2.sql | 2 + .../scripts/sql/Updates/r299_scriptdev2.sql | 9 + src/bindings/scripts/sql/Updates/r304_mangos.sql | 1 + .../scripts/sql/Updates/r306_scriptdev2.sql | 4 + src/bindings/scripts/sql/Updates/r307_mangos.sql | 4 + src/bindings/scripts/sql/Updates/r308_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r309_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r311_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r312_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r318_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r324_mangos.sql | 3 + src/bindings/scripts/sql/Updates/r327_mangos.sql | 5 + .../scripts/sql/Updates/r332_scriptdev2.sql | 2 + src/bindings/scripts/sql/Updates/r333_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r334_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r336_mangos.sql | 9 + src/bindings/scripts/sql/Updates/r352_mangos.sql | 23 ++ src/bindings/scripts/sql/Updates/r355_mangos.sql | 23 ++ src/bindings/scripts/sql/Updates/r358_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r364_mangos.sql | 7 + src/bindings/scripts/sql/Updates/r367_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r368_mangos.sql | 5 + src/bindings/scripts/sql/Updates/r369_mangos.sql | 5 + src/bindings/scripts/sql/Updates/r374_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r386_mangos.sql | 7 + src/bindings/scripts/sql/Updates/r417_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r428_mangos.sql | 4 + src/bindings/scripts/sql/Updates/r431_mangos.sql | 4 + src/bindings/scripts/sql/Updates/r444_mangos.sql | 5 + src/bindings/scripts/sql/Updates/r445_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r446_mangos.sql | 2 + .../scripts/sql/Updates/r448_scriptdev2.sql | 5 + src/bindings/scripts/sql/Updates/r462_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r465_mangos.sql | 3 + src/bindings/scripts/sql/Updates/r467_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r473_mangos.sql | 3 + src/bindings/scripts/sql/Updates/r476_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r477_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r479_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r482_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r484_mangos.sql | 8 + src/bindings/scripts/sql/Updates/r486_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r487_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r494_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r501_mangos.sql | 4 + src/bindings/scripts/sql/Updates/r513_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r514_mangos.sql | 3 + src/bindings/scripts/sql/Updates/r515_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r516_mangos.sql | 3 + src/bindings/scripts/sql/Updates/r517_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r518_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r519_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r520_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r521_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r522_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r526_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r528_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r533_mangos.sql | 1 + .../scripts/sql/Updates/r538_scriptdev2.sql | 60 ++++ src/bindings/scripts/sql/Updates/r547_mangos.sql | 22 ++ src/bindings/scripts/sql/Updates/r554_mangos.sql | 3 + src/bindings/scripts/sql/Updates/r555_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r56.sql | 2 + src/bindings/scripts/sql/Updates/r575_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r576_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r578_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r584_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r59.sql | 3 + src/bindings/scripts/sql/Updates/r590_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r591_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r593_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r594_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r596_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r610_mangos.sql | 2 + .../scripts/sql/Updates/r615_scriptdev2.sql | 4 + src/bindings/scripts/sql/Updates/r617_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r621_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r628_mangos.sql | 3 + src/bindings/scripts/sql/Updates/r63.sql | 1 + src/bindings/scripts/sql/Updates/r632_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r633_mangos.sql | 1 + .../scripts/sql/Updates/r634_scriptdev2.sql | 35 ++ src/bindings/scripts/sql/Updates/r636_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r637_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r638_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r639_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r642_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r643_mangos.sql | 2 + src/bindings/scripts/sql/Updates/r646_mangos.sql | 1 + .../scripts/sql/Updates/r647_scriptdev2.sql | 10 + src/bindings/scripts/sql/Updates/r65.sql | 2 + .../scripts/sql/Updates/r656_scriptdev2.sql | 5 + src/bindings/scripts/sql/Updates/r658_mangos.sql | 1 + src/bindings/scripts/sql/Updates/r659_mangos.sql | 4 + src/bindings/scripts/sql/Updates/r72.sql | 4 + src/bindings/scripts/sql/Updates/r78.sql | 3 + src/bindings/scripts/sql/Updates/r81.sql | 35 ++ src/bindings/scripts/sql/Updates/r91.sql | 2 + src/bindings/scripts/sql/Updates/r92.sql | 1 + src/bindings/scripts/sql/Updates/r97.sql | 1 + 193 files changed, 1643 insertions(+) create mode 100644 src/bindings/scripts/sql/Updates/09_BraveWindfeather.sql create mode 100644 src/bindings/scripts/sql/Updates/11_SilvaFilnaveth.sql create mode 100644 src/bindings/scripts/sql/Updates/27_Vaelastraz.sql create mode 100644 src/bindings/scripts/sql/Updates/Makefile.am create mode 100644 src/bindings/scripts/sql/Updates/Makefile.in create mode 100644 src/bindings/scripts/sql/Updates/r104.sql create mode 100644 src/bindings/scripts/sql/Updates/r108.sql create mode 100644 src/bindings/scripts/sql/Updates/r110.sql create mode 100644 src/bindings/scripts/sql/Updates/r121.sql create mode 100644 src/bindings/scripts/sql/Updates/r123.sql create mode 100644 src/bindings/scripts/sql/Updates/r124.sql create mode 100644 src/bindings/scripts/sql/Updates/r125.sql create mode 100644 src/bindings/scripts/sql/Updates/r128.sql create mode 100644 src/bindings/scripts/sql/Updates/r131.sql create mode 100644 src/bindings/scripts/sql/Updates/r134.sql create mode 100644 src/bindings/scripts/sql/Updates/r136.sql create mode 100644 src/bindings/scripts/sql/Updates/r139.sql create mode 100644 src/bindings/scripts/sql/Updates/r142.sql create mode 100644 src/bindings/scripts/sql/Updates/r144.sql create mode 100644 src/bindings/scripts/sql/Updates/r145.sql create mode 100644 src/bindings/scripts/sql/Updates/r149.sql create mode 100644 src/bindings/scripts/sql/Updates/r150.sql create mode 100644 src/bindings/scripts/sql/Updates/r152.sql create mode 100644 src/bindings/scripts/sql/Updates/r153.sql create mode 100644 src/bindings/scripts/sql/Updates/r157.sql create mode 100644 src/bindings/scripts/sql/Updates/r161.sql create mode 100644 src/bindings/scripts/sql/Updates/r163.sql create mode 100644 src/bindings/scripts/sql/Updates/r164.sql create mode 100644 src/bindings/scripts/sql/Updates/r165.sql create mode 100644 src/bindings/scripts/sql/Updates/r169.sql create mode 100644 src/bindings/scripts/sql/Updates/r170.sql create mode 100644 src/bindings/scripts/sql/Updates/r171.sql create mode 100644 src/bindings/scripts/sql/Updates/r172.sql create mode 100644 src/bindings/scripts/sql/Updates/r174.sql create mode 100644 src/bindings/scripts/sql/Updates/r176.sql create mode 100644 src/bindings/scripts/sql/Updates/r177.sql create mode 100644 src/bindings/scripts/sql/Updates/r178.sql create mode 100644 src/bindings/scripts/sql/Updates/r181.sql create mode 100644 src/bindings/scripts/sql/Updates/r182.sql create mode 100644 src/bindings/scripts/sql/Updates/r183.sql create mode 100644 src/bindings/scripts/sql/Updates/r184.sql create mode 100644 src/bindings/scripts/sql/Updates/r186.sql create mode 100644 src/bindings/scripts/sql/Updates/r187.sql create mode 100644 src/bindings/scripts/sql/Updates/r189.sql create mode 100644 src/bindings/scripts/sql/Updates/r191.sql create mode 100644 src/bindings/scripts/sql/Updates/r192.sql create mode 100644 src/bindings/scripts/sql/Updates/r197.sql create mode 100644 src/bindings/scripts/sql/Updates/r204.sql create mode 100644 src/bindings/scripts/sql/Updates/r206.sql create mode 100644 src/bindings/scripts/sql/Updates/r211.sql create mode 100644 src/bindings/scripts/sql/Updates/r213.sql create mode 100644 src/bindings/scripts/sql/Updates/r214.sql create mode 100644 src/bindings/scripts/sql/Updates/r215.sql create mode 100644 src/bindings/scripts/sql/Updates/r218.sql create mode 100644 src/bindings/scripts/sql/Updates/r219.sql create mode 100644 src/bindings/scripts/sql/Updates/r221_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r227_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r230_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r234_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r237_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r238_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r239_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r240_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r241_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r242_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r243_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r249_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r250_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r253_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r255_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r256_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r257_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r258_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r260_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r261_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r262_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r263_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r264_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r265_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r269_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r270_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r271_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r272_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r273_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r274_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r275_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r281_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r282_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r286_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r289_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r291_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r295_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r297_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r298_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r299_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r304_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r306_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r307_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r308_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r309_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r311_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r312_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r318_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r324_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r327_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r332_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r333_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r334_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r336_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r352_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r355_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r358_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r364_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r367_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r368_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r369_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r374_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r386_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r417_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r428_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r431_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r444_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r445_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r446_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r448_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r462_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r465_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r467_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r473_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r476_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r477_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r479_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r482_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r484_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r486_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r487_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r494_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r501_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r513_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r514_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r515_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r516_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r517_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r518_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r519_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r520_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r521_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r522_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r526_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r528_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r533_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r538_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r547_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r554_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r555_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r56.sql create mode 100644 src/bindings/scripts/sql/Updates/r575_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r576_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r578_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r584_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r59.sql create mode 100644 src/bindings/scripts/sql/Updates/r590_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r591_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r593_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r594_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r596_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r610_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r615_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r617_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r621_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r628_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r63.sql create mode 100644 src/bindings/scripts/sql/Updates/r632_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r633_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r634_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r636_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r637_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r638_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r639_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r642_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r643_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r646_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r647_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r65.sql create mode 100644 src/bindings/scripts/sql/Updates/r656_scriptdev2.sql create mode 100644 src/bindings/scripts/sql/Updates/r658_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r659_mangos.sql create mode 100644 src/bindings/scripts/sql/Updates/r72.sql create mode 100644 src/bindings/scripts/sql/Updates/r78.sql create mode 100644 src/bindings/scripts/sql/Updates/r81.sql create mode 100644 src/bindings/scripts/sql/Updates/r91.sql create mode 100644 src/bindings/scripts/sql/Updates/r92.sql create mode 100644 src/bindings/scripts/sql/Updates/r97.sql (limited to 'src/bindings/scripts/sql/Updates') diff --git a/src/bindings/scripts/sql/Updates/09_BraveWindfeather.sql b/src/bindings/scripts/sql/Updates/09_BraveWindfeather.sql new file mode 100644 index 00000000000..ae78c707323 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/09_BraveWindfeather.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..9900466b717 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/11_SilvaFilnaveth.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..e57ed2107d9 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/27_Vaelastraz.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..e8389337a6a --- /dev/null +++ b/src/bindings/scripts/sql/Updates/Makefile.am @@ -0,0 +1,215 @@ +# Copyright (C) 2005,2006,2007 MaNGOS +# +# 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 new file mode 100644 index 00000000000..9b43048f032 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/Makefile.in @@ -0,0 +1,383 @@ +# 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 +# +# 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 new file mode 100644 index 00000000000..29372b726b7 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r104.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..7c50fe13d77 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r108.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..d5bd73a2fa2 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r110.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..597bf532508 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r121.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..14f73d1e2d3 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r123.sql @@ -0,0 +1,4 @@ +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 new file mode 100644 index 00000000000..4b5f5cb5794 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r124.sql @@ -0,0 +1,13 @@ +-- 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 new file mode 100644 index 00000000000..85477c24e08 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r125.sql @@ -0,0 +1,24 @@ +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 new file mode 100644 index 00000000000..f652fa16f10 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r128.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..0899dae38bc --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r131.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..eac5bb78415 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r134.sql @@ -0,0 +1,15 @@ + +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 new file mode 100644 index 00000000000..52a9d87d6de --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r136.sql @@ -0,0 +1,55 @@ + +-- 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 new file mode 100644 index 00000000000..73c013f1a1f --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r139.sql @@ -0,0 +1,35 @@ +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 new file mode 100644 index 00000000000..2cd9b29e6ec --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r142.sql @@ -0,0 +1,11 @@ +-- 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 new file mode 100644 index 00000000000..ddf354b9ea1 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r144.sql @@ -0,0 +1,5 @@ +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 new file mode 100644 index 00000000000..d2d79974048 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r145.sql @@ -0,0 +1,4 @@ + +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 new file mode 100644 index 00000000000..a6311a14e9c --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r149.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..eb1eb180622 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r150.sql @@ -0,0 +1,19 @@ +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 new file mode 100644 index 00000000000..9efdb9f53c4 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r152.sql @@ -0,0 +1,12 @@ +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 new file mode 100644 index 00000000000..fb59c996edf --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r153.sql @@ -0,0 +1,33 @@ +-- 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 new file mode 100644 index 00000000000..05c8299529c --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r157.sql @@ -0,0 +1,7 @@ +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 new file mode 100644 index 00000000000..0bb31ee2ba0 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r161.sql @@ -0,0 +1,12 @@ +-- 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 new file mode 100644 index 00000000000..9f8253e3cd3 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r163.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..30b7a6a05a6 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r164.sql @@ -0,0 +1,10 @@ +-- 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 new file mode 100644 index 00000000000..69401cdb8f4 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r165.sql @@ -0,0 +1,8 @@ + +-- 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 new file mode 100644 index 00000000000..d5511e82106 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r169.sql @@ -0,0 +1,4 @@ +-- 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 new file mode 100644 index 00000000000..c397c160065 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r170.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..5a7adb61514 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r171.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..4cac983026d --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r172.sql @@ -0,0 +1,3 @@ +-- 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 new file mode 100644 index 00000000000..57dde5a0fd2 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r174.sql @@ -0,0 +1,8 @@ +-- 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 new file mode 100644 index 00000000000..58e75375c12 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r176.sql @@ -0,0 +1,5 @@ +-- 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 new file mode 100644 index 00000000000..3914679aa3b --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r177.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..f20a4366885 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r178.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..4807582d1a4 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r181.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..5d0a3c68fd2 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r182.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..79c175d0996 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r183.sql @@ -0,0 +1,5 @@ +-- 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 new file mode 100644 index 00000000000..599fd9f3c0e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r184.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..a225e6850fc --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r186.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..2b34b1c84bf --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r187.sql @@ -0,0 +1,12 @@ +-- 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 new file mode 100644 index 00000000000..51fc09abcd2 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r189.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..f5d563bc272 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r191.sql @@ -0,0 +1,5 @@ + +/* 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 new file mode 100644 index 00000000000..beb8aa31eb8 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r192.sql @@ -0,0 +1,9 @@ +-- 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 new file mode 100644 index 00000000000..800595abd59 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r197.sql @@ -0,0 +1,5 @@ +-- 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 new file mode 100644 index 00000000000..960ba366f18 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r204.sql @@ -0,0 +1,7 @@ +-- 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 new file mode 100644 index 00000000000..9adcb76a6a3 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r206.sql @@ -0,0 +1,16 @@ +-- 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 new file mode 100644 index 00000000000..ceb91171b9a --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r211.sql @@ -0,0 +1,6 @@ +-- 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 new file mode 100644 index 00000000000..b512cfd5044 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r213.sql @@ -0,0 +1,11 @@ +-- 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 new file mode 100644 index 00000000000..24b5aa393d3 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r214.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..90bfbf0e86b --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r215.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..e6eeb7782aa --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r218.sql @@ -0,0 +1,5 @@ +-- 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 new file mode 100644 index 00000000000..8b01dd43784 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r219.sql @@ -0,0 +1,3 @@ +/* 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 new file mode 100644 index 00000000000..06cd4334508 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r221_scriptdev2.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..4e600fc3df8 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r227_scriptdev2.sql @@ -0,0 +1,29 @@ +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 new file mode 100644 index 00000000000..4db44512536 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r230_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..8a72910adbe --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r234_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..265bde22802 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r237_mangos.sql @@ -0,0 +1,6 @@ +-- 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 new file mode 100644 index 00000000000..d148e11f863 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r238_mangos.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..8936e4d8f6c --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r239_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..635ee46b18e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r240_scriptdev2.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..ffc99c200d5 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r241_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..49465a656e9 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r242_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..6b1ad08d0a0 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r243_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..cf0c36ef468 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r249_mangos.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..841e39d71b3 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r250_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..424237be238 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r253_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..7019586eb96 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r255_mangos.sql @@ -0,0 +1,5 @@ +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 new file mode 100644 index 00000000000..4207454117e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r256_mangos.sql @@ -0,0 +1,35 @@ +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 new file mode 100644 index 00000000000..1bed2c9f098 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r257_mangos.sql @@ -0,0 +1,4 @@ +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 new file mode 100644 index 00000000000..18970d669da --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r258_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..e96598d09e1 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r260_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..b1c8e6312a9 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r261_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..225b7c38437 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r262_mangos.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..a3ff56a0bd7 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r263_mangos.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..410f1de42d5 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r264_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..4eaed94ee10 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r265_mangos.sql @@ -0,0 +1,9 @@ +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 new file mode 100644 index 00000000000..95ed715301a --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r269_mangos.sql @@ -0,0 +1,6 @@ +-- 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 new file mode 100644 index 00000000000..2d7ffe0c432 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r270_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..74fcb02284d --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r271_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..3e5313f20e0 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r272_mangos.sql @@ -0,0 +1,8 @@ +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 new file mode 100644 index 00000000000..db98e282f09 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r273_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..fef98f84e11 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r274_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..618666b80e1 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r275_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..719d1ee7852 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r281_scriptdev2.sql @@ -0,0 +1,35 @@ +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 new file mode 100644 index 00000000000..93ea058523a --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r282_mangos.sql @@ -0,0 +1,38 @@ +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 new file mode 100644 index 00000000000..d1d0a14dfa5 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r286_mangos.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..48e08ebb878 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r289_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..a85fb7bf34c --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r291_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..b992e0ee630 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r295_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..702013c465b --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r297_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..953baee559b --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r298_scriptdev2.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..8b835b0ed7c --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r299_scriptdev2.sql @@ -0,0 +1,9 @@ +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 new file mode 100644 index 00000000000..2a6ed9c0f60 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r304_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..60eac88d01e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r306_scriptdev2.sql @@ -0,0 +1,4 @@ +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 new file mode 100644 index 00000000000..e239d40700d --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r307_mangos.sql @@ -0,0 +1,4 @@ +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 new file mode 100644 index 00000000000..b3c16a91402 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r308_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..03bd078c7ab --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r309_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..22cb325623b --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r311_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..978152764bd --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r312_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..5ce2afca20f --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r318_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..4b9fb91dc2d --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r324_mangos.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..d2d56fdfc3c --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r327_mangos.sql @@ -0,0 +1,5 @@ +-- 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 new file mode 100644 index 00000000000..ea67d3e7392 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r332_scriptdev2.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..48a7f673fad --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r333_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..5d010c62209 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r334_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..993b954bb4b --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r336_mangos.sql @@ -0,0 +1,9 @@ +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 new file mode 100644 index 00000000000..a40281bcd33 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r352_mangos.sql @@ -0,0 +1,23 @@ +-- 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 new file mode 100644 index 00000000000..a40281bcd33 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r355_mangos.sql @@ -0,0 +1,23 @@ +-- 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 new file mode 100644 index 00000000000..01db3736d2e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r358_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..d893f4d923c --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r364_mangos.sql @@ -0,0 +1,7 @@ +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 new file mode 100644 index 00000000000..29a27c7d745 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r367_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..b4cf82da064 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r368_mangos.sql @@ -0,0 +1,5 @@ +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 new file mode 100644 index 00000000000..1d053e5f583 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r369_mangos.sql @@ -0,0 +1,5 @@ +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 new file mode 100644 index 00000000000..f430c086f00 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r374_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..7913666b5ce --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r386_mangos.sql @@ -0,0 +1,7 @@ +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 new file mode 100644 index 00000000000..c9c08fe598b --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r417_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..997c636332d --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r428_mangos.sql @@ -0,0 +1,4 @@ +-- 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 new file mode 100644 index 00000000000..bd8481815eb --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r431_mangos.sql @@ -0,0 +1,4 @@ +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 new file mode 100644 index 00000000000..c45fa7b9620 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r444_mangos.sql @@ -0,0 +1,5 @@ +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 new file mode 100644 index 00000000000..5ca5011dd4e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r445_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..a8a819e3b67 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r446_mangos.sql @@ -0,0 +1,2 @@ +-- 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 new file mode 100644 index 00000000000..66d78082aa0 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r448_scriptdev2.sql @@ -0,0 +1,5 @@ +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 new file mode 100644 index 00000000000..6d8ac269de3 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r462_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..35d7d3834f1 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r465_mangos.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..711bba7cc94 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r467_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..f9918bc1b71 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r473_mangos.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..998045f2193 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r476_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..0f9c76c5336 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r477_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..216fe068317 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r479_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..b431b85c90e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r482_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..1f4fefd7fa1 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r484_mangos.sql @@ -0,0 +1,8 @@ +-- 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 new file mode 100644 index 00000000000..28920abf0db --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r486_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..229be423977 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r487_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..c8f5aef5d9a --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r494_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..7242f3b8a7b --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r501_mangos.sql @@ -0,0 +1,4 @@ +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 new file mode 100644 index 00000000000..fcc3433fa59 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r513_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..108948250d9 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r514_mangos.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..8860641d493 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r515_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..76bd7b83780 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r516_mangos.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..2077e416c81 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r517_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..5930aba9256 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r518_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..fa408a043ec --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r519_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..959ac79be55 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r520_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..37d09546b0a --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r521_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..159e6e83826 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r522_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..2171bed6570 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r526_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..90b63aabe40 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r528_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..a05d4bfb732 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r533_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..92ef9ea24ff --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r538_scriptdev2.sql @@ -0,0 +1,60 @@ +-- 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 new file mode 100644 index 00000000000..cc98862022e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r547_mangos.sql @@ -0,0 +1,22 @@ +/* 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 new file mode 100644 index 00000000000..b6beac3adce --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r554_mangos.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..f0284ddd037 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r555_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..69e31e9e21c --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r56.sql @@ -0,0 +1,2 @@ +/* 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 new file mode 100644 index 00000000000..bbf52bd5c96 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r575_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..0df34443309 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r576_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..f82ea62c26e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r578_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..0980b86cc4e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r584_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..219f96220b1 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r59.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..72348756d91 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r590_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..253fe3ed53b --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r591_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..ec6730e3d4e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r593_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..3315fd47241 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r594_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..2f0e4587883 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r596_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..1aa9f4b50b4 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r610_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..5c5625860f8 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r615_scriptdev2.sql @@ -0,0 +1,4 @@ +-- 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 new file mode 100644 index 00000000000..7a30f9c553d --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r617_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..822de701ebb --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r621_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..47d286d2718 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r628_mangos.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..4627d40067b --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r63.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..4ea0c35e6ea --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r632_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..bbf75d1f961 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r633_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..31791a57084 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r634_scriptdev2.sql @@ -0,0 +1,35 @@ +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 new file mode 100644 index 00000000000..55eea42bf2a --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r636_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..03a53749cab --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r637_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..cf20d33e957 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r638_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..7946ac237ed --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r639_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..b9963728279 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r642_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..8659ebcb850 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r643_mangos.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..3f43d49bc32 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r646_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..bd259718b81 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r647_scriptdev2.sql @@ -0,0 +1,10 @@ +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 new file mode 100644 index 00000000000..2c878bfed56 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r65.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..96fcd146d76 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r656_scriptdev2.sql @@ -0,0 +1,5 @@ +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 new file mode 100644 index 00000000000..50ae5fcbd4c --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r658_mangos.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..feb9379b8af --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r659_mangos.sql @@ -0,0 +1,4 @@ +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 new file mode 100644 index 00000000000..fd79e95cd66 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r72.sql @@ -0,0 +1,4 @@ +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 new file mode 100644 index 00000000000..783482aed8e --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r78.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..c1785f088d8 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r81.sql @@ -0,0 +1,35 @@ +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 new file mode 100644 index 00000000000..bd7fc1131ac --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r91.sql @@ -0,0 +1,2 @@ +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 new file mode 100644 index 00000000000..b149b69c19c --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r92.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 00000000000..95934d6ce15 --- /dev/null +++ b/src/bindings/scripts/sql/Updates/r97.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName` = 'npcs_captains_blackanvil_and_skullsplit' WHERE `entry` IN (15440, 15612); -- cgit v1.2.3