items db

[dcosper]

Still corrupts the database, i gotta be doing something wrong ;p

[Derision]

Originally Posted by dcosper

Still corrupts the database, i gotta be doing something wrong ;p

You should post the SQL query you are using that corrupts the database. I tried doing what you described a few days ago and it worked fine for me.

[dcosper]

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

[Derision]

I ran that query while my server was running. As expected item was not available in game until the server was restarted (items are loaded into shared memory once when the server first starts). After server restart, all looked OK.

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

How does C# figure into this issue ?

[dcosper]

well if you ran the query fine and had all your items on restart, the c# datetimes are not the issue, when i run that query on my database, i can no longer access any items in the game lol, wierd