Lua CHARACTER DOES NOT SAVE

[Igor Milagres]

Hello friends, I'm facing the following problem, I've tried several solutions but all without success, can anyone help me? Thanks

I'm using the Sabrehaven 8.0 server as a base, but it's not saving the chars.

PLEASE HELP ME !


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

 

[Mateus Robeerto]

Hello friends, I'm facing the following problem, I've tried several solutions but all without success, can anyone help me? Thanks

I'm using the Sabrehaven 8.0 server as a base, but it's not saving the chars.

PLEASE HELP ME !


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

you should have change that line in the source and recompile be happy ^^, it happened on my tfs 1.2 8.0

in iologindata.cpp, change:
from: query << "sex = " << player->sex << ',';
to: query << "sex = " << static_cast<uint16_t>(player->sex) << ',';

 

[Igor Milagres]

you should have change that line in the source and recompile be happy ^^, it happened on my tfs 1.2 8.0

in iologindata.cpp, change:
from: query << "sex = " << player->sex << ',';
to: query << "sex = " << static_cast<uint16_t>(player->sex) << ',';

Good morning Mateus, so the problem is that I'm a beginner, I don't understand much about programming, I saw a tutorial on how to compile, I even downloaded the visual studio and such but I couldn't succeed when compiling, would that be the only way to solve this?

Would you have any tutorial or video to indicate me explaining from scratch the step by step of how to compile?

 

[Mateus Robeerto]

Bom dia Mateus, então o problema é que sou iniciante, não entendo muito de programação, vi um tutorial de como compilar, até baixei o visual studio e tal mas não consegui sucesso na hora de compilar, seria a única forma de resolver isso?

Você teria algum tutorial ou vídeo para me indicar explicando do zero o passo a passo de como compilar?

yes, call me in private!!

 

[Igor Milagres]

Hello friends, I'm trying to use the SABREHAVEN 8.0 base to start some tests, I already have a client and a website compatible with it and when I put the distro online, it runs smoothly without any error, but when I log off a char, the char doesn't save anything, it always comes back to start, and the following error appears in the distro:

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


After looking for possible solutions, what most told me was that the only way to solve this would be to go to the:


iologindata.cpp

find this line: query << " sex= " << player->sex << ',';

and change it to this line: query << " sex= " << static_cast<uint16_t>(player->sex) << ',';


They said that this would solve the problem, but for this to work I need to compile the server, but I'm a layman and I'm having a lot of difficulty with this, I've tried in different ways, I've seen several videos and tutorials but I still haven't been successful in solving this error, does anyone can you help me please??

Post automatically merged: Apr 11, 2023

sorted out !