search

MillhioreBT / forgottenserver-downgrade

TFS Downgrade 1.5+ is an engine based on nekiro downgrade but highly updated with current tfs code, it also has the lua modules divided and uses lua5.4
GNU General Public License v2.0
19 stars 18 forks source link

fix: missing tables and columns in shemas.sql file #20

Closed kokekanon closed 8 months ago

kokekanon commented 8 months ago

fix at login: 

[Error - mysql_real_query] Query: DELETE FROM `player_mounts` WHERE `player_id` = 1
Message: Table '860new.player_mounts' doesn't exist
[Error - mysql_store_result] Query: SELECT `id`, `name`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `currentmount`, `randomizemount`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `skulltime`, `skull`, `town_id`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `direction` FROM `players` WHERE `id` = 1
Message: Unknown column 'randomizemount' in 'field list'

Message: Unknown column 'currentmount' in 'field list'

MillhioreBT commented 8 months ago

hey sorry, I hadn't seen the PR, someone reported it on discord and I added it manually to the main branch, next time I'll review it first, don't refrain from proposing more good PR later <3