[DaNIEL MeNTED]

I've imported all the templates and SQL queries into the product...

I've added uninstall code that removes all the tables.

I have also added the following:

ON INSTALL - the ALIAS will be populated for all users with the following in mind:

• all usernames are converted to lowercase.
• all characters other than a-z, 0-9, and . (period) are stripped from their username.
• before an alias is added it is checked against all other aliases in the database, if the alias exists it adds a 1, 2, 3, n. to the end of the alias as required.

Please have a look at this code and tell me if it can be improved - like I said I'm not a coder.

PHP Code:

$allusers = $vbulletin->db->query("SELECT * FROM  " . TABLE_PREFIX . "user"); 

while($row = mysql_fetch_array( $allusers )) {
 $suffix=1;
 $username = $row['username'];
 $username = strtolower($username);
 $newalias = preg_replace('/\s/', '.', $username);
 $newalias = preg_replace('@[^a-z0-9.]@', '', $newalias);
 $dupecheck = $vbulletin->db->query("SELECT * FROM  " . TABLE_PREFIX . "user"); 
 while($dupe = mysql_fetch_array( $dupecheck)) {
  $existing = $dupe['vbms_alias'];
  $currentuser = $dupe['username'];
  if ($newalias == $existing) {
   if ($user != $currentuser && $suffix == 1) {
    $newalias = $newalias . $suffix++;
   } elseif ($user != $currentuser && $suffix > 1) {
   $newalias = rtrim($newalias, "1..9");
   $newalias = $newalias . $suffix++;
   } else {
    $newalias = $existing;
   }
  }
 }
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "user SET `vbms_alias` = '" . $newalias . "' WHERE " . TABLE_PREFIX . 
"user.username ='" . $username . "' LIMIT 1");
} 


I would rather remove this from the install and modify it into 2 plugins ... one that could be run from the admin CP (Populate Aliases! button) and one that runs as part of a new user registration (after the confirm their address).

Also, I'm not sure how to add the alias fields to the user view in the admin CP... anyone want to point me in that direction?

Oh .... I did change the product version to 2.53 because of the differences in the XML I made.

EDITED TO ASK:

Are there any other changes that need to be made to "mail enable" a user?