BlackYet

To solve that do this: in Fleet.php in Fleet folder inside modules folder add at line 36: GROUP BY a.registration ORDER BY a.name

Just in case you are on a MAC the best solution is MAMP, free, fast and easy to use.

OK, in case of other contribution I will follow your advise, many thanks and sorry for the mess!! In case you want the displayed name as ABC1234 FirstName Surname you have just to change the "$name" variable...

Hi, I'm new as writer in the forum but I'm an old-reader. I'm working with phpVMS to move my VA website from Joomla to phpVMS only, even if I was already full automated with FS Acars; but you know it is not the best around. So I discovered this fantastic add on but I was not happy at all with the user and displayed name that is imported in SMF and I decided to make this small change: the user name is now equal to "ABC1234" only while the displayed name is "FirstName Surname". Just in case you want the same the new code for the file SMFRegisterData.class.php is: class SMFRegisterData extends CodonData { public function forum_register($eventinfo) { $id = PilotData::getPilotByEmail($eventinfo[2]); $pid = PilotData::getPilotCode($eventinfo[2] , $id->pilotid); $username = $pid; $name = $eventinfo[2][firstname].' '.$eventinfo[2][lastname]; $password = $eventinfo[2][password1]; $email = $eventinfo[2][email]; $register_vars = array( 'memberName' => "'$username'", 'realName' => "'$name'", 'emailAddress' => "'" . addslashes($email) . "'", 'passwd' => "'" . sha1(strtolower($username) . $password) . "'", 'passwordSalt' => "'" . substr(md5(mt_rand()), 0, 4) . "'", 'posts' => '0', 'dateRegistered' => (string) time(), 'is_activated' => '1', 'personalText' => "''", 'pm_email_notify' => '1', 'ID_THEME' => '4', 'ID_POST_GROUP' => '4', 'lngfile' => "''", 'buddy_list' => "''", 'pm_ignore_list' => "''", 'messageLabels' => "''", 'websiteTitle' => "''", 'websiteUrl' => "''", 'location' => "''", 'ICQ' => "''", 'AIM' => "''", 'YIM' => "''", 'MSN' => "''", 'timeFormat' => "''", 'signature' => "''", 'avatar' => "''", 'usertitle' => "''", 'memberIP' => "''", 'memberIP2' => "''", 'secretQuestion' => "''", 'secretAnswer' => "''", 'validation_code' => "''", 'additionalGroups' => "''", 'smileySet' => "''", ); $query = "INSERT INTO smf_members (" . implode(', ', array_keys($register_vars)) . ") VALUES (" . implode(', ', $register_vars) . ")"; instead of: class SMFRegisterData extends CodonData { public function forum_register($eventinfo) { $id = PilotData::getPilotByEmail($eventinfo[2][email]); $pid = PilotData::getPilotCode($eventinfo[2][code], $id->pilotid); $username = $eventinfo[2][firstname].' '.$eventinfo[2][lastname].' '.$pid; $password = $eventinfo[2][password1]; $email = $eventinfo[2][email]; $register_vars = array( 'memberName' => "'$username'", 'realName' => "'$username'", 'emailAddress' => "'" . addslashes($email) . "'", 'passwd' => "'" . sha1(strtolower($username) . $password) . "'", 'passwordSalt' => "'" . substr(md5(mt_rand()), 0, 4) . "'", 'posts' => '0', 'dateRegistered' => (string) time(), 'is_activated' => '1', 'personalText' => "''", 'pm_email_notify' => '1', 'ID_THEME' => '4', 'ID_POST_GROUP' => '4', 'lngfile' => "''", 'buddy_list' => "''", 'pm_ignore_list' => "''", 'messageLabels' => "''", 'websiteTitle' => "''", 'websiteUrl' => "''", 'location' => "''", 'ICQ' => "''", 'AIM' => "''", 'YIM' => "''", 'MSN' => "''", 'timeFormat' => "''", 'signature' => "''", 'avatar' => "''", 'usertitle' => "''", 'memberIP' => "''", 'memberIP2' => "''", 'secretQuestion' => "''", 'secretAnswer' => "''", 'validation_code' => "''", 'additionalGroups' => "''", 'smileySet' => "''", ); $query = "INSERT INTO smf_members (" . implode(', ', array_keys($register_vars)) . ") VALUES (" . implode(', ', $register_vars) . ")"; Regards!