I am looking for a way to extract via SQL the tags associated with a thread.
It looks like the tags of a thread are in the field tag of the table xf_thread.
The problem is that such field contains codes in an hexadecimal format.
How can I decode such hexadecimal value and how it is related to the tag_id of the table tags?
I thank everybody in advance.
It looks like the tags of a thread are in the field tag of the table xf_thread.
The problem is that such field contains codes in an hexadecimal format.
How can I decode such hexadecimal value and how it is related to the tag_id of the table tags?
I thank everybody in advance.