From 3363d030faa7dac3f0afdf68bcc30d713b939d4d Mon Sep 17 00:00:00 2001 From: theluda Date: Thu, 20 Sep 2007 15:09:21 +0000 Subject: [PATCH] [4489] Fixed a few missing eol-style svn properties. --- configure.ac | 2 +- sql/updates/4470_command.sql | 8 ++++---- sql/updates/4480_spell_affect.sql | 18 +++++++++--------- sql/updates/4481_spell_affect.sql | 8 ++++---- sql/updates/4482_playercreateinfo.sql | 22 +++++++++++----------- sql/updates/4482_spell_proc_event.sql | 14 +++++++------- sql/updates/4488_db_version.sql | 12 ++++++------ 7 files changed, 42 insertions(+), 42 deletions(-) diff --git a/configure.ac b/configure.ac index db2084e2..4c4915e4 100644 --- a/configure.ac +++ b/configure.ac @@ -20,7 +20,7 @@ AC_CONFIG_SRCDIR([src/shared/Base.cpp]) ## Prelude, basic settings for Automake # Turn on all warnings and error messages, and enforce GNU # standards for the package. -AM_INIT_AUTOMAKE([-Wall -Werror dist-bzip2]) +AM_INIT_AUTOMAKE([-Wall -Werror]) AM_MAINTAINER_MODE ## Check for required dependencies. diff --git a/sql/updates/4470_command.sql b/sql/updates/4470_command.sql index e7a9c329..bbd104b7 100644 --- a/sql/updates/4470_command.sql +++ b/sql/updates/4470_command.sql @@ -1,4 +1,4 @@ -delete from command where name in('movegens'); -INSERT INTO `command` VALUES -('movegens',3,'Syntax: .movegens\r\n Show movement generators stack for selected creature or player.'); - +delete from command where name in('movegens'); +INSERT INTO `command` VALUES +('movegens',3,'Syntax: .movegens\r\n Show movement generators stack for selected creature or player.'); + diff --git a/sql/updates/4480_spell_affect.sql b/sql/updates/4480_spell_affect.sql index 7241dba2..74fec20b 100644 --- a/sql/updates/4480_spell_affect.sql +++ b/sql/updates/4480_spell_affect.sql @@ -1,9 +1,9 @@ --- Improved Fire Totems 1-2 Rangs -DELETE FROM `spell_affect` WHERE `entry` IN (16544,16086); -INSERT INTO `spell_affect` VALUES -(16544,0,0,0,0,0,0,32,0), -(16544,1,0,0,0,0,0,32,0), -(16544,2,0,0,0,0,0,1073741824,0), -(16086,0,0,0,0,0,0,32,0), -(16086,1,0,0,0,0,0,32,0), -(16086,2,0,0,0,0,0,1073741824,0); +-- Improved Fire Totems 1-2 Rangs +DELETE FROM `spell_affect` WHERE `entry` IN (16544,16086); +INSERT INTO `spell_affect` VALUES +(16544,0,0,0,0,0,0,32,0), +(16544,1,0,0,0,0,0,32,0), +(16544,2,0,0,0,0,0,1073741824,0), +(16086,0,0,0,0,0,0,32,0), +(16086,1,0,0,0,0,0,32,0), +(16086,2,0,0,0,0,0,1073741824,0); diff --git a/sql/updates/4481_spell_affect.sql b/sql/updates/4481_spell_affect.sql index 23d99e5f..cd1535c8 100644 --- a/sql/updates/4481_spell_affect.sql +++ b/sql/updates/4481_spell_affect.sql @@ -1,4 +1,4 @@ -DELETE FROM `spell_affect` WHERE `entry` IN (16544,16086) AND `effectId`=2; -INSERT INTO `spell_affect` VALUES -(16544,2,0,0,0,0,0,4,0), -(16086,2,0,0,0,0,0,4,0); +DELETE FROM `spell_affect` WHERE `entry` IN (16544,16086) AND `effectId`=2; +INSERT INTO `spell_affect` VALUES +(16544,2,0,0,0,0,0,4,0), +(16086,2,0,0,0,0,0,4,0); diff --git a/sql/updates/4482_playercreateinfo.sql b/sql/updates/4482_playercreateinfo.sql index ad9c68ae..bd7c02fb 100644 --- a/sql/updates/4482_playercreateinfo.sql +++ b/sql/updates/4482_playercreateinfo.sql @@ -1,11 +1,11 @@ -UPDATE playercreateinfo_spell SET Spell = '21084' WHERE Spell = '20154'; -UPDATE playercreateinfo_action SET action = '21084' WHERE action = '20154'; -DELETE FROM `character_spell` WHERE spell='20154'; - --- re-add all default spells if not have with from spell list -INSERT IGNORE INTO `character_spell` -SELECT `character`.`guid`,`playercreateinfo_spell`.`spell` AS `spell`, '65535' AS `slot`,`playercreateinfo_spell`.`Active` AS `active` -FROM `character`,`playercreateinfo_spell` -WHERE `character`.`class`=`playercreateinfo_spell`.`class` AND `character`.`race`=`playercreateinfo_spell`.`race`; - -UPDATE character_action SET action = '21084' WHERE action = '20154' AND `type` = 0; +UPDATE playercreateinfo_spell SET Spell = '21084' WHERE Spell = '20154'; +UPDATE playercreateinfo_action SET action = '21084' WHERE action = '20154'; +DELETE FROM `character_spell` WHERE spell='20154'; + +-- re-add all default spells if not have with from spell list +INSERT IGNORE INTO `character_spell` +SELECT `character`.`guid`,`playercreateinfo_spell`.`spell` AS `spell`, '65535' AS `slot`,`playercreateinfo_spell`.`Active` AS `active` +FROM `character`,`playercreateinfo_spell` +WHERE `character`.`class`=`playercreateinfo_spell`.`class` AND `character`.`race`=`playercreateinfo_spell`.`race`; + +UPDATE character_action SET action = '21084' WHERE action = '20154' AND `type` = 0; diff --git a/sql/updates/4482_spell_proc_event.sql b/sql/updates/4482_spell_proc_event.sql index 3ebb7cc3..bf1371d1 100644 --- a/sql/updates/4482_spell_proc_event.sql +++ b/sql/updates/4482_spell_proc_event.sql @@ -1,7 +1,7 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (12284,12701,12702,12703,12704); -INSERT INTO `spell_proc_event` VALUES -(12284,0,0,0,0,0,1,0.33252), -(12701,0,0,0,0,0,1,0.66504), -(12702,0,0,0,0,0,1,0.99756), -(12703,0,0,0,0,0,1,1.33008), -(12704,0,0,0,0,0,1,1.66260); +DELETE FROM `spell_proc_event` WHERE `entry` IN (12284,12701,12702,12703,12704); +INSERT INTO `spell_proc_event` VALUES +(12284,0,0,0,0,0,1,0.33252), +(12701,0,0,0,0,0,1,0.66504), +(12702,0,0,0,0,0,1,0.99756), +(12703,0,0,0,0,0,1,1.33008), +(12704,0,0,0,0,0,1,1.66260); diff --git a/sql/updates/4488_db_version.sql b/sql/updates/4488_db_version.sql index 0e322cab..704942e9 100644 --- a/sql/updates/4488_db_version.sql +++ b/sql/updates/4488_db_version.sql @@ -1,6 +1,6 @@ -DROP TABLE IF EXISTS `db_version`; -CREATE TABLE `db_version` ( - `version` varchar(120) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; - -INSERT INTO `db_version` VALUES ( 'unknown world database.' ); +DROP TABLE IF EXISTS `db_version`; +CREATE TABLE `db_version` ( + `version` varchar(120) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; + +INSERT INTO `db_version` VALUES ( 'unknown world database.' ); -- 2.11.4.GIT