--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/web/wp-content/themes/selecta/ocmx/ocmx-comment-options.php Fri Mar 12 13:29:04 2010 +0000
@@ -0,0 +1,228 @@
+<?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
+
+};
+?>
\ No newline at end of file