[Scott MacVicar]

Originally Posted by 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.

Its probably the intval thats doing it.

Personally I'd add another column like EmployeeID and reference it where appropriate rather than attempt to modify the userid since there are intvals done everywhere to sanatize the data.