Hi, first i would suggest when exporting the table to use json format, in that case if you're using vscode to view the file, vscode can format json file, the file will be much more easier to read and modify
I've successfully changed the 'The Moongrass' Enlightenment' (nahida's banner) into 'Leaves In The Wind' (Kazuha Banner)
Here's how I've done it:
Note: All interactions with MySQL DB are performed through MySQLWorkBench software on windows host machine
1. Export mysql's table 't_gacha_schedule_config' as json file format
- Optional: open that file in vscode and right-click → format document (alt+shift+F)
2. Change the fowllowing lines:
Code:
"gacha_type": 301, // more info
"gacha_pool_id": 201 // ID value are from GachaPoolData.txt
// using Banners.tsj should be straight forward as to determine what's the parent item and the child item_list
"gacha_up_config": "{"gacha_up_list":[{"item_parent_type":1,"prob":500,"item_list":[1047]},{"item_parent_type":2,"prob":500,"item_list":[1027,1059,1050]}]}",
// Both fields below should match the type id i.e(A***)
"gacha_prefab_path": "GachaShowPanel_A086",
"gacha_preview_prefab_path": "UI_Tab_GachaShowPanel_A086",
"enabled": 1,
// can be determine from Banners.tsj
"title_textmap": "UI_GACHA_SHOW_PANEL_A045_TITLE",
Note: in Banners.tsj you can get the banner's info by looking up which version that banner is released under, with the help of online sites that has a list of banners with their corresponding images and release date such as
this
- for example in our case that banner is listed on the site under update `2.8`
- then you can determine which half it has been released under either a or b
- looking inside 'Banners.tsj' you can see the parent character id [1047] and it's chiled characters IDs [1027,1059,1050]
- 'UI_GACHA_SHOW_PANEL_A045_TITLE' can be determined from 'Banners.tsj' (linked above)
Import that file into the database
Importatnt:
check the option 'Truncate table' before importing in case you've formatted that `json` file, else your changes won't take effect, it will import successfully, but that data won't change
After successfully importing the file, you can verify by Right-click that table → select rows, and ensure that changes has been made
Here's my edited table in json file format working perfectly
