if ( $name ) {
   $query = "SELECT name"
   . "\n FROM #__users"
   . "\n WHERE id = $my->id"
   ;
   $database->setQuery( $query );
   $name = $database->loadResult();
} else {
   $name = $my->username;
}

// find this section of code:

$registration_enabled    = $mainframe->getCfg( 'allowUserRegistration' );
$message_login          = $params->def( 'login_message', 0 );
$message_logout       = $params->def( 'logout_message', 0 );
$pretext             = $params->get( 'pretext' );
$posttext             = $params->get( 'posttext' );
$login                = $params->def( 'login', $return );
$logout             = $params->def( 'logout', $return );
$name                = $params->def( 'name', 1 );
$greeting             = $params->def( 'greeting', 1 );

// insert the new (well actually old) code shown below in this area ----------------------
// this is the original code from 1.0.7 that was not included in the 1.0.8 patch and full packages

if ( $name ) {
   $query = "SELECT name"
   . "\n FROM #__users"
   . "\n WHERE id = $my->id"
   ;
   $database->setQuery( $query );
   $name = $database->loadResult();
} else {
   $name = $my->username;
}

// Back to original code -------------------------------------------------------

if ( $my->id ) {
// Logout output
// ie HTML when already logged in and trying to logout
   ?>

   if ( $name ) {
      $name = $my->username;
   }

   if ( $name ) {
      $query = "SELECT name"
      . "\n FROM #__users"
      . "\n WHERE id = $my->id"
      ;
      $database->setQuery( $query );
      $name = $database->loadResult();
   } else {
      $name = $my->username;
   }

// Original Packaged Joomla 1.0.7 eCommerce Edition VirtueMart 1.0.2 mod_login.php starting at line #21

$registration_enabled    = $mainframe->getCfg( 'allowUserRegistration' );
$message_login          = $params->def( 'login_message', 0 );
$message_logout       = $params->def( 'logout_message', 0 );
$pretext             = $params->get( 'pretext' );
$posttext             = $params->get( 'posttext' );
$login                = $params->def( 'login', $return );
$logout             = $params->def( 'logout', $return );
$name                = $params->def( 'name', 1 );
$greeting             = $params->def( 'greeting', 1 );

if ( $name ) {
   $query = "SELECT name"
   . "\n FROM #__users"
   . "\n WHERE id = $my->id"
   ;
   $database->setQuery( $query );
   $name = $database->loadResult();
} else {
   $name = $my->username;
}

if ( $my->id ) {
// Logout output
// ie HTML when already logged in and trying to logout
   ?>
   <form action="<?php echo sefRelToAbs( 'index.php?option=logout' ); ?>" method="post" name="login">
   <?php
   if ( $greeting ) {
      echo _HI;
      echo $name;
   }
   ?>
   <br />
   <div align="center">
      <input type="submit" name="Submit" class="button" value="<?php echo _BUTTON_LOGOUT; ?>" />
   </div>

// Original Packaged Joomla 1.0.8 (Update and Full) mod_login.php starting at line #36

$registration_enabled    = $mainframe->getCfg( 'allowUserRegistration' );
$message_login          = $params->def( 'login_message', 0 );
$message_logout       = $params->def( 'logout_message', 0 );
$pretext             = $params->get( 'pretext' );
$posttext             = $params->get( 'posttext' );
$login                = $params->def( 'login', $return );
$logout             = $params->def( 'logout', $return );
$name                = $params->def( 'name', 1 );
$greeting             = $params->def( 'greeting', 1 );

if ( $my->id ) {
// Logout output
// ie HTML when already logged in and trying to logout

// this is the section of code to be replaced, from here --------
   if ( $name ) {
      $name = $my->username;
   }
// ------- to here

   ?>
   <form action="<?php echo sefRelToAbs( 'index.php?option=logout' ); ?>" method="post" name="login">
   <?php
   if ( $greeting ) {
      echo _HI;
      echo $name;
   }
   ?>
   <br />
   <div align="center">
      <input type="submit" name="Submit" class="button" value="<?php echo _BUTTON_LOGOUT; ?>" />
   </div>

// Proposed fix for Joomla 1.0.8 mod_login.php starting at line #36

$registration_enabled    = $mainframe->getCfg( 'allowUserRegistration' );
$message_login          = $params->def( 'login_message', 0 );
$message_logout       = $params->def( 'logout_message', 0 );
$pretext             = $params->get( 'pretext' );
$posttext             = $params->get( 'posttext' );
$login                = $params->def( 'login', $return );
$logout             = $params->def( 'logout', $return );
$name                = $params->def( 'name', 1 );
$greeting             = $params->def( 'greeting', 1 );

if ( $my->id ) {
// Logout output
// ie HTML when already logged in and trying to logout

// this is the fixed code from here -------
   if ( $name ) {
      $query = "SELECT name"
      . "\n FROM #__users"
      . "\n WHERE id = $my->id"
      ;
      $database->setQuery( $query );
      $name = $database->loadResult();
   } else {
      $name = $my->username;
   }  // --------- to here

   ?>
   <form action="<?php echo sefRelToAbs( 'index.php?option=logout' ); ?>" method="post" name="login">
   <?php
   if ( $greeting ) {
      echo _HI;
      echo $name;
   }
   ?>
   <br />
   <div align="center">
      <input type="submit" name="Submit" class="button" value="<?php echo _BUTTON_LOGOUT; ?>" />
   </div>