<?php
function ocmx_comment_options (){
if($_POST["startrow"]) :
$startrow = $_POST["startrow"];
$endrow = ($_POST["startrow"] + 15);
elseif($_GET["startrow"]) :
$startrow = $_GET["startrow"];
$endrow = ($_GET["startrow"] + 15);
else :
$startrow = "0";
$endrow = 15;
endif;
global $options, $themename, $manualurl, $wpdb;
$comment_table = $wpdb->prefix . "ocmx_comment_meta";
$count_subscribers = $wpdb->get_results("SELECT * FROM $comment_table");
$fetch_subscribers = $wpdb->get_results(
"SELECT $wpdb->comments.*, $comment_table.*
FROM $wpdb->comments INNER JOIN $comment_table
ON $wpdb->comments.comment_ID = $comment_table.commentId
ORDER BY $wpdb->comments.comment_post_ID ASC, $wpdb->comments.comment_author ASC, $wpdb->comments.comment_author_email ASC, $comment_table.twitter ASC, $comment_table.email_subscribe DESC
LIMIT $startrow, $endrow");
if(isset($_POST["comment_changes"])) :
$users_deleted = 0;
$users_blocked = 0;
$users_subs = 0;
wp_cache_flush();
foreach($fetch_subscribers as $subscriber_details) :
$delete_key = "delete_comment-".$subscriber_details->commentId;
$block_key = "block_comment-".$subscriber_details->commentId;
$subs_key = "mail_comment-".$subscriber_details->commentId;
if(isset($_POST[$delete_key])) :
$main_sql = "DELETE FROM $wpdb->comments WHERE comment_ID = ".$subscriber_details->commentId;
$meta_sql = "DELETE FROM $comment_table WHERE commentId = '".$subscriber_details->commentId."'";
$check_post = get_post($subscriber_details->comment_post_ID);
if($wpdb->query($main_sql) == "1" && $wpdb->query($meta_sql) == "1") :
if($check_post->comment_count !== 0):
$update_posts = "UPDATE $wpdb->posts SET comment_count = ".($check_post->comment_count - 1)." WHERE `ID` = ".$subscriber_details->comment_post_ID;
$wpdb->query($update_posts);
endif;
$users_deleted += 1;
endif;
else :
if(isset($_POST[$block_key])): $block_user = 1; else: $block_user = 0; endif;
if(isset($_POST[$subs_key])): $subs_user = 1; else: $subs_user = 0; endif;
$update_sql = "UPDATE $comment_table
SET block_user = ".$block_user.",
email_subscribe = ".$subs_user."
WHERE commentId = ".$subscriber_details->commentId;
$wpdb->query($update_sql);
if(isset($_POST[$block_key])) :
$users_blocked += 1;
endif;
if(isset($_POST[$subs_key])) :
$users_subs += 1;
endif;
endif;
endforeach;
$fetch_subscribers = $wpdb->get_results(
"SELECT $wpdb->comments.*, $comment_table.*
FROM $wpdb->comments INNER JOIN $comment_table
ON $wpdb->comments.comment_ID = $comment_table.commentId
ORDER BY $wpdb->comments.comment_post_ID ASC, $wpdb->comments.comment_author ASC, $wpdb->comments.comment_author_email ASC, $comment_table.twitter ASC, $comment_table.email_subscribe DESC
LIMIT $startrow, $endrow");
endif;
ocmx_header();
?>
<h2>OCMX Comments</h2>
<?php if(isset($_POST["comment_changes"])) :
if($users_deleted !== 0 || $users_blocked !== 0 || $users_subs !== 0) :
echo "<p class=\"success\">Your changes were successful. $users_deleted Deleted, $users_blocked Blocked, $users_subs Subscription Changes</p>";
else :
echo "<p class=\"error\">Your changes were not successful.</p>";
endif;
endif; ?>
<form action="<?php echo $_SERVER['REQUEST_URI']; ?>&startrow=<?php echo $startrow; ?>" id="ocmx_comment_form" method="post" enctype="multipart/form-data">
<p class="submit"><input name="save" type="submit" value="Save changes" /></p>
<input type="hidden" name="comment_changes" value="1" />
<input type="hidden" name="startrow" value="<?php echo $startrow; ?>" />
<?php
$pages = (count($count_subscribers)/15);
if($pages > 1) :
echo "<p>Pages: ";
for ($i = 1; $i < ($pages + 1); $i++)
{
if($startrow == ($i*15-15)) :
echo "<a href=\"".$_SERVER['REQUEST_URI']."&startrow=".($i*15-15)."\"><strong>".$i."</strong></a>";
else :
echo "<a href=\"".$_SERVER['REQUEST_URI']."&startrow=".($i*15-15)."\">".$i."</a>";
endif;
if($i !== round($pages)) :
echo " · ";
endif;
}
echo "</p>";
endif;
?>
<div id="container">
<div class="content_box">
<div class="ocmx-tabs">
<ul class="tabs clearfix">
<li class="selected"><a href="#">Manage</a></li>
</ul>
</div>
<div class="ocmx-content">
<div class="header"><div></div></div>
<div class="content clearfix">
<!-- <div class="tablenav clearfix"> -->
<p></p>
<table class="widefat post fixed">
<thead>
<tr>
<th>Full Name</th>
<th>E-Mail</th>
<th>Twitter ID</th>
<th width="8%">View</th>
<th width="8%">Mail</th>
<th width="8%">Block</th>
<th width="8%">Delete</th>
</tr>
</thead>
<?php
$last_post_id = "alternate";
foreach($fetch_subscribers as $subscriber_details) :
$cId = $subscriber_details->commentId;
if($last_post_id !== $subscriber_details->comment_post_ID) :
if($use_class == "alternate") :
$use_class = "";
else:
$use_class = "alternate";
endif;
?>
<tr class="<?php echo $use_class; ?>">
<td colspan="7">
<strong>Post Title: </strong>
<a href="<?php echo get_permalink($subscriber_details->comment_post_ID); ?>" class="std_link" target="_blank">
<?php echo get_the_title($subscriber_details->comment_post_ID); ?>
</a>
</td>
</tr>
<?php
endif;
?>
<tr class="<?php echo $use_class; ?>">
<td><?php echo $subscriber_details->comment_author; ?></td>
<td><?php echo $subscriber_details->comment_author_email; ?></td>
<td>
<input type="hidden" name="post_id-<?php echo $cId; ?>" value="1" />
<a href="http://twitter.com/<?php echo $subscriber_details->twitter; ?>" class="std_link" target="_blank">
<?php echo $subscriber_details->twitter; ?>
</a>
</td>
<td class="t_center">
<a href="<?php echo $_SERVER['REQUEST_URI']; ?>&delete_comment=1&comment_id=<?php echo $cId; ?>" class="std_link" id="view-comment-<?php echo $cId; ?>" title="View Comment">
<img src="<?php bloginfo('template_directory'); ?>/ocmx/images/comment.gif" alt="view" />
</a>
</td>
<td class="t_center">
<?php if($subscriber_details->email_subscribe == 1): ?>
<input type="checkbox" checked="checked" name="mail_comment-<?php echo $cId; ?>" id="mail_comment-<?php echo $cId; ?>"/>
<?php else: ?>
<input type="checkbox" name="mail_comment-<?php echo $cId; ?>" id="mail_comment-<?php echo $cId; ?>"/>
<?php endif?>
</td>
<td class="t_center">
<?php if($subscriber_details->block_user == 1): ?>
<input type="checkbox" checked="checked" name="block_comment-<?php echo $cId; ?>" id="block_comment-<?php echo $cId; ?>"/>
<?php else : ?>
<input type="checkbox" name="block_comment-<?php echo $cId; ?>" id="block_comment-<?php echo $cId; ?>"/>
<?php endif?>
</td>
<td class="t_center">
<input type="checkbox" name="delete_comment-<?php echo $cId; ?>" id="delete_comment-<?php echo $cId; ?>"/>
</td>
</tr>
<tr class="no_display" id="ocmx-comment-<?php echo $cId; ?>">
<td colspan="7">
<p>
<?php
$use_comment = apply_filters('wp_texturize', $subscriber_details->comment_content);
$use_comment = str_replace("\n", "<br>", $use_comment);
echo $use_comment;
?>
</p>
</td>
</tr>
<?php
$last_post_id = $subscriber_details->comment_post_ID;
endforeach; ?>
</table>
<!-- </div> -->
</div>
<div class="footer"><div></div></div>
</div>
</div>
</div>
<?php
if($pages > 1) :
echo "<p>Pages: ";
for ($i = 1; $i < ($pages + 1); $i++)
{
if($startrow == ($i*15-15)) :
echo "<a href=\"".$_SERVER['REQUEST_URI']."&startrow=".($i*15-15)."\"><strong>".$i."</strong></a>";
else :
echo "<a href=\"".$_SERVER['REQUEST_URI']."&startrow=".($i*15-15)."\">".$i."</a>";
endif;
if($i !== round($pages)) :
echo " · ";
endif;
}
echo "</p>";
endif;
?>
<p class="submit"><input name="save" type="submit" value="Save changes" /></p>
<div class="clearfix"></div>
</form>
<div class="clearfix"></div>
<?php
};
?>