Char Name in Picklog db

[Chocolate31]

Dont know if this is the right section, move to right forum please. 

I need some help with the picklog db to make easier to locate a user.
Picklog db only show the char id so its uncomfortable.
 

How to make a functional extra table in the picklog db to view the char name?

Thanks.

 

[Dastgir]

Simple Query can make it do so:

SELECT id,time,picklog.char_id,type,nameid,amount,refine,card0,card1,card2,card3,unique_id,map,char.name FROM picklog LEFT JOIN `char` ON char.char_id = picklog.char_id;

I feel its extra overhead to have char_name to be saved, so this query would save you

 

[Chocolate31]

Excellent!
Tested and working
Thank you very much.