Salve ragazzi, sono nuovamente alle prese con un codice php questa volta con un widjet che svolge una funzione molto simile a quella che vorrei andare ad implementare.

Purtroppo non sono riuscito a modificare correttamente il widjet in modo da farlo funzionare. Nuovamente mi appello a gente molto più esperta di me.

Il widjet stampa gli ultimi eventi caricati, io invece vorrei sapere se è possibile modificarlo in modo tale da fargli stampare solo i prossimi eventi

Grazie in anticipo

codice:
<?php

// =============================== Latest events posts Widget (particular category) ======================================
class events2columns extends WP_Widget {
	function events2columns() {
	//Constructor
		$widget_ops = array('classname' => 'widget Latest Events', 'description' => 'List of latest events in particular category - ( List View ) ' );
		$this->WP_Widget('news2columns', 'PT &rarr; Latest Events List View', $widget_ops);
	}
	function widget($args, $instance) {
	// prints the widget
		extract($args, EXTR_SKIP);
		echo $before_widget;
		$title = empty($instance['title']) ? '' : apply_filters('widget_title', $instance['title']);
 		$category = empty($instance['category']) ? '' : apply_filters('widget_category', $instance['category']);
		$post_number = empty($instance['post_number']) ? '6' : apply_filters('widget_post_number', $instance['post_number']);
		$post_link = empty($instance['post_link']) ? '#' : apply_filters('widget_post_link', $instance['post_link']);
		$character_cout = empty($instance['character_cout']) ? '15' : apply_filters('widget_character_cout', $instance['character_cout']);
		 ?>
          
				<?php 
			        global $post,$wpdb;
					$thumb_url1 = $thumb_url.get_image_cutting_edge($args);
					$img_zc = get_img_zc(get_option('ptthemes_image_zc'));
					$sqlsql ='';
			      if($category)
				   {
						$category = "'".str_replace(",","','",$category)."'";
						$sqlsql = "and p.ID in (select tr.object_id from $wpdb->term_relationships tr join $wpdb->term_taxonomy t on t.term_taxonomy_id=tr.term_taxonomy_id where t.term_id in ($category)  )";   
				   }
				   
				   if($_SESSION['multi_city'])
					{
						$multi_city_id =  get_multi_city_id();
						$meta_key = get_multi_city_meta();
						$sql = "select p.* from $wpdb->posts p join $wpdb->postmeta pm on pm.post_id=p.ID where p.post_type='event' and p.post_status='publish' and (pm.meta_key=\"$meta_key\" and (pm.meta_value in ($multi_city_id))) $sqlsql order by  p.post_date desc,p.post_title asc limit $post_number";
						}
					else{
					$sql = "select p.* from $wpdb->posts p where p.post_type='event' and p.post_status='publish' $sqlsql order by  p.post_date desc,p.post_title asc limit $post_number";}
					
					$latest_menus = $wpdb->get_results($sql);
                    if($latest_menus)
					{
					?>
                    <h3> <?php echo $title; ?> </h3>
         	 <ul class="category_list_view">
                    <?php
					foreach($latest_menus as $post) :
                    setup_postdata($post);
			    ?>
                 <?php $post_images = bdw_get_images($post->ID,'medium');?>
           		<li class="clearfix <?php if(get_post_meta($post->ID,'is_featured',true)){ echo 'featured';}?> <?php echo FEATURED_IMG_CLASS;?>
" > 
                <?php if(get_post_meta($post->ID,'is_featured',true)) {?>  <span class="<?php echo 'featured_img';?>">featured</span> <?php }?>
            	<?php 
            if(get_the_post_thumbnail( $post->ID, 'medium')){?>
             <a class="post_img" href="<?php the_permalink(); ?>">
             <?php $post_thumb =  get_the_post_thumbnail_src(get_the_post_thumbnail( $post->ID,'medium'));?>
             [img]<?php echo $post_thumb;?>[/img]" title="<?php the_title(); ?>"  />
             </a>
            <?php }else if($post_images[0]){ global $thumb_url;             
                
            ?>
             <a class="post_img" href="<?php the_permalink(); ?>">
             [img]<?php echo $post_images[0];?>[/img]" title="<?php the_title(); ?>"  /> </a>
            <?php
            } else { ?> 
<a class="post_img" href="<?php the_permalink(); ?>">
             [img]<?php echo get_post_default_img($post->ID,$post->post_type);?>[/img]" title="<?php the_title(); ?>"  /> </a>            <?php }?> 
            		 <h3> 
                         <?php the_title(); ?>       
                          <?php comments_number('0', '1', '%'); ?>  
                     </h3> 
                     <p class="timing"> <span><?php _e('Start Date :');?></span> 
		 <?php echo get_formated_date(get_post_meta($post->ID,'st_date',true)).' '. get_formated_time(get_post_meta($post->ID,'st_time',true));?> 
         
 
         <span><?php _e('End Date :');?></span> <?php echo get_formated_date(get_post_meta($post->ID,'end_date',true)) . ' ' .get_formated_time(get_post_meta($post->ID,'end_time',true));?>
         </p>
                     <?php
                     if(get_post_meta($post->ID,'address',true))
					{
						$from_add = get_post_meta($post->ID,'address',true);
					}else
					{
						$from_add = get_post_meta($post->ID,'geo_address',true);
					}
					if($from_add){
					 ?>
                     <p class="address"><?php echo $from_add;?></p>
                     <?php }?>
                     <span class="rating"><?php echo get_post_rating_star($post->ID);?><?php /*?>[img]<?php bloginfo('template_directory'); ?>/images/rating.png[/img] <?php */?></span>
                    

<?php echo excerpt($character_cout); ?> </p>
                    <span class="readmore" > <?php _e('read more');?>   </span>
            	 
<?php endforeach; ?>[/list]
<?php }?>
<?php
		echo $after_widget;
	}
	function update($new_instance, $old_instance) {
	//save the widget
		$instance = $old_instance;
		$instance['title'] = strip_tags($new_instance['title']);
		$instance['category'] = strip_tags($new_instance['category']);
		$instance['post_number'] = strip_tags($new_instance['post_number']);
		$instance['post_link'] = strip_tags($new_instance['post_link']);
		$instance['character_cout'] = strip_tags($new_instance['character_cout']);
		return $instance;

	}

	function form($instance) {
	//widgetform in backend
		$instance = wp_parse_args( (array) $instance, array( 'title' => '', 'category' => '', 'post_number' => '','character_cout' => '' ) );
		$title = strip_tags($instance['title']);
		$category = strip_tags($instance['category']);
		$post_number = strip_tags($instance['post_number']);
		$post_link = strip_tags($instance['post_link']);
		$character_cout = strip_tags($instance['character_cout']);

?>



  <label for="<?php echo $this->get_field_id('title'); ?>">Title:
    <input class="widefat" id="<?php echo $this->get_field_id('title'); ?>" name="<?php echo $this->get_field_name('title'); ?>" type="text" value="<?php echo attribute_escape($title); ?>" />
  </label>
</p>



  <label for="<?php echo $this->get_field_id('category'); ?>">Categories (<code>IDs</code> separated by commas):
  <input class="widefat" id="<?php echo $this->get_field_id('category'); ?>" name="<?php echo $this->get_field_name('category'); ?>" type="text" value="<?php echo attribute_escape($category); ?>" />
  </label>
</p>



  <label for="<?php echo $this->get_field_id('post_number'); ?>">Number of posts:
  <input class="widefat" id="<?php echo $this->get_field_id('post_number'); ?>" name="<?php echo $this->get_field_name('post_number'); ?>" type="text" value="<?php echo attribute_escape($post_number); ?>" />
  </label>
</p>



  <label for="<?php echo $this->get_field_id('character_cout'); ?>">Post content excerpt character count : 
  <input class="widefat" id="<?php echo $this->get_field_id('character_cout'); ?>" name="<?php echo $this->get_field_name('character_cout'); ?>" type="text" value="<?php echo attribute_escape($character_cout); ?>" />
  </label>
</p>
<?php
	}
}
register_widget('events2columns'); ?>