[TECK]

Hi guys,
I'm trying to mod VB3 in a different way, I don't want to generate automatically an userid... instead I want to give the choice to the user to select his(her) userid.
Why? Is really simple, I want to replace the userid with an alphanumeric serial of numbers (employee number).
So, if I work for a company, I will have my unique employee number as userid, for example A50021, my username and my password.

Now, what type will become the "userid" field?
Changing the actual php code should be really easy, to let the user enter his(her) id:

print_input_row('<b>User ID</b>', 'userid', '');
$DB_site->query("
  INSERT INTO " . TABLE_PREFIX . "user
    (userid, username, ...
  VALUES
    ('" . intval($_POST['userid']) . "', '" . addslashes($_POST['username']) . "', ...
 
$userid = intval($_POST['userid']);

I tried the code above and if I look in the USER table, it defaults still the userid 1, instead of the alphanumeric value.
Let me know what I should change in the table... Thanks guys.