Show message count in page title

Hi nblauw

The sum of guestbook entries is saved in $num_rows1, I saw you already implement it on Bartbroersen.nl 🙂

Greetings,
Dani

Hi nblauw

1.) create a new function in function.php:

function countGuestbookEntries($guestbook) {
global $wpdb;
$table_name = $wpdb->prefix . "dmsguestbook";

$query = $wpdb->get_results("SELECT id FROM $table_name WHERE flag != '1' && guestbook = '" . sprintf("%d", $guestbook) . "' && spam = '0' ");
return $wpdb->num_rows;
}

2.) insert following code in your theme, where you want to display the guestbook count:
echo countGuestbookEntries(0);

“0” = your first guestbook
“1” = your second guestbook if you have more than one
…

3.) Shows sum of entries only on guestbook page:

if($post->ID == 48) {
echo countGuestbookEntries(0);
}

“48” is your post ID (You will see that on “DMSGuestbook -> Guestbook settings -> Basic”

Greetings,
Dani

function.php

function title_guestbook_count( $title, $post_id ) {
	global $wpdb;
	$table_name = $wpdb->prefix . "dmsguestbook";
	$query = $wpdb->get_results("SELECT id FROM $table_name WHERE flag != '1' && guestbook = '" . sprintf("%d", 0) . "' && spam = '0' ");

	$guestbook = do_shortcode( $wpdb->num_rows );

	if ( preg_match( '/\[\s*post_count\s*\]/', $title ) ) {
		$title = preg_replace( '/\[\s*post_count\s*\]/', $guestbook, $title );
	}
	return $title;
}

Theme:
add_filter( 'the_title', 'title_guestbook_count', 10, 48 );

Greetings,
Dani

You’re welcome…

Hi Nick

Insert this piece of code between the <title> tags of your theme instead wp_title():
echo preg_replace('/\[\s*post_count\s*\]/', wp_title_guestbook_count(), wp_title('|', false, 'right'));

function.php:

function wp_title_guestbook_count() {
	global $wpdb;
	$table_name = $wpdb->prefix . "dmsguestbook";
	$query = $wpdb->get_results("SELECT id FROM $table_name WHERE flag != '1' && guestbook = '" . sprintf("%d", 0) . "' && spam = '0' ");

	$entries = $wpdb->num_rows;
	return $entries;
}

More infos about wp_title

Greetings,
Dani