From 2bf8110032e84796f21d4d44d72e33abc58a4e1e Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 2 Oct 2021 21:46:58 +0200 Subject: Core/Players: Do not show zone on character list before first login --- sql/base/characters_database.sql | 3 ++- sql/updates/characters/master/2021_10_02_01_characters.sql | 1 + 2 files changed, 3 insertions(+), 1 deletion(-) create mode 100644 sql/updates/characters/master/2021_10_02_01_characters.sql (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 637cfc8c1b0..005b09ff3e9 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -3721,7 +3721,8 @@ INSERT INTO `updates` VALUES ('2021_07_04_00_characters.sql','E0E7AD664DDB553E96B457DD9ED8976665E94007','ARCHIVED','2021-07-04 22:23:24',0), ('2021_08_11_00_characters.sql','2137A52A45B045104B97D39626CE3C0214625B17','ARCHIVED','2021-08-11 21:48:57',0), ('2021_08_18_00_characters.sql','5BA1326EE8EC907CDE82E6E8BCB38EA2E661F10A','ARCHIVED','2021-08-18 15:14:17',0), -('2021_10_02_00_characters.sql','C6831D3ED03F6BD390A5E5E403FA402D6DC0E95D','RELEASED','2021-10-02 21:21:37',0); +('2021_10_02_00_characters.sql','C6831D3ED03F6BD390A5E5E403FA402D6DC0E95D','RELEASED','2021-10-02 21:21:37',0), +('2021_10_02_01_characters.sql','F97B956F3B5F909294CA399F75B5795A07C4D8EC','RELEASED','2021-10-02 21:47:38',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/master/2021_10_02_01_characters.sql b/sql/updates/characters/master/2021_10_02_01_characters.sql new file mode 100644 index 00000000000..e4c6a5e83b0 --- /dev/null +++ b/sql/updates/characters/master/2021_10_02_01_characters.sql @@ -0,0 +1 @@ +UPDATE `characters` SET `zone`=0 WHERE (`at_login` & 0x20) != 0; -- cgit v1.2.3