INSERT INTO `items` VALUES ('811005','0','Cloth Mart', '0' ,'1' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'7' ,'1' ,'0' ,'1' ,'0' ,'1' ,'0' ,'1' ,'0' ,'1' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'' ,'0' ,'65535' ,'0' ,'0' ,'0' ,'0' ,'180' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'' ,'-1' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'665' ,'IT63' ,'0' ,'10' ,'0' ,'0' ,'0' ,'0' ,'Cloth Mart' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'1' ,'1' ,'0' ,'0' ,'0' ,'62335' ,'0' ,'0' ,'0' ,'0' ,'1' ,'0' ,'1' ,'-1' ,'0' ,'64' ,'-1' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'2' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'20130311142011' ,'' ,'0' ,'0' ,'0' ,'0' ,'1' ,'0' ,'0' ,'' ,'0' ,'-1' ,'0' ,'0' ,'0' ,'0' ,'-1' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'-1' ,'0' ,'0' ,'0' ,'0' ,'20130311142011' ,'00010101000000' ,'' ,'13THFLOOR' ,'0' ,'' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'-1' ,'0' ,'0' ,'00000000000000000000' ,'0' ,'' ,'-1' ,'0' ,'0' ,'0' ,'0' ,'' ,'-1' ,'0' ,'0' ,'0' ,'0' ,'0' ,'' ,'-1' ,'0' ,'0' ,'0' ,'0' ,'0' ,'' ,'-1' ,'0' ,'0' ,'0' ,'0' ,'0' ,'' ,'-1' ,'0' ,'0' ,'0' ,'' ,'' ,'' ,'' ,'' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'2003-10-15 08:00:26' ,'0' ,'70' ,'0' ,'0' ,'0' ,'-1' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'' ,'-1' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'-1' ,'0' ,'-256' ,'255' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0');
All i did was copy Cloth Shawl item 1005, change the id to 811005 and the name and lore name, i also have tried an id of 200, this entry goes into mysql fine, no errors, but when i log on i am unable to access any items in game, and all chars are nude.
Only other thing i can think to look at now, is i had to convert the datetimes into something c# wants to use, maybe its a datetime error
|