Username in FC does not reflect username in WP

Drive Zone by default the FC display name is users FirstName+LastName - there's a function that runs after every time the user updates their profile that reapplies this formula to the display name (for cases where you update either your first or last name).

If you want a custom display name you need to hook in and change that profile save function, or overwrite it. My current solution takes a new pattern, applies it to every user in bulk, then adds a rewrite to the user-save-profile function to apply my formula to the display name. Works mostly and the only issue so far is a quick flash of the original display name for the user when they save their profile.

Tawsif Ahmed Riyad Any idea what to change in this snippet to link on correct user URL? After username change it keep linking on old username.

/**

• MEC seznam účastníků – avatar z Fluent Community (fallback na Gravatar)
  */
  add_action('mec_single_after_content', function($event) {

  if (!class_exists('MEC_main')) return;

  $MEC = MEC::getInstance('app.libraries.main');
  $book = $MEC->getBook();

  $date = $event->date;
  $timestamp = isset($date['start']['timestamp']) ? $date['start']['timestamp'] : current_time('timestamp');

  // Získání všech rezervací pro daný event
  $bookings = $MEC->get_bookings($event->data->ID, $timestamp, 100);

  if (!$bookings || empty($bookings)) {
  echo '

  ℹ️ Žádní členové zatím nepotvrdili účast na této události. Buď první!

  ';
  return;
  }

  echo '';
  echo '

  Účastníci

  ';
  echo '
  ';

  foreach ($bookings as $booking) {
  $author_id = $booking->post_author;
  $user = get_userdata($author_id);

   $name = $user ? $user->display_name : __('Neznámý uživatel', 'mec');
   $total_attendees = $book->get_total_attendees($booking->ID);
   $profile_url = $user ? site_url('/portal/u/' . $user->user_nicename) : '#';
  
   // Fluent avatar fallback
   $avatar_url = drivezone_get_fluent_avatar($author_id);
   if (!$avatar_url) {
       $avatar_url = get_avatar_url($author_id, ['size' => 64]);
   }
  
   echo '<li class="mec-attendee-item" data-user-id="' . esc_attr($author_id) . '">';
   echo '<div class="mec-attendee-avatar">';
   echo '<a href="' . esc_url($profile_url) . '" class="mec-attendee-link">';
   echo '<img src="' . esc_url($avatar_url) . '" alt="' . esc_attr($name) . '" width="64" height="64" class="mec-avatar-img" style="border-radius:50%;object-fit:cover;">';
   echo '</a>';
   echo '</div>';
   echo '<div class="mec-attendee-info">';
   echo '<a href="' . esc_url($profile_url) . '" class="mec-attendee-name"><strong>' . esc_html($name) . '</strong></a><br>';
   echo '<span class="mec-attendee-count">' . sprintf(_n('%s lístek', '%s lístků', $total_attendees, 'mec'), $total_attendees) . '</span>';
   echo '</div>';
   echo '</li>';

  }

  echo '

  ';
  });

Drive Zone, for $profile_url you are using $user->user_nicename, which is not the username of a user. Try this out and let me know.

global $wpdb;  // add this before the foreach loop
foreach ($bookings as $booking) {
    $author_id = $booking->post_author;
    $user = get_userdata($author_id);

    // Get username from wp_fcom_xprofile
    $fluent_community_username = $wpdb->get_var(
        $wpdb->prepare(
            "SELECT username FROM {$wpdb->prefix}fcom_xprofile WHERE user_id = %d LIMIT 1",
            $author_id
        )
    );

// rest of the code

$profile_url = $fluent_community_username ? site_url('/portal/u/' . $fluent_community_username) : '#';  // updated;; used $fluent_community_username for valid profile url

// rest of the code

You need to query it using the user_id of wp_fcom_xprofile table to retrieve the correct/current username of a user.

Tawsif Ahmed Riyad Works! Thank you!