search

opendarkeden / server

42 stars 32 forks source link

Storage items Problem #129

Open Supacek opened 1 year ago

Supacek commented 1 year ago

Items are saving under Storage 10 = GARBAGE During Exchanging items using Trade Character get DC cuz the range value for column 'EnchantLevel' at row 1 image

Supacek commented 1 year ago

i think it has somethink with the Trading items and geting DC 

Receive:CGTradeFinish(TargetObjectID:46317,CODE:0)
Send:400[5,184] GCTradeFinish(TargetObjectID:46340,CODE:0)
Send:400[5,185] GCTradeFinish(TargetObjectID:46340,CODE:3)
Send:400[5,246] GCTradeFinish(TargetObjectID:46317,CODE:3)
Stmt::EQ real Query Error
Stmt [UPDATE ShoesObject SET ObjectID=46322, ItemType=10, OwnerID='Crescendo', Storage=0, StorageID=0, X=1, Y=0, OptionType='183 6', Durability=3000, Grade=3, EnchantLevel=4294967218 WHERE ItemID=27340]
Out of range value for column 'EnchantLevel' at row 1
Send:400[5,186] GCTradeFinish(TargetObjectID:46340,CODE:1)
Send:434[15,149] GSGuildMemberLogOn (GuildID:13140Name:CrescendoLogOn:falseServerID:56151 )
Receive:SGGuildMemberLogOnOK(GuildID:13140Name:CrescendoLogOn:falseServerID:56151)
Supacek commented 1 year ago

i didnt fix this in my database Out of range value for column 'EnchantLevel' at row 1 but when this cause the DC to players after trade why the item jump into Storage 10 ?

Supacek commented 1 year ago

image

Supacek commented 1 year ago

also i see there is same shit happening for image