diff options
| author | Kinzcool <kinzzcool@hotmail.com> | 2014-12-28 15:06:07 -0500 |
|---|---|---|
| committer | Kinzcool <kinzzcool@hotmail.com> | 2014-12-28 15:06:07 -0500 |
| commit | 0dec23b43ad8692189b511bb114ef3b772678fe3 (patch) | |
| tree | 2c2df816cd50ed39ba9018dfa68ae821cf1cb84e | |
| parent | ab24c0b37f863ab6084fd36f1304b1cbb312e298 (diff) | |
SQL: Added a missing semicolon
| -rw-r--r-- | sql/updates/world/2014_12_28_04_world.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/updates/world/2014_12_28_04_world.sql b/sql/updates/world/2014_12_28_04_world.sql index 1a04d014138..abd02d38d13 100644 --- a/sql/updates/world/2014_12_28_04_world.sql +++ b/sql/updates/world/2014_12_28_04_world.sql @@ -1429,4 +1429,4 @@ SELECT `ID`, `RequiredSkillId`, `RequiredSkillPoints`, `RequiredMinRepFaction`, WHERE `ID` NOT IN (SELECT `ID` FROM `quest_template_addon`) AND (`RequiredSkillId`!=0 OR `RequiredSkillPoints`!=0 OR `RequiredMinRepFaction`!=0 OR `RequiredMaxRepFaction`!=0 OR `RequiredMinRepValue`!=0 OR `RequiredMaxRepValue`!=0); UPDATE `quest_template_addon` A INNER JOIN `quest_template` B ON A.`ID`=B.`ID` -SET A.`RequiredSkillID`=B.`RequiredSkillId`, A.`RequiredSkillPoints`=B.`RequiredSkillPoints`, A.`RequiredMinRepFaction`=B.`RequiredMinRepFaction`, A.`RequiredMaxRepFaction`=B.`RequiredMaxRepFaction`, A.`RequiredMinRepValue`=B.`RequiredMinRepValue`, A.`RequiredMaxRepValue`=B.`RequiredMaxRepValue` +SET A.`RequiredSkillID`=B.`RequiredSkillId`, A.`RequiredSkillPoints`=B.`RequiredSkillPoints`, A.`RequiredMinRepFaction`=B.`RequiredMinRepFaction`, A.`RequiredMaxRepFaction`=B.`RequiredMaxRepFaction`, A.`RequiredMinRepValue`=B.`RequiredMinRepValue`, A.`RequiredMaxRepValue`=B.`RequiredMaxRepValue`; |