function tdomf_get_users_published_posts_count($user_id = 0)
{
/*global $wpdb;
$query = "SELECT count(ID) ";
$query .= "FROM $wpdb->posts ";
$query .= "LEFT JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id) ";
$query .= "WHERE meta_key = '".TDOMF_KEY_USER_ID."' ";
$query .= "AND meta_value = '$user_id' ";
$query .= "AND post_status = 'publish' ";
return intval($wpdb->get_var( $query ));*/
return tdomf_get_posts(array('count' => true, 'post_status' => array('publish', 'future'), 'user_id' => $user_id));
}
function tdomf_get_user_draft_posts($user_id = 0, $offset = 0, $limit = 0)
{
/*global $wpdb;
$query = "SELECT ID, post_title, meta_value, post_status ";
$query .= "FROM $wpdb->posts ";
$query .= "LEFT JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id) ";
$query .= "WHERE meta_key = '".TDOMF_KEY_USER_ID."' ";
$query .= "AND post_status = 'draft' ";
$query .= "AND meta_value = '$user_id' ";
$query .= "ORDER BY ID DESC ";
if($limit > 0) {
$query .= "LIMIT $limit ";
}
if($offset > 0) {
$query .= "OFFSET $offset ";
}
return $wpdb->get_results( $query );*/
return tdomf_get_posts(array('limit' => $limit, 'offset' => $offset, 'user_id' => $user_id, 'post_status' => array('draft')));
}
function tdomf_show_mod_posts_menu()
{
tdomf_moderation_handler();
$user_id = false;
if (isset($_REQUEST['user_id'])) {
$user_id = intval($_REQUEST['user_id']);
}
$ip = false;
if (isset($_REQUEST['ip'])) {
$ip = $_REQUEST['ip'];
}
$form_id = false;
if (isset($_REQUEST['form_id'])) {
$form_id = intval($_REQUEST['form_id']);
if ($form_id <= 0) {
$form_id = false;
}
}
$pending_count = tdomf_get_posts(array('count' => true, 'post_status' => array('draft'), 'nospam' => true, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$scheduled_count = tdomf_get_posts(array('count' => true, 'post_status' => array('future'), 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$published_count = tdomf_get_posts(array('count' => true, 'post_status' => array('publish'), 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$spam_count = tdomf_get_posts(array('count' => true, 'spam' => true, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$all_count = tdomf_get_posts(array('count' => true, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$form_ids = tdomf_get_form_ids();
$pending_edits_count = tdomf_get_edits(array('state' => 'unapproved', 'count' => true, 'unique_post_ids' => true, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$spam_edits_count = tdomf_get_edits(array('state' => 'spam', 'count' => true, 'unique_post_ids' => true, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$approved_edits_count = tdomf_get_edits(array('state' => 'approved', 'count' => true, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$limit = 10;
# fixed
if (isset($_REQUEST['limit'])) {
$limit = intval($_REQUEST['limit']);
}
$paged = 1;
if (isset($_GET['paged'])) {
$paged = intval($_GET['paged']);
}
$offset = $limit * ($paged - 1);
$show = 'all';
if (isset($_REQUEST['show'])) {
$show = $_REQUEST['show'];
}
$posts = false;
$max_pages = 0;
$max_items = 0;
if ($show == 'all') {
$posts = tdomf_get_posts(array('offset' => $offset, 'limit' => $limit, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$max_pages = ceil($all_count / $limit);
$max_items = $all_count;
} else {
if ($show == 'pending_submissions') {
$posts = tdomf_get_posts(array('offset' => $offset, 'limit' => $limit, 'post_status' => array('draft'), 'nospam' => true, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$max_pages = ceil($pending_count / $limit);
$max_items = $pending_count;
} else {
if ($show == 'scheduled') {
$posts = tdomf_get_posts(array('offset' => $offset, 'post_status' => array('future'), 'limit' => $limit, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$max_pages = ceil($scheduled_count / $limit);
$max_items = $scheduled_count;
} else {
if ($show == 'published') {
$posts = tdomf_get_posts(array('offset' => $offset, 'post_status' => array('publish'), 'limit' => $limit, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$max_pages = ceil($published_count / $limit);
$max_items = $published_count;
} else {
if ($show == 'spam_submissions') {
$posts = tdomf_get_posts(array('offset' => $offset, 'spam' => true, 'limit' => $limit, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$max_pages = ceil($spam_count / $limit);
$max_items = $spam_count;
} else {
if ($show == 'pending_edits') {
$edits = tdomf_get_edits(array('state' => 'unapproved', 'unique_post_ids' => true, 'offset' => $offset, 'limit' => $limit, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$max_pages = ceil($pending_edits_count / $limit);
$posts = array();
# a little hacky magic
foreach ($edits as $e) {
$posts[] = (object) array('ID' => $e->post_id);
}
$max_items = $pending_edits_count;
} else {
if ($show == 'spam_edits') {
$edits = tdomf_get_edits(array('state' => 'spam', 'unique_post_ids' => true, 'offset' => $offset, 'limit' => $limit, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$max_pages = ceil($spam_edits_count / $limit);
$posts = array();
# a little hacky magic
foreach ($edits as $e) {
$posts[] = (object) array('ID' => $e->post_id);
}
$max_items = $spam_edits_count;
} else {
if ($show == 'approved_edits') {
$edits = tdomf_get_edits(array('state' => 'approved', 'offset' => $offset, 'limit' => $limit, 'form_id' => $form_id, 'user_id' => $user_id, 'ip' => $ip));
$max_pages = ceil($approved_edits_count / $limit);
$posts = array();
# a little hacky magic
foreach ($edits as $e) {
$posts[] = (object) array('ID' => $e->post_id, 'edit_id' => $e->edit_id);
}
$max_items = $approved_edits_count;
}
}
}
}
}
}
}
}
# max is incorrect... doesn't account for form filter...
$mode = 'list';
if (isset($_GET['mode'])) {
$mode = $_GET['mode'];
}
$count = 0;
# what bulk actions to support
$bulk_sub_publish_now = false;
$bulk_sub_publish = false;
$bulk_sub_unpublish = false;
$bulk_sub_spamit = false;
$bulk_sub_hamit = false;
$bulk_sub_lock = false;
$bulk_sub_unlock = false;
$bulk_edit_approve = false;
$bulk_edit_revert = false;
$bulk_edit_delete = false;
$bulk_edit_spamit = false;
$bulk_edit_hamit = false;
?>
<div class="wrap">
<?php
/* screen_icon(); */
?>
<h2>
<?php
if ($user_id || $ip) {
if ($user_id) {
$u = get_userdata($user_id);
printf(__('Posts submitted by user %s', 'tdomf'), $u->user_login);
} else {
if ($ip) {
printf(__('Posts submitted from IP %s', 'tdomf'), $ip);
}
}
} else {
?>
<?php
_e('Moderation', 'tdomf');
?>
<?php
}
?>
</h2>
<?php
/*if(count($posts) <= 0) { ?>
<div class="clear"></div>
<p><?php _e('No submissions found','tdomf') ?></p>
</div> <!-- wrap --><?php
return; }*/
?>
<form id="posts-filter" action="<?php
tdomf_get_mod_posts_url(true, $show, 0);
?>
" method="post">
<!-- hidden vars -->
<ul class="subsubsub">
<?php
if ($all_count > 0) {
?>
<li><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'show' => 'all'));
?>
"<?php
if ($show == 'all') {
?>
class="current"<?php
}
?>
><?php
printf(__('All Submissions (%s)', 'tdomf'), $all_count);
?>
</a> | </li>
<?php
}
?>
<?php
if ($pending_count > 0) {
?>
<li><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'show' => 'pending_submissions'));
?>
"<?php
if ($show == 'pending_submissions') {
?>
class="current"<?php
}
?>
><?php
printf(__('Pending Submissions (%s)', 'tdomf'), $pending_count);
?>
</a> | </li>
<?php
}
?>
<?php
if ($scheduled_count > 0) {
?>
<li><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'show' => 'scheduled'));
?>
"<?php
if ($show == 'scheduled') {
?>
class="current"<?php
}
?>
><?php
printf(__('Scheduled Submissions (%s)', 'tdomf'), $scheduled_count);
?>
</a> | </li>
<?php
}
?>
<?php
if ($published_count > 0) {
?>
<li><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'show' => 'published'));
?>
"<?php
if ($show == 'published') {
?>
class="current"<?php
}
?>
><?php
printf(__('Published (%s)', 'tdomf'), $published_count);
?>
</a> | </li>
<?php
}
?>
<?php
if ($spam_count > 0) {
?>
<li><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'show' => 'spam_submissions'));
?>
"<?php
if ($show == 'spam_submissions') {
?>
class="current"<?php
}
?>
><?php
printf(__('Spam Submissions (%s)', 'tdomf'), $spam_count);
?>
</a> | </li>
<?php
}
?>
<?php
if ($approved_edits_count > 0) {
?>
<li><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'show' => 'approved_edits'));
?>
"<?php
if ($show == 'approved_edits') {
?>
class="current"<?php
}
?>
><?php
printf(__('Approved Edits (%s)', 'tdomf'), $approved_edits_count);
?>
</a> | </li>
<?php
}
?>
<?php
if ($pending_edits_count > 0) {
?>
<li><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'show' => 'pending_edits'));
?>
"<?php
if ($show == 'pending_edits') {
?>
class="current"<?php
}
?>
><?php
printf(__('Pending Edits (%s)', 'tdomf'), $pending_edits_count);
?>
</a> | </li>
<?php
}
?>
<?php
if ($spam_edits_count > 0) {
?>
<li><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'show' => 'spam_edits'));
?>
"<?php
if ($show == 'spam_edits') {
?>
class="current"<?php
}
?>
><?php
printf(__('Spam Edits (%s)', 'tdomf'), $spam_edits_count);
?>
</a> | </li>
<?php
}
?>
</ul>
<div class="tablenav">
<?php
$page_links = paginate_links(array('base' => add_query_arg('paged', '%#%', tdomf_get_mod_posts_url(array())), 'format' => '', 'prev_text' => __('«'), 'next_text' => __('»'), 'total' => $max_pages, 'current' => $paged));
?>
<?php
if ($page_links) {
?>
<div class="tablenav-pages"><?php
$page_links_text = sprintf('<span class="displaying-num">' . __('Displaying %s–%s of %s') . '</span>%s', number_format_i18n($offset), number_format_i18n($offset + count($posts)), number_format_i18n($max_items), $page_links);
echo $page_links_text;
?>
</div>
<?php
}
?>
<div class="view-switch">
<a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'mode' => 'list'));
?>
"><img <?php
if ('list' == $mode) {
echo 'class="current"';
}
?>
id="view-switch-list" src="../wp-includes/images/blank.gif" width="20" height="20" title="<?php
_e('List View');
?>
" alt="<?php
_e('List View');
?>
" /></a>
<a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'mode' => 'excerpt'));
?>
"><img <?php
if ('excerpt' == $mode) {
echo 'class="current"';
}
?>
id="view-switch-excerpt" src="../wp-includes/images/blank.gif" width="20" height="20" title="<?php
_e('Excerpt View');
?>
" alt="<?php
_e('Excerpt View');
?>
" /></a>
</div>
<?php
$form_ids_check = array();
foreach ($form_ids as $form) {
if (TDOMF_Widget::isSubmitForm(false, $form->form_id)) {
$count = tdomf_get_posts(array('count' => true, 'form_id' => $form->form_id));
} else {
$count = tdomf_get_edits(array('count' => true, 'form_id' => $form->form_id));
}
if ($count > 0) {
$form_ids_check[] = $form->form_id;
}
}
if (!empty($form_ids_check)) {
?>
<select name='form_id'>
<option value="-1" selected="selected"><?php
_e('Show All', 'tdomf');
?>
</option>
<?php
foreach ($form_ids_check as $form) {
?>
<option value="<?php
echo $form;
?>
" <?php
if ($form_id == $form) {
?>
selected="selected" <?php
}
?>
><?php
printf(__('Form #%d', 'tdomf'), $form);
?>
</option>
<?php
}
?>
</select>
<input type="submit" id="post-query-submit" value="<?php
_e('Filter');
?>
" class="button-secondary" />
<?php
}
?>
<div class="clear"></div>
</div> <!-- tablenav -->
<div class="clear"></div>
<table class="widefat post fixed" cellspacing="0">
<thead>
<tr>
<th scope="col" id="cb" class="manage-column column-cb check-column" style=""><input type="checkbox" /></th>
<th scope="col" id="title" class="manage-column column-title" style=""><?php
_e('Post', 'tdomf');
?>
</th>
<th scope="col" id="submitted" class="manage-column column-submitted" style=""><?php
_e('Submitted', 'tdomf');
?>
</th>
<th scope="col" id="edited" class="manage-column column-edited" style="">
<?php
if ($show == 'approved_edits') {
_e('Edit', 'tdomf');
} else {
if ($show == 'pending_edits') {
_e('Pending Edit', 'tdomf');
} else {
if ($show == 'spam_edits') {
_e('Spam Edit', 'tdomf');
} else {
_e('Most Recent Edit', 'tdomf');
}
}
}
?>
</th>
<th scope="col" id="status" class="manage-column column-status" style=""><?php
_e('Status', 'tdomf');
?>
</th>
</tr>
</thead>
<tfoot>
<tr>
<th scope="col" id="cb" class="manage-column column-cb check-column" style=""><input type="checkbox" /></th>
<th scope="col" id="title" class="manage-column column-title" style=""><?php
_e('Post', 'tdomf');
?>
</th>
<th scope="col" id="submitted" class="manage-column column-submitted" style=""><?php
_e('Submitted', 'tdomf');
?>
</th>
<th scope="col" id="edited" class="manage-column column-edited" style="">
<?php
if ($show == 'approved_edits') {
_e('Edit', 'tdomf');
} else {
if ($show == 'pending_edits') {
_e('Pending Edit', 'tdomf');
} else {
if ($show == 'spam_edits') {
_e('Spam Edit', 'tdomf');
} else {
_e('Most Recent Edit', 'tdomf');
}
}
}
?>
</th>
<th scope="col" id="status" class="manage-column column-status" style=""><?php
_e('Status', 'tdomf');
?>
</th>
</tr>
</tfoot>
<tbody>
<?php
if (!empty($posts)) {
foreach ($posts as $p) {
$count++;
?>
<?php
$post =& get_post($p->ID);
/* seems I need this later */
?>
<?php
if ($show == 'approved_edits') {
// not really the "last" edit but lest pretend
$last_edit = array(tdomf_get_edit($p->edit_id));
} else {
$last_edit = tdomf_get_edits(array('post_id' => $p->ID, 'limit' => 2));
/* and need this earlier too */
}
?>
<?php
$form_id = get_post_meta($p->ID, TDOMF_KEY_FORM_ID, true);
?>
<?php
$queue = intval(tdomf_get_option_form(TDOMF_OPTION_QUEUE_PERIOD, $form_id));
if ($queue > 0) {
$queue = true;
} else {
$queue = false;
}
?>
<?php
$is_spam = get_post_meta($p->ID, TDOMF_KEY_SPAM);
?>
<?php
$locked = get_post_meta($post->ID, TDOMF_KEY_LOCK, true);
?>
<tr id='post-<?php
echo $p->ID;
?>
' class='<?php
if ($count % 2 != 0) {
?>
alternate <?php
}
?>
status-<?php
echo $post->post_status;
?>
iedit' valign="top">
<th scope="row" class="check-column"><input type="checkbox" name="post[]" value="<?php
echo $p->ID;
?>
" /></th>
<td class="post-title column-title"><strong><a class="row-title" href="post.php?action=edit&post=<?php
echo $p->ID;
?>
" title="Edit"><?php
echo $post->post_title;
?>
</a></strong>
<?php
/*$fuoptions = TDOMF_WidgetUploadFiles::getOptions($form_id);*/
$index = 0;
$filelinks = "";
while (true) {
$filename = get_post_meta($p->ID, TDOMF_KEY_DOWNLOAD_NAME . $index, true);
if ($filename == false) {
break;
}
/*if($fuoptions['nohandler'] && trim($fuoptions['url']) != "") {
$uri = trailingslashit($fuoptions['url'])."$p->ID/".$filename;
} else {*/
$uri = trailingslashit(get_bloginfo('wpurl')) . '?tdomf_download=' . $p->ID . '&id=' . $i;
/*}*/
$filelinks .= "<a href='{$uri}' title='" . htmlentities($filename) . "'>{$index}</a>, ";
$index++;
}
if (!empty($filelinks)) {
?>
<?php
_e('Uploaded Files: ', 'tdomf');
echo $filelinks;
?>
<br/>
<?php
}
?>
<?php
if ('excerpt' == $mode) {
# Have to create our own excerpt, the_excerpt() doesn't cut it
# here :(
if (empty($post->post_excerpt)) {
$excerpt = apply_filters('the_content', $post->post_content);
} else {
$excerpt = apply_filters('the_excerpt', $post->post_excerpt);
}
$excerpt = str_replace(']]>', ']]>', $excerpt);
$excerpt = wp_html_excerpt($excerpt, 252);
if (strlen($excerpt) == 252) {
$excerpt .= '...';
}
echo '<blockquote>' . $excerpt . '</blockquote>';
}
?>
<?php
if (get_option(TDOMF_OPTION_MOD_SHOW_LINKS)) {
?>
<div>
<?php
} else {
?>
<div class="row-actions">
<?php
}
?>
<?php
if ($post->post_status == 'future') {
$bulk_sub_publish_now = true;
?>
<span class="publish"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'publish_now', 'post_id' => $p->ID, 'nonce' => 'tdomf-publish_' . $p->ID));
?>
" title="<?php
echo htmlentities(__('Publish this submission now', 'tdomf'));
?>
"><?php
_e('Publish Now', 'tdomf');
?>
</a> |</span>
<?php
} else {
if ($post->post_status != 'publish') {
?>
<?php
if ($queue) {
$bulk_sub_publish_now = true;
$bulk_sub_publish = true;
?>
<span class="publish"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'publish', 'post_id' => $p->ID, 'nonce' => 'tdomf-publish_' . $p->ID));
?>
" title="<?php
echo htmlentities(__('Add submission to publish queue', 'tdomf'));
?>
"><?php
_e('Queue', 'tdomf');
?>
</a> |</span>
<span class="publish"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'publish_now', 'post_id' => $p->ID, 'nonce' => 'tdomf-publish_' . $p->ID));
?>
" title="<?php
echo htmlentities(__('Publish submission now', 'tdomf'));
?>
"><?php
_e('Publish Now', 'tdomf');
?>
</a> |</span>
<?php
} else {
$bulk_sub_publish = true;
?>
<span class="publish"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'publish_now', 'post_id' => $p->ID, 'nonce' => 'tdomf-publish_' . $p->ID));
?>
" title="<?php
echo htmlentities(__('Publish submission', 'tdomf'));
?>
"><?php
_e('Publish', 'tdomf');
?>
</a> |</span>
<?php
}
?>
<?php
} else {
if ($post->post_status == 'publish') {
$bulk_sub_unpublish = true;
?>
<span class="publish"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'unpublish', 'post_id' => $p->ID, 'nonce' => 'tdomf-unpublish_' . $p->ID));
?>
" title="<?php
echo htmlentities(__('Set submission to draft/unmoderated status.', 'tdomf'));
?>
"><?php
_e('Un-publish', 'tdomf');
?>
</a> |</span>
<?php
}
}
}
?>
<span class='delete'><a class='submitdelete' title='Delete this submission' href='<?php
echo wp_nonce_url("post.php?action=delete&post={$p->ID}", 'delete-post_' . $p->ID);
?>
' onclick="if ( confirm('<?php
echo js_escape(sprintf(__("You are about to delete this post \\'%s\\'\n \\'Cancel\\' to stop, \\'OK\\' to delete.", 'tdomf'), $post->post_title));
?>
') ) { return true;}return false;"><?php
_e('Delete', 'tdomf');
?>
</a> | </span>
<?php
if ($locked) {
$bulk_sub_unlock = true;
?>
<span class="lock"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'unlock', 'post_id' => $p->ID, 'nonce' => 'tdomf-unlock_' . $p->ID));
?>
" title="<?php
echo htmlentities(__('Unlock submission so it can be edited.', 'tdomf'));
?>
"><?php
_e('Unlock', 'tdomf');
?>
</a> |</span>
<?php
} else {
$bulk_sub_lock = true;
?>
<span class="lock"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'lock', 'post_id' => $p->ID, 'nonce' => 'tdomf-lock_' . $p->ID));
?>
" title="<?php
echo htmlentities(__('Lock submission from being edited.', 'tdomf'));
?>
"><?php
_e('Lock', 'tdomf');
?>
</a> |</span>
<?php
}
?>
<?php
if ($post->post_status == 'publish') {
?>
<span class='view'><a href="<?php
echo get_permalink($p->ID);
?>
" title="<?php
echo htmlentities(sprintf(__('View \'%s\'', 'tdomf'), $post->post_title));
?>
" rel="permalink"><?php
_e('View', 'tdomf');
?>
</a> | </span>
<?php
} else {
?>
<span class='view'><a href="<?php
echo get_permalink($p->ID);
?>
" title="<?php
echo htmlentities(sprintf(__('Preview \'%s\'', 'tdomf'), $post->post_title));
?>
" rel="permalink"><?php
_e('Preview', 'tdomf');
?>
</a> | </span>
<?php
}
?>
<span class='edit'><a href="post.php?action=edit&post=<?php
echo $p->ID;
?>
" title="<?php
echo htmlentities(__('Edit this submission', 'tdomf'));
?>
"><?php
_e('Edit', 'tdomf');
?>
</a>
<?php
if (get_option(TDOMF_OPTION_SPAM)) {
?>
|</span><?php
}
?>
<?php
if (get_option(TDOMF_OPTION_SPAM)) {
if (!$is_spam) {
$bulk_sub_spamit = true;
?>
<span class="spam"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'spamit', 'post_id' => $p->ID, 'nonce' => 'tdomf-spamit_' . $p->ID));
?>
" onclick="if ( confirm('<?php
echo js_escape(sprintf(__("You are about to flag this submission \\'%s\\' as spam\n \\'Cancel\\' to stop, \\'OK\\' to delete.", 'tdomf'), $post->post_title));
?>
') ) { return true;}return false;"><?php
_e('Spam', 'tdomf');
?>
</a></span>
<?php
} else {
$bulk_sub_hamit = true;
?>
<span class="spam"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'hamit', 'post_id' => $p->ID, 'nonce' => 'tdomf-hamit_' . $p->ID));
?>
" ><?php
_e('Not Spam', 'tdomf');
?>
</span>
<?php
}
}
?>
</div>
</td>
<td class="column-submitted">
<ul style="font-size: 11px;">
<li>
<?php
$name = get_post_meta($p->ID, TDOMF_KEY_NAME, true);
$email = get_post_meta($p->ID, TDOMF_KEY_EMAIL, true);
$user_id = get_post_meta($p->ID, TDOMF_KEY_USER_ID, true);
if ($user_id != false) {
?>
<!-- <a href="user-edit.php?user_id=<?php
echo $user_id;
?>
" class="edit"> -->
<a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'user_id' => $user_id, 'ip' => false, 'form_id' => false));
?>
">
<?php
$u = get_userdata($user_id);
echo $u->user_login;
?>
</a>
<?php
} else {
if (!empty($name) && !empty($email)) {
echo $name . " (" . $email . ")";
} else {
if (!empty($name)) {
echo $name;
} else {
if (!empty($email)) {
echo $email;
} else {
_e("N/A", "tdomf");
}
}
}
}
?>
/ <?php
$ip = get_post_meta($p->ID, TDOMF_KEY_IP, true);
if (!empty($ip)) {
?>
<a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'ip' => $ip, 'user_id' => false, 'form_id' => false));
?>
">
<?php
}
?>
<?php
echo $ip;
?>
<?php
if (!empty($ip)) {
?>
</a> <?php
}
?>
</li>
<li>
<?php
if ($form_id == false || tdomf_form_exists($form_id) == false) {
?>
<?php
_e("Unknown or deleted form", "tdomf");
?>
<?php
} else {
$form_edit_url = "admin.php?page=tdomf_show_form_options_menu&form={$form_id}";
$form_name = tdomf_get_option_form(TDOMF_OPTION_NAME, $form_id);
echo '<a href="' . $form_edit_url . '">' . sprintf(__('Form #%d: %s</a>', 'tdomf'), $form_id, $form_name) . '</a>';
}
?>
</li>
<li>
<?php
if ($post->post_status != 'publish' && $post->post_status != 'future') {
$post_date_gmt = get_post_meta($p->ID, TDOMF_KEY_SUBMISSION_DATE, true);
if ($post_date_gmt) {
echo mysql2date(__('Y/m/d'), $post_date_gmt);
} else {
#echo mysql2date(__('Y/m/d'), $post->post_modified_gmt);
}
} else {
echo mysql2date(__('Y/m/d'), $post->post_date_gmt);
}
?>
</li>
</ul>
</td>
<td class="column-edited">
<?php
/*$last_edit = tdomf_get_edits(array('post_id' => $p->ID, 'limit' => 1));*/
if ($last_edit == false || empty($last_edit) || $last_edit == NULL) {
?>
<!-- no edits -->
<?php
} else {
$previous_edit = false;
if (count($last_edit) == 2) {
$previous_edit = $last_edit[1];
}
$last_edit = $last_edit[0];
# only care about the first entry
$last_edit_data = maybe_unserialize($last_edit->data);
?>
<ul style="font-size: 11px;">
<li><?php
$user_id = $last_edit->user_id;
$name = __("N/A", "tdomf");
if (isset($last_edit_data[TDOMF_KEY_NAME])) {
$name = $last_edit_data[TDOMF_KEY_NAME];
}
$email = __("N/A", "tdomf");
if (isset($last_edit_data[TDOMF_KEY_EMAIL])) {
$email = $last_edit_data[TDOMF_KEY_EMAIL];
}
if ($user_id != 0) {
?>
<a href="user-edit.php?user_id=<?php
echo $user_id;
?>
" class="edit">
<?php
$u = get_userdata($user_id);
echo $u->user_login;
?>
</a>
<?php
} else {
if (!empty($name) && !empty($email)) {
echo $name . " (" . $email . ")";
} else {
if (!empty($name)) {
echo $name;
} else {
if (!empty($email)) {
echo $email;
} else {
_e("N/A", "tdomf");
}
}
}
}
?>
/ <?php
echo $last_edit->ip;
?>
</li>
<li>
<?php
$form_id = $last_edit->form_id;
if ($form_id == false || tdomf_form_exists($form_id) == false) {
?>
<?php
_e("Unknown or deleted form", "tdomf");
?>
<?php
} else {
$form_edit_url = "admin.php?page=tdomf_show_form_options_menu&form={$form_id}";
$form_name = tdomf_get_option_form(TDOMF_OPTION_NAME, $form_id);
echo '<a href="' . $form_edit_url . '">' . sprintf(__('Form #%d: %s', 'tdomf'), $form_id, $form_name) . '</a>';
}
?>
</li>
<li><?php
echo mysql2date(__('Y/m/d'), $last_edit->date_gmt);
?>
</li>
<li><?php
switch ($last_edit->state) {
case 'unapproved':
_e('Unapproved', "tdomf");
break;
case 'approved':
_e('Approved', "tdomf");
break;
case 'spam':
_e('Spam', "tdomf");
break;
default:
echo _e($last_edit->state, "tdomf");
break;
}
?>
</li>
</ul>
<div class="row-actions">
<?php
/* nothing to do if revisioning is disabled for the edits... */
if ($last_edit->revision_id != 0) {
?>
<?php
if ($last_edit->state != 'approved') {
?>
<span class='view'><a href="admin.php?page=<?php
echo TDOMF_FOLDER . DIRECTORY_SEPARATOR . "admin" . DIRECTORY_SEPARATOR . 'tdomf-revision.php&edit=' . $last_edit->edit_id;
?>
"><?php
_e('View', 'tdomf');
?>
</a> |<span>
<!-- <span class='view'><a href="revision.php?revision=<?php
echo $last_edit->revision_id;
?>
"><?php
_e('View', 'tdomf');
?>
</a> |<span> -->
<?php
}
?>
<?php
if ($last_edit->state == 'approved') {
$bulk_edit_revert = true;
?>
<span class="edit"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'revert_edit', 'edit_id' => $last_edit->edit_id, 'nonce' => 'tdomf-revert_edit_' . $last_edit->edit_id));
?>
"><?php
_e('Revert', 'tdomf');
?>
</a> | </span>
<?php
} else {
if ($last_edit->state == 'unapproved' || $last_edit->state == 'spam') {
$bulk_edit_delete = true;
$bulk_edit_approve = true;
?>
<span class="delete"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'delete_edit', 'edit_id' => $last_edit->edit_id, 'nonce' => 'tdomf-delete_edit_' . $last_edit->edit_id));
?>
"><?php
_e('Delete', 'tdomf');
?>
</a> | </span>
<span class="edit"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'approve_edit', 'edit_id' => $last_edit->edit_id, 'nonce' => 'tdomf-approve_edit_' . $last_edit->edit_id));
?>
"><?php
_e('Approve', 'tdomf');
?>
</a> | </span>
<?php
}
}
?>
<?php
if ($previous_edit) {
?>
<span class="edit"><a href="admin.php?page=<?php
echo TDOMF_FOLDER . DIRECTORY_SEPARATOR . "admin" . DIRECTORY_SEPARATOR . 'tdomf-revision.php&edit=' . $last_edit->edit_id;
?>
&right=<?php
echo $last_edit->edit_id;
?>
&left=<?php
echo $previous_edit->edit_id;
?>
"><?php
_e('Compare', 'tdomf');
?>
</a>
<?php
} else {
?>
<!-- <span class="edit"><a href="revision.php?action=diff&right=<?php
echo $last_edit->revision_id;
?>
&left=<?php
echo $last_edit->current_revision_id;
?>
"><?php
_e('Compare', 'tdomf');
?>
</a> -->
<span class="edit"><a href="admin.php?page=<?php
echo TDOMF_FOLDER . DIRECTORY_SEPARATOR . "admin" . DIRECTORY_SEPARATOR . 'tdomf-revision.php&edit=' . $last_edit->edit_id;
?>
&right=<?php
echo $last_edit->edit_id;
?>
&left=previous"><?php
_e('Compare', 'tdomf');
?>
</a>
<?php
}
?>
<?php
if (get_option(TDOMF_OPTION_SPAM)) {
?>
|<?php
}
?>
</span>
<?php
if (get_option(TDOMF_OPTION_SPAM)) {
if ($last_edit->state == 'spam') {
$bulk_edit_hamit = true;
?>
<span class="spam"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'hamit_edit', 'edit_id' => $last_edit->edit_id, 'nonce' => 'tdomf-hamit_edit_' . $last_edit->edit_id));
?>
" title="<?php
echo htmlentities(__('Flag contributation as not being spam', 'tdomf'));
?>
" ><?php
_e('Not Spam', 'tdomf');
?>
</span>
<?php
} else {
$bulk_edit_spamit = true;
?>
<span class="spam"><a href="<?php
tdomf_get_mod_posts_url(array('echo' => true, 'action' => 'spamit_edit', 'edit_id' => $last_edit->edit_id, 'nonce' => 'tdomf-spamit_edit_' . $last_edit->edit_id));
?>
" title="<?php
echo htmlentities(__('Flag contributation as being spam', 'tdomf'));
?>
" onclick="if ( confirm('<?php
echo js_escape(__("You are about to flag this contribution as spam\n \\'Cancel\\' to stop, \\'OK\\' to delete.", 'tdomf'));
?>
') ) { return true;}return false;"><?php
_e('Spam', 'tdomf');
?>
</a></span>
<?php
}
}
?>
<?php
}
?>
</div>
<?php
}
?>
</td>
<td class="status column-status">
<!-- todo take into account edited status -->
<?php
if ($is_spam && $post->post_status == 'draft') {
?>
<?php
_e('Spam', "tdomf");
?>
<?php
} else {
switch ($post->post_status) {
case 'draft':
_e('Draft', "tdomf");
break;
case 'publish':
_e('Published', "tdomf");
break;
case 'future':
_e('Scheduled', "tdomf");
break;
default:
echo _e($post->post_status, "tdomf");
break;
}
if ($is_spam) {
_e(' (Spam)', "tdomf");
}
if ($locked) {
_e(' [Locked]', 'tdomf');
}
}
?>
</td>
<?php
}
}
?>
</tbody>
</table>
<div class="tablenav">
<?php
if ($page_links) {
echo "<div class='tablenav-pages'>{$page_links_text}</div>";
}
?>
<?php
if (count($posts) > 0) {
?>
<div class="alignleft actions">
<select name="action">
<option value="-1" selected="selected"><?php
_e('Bulk Actions');
?>
</option>
<?php
if ($bulk_sub_publish_now) {
?>
<option value="publish_now"><?php
_e('Publish Submissions (Now)', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_sub_publish) {
?>
<option value="publish"><?php
_e('Publish/Queue Submissions', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_sub_unpublish) {
?>
<option value="unpublish"><?php
_e('Un-publish Submissions', 'tdomf');
?>
</option>
<?php
}
?>
<option value="delete"><?php
_e('Delete Submissions', 'tdomf');
?>
</option>
<?php
if ($bulk_sub_unlock) {
?>
<option value="unlock"><?php
_e('Unlock Submissions', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_sub_lock) {
?>
<option value="lock"><?php
_e('Lock Submissions', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_sub_spamit) {
?>
<option value="spamit"><?php
_e('Mark Submissions as Spam', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_sub_hamit) {
?>
<option value="hamit"><?php
_e('Mark Submissions as Not Spam', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_sub_hamit || $bulk_sub_spamit) {
?>
<option value="spam_recheck"><?php
_e('Recheck Submssions for Spam', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_edit_approve) {
?>
<option value="edit_approve"><?php
_e('Approve Edits', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_edit_revert) {
?>
<option value="edit_revert"><?php
_e('Revert Edits', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_edit_delete) {
?>
<option value="edit_delete"><?php
_e('Delete Edits', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_edit_spamit) {
?>
<option value="edit_spamit"><?php
_e('Mark Edits as Spam', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_edit_hamit) {
?>
<option value="edit_hamit"><?php
_e('Mark Edits as not Spam', 'tdomf');
?>
</option>
<?php
}
?>
<?php
if ($bulk_edit_hamit || $bulk_edit_spamit) {
?>
<option value="edit_spam_recheck"><?php
_e('Recheck Edits for Spam', 'tdomf');
?>
</option>
<?php
}
?>
</select>
<input type="submit" value="<?php
_e('Apply');
?>
" name="doaction" id="doaction" class="button-secondary action" />
<?php
wp_nonce_field('tdomf-moderate-bulk');
}
?>
<!-- hide filters
<select name='form'>
<option value="-1" selected="selected"><?php
_e('Show All Forms', 'tdomf');
?>
</option>
<?php
foreach ($form_ids as $form) {
?>
<option value="<?php
echo $form->form_id;
?>
"><?php
printf(__('Form #%d', 'tdomf'), $form->form_id);
?>
</option>
<?php
}
?>
</select>
-->
<br class="clear" />
</div> <!-- tablenav -->
<br class="clear" />
</div> <!-- wrap -->
</form>
<?php
}
