Recall a Destroyed Item to a Player?

04/23/2013 19:34 cypherxxl#1
Hello dear Epvpers.

Is it Possible to recall an Destroyed Item back to a player?
If yes: How can i do it?

/recallitem ItemUID didnt work, it says Dont exist.


Would be great, if any1 can help me out.
04/23/2013 19:56 andr3y_you96#2
you can check the logs but i dont remember the ActionType for breaking item >.<
04/23/2013 22:40 JohnHeatz#3
#Moved to the right section
04/24/2013 13:48 cypherxxl#4
hmm i dont know what u mean.

The Table: CharItems has all i need to know even - ItemUID
04/24/2013 14:09 andr3y_you96#5
Use This
Quote:
USE PS_GameLog
SELECT UserID, UserUID, CharID, CharName, ActionTime, ActionType, Text1, Text2, Text3, Text4
FROM ActionLog
WHERE (UserID = 'Account name here') AND (ActionType = '112') and Text1 = 'Lost Item Name'
ORDER BY ActionTime
it will give you in text2 something like this
Quote:
182,66,6,172,34,0 (Option:20200000000000000013)
182,66,6,172,34,0 are the lapis linked and Option:20200000000000000013 is the CraftName you can recreate it in db

Good luck :)

i always use this the command doesnt work for me
04/24/2013 15:36 cypherxxl#6
this is useless for me.

In CharItems i can see the ItemUID too.

But how can i get the item back to the player, if its lost cause its Destroyed while Linking?
04/24/2013 15:50 andr3y_you96#7
read better that action type is for item lost in linking
04/24/2013 18:42 cypherxxl#8
oh ^^

Thank you :)