SQL ERROR SKILL ATRIBUT

[Josefelipeleite]

PEOPLE THOUSANDS EXCUSES FOR DIFFICULTING YOUR TIME, BUT I GOT A SCRIPT FROM TFS 1.1 SET ENCHANTS BUT WHEN I CHANCE THE STONES IN MY SET AND DO LOGOUT, LOGO APPEARS THIS MISTAKE ''ERROR IN SQLI'' AND ALSO, THE PLAYER LOSE ALL INVENTORY ITEMS (THOSE I WAS CHARMED).

The enchants are : melee 15 % 3 slots / ml 15% 3 slot / distance 15% 3 slots / shielding 15% em 3 slots

obs. 3 slots in each item

SOMEONE COULD HELP ME, PLEASE.

Look the distro:

[Error - mysql_real_query] Query: INSERT INTO player_items (player_id, pid
, sid, itemtype, count, attributes) VALUES (14,1,101,32415,1,'&\0[melee.
+15%] [melee.+15%] [melee.+15%]'),(14,2,102,24717,1,'&\0[melee.+15%] [melee.+15%
] [melee.+15%]'),(14,3,103,1988,1,''),(14,4,104,
Message: Out of range value for column 'itemtype' at row 11
[Error - mysql_real_query] Query: INSERT INTO player_items (player_id, pid
, sid, itemtype, count, attributes) VALUES (14,1,101,32415,1,'&\0[melee.
+15%] [melee.+15%] [melee.+15%]'),(14,2,102,24717,1,'&\0[melee.+15%] [melee.+15%
] [melee.+15%]'),(14,3,103,1988,1,''),(14,4,104,
Message: Out of range value for column 'itemtype' at row 11
[Error - mysql_real_query] Query: INSERT INTO player_items (player_id, pid
, sid, itemtype, count, attributes) VALUES (14,1,101,32415,1,'&\0[melee.
+15%] [melee.+15%] [melee.+15%]'),(14,2,102,24717,1,'&\0[melee.+15%] [melee.+15%
] [melee.+15%]'),(14,3,103,1988,1,''),(14,4,104,
Message: Out of range value for column 'itemtype' at row 11
Error while saving player: Dsdvw

 

[esigma94]

Message: Out of range value for column 'itemtype' at row 11
itemtype = 24717
Value 24717 is too big for field of itemtype in database.
Check in mysql what is the type of itemtype column in player_items table and change its type to make it able to keep bigger values (INT or even SMALLINT for example).

smallint is also default type for current sql schema of TFS:

forgottenserver/schema.sql at master · otland/forgottenserver

A free and open-source MMORPG server emulator written in C++ - otland/forgottenserver

github.com

Execute following sql query in your database console:
ALTER TABLE player_items MODIFY itemtype SMALLINT NOT NULL DEFAULT '0'