function tern_wp_youtube_list()
{
global $getWP, $wpdb, $post, $tern_wp_youtube_options;
$o = $getWP->getOption('tern_wp_youtube', $tern_wp_youtube_options);
//
$page = empty($_GET['page']) ? (tern_wp_youtube_page() - 1) * $o['limit'] : (intval($_GET['page']) - 1) * $o['limit'];
$p = $wpdb->get_results("select ID from {$wpdb->posts} as p, {$wpdb->postmeta} as m where p.ID = m.post_id and m.meta_key = '_tern_wp_youtube_video' order by p.post_date desc limit " . $page . ',' . $o['limit']);
$t = $wpdb->get_var("select COUNT(*) from {$wpdb->posts} as p, {$wpdb->postmeta} as m where p.ID = m.post_id and m.meta_key = '_tern_wp_youtube_video'");
//
if (!empty($p)) {
$n = new pagination(array('total' => $t, 'limit' => $o['limit'], 'url' => get_permalink(), 'seo' => $o['pages']));
?>
<ul class="tern_wp_post_list category-<?php
echo $o['category'];
?>
">
<?php
foreach ($p as $post) {
$post = get_post($post->ID);
setup_postdata($post);
$i = get_post_meta($post->ID, '_tern_wp_youtube_video', true);
?>
<li class="tern_wp_post post<?php
echo $c;
?>
">
<div class="tern_wp_post_head">
<h3 id="post-<?php
the_ID();
?>
">
<a href="<?php
the_permalink();
?>
" rel="bookmark" title="Permanent Link to <?php
the_title_attribute();
?>
"><?php
the_title();
?>
</a>
</h3>
<small><?php
the_time('F ');
?>
<span><?php
the_time('j');
?>
</span><?php
the_time(' Y');
?>
</small>
</div>
<div class="tern_wp_post_entry">
<div class="tern_wp_post_image">
<a href="<?php
the_permalink();
?>
"><?php
tern_wp_youtube_thumb();
?>
</a>
</div>
<?php
the_content('read more...');
?>
</div>
<div class="tern_wp_post_footer">
Filed in <?php
the_category(', ', 'single');
?>
| Comments (<?php
echo comments_number('0', '1', '%');
?>
)
</div>
</li>
<?php
$c++;
}
?>
</ul>
<?php
$n = new pagination(array('total' => $t, 'limit' => $o['limit'], 'url' => get_category_link($o['category']), 'seo' => $o['pages']));
} else {
echo '<h3>Sorry, there is nothing here to see yet.</h3>';
}
}
function WP_ayvpp_video_posts()
{
global $getWP, $tern_wp_youtube_options, $wpdb;
$o = $getWP->getOption('tern_wp_youtube', $tern_wp_youtube_options);
//$videos = get_option('tern_wp_youtube_videos');
//$videos = is_array($videos) ? $videos : array();
$videos = $wpdb->get_col("select post_id from {$wpdb->postmeta} where meta_key='_tern_wp_youtube_video'");
?>
<div class="wrap">
<div id="icon-options-general" class="icon32"><br /></div>
<h2>Video Posts</h2>
<p>Below you can delete, publish or draft your video posts.</p>
<p>Let's talk about this video list a little. This list displays all the videos that have been found in your YouTube channels and playlists. For each of these videos a WordPress post has been created. From this list you can manipulate the WordPress post by publishing, drafting or deleting it. When deleting a post you are simply moving it to the trash. Any of these actions taken does not affect the list of videos below PROVIDED THAT YOU NEVER PERMANENTLY DELETE THE POST CREATED. You cannot delete a video from the list below unless you reset the list below or manually delete a post from the trash. Publishing, deleting or drafting only affects the post associated with the YouTube video. Remember this list is simply a reference to the videos that this plugin has found in your YouTube channels and playlists. However, upon the permanent deletion of a post the import may republish the deleted video post automatically. If you wish to hide a video post from your blog, set the post to draft or move it to the trash.</p>
<form method="post" action="">
<p>The following button will delete all videos from the list below and all WordPress posts associated with the videos below. THIS MAY TAKE SOME TIME.</p>
<input type="submit" value="Completely Refresh Videos" name="refresh" class="button-primary action" />
<input type="hidden" name="action" value="refresh" />
<input type="hidden" id="_wpnonce" name="_wpnonce" value="<?php
echo wp_create_nonce('tern_wp_youtube_nonce');
?>
" />
</form>
<br /><br />
<form id="tern_wp_youtube_list_fm" method="post" action="">
<div class="tablenav">
<?php
$paged = $_GET['paged'] ? $_GET['paged'] : 1;
$num = 10;
$paging_text = paginate_links(array('total' => ceil(count($videos) / $num), 'current' => $paged, 'base' => 'admin.php?page=ayvpp-video-posts&%_%', 'format' => 'paged=%#%'));
if ($paging_text) {
$paging_text = sprintf('<span class="displaying-num">' . __('Displaying %s–%s of %s') . '</span>%s', number_format_i18n(($paged - 1) * $num + 1), number_format_i18n(min($paged * $num, count($videos))), number_format_i18n(count($videos)), $paging_text);
}
?>
<div class="tablenav-pages"><?php
echo $paging_text;
?>
</div>
<div class="alignleft actions">
<select name="action">
<option value="" selected="selected">Bulk Actions</option>
<option value="delete">Delete</option>
<option value="publish">Publish</option>
<option value="draft">Draft</option>
</select>
<input type="submit" value="Apply" name="doaction" class="button-secondary action" />
</div>
<br class="clear" />
</div>
<table class="widefat fixed" cellspacing="0">
<thead>
<tr class="thead">
<th scope="col" id="cb" class="manage-column column-cb check-column"><input type="checkbox" /></th>
<th scope="col" id="image" class="manage-column column-img" style="width:150px;">Preview</th>
<th scope="col" id="video-id" class="manage-column column-id" style="width:20%;">Video I.D.</th>
<th scope="col" id="title" class="manage-column column-title" style="width:20%;">Video Title</th>
<th scope="col" id="url" class="manage-column column-url">URL</th>
<th scope="col" id="post-id" class="manage-column column-post-id">Post ID</th>
</tr>
</thead>
<tfoot>
<tr class="thead">
<th scope="col" class="manage-column column-cb check-column"><input type="checkbox" /></th>
<th scope="col" class="manage-column column-img">Preview</th>
<th scope="col" class="manage-column column-id">Video I.D.</th>
<th scope="col" class="manage-column column-title">Video Title</th>
<th scope="col" class="manage-column column-url">URL</th>
<th scope="col" class="manage-column column-post-id">Post ID</th>
</tr>
</tfoot>
<tbody id="fields" class="list:fields field-list">
<?php
$videos = array_slice($videos, ($paged - 1) * $num, $num);
foreach ($videos as $v) {
$p = get_post($v);
$k = get_post_meta($v, '_tern_wp_youtube_video', true);
$d = empty($d) ? ' class="alternate"' : '';
?>
<tr id='field-<?php
echo $k;
?>
'<?php
echo $d;
?>
>
<th scope='row' class='check-column'><input type='checkbox' name='videos[]' id='field_<?php
echo $k;
?>
' value='<?php
echo $v;
?>
' /></th>
<td class="image column-image">
<?php
tern_wp_youtube_thumb($k);
?>
</td>
<td class="id column-id">
<strong><?php
echo $k;
?>
</strong>
<div class="row-actions">
<?php
$s = '';
if ($p->ID and $p->post_status != 'trash') {
$s = '<span class="edit"><a href="admin.php?page=ayvpp-video-posts&videos%5B%5D=' . $v . '&action=delete&_wpnonce=' . wp_create_nonce('tern_wp_youtube_nonce') . '">Delete</a></span>';
}
if ($p->ID and $p->post_status != 'publish') {
$s .= empty($s) ? '' : ' | ';
$s .= '<span class="edit"><a href="admin.php?page=ayvpp-video-posts&videos%5B%5D=' . $v . '&action=publish&_wpnonce=' . wp_create_nonce('tern_wp_youtube_nonce') . '">Publish</a></span>';
}
if ($p->ID and $p->post_status != 'draft') {
$s .= empty($s) ? '' : ' | ';
$s .= '<span class="edit"><a href="admin.php?page=ayvpp-video-posts&videos%5B%5D=' . $v . '&action=draft&_wpnonce=' . wp_create_nonce('tern_wp_youtube_nonce') . '">Draft</a></span>';
}
echo $s;
?>
</div>
</td>
<td class="title column-title">
<span class="field_titles"><?php
echo $p->post_title;
?>
</span>
</td>
<td class="url column-url">
<a href="<?php
tern_wp_youtube_video_watch_link($k);
?>
" target="_blank"><?php
tern_wp_youtube_video_watch_link($k);
?>
</a>
</td>
<td class="post-id column-post-id">
<?php
echo $v;
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<div class="tablenav">
<div class="alignleft actions">
<select name="action2">
<option value="" selected="selected">Bulk Actions</option>
<option value="delete">Delete</option>
<option value="publish">Publish</option>
<option value="draft">Draft</option>
</select>
<input type="submit" value="Apply" name="doaction2" class="button-secondary action" />
</div>
<br class="clear" />
</div>
<input type="hidden" id="page" name="page" value="ayvpp-video-posts" />
<input type="hidden" id="_wpnonce" name="_wpnonce" value="<?php
echo wp_create_nonce('tern_wp_youtube_nonce');
?>
" />
</form>
</div>
<?php
}
