edow

@carike Thanks, some of them looks promising.

Hi bcworkz! The easy questions I try to manage myself 😉 It seems that you’re the only one responding to my complex questions. Thank you for that!

I hear it’s not that simple as it seems. Right now there’re about 300 posts, but within a couple of years that should be thousands. For now I can change the lat/lon to two seperate custom fields if necessary, but I understand there’re more problems.

A 20 km square is also fine. It doesn’t have to be that precise, but it would be fine if the exact distance is shown. For example:

Nearby accommodations:

• Hotel ABC 2,1 km
• Hotel Stay2Day 8,6 km
• B&B 1234 9,5 km
• Motel OK 11,9 km
• Hotel Go 19,1 km

And then a similar list for restaurants/activities.

So, it don’t have to be very precise, but the precise distance have to be shown (maybe not after the comma). In the future ther’re hopefully a lot of posts (probably high in the thousands), so I’m looking for a solid function which is not asking to much from the server.

Maybe I also should mention that I want this function in the sidebar. I noticed that the sidebar sometimes works different than the actual post.

What do you mean with What is the maximum latitude range of all of your records? If I think I know what you mean it is than the answer is that the lat/lon can be all over the world. Right now only in Europe, but later I hope/think it will be outside Europe also.

Hopefully it’s doable. I understand it’s not easy. Where should I start? Hopefully you can show me the right way so I can try to achieve this.

Hi, thank you for your reply.

Yes, I was thinking about doing it for the entire website. In my theme I have hard coded URLs and some WordPress permalink PHP codes for example, so I have both I guess. But I’m not sure about the WordPress core and the plugins. If it’s not recommended then I don’t need it for the login page, but otherwise I do.

When I change this:
query_posts('category_name='.$yourcat->slug);

to this:
query_posts('category_name='.$yourcat->slug.'&paged='.$paged.'');

and I go to page 2 then it shows the tags from the post from page 2 (which it didn’t before) so that is a beginning.

But then it leaves me with the following problems:

1. It still doesn’t show all the tags from the whole category, but only from the current page
2. When I’m on page 2 and click on a results it redirects to page 1 (that’s what I want), but then it doesn’t show the tag in the sidebar, because it’s not page 2 anymore

This is working for the loops now:

<?php
			$popular_restaurants = new WP_Query( array(
				'post_type'             => 'restaurant',
				'posts_per_page'        => 5,
				'category_name'         => 'restaurants',
				'ignore_sticky_posts'   => true,
				'orderby'               => 'comment_count',
				'order'                 => 'DESC',
				'date_query' => array(
					array(
						'after' => '0',
					),
				),
			) );
		?>
		<?php if ( $popular_restaurants->have_posts() ) : ?>
		<?php while ( $popular_restaurants->have_posts() ): $popular_restaurants->the_post(); ?>
			<li><a href="<?php the_permalink() ?>"><?php the_title(); ?></a> (<?php comments_number( 'Nu stemmen!', '1', '%' ); ?>)</li>
		<?php endwhile; ?>
		<?php wp_reset_postdata(); ?>

		<?php else:  ?>

		<p><?php _e( 'Sorry, er gaat even iets fout. We hebben niets kunnen vinden.' ); ?></p>

		<?php endif; ?>

Now I only have the question about how to deal with the most voted posts instead of showing the most commented posts.

I feel guilty to ask something again in this topic, but it seems to me this is the best place to ask it.

As seen above I use this code to show the post score:

<?php
$counts = aigoo_get_score();
			extract( $counts );  //restores compacted variables

<span>+'.$score.'</span>
?>

The following code is showing the latest 5 posts with the most comments in a specific category on my homepage:

<?php
			$popular = new WP_Query( array(
				'post_type'             => array( 'post' ),
				'showposts'             => 5,
				'cat'                   => 'activiteit',
				'ignore_sticky_posts'   => true,
				'orderby'               => 'comment_count',
				'order'                 => 'dsc',
				'date_query' => array(
					array(
						'after' => '0',
					),
				),
			) );
		?>
		<?php while ( $popular->have_posts() ): $popular->the_post(); ?>
			<li><a href="<?php the_permalink() ?>"><?php the_title(); ?></a> (<?php comments_number( 'Nu stemmen!', '1', '%' ); ?>)</li>
		<?php endwhile; ?>

How can I make it happen that instead of showing the posts with the most comments it shows the posts with the highest voted comments on my homepage?

I don’t know if it’s even possible.

To be complete, this is in my functions.php:

<?php
/* Display likes/unlikes */
function aigoo_get_score() {
   $comments = get_comments( array('post_id' => get_the_ID(),) );
			$likes = array();
			$unlikes = array();
			foreach( $comments as $comment ) {
				if('unlike' == $comment->comment_content ) $unlikes[] = $comment;
					else $likes[] = $comment;
			}
    $likescore = count( $likes );
	$unlikescore = count( $unlikes );
	$score = count($likes) - count($unlikes);
	$totalvotes = count($likes) + count($unlikes);
	return compact('likes', 'unlikes', 'likescore', 'unlikescore', 'score', 'totalvotes');
}
?>

Thanks a lot! To thank you for all your help I can mention your name and website on the new website if you like. I’m on holiday tomorrow, so if you would like that I hear it when I’m back.