MarcTowler / ItsLit-RPG-Tracker

Issue tracker for all parts of the ItsLit RPG
0 stars 0 forks source link

Merge Character and User tables #101

Closed MarcTowler closed 4 years ago

MarcTowler commented 4 years ago

saves a lot of mess and isnt needed to have both, also can help to resolve other issues

MarcTowler commented 4 years ago

DB query update users u inner joincharacterc on c.uid = u.uid set u.class = c.class, u.race = c.race, u.level = c.level, u.xp = c.xp, u.cur_hp = c.cur_hp, u.max_hp = c.max_hp, u.cur_ap = c.cur_ap, u.max_ap = c.max_ap, u.str = c.str, u.def = c.def, u.dex = c.dex, u.spd = c.spd, u.pouch = c.pouch, u.registered = c.registered, u.alpha_tester = c.alpha_tester, u.beta_tester = c.beta_tester, u.reroll_count = c.reroll_count;