<?php wp_uc_flash(); ?> in your templates~ Navigate to `Editing Comment` page to configure or cancel useful comments.
Version: 2.0
Author: LL19.com
Author URI: http://www.ll19.com/
*/
if (!isset ($wpdb)) {
wp_useful_comments_init();
}
$ucTextDomain = 'UsefulComments';
$ucUrlDomain = "";
if (@ file_exists(TEMPLATEPATH . '/useful_comments.php')) {
$ucUrlDomain = get_stylesheet_directory_uri() . "/";
} else {
$ucUrlDomain = WP_PLUGIN_URL . "/useful_comments/";
}
class wp_useful_comments {
function install() {
global $wpdb;
$result = mysql_query("CREATE TABLE `$wpdb->useful_comments`(`commentid` INT( 20 ) NOT NULL ,`postid` INT( 20 ) NOT NULL ,PRIMARY KEY ( `commentid` ))", $wpdb->dbh) or die(mysql_error() . ' on line: ' . __LINE__);
if (!$result) {
return false;
}
return true;
}
}
/*
creat table wp_useful_comments.
*/
function wp_useful_comments_init() {
global $wpdb, $wp_uc;
$wpdb->useful_comments = $wpdb->prefix . 'useful_comments';
$wp_uc = new wp_useful_comments;
$result = mysql_list_tables(DB_NAME);
$tables = array ();
while ($row = mysql_fetch_row($result)) {
$tables[] = $row[0];
}
if (!in_array($wpdb->useful_comments, $tables)) {
$wp_uc->install();
}
}
add_action('admin_print_scripts', 'uc_tag_js_header');
function uc_tag_js_header() {
global $ucUrlDomain;
// use JQuery
echo "\n" . '' . "\n";
wp_print_scripts('jquery');
echo '' . "\n";
echo '' . "\n";
}
function uc_edit_text_form() {
global $ucTextDomain, $ucUrlDomain, $comment, $wpdb, $table_prefix;
$query = "SELECT * FROM " . $table_prefix . "useful_comments WHERE commentid = '" . $comment->comment_ID . "'";
$wp_select_uc_callback = $wpdb->query($query);
if ($wp_select_uc_callback == 0) {
echo '';
} else {
echo '';
}
?>
get_var($sqlcount);
if ($uc_count > 0) {
?>