• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Database items trensfer

desalib

New Member
Joined
Jul 4, 2010
Messages
30
Reaction score
0
Hello everyone !

Here's my issue :

I want to move item from player_items to depot_items and if possible to a custom made table temp_items using dbquerry in lua script.


I know that player>depot is easily done with lua functions but the goal would be to move it to a custom made table that use the same model as player/depot_items
the custom table is temp_items. It should keep the player_id as in the 2 others and the attributes also. I must be able to send it back to player/depot_items later and the item must remain identical. So in fact I need a little help to send a player/depot_items line to temp_items and back to player/depot_items.

I could probably do it easily using a single dbquery but I'm not sure if it will works correctly.
Will any id be duplicated or else and make bugg the items list?
Once in my custom table, how to get the uid of the item?
And is there a way to read/write the Blob data in attribute collumn?
 
Back
Top