ErikasKontenis / SabrehavenServer

15 stars 34 forks source link

CHARACTER NO SAVE #2

Open Morpheu12 opened 1 year ago

Morpheu12 commented 1 year ago

ADMIN has logged out. [Error - mysql_real_query] Query: UPDATE players SET level = 8,group_id = 3,vocation = 1,health = 185,healthmax = 185,experience = 4200,lookbody = 106,lookfeet = 95,lookhead = 78,looklegs = 58,looktype = 128,lookaddons = 0,maglevel = 100,mana = 40,manamax = Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '☺,lastlogin = 1681044343,lastip = 16777343,conditions = '',skulltime ...' at line 1 [Error - mysql_real_query] Query: UPDATE players SET level = 8,group_id = 3,vocation = 1,health = 185,healthmax = 185,experience = 4200,lookbody = 106,lookfeet = 95,lookhead = 78,looklegs = 58,looktype = 128,lookaddons = 0,maglevel = 100,mana = 40,manamax = Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '☺,lastlogin = 1681044343,lastip = 16777343,conditions = '',skulltime ...' at line 1 [Error - mysql_real_query] Query: UPDATE players SET level = 8,group_id = 3,vocation = 1,health = 185,healthmax = 185,experience = 4200,lookbody = 106,lookfeet = 95,lookhead = 78,looklegs = 58,looktype = 128,lookaddons = 0,maglevel = 100,mana = 40,manamax = Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '☺,lastlogin = 1681044343,lastip = 16777343,conditions = '',skulltime ...' at line 1 Error while saving player: ADMIN

Help me please ! thanks

Morpheu12 commented 1 year ago

sorted out

victorvadl commented 1 year ago

Im with the same problem, do u know how to solve? @ErikasKontenis @tarantonio @danilopucci

victorvadl commented 1 year ago

Fixed! in iologindata.cpp u have to change line 664 from query << "sex= " << player->sex << ','; to query << "sex= " << static_cast<uint16_t>(player->sex) << ',';