diff options
Diffstat (limited to 'sql/old/4.3.4')
20 files changed, 158 insertions, 0 deletions
diff --git a/sql/old/4.3.4/2012_07_03_00_world_item_template_addon_434.sql b/sql/old/4.3.4/2012_07_03_00_world_item_template_addon_434.sql new file mode 100644 index 00000000000..6cc5b547867 --- /dev/null +++ b/sql/old/4.3.4/2012_07_03_00_world_item_template_addon_434.sql @@ -0,0 +1 @@ +ALTER TABLE `item_template_addon` DROP `BuyCount`; diff --git a/sql/old/4.3.4/2012_07_05_00_world_item_template_addon_434.sql b/sql/old/4.3.4/2012_07_05_00_world_item_template_addon_434.sql new file mode 100644 index 00000000000..140fc3a9940 --- /dev/null +++ b/sql/old/4.3.4/2012_07_05_00_world_item_template_addon_434.sql @@ -0,0 +1 @@ +ALTER TABLE `item_template_addon` ADD `FlagsCu` INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `Id`; diff --git a/sql/old/4.3.4/2012_08_04_01_world_player_classlevelstats_434.sql b/sql/old/4.3.4/2012_08_04_01_world_player_classlevelstats_434.sql new file mode 100644 index 00000000000..9b2bcb6d6ca --- /dev/null +++ b/sql/old/4.3.4/2012_08_04_01_world_player_classlevelstats_434.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS `player_classlevelstats`;
\ No newline at end of file diff --git a/sql/old/4.3.4/2012_08_05_01_world_item_set_names_434.sql b/sql/old/4.3.4/2012_08_05_01_world_item_set_names_434.sql new file mode 100644 index 00000000000..6e7cd5dbc61 --- /dev/null +++ b/sql/old/4.3.4/2012_08_05_01_world_item_set_names_434.sql @@ -0,0 +1,2 @@ +DROP TABLE IF EXISTS `locales_item_set_names`; +DROP TABLE IF EXISTS `item_set_names`; diff --git a/sql/old/4.3.4/2012_08_05_02_world_command_434.sql b/sql/old/4.3.4/2012_08_05_02_world_command_434.sql new file mode 100644 index 00000000000..69fd621c457 --- /dev/null +++ b/sql/old/4.3.4/2012_08_05_02_world_command_434.sql @@ -0,0 +1,2 @@ +DELETE FROM `command` WHERE `name` = 'reload locales_item_set_name'; +DELETE FROM `command` WHERE `name` = 'reload item_set_names'; diff --git a/sql/old/4.3.4/2012_08_06_00_world_classlevelstats_434.sql b/sql/old/4.3.4/2012_08_06_00_world_classlevelstats_434.sql new file mode 100644 index 00000000000..e6038374508 --- /dev/null +++ b/sql/old/4.3.4/2012_08_06_00_world_classlevelstats_434.sql @@ -0,0 +1,7 @@ +ALTER TABLE `creature_classlevelstats` ADD `basehp3` smallint(6) NOT NULL DEFAULT '1' AFTER `basehp2`; + +ALTER TABLE `creature_classlevelstats` CHANGE `basehp0` `basehp0` smallint(6) NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp1` `basehp1` smallint(6) NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp2` `basehp2` smallint(6) NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basemana` `basemana` smallint(6) NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basearmor` `basearmor` smallint(6) NOT NULL DEFAULT '1'; diff --git a/sql/old/4.3.4/2012_08_06_00_world_command_434.sql b/sql/old/4.3.4/2012_08_06_00_world_command_434.sql new file mode 100644 index 00000000000..50628aaa589 --- /dev/null +++ b/sql/old/4.3.4/2012_08_06_00_world_command_434.sql @@ -0,0 +1,4 @@ +DELETE FROM `command` WHERE `name` IN ('server togglequerylog', 'server set loglevel'); + +INSERT INTO `command` (`name`,`security`,`help`) VALUES +('server set loglevel',4,'Syntax: .server set loglevel $facility $name $loglevel. $facility can take the values: appender (a) or logger (l). $loglevel can take the values: disabled (0), trace (1), debug (2), info (3), warn (4), error (5) or fatal (6)'); diff --git a/sql/old/4.3.4/2012_08_06_01_world_classlevelstats_434.sql b/sql/old/4.3.4/2012_08_06_01_world_classlevelstats_434.sql new file mode 100644 index 00000000000..6fe7ad67994 --- /dev/null +++ b/sql/old/4.3.4/2012_08_06_01_world_classlevelstats_434.sql @@ -0,0 +1,6 @@ +ALTER TABLE `creature_classlevelstats` CHANGE `basehp0` `basehp0` mediumint(8) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp1` `basehp1` mediumint(8) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp2` `basehp2` mediumint(8) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp3` `basehp3` mediumint(8) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basemana` `basemana` mediumint(8) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basearmor` `basearmor` mediumint(8) unsigned NOT NULL DEFAULT '1'; diff --git a/sql/old/4.3.4/2012_08_08_00_world_creature_template_434.sql b/sql/old/4.3.4/2012_08_08_00_world_creature_template_434.sql new file mode 100644 index 00000000000..1e934b9f612 --- /dev/null +++ b/sql/old/4.3.4/2012_08_08_00_world_creature_template_434.sql @@ -0,0 +1 @@ +ALTER TABLE `creature_template` ADD `Mana_mod_extra` float NOT NULL DEFAULT '1' AFTER `Mana_mod`; diff --git a/sql/old/4.3.4/2012_08_12_00_world_misc_434.sql b/sql/old/4.3.4/2012_08_12_00_world_misc_434.sql new file mode 100644 index 00000000000..740b9c3582c --- /dev/null +++ b/sql/old/4.3.4/2012_08_12_00_world_misc_434.sql @@ -0,0 +1,59 @@ +UPDATE `creature_template` SET `ScriptName`='' WHERE `ScriptName` IN ( +'mobs_spitelashes', +'npc_loramus_thalipedes', +'mob_rizzle_sprysprocket', +'mob_depth_charge', +'npc_geezle', +'boss_azuregos', +'npc_kerlonian', +'npc_prospector_remtravel', +'npc_threshwackonator', +'go_iruxos', +'npc_dalinda', +'npc_tiger_matriarch_credit', +'npc_tiger_matriarch', +'npc_troll_volunteer', +'mobs_risen_husk_spirit', +'npc_lady_jaina_proudmoore', +'npc_nat_pagle', +'npc_private_hendel', +'npc_zelfrax', +'npc_theramore_guard', +'npcs_riverbreeze_and_silversky', +'npc_gregan_brewspewer', +'npc_oox22fe', +'npc_screecher_spirit', +'npc_bunthen_plainswind', +'npc_great_bear_spirit', +'npc_silva_filnaveth', +'npc_clintar_dreamwalker', +'npc_clintar_spirit', +'npc_plains_vision', +'npc_shenthul', +'npc_thrall_warchief', +'go_crystalline_tear', +'npc_anachronos_quest_trigger', +'npc_anachronos_the_ancient', +'mob_qiraj_war_spawn', +'npc_braug_dimspirit', +'npc_kaya_flathoof', +'mob_aquementas', +'npc_marin_noggenfogger', +'npc_stone_watcher_of_norgannon', +'npc_tooga', +'npc_beaten_corpse', +'npc_gilthares', +'npc_sputtervalve', +'npc_taskmaster_fizzule', +'npc_twiggy_flathead', +'npc_kanati', +'npc_lakota_windsong', +'npc_paoka_swiftmountain', +'npc_plucky', +'npc_enraged_panther', +'go_panther_cage', +'npc_ame', +'npc_ringo' +); + +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_mount_check','spell_voljin_war_drums'); diff --git a/sql/old/4.3.4/2012_08_12_03_world_misc_434.sql b/sql/old/4.3.4/2012_08_12_03_world_misc_434.sql new file mode 100644 index 00000000000..aa6c11ee1f8 --- /dev/null +++ b/sql/old/4.3.4/2012_08_12_03_world_misc_434.sql @@ -0,0 +1,38 @@ +DELETE FROM `creature_text` WHERE `entry`=2768; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(2768,0,0,'Ok, $N. Follow me to the cave where I''ll attempt to harness the power of the rune stone into these goggles.',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_1'), +(2768,1,0,'I discovered this cave on our first day here. I believe the energy in the stone can be used to our advantage.',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_2'), +(2768,2,0,'I''ll begin drawing energy from the stone. Your job, $N, is to defend me. This place is cursed... trust me.',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_3'), +(2768,3,0,'%s begins tinkering with the goggles before the stone.',16,0,100,0,0,0,'Professor Phizzlethorpe - EMOTE_PROGRESS_4'), +(2768,4,0,'Help!!! Get these things off me so I can get my work done!',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_AGGRO'), +(2768,5,0,'Almost done! Just a little longer!',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_5'), +(2768,6,0,'I''ve done it! I have harnessed the power of the stone into the goggles! Let''s get out of here!',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_6'), +(2768,7,0,'Phew! Glad to be back from that creepy cave.',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_7'), +(2768,8,0,'%s hands one glowing goggles over to Doctor Draxlegauge.',16,0,100,0,0,0,'Professor Phizzlethorpe - EMOTE_PROGRESS_8'), +(2768,9,0,'Doctor Draxlegauge will give you further instructions, $N. Many thanks for your help!',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_9'); + +DELETE FROM `script_waypoint` WHERE `entry`=2768; +INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES +(2768,1,-2072.32,-2089.59,9.14603,0,''), +(2768,2,-2078.18,-2096.31,10.8916,0,''), +(2768,3,-2079.21,-2105.22,13.3174,0,''), +(2768,4,-2074.81,-2108.72,14.1485,0,''), +(2768,5,-2076,-2116.21,16.3934,0,''), +(2768,6,-2073.31,-2123.92,18.6202,4000,''), +(2768,7,-2064.41,-2133.33,21.5776,0,''), +(2768,8,-2044.08,-2153.12,20.121,18000,''), +(2768,9,-2044.08,-2153.12,20.121,3000,''), +(2768,10,-2044.08,-2153.12,20.121,0,''), +(2768,11,-2044.08,-2153.12,20.121,14000,''), +(2768,12,-2063.89,-2133.33,21.5648,0,''), +(2768,13,-2075,-2121.98,17.8443,0,''), +(2768,14,-2074.83,-2108.53,14.1036,0,''), +(2768,15,-2079.59,-2091.61,9.80862,0,''), +(2768,16,-2071.29,-2086.44,8.5181,0,''), +(2768,17,-2066.46,-2085.97,8.9241,7000,''); + +DELETE FROM `creature_questrelation` WHERE `id`=2768 AND `quest`=26050; +INSERT INTO `creature_questrelation` (`id`, `quest`) +VALUES (2768, 26050); + +UPDATE `creature_template` SET `ScriptName`='npc_professor_phizzlethorpe' WHERE `entry`=2768;
\ No newline at end of file diff --git a/sql/old/4.3.4/2012_08_13_00_world_quest_template_434.sql b/sql/old/4.3.4/2012_08_13_00_world_quest_template_434.sql new file mode 100644 index 00000000000..d4a0960e044 --- /dev/null +++ b/sql/old/4.3.4/2012_08_13_00_world_quest_template_434.sql @@ -0,0 +1,2 @@ +-- ALTER TABLE `quest_template` CHANGE `MinLevel` `MinLevel` tinyint(4) NOT NULL DEFAULT '0'; +-- Properly fixed in 53a2b8622812f365ca7d31fdbf75fe9a1707ac7 diff --git a/sql/old/4.3.4/2012_08_14_00_world_event_ai_434.sql b/sql/old/4.3.4/2012_08_14_00_world_event_ai_434.sql new file mode 100644 index 00000000000..3fe49aa4059 --- /dev/null +++ b/sql/old/4.3.4/2012_08_14_00_world_event_ai_434.sql @@ -0,0 +1,3 @@ +DROP TABLE `creature_ai_scripts`; +DROP TABLE `creature_ai_summons`; +DROP TABLE `creature_ai_texts`; diff --git a/sql/old/4.3.4/2012_08_14_00_world_reputation_spillover_template_434.sql b/sql/old/4.3.4/2012_08_14_00_world_reputation_spillover_template_434.sql new file mode 100644 index 00000000000..afce8209afa --- /dev/null +++ b/sql/old/4.3.4/2012_08_14_00_world_reputation_spillover_template_434.sql @@ -0,0 +1,13 @@ +ALTER TABLE `reputation_spillover_template` +ADD COLUMN `faction5` SMALLINT(6) UNSIGNED DEFAULT '0' NOT NULL AFTER `rank_4`, +ADD COLUMN `rate_5` FLOAT DEFAULT '0' NOT NULL AFTER `faction5`, +ADD COLUMN `rank_5` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `rate_5`; + +UPDATE `reputation_spillover_template` SET `faction5`=1134,`rate_5`=0.25,`rank_5`=7 WHERE `faction` IN (72,47,54,930,69); +UPDATE `reputation_spillover_template` SET `faction5`=1133,`rate_5`=0.25,`rank_5`=7 WHERE `faction` IN (76,530,911,81,68); + +DELETE FROM `reputation_spillover_template` WHERE `faction` IN (1134,1133); +INSERT INTO `reputation_spillover_template`(`faction`,`faction1`,`rate_1`,`rank_1`,`faction2`,`rate_2`,`rank_2`,`faction3`,`rate_3`,`rank_3`,`faction4`,`rate_4`,`rank_4`,`faction5`,`rate_5`,`rank_5`) VALUES +(1134,72,0.25,7,47,0.27,7,54,0.25,7,930,0.25,7,69,0.25,7), +(1133,76,0.25,7,530,0.27,7,911,0.25,7,81,0.25,7,68,0.25,7); + diff --git a/sql/old/4.3.4/2012_08_14_01_world_commands_434.sql b/sql/old/4.3.4/2012_08_14_01_world_commands_434.sql new file mode 100644 index 00000000000..aa030e01adb --- /dev/null +++ b/sql/old/4.3.4/2012_08_14_01_world_commands_434.sql @@ -0,0 +1 @@ +DELETE FROM `command` WHERE `name`='reload all eventai'; diff --git a/sql/old/4.3.4/2012_08_14_02_world_npc_vendor_434.sql b/sql/old/4.3.4/2012_08_14_02_world_npc_vendor_434.sql new file mode 100644 index 00000000000..de00be694fc --- /dev/null +++ b/sql/old/4.3.4/2012_08_14_02_world_npc_vendor_434.sql @@ -0,0 +1,6 @@ +ALTER TABLE `npc_vendor` ADD `type` tinyint(3) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `game_event_npc_vendor` ADD `type` tinyint(3) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `npc_vendor` CHANGE `maxcount` `maxcount` mediumint(8) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_npc_vendor` CHANGE `maxcount` `maxcount` mediumint(8) unsigned NOT NULL DEFAULT '0'; +UPDATE `trinity_string` SET `content_default` = 'Item \'%u\' (type %u) not found in database.' WHERE `entry`=207; +UPDATE `trinity_string` SET `content_default` = 'Item \'%u\' (with extended cost %u, type %u) already in vendor list' WHERE `entry`=210; diff --git a/sql/old/4.3.4/2012_08_15_00_world_quest_template_434.sql b/sql/old/4.3.4/2012_08_15_00_world_quest_template_434.sql new file mode 100644 index 00000000000..423edb1c77b --- /dev/null +++ b/sql/old/4.3.4/2012_08_15_00_world_quest_template_434.sql @@ -0,0 +1,2 @@ +ALTER TABLE `quest_template` CHANGE `MinLevel` `MinLevel` smallint(6) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template` CHANGE `MaxLevel` `MaxLevel` smallint(6) NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_08_15_01_world_misc_434.sql b/sql/old/4.3.4/2012_08_15_01_world_misc_434.sql new file mode 100644 index 00000000000..dae8500479b --- /dev/null +++ b/sql/old/4.3.4/2012_08_15_01_world_misc_434.sql @@ -0,0 +1,3 @@ +ALTER TABLE `quest_poi` DROP INDEX `idx`; +ALTER TABLE `game_event_npc_vendor` DROP INDEX `PRIMARY`, ADD PRIMARY KEY (`guid`, `item`, `ExtendedCost`, `type`); +ALTER TABLE `npc_vendor` DROP INDEX `PRIMARY`, ADD PRIMARY KEY (`entry`, `item`, `ExtendedCost`, `type`); diff --git a/sql/old/4.3.4/2012_08_15_02_world_quest_template_434.sql b/sql/old/4.3.4/2012_08_15_02_world_quest_template_434.sql new file mode 100644 index 00000000000..a435f54e639 --- /dev/null +++ b/sql/old/4.3.4/2012_08_15_02_world_quest_template_434.sql @@ -0,0 +1,5 @@ +ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride1` `RewardFactionValueIdOverride1` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride2` `RewardFactionValueIdOverride2` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride3` `RewardFactionValueIdOverride3` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride4` `RewardFactionValueIdOverride4` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride5` `RewardFactionValueIdOverride5` int(11) NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_08_15_03_world_rep_spillover_template_434.sql b/sql/old/4.3.4/2012_08_15_03_world_rep_spillover_template_434.sql new file mode 100644 index 00000000000..08469f1b59e --- /dev/null +++ b/sql/old/4.3.4/2012_08_15_03_world_rep_spillover_template_434.sql @@ -0,0 +1 @@ +ALTER TABLE `reputation_spillover_template` CHANGE `faction5` `faction5` smallint(5) unsigned NOT NULL DEFAULT '0'; |