th3rion

Example of code with working pagination with WP-Paginate plugin but you can use default WP controls or other plugin – just change last part.

<?php
global $wpdb;

$date = date("Y-m-d");

$querystr = "
SELECT *
FROM wp_posts
JOIN wp_ftcalendar_events ON wp_posts.ID = wp_ftcalendar_events.post_parent
WHERE wp_posts.post_status =  'publish'
AND wp_posts.post_type =  'post'
AND wp_ftcalendar_events.start_datetime >= '$date'
GROUP BY wp_posts.ID
ORDER BY wp_ftcalendar_events.start_datetime DESC
";

$total_record = count($wpdb->get_results($querystr, OBJECT_K));
$paged = get_query_var('paged') ? get_query_var('paged') : 1;
$post_per_page  = 10;
$offset = ($paged - 1)*$post_per_page;
$max_num_pages = ceil($total_record/ $post_per_page);

$wp_query->found_posts = $total_record;
$wp_query->max_num_pages = $max_num_pages;

$limit_query = " LIMIT ".$post_per_page." OFFSET ".$offset;  

$pageposts = $wpdb->get_results($querystr.$limit_query, OBJECT_K); ?>

<?php if ($pageposts): ?>

<?php global $post; ?>

<?php foreach ($pageposts as $post): ?>

<?php setup_postdata($post); ?>

<?php $start_date = date_i18n("d F Y", strtotime( $post->start_datetime )); ?>

<!-- do stuff -->

<?php echo $start_date; ?> <!-- example how to display event start date -->

<?php endforeach; ?>

<?php endif; ?>

<?php if(function_exists('wp_paginate')) { wp_paginate(); } ?>

Yes it worked – thank you very much 🙂

I searched for info if this is possible with their plugin but im not certain.

So its not a bug? But i cant make it work as i want… If theres no simple way to make it display proper week and day everythime I think ill just hide this whole Month – Week – Day line…

Problem was that todays date in todays events was 1 July and today is 19 July 🙂 I deleted plugin and reinstalled it and it helped – not sure why. So sorry for unnecessary topic…

Yes im aware but in my code theres no break lines. Heres screenshot:
http://th3rion.unixstorm.org/jarex/1.jpg

I think its a bug – putting code in one line doesnt help.