Return signed item's name

[Luciar]

I am aware I can check if an item is signed by using getequipcardid, but I am having trouble thinking of a way to retrieve the name of the signer. Is there any current method to do this?

 

My intention is to write an NPC that can return a string saying "Your item was signed by "+.@signer$ or something similar.

 

Thanks

[Brian]

First, get the card3 and card4 values using getequipcardid or getinventorylist.

Then, combine them to get the char_id:

set .@signer_char_id, .@card3 | (.@card4 << 0x10);

Then, query the `char` table to get the name:

query_sql "SELECT `name` FROM `char` WHERE char_id="+.@signer_char_id, .@signer$;