Rank all Users in a gaming theme using ACF

  • Hi there !

    I’m developing a gaming theme based on ACF.
    I’m incrementing the score for every user (basic WP subscribers) through ACF fields.
    I’d like to get the ranking of a given user, without scrolling all users.
    Any idea ?

    Thanks !

Viewing 1 replies (of 1 total)
  • Thread Starter yasol

    (@yasol)

    If anyone needs it, I didn’t find anything built in so I went for a good old MySql query to get all different scores, and then looked for the index of the current user’s score in the result, looks the most efficient to me.
    Here is the query :

    $prepared_query = $wpdb->prepare( “SELECT meta_value FROM wp_usermeta WHERE meta_key LIKE ‘global_score’ ORDER BY meta_key ASC” );

    $results = $wpdb->get_results( $prepared_query );

Viewing 1 replies (of 1 total)
  • The topic ‘Rank all Users in a gaming theme using ACF’ is closed to new replies.