Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Files and SQL to switch banners easily for 3.2 and maybe 3.4

Newbie Spellweaver
Joined
Apr 26, 2023
Messages
7
Reaction score
17
This will let you add all banners from 1.0 to 3.2 (or 3.4) to the server then use a simple SQL query changing a few numbers to enable the ones you want. The banners are similar to the official ones, except older ones now contain the newer weapons/characters that have become standard in all banners so that they don't feel outdated/incomplete. For example, Tighnari was officially set to be in every character banner after 3.1, so he's been added to previous character banners too in the same way (except his own where he's the featured character).

I've only tested on 3.2, but I'm hoping it will work with 3.4.

Much credit goes to for making this much easier as it had all the banner images/text values and about 99% of the IDs needed.

Versions:
There's different versions so you can pick if you want normal 4 star banner boosts or if those should be ignored so that every 4 star thing has an equal chance. There's also versions to decide if Amber, Lisa, Kaeya, and Layla should only be in the Standard Wish (the official way) or if they should be put in all banners like other 4 star characters.

If you're new to Genshin Impact, this and explain featured boosts. In short, if you use a version with boosted 4 star characters, there's a very low chance you'll get non-boosted 4 star characters on character banners, and the same goes for non-boosted weapons on weapon banners. This gives you a chance to level up those featured characters/weapons easier, but at the cost of less variety until you switch banners.

If you use a version without boosted 4 star weapons, the name shown over the 4 star part of the banner could be something like "A046" but it still works normally.

Setup:
  1. Copy GachaProbData.txt to the server's \data\txt\ directory.
  2. Go through the folders to get to the version you want, like: \For 3.2\Has Character Boosts\Has Weapon Boosts\Amber, Lisa, Kaeya, Layla in all banners\
  3. Copy that version's GachaPoolData.txt to the server's \data\txt\ directory.
  4. Run that version's banner_setup.sql on the server's database.
In the SQL queries, you may have to replace all instances of db_hk4e_config_gio to db_hk4e_config depending on your server setup.

Setting banners:
Open and edit either banner_update.sql or banner_update_extras.sql and change the numbers on the top "SET" lines to the banners you want. The list below has the numbers. Run that whenever you want to update the banners. You can switch back and forth between using the 2 versions without causing a problem.

  • banner_update.sql is 2 character banners and a weapon banner how it normally is.
  • banner_update_extras.sql is 4 character and 2 weapon banners, but the 2nd weapon banner won't have the Epitomized Path. Name text may also be wrong sometimes, especially on the extra weapon banner. You can remove lines for any extra banner you don't want to use.
Here's an example of using to set the banners to Yelan (1034), whoever Kamisato Ayato is (1031), and Staff of the Scarlet Sands / Elegy for the End weapons (2033). Only the top 3 lines ever change:
BannerUpdateQuery - Files and SQL to switch banners easily for 3.2 and maybe 3.4 - RaGEZONE Forums


Banner list:
<MISSING> means the 3.2 client doesn't have those banner images anymore so there will be an error popup and blank image, but it can still be used. If you want to add an inaccurate image, in the SQL table you can copy another banner's gacha_prefab_path and gacha_preview_prefab_path to it. It may be possible to add files to the client to get some banner images back, but I haven't tried yet. If you want to try that, you could join GIO-docker-braindead's Discord (currently taken from ) then search for "hdiff banner" and all the results will be about that.

Code:
Character Banners:
1000: [1.0.1] Venti               (Xiangling, Fischl, Barbara)
1001: [1.0.2] Klee                (Xingqiu, Noelle, Sucrose)
1002: [1.1.1] Tartaglia           (Ningguang, Beidou, Diona)
1003: [1.1.2] Zhongli             (Xinyan, Chongyun, Razor)
1004: [1.2.1] Albedo              (Fischl, Sucrose, Bennett)
1005: [1.2.2] Ganyu               (Xiangling, Xingqiu, Noelle)
1006: [1.3.1] Xiao                (Diona, Beidou, Xinyan)
1007: [1.3.2] Keqing              (Ningguang, Bennett, Barbara)
1008: [1.3.3] Hu Tao              (Xingqiu, Chongyun, Xiangling)
1009: [1.4.1] Venti               (Sucrose, Razor, Noelle)
1010: [1.4.2] Tartaglia           (Barbara, Fischl, Rosaria)
1011: [1.5.1] Zhongli             (Yanfei, Noelle, Diona)
1012: [1.5.2] Eula                (Xinyan, Xingqiu, Beidou)
1013: [1.6.1] Klee                (Barbara, Sucrose, Fischl)
1014: [1.6.2] Kaedehara Kazuha    (Rosaria, Bennett, Razor)
1015: [2.0.1] Kamisato Ayaka      (Ningguang, Chongyun, Yanfei)
1016: [2.0.2] Yoimiya             (Sayu, Diona, Xinyan)
1017: [2.1.1] Raiden Shogun       (Kujou Sara, Xiangling, Sucrose)
1018: [2.1.2] Sangonomiya Kokomi  (Rosaria, Beidou, Xingqiu)
1019: [2.2.1] Tartaglia           (Ningguang, Chongyun, Yanfei)
1020: [2.2.2] Hu Tao              (Thoma, Diona, Sayu)
1021: [2.3.1] Albedo              (Bennett, Noelle, Rosaria)
1022: [2.3.1] Eula                (Bennett, Noelle, Rosaria)
1023: [2.3.2] Arataki Itto        (Gorou, Barbara, Xiangling)
1024: [2.4.1] Shenhe              (Yun Jin, Ningguang, Chongyun)
1025: [2.4.1] Xiao                (Yun Jin, Ningguang, Chongyun)
1026: [2.4.2] Zhongli             (Xingqiu, Beidou, Yanfei)
1027: [2.4.2] Ganyu               (Xingqiu, Beidou, Yanfei)
1028: [2.5.1] Yae Miko            (Fischl, Diona, Thoma)
1029: [2.5.2] Raiden Shogun       (Xinyan, Kujou Sara, Bennett)
1030: [2.5.2] Sangonomiya Kokomi  (Xinyan, Kujou Sara, Bennett)
1031: [2.6.1] Kamisato Ayato      (Xiangling, Sucrose, Yun Jin)
1032: [2.6.1] Venti               (Xiangling, Sucrose, Yun Jin)
1033: [2.6.2] Kamisato Ayaka      (Rosaria, Sayu, Razor)
1034: [2.7.1] Yelan               (Yanfei, Barbara, Noelle)
1035: [2.7.1] Xiao                (Yanfei, Barbara, Noelle)
1036: [2.7.2] Arataki Itto        (Chongyun, Gorou, Kuki Shinobu)
1037: [2.8.1] Kaedehara Kazuha    (Ningguang, Shikanoin Heizou, Thoma)
1038: [2.8.1] Klee                (Ningguang, Shikanoin Heizou, Thoma)
1039: [2.8.2] Yoimiya             (Yun Jin, Xinyan, Bennett)
1040: [3.0.1] Tighnari            (Collei, Diona, Fischl)
1041: [3.0.1] Zhongli             (Collei, Diona, Fischl)
1042: [3.0.2] Ganyu               (Xingqiu, Sucrose, Dori)
1043: [3.0.2] Sangonomiya Kokomi  (Xingqiu, Sucrose, Dori)
1044: [3.1.1] Cyno                (Kuki Shinobu, Sayu, Candace)
1045: [3.1.1] Venti               (Kuki Shinobu, Sayu, Candace)
1046: [3.1.2] <MISSING> Nilou     (Beidou, Barbara, Xiangling)
1047: [3.1.2] <MISSING> Albedo    (Beidou, Barbara, Xiangling)
1048: [3.2.1] Nahida              (Bennett, Razor, Noelle)
1049: [3.2.1] Yoimiya             (Bennett, Razor, Noelle)
1050: [3.2.2] <MISSING> Yae Miko  (Layla, Shikanoin Heizou, Thoma)
1051: [3.2.2] <MISSING> Tartaglia (Layla, Shikanoin Heizou, Thoma)
1052: [3.3.1] Wanderer            (Faruzan, Gorou, Yanfei)
1053: [3.3.1] Arataki Itto        (Faruzan, Gorou, Yanfei)
1054: [3.3.2] Raiden Shogun       (Rosaria, Sayu, Kujou Sara)
1055: [3.3.2] Kamisato Ayato      (Rosaria, Sayu, Kujou Sara)
1056: [3.4.1] Alhaitham           (Xinyan, Yun Jin, Yaoyao)
1057: [3.4.1] Xiao                (Xinyan, Yun Jin, Yaoyao)
1058: [3.4.2] Hu Tao              (Xingqiu, Ningguang, Beidou)
1059: [3.4.2] Yelan               (Xingqiu, Ningguang, Beidou)

Weapon Banners:
2000: [1.0.1] Amos' Bow / Aquila Favonia                              (Favonius Lance, The Flute, The Bell, The Stringless, The Widsith)
2001: [1.0.2] Lost Prayer to the Sacred Winds / Wolf's Gravestone     (Dragon's Bane, Sacrificial Sword, Sacrificial Greatsword, Sacrificial Fragments, Sacrificial Bow)
2002: [1.1.1] Skyward Harp / Memory of Dust                           (Rust, The Flute, Eye of Perception, Favonius Lance, Rainslasher)
2003: [1.2.1] Summit Shaper / Skyward Atlas                           (Favonius Greatsword, Favonius Lance, Lion's Roar, The Stringless, The Widsith)
2004: [1.2.2] Amos' Bow / Skyward Pride                               (Dragon's Bane, Eye of Perception, The Bell, Sacrificial Sword, Favonius Warbow)
2005: [1.3.1] Primordial Jade Cutter / Primordial Jade Winged-Spear   (Eye of Perception, Favonius Lance, The Flute, Rust, Sacrificial Greatsword)
2006: [1.3.3] Staff of Homa / Wolf's Gravestone                       (Lion's Roar, Lithic Blade, Lithic Spear, The Widsith, Sacrificial Bow)
2007: [1.4.1] Elegy for the End / Skyward Blade                       (Dragon's Bane, Favonius Greatsword, Favonius Warbow, The Alley Flash, Wine and Song)
2008: [1.4.2] Skyward Harp / Lost Prayer to the Sacred Winds          (Alley Hunter, Favonius Sword, Favonius Lance, Favonius Codex, Sacrificial Greatsword)
2009: [1.5.1] Summit Shaper / Memory of Dust                          (Lithic Blade, Lithic Spear, Sacrificial Bow, The Flute, Eye of Perception)
2010: [1.5.2] Song of Broken Pines / Aquila Favonia                   (Dragon's Bane, Sacrificial Fragments, Sacrificial Sword, Rust, Rainslasher)
2011: [1.6.1] Lost Prayer to the Sacred Winds / Skyward Pride         (Favonius Lance, Lion's Roar, Mitternachts Waltz, The Bell, The Widsith)
2012: [1.6.2] Freedom-Sworn / Skyward Atlas                           (Alley Hunter, Dragon's Bane, Favonius Greatsword, The Alley Flash, Wine and Song)
2013: [2.0.1] Mistsplitter Reforged / Skyward Spine                   (Favonius Codex, Favonius Sword, Favonius Lance, The Stringless, Sacrificial Greatsword)
2014: [2.0.2] Thundering Pulse / Skyward Blade                        (Dragon's Bane, Favonius Warbow, Rainslasher, Sacrificial Sword, Sacrificial Fragments)
2015: [2.1.1] Engulfing Lightning / The Unforged                      (The Bell, Lion's Roar, The Widsith, Sacrificial Bow, Favonius Lance)
2016: [2.1.2] Primordial Jade Cutter / Everlasting Moonglow           (Dragon's Bane, Favonius Codex, Favonius Greatsword, The Flute, The Stringless)
2017: [2.2.1] Memory of Dust / Polar Star                             (Favonius Lance, Eye of Perception, Rust, Favonius Sword, Akuoumaru)
2018: [2.2.2] Staff of Homa / Elegy for the End                       (Sacrificial Sword, Rainslasher, Wavebreaker's Fin, The Widsith, Mouun's Moon)
2019: [2.3.1] Freedom-Sworn / Song of Broken Pines                    (Lion's Roar, Sacrificial Greatsword, Dragon's Bane, Wine and Song, Alley Hunter)
2020: [2.3.2] Redhorn Stonethresher / Skyward Harp                    (The Alley Flash, The Bell, Favonius Lance, Sacrificial Fragments, Mitternachts Waltz)
2021: [2.4.1] Calamity Queller / Primordial Jade Winged-Spear         (The Flute, Favonius Greatsword, Lithic Spear, The Widsith, Favonius Warbow)
2022: [2.4.2] Vortex Vanquisher / Amos' Bow                           (Favonius Sword, Lithic Blade, Dragon's Bane, Favonius Codex, Sacrificial Bow)
2023: [2.5.1] Kagura's Verity / Primordial Jade Cutter                (Sacrificial Sword, Rainslasher, Wavebreaker's Fin, Eye of Perception, The Stringless)
2024: [2.5.2] Engulfing Lightning / Everlasting Moonglow              (Akuoumaru, Mouun's Moon, Lion's Roar, Favonius Lance, Sacrificial Fragments)
2025: [2.6.1] Haran Geppaku Futsu / Elegy for the End                 (Rust, The Flute, The Widsith, Dragon's Bane, Sacrificial Greatsword)
2026: [2.6.2] Mistsplitter Reforged / The Unforged                    (Favonius Sword, The Bell, Favonius Lance, Favonius Codex, Favonius Warbow)
2027: [2.7.1] Aqua Simulacra / Primordial Jade Winged-Spear           (Lithic Spear, Sacrificial Sword, Favonius Greatsword, Eye of Perception, Sacrificial Bow)
2028: [2.7.2] Redhorn Stonethresher / Memory of Dust                  (Lithic Blade, Lion's Roar, Dragon's Bane, Sacrificial Fragments, The Stringless)
2029: [2.8.1] Freedom-Sworn / Lost Prayer to the Sacred Winds         (The Alley Flash, Rainslasher, Favonius Lance, The Widsith, Mitternachts Waltz)
2030: [2.8.2] Thundering Pulse / Summit Shaper                        (Wine and Song, Alley Hunter, The Flute, Sacrificial Greatsword, Dragon's Bane)
2031: [3.0.1] Hunter's Path / Vortex Vanquisher                       (Favonius Sword, The Bell, Favonius Lance, Favonius Codex, The Stringless)
2032: [3.0.2] Amos' Bow / Everlasting Moonglow                        (Sacrificial Sword, Favonius Greatsword, Dragon's Bane, Eye of Perception, Rust)
2033: [3.1.1] Staff of the Scarlet Sands / Elegy for the End          (Lion's Roar, Makhaira Aquamarine, Favonius Lance, Sacrificial Fragments, Favonius Warbow)
2034: [3.1.2] <MISSING> Key of Khaj-Nisut / Primordial Jade Cutter    (Xiphos' Moonlight, Rainslasher, Dragon's Bane, Wandering Evenstar, Sacrificial Bow)
2035: [3.2.1] A Thousand Floating Dreams / Thundering Pulse           (The Flute, Sacrificial Greatsword, Favonius Lance, The Widsith, Rust)
2036: [3.2.2] <MISSING> Kagura's Verity / Polar Star                  (Favonius Sword, The Bell, Dragon's Bane, Favonius Codex, The Stringless)
2037: [3.3.1] Tulaytullah's Remembrance / Redhorn Stonethresher       (Sacrificial Sword, Favonius Greatsword, Wavebreaker's Fin, Eye of Perception, Favonius Warbow)
2038: [3.3.2] Engulfing Lightning / Haran Geppaku Futsu               (Akuoumaru, Mouun's Moon, Lion's Roar, Favonius Lance, Sacrificial Fragments)
2039: [3.4.1] Light of Foliar Incision / Primordial Jade Winged-Spear (Lithic Spear, The Flute, Rainslasher, The Widsith, Sacrificial Bow)
2040: [3.4.2] Staff of Homa / Aqua Simulacra                          (Lithic Blade, Favonius Sword, Dragon's Bane, Favonius Codex, Rust)

Extra Notes:
  • GachaProbData.txt is using the normal rates, but the file itself is slightly modified to remove 2 lines about 5 star characters in weapon banners and 5 star weapons in character banners (neither exist) or else it won't load. So if you want to change the rates, do it with this file or remove the same lines I did.
  • I started with the Solo Mod's way (which you should look at if you haven't because you may like it more) but wanted a way of building up character constellation levels closer to the real way. Whenever I feel done with a banner I let a random number generator pick the next unused person.
  • There's way too much for me to test thoroughly, so if you notice something wrong let me know if you want.
 

Attachments

You must be registered for see attachments list
Back
Top