'articlesPickAndSlide', 'description' => __('Questo widget ti permette di visualizzare uno slider degli articoli di una categoria','articlesPickAndSlide') ); /* Widget creation */ $this->WP_Widget( 'articlesPickAndSlide-widget', __('Articles Slider','articlesPickAndSlide'), $widget_opt); } function widget($args, $instance) { extract( $args ); global $wpdb; /* User settings. */ $title = apply_filters('widget_title', $instance['title'] ); $num_max_articles = $instance['num_max_articles']; $articles_cat_id = $instance['articles_cat_id']; echo $before_widget; $query = "SELECT id, post_title, post_content, post_date " ."FROM wp_posts " ."INNER JOIN wp_term_relationships ON wp_posts.id = wp_term_relationships.object_id " ."WHERE term_taxonomy_id = ".$articles_cat_id." " ."AND post_status = 'publish' " ."ORDER BY post_date DESC " ."LIMIT 0, ".$num_max_articles; $contents = $wpdb->get_results($wpdb->prepare($query)); if (count($contents) > 0){ echo "
"; echo "

"; // Widget Title if ( $title ) echo $before_title . $title . $after_title; echo "

"; echo "
"; echo "
"; echo "
"; foreach ($contents as $content) { echo "
"; echo "

".$content->post_title."

"; echo "

".date('d.m.Y',strtotime($content->post_date))."

"; //dmY echo "

".substr($content->post_content,0,130); echo "

"; } echo "
"; echo "
"; echo "
"; echo "
"; } //wp_reset_query(); echo $after_widget; } function update( $new_instance, $old_instance ) { $instance = $old_instance; $instance['title'] = strip_tags( $new_instance['title'] ); $instance['num_max_articles'] = $new_instance['num_max_articles']; $instance['articles_cat_id'] = $new_instance['articles_cat_id']; return $instance; } function form( $instance ) { /* default settings */ $defaults = array( 'title' => 'Article Slider', ); $instance = wp_parse_args( (array) $instance, $defaults ); ?>