title: phpBB 3: finding additional user field in the underlying database
body: <p>I use phpBB 3.0.7-PL1 (upgrading soon) with CentOS 5.5 and PostgreSQL 8.4.6 and have the following additional question shown to new users on their registration to prevent SPAM: </p>
  
  <pre><code>What is your gender please? Answers: Robot/Man/Woman
  </code></pre>
  
  <p>I have found the corresponding entries in the database:</p>
  
  <pre><code>pref=&gt; select * from phpbb_profile_lang;
   field_id | lang_id | lang_name |        lang_explain         | lang_default_value
  ----------+---------+-----------+-----------------------------+--------------------
          5 |       2 | Sex       | Please specify your gender  |
  (1 row)
  
  pref=&gt; select * from phpbb_profile_fields_lang;
   field_id | lang_id | option_id | field_type | lang_value
  ----------+---------+-----------+------------+------------
          5 |       2 |         0 |          5 | Robot
          5 |       2 |         1 |          5 | Man
          5 |       2 |         2 |          5 | Woman
  (3 rows)
  </code></pre>
  
  <p>My problem is: I would like to find out now, which user is <strong>Man</strong> and which user is <strong>Woman</strong> (I need it for the game integrated in my forum in Russian language, so that I can refer to the players correctly). </p>
  
  <p>But I can't find, where these values are stored, in which "phpbb_xxxx" table and field. Does anybody please know?</p>
  
  <p>Thank you!
  Alex</p>