TFS 1.X+ Erorr xamp sql

[abdala ragab]

Anasd has logged out.
[Error - mysql_real_query] Query: UPDATE players SET level = 8,group_id = 1,vocation = 2,health = 190,healthmax = 190,experience = 4500,lookbody = 0,lookfeet = 0,lookhead = 0,looklegs = 0,looktype = 128,lookaddons = 0,maglevel = 0,mana = 40,manamax = 40,man
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 = 1651442973,lastip = 889385517,conditions = '',lastlogout...' at line 1
[Error - mysql_real_query] Query: UPDATE players SET level = 8,group_id = 1,vocation = 2,health = 190,healthmax = 190,experience = 4500,lookbody = 0,lookfeet = 0,lookhead = 0,looklegs = 0,looktype = 128,lookaddons = 0,maglevel = 0,mana = 40,manamax = 40,man
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 = 1651442973,lastip = 889385517,conditions = '',lastlogout...' at line 1
[Error - mysql_real_query] Query: UPDATE players SET level = 8,group_id = 1,vocation = 2,health = 190,healthmax = 190,experience = 4500,lookbody = 0,lookfeet = 0,lookhead = 0,looklegs = 0,looktype = 128,lookaddons = 0,maglevel = 0,mana = 40,manamax = 40,man
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 = 1651442973,lastip = 889385517,conditions = '',lastlogout...' at line 1
Error while saving player: Anasd
Anasd has logged in.

I succeeded in creating compile and then I faced this problem although sql works fine on my old engine why doesn't it work on modern engine @Boy67

 

[Addams]

Change this and then recompile.

Characters being reset after logging out.

I've compiled and got the current OTservBR running from this thread: https://otland.net/threads/new-ot-project-otservbr-global-10x-outdated-with-sprites-12-15.264701/ It works wonderfully, however all characters are being reset to new character stats and outfits if they log out. The error I'm...

otland.net

 

[abdala ragab]

Change this and then recompile.

Characters being reset after logging out.

I've compiled and got the current OTservBR running from this thread: https://otland.net/threads/new-ot-project-otservbr-global-10x-outdated-with-sprites-12-15.264701/ It works wonderfully, however all characters are being reset to new character stats and outfits if they log out. The error I'm...

otland.net

Wonderful, thank you