Map-A-Droid / MAD

Map PoGo stuff with Android devices
212 stars 132 forks source link

quest_item_amount, quest_target TINYINT -> SMALLINT. #1389

Open JabLuszko opened 1 month ago

JabLuszko commented 1 month ago

Need proper fixing of quest_item_amount (SMALLINT, unsigned?) field type so it can store bigger numbers. Fix saving experience quest to stardust rather than item_amount. Fix questGen for that aka semi-reverse https://github.com/Map-A-Droid/MAD/pull/1388

Combine this with update for quest_target to SMALLINT as Dynamax/Stations introduced quests Like "Collect 400 Max Particles" and 400 is above the TINYINT

ALTER TABLEtrs_questMODIFYquest_targetSMALLINT;

Failed submitting quests to DB: (pymysql.err.DataError) (1264, "Out of range value for column 'quest_target' at row 1")
[SQL: INSERT INTO trs_quest (GUID, layer, quest_type, quest_timestamp, quest_stardust, quest_pokemon_id, quest_reward_type, quest_item_id, quest_item_amount, quest_target, quest_condition, quest_reward, quest_template, quest_task, quest_pokemon_form_id, quest_pokemon_costume_id, quest_title) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: ('71ce04d9262a4e568315aaaeb3c52653.16', 1, 82, 1725994963, 0, 819, 7, 0, 0, 400, '[]', '[{"type": "POKEMON_ENCOUNTER", "pokemonEncounter": {"pokemonId": "SKWOVET"}}]', 'GO_BIG_MP_HARD', 'Unknown quest type placeholder: 82', 0, 0, 'collect_max_particles')]