Index: /unk/src/bindings/scripts/sql/Updates/r211.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r211.sql (revision 2) +++ (revision ) @@ -1,6 +1,0 @@ --- kael'thas event -UPDATE `creature_template` SET `ScriptName` = 'boss_kaelthas' WHERE `entry` = 19622; -UPDATE `creature_template` SET `ScriptName` = 'boss_thaladred_the_darkener' WHERE `entry` = 20064; -UPDATE `creature_template` SET `ScriptName` = 'boss_lord_sanguinar' WHERE `entry` = 20060; -UPDATE `creature_template` SET `ScriptName` = 'boss_grand_astromancer_capernian' WHERE `entry` = 20062; -UPDATE `creature_template` SET `ScriptName` = 'boss_master_engineer_telonicus' WHERE `entry` = 20063; Index: /unk/src/bindings/scripts/sql/Updates/r213.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r213.sql (revision 2) +++ (revision ) @@ -1,11 +1,0 @@ --- Zul'Gurub Part II -UPDATE `creature_template` SET `ScriptName` = "boss_hakkar" WHERE `creature_template`.`entry` = 15295; -UPDATE `creature_template` SET `ScriptName` = "boss_thekal" WHERE `creature_template`.`entry` = 14509; -UPDATE `creature_template` SET `ScriptName` = "boss_arlokk" WHERE `creature_template`.`entry` = 14515; -UPDATE `creature_template` SET `ScriptName` = "mob_zealot_lorkhan" WHERE `creature_template`.`entry` = 11347; -UPDATE `creature_template` SET `ScriptName` = "mob_zealot_zath" WHERE `creature_template`.`entry` = 11348; -UPDATE `creature_template` SET `ScriptName` = "mob_healing_ward" WHERE `creature_template`.`entry` = 14987; -UPDATE `creature_template` SET `Scriptname` = "mobs_zulgurub" WHERE `creature_template`.`entry` IN (11340 ,11352 , 11350, 11830, 11372, 11351, 14750); - - - Index: /unk/src/bindings/scripts/sql/Updates/r134.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r134.sql (revision 2) +++ (revision ) @@ -1,15 +1,0 @@ - -UPDATE `instance_template` SET `script` = 'instance_molten_core' WHERE `map`= 409; -UPDATE `instance_template` SET `script` = 'instance_blackwing_lair' WHERE `map`= 469; -UPDATE `instance_template` SET `script` = 'instance_zulgurub' WHERE `map`= 309; -UPDATE `instance_template` SET `script` = 'instance_ruins_of_ahnqiraj' WHERE `map`= 509; -UPDATE `instance_template` SET `script` = 'instance_temple_of_ahnqiraj' WHERE `map`= 531; -UPDATE `instance_template` SET `script` = 'instance_naxxramas' WHERE `map`= 533; - -UPDATE `instance_template` SET `script` = 'instance_karazhan' WHERE `map`= 532; -UPDATE `instance_template` SET `script` = 'instance_hyjal' WHERE `map`= 534; -UPDATE `instance_template` SET `script` = 'instance_gruuls_lair' WHERE `map`= 565; -UPDATE `instance_template` SET `script` = 'instance_magtheridons_lair' WHERE `map`= 544; -UPDATE `instance_template` SET `script` = 'instance_serpent_shrine' WHERE `map`= 548; -UPDATE `instance_template` SET `script` = 'instance_the_eye' WHERE `map`= 550; -UPDATE `instance_template` SET `script` = 'instance_black_temple' WHERE `map`= 564; Index: /unk/src/bindings/scripts/sql/Updates/r215.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r215.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `item_template` SET `ScriptName` = 'item_skin_of_purest_water' WHERE `entry` = 23751; Index: /unk/src/bindings/scripts/sql/Updates/r171.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r171.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- multi kill quest mobs hfp -UPDATE `creature_template` SET `ScriptName` = 'mobs_shattered_hand_orc' WHERE `entry` IN (19411, 19410, 19413, 19414, 16867, 19295, 16870, 16878, 19415); Index: /unk/src/bindings/scripts/sql/Updates/r136.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r136.sql (revision 2) +++ (revision ) @@ -1,55 +1,0 @@ - --- AQ40 bosses -- - --- Skeram 15263 -UPDATE `creature_template` SET `ScriptName` = 'boss_skeram' WHERE `entry` = 15263; - --- Vem, Yauj, Kri --- Vem 15544 -UPDATE `creature_template` SET `ScriptName` = 'boss_vem' WHERE `entry` = 15544; --- Yauj 15543 -UPDATE `creature_template` SET `ScriptName` = 'boss_yauj' WHERE `entry` = 15543; --- Yauj Brood 15621 -UPDATE `creature_template` SET `ScriptName` = 'mob_yauj_brood' WHERE `entry` = 15621; --- Kri 15511 -UPDATE `creature_template` SET `ScriptName` = 'boss_kri' WHERE `entry` = 15511; - --- Sartura 15516 -UPDATE `creature_template` SET `ScriptName` = 'boss_sartura' WHERE `entry` = 15516; --- Sartura's Royal Guard 15984 -UPDATE `creature_template` SET `ScriptName` = 'mob_sartura_royal_guard' WHERE `entry` = 15984; - --- Fankriss 15510 -UPDATE `creature_template` SET `ScriptName` = 'boss_fankriss' WHERE `entry` = 15510; --- Spawn of Fankriss 15630 -UPDATE `creature_template` SET `ScriptName` = 'mob_spawn_of_fankriss' WHERE `entry` = 15630; - --- Viscidus 15299 -UPDATE `creature_template` SET `ScriptName` = 'boss_viscidus' WHERE `entry` = 15299; --- Glob of Viscidus 15667 -UPDATE `creature_template` SET `ScriptName` = 'boss_glob_of_viscidus' WHERE `entry` = 15667; - --- Huhuran 15509 -UPDATE `creature_template` SET `ScriptName` = 'boss_huhuran' WHERE `entry` = 15509; - --- Veklor & Veknilash --- Veklor 15276 -UPDATE `creature_template` SET `ScriptName` = 'boss_veklor' WHERE `entry` = 15276; --- Veknilash 15275 -UPDATE `creature_template` SET `ScriptName` = 'boss_veknilash' WHERE `entry` = 15275; - --- Ouro 15517 -UPDATE `creature_template` SET `ScriptName` = 'boss_ouro' WHERE `entry` = 15517; - --- C'thun --- Eye 15589 --- Body 15727 - -UPDATE creature_template SET ScriptName='boss_eye_of_cthun' WHERE entry=15589; -UPDATE creature_template SET ScriptName='mob_claw_tentacle' WHERE entry=15725; -UPDATE creature_template SET ScriptName='mob_eye_tentacle' WHERE entry=15726; - -UPDATE creature_template SET ScriptName='boss_cthun' WHERE entry=15727; -UPDATE creature_template SET ScriptName='mob_giant_claw_tentacle' WHERE entry=15728; -UPDATE creature_template SET ScriptName='mob_giant_eye_tentacle' WHERE entry=15334; -UPDATE creature_template SET ScriptName='mob_giant_flesh_tentacle' WHERE entry=15802; Index: /unk/src/bindings/scripts/sql/Updates/r610_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r610_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_lady_sylvanas_windrunner' WHERE `entry`=10181; -UPDATE `creature_template` SET `ScriptName`='npc_highborne_lamenter' WHERE `entry`=21628; Index: /unk/src/bindings/scripts/sql/Updates/r260_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r260_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_lady_katrana_prestor' WHERE `entry` = 1749; Index: /unk/src/bindings/scripts/sql/Updates/r219.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r219.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -/* Fix for Wrong ZG Update */ -UPDATE `creature_template` SET `ScriptName` = ' ' WHERE `entry` = 14607; -UPDATE `creature_template` SET `ScriptName` = ' ' WHERE `entry` = 15295; Index: /unk/src/bindings/scripts/sql/Updates/r234_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r234_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_screecher_spirit' WHERE `entry` = 8612; -UPDATE `item_template` SET `ScriptName` = 'item_yehkinyas_bramble' WHERE `entry`= 10699; Index: /unk/src/bindings/scripts/sql/Updates/r177.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r177.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- kalaran windblade -UPDATE `creature_template` SET `ScriptName` = 'npc_kalaran_windblade' WHERE `entry` = 8479; Index: /unk/src/bindings/scripts/sql/Updates/r462_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r462_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_taretha' WHERE `entry`=18887; -UPDATE `creature_template` SET `ScriptName`='npc_thrall_old_hillsbrad' WHERE `entry`=17876; Index: /unk/src/bindings/scripts/sql/Updates/r309_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r309_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_webbed_creature' WHERE `entry` = 17680; Index: /unk/src/bindings/scripts/sql/Updates/r355_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r355_mangos.sql (revision 2) +++ (revision ) @@ -1,23 +1,0 @@ --- Moroes -update creature_template set scriptname = "boss_moroes" where entry = 15687; -update creature_template set scriptname = "boss_baroness_dorothea_millstipe" where entry = 19875; -update creature_template set scriptname = "boss_baron_rafe_dreuger" where entry = 19874; -update creature_template set scriptname = "boss_lady_catriona_von_indi" where entry = 19872; -update creature_template set scriptname = "boss_lady_keira_berrybuck" where entry = 17007; -update creature_template set scriptname = "boss_lord_robin_daris" where entry = 19876; -update creature_template set scriptname = "boss_lord_crispin_ference" where entry = 19873; - --- Barnes -update creature_template set scriptname = "npc_barnes" where entry = 16812; --- Oz Event -update creature_template set scriptname = "boss_dorothee" where entry = 17535; -update creature_template set scriptname = "boss_strawman" where entry = 17543; -update creature_template set scriptname = "boss_tinhead" where entry = 17547; -update creature_template set scriptname = "boss_roar" where entry = 17546; -update creature_template set scriptname = "boss_crone" where entry = 18168; --- Hood Event -update creature_template set scriptname = "npc_grandmother" where entry = 17603; -update creature_template set scriptname = "boss_bigbadwolf" where entry = 17521; --- Romeo and Juliet disabled for now --- update creature_template set scriptname = "boss_julianne" where entry = 17543; --- update creature_template set scriptname = "boss_romulo" where entry = 17533; Index: /unk/src/bindings/scripts/sql/Updates/r274_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r274_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_blackwing_lair' WHERE `entry` = 12557; Index: /unk/src/bindings/scripts/sql/Updates/r517_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r517_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_taskmaster_fizzule' WHERE `entry`=7233; Index: /unk/src/bindings/scripts/sql/Updates/r482_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r482_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_dancing_flames' WHERE `entry`=25305; Index: /unk/src/bindings/scripts/sql/Updates/r638_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r638_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `item_template` SET `ScriptName`='item_attuned_crystal_cores' WHERE `entry`=34368; -UPDATE `creature_template` SET `ScriptName`='npc_converted_sentry' WHERE `entry`=24981; Index: /unk/src/bindings/scripts/sql/Updates/r476_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r476_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_engineer_spark_overgrind' WHERE `entry`=17243; Index: /unk/src/bindings/scripts/sql/Updates/r647_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r647_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,10 +1,0 @@ -DROP TABLE IF EXISTS `script_texts`; -CREATE TABLE `script_texts` ( -`id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier', -`sound` int(11) unsigned NOT NULL default '0', -`type` int(11) unsigned NOT NULL default '0', -`language` int(11) unsigned NOT NULL default '0', -`text` varchar(255) NOT NULL default '', -`comment` varchar(255) NOT NULL default '', -PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'; Index: /unk/src/bindings/scripts/sql/Updates/r369_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r369_mangos.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_rage_winterchill' WHERE `entry` = 17767; -UPDATE `creature_template` SET `ScriptName` = 'boss_anetheron' WHERE `entry` = 17808; -UPDATE `creature_template` SET `ScriptName` = 'boss_kazrogal' WHERE `entry` = 17888; -UPDATE `creature_template` SET `ScriptName` = 'boss_azgalor' WHERE `entry` = 17842; -UPDATE `creature_template` SET `ScriptName` = 'mob_echo_of_archimonde' WHERE `entry` = 13083; Index: /unk/src/bindings/scripts/sql/Updates/r658_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r658_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_custodian_of_time' WHERE `entry`=20129; Index: /unk/src/bindings/scripts/sql/Updates/r91.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r91.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_great_bear_spirit' WHERE `entry` = 11956; -UPDATE `creature_template` SET `ScriptName` = 'npcs_rutgar_and_frankal.cpp' WHERE `entry` IN (15170, 15171); Index: /unk/src/bindings/scripts/sql/Updates/r56.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r56.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -/* Remove guildmaster script from npc's. Core has full support */ -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (4974,5054,4613); Index: /unk/src/bindings/scripts/sql/Updates/r97.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r97.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npcs_captains_blackanvil_and_skullsplit' WHERE `entry` IN (15440, 15612); Index: /unk/src/bindings/scripts/sql/Updates/r104.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r104.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `gameobject_template` SET `ScriptName`='go_orb_of_command' WHERE `entry`='179879'; Index: /unk/src/bindings/scripts/sql/Updates/r108.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r108.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_dementeddruids' WHERE `entry` = 15260; Index: /unk/src/bindings/scripts/sql/Updates/r145.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r145.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ - -UPDATE `creature_template` SET `ScriptName` = 'mob_shadow_of_aran' WHERE `entry` = 18254; -UPDATE `creature_template` SET `ScriptName` = 'mob_aran_elemental' WHERE `entry` = 17167; -UPDATE `creature_template` SET `ScriptName` = 'mob_aran_blizzard' WHERE `entry` = 17161; Index: /unk/src/bindings/scripts/sql/Updates/r182.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r182.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- npc_ragged_john -UPDATE `creature_template` SET `ScriptName` = 'npc_ragged_john' WHERE `entry` = 9563; Index: /unk/src/bindings/scripts/sql/Updates/r304_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r304_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (15440, 15612); Index: /unk/src/bindings/scripts/sql/Updates/r431_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r431_mangos.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_zephyr' WHERE `entry`=25967; -UPDATE `instance_template` SET `script`='instance_old_hillsbrad' WHERE `map`=560; -UPDATE `creature_template` SET `ScriptName`='npc_brazen' WHERE `entry`=18725; -UPDATE `creature_template` SET `ScriptName`='npc_erozion' WHERE `entry`=18723; Index: /unk/src/bindings/scripts/sql/Updates/r324_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r324_mangos.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_mortog_steamhead' WHERE `entry` = 23373; -UPDATE `creature_template` SET `ScriptName` = 'npc_veronia' WHERE `entry` = 20162; -UPDATE `creature_template` SET `ScriptName` = 'npc_susurrus' WHERE `entry` = 17435; Index: /unk/src/bindings/scripts/sql/Updates/r243_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r243_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_marin_noggenfogger' WHERE `entry` = 7564; Index: /unk/src/bindings/scripts/sql/Updates/r184.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r184.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- revert to default database values -UPDATE `quest_template` SET `SpecialFlags`= 10, `ReqCreatureOrGOId1` = 0, `ReqCreatureOrGOId2` = 0, `ReqCreatureOrGOId3`= 0, `ReqCreatureOrGOId4`= 0, `ReqCreatureOrGOCount1` = 0, `ReqCreatureOrGOCount2` = 0, `ReqCreatureOrGOCount3` = 0, `ReqCreatureOrGOCount4`= 0, `ReqSpellCast1` = 0, `ReqSpellCast2` = 0, `ReqSpellCast3` = 0, `ReqSpellCast4` = 0 WHERE `entry` IN (5929, 5930); Index: /unk/src/bindings/scripts/sql/Updates/r149.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r149.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -INSERT INTO `spell_script_target` VALUES (30834, 1, 17646); Index: /unk/src/bindings/scripts/sql/Updates/r263_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r263_mangos.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'go_northern_crystal_pylon' WHERE `entry` = 164955; -UPDATE `gameobject_template` SET `ScriptName` = 'go_western_crystal_pylon' WHERE `entry` = 164956; -UPDATE `gameobject_template` SET `ScriptName` = 'go_eastern_crystal_pylon' WHERE `entry` = 164957; Index: /unk/src/bindings/scripts/sql/Updates/r186.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r186.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- leotheras the blind demonform -UPDATE `creature_template` SET `ScriptName` = 'boss_leotheras_the_blind_demonform' WHERE `entry` = 21845; Index: /unk/src/bindings/scripts/sql/Updates/r318_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r318_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npcs_flanis_swiftwing_and_kagrosh' WHERE `entry` IN (21725, 21727); Index: /unk/src/bindings/scripts/sql/Updates/r237_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r237_mangos.sql (revision 2) +++ (revision ) @@ -1,6 +1,0 @@ --- new -UPDATE `creature_template` SET `ScriptName` = 'guard_azuremyst' WHERE `entry` = 18038; -UPDATE `creature_template` SET `ScriptName` = 'guard_eversong' WHERE `entry` = 16221; --- update -UPDATE `creature_template` SET `ScriptName` = 'guard_durotar' WHERE `entry` = 5953; -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (3210, 3211, 3213, 3214, 1736, 1739, 1737); Index: /unk/src/bindings/scripts/sql/Updates/r633_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r633_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_rogue_trainer' WHERE `entry` IN (918,4163,3328,4583,5165,5167,13283,16684); Index: /unk/src/bindings/scripts/sql/Updates/r445_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r445_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_high_astromancer_solarian' WHERE `entry`=18805; -UPDATE `creature_template` SET `ScriptName`='mob_solarium_priest' WHERE `entry`=18806; Index: /unk/src/bindings/scripts/sql/Updates/r364_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r364_mangos.sql (revision 2) +++ (revision ) @@ -1,7 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_ayren_cloudbreaker' WHERE `entry` = 25059; -UPDATE `creature_template` SET `ScriptName` = 'npc_unrestrained_dragonhawk' WHERE `entry` = 25236; -UPDATE `creature_template` SET `ScriptName` = 'npc_sputtervalve' WHERE `entry` = 3442; -UPDATE `creature_template` SET `ScriptName` = 'npc_budd_nedreck' WHERE `entry` = 23559; -UPDATE `creature_template` SET `ScriptName` = 'npc_blood_knight_dawnstar' WHERE `entry` = 17832; -UPDATE `creature_template` SET `ScriptName` = 'npc_stone_watcher_of_norgannon' WHERE `entry` = 7918; -UPDATE `creature_template` SET `ScriptName` = 'npc_lore_keeper_of_norgannon' WHERE `entry` = 7172; Index: /unk/src/bindings/scripts/sql/Updates/r526_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r526_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_injured_draenei' WHERE `entry`=16971; Index: /unk/src/bindings/scripts/sql/Updates/r257_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r257_mangos.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_archmage_malin' WHERE `entry` = 2708; -UPDATE `creature_template` SET `ScriptName` = 'npc_dashel_stonefist' WHERE `entry` = 4961; -UPDATE `creature_template` SET `ScriptName` = 'npc_doctor' WHERE `entry` IN (12939, 12920); -UPDATE `creature_template` SET `ScriptName` = 'npc_injured_patient' WHERE `entry` IN (12936, 12937, 12938, 12923, 12924, 12925); Index: /unk/src/bindings/scripts/sql/Updates/r465_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r465_mangos.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_harbinger_skyriss' WHERE `entry`=20912; -UPDATE `creature_template` SET `ScriptName`='npc_warden_mellichar' WHERE `entry`=20904; -UPDATE `creature_template` SET `ScriptName`='npc_millhouse_manastorm' WHERE `entry`=20977; Index: /unk/src/bindings/scripts/sql/Updates/r358_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r358_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -update creature_template set scriptname = "mob_cyclone" where entry = 18412; Index: /unk/src/bindings/scripts/sql/Updates/r297_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r297_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_berthold' WHERE `entry` = 16153; Index: /unk/src/bindings/scripts/sql/Updates/r656_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r656_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ -ALTER TABLE -`eventai_localized_texts` ADD COLUMN `locale_8` varchar(255) NOT NULL default '' AFTER locale_7; - -ALTER TABLE -`script_localized_texts` ADD COLUMN `locale_8` varchar(255) NOT NULL default '' AFTER locale_7; Index: /unk/src/bindings/scripts/sql/Updates/r479_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r479_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_chicken_cluck' WHERE `entry`=620; Index: /unk/src/bindings/scripts/sql/Updates/r63.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r63.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_bartleby' WHERE `entry` IN (6090); Index: /unk/src/bindings/scripts/sql/Updates/r65.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r65.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `npcflag`='3', `ScriptName`='npc_lothos_riftwalker' WHERE `entry`='14387'; -UPDATE creature_template SET ScriptName="boss_gruul" WHERE entry=19044; Index: /unk/src/bindings/scripts/sql/Updates/11_SilvaFilnaveth.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/11_SilvaFilnaveth.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature` SET `id` = 11798, `curhealth` = 3857 WHERE `guid` = 46833; Index: /unk/src/bindings/scripts/sql/Updates/r150.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r150.sql (revision 2) +++ (revision ) @@ -1,19 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_grand_warlock_nethekurse' WHERE `entry` = 16807; -UPDATE `creature_template` SET `ScriptName` = 'mob_nethe_shadowfissure' WHERE `entry` = 17471; - -UPDATE `creature_template` SET `scriptname`='mob_phoenix' WHERE `entry`='21362'; -UPDATE `creature_template` SET `scriptname`='mob_phoenix_egg' WHERE `entry`='21364'; - -UPDATE `item_template` SET `ScriptName` = 'vorenthals_presence' WHERE `entry`= 30259; - -UPDATE `creature_template` SET `ScriptName` = 'boss_hydromancer_thespia' WHERE `entry` = 17797; -UPDATE `creature_template` SET `ScriptName` = 'mob_coilfang_waterelemental' WHERE `entry` = 17917; - -UPDATE `creature_template` SET `ScriptName` = 'mob_ethereal_beacon' WHERE `entry` = 18431; -UPDATE `creature_template` SET `ScriptName` = 'mob_ethereal_apprentice' WHERE `entry` = 18430; - -UPDATE `creature_template` SET `ScriptName` = 'boss_tavarok' WHERE `entry` = 18343; -UPDATE `creature_template` SET `ScriptName` = 'boss_pandemonius' WHERE `entry` = 18341; -UPDATE `creature_template` SET `ScriptName` = 'boss_nexusprince_shaffar' WHERE `entry` = 18344; - -UPDATE `creature_template` SET `ScriptName` = 'boss_ghazan' WHERE `entry` = 18105; Index: /unk/src/bindings/scripts/sql/Updates/r152.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r152.sql (revision 2) +++ (revision ) @@ -1,12 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_syth_fire' WHERE `entry` = 19203; -UPDATE `creature_template` SET `ScriptName` = 'mob_syth_arcane' WHERE `entry` = 19205; -UPDATE `creature_template` SET `ScriptName` = 'mob_syth_frost' WHERE `entry` = 19204; -UPDATE `creature_template` SET `ScriptName` = 'mob_syth_shadow' WHERE `entry` = 19206; - -UPDATE `creature_template` SET `ScriptName` = 'boss_tailonking_ikiss' WHERE `entry` = 18473; -UPDATE `creature_template` SET `ScriptName` = 'boss_darkweaver_syth' WHERE `entry` = 18472; - -UPDATE creature_template SET ScriptName = 'npc_shattrathflaskvendors' WHERE entry = '23483'; -UPDATE creature_template SET ScriptName = 'npc_shattrathflaskvendors' WHERE entry = '23484'; - -UPDATE `creature_template` SET ScriptName='innkeeper' WHERE `npcflag` & 128<>0; Index: /unk/src/bindings/scripts/sql/Updates/r221_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r221_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -ALTER TABLE `eventai_Scripts` RENAME TO `eventai_scripts`; Index: /unk/src/bindings/scripts/sql/Updates/r501_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r501_mangos.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_prof_alchemy' WHERE `entry` IN (17909,19052,22427); -UPDATE `creature_template` SET `ScriptName`='npc_prof_blacksmith' WHERE `entry` IN (5164,11145,11146,11176,11177,11178,11191,11192,11193); -UPDATE `creature_template` SET `ScriptName`='npc_prof_leather' WHERE `entry` IN (7866,7867,7868,7869,7870,7871); -UPDATE `creature_template` SET `ScriptName`='npc_prof_tailor' WHERE `entry` IN (22208,22212,22213); Index: /unk/src/bindings/scripts/sql/Updates/r191.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r191.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ - -/* THE MECHANAR */ -UPDATE `creature_template` SET `ScriptName` = 'boss_gatewatcher_iron_hand' WHERE `entry` = 19710; -UPDATE `creature_template` SET `ScriptName` = 'boss_nethermancer_sepethrea' WHERE `entry` = 19221; -UPDATE `creature_template` SET `ScriptName` = 'mob_ragin_flames' WHERE `entry` = 20481; Index: /unk/src/bindings/scripts/sql/Updates/r521_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r521_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_gregan_brewspewer' WHERE `entry`=7775; Index: /unk/src/bindings/scripts/sql/Updates/r333_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r333_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_oronok_tornheart' WHERE `entry` = 21183; Index: /unk/src/bindings/scripts/sql/Updates/r332_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r332_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -ALTER TABLE eventai_summons -ADD `comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment' AFTER spawntimesecs; Index: /unk/src/bindings/scripts/sql/Updates/r307_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r307_mangos.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npcs_dithers_and_arbington' WHERE `entry` IN (11056, 11057); -UPDATE `creature_template` SET `ScriptName` = 'npc_witch_doctor_mauari' WHERE `entry` = 10307; -UPDATE `creature_template` SET `ScriptName` = 'npcs_riverbreeze_and_silversky' WHERE `entry` IN (9528, 9529); -UPDATE `creature_template` SET `ScriptName` = 'npc_sayge' WHERE `entry` = 14822; Index: /unk/src/bindings/scripts/sql/Updates/r272_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r272_mangos.sql (revision 2) +++ (revision ) @@ -1,8 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_kaelthas' WHERE `entry` = 23054; -UPDATE `creature_template` SET `ScriptName` = 'boss_thaladred_the_darkener' WHERE `entry` = 20064; -UPDATE `creature_template` SET `ScriptName` = 'boss_lord_sanguinar' WHERE `entry` = 20060; -UPDATE `creature_template` SET `ScriptName` = 'boss_grand_astromancer_capernian' WHERE `entry` = 20062; -UPDATE `creature_template` SET `ScriptName` = 'boss_master_engineer_telonicus' WHERE `entry` = 20063; -UPDATE `creature_template` SET `ScriptName` = 'mob_phoenix' WHERE `entry` = 21362; -UPDATE `creature_template` SET `ScriptName` = 'mob_nether_vapor' WHERE `entry` = 21002; -UPDATE `creature_template` SET `ScriptName` = 'mob_kael_flamestrike' WHERE `entry` = 21369; Index: /unk/src/bindings/scripts/sql/Updates/r515_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r515_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_murkblood_overseer' WHERE `entry`=23309; Index: /unk/src/bindings/scripts/sql/Updates/r642_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r642_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='mob_shadowmoon_channeler' WHERE `entry`=17653; Index: /unk/src/bindings/scripts/sql/Updates/r281_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r281_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,35 +1,0 @@ -ALTER TABLE eventai_scripts -ADD event_chance tinyint(3) unsigned NOT NULL default 100 AFTER event_inverse_phase_mask; - --- EVENT_T_TIMER_REPEAT -UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 0 AND event_param3 < 0; - --- EVENT_T_TIMER_SINGLE -UPDATE eventai_scripts SET event_chance = event_param2 WHERE event_type = 1; - --- EVENT_T_TIMER_OOC_REPEAT -UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 2 AND event_param3 < 0; - --- EVENT_T_TIMER_OOC_SINGLE -UPDATE eventai_scripts SET event_chance = event_param2 WHERE event_type = 3; - --- EVENT_T_HP_SINGLE -UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 4 AND event_param3 < 0; - --- EVENT_T_MANA_SINGLE -UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 5 AND event_param3 < 0; - --- EVENT_T_AGGRO -UPDATE eventai_scripts SET event_chance = event_param1 WHERE event_type = 6; - --- EVENT_T_KILL -UPDATE eventai_scripts SET event_chance = event_param2 WHERE event_type = 7; - --- EVENT_T_DEATH -UPDATE eventai_scripts SET event_chance = event_param1 WHERE event_type = 8; - --- EVENT_T_EVADE -UPDATE eventai_scripts SET event_chance = event_param1 WHERE event_type = 9; - --- EVENT_T_SPELLHIT -UPDATE eventai_scripts SET event_chance = event_param3 WHERE event_type = 10; Index: /unk/src/bindings/scripts/sql/Updates/r327_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r327_mangos.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ --- Sunspring Villagers. -UPDATE `creature_template` SET `ScriptName` = 'mob_sunspring_villager' WHERE `entry` = 18240; - --- Terestian Illhoof -UPDATE `creature_template` SET `ScriptName` = 'mob_demon_chain' WHERE `entry` = 17248; Index: /unk/src/bindings/scripts/sql/Updates/r615_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r615_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ --- Structure updates - -ALTER TABLE localized_texts -ADD `locale_8` varchar(255) NOT NULL default '' AFTER locale_7; Index: /unk/src/bindings/scripts/sql/Updates/r197.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r197.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ --- scholomance script -UPDATE `instance_template` SET `script` = 'instance_scholomance' WHERE `map` = 289; - --- arcatraz script -UPDATE `instance_template` SET `script` = 'instance_arcatraz' WHERE `map` = 552; Index: /unk/src/bindings/scripts/sql/Updates/r428_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r428_mangos.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ --- Quest Support 10804 (Kindness) -UPDATE creature_template SET scriptname = 'mob_mature_netherwing_drake' WHERE entry = 21648; --- Quest Support 10854 (The Force of Neltharaku) -UPDATE creature_template SET scriptname = 'mob_enslaved_netherwing_drake' WHERE entry = 21722; Index: /unk/src/bindings/scripts/sql/Updates/r636_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r636_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_laj' WHERE `entry`=17980; Index: /unk/src/bindings/scripts/sql/Updates/r555_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r555_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `gameobject_template` SET `ScriptName`='go_manaforge_control_console' WHERE `entry` IN (183770,183956,184311,184312); -UPDATE `creature_template` SET `ScriptName`='npc_manaforge_control_console' WHERE `entry` IN (20209,20417,20418,20440); Index: /unk/src/bindings/scripts/sql/Updates/r286_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r286_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- Items -UPDATE `item_template` SET `ScriptName` = '' WHERE `entry` = 23751; -- Remove script for Skin of Purest Water Index: /unk/src/bindings/scripts/sql/Updates/r367_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r367_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_aquementas' WHERE `entry` = 9453; Index: /unk/src/bindings/scripts/sql/Updates/r575_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r575_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `item_template` SET `ScriptName`='item_gor_dreks_ointment' WHERE `entry`=30175; Index: /unk/src/bindings/scripts/sql/Updates/r494_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r494_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'gameobject_cage_trap' WHERE `entry` = 185916; Index: /unk/src/bindings/scripts/sql/Updates/r72.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r72.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mobs_mana_tapped' WHERE `entry` IN (15273,15274,15294,15298,15367); -UPDATE `creature_template` SET `ScriptName` = 'mobs_ghoul_flayer' WHERE `entry` IN (8530, 8531, 8532); -UPDATE `creature_template` SET `ScriptName` = 'mobs_bonechewer_orc' WHERE `entry` IN (16876, 16925, 18952, 19701); -UPDATE `item_template` SET `ScriptName` = 'purification_mixture' WHERE `entry`= 23268; Index: /unk/src/bindings/scripts/sql/Updates/r299_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r299_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,9 +1,0 @@ -CREATE TABLE `eventai_summons` ( -`id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT, -`position_x` float NOT NULL default '0', -`position_y` float NOT NULL default '0', -`position_z` float NOT NULL default '0', -`orientation` float NOT NULL default '0', -`spawntimesecs` int(11) unsigned NOT NULL default '120', -PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations'; Index: /unk/src/bindings/scripts/sql/Updates/r78.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r78.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `item_template` SET `ScriptName` = 'nether_wraith_beacon' WHERE `entry` = 31742; -UPDATE `item_template` SET `ScriptName` = 'area_52_special' WHERE `entry` = 28132; -UPDATE `creature_template` SET `ScriptName` = 'guard_shattrath' WHERE `entry` = 19687; Index: /unk/src/bindings/scripts/sql/Updates/r124.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r124.sql (revision 2) +++ (revision ) @@ -1,13 +1,0 @@ --- BT Trash Mobs -UPDATE `creature_template` SET `scriptname`='mob_blacktemple' WHERE `entry` IN (22844,22845,22846,22849,22853,22855,22869,22873,22875,22876,22877,22878,22880,22881,22882,22883,22884,22945,22953,22954,23337,23339); - --- The Eye Trash Mobs -UPDATE `creature_template` SET `scriptname`='mob_the_eye' WHERE `entry` IN (20031,20032,20033,20034,20035,20039,20041,20043,20046,20052); -UPDATE `creature_template` SET `scriptname`='mob_crystalcore_devastator' WHERE `entry`='20040'; - --- Uldaman Trash Mobs -UPDATE `creature_template` SET `scriptname`='mob_uldaman' WHERE `entry` IN (4847,4852,4853,4854,4860,4861,6910,7011,7012,7022,7030,7078,7291); -UPDATE `creature_template` SET `scriptname`='mob_jadespine_basilisk' WHERE `entry`='4863'; - --- Uldaman Boss Ironaya -UPDATE `creature_template` SET `scriptname`='boss_ironaya' WHERE `entry`='7228'; Index: /unk/src/bindings/scripts/sql/Updates/r161.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r161.sql (revision 2) +++ (revision ) @@ -1,12 +1,0 @@ --- shadow labyrinth -UPDATE `instance_template` SET `script` = 'instance_shadow_labyrinth' WHERE `map`= 555; -UPDATE `creature_template` SET `ScriptName` = 'boss_murmur' WHERE `entry` = 18708; -UPDATE `creature_template` SET `ScriptName` = 'boss_ambassador_hellmaw' WHERE `entry` = 18731; -UPDATE `creature_template` SET `ScriptName` = 'boss_grandmaster_vorpil' WHERE `entry` = 18732; -UPDATE `creature_template` SET `ScriptName` = 'boss_blackheart_the_inciter' WHERE `entry` = 18667; - --- fathomlord karathress -UPDATE `creature_template` SET `ScriptName` = 'boss_fathomlord_karathress' WHERE `entry`=21214; -UPDATE `creature_template` SET `ScriptName` = 'boss_fathomguard_sharkkis' WHERE `entry`=21966; -UPDATE `creature_template` SET `ScriptName` = 'boss_fathomguard_tidalvess' WHERE `entry`=21965; -UPDATE `creature_template` SET `ScriptName` = 'boss_fathomguard_caribdis' WHERE `entry`=21964; Index: /unk/src/bindings/scripts/sql/Updates/r163.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r163.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE creature_template SET npcflag=npcflag|1, ScriptName='npc_cairne_bloodhoof' WHERE entry=3057; -UPDATE `gameobject_template` SET `ScriptName`='go_barov_journal' WHERE `entry`=180794; Index: /unk/src/bindings/scripts/sql/Updates/r241_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r241_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_skyguard_handler_irena' WHERE `entry` = 23413; -UPDATE `creature_template` SET `ScriptName` = 'npc_skyguard_handler_deesak' WHERE `entry` = 23415; Index: /unk/src/bindings/scripts/sql/Updates/r240_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r240_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -ALTER TABLE `eventai_scripts` -ADD `event_inverse_phase_mask` int(11) signed NOT NULL default '0', COMMENT 'Mask which phases this event will not trigger in'; Index: /unk/src/bindings/scripts/sql/Updates/r128.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r128.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -update `creature_template` SET `scriptname`='npc_guardian' WHERE `entry`='5764'; Index: /unk/src/bindings/scripts/sql/Updates/r165.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r165.sql (revision 2) +++ (revision ) @@ -1,8 +1,0 @@ - --- the steam vault -UPDATE `instance_template` SET `script` = 'instance_steam_vault' WHERE `map` = 545; - --- right old hillsbrad foothills bosses script name -UPDATE `creature_template` SET `ScriptName` = 'boss_lieutenant_drake' WHERE `entry` = 17848; -UPDATE `creature_template` SET `ScriptName` = 'boss_epoch_hunter' WHERE `entry` = 18096; - Index: /unk/src/bindings/scripts/sql/Updates/r261_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r261_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_general_marcus_jonathan' WHERE `entry` = 466; Index: /unk/src/bindings/scripts/sql/Updates/r169.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r169.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ --- hellfire peninsula special taxi path -UPDATE `creature_template` SET `ScriptName` = 'npc_wing_commander_brack' WHERE `entry` = 19401; -UPDATE `creature_template` SET `ScriptName` = 'npc_wing_commander_dabiree' WHERE `entry` = 19409; -UPDATE `creature_template` SET `ScriptName` = 'npc_gryphoneer_windbellow' WHERE `entry` = 20235; Index: /unk/src/bindings/scripts/sql/Updates/r255_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r255_mangos.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ -UPDATE instance_template SET script = 'instance_zulaman' WHERE map = 568; -UPDATE creature_template SET scriptname='boss_janalai' WHERE entry=23578; -UPDATE creature_template SET scriptname='mob_jandalai_firebomb' WHERE entry=23920; -UPDATE creature_template SET scriptname='mob_amanishi_hatcher' WHERE entry=23818; -UPDATE creature_template SET scriptname='mob_hatchling' WHERE entry=23598; Index: /unk/src/bindings/scripts/sql/Updates/r336_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r336_mangos.sql (revision 2) +++ (revision ) @@ -1,9 +1,0 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'go_tablet_of_madness' WHERE `entry` = 180368; -UPDATE `creature_template` SET `ScriptName` = 'boss_grilek' WHERE `entry` = 15082; -UPDATE `creature_template` SET `ScriptName` = 'boss_hazzarah' WHERE `entry` = 15083; -UPDATE `creature_template` SET `ScriptName` = 'boss_renataki' WHERE `entry` = 15084; -UPDATE `creature_template` SET `ScriptName` = 'boss_wushoolay' WHERE `entry` = 15085; -UPDATE `creature_template` SET `ScriptName` = 'mobs_zulgurub' WHERE `entry` = 14883; -UPDATE `creature_template` SET `ScriptName` = 'mob_blackwing_lair' WHERE `entry` = 12468; - - Index: /unk/src/bindings/scripts/sql/Updates/r417_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r417_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `item_template` SET `ScriptName` = 'item_tame_beast_rods' WHERE `entry` IN (15908,15911,15913,15914,15915,15916,15917,15919,15920,15921,15922,15923,23697,23702,23703,23896,23897,23898); Index: /unk/src/bindings/scripts/sql/Updates/r634_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r634_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,35 +1,0 @@ -DROP TABLE IF EXISTS `script_texts`; -CREATE TABLE `script_texts` ( -`ScriptName` varchar(255) NOT NULL default '', -`Id` int(11) unsigned NOT NULL default '0', -`Sound` int(11) unsigned NOT NULL default '0', -`Type` int(11) unsigned NOT NULL default '0', -`Language` int(11) unsigned NOT NULL default '0', -`Text` varchar(255) NOT NULL default '', -`Comment` varchar(255) NOT NULL default '', -PRIMARY KEY (`ScriptName`,`Id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'; - - -DROP TABLE IF EXISTS `script_localized_texts`; -CREATE TABLE `script_localized_texts` ( -`id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier', -`locale_1` varchar(255) NOT NULL default '', -`locale_2` varchar(255) NOT NULL default '', -`locale_3` varchar(255) NOT NULL default '', -`locale_4` varchar(255) NOT NULL default '', -`locale_5` varchar(255) NOT NULL default '', -`locale_6` varchar(255) NOT NULL default '', -`locale_7` varchar(255) NOT NULL default '', -`locale_8` varchar(255) NOT NULL default '', -`comment` varchar(255) NOT NULL default '' COMMENT 'Text Comment', -PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Localized Script Text'; - - -DROP TABLE IF EXISTS `eventai_texts`; -CREATE TABLE `eventai_texts` AS SELECT `id`, `locale_0` AS `text`, `comment` FROM `localized_texts`; -TRUNCATE TABLE `localized_texts`; -DROP TABLE IF EXISTS `eventai_localized_texts`; -ALTER TABLE `localized_texts` RENAME TO `eventai_localized_texts`; -ALTER TABLE `eventai_localized_texts` DROP COLUMN `locale_0`; Index: /unk/src/bindings/scripts/sql/Updates/r590_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r590_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_sergeant_bly' WHERE `entry`=7604; -UPDATE `creature_template` SET `ScriptName`='npc_weegli_blastfuse' WHERE `entry`=7607; Index: /unk/src/bindings/scripts/sql/Updates/r518_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r518_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_rathis_tomber' WHERE `entry`=16224; Index: /unk/src/bindings/scripts/sql/Updates/r275_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r275_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_shade_of_jindo' WHERE `entry` = 14986; Index: /unk/src/bindings/scripts/sql/Updates/r249_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r249_mangos.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_flamewaker_priest' WHERE `entry` = 11662; -UPDATE `creature_template` SET `ScriptName` = 'boss_datrohan_balnazzar' WHERE `entry` = 10812; - Index: /unk/src/bindings/scripts/sql/Updates/r295_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r295_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `instance_template` SET `script` = 'instance_stratholme' WHERE `map` = 329; -UPDATE `creature_template` SET `ScriptName` = 'boss_silver_hand_bosses' WHERE `entry` IN (17910, 17911, 17912, 17913, 17914); Index: /unk/src/bindings/scripts/sql/Updates/r584_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r584_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `item_template` SET `ScriptName`='item_voodoo_charm' WHERE `entry`=8149; Index: /unk/src/bindings/scripts/sql/Updates/r269_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r269_mangos.sql (revision 2) +++ (revision ) @@ -1,6 +1,0 @@ --- removing old script names that does no longer exist -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (12198,14982,857,12197,7427,347,15007,2804); -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (9564,12136,3149,12137,9566,3150,9559,9558); -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` = 197; -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (11328, 11260); -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (80, 1236, 3578, 40, 1358, 1360, 5996, 1426, 1094, 674); Index: /unk/src/bindings/scripts/sql/Updates/r639_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r639_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_ravenholdt' WHERE `entry`=13936; Index: /unk/src/bindings/scripts/sql/Updates/r477_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r477_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=19577; Index: /unk/src/bindings/scripts/sql/Updates/r289_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r289_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `scriptname` = 'npc_creditmarker_visit_with_ancestors' WHERE `entry` IN (18840,18841,18842,18843); Index: /unk/src/bindings/scripts/sql/Updates/r659_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r659_mangos.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_akama_shade' WHERE `entry`=22990; -- Akama at Shade of Akama -UPDATE `creature_template` SET `ScriptName`='npc_akama_illidan' WHERE `entry`=23089; -- Akama at Illidan -UPDATE `creature_template` SET `ScriptName`='mob_illidari_council' WHERE `entry`=23426; -- Illidari Council controller mob -UPDATE `creature_template` SET `ScriptName`='mob_blood_elf_council_voice_trigger' WHERE `entry` = 23499; -- Voice Trigger Mob (Controls Aggro + Enrage yells) Index: /unk/src/bindings/scripts/sql/Updates/r578_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r578_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_forest_frog' WHERE `entry`=24396; Index: /unk/src/bindings/scripts/sql/Updates/r298_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r298_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- EVENT_T_SPELLHIT -UPDATE eventai_scripts SET event_param3 = event_param2, event_param2 = -1 WHERE event_type = 10; Index: /unk/src/bindings/scripts/sql/Updates/r81.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r81.sql (revision 2) +++ (revision ) @@ -1,35 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_gyth' WHERE `entry` = 10339; -UPDATE `creature_template` SET `ScriptName` = 'boss_rend_blackhand' WHERE `entry` = 10429; -UPDATE `creature_template` SET `ScriptName` = 'boss_pyroguard_emberseer' WHERE `entry` = 9816; -UPDATE `creature_template` SET `ScriptName` = 'mob_chromatic_elite_guard' WHERE `entry` = 10814; -UPDATE `creature_template` SET `ScriptName` = 'mob_ancient_core_hound' WHERE `entry` = 11673; -UPDATE `creature_template` SET `ScriptName` = 'mob_core_rager' WHERE `entry` = 11672; -UPDATE `creature_template` SET `ScriptName` = 'mob_firesworn' WHERE `entry` = 12099; -UPDATE `creature_template` SET `ScriptName` = 'mob_firewalker' WHERE `entry` = 11666; -UPDATE `creature_template` SET `ScriptName` = 'mob_flame_guard' WHERE `entry` = 11667; -UPDATE `creature_template` SET `ScriptName` = 'mob_flamewaker' WHERE `entry` = 11661; -UPDATE `creature_template` SET `ScriptName` = 'mob_flamewaker_elite' WHERE `entry` = 11664; -UPDATE `creature_template` SET `ScriptName` = 'mob_flamewaker_healer' WHERE `entry` = 11663; -UPDATE `creature_template` SET `ScriptName` = 'mob_flamewaker_protector' WHERE `entry` = 12119; -UPDATE `creature_template` SET `ScriptName` = 'mob_lavaspawn' WHERE `entry` = 12265; -UPDATE `creature_template` SET `ScriptName` = 'mob_molten_destroyer' WHERE `entry` = 11659; -UPDATE `creature_template` SET `ScriptName` = 'mob_molten_giant' WHERE `entry` = 11658; -UPDATE `creature_template` SET `ScriptName` = 'boss_azuregos' WHERE `entry` = 6109; - - - - - - - - - - - - - - - - - - Index: /unk/src/bindings/scripts/sql/Updates/Makefile.am =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/Makefile.am (revision 2) +++ (revision ) @@ -1,215 +1,0 @@ -# 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 Index: /unk/src/bindings/scripts/sql/Updates/Makefile.in =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/Makefile.in (revision 2) +++ (revision ) @@ -1,383 +1,0 @@ -# Makefile.in generated by automake 1.9.6 from Makefile.am. -# @configure_input@ - -# Copyright (C) 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, -# 2003, 2004, 2005 Free Software Foundation, Inc. -# This Makefile.in is free software; the Free Software Foundation -# gives unlimited permission to copy and/or distribute it, -# with or without modifications, as long as this notice is preserved. - -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY, to the extent permitted by law; without -# even the implied warranty of MERCHANTABILITY or FITNESS FOR A -# PARTICULAR PURPOSE. - -@SET_MAKE@ - -# Copyright (C) 2005,2006,2007 MaNGOS -# -# 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: Index: /unk/src/bindings/scripts/sql/Updates/r131.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r131.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_henze_faulk' WHERE `entry`= 6172; Index: /unk/src/bindings/scripts/sql/Updates/r214.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r214.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = "boss_hakkar" WHERE `creature_template`.`entry` = 14834; - Index: /unk/src/bindings/scripts/sql/Updates/r170.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r170.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- special taxi path netherstorm -UPDATE `creature_template` SET `ScriptName` = 'npc_protectorate_nether_drake' WHERE `entry` = 20903; Index: /unk/src/bindings/scripts/sql/Updates/r230_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r230_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_deserter_agitator' WHERE `entry` = 23602; -UPDATE `gameobject_template` SET `ScriptName` = 'go_field_repair_bot_74A' where `entry`= 179552; Index: /unk/src/bindings/scripts/sql/Updates/r311_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r311_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_invis_legion_teleporter' WHERE `entry` = 21807; Index: /unk/src/bindings/scripts/sql/Updates/r172.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r172.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ --- support multikill bladespire and bloodmaul ogres -UPDATE `creature_template` SET `ScriptName` = 'mobs_bladespire_ogre' WHERE `entry` IN (19998, 20334, 21296, 21975); -UPDATE `creature_template` SET `ScriptName` = 'mobs_bloodmaul_ogre' WHERE `entry` IN (19948, 19952, 19957); Index: /unk/src/bindings/scripts/sql/Updates/r218.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r218.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ --- misc quest related -UPDATE `creature_template` SET `ScriptName` = 'npc_restless_apparition' WHERE `entry` = 23861; -UPDATE `creature_template` SET `ScriptName` = 'mobs_direhorn_grimtotem' WHERE `entry` = 23595; -UPDATE `creature_template` SET `ScriptName` = 'mobs_risen_husk_spirit' WHERE `entry` IN (23554, 23555); - Index: /unk/src/bindings/scripts/sql/Updates/r250_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r250_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_dathrohan_balnazzar' WHERE `entry` = 10812; - Index: /unk/src/bindings/scripts/sql/Updates/r174.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r174.sql (revision 2) +++ (revision ) @@ -1,8 +1,0 @@ --- multikill creatures -UPDATE `creature_template` SET `ScriptName` = 'mobs_dragonmaw_orc' WHERE `entry` IN (21717, 21718, 21719, 21720, 22331); -UPDATE `creature_template` SET `ScriptName` = 'mobs_shadowmoon_valley_wildlife' WHERE `entry` IN (21878, 21879); -UPDATE `creature_template` SET `ScriptName` = 'mobs_gordunni_ogre' WHERE `entry` IN (22143, 22144, 22148, 23022); --- vendor -UPDATE `creature_template` SET `ScriptName` = 'npc_drake_dealer_hurlunk' WHERE `entry` = 23489; -UPDATE `creature_template` SET `ScriptName` = 'npc_rivern_frostwind' WHERE `entry` = 10618; - Index: /unk/src/bindings/scripts/sql/Updates/r513_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r513_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_salsalabim' WHERE `entry`=18584; Index: /unk/src/bindings/scripts/sql/Updates/r139.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r139.sql (revision 2) +++ (revision ) @@ -1,35 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_lokhtos_darkbargainer' WHERE `entry` = 12944; - -UPDATE creature_template SET ScriptName='npc_lady_jaina_proudmoore' WHERE entry=4968; - -UPDATE `creature_template` SET `ScriptName` = 'mobs_spitelashes' WHERE entry IN (6190,6193,6194,6195,6196,7885,7886,12204,12205); - -UPDATE creature_template SET npcflag=1, ScriptName='npc_beaten_corpse' WHERE entry=10668; -UPDATE quest_template SET SpecialFlags=8, ReqCreatureOrGOId1=10668, ReqCreatureOrGOCount1=1 WHERE entry=4921; - -UPDATE creature_template SET ScriptName='boss_rokmar_the_crackler' WHERE entry=17991; -UPDATE creature_template SET ScriptName='boss_warlord_kalithresh' WHERE entry=17798; - -UPDATE `creature_template` SET `ScriptName` = 'boss_midnight' WHERE `entry` = 16151; -UPDATE `creature_template` SET `ScriptName` = 'boss_attumen' WHERE `entry` = 15550; -UPDATE `creature_template` SET `ScriptName` = 'boss_moroes' WHERE `entry` = 15687; -UPDATE `creature_template` SET `ScriptName` = 'boss_maiden_of_virtue' WHERE `entry` = 16457; -UPDATE `creature_template` SET `ScriptName` = 'boss_curator' WHERE `entry` = 15691; -UPDATE `creature_template` SET `ScriptName` = 'boss_big_bad_wolf' WHERE `entry` = 17521; -UPDATE `creature_template` SET `ScriptName` = 'boss_julianne' WHERE `entry` = 17534; -UPDATE `creature_template` SET `ScriptName` = 'boss_romulo' WHERE `entry` = 17533; -UPDATE `creature_template` SET `ScriptName` = 'boss_dorothee' WHERE `entry` = 17535; -UPDATE `creature_template` SET `ScriptName` = 'boss_strawman' WHERE `entry` = 17543; -UPDATE `creature_template` SET `ScriptName` = 'boss_tinhead' WHERE `entry` = 17547; -UPDATE `creature_template` SET `ScriptName` = 'boss_tito' WHERE `entry` = 17548; -UPDATE `creature_template` SET `ScriptName` = 'boss_roar' WHERE `entry` = 17546; -UPDATE `creature_template` SET `ScriptName` = 'boss_crone' WHERE `entry` = 18168; -UPDATE `creature_template` SET `ScriptName` = 'boss_terestian_illhoof' WHERE `entry` = 15688; -UPDATE `creature_template` SET `ScriptName` = 'boss_shade_of_aran' WHERE `entry` = 16524; -UPDATE `creature_template` SET `ScriptName` = 'boss_netherspite' WHERE `entry` = 15689; -UPDATE `creature_template` SET `ScriptName` = 'boss_malchezaar' WHERE `entry` = 15690; -UPDATE `creature_template` SET `ScriptName` = 'boss_nightbane' WHERE `entry` = 17225; - -UPDATE `creature_template` SET `ScriptName` = 'mob_homunculus' WHERE `entry` = 16539; -UPDATE `creature_template` SET `ScriptName` = 'mob_kilrek' WHERE `entry` = 17229; -UPDATE `creature_template` SET `ScriptName` = 'netherspite_infernal' WHERE `entry` = 17646; Index: /unk/src/bindings/scripts/sql/Updates/r270_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r270_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_overseer_nuaar' WHERE `entry` = 21981; Index: /unk/src/bindings/scripts/sql/Updates/r176.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r176.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ --- tales and stories -UPDATE `creature_template` SET `ScriptName` = 'npc_tirion_fordring' WHERE `entry` = 1855; -UPDATE `creature_template` SET `ScriptName` = 'npc_loramus_thalipedes' WHERE `entry` = 7783; -UPDATE `creature_template` SET `ScriptName` = 'npc_fallen_hero_of_horde' WHERE `entry` = 7572; -UPDATE `creature_template` SET `ScriptName` = 'npc_lorax' WHERE `entry` = 10918; Index: /unk/src/bindings/scripts/sql/Updates/r533_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r533_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_augustus_the_touched' WHERE `entry`=12384; Index: /unk/src/bindings/scripts/sql/Updates/r227_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r227_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,29 +1,0 @@ -ALTER TABLE `eventai_scripts` - DROP PRIMARY KEY, - DROP `id`, - ADD `id` int(11) unsigned NOT NULL COMMENT 'Identifier' PRIMARY KEY AUTO_INCREMENT FIRST, - - MODIFY `event_param1` int(11) signed NOT NULL default '0', - MODIFY `event_param2` int(11) signed NOT NULL default '0', - MODIFY `event_param3` int(11) signed NOT NULL default '0', - - MODIFY `action1_param1` int(11) signed NOT NULL default '0', - MODIFY `action1_param2` int(11) signed NOT NULL default '0', - MODIFY `action1_param3` int(11) signed NOT NULL default '0', - - MODIFY `action2_param1` int(11) signed NOT NULL default '0', - MODIFY `action2_param2` int(11) signed NOT NULL default '0', - MODIFY `action2_param3` int(11) signed NOT NULL default '0', - - MODIFY `action3_param1` int(11) signed NOT NULL default '0', - MODIFY `action3_param2` int(11) signed NOT NULL default '0', - MODIFY `action3_param3` int(11) signed NOT NULL default '0', - - ADD `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment'; - -ALTER TABLE `localized_texts` - DROP PRIMARY KEY, - DROP `id`, - ADD `id` int(11) unsigned NOT NULL COMMENT 'Identifier' PRIMARY KEY AUTO_INCREMENT FIRST, - ADD `comment` varchar(255) NOT NULL default '' COMMENT 'Text Comment'; - Index: /unk/src/bindings/scripts/sql/Updates/r178.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r178.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- kharan mighthammer -UPDATE `creature_template` SET `ScriptName` = 'npc_kharan_mighthammer' WHERE `entry` = 9021; Index: /unk/src/bindings/scripts/sql/Updates/r264_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r264_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_astor_hadren' WHERE `entry` = 6497; Index: /unk/src/bindings/scripts/sql/Updates/r238_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r238_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- revert previously bad sql -UPDATE `creature_template` SET `ScriptName` = '' WHERE `ScriptName` LIKE '%innkeeper%' AND `npcflag` & 128<>0; Index: /unk/src/bindings/scripts/sql/Updates/r446_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r446_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- Set ACID (mob_eventai) ScriptName for 4 Hyjal-wave bosses -UPDATE `creature_template` SET `ScriptName` = 'mob_eventai' WHERE `entry` IN (17767, 17808, 17888, 17842); Index: /unk/src/bindings/scripts/sql/Updates/r258_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r258_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_deathly_usher' WHERE `entry` = 8816; Index: /unk/src/bindings/scripts/sql/Updates/r547_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r547_mangos.sql (revision 2) +++ (revision ) @@ -1,22 +1,0 @@ -/* Magister's Terrace */ -UPDATE `instance_template` SET `script` = 'instance_magisters_terrace' WHERE `map` = 585; -UPDATE `creature_template` SET `ScriptName` = 'boss_selin_fireheart' WHERE `entry` = 24723; -UPDATE `creature_template` SET `ScriptName` = 'mob_fel_crystal' WHERE `entry` = 24722; -UPDATE `creature_template` SET `ScriptName` = 'boss_vexallus' WHERE `entry` = 24744; -UPDATE `creature_template` SET `ScriptName` = 'mob_pure_energy' WHERE `entry` = 24745; -UPDATE `creature_template` SET `ScriptName` = 'boss_priestess_delrissa' WHERE `entry` = 24560; -UPDATE `creature_template` SET `ScriptName` = 'boss_kagani_nightstrike' WHERE `entry` = 24557; -UPDATE `creature_template` SET `ScriptName` = 'boss_ellris_duskhallow' WHERE `entry` = 24558; -UPDATE `creature_template` SET `ScriptName` = 'mob_imp' WHERE `entry` = 24656; -UPDATE `creature_template` SET `ScriptName` = 'boss_eramas_brightblaze' WHERE `entry` = 24554; -UPDATE `creature_template` SET `ScriptName` = 'boss_yazzai' WHERE `entry` = 24561; -UPDATE `creature_template` SET `ScriptName` = 'boss_warlord_salaris' WHERE `entry` = 24559; -UPDATE `creature_template` SET `ScriptName` = 'boss_garaxxas' WHERE `entry` = 24555; -UPDATE `creature_template` SET `ScriptName` = 'mob_sliver' WHERE `entry` = 24552; -UPDATE `creature_template` SET `ScriptName` = 'boss_apoko' WHERE `entry` = 24553; -UPDATE `creature_template` SET `ScriptName` = 'boss_zelfan' WHERE `entry` = 24556; -UPDATE `creature_template` SET `ScriptName` = 'boss_felblood_kaelthas' WHERE `entry` = 24664; -UPDATE `creature_template` SET `ScriptName` = 'mob_arcane_sphere' WHERE `entry` = 24708; -UPDATE `creature_template` SET `ScriptName` = 'mob_felkael_phoenix' WHERE `entry` = 24674; -UPDATE `creature_template` SET `ScriptName` = 'mob_felkael_phoenix_egg' WHERE `entry` = 24675; -UPDATE `creature_template` SET `ScriptName` = 'mob_felkael_flamestrike' WHERE `entry` = 24666; Index: /unk/src/bindings/scripts/sql/Updates/r628_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r628_mangos.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `instance_template` SET `script`='instance_shattered_halls' WHERE `map`=540; -UPDATE `creature_template` SET `ScriptName`='mob_fel_orc_convert' WHERE `entry`=17083; -UPDATE `creature_template` SET `ScriptName`='mob_lesser_shadow_fissure' WHERE `entry`=17471; Index: /unk/src/bindings/scripts/sql/Updates/r593_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r593_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `gameobject_template` SET `ScriptName`='go_tablet_of_the_seven' WHERE `entry`=169294; Index: /unk/src/bindings/scripts/sql/Updates/r486_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r486_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `gameobject_template` SET `ScriptName`='' WHERE `entry`=181956; Index: /unk/src/bindings/scripts/sql/Updates/r92.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r92.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npcs_rutgar_and_frankal' WHERE `entry` IN (15170, 15171); Index: /unk/src/bindings/scripts/sql/Updates/r59.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r59.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_narm_faulk' WHERE `entry`= 6177; -UPDATE `creature_template` SET `ScriptName` = 'npc_q8304' WHERE `entry` IN (15170, 15171); -UPDATE `creature_template` SET `ScriptName` = 'npc_q8507_q8731' WHERE `entry` IN (15440, 15612); Index: /unk/src/bindings/scripts/sql/Updates/r142.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r142.sql (revision 2) +++ (revision ) @@ -1,11 +1,0 @@ --- VoidReaver 19516 -UPDATE `creature_template` SET `ScriptName` = 'boss_void_reaver' WHERE `entry` = 19516; - --- Arcane Orb Target -REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (19577, 16946, 16946, 'Arcane Orb Target', '', 70, 70, 1, 1, 0, 0, 0, 35, 35, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 'mob_arcane_orb_target'); - -UPDATE `creature_template` SET `ScriptName` = 'boss_omor_the_unscarred' WHERE `entry` = 17308; -UPDATE `creature_template` SET `ScriptName` = 'boss_watchkeeper_gargolmar' WHERE `entry` = 17306; - -UPDATE `creature_template` SET `ScriptName` = 'boss_hungarfen' WHERE `entry` = 17770; -UPDATE `creature_template` SET `ScriptName` = 'mob_underbog_mushroom' WHERE `entry` = 17990; Index: /unk/src/bindings/scripts/sql/Updates/r144.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r144.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_the_maker' WHERE `entry` = 17381; -UPDATE `creature_template` SET `ScriptName` = 'boss_broggok' WHERE `entry` = 17380; -UPDATE `creature_template` SET `ScriptName` = 'boss_kelidan_the_breaker' WHERE `entry` = 17377; -UPDATE `creature_template` SET `ScriptName` = 'mob_broggok_poisoncloud' WHERE `entry` = 17662; -UPDATE `creature_template` SET minlevel = 63, maxlevel = 63 WHERE `entry` = 17662; Index: /unk/src/bindings/scripts/sql/Updates/r181.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r181.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ --- npc_lantresor_of_the_blade -UPDATE `creature_template` SET `ScriptName` = 'npc_lantresor_of_the_blade' WHERE `entry` = 18261; Index: /unk/src/bindings/scripts/sql/Updates/r183.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r183.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ --- revert to original specialflags + flag 4 for mangos support, script no longer needed for quest -UPDATE `quest_template` SET `SpecialFlags`= 140 WHERE `entry` IN (10040, 10041); -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (18716, 18717, 18719); --- gossip only, key to searing gorge discussion -UPDATE `creature_template` SET `ScriptName` = 'npc_mountaineer_pebblebitty' WHERE `entry` = 3836; Index: /unk/src/bindings/scripts/sql/Updates/r522_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r522_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='guard_shattrath_aldor' WHERE `entry`=18549; -UPDATE `creature_template` SET `ScriptName`='guard_shattrath_scryer' WHERE `entry`=18568; Index: /unk/src/bindings/scripts/sql/Updates/r334_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r334_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `instance_template` SET `script` = 'instance_sethekk_halls' WHERE `map` = 556; Index: /unk/src/bindings/scripts/sql/Updates/r253_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r253_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `item_template` SET `ScriptName` = 'item_zezzaks_shard' WHERE `entry` = 31463; Index: /unk/src/bindings/scripts/sql/Updates/r308_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r308_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_nat_pagle' WHERE `entry` = 12919; Index: /unk/src/bindings/scripts/sql/Updates/r273_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r273_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_saikkal_the_elder' WHERE `entry` = 22932; Index: /unk/src/bindings/scripts/sql/Updates/r187.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r187.sql (revision 2) +++ (revision ) @@ -1,12 +1,0 @@ --- test of lore quest npcs -UPDATE `creature_template` SET `ScriptName` = 'npc_parqual_fintallas' WHERE `entry` = 4488; -UPDATE `creature_template` SET `ScriptName` = 'npc_braug_dimspirit' WHERE `entry` = 4489; --- quest Scratches -UPDATE `creature_template` SET `ScriptName` = 'npc_daranelle' WHERE `entry` = 21469; - --- no comments of malfuntion, implementing mount vendors script -UPDATE `creature_template` SET `ScriptName` = 'npc_mount_vendor' WHERE `entry` IN (384, 1261, 1460, 2357, 3362, 3685, 4730, 4731, 4885, 7952, 7955, 16264, 17584); - --- one time update, this is database related sql and should be included in any database -UPDATE `creature_template` SET `npcflag` = `npcflag`|1 WHERE `entry` IN (4488, 4489, 21469); -INSERT IGNORE `spell_teleport` VALUES (6766, 1,-2354.03,-1902.07,95.78,4.6); Index: /unk/src/bindings/scripts/sql/Updates/r516_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r516_mangos.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_neeru_fireblade' WHERE `entry`=3216; -UPDATE `creature_template` SET `ScriptName`='npc_shenthul' WHERE `entry`=3401; -UPDATE `creature_template` SET `ScriptName`='npc_thrall_warchief' WHERE `entry`=4949; Index: /unk/src/bindings/scripts/sql/Updates/r643_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r643_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='mob_stolen_soul' WHERE `entry`=18441; -UPDATE `creature_template` SET `ScriptName`='mob_avatar_of_martyred' WHERE `entry`=18478; Index: /unk/src/bindings/scripts/sql/Updates/r374_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r374_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_the_scourge_cauldron' WHERE `entry` = 11152; Index: /unk/src/bindings/scripts/sql/Updates/r189.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r189.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'go_field_repair_bot' where `entry`=179552; -UPDATE `creature_template` SET `ScriptName` = 'boss_doomwalker' WHERE `entry` = 17711; -UPDATE `creature_template` SET `ScriptName` = 'boss_exarch_maladaar' WHERE `entry` = 18373; Index: /unk/src/bindings/scripts/sql/Updates/r617_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r617_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `item_template` SET `ScriptName`='item_razorthorn_flayer_gland' WHERE `entry`=34255; Index: /unk/src/bindings/scripts/sql/Updates/r637_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r637_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_high_botanist_freywinn' WHERE `entry`=17975; Index: /unk/src/bindings/scripts/sql/Updates/r448_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r448_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ -DROP TABLE IF EXISTS `db_version`; -DROP TABLE IF EXISTS `sd2_db_version`; -CREATE TABLE `sd2_db_version` ( -`version` varchar(255) NOT NULL default '' COMMENT 'Database version string' -) ENGINE=MyISAM DEFAULT CHARSET=utf8; Index: /unk/src/bindings/scripts/sql/Updates/r368_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r368_mangos.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ -UPDATE `instance_template` SET `script` = 'instance_shadowfang_keep' WHERE `map` = 33; -UPDATE `creature_template` SET `ScriptName` = 'boss_fenrus' WHERE `entry` = 4274; -UPDATE `creature_template` SET `ScriptName` = 'boss_nandos' WHERE `entry` = 3927; -UPDATE `creature_template` SET `ScriptName` = 'boss_rethilgore' WHERE `entry` = 3914; -UPDATE `creature_template` SET `ScriptName` = 'npc_shadowfang_prisoner' WHERE `entry` IN (3849, 3850); Index: /unk/src/bindings/scripts/sql/Updates/r576_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r576_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `item_template` SET `ScriptName`='item_muiseks_vessel' WHERE `entry` IN (9606,9618,9619,9620,9621); Index: /unk/src/bindings/scripts/sql/Updates/r596_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r596_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_ambassador_hellmaw' WHERE `entry`=18731; Index: /unk/src/bindings/scripts/sql/Updates/r110.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r110.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_illusionofjandicebarov' WHERE `entry` = 11439; Index: /unk/src/bindings/scripts/sql/Updates/27_Vaelastraz.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/27_Vaelastraz.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE creature_template SET faction=35 WHERE entry=13020; -UPDATE creature_template SET npcflag=65 WHERE entry=13020; Index: /unk/src/bindings/scripts/sql/Updates/09_BraveWindfeather.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/09_BraveWindfeather.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET`ScriptName` = '' WHERE `entry` = 3209; Index: /unk/src/bindings/scripts/sql/Updates/r153.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r153.sql (revision 2) +++ (revision ) @@ -1,33 +1,0 @@ --- Fishing net -UPDATE item_template SET ScriptName = 'draenei_fishing_net' WHERE entry = 23654; - --- Auchenai Crypts -UPDATE `creature_template` set `scriptname` = 'boss_shirrak_the_dead_watcher' where `entry` = '18371'; -UPDATE `creature_template` set `scriptname` = 'boss_shirrak_the_dead_watcher' where `entry` = '20318'; - --- Old Hillsbrad -UPDATE `creature_template` set `scriptname` = 'mob_lieutenant_drake' where `entry` = '17848'; -UPDATE `creature_template` set `scriptname` = 'mob_epoch_hunter' where `entry` = '18096'; -UPDATE `creature_template` SET `ScriptName` = 'boss_captain_skarloc' WHERE `entry`=17862; - --- The Black Morass -UPDATE `creature_template` set `ScriptName` = 'boss_chrono_lord_deja' where `entry` = '17879'; -UPDATE `creature_template` SET `ScriptName` = 'boss_aeonus' WHERE `entry`=17881; -UPDATE `creature_template` set `ScriptName` = 'boss_temporus' where `entry` = '17880'; - --- Deadmines -UPDATE `creature_template` SET `ScriptName` = 'boss_deadmines' WHERE `entry`=645; -UPDATE `creature_template` SET `ScriptName` = 'boss_deadmines' WHERE `entry`=1763; -UPDATE `creature_template` SET `ScriptName` = 'boss_deadmines' WHERE `entry`=599; -UPDATE `creature_template` SET `ScriptName` = 'boss_deadmines' WHERE `entry`=3586; - --- Wailing Caverns -UPDATE `creature_template` SET `ScriptName` = 'boss_wailing_caverns' WHERE `entry`=3654; - --- Gruul's Lair -UPDATE `creature_template` SET `ScriptName` = 'boss_high_king_maulgar' WHERE `entry`=18831; -UPDATE `creature_template` SET `ScriptName` = 'boss_kiggler_the_crazed' WHERE `entry`=18835; -UPDATE `creature_template` SET `ScriptName` = 'boss_blindeye_the_seer' WHERE `entry`=18836; -UPDATE `creature_template` SET `ScriptName` = 'boss_olm_the_summoner' WHERE `entry`=18834; -UPDATE `creature_template` SET `ScriptName` = 'boss_krosh_firehand' WHERE `entry`=18832; -UPDATE `instance_template` SET `script`="instance_gruuls_lair" WHERE `map`=565; Index: /unk/src/bindings/scripts/sql/Updates/r242_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r242_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_zamael_lunthistle' WHERE `entry` = 8436; -UPDATE `creature_template` SET `ScriptName` = 'npc_lothos_riftwaker' WHERE `entry` = 14387; Index: /unk/src/bindings/scripts/sql/Updates/r192.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r192.sql (revision 2) +++ (revision ) @@ -1,9 +1,0 @@ --- lady vashj event -UPDATE `creature_template` SET `ScriptName` = 'boss_lady_vashj' WHERE `entry` = 21212; -UPDATE `creature_template` SET `ScriptName` = 'mob_enchanted_elemental' WHERE `entry` = 21958; -UPDATE `creature_template` SET `ScriptName` = 'mob_tainted_elemental' WHERE `entry` = 22009; -UPDATE `creature_template` SET `ScriptName` = 'mob_coilfang_elite' WHERE `entry` = 22055; -UPDATE `creature_template` SET `ScriptName` = 'mob_coilfang_strider' WHERE `entry` = 22056; -UPDATE `creature_template` SET `ScriptName` = 'mob_fathom_sporebat' WHERE `entry` = 22120; - -UPDATE `gameobject_template` SET `ScriptName` = 'go_shield_generator' WHERE `entry` IN (185052, 185053, 185051, 185054); Index: /unk/src/bindings/scripts/sql/Updates/r157.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r157.sql (revision 2) +++ (revision ) @@ -1,7 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_hydross_the_unstable' WHERE `entry`=21216; -UPDATE `creature_template` SET `ScriptName` = 'boss_leotheras_the_blind' WHERE `entry`=21215; - --- Magtheridon's Lair -UPDATE `gameobject_template` SET `ScriptName`='go_manticron_cube' WHERE `entry`='181713'; -UPDATE `creature_template` SET `ScriptName` = 'boss_magtheridon' WHERE `entry`=17257; -UPDATE `creature_template` SET `ScriptName` = 'mob_hellfire_channeler' WHERE `entry`=17256; Index: /unk/src/bindings/scripts/sql/Updates/r306_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r306_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ -DROP TABLE IF EXISTS `db_version`; -CREATE TABLE `db_version` ( -`version` varchar(255) NOT NULL default '' COMMENT 'Database version string' -) ENGINE=MyISAM DEFAULT CHARSET=utf8; Index: /unk/src/bindings/scripts/sql/Updates/r262_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r262_mangos.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_royal_historian_archesonus' WHERE `entry` = 8879; -UPDATE `creature_template` SET `ScriptName` = 'npc_bunthen_plainswind' WHERE `entry` = 11798; -UPDATE `creature_template` SET `ScriptName` = 'npc_silva_filnaveth' WHERE `entry` = 11800; Index: /unk/src/bindings/scripts/sql/Updates/r632_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r632_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_warbringer_omrogg' WHERE `entry`=16809; -UPDATE `creature_template` SET `ScriptName`='mob_omrogg_heads' WHERE `entry` IN (19523,19524); Index: /unk/src/bindings/scripts/sql/Updates/r444_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r444_mangos.sql (revision 2) +++ (revision ) @@ -1,5 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=22120; -UPDATE `creature_template` SET `ScriptName`='mob_fathom_sporebat' WHERE `entry`=22140; -UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=20318; -UPDATE `creature_template` SET `ScriptName`='mob_eventai' WHERE `entry` IN (3927,3914,4274); -UPDATE `creature_template` SET `ScriptName`='mob_eventai' WHERE `entry` IN (21717,21718,21719,21720,22331,21878,21879,18371,18343,13083,17808); Index: /unk/src/bindings/scripts/sql/Updates/r282_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r282_mangos.sql (revision 2) +++ (revision ) @@ -1,38 +1,0 @@ -UPDATE creature_template SET ScriptName = 'npc_tyrande_whisperwind' WHERE entry = 17948; -UPDATE creature_template SET ScriptName = 'npc_thrall' WHERE entry = 17852; -UPDATE creature_template SET ScriptName = 'npc_jaina_proudmoore' WHERE entry = 17772; - -UPDATE creature_template SET ScriptName = 'npc_akama_shade' WHERE entry = 23089; -- Akama at Shade of Akama -UPDATE creature_template SET ScriptName = 'npc_akama_illidan' WHERE entry = 22990; -- Akama at Illidan -UPDATE creature_template SET ScriptName = 'illidari_council' WHERE entry = 23426; -- Illidari Council controller mob -UPDATE creature_template SET ScriptName = 'boss_veras_darkshadow' WHERE entry = 22952; -- Rogue of Illidari Council -UPDATE creature_template SET ScriptName = 'boss_teron_gorefiend' WHERE entry = 22871; -- Teron Gorefiend -UPDATE creature_template SET ScriptName = 'boss_supremus' WHERE entry = 22898; -- Supremus -UPDATE creature_template SET ScriptName = 'boss_shade_of_akama' WHERE entry = 22841; -- Shade of Akama -UPDATE creature_template SET ScriptName = 'boss_reliquary_of_souls' WHERE entry = 22856; -- Reliquary Controller Mob -UPDATE creature_template SET ScriptName = 'boss_essence_of_suffering' WHERE entry = 23418; -- Essence Of Suffering -UPDATE creature_template SET ScriptName = 'boss_essence_of_desire' WHERE entry = 23419; -- Essence of Desire -UPDATE creature_template SET ScriptName = 'boss_essence_of_anger' WHERE entry = 23420; -- Essence of Anger -UPDATE creature_template SET ScriptName = 'boss_najentus' WHERE entry = 22887; -- High Warlord Naj'entus -UPDATE creature_template SET ScriptName = 'boss_gurtogg_bloodboil' WHERE entry = 22948; -- Gurtogg Bloodboil -UPDATE creature_template SET ScriptName = 'boss_mother_shahraz' WHERE entry = 22947; -- Mother Shahraz -UPDATE creature_template SET ScriptName = 'boss_lady_malande' WHERE entry = 22951; -- Priest <3 at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_illidan_stormrage' WHERE entry = 22917; -- Illidan The Betrayer! -UPDATE creature_template SET ScriptName = 'boss_high_nethermancer_zerevor' WHERE entry = 22950; -- Mage at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_gathios_the_shatterer' WHERE entry = 22949; -- Paladin at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_maiev_shadowsong' WHERE entry = 23197; -- Maiev Shadowsong -UPDATE creature_template SET ScriptName = 'mob_blaze' WHERE entry = 23259; -- Blaze mob in Illidan Phase 2 -UPDATE creature_template SET ScriptName = 'mob_flame_of_azzinoth' WHERE entry = 22997; -- Flame of Azzinoth (Illidan Phase 2) -UPDATE creature_template SET ScriptName = 'mob_blade_of_azzinoth' WHERE entry = 22996; -- Blade of Azzinoth (Illidan Phase 2) -UPDATE creature_template SET ScriptName = 'mob_demon_fire' WHERE entry = 23069; -- Demon Fire in Illidan Phase 2 -UPDATE creature_template SET ScriptName = 'mob_flame_crash' WHERE entry = 23336; -- Flame Crash in Illidan Normal Form -UPDATE creature_template SET ScriptName = 'mob_cage_trap_trigger' WHERE entry = 23304; -- Cage Trap mob in Illidan Phase 3/4 Normal -UPDATE creature_template SET ScriptName = 'mob_shadow_demon' WHERE entry = 23375; -- Shadow Demon in Illidan Demon Form -UPDATE creature_template SET ScriptName = 'npc_volcano' WHERE entry = 23085; -- Supremus Volcano -UPDATE creature_template SET ScriptName = 'molten_flame' WHERE entry = 23095; -- Molten Flame in SUpremus -UPDATE creature_template SET ScriptName = 'mob_ashtongue_channeler' WHERE entry = 23421; -- Ashtongue CHanneler in Shade of AKama -UPDATE creature_template SET ScriptName = 'mob_ashtongue_sorcerer' WHERE entry = 23215; -- Ashtongue Sorcerer in Shade of Akama -UPDATE creature_template SET ScriptName = 'npc_enslaved_soul' WHERE entry = 23469; -- Enslaved Soul in Reliquary Event -UPDATE creature_template SET ScriptName = 'mob_doom_blossom' WHERE entry = 23123; -- Doom Blossoms in Teron Gorefiend's encounter --- UPDATE creature_template sET ScriptName = 'mob_shadowy_construct' WHERE entry = 23111; -- Shadowy Construct in Teron Gorefiend's encounter. Commented until Mind Control is implemented. --- UPDATE creature_template SET ScriptName = 'mob_najentus_spine' WHERE entry = 500000; -- Workaround creature for spine in Najentus event Index: /unk/src/bindings/scripts/sql/Updates/r256_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r256_mangos.sql (revision 2) +++ (revision ) @@ -1,35 +1,0 @@ -UPDATE creature_template SET ScriptName = 'npc_tyrande_whisperwind' WHERE entry = 17948; -UPDATE creature_template SET ScriptName = 'npc_thrall' WHERE entry = 17852; -UPDATE creature_template SET ScriptName = 'npc_jaina_proudmoore' WHERE entry = 17772; - -UPDATE creature_template SET ScriptName = 'npc_akama_shade' WHERE entry = 23089; -- Akama at Shade of Akama -UPDATE creature_template SET ScriptName = 'npc_akama_illidan' WHERE entry = 22990; -- Akama at Illidan -UPDATE creature_template SET ScriptName = 'illidari_council' WHERE entry = 23426; -- Illidari Council controller mob -UPDATE creature_template SET ScriptName = 'boss_veras_darkshadow' WHERE entry = 22952; -- Rogue of Illidari Council -UPDATE creature_template SET ScriptName = 'boss_teron_gorefiend' WHERE entry = 22871; -- Teron Gorefiend -UPDATE creature_template SET ScriptName = 'boss_supremus' WHERE entry = 22898; -- Supremus -UPDATE creature_template SET ScriptName = 'boss_shade_of_akama' WHERE entry = 22841; -- Shade of Akama -UPDATE creature_template SET ScriptName = 'boss_reliquary_of_souls' WHERE entry = 22856; -- Reliquary Controller Mob -UPDATE creature_template SET ScriptName = 'boss_essence_of_suffering' WHERE entry = 23418; -- Essence Of Suffering -UPDATE creature_template SET ScriptName = 'boss_essence_of_desire' WHERE entry = 23419; -- Essence of Desire -UPDATE creature_template SET ScriptName = 'boss_essence_of_anger' WHERE entry = 23420; -- Essence of Anger -UPDATE creature_template SET ScriptName = 'boss_najentus' WHERE entry = 22887; -- High Warlord Naj'entus -UPDATE creature_template SET ScriptName = 'boss_gurtogg_bloodboil' WHERE entry = 22948; -- Gurtogg Bloodboil -UPDATE creature_template SET ScriptName = 'boss_mother_shahraz' WHERE entry = 22947; -- Mother Shahraz -UPDATE creature_template SET ScriptName = 'boss_lady_malande' WHERE entry = 22951; -- Priest <3 at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_illidan_stormrage' WHERE entry = 22917; -- Illidan The Betrayer! -UPDATE creature_template SET ScriptName = 'boss_high_nethermancer_zerevor' WHERE entry = 22950; -- Mage at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_gathios_the_shatterer' WHERE entry = 22949; -- Paladin at Illidari Council -UPDATE creature_template SET ScriptName = 'boss_maiev_shadowsong' WHERE entry = 23197; -- Maiev Shadowsong -UPDATE creature_template SET ScriptName = 'mob_blaze' WHERE entry = 23259; -- Blaze mob in Illidan Phase 2 -UPDATE creature_template SET ScriptName = 'mob_flame_of_azzinoth' WHERE entry = 22997; -- Flame of Azzinoth (Illidan Phase 2) -UPDATE creature_template SET ScriptName = 'mob_demon_fire' WHERE entry = 23069; -- Demon Fire in Illidan Phase 2 -UPDATE creature_template SET ScriptName = 'mob_flame_crash' WHERE entry = 23336; -- Flame Crash in Illidan Normal Form -UPDATE creature_template SET ScriptName = 'mob_cage_trap_trigger' WHERE entry = 23304; -- Cage Trap mob in Illidan Phase 3/4 Normal -UPDATE creature_template SET ScriptName = 'mob_shadow_demon' WHERE entry = 23375; -- Shadow Demon in Illidan Demon Form -UPDATE creature_template SET ScriptName = 'npc_volcano' WHERE entry = 23085; -- Supremus Volcano -UPDATE creature_template SET ScriptName = 'molten_flame' WHERE entry = 23095; -- Molten Flame in SUpremus -UPDATE creature_template SET ScriptName = 'mob_ashtongue_channeler' WHERE entry = 23421; -- Ashtongue CHanneler in Shade of AKama -UPDATE creature_template SET ScriptName = 'mob_ashtongue_sorcerer' WHERE entry = 23215; -- Ashtongue Sorcerer in Shade of Akama -UPDATE creature_template SET ScriptName = 'npc_enslaved_soul' WHERE entry = 23469; -- Enslaved Soul in Reliquary Event --- UPDATE creature_template SET ScriptName = 'mob_najentus_spine' WHERE entry = 500000; -- Workaround creature for spine in Najentus event Index: /unk/src/bindings/scripts/sql/Updates/r519_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r519_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_calvin_montague' WHERE `entry`=6784; Index: /unk/src/bindings/scripts/sql/Updates/r591_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r591_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='mobs_nether_drake' WHERE `entry` IN (20021,21817,21820,21821,21823); Index: /unk/src/bindings/scripts/sql/Updates/r484_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r484_mangos.sql (revision 2) +++ (revision ) @@ -1,8 +1,0 @@ --- Quest support 9678 -UPDATE `gameobject_template` SET `ScriptName`='go_gilded_brazier' WHERE `entry` = '181956'; - --- Archimonde with related creatures. -UPDATE `creature_template` SET `Scriptname` = "boss_archimonde" WHERE `entry` = 17968; -UPDATE `creature_template` SET `ScriptName` = "mob_doomfire" WHERE `entry` = 18095; -UPDATE `creature_template` SET `Scriptname` = "mob_doomfire_targetting" WHERE `entry` = 18104; -UPDATE `creature_template` SET `ScriptName` = "mob_ancient_wisp" WHERE `entry` = 17946; Index: /unk/src/bindings/scripts/sql/Updates/r646_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r646_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_harbinger_skyriss_illusion' WHERE `entry` IN (21466,21467); Index: /unk/src/bindings/scripts/sql/Updates/r538_scriptdev2.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r538_scriptdev2.sql (revision 2) +++ (revision ) @@ -1,60 +1,0 @@ --- Structure updates - -ALTER TABLE eventai_scripts -ADD event_flags tinyint(3) unsigned NOT NULL default '0' AFTER event_chance; - -ALTER TABLE eventai_scripts -ADD event_param4 int(11) signed NOT NULL default '0' AFTER event_param3; - --- Event updates - --- EVENT_T_TIMER_REPEAT -UPDATE eventai_scripts SET event_param4 = event_param3+event_param1, event_param3 = event_param1, event_param1 = event_param2, event_flags = 1 WHERE event_type = 0; - --- EVENT_T_TIMER_SINGLE -UPDATE eventai_scripts SET event_param4 = event_param3+event_param1, event_param3 = event_param1, event_param1 = event_param2, event_type = 0 WHERE event_type = 1; - --- EVENT_T_TIMER_OOC_REPEAT -UPDATE eventai_scripts SET event_param4 = event_param3+event_param1, event_param3 = event_param1, event_param1 = event_param2, event_flags = 1, event_type = 1 WHERE event_type = 2; - --- EVENT_T_TIMER_OOC_SINGLE -UPDATE eventai_scripts SET event_param4 = event_param3+event_param1, event_param3 = event_param1, event_param1 = event_param2, event_type = 1 WHERE event_type = 3; - --- EVENT_T_HP_SINGLE -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 0, event_type = 2 WHERE event_type = 4; - --- EVENT_T_MANA_SINGLE -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 0, event_type = 3 WHERE event_type = 5; - --- EVENT_T_AGGRO -UPDATE eventai_scripts SET event_type = 4 WHERE event_type = 6; - --- EVENT_T_KILL -UPDATE eventai_scripts SET event_param2 = event_param1, event_flags = 1, event_type = 5 WHERE event_type = 7; - --- EVENT_T_DEATH -UPDATE eventai_scripts SET event_type = 6 WHERE event_type = 8; - --- EVENT_T_EVADE -UPDATE eventai_scripts SET event_type = 7 WHERE event_type = 9; - --- EVENT_T_SPELLHIT -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 1, event_type = 8 WHERE event_type = 10; - --- EVENT_T_RANGE -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 1, event_type = 9 WHERE event_type = 11; - --- EVENT_T_OOC_LOS -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 1, event_type = 10 WHERE event_type = 12; - --- EVENT_T_SPAWNED -UPDATE eventai_scripts SET event_type = 11 WHERE event_type = 13; - --- EVENT_T_TARGET_HP -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 1, event_type = 12 WHERE event_type = 14; - --- EVENT_T_TARGET_CASTING -UPDATE eventai_scripts SET event_param2 = event_param1, event_flags = 1, event_type = 13 WHERE event_type = 15; - --- EVENT_T_FRIENDLY_HP -UPDATE eventai_scripts SET event_param4 = event_param3, event_flags = 1, event_type = 14 WHERE event_type = 16; Index: /unk/src/bindings/scripts/sql/Updates/r121.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r121.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mobs_spectral_ghostly_citizen' WHERE `entry` IN (10384, 10385); - Index: /unk/src/bindings/scripts/sql/Updates/r123.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r123.sql (revision 2) +++ (revision ) @@ -1,4 +1,0 @@ -UPDATE creature_template SET ScriptName = 'dashel_stonefist' WHERE entry = '4961'; -UPDATE creature_template SET ScriptName = 'blood_knight_stillblade' WHERE entry = '17768'; -UPDATE creature_template SET ScriptName = 'shattered_rumbler' WHERE entry = '17157'; -UPDATE `creature_template` SET `ScriptName`='neltharaku' WHERE `entry`='21657'; Index: /unk/src/bindings/scripts/sql/Updates/r204.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r204.sql (revision 2) +++ (revision ) @@ -1,7 +1,0 @@ --- lady vashj event -UPDATE `gameobject_template` SET `type`=0,`ScriptName`='' WHERE `entry` IN (185052, 185053, 185051, 185054); -UPDATE `item_template` SET `ScriptName` = 'item_tainted_core' WHERE `entry` = 31088; -UPDATE `creature_template` SET `ScriptName` = 'mob_shield_generator_channel' WHERE `entry` = 19870; - --- BWL trash mobs -UPDATE `creature_template` SET `ScriptName` = 'mob_blackwing_lair' WHERE `entry` IN (14265, 12457, 13996, 12459, 14261, 14263, 12467, 12463, 12461, 12464, 12460, 12465, 14262, 14264); Index: /unk/src/bindings/scripts/sql/Updates/r125.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r125.sql (revision 2) +++ (revision ) @@ -1,24 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_infested_root_walker' WHERE `entry` = 22095; -UPDATE `creature_template` SET `ScriptName` = 'mob_rotting_forest_rager' WHERE `entry` = 22307; -UPDATE `creature_template` SET `ScriptName` = 'mob_netherweb_victim' WHERE `entry` = 22355; - -UPDATE `creature_template` SET `ScriptName` = 'mobs_shadow_council_covert' WHERE `entry` IN (18716, 18717, 18719); -UPDATE `creature_template` SET `npcflag` = 1 WHERE `entry` IN (18716, 18717, 18719); - -UPDATE `creature_template` SET `ScriptName` = 'mob_gurok_the_usurper' WHERE `entry` = 18182; -UPDATE `creature_template` SET `ScriptName` = 'mob_shattered_rumbler' WHERE `entry` = '17157'; -UPDATE `creature_template` SET `ScriptName` = 'mobs_kilsorrow_agent' WHERE `entry` IN (17146, 17147, 17148, 18397, 18658); -UPDATE `creature_template` SET `ScriptName` = 'npc_altruis_the_sufferer' WHERE `entry` = 18417; - -UPDATE `creature_template` SET `ScriptName` = 'npcs_ashyen_and_keleth' WHERE `entry` IN (17900, 17901); -UPDATE `creature_template` SET `npcflag` = 1 WHERE `entry` IN (17900,17901); -UPDATE `creature_template` SET `ScriptName` = 'npc_elder_kuruti' WHERE `entry` = 18197; -UPDATE `creature_template` SET `npcflag` = 1 WHERE `entry` = 18197; - -UPDATE `creature_template` SET `ScriptName` = 'mob_lunaclaw' WHERE `entry` = 12138; - -UPDATE `creature_template` SET `ScriptName` = 'npc_steward_of_time' WHERE `entry` = 20142; - -UPDATE `creature_template` SET `ScriptName` = 'boss_death_knight_darkreaver' WHERE `entry` = 14516; - -UPDATE `creature_template` SET `ScriptName` = 'mob_yenniku' WHERE `entry` = 2530; Index: /unk/src/bindings/scripts/sql/Updates/r206.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r206.sql (revision 2) +++ (revision ) @@ -1,16 +1,0 @@ --- Zul'Gurub Bosses Part 1 + Trash Mobs -UPDATE `creature_template` SET `ScriptName` = 'boss_jeklik' WHERE `entry` = 14517; -UPDATE `creature_template` SET `ScriptName` = 'boss_venoxis' WHERE `entry` = 14607; -UPDATE `creature_template` SET `ScriptName` = 'boss_marli' WHERE `entry` = 14510; -UPDATE `creature_template` SET `ScriptName` = 'boss_mandokir' WHERE `entry` = 11382; -UPDATE `creature_template` SET `ScriptName` = 'boss_gahzranka' WHERE `entry` = 15114; -UPDATE `creature_template` SET `ScriptName` = 'boss_jindo' WHERE `entry` = 11380; - -/* Spawn of Marli */ -UPDATE `creature_template` SET `ScriptName` = 'mob_spawn_of_marli' WHERE `entry` = 15041; -/* Jeklik Batrider */ -UPDATE `creature_template` SET `ScriptName` = 'mob_batrider' WHERE `entry` = 14965; - - --- Darkmaster Ganling -UPDATE `creature_template` SET `ScriptName` = 'boss_darkmaster_gandling' WHERE `entry` = 1853; Index: /unk/src/bindings/scripts/sql/Updates/r312_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r312_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_captured_sunhawk_agent' WHERE `entry` = 17824; -UPDATE `creature_template` SET `ScriptName` = 'npc_neltharaku' WHERE `entry` = 21657; Index: /unk/src/bindings/scripts/sql/Updates/r164.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r164.sql (revision 2) +++ (revision ) @@ -1,10 +1,0 @@ --- gruuls lair trash mobs -UPDATE `creature_template` SET `ScriptName` = 'mob_gruuls_lair' WHERE `entry` IN (19389, 21350); - --- morogrim tidewalker -UPDATE `creature_template` SET `ScriptName` = 'boss_morogrim_tidewalker' WHERE `entry`=21213; --- Water Globule -UPDATE `creature_template` SET `ScriptName` = 'mob_water_globule' WHERE `entry`=21913; - --- Serpentshrine Cavern Trash Mobs -UPDATE `creature_template` SET `ScriptName` = 'mob_serpentshrine_cavern' WHERE `entry` IN (21246, 21339, 21221, 21224, 21227, 21228, 21226, 21225, 21298, 21299); Index: /unk/src/bindings/scripts/sql/Updates/r520_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r520_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `item_template` SET `ScriptName`='item_disciplinary_rod' WHERE `entry`=22473; -UPDATE `item_template` SET `ScriptName`='item_protovoltaic_magneto_collector' WHERE `entry`=30656; Index: /unk/src/bindings/scripts/sql/Updates/r621_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r621_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_talon_king_ikiss' WHERE `entry`=18473; Index: /unk/src/bindings/scripts/sql/Updates/r352_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r352_mangos.sql (revision 2) +++ (revision ) @@ -1,23 +1,0 @@ --- Moroes -update creature_template set scriptname = "boss_moroes" where entry = 15687; -update creature_template set scriptname = "boss_baroness_dorothea_millstipe" where entry = 19875; -update creature_template set scriptname = "boss_baron_rafe_dreuger" where entry = 19874; -update creature_template set scriptname = "boss_lady_catriona_von_indi" where entry = 19872; -update creature_template set scriptname = "boss_lady_keira_berrybuck" where entry = 17007; -update creature_template set scriptname = "boss_lord_robin_daris" where entry = 19876; -update creature_template set scriptname = "boss_lord_crispin_ference" where entry = 19873; - --- Barnes -update creature_template set scriptname = "npc_barnes" where entry = 16812; --- Oz Event -update creature_template set scriptname = "boss_dorothee" where entry = 17535; -update creature_template set scriptname = "boss_strawman" where entry = 17543; -update creature_template set scriptname = "boss_tinhead" where entry = 17547; -update creature_template set scriptname = "boss_roar" where entry = 17546; -update creature_template set scriptname = "boss_crone" where entry = 18168; --- Hood Event -update creature_template set scriptname = "npc_grandmother" where entry = 17603; -update creature_template set scriptname = "boss_bigbadwolf" where entry = 17521; --- Romeo and Juliet disabled for now --- update creature_template set scriptname = "boss_julianne" where entry = 17543; --- update creature_template set scriptname = "boss_romulo" where entry = 17533; Index: /unk/src/bindings/scripts/sql/Updates/r271_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r271_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_greatmother_geyah' WHERE `entry` = 18141; Index: /unk/src/bindings/scripts/sql/Updates/r514_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r514_mangos.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_raliq_the_drunk' WHERE `entry`=18585; -UPDATE `creature_template` SET `ScriptName`='npc_cooshcoosh' WHERE `entry`=18586; -UPDATE `creature_template` SET `ScriptName`='npc_floon' WHERE `entry`=18588; Index: /unk/src/bindings/scripts/sql/Updates/r291_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r291_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_spawn_of_fankriss' WHERE `entry` = 15630; Index: /unk/src/bindings/scripts/sql/Updates/r265_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r265_mangos.sql (revision 2) +++ (revision ) @@ -1,9 +1,0 @@ -UPDATE `item_template` SET `ScriptName` = 'item_nether_wraith_beacon' WHERE `entry` = 31742; -UPDATE `item_template` SET `ScriptName` = 'item_area_52_special' WHERE `entry` = 28132; -UPDATE `item_template` SET `ScriptName` = 'item_vorenthals_presence' WHERE `entry` = 30259; -UPDATE `item_template` SET `ScriptName` = 'item_draenei_fishing_net' WHERE `entry` = 23654; -UPDATE `item_template` SET `ScriptName` = 'item_skin_of_purest_water' WHERE `entry` = 23751; -UPDATE `item_template` SET `ScriptName` = 'item_yehkinyas_bramble' WHERE `entry` = 10699; -UPDATE `item_template` SET `ScriptName` = 'item_zezzaks_shard' WHERE `entry` = 31463; -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (40100,40101,40102,40103,40104,40105,40106,40107,40108,40109,40110,40111,40112,40113); -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` IN (40200,40201,40202,40203,40204,40205,40206,40207,40208,40209,40210,40211,40212,40213); Index: /unk/src/bindings/scripts/sql/Updates/r239_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r239_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `item_template` SET `ScriptName` = '' WHERE `entry` = 23268; Index: /unk/src/bindings/scripts/sql/Updates/r473_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r473_mangos.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `item_template` SET `ScriptName`='item_soul_cannon' WHERE `entry`=32825; -UPDATE `item_template` SET `ScriptName`='item_sparrowhawk_net' WHERE `entry`=32321; -UPDATE `item_template` SET `ScriptName`='item_blackwhelp_net' WHERE `entry`=31129; Index: /unk/src/bindings/scripts/sql/Updates/r554_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r554_mangos.sql (revision 2) +++ (revision ) @@ -1,3 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_mekgineer_steamrigger' WHERE `entry`=17796; -UPDATE `creature_template` SET `ScriptName`='mob_steamrigger_mechanic' WHERE `entry`=17951; -UPDATE `creature_template` SET `ScriptName`='mob_naga_distiller' WHERE `entry`=17954; Index: /unk/src/bindings/scripts/sql/Updates/r528_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r528_mangos.sql (revision 2) +++ (revision ) @@ -1,2 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_skorn_whitecloud' WHERE `entry`=3052; -UPDATE `creature_template` SET `ScriptName`='npc_blood_knight_stillblade' WHERE `entry`=17768; Index: /unk/src/bindings/scripts/sql/Updates/r467_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r467_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `item_template` SET `ScriptName`='item_flying_machine' WHERE `entry` IN (34060,34061); Index: /unk/src/bindings/scripts/sql/Updates/r386_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r386_mangos.sql (revision 2) +++ (revision ) @@ -1,7 +1,0 @@ -UPDATE `item_template` SET `ScriptName` = 'item_Sparrowhawk_Net' WHERE `entry` = 32321; -UPDATE `item_template` SET `ScriptName` = 'item_Blackwhelp_Net' WHERE `entry` = 31129; - -UPDATE `creature_template` SET `ScriptName` = 'npc_spirit_of_olum' WHERE `entry` = 23411; - -UPDATE creature_template SET ScriptName='boss_warp_splinter' WHERE entry='17977'; -UPDATE creature_template SET ScriptName='mob_warp_splinter_treant' WHERE entry='19949'; Index: /unk/src/bindings/scripts/sql/Updates/r594_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r594_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='mob_anubisath_sentinel' WHERE `entry`=15264; Index: /unk/src/bindings/scripts/sql/Updates/r487_mangos.sql =================================================================== --- /trunk/src/bindings/scripts/sql/Updates/r487_mangos.sql (revision 2) +++ (revision ) @@ -1,1 +1,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_prospector_anvilward' WHERE `entry`=15420;