Ejemplos de Podlove\Modules\Networks\Model PodcastList::property en PHP

Ejemplo n.º 1

Archivo: podcast_list.php Proyecto: johannes-mueller/podlove-publisher

            $subqueries[] = $podcast->with_blog_scope(function () use($podcast) {
                global $wpdb;
                $query = "(SELECT p.ID, p.post_title, p.post_date, b.blog_id FROM " . $wpdb->posts . " p, " . $wpdb->blogs . " b\n";
                $query .= "WHERE p.post_type = 'podcast'";
                $query .= "AND p.post_status = 'publish'";
                $query .= "AND b.blog_id = " . $podcast->get_blog_id() . ")";
                return $query;
            });
        }
        $query = implode("UNION\n", $subqueries) . " ORDER BY {$orderby} {$order} LIMIT 0, " . (int) $number_of_episodes;
        $recent_posts = $wpdb->get_results($query);
        $episodes = [];
        foreach ($recent_posts as $post) {
            switch_to_blog($post->blog_id);
            if ($episode = \Podlove\Model\Episode::find_one_by_post_id($post->ID)) {
                $episodes[] = new \Podlove\Template\Episode($episode);
            }
            restore_current_blog();
        }
        return $episodes;
    }
}
PodcastList::property('id', 'INT NOT NULL AUTO_INCREMENT PRIMARY KEY');
PodcastList::property('title', 'VARCHAR(255)');
PodcastList::property('slug', 'VARCHAR(255)');
PodcastList::property('subtitle', 'TEXT');
PodcastList::property('description', 'TEXT');
PodcastList::property('url', 'TEXT');
PodcastList::property('logo', 'TEXT');
PodcastList::property('podcasts', 'TEXT');