Permanent New Additional Table in Picklog db.

[Yaoi]

Hi community!

I would like to know how to add a new permanent table in the picklog db showing the char names... Actually it only shows the char id.

someone helped me time ago to do it with a QUERY : 

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;

But i want to make it permanent, Thanks.

[Akkarin]

This would require adding to the rA source code.

If you want the name to show up instead of just the char ID, add a left join statement to the modules/logs/picklog.php file.

Or add an Issue to the fluxcp repo and ill make the changes and push later today.

[Yaoi]

@Akkarin 

the fluxcp im using shows up the char name but is easier and faster to me to use the phpmyadmin.

thanks for your help.

[Akkarin]

1 minute ago, Yaoi said:

@Akkarin 

the fluxcp im using shows up the char name but is easier and faster to me to use the phpmyadmin.

thanks for your help.

Then perhaps the picklog pages need to be revamped so it's easier to find the information you need.