From ce7699af544c4323d2d1c3cd4798bfaee886e93d Mon Sep 17 00:00:00 2001 From: QAston Date: Thu, 2 Jul 2009 11:00:48 +0200 Subject: [8107] Fixed sql queries included in [8098]. Author: GriffonHeart. --HG-- branch : trunk --- sql/updates/4346_8098_characters.sql | 2 +- sql/updates/4346_8098_world.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/updates/4346_8098_characters.sql b/sql/updates/4346_8098_characters.sql index 158e36500d9..897b2f7a34d 100644 --- a/sql/updates/4346_8098_characters.sql +++ b/sql/updates/4346_8098_characters.sql @@ -4,7 +4,7 @@ ALTER TABLE character_action CHANGE COLUMN action action int(11) unsigned NOT NULL default '0'; UPDATE character_action - SET action = action | ( misc < 16 ); + SET action = action | ( misc << 16 ); ALTER TABLE character_action DROP COLUMN misc; diff --git a/sql/updates/4346_8098_world.sql b/sql/updates/4346_8098_world.sql index 36e0dd7a3e7..ad81835b433 100644 --- a/sql/updates/4346_8098_world.sql +++ b/sql/updates/4346_8098_world.sql @@ -4,7 +4,7 @@ ALTER TABLE playercreateinfo_action CHANGE COLUMN action action int(11) unsigned NOT NULL default '0'; UPDATE playercreateinfo_action - SET action = action | ( misc < 16 ); + SET action = action | ( misc << 16 ); ALTER TABLE playercreateinfo_action DROP COLUMN misc; -- cgit v1.2.3