Shortcode for Current User Position

No there isn’t, but it is relatively easy to code. So I’ll add it to the next version.

Ok very nice!:)

When can we expect the next version? Or is it hard to say how long it is gonna take?

A few weeks. I am not planning any big changes in this release. Just some filters and actions that make the plugin more extensible.

Hello,

Did you manage to create the current user position allready? I tried it myselve but no luck so far… Would be a great add-on:)

Thanks

Best regards

Yes, the shortcode is finished. But the release is not yet finished. If you can’t wait, you can download the latest development version here.

Very nice!

If I copy the shortcode form your class-football-pool-shortcodes.php en past it into mine… Is that enough or is there more coding in different files?

I cant update your plugin because I changed to much and not in a child theme… ??

My mistake… So I have to edit it myself

Thanks:)

No, just copying the shortcode is not enough.

Changes in classes\class-football-pool-shortcodes.php:
1. Add the line
add_shortcode( 'fp-user-ranking', array( 'Football_Pool_Shortcodes', 'shortcode_user_ranking' ) );

2. Add the shortcode function inside the class:

public function shortcode_user_ranking( $atts ) {
		extract( shortcode_atts( array(
					'user' => '',
					'ranking' => FOOTBALLPOOL_RANKING_DEFAULT,
					'date' => 'now',
					'text' => '',
				), $atts ) );

		$output = $text;

		if ( $user == '' || ! is_numeric( $user ) ) {
			$user = get_current_user_id();
		}

		if ( ( int ) $user > 0 ) {
			$pool = new Football_Pool_Pool;
			$rank = $pool->get_user_rank( $user, $ranking, self::date_helper( $date ) );
			if ( $rank != null ) $output = $rank;
		}

		return apply_filters( 'footballpool_shortcode_html_fp-user-ranking', $output );
	}

3. Add function get_user_rank() to the file classes\class-football-pool-pool.php:

public function get_user_rank( $user, $ranking_id = FOOTBALLPOOL_RANKING_DEFAULT, $score_date = '' ) {
		global $wpdb;
		$prefix = FOOTBALLPOOL_DB_PREFIX;

		$sql = $wpdb->prepare(
						sprintf( "SELECT ranking FROM {$prefix}scorehistory
								WHERE user_id = %%d AND ranking_id = %%d
								AND ( %s score_date <= %%s )
								ORDER BY score_date DESC LIMIT 1"
								, ( $score_date == '' ? '1 = 1 OR' : '' )
						) , $user, $ranking_id, $score_date );
		return $wpdb->get_var( $sql ); // return null if nothing found
	}