[Solved] Where's the Field "Comment" (in Edit Agent) in Database?

[aMescAs]

Hi..

I've recently made use of the field "Comment", placed in the Agent data. Now i pretend to get it from the database, into a query, for report purposes. Seems that this field doesn'r appear in the "Users" table, or any other table.
I mean, it must be around there, but i don't have any ideia where.

1. Go to Admin > Agents


2. Edit Agent


3. Field Comment ! (first in the printscreen)



Anyone knows?

Cumps,

[eandrex]

look into user_preferences table

[aMescAs]

yeah, i have already serached there... except that the field is kinda ecrypted there!

So i did find the value, in "user_preferences", but with this line:

Code: Select all

CONVERT(`preferences_value` USING utf8)

Cumps!