diff options
| author | Shauren <shauren.trinity@gmail.com> | 2021-10-02 21:46:58 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-10-02 21:46:58 +0200 |
| commit | 2bf8110032e84796f21d4d44d72e33abc58a4e1e (patch) | |
| tree | 76caf68af368b2c13f482f2452e740b9d5d029ae /sql | |
| parent | 696be301d304e92245c1d332c28ae61b0390e330 (diff) | |
Core/Players: Do not show zone on character list before first login
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 3 | ||||
| -rw-r--r-- | sql/updates/characters/master/2021_10_02_01_characters.sql | 1 |
2 files changed, 3 insertions, 1 deletions
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; |