gm

11/22/2011 15:16 tracker62#1
Hello I am looking for how (gm) can put the player in the warehouse
:handsdown:
11/22/2011 15:54 [Dev]Ansem#2
you want to put a player in a warehous?
you cant put a player in a "warehouse".
11/22/2011 19:55 tracker62#3
not its meter of the object in the warehouse of player
11/22/2011 20:01 [Dev]Ansem#4
You are a GameMaster and want to put items in players warehouse?


(hard to understand you :P)
11/22/2011 20:16 tracker62#5
Yes as for delight or the commands(orders) of the player
11/22/2011 23:26 castor4878#6
<out of topic>

Tracker, mettre (ie déposer, insérer, etc) prend 2 T.

cela n'a l'air de rien 1 ou 2 T, mais pour Google translate cela donne "its meter" ("son mêtre") ou to put, to insert, to place, etc, et cela change tout aux réponses qui pourront être données ici.

</out of topic>

items present in an account (not toon) warehouse are listed by the PS_GameData.dbo.UserStoredItems table.
so inserting an item in a warehouse would be as simple as inserting a record in that table.

the first issue is to find a free slot (to not erase an existing item); the slot to be used (ie the value for the "Slot" column) is a value ranging 0 (first slot of first page) to 239 (last slot of 6th page) (each page has 40 slots - 8 cols, 5 rows).

the second issue is to compute an unique identifier for the item to insert - unless you are moving an existing item with an already assigned "ItemUID" value - you have to create that value (the /getitem command generates this UID, but here the generation is only made by the SQL Insert statement, so some fields must be computed by yourself - this is an old thread regarding that generation (starting by a question from LPH) search for it. and of course check existing items to get examples of full valid records (all columns but Craftname are required).

EDIT: THANKS John !!! when you don't insult me in private mails, don't purposelessly delete my posts, you give those loving yellow toys, I DO LOVE YOU TOO.
11/23/2011 13:32 tracker62#7
merci pour la reponse justement j'utilise google translator il traduit mal


thank you for the correct answer I use google translator it translates poorly