Quote:
Originally Posted by darkhc
This problem with item drop is real. I have this same issue but not found the problem and not have time for repair this :(.
|
The system does use a ORM which will not let you save twice the same ID if you're creating something (will throw you a BIG exception), if you delete something on the database and try to save it on the server, it will throw a BIG exception in the console and when you drop something it just changes the item position to 254, which means it's on the floor, so if you save it by any mean it will be recorded in the floor and wont come back to your inventory.
Tho, you might do a check when initializating items that if the item is in the floor, you delete it. But even if it's on the floor and you enter the game, it will save the item back in your inventory, but the DB object is still the same, so it won't be saved twice.
You can debug when you DROP the item and when you PICK UP the item, if you see something wrong it might not be hard to fix. But as I said, this server has gone live with over 150 players online and never gave me this item issue.
Thus, you SHOULD NOT change any server record while the server is live. Tables that are updated when the server is live MUST be EXCLUSIVELY updated by the server, or you'll have items not saving, characters not saving properly and etc.
If you need to do anything outside of the game world, make it communicate on the network and the server itself make the processing.
I will download the 5103 source and check the processing.
----------------------
[Only registered and activated users can see links. Click Here To Register...]