dimigra

too much complicated i suppose …

Hi,

I’d like to add a line where I select the categories of posts I want to diplay on calendar:

this is my code:

FROM $wpdb->posts WHERE MONTH(post_date) = $thismonth
  		AND YEAR(post_date) = $thisyear
  		AND post_status = 'publish' AND post_type='post'
		AND post_date <> '" . current_time('mysql') . '\'', ARRAY_N);

Thank you!

Hi everyboy!!

thank for your precious support, I can tell you that after a series of tests I see that the problem is in the loops,

I use a specific code to query my DB in order to show specific post in the future:

the following is the first one:

<?php query_posts('showposts=-1&order=ASC&cat=-14,-10'); ?>
<?php if ( have_posts() ) { while ( have_posts() ) : the_post(); ?>
<?php static $ctr = 0;
if ($ctr == "3") { break; }
else { ?>

<?php  $mylimit=60*60*24*7; //secondi * minuti * ore [* giorni]
 if ((get_the_time('U') <  (current_time(timestamp) - (get_settings('gmt_offset') * 3600) + $mylimit)) && (get_the_time('U') > current_time(timestamp)) ) {?>

the following is the second:

<?php query_posts('showposts=-1&offset=2&order=ASC&limit=5&cat=-14,-10') ; ?>
<?php if ( have_posts() ) { while ( have_posts() ) : the_post(); ?>

<?php static $ctr = 0;
if ($ctr == "7") { break; }
else { ?>

<?php  $mylimit=60*60*24*7; //secondi * minuti * ore [* giorni]
 if ((get_the_time('U') <  (current_time(timestamp) - (get_settings('gmt_offset') * 3600) + $mylimit)) && (get_the_time('U') > current_time(timestamp)+48*3600 ) ) {?>

I don’t know what you’re using to display future posts (and what it may react to)

I’m using “the future is now” plug-in to show future post.

I’ll try your suggestion.

Thanks

At the moment I’m using this solution:

<?php if ( have_posts() ) { while ( have_posts() ) : the_post(); ?>

<?php $mylimit=60*60*24; //secondi * minuti * ore [* giorni]
if ((get_the_time(‘U’) < (current_time(timestamp) – (get_settings(‘gmt_offset’) * 3600) + $mylimit)) && (get_the_time(‘U’) > current_time(timestamp)) ) {?>

Now I don’t know how to place a second loop that show “next 7 days events” ( posts )

Thank you for you kind support, i’ll try to be more clear.

– First Loop = show the next 24 hours events (posts)

If there are no events go to next 24 hours and so on…

– Second Loop = show next 7 days events (posts)

Thank you again for the attention.

Ciao!

I can even pay for a professional support.

Thanks

I forgot to say tha I’m using a 2.3 version of WP and I’veinstalled a plug-in to show future date posts.

Hi !

I have installed your last release of campaign monitor everything seems to work but the “Send Email” section, infact when i try to access the page i find an empty section. I use 2.1 wp version.

Thanks in advance for your help.

Ciao !

Could you please hod did you figure out, cause I had the same problem..

Thanks