ratings = $table_prefix . 'ratings';
### Function: Ratings Administration Menu
add_action('admin_menu', 'ratings_menu');
function ratings_menu() {
if (function_exists('add_menu_page')) {
add_menu_page(__('Ratings', 'wp-postratings'), __('Ratings', 'wp-postratings'), 'manage_ratings', 'postratings/postratings-manager.php');
}
if (function_exists('add_submenu_page')) {
add_submenu_page('postratings/postratings-manager.php', __('Manage Ratings', 'wp-postratings'), __('Manage Ratings', 'wp-postratings'), 'manage_ratings', 'postratings/postratings-manager.php');
add_submenu_page('postratings/postratings-manager.php', __('Ratings Options', 'wp-postratings'), __('Ratings Options', 'wp-postratings'), 'manage_ratings', 'postratings/postratings-options.php');
add_submenu_page('postratings/postratings-manager.php', __('Ratings Usage', 'wp-postratings'), __('Ratings Usage', 'wp-postratings'), 'manage_ratings', 'postratings/postratings-usage.php');
}
}
### Function: Display The Rating For The Post
function the_ratings($start_tag = 'div', $display = true) {
global $id;
// Loading Style
$loading = "<$start_tag id=\"post-ratings-$id-loading\" class=\"post-ratings-loading\">![\"".__('Loading',](\"".get_settings('siteurl')."/wp-content/plugins/postratings/images/loading.gif\" "\\"\".__('Loading',")
".__('Loading', 'wp-postratings')." ...\n";
// Check To See Whether User Has Voted
$user_voted = check_rated($id);
// If User Voted Or Is Not Allowed To Rate
if($user_voted || !check_allowtorate()) {
if(!$display) {
return "<$start_tag id=\"post-ratings-$id\" class=\"post-ratings\">".the_ratings_results($id).''."\n$loading";
} else {
echo "<$start_tag id=\"post-ratings-$id\" class=\"post-ratings\">".the_ratings_results($id).''."\n$loading";
return;
}
// If User Has Not Voted
} else {
if(!$display) {
return "<$start_tag id=\"post-ratings-$id\" class=\"post-ratings\">".the_ratings_vote($id).''."\n$loading";
} else {
echo "<$start_tag id=\"post-ratings-$id\" class=\"post-ratings\">".the_ratings_vote($id).''."\n$loading\n";
return;
}
}
}
### Function: Displays Rating Header
add_action('wp_head', 'the_ratings_header');
function the_ratings_header() {
if(strpos($_SERVER['SCRIPT_NAME'], 'cgi') === false) {
$ratings_ajax_url = dirname($_SERVER['SCRIPT_NAME']);
} else {
$ratings_ajax_url = dirname($_SERVER['PHP_SELF']);
}
if(substr($ratings_ajax_url, -1) == '/') {
$ratings_ajax_url = substr($ratings_ajax_url, 0, -1);
}
echo "\n".''."\n";
echo ''."\n";
echo ''."\n";
echo ''."\n";
echo ''."\n";
echo ''."\n";
}
### Function: Displays Ratings Header In WP-Admin
add_action('admin_head', 'ratings_header_admin');
function ratings_header_admin() {
echo ''."\n";
}
### Function: Display Ratings Results
function the_ratings_results($post_id, $new_user = 0, $new_score = 0, $new_average = 0) {
$ratings_image = get_settings('postratings_image');
$ratings_max = intval(get_settings('postratings_max'));
if($new_user == 0 && $new_score == 0 && $new_average == 0) {
$post_ratings = get_post_custom($post_id);
$post_ratings_users = $post_ratings['ratings_users'][0];
$post_ratings_score = $post_ratings['ratings_score'][0];
$post_ratings_average = $post_ratings['ratings_average'][0];
} else {
$post_ratings_users = $new_user;
$post_ratings_score = $new_score;
$post_ratings_average = $new_average;
}
$post_ratings_images = '';
if($post_ratings_score == 0 || $post_ratings_users == 0) {
$post_ratings = 0;
$post_ratings_average = 0;
$post_ratings_percentage = 0;
} else {
$post_ratings = round($post_ratings_average, 1);
$post_ratings_percentage = round((($post_ratings_score/$post_ratings_users)/$ratings_max) * 100, 2);
}
// Check For Half Star
$insert_half = 0;
$average_diff = abs(floor($post_ratings_average)-$post_ratings);
if($average_diff >= 0.25 && $average_diff <= 0.75) {
$insert_half = ceil($post_ratings_average);
} elseif($average_diff > 0.75) {
$insert_half = ceil($post_ratings);
}
$post_ratings = intval($post_ratings);
// Display Start Of Rating Image
if(file_exists(ABSPATH.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_start.gif')) {
$post_ratings_images .= '.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_start.gif)
';
}
// Display Rated Images
$image_alt = $post_ratings_users.' '.__('votes', 'wp-postratings').', '.__('average', 'wp-postratings').': '.$post_ratings_average.' '.__('out of', 'wp-postratings').' '.$ratings_max;
for($i=1; $i <= $ratings_max; $i++) {
if($i <= $post_ratings) {
$post_ratings_images .= '.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_on.gif "'.$image_alt.'")
';
} elseif($i == $insert_half) {
$post_ratings_images .= '.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_half.gif "'.$image_alt.'")
';
} else {
$post_ratings_images .= '.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_off.gif "'.$image_alt.'")
';
}
}
// Display End Of Rating Image
if(file_exists(ABSPATH.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_end.gif')) {
$post_ratings_images .= '.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_end.gif)
';
}
// Display User Rated Text
$post_ratings_user_rated = '';
// Display The Contents
$template_postratings_text = stripslashes(get_settings('postratings_template_text'));
$template_postratings_text = str_replace("%RATINGS_IMAGES%", $post_ratings_images, $template_postratings_text);
$template_postratings_text = str_replace("%RATINGS_MAX%", $ratings_max, $template_postratings_text);
$template_postratings_text = str_replace("%RATINGS_SCORE%", $post_ratings_score, $template_postratings_text);
$template_postratings_text = str_replace("%RATINGS_USER_RATED%", $post_ratings_user_rated, $template_postratings_text);
$template_postratings_text = str_replace("%RATINGS_AVERAGE%", $post_ratings_average, $template_postratings_text);
$template_postratings_text = str_replace("%RATINGS_PERCENTAGE%", $post_ratings_percentage, $template_postratings_text);
$template_postratings_text = str_replace("%RATINGS_USERS%", number_format($post_ratings_users), $template_postratings_text);
// Return Post Ratings Template
return $template_postratings_text;
}
### Function: Display Ratings Vote
function the_ratings_vote($post_id, $new_user = 0, $new_score = 0, $new_average = 0) {
$ratings_image = get_settings('postratings_image');
$ratings_max = intval(get_settings('postratings_max'));
if($new_user == 0 && $new_score == 0 && $new_average == 0) {
$post_ratings = get_post_custom($post_id);
$post_ratings_users = $post_ratings['ratings_users'][0];
$post_ratings_score = $post_ratings['ratings_score'][0];
$post_ratings_average = $post_ratings['ratings_average'][0];
} else {
$post_ratings_users = $new_user;
$post_ratings_score = $new_score;
$post_ratings_average = $new_average;
}
$post_ratings_images = '';
if($post_ratings_score == 0 || $post_ratings_users == 0) {
$post_ratings = 0;
$post_ratings_average = 0;
$post_ratings_percentage = 0;
} else {
$post_ratings = round($post_ratings_average, 1);
$post_ratings_percentage = round((($post_ratings_score/$post_ratings_users)/$ratings_max) * 100, 2);
}
// Check For Half Star
$insert_half = 0;
$average_diff = abs(floor($post_ratings_average)-$post_ratings);
if($average_diff >= 0.25 && $average_diff <= 0.75) {
$insert_half = ceil($post_ratings_average);
} elseif($average_diff > 0.75) {
$insert_half = ceil($post_ratings);
}
$post_ratings = intval($post_ratings);
$postratings_ratingstext = get_settings('postratings_ratingstext');
// Display Start Of Rating Image
if(file_exists(ABSPATH.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_start.gif')) {
$post_ratings_images .= '';
}
// Display Rated Images
for($i=1; $i <= $ratings_max; $i++) {
$ratings_text = stripslashes($postratings_ratingstext[$i-1]);
if($i <= $post_ratings) {
$post_ratings_images .= '';
} elseif($i == $insert_half) {
$post_ratings_images .= '';
} else {
$post_ratings_images .= '';
}
}
// Display End Of Rating Image
if(file_exists(ABSPATH.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_end.gif')) {
$post_ratings_images .= '';
}
// Individual Post Ratings Text
$post_ratings_text = '';
// If No Ratings, Return No Ratings templae
if($post_ratings == 0) {
$template_postratings_none = stripslashes(get_settings('postratings_template_none'));
$template_postratings_none = str_replace("%RATINGS_IMAGES_VOTE%", $post_ratings_images, $template_postratings_none);
$template_postratings_none = str_replace("%RATINGS_MAX%", $ratings_max, $template_postratings_none);
$template_postratings_none = str_replace("%RATINGS_SCORE%", $post_ratings_score, $template_postratings_none);
$template_postratings_none = str_replace("%RATINGS_TEXT%", $post_ratings_text, $template_postratings_none);
$template_postratings_none = str_replace("%RATINGS_AVERAGE%", $post_ratings_average, $template_postratings_none);
$template_postratings_none = str_replace("%RATINGS_PERCENTAGE%", $post_ratings_percentage, $template_postratings_none);
$template_postratings_none = str_replace("%RATINGS_USERS%", $post_ratings_users, $template_postratings_none);
// Return Post Ratings Template
return $template_postratings_none;
} else {
// Display The Contents
$template_postratings_vote = stripslashes(get_settings('postratings_template_vote'));
$template_postratings_vote = str_replace("%RATINGS_IMAGES_VOTE%", $post_ratings_images, $template_postratings_vote);
$template_postratings_vote = str_replace("%RATINGS_MAX%", $ratings_max, $template_postratings_vote);
$template_postratings_vote = str_replace("%RATINGS_SCORE%", $post_ratings_score, $template_postratings_vote);
$template_postratings_vote = str_replace("%RATINGS_TEXT%", $post_ratings_text, $template_postratings_vote);
$template_postratings_vote = str_replace("%RATINGS_AVERAGE%", $post_ratings_average, $template_postratings_vote);
$template_postratings_vote = str_replace("%RATINGS_PERCENTAGE%", $post_ratings_percentage, $template_postratings_vote);
$template_postratings_vote = str_replace("%RATINGS_USERS%", number_format($post_ratings_users), $template_postratings_vote);
// Return Post Ratings Voting Template
return $template_postratings_vote;
}
}
### Function: Check Who Is Allow To Rate
function check_allowtorate() {
global $user_ID;
$user_ID = intval($user_ID);
$allow_to_vote = intval(get_settings('postratings_allowtorate'));
switch($allow_to_vote) {
// Guests Only
case 0:
if($user_ID > 0) {
return false;
}
return true;
break;
// Registered Users Only
case 1:
if($user_ID == 0) {
return false;
}
return true;
break;
// Registered Users And Guests
case 2:
default:
return true;
}
}
### Function: Check Whether User Have Rated For The Post
function check_rated($post_id) {
global $user_ID;
$postratings_logging_method = intval(get_settings('postratings_logging_method'));
switch($postratings_logging_method) {
// Do Not Log
case 0:
return false;
break;
// Logged By Cookie
case 1:
return check_rated_cookie($post_id);
break;
// Logged By IP
case 2:
return check_rated_ip($post_id);
break;
// Logged By Cookie And IP
case 3:
$rated_cookie = check_rated_cookie($post_id);
if($rated_cookie > 0) {
return true;
} else {
return check_rated_ip($post_id);
}
break;
// Logged By Username
case 4:
return check_rated_username($post_id);
break;
}
return false;
}
### Function: Check Rated By Cookie
function check_rated_cookie($post_id) {
// 0: False | > 0: True
return intval($_COOKIE["rated_$post_id"]);
}
### Function: Check Rated By IP
function check_rated_ip($post_id) {
global $wpdb;
// Check IP From IP Logging Database
$get_rated = $wpdb->get_var("SELECT rating_ip FROM $wpdb->ratings WHERE rating_postid = $post_id AND rating_ip = '".get_ipaddress()."'");
// 0: False | > 0: True
return intval($get_rated);
}
### Function: Check Rated By Username
function check_rated_username($post_id) {
global $wpdb, $user_ID;
$rating_userid = intval($user_ID);
// Check User ID From IP Logging Database
$get_rated = $wpdb->get_var("SELECT rating_userid FROM $wpdb->ratings WHERE rating_postid = $post_id AND rating_userid = $rating_userid");
// 0: False | > 0: True
return intval($get_rated);
}
### Function: Get IP Address
if(!function_exists('get_ipaddress')) {
function get_ipaddress() {
if (empty($_SERVER["HTTP_X_FORWARDED_FOR"])) {
$ip_address = $_SERVER["REMOTE_ADDR"];
} else {
$ip_address = $_SERVER["HTTP_X_FORWARDED_FOR"];
}
if(strpos($ip_address, ',') !== false) {
$ip_address = explode(',', $ip_address);
$ip_address = $ip_address[0];
}
return $ip_address;
}
}
### Function: Place Rating In Content
add_filter('the_content', 'place_ratings', 7);
function place_ratings($content){
$content = preg_replace( "/\[ratings\]/ise", "the_ratings('div', false)", $content);
return $content;
}
### Function: Display Most Rated Page/Post
if(!function_exists('get_most_rated')) {
function get_most_rated($mode = '', $limit = 10, $chars = 0, $display = true) {
global $wpdb, $post;
$where = '';
$temp = '';
if($mode == 'post') {
$where = "$wpdb->posts.post_status = 'publish'";
} elseif($mode == 'page') {
$where = "$wpdb->posts.post_status = 'static'";
} else {
$where = "($wpdb->posts.post_status = 'publish' OR $wpdb->posts.post_status = 'static')";
}
$most_rated = $wpdb->get_results("SELECT $wpdb->posts.ID, post_title, post_name, post_status, post_date, (meta_value+0.00) AS ratings_votes FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->postmeta.post_id = $wpdb->posts.ID WHERE post_date < '".current_time('mysql')."' AND $where AND meta_key = 'ratings_users' AND post_password = '' ORDER BY ratings_votes DESC LIMIT $limit");
if($most_rated) {
if($chars > 0) {
foreach ($most_rated as $post) {
$post_title = htmlspecialchars(stripslashes($post->post_title));
$post_votes = intval($post->ratings_votes);
$temp .= "".snippet_text($post_title, $chars)." - $post_votes ".__('Votes', 'wp-postratings')."\n";
}
} else {
foreach ($most_rated as $post) {
$post_title = htmlspecialchars(stripslashes($post->post_title));
$post_votes = intval($post->ratings_votes);
$temp .= "$post_title - $post_votes ".__('Votes', 'wp-postratings')."\n";
}
}
} else {
$temp = ''.__('N/A', 'wp-postratings').''."\n";
}
if($display) {
echo $temp;
} else {
return $temp;
}
}
}
### Function: Display Highest Rated Page/Post
if(!function_exists('get_highest_rated')) {
function get_highest_rated($mode = '', $limit = 10, $chars = 0, $display = true) {
global $wpdb, $post;
$ratings_image = get_settings('postratings_image');
$ratings_max = intval(get_settings('postratings_max'));
$where = '';
$temp = '';
$output = '';
if($mode == 'post') {
$where = "$wpdb->posts.post_status = 'publish'";
} elseif($mode == 'page') {
$where = "$wpdb->posts.post_status = 'static'";
} else {
$where = "($wpdb->posts.post_status = 'publish' OR $wpdb->posts.post_status = 'static')";
}
$highest_rated = $wpdb->get_results("SELECT $wpdb->posts.ID, $wpdb->posts.post_title, $wpdb->posts.post_name, $wpdb->posts.post_status, $wpdb->posts.post_date, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM $wpdb->posts LEFT JOIN $wpdb->postmeta AS t1 ON t1.post_id = $wpdb->posts.ID LEFT JOIN $wpdb->postmeta As t2 ON t1.post_id = t2.post_id WHERE t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' AND $wpdb->posts.post_password = '' AND $wpdb->posts.post_date < '".current_time('mysql')."' AND $where ORDER BY ratings_average DESC, ratings_users DESC LIMIT $limit");
if($highest_rated) {
foreach($highest_rated as $post) {
// Variables
$post_ratings_users = $post->ratings_users;
$post_ratings_images = '';
$post_title = htmlspecialchars(stripslashes($post->post_title));
$post_ratings_average = $post->ratings_average;
$post_ratings_whole = intval($post_ratings_average);
$post_ratings = floor($post_ratings_average);
// Check For Half Star
$insert_half = 0;
$average_diff = $post_ratings_average-$post_ratings_whole;
if($average_diff >= 0.25 && $average_diff <= 0.75) {
$insert_half = $post_ratings_whole+1;
} elseif($average_diff > 0.75) {
$post_ratings = $post_ratings+1;
}
// Display Start Of Rating Image
if(file_exists(ABSPATH.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_start.gif')) {
$post_ratings_images .= '';
}
// Display Rated Images
for($i=1; $i <= $ratings_max; $i++) {
if($i <= $post_ratings) {
$post_ratings_images .= '';
} elseif($i == $insert_half) {
$post_ratings_images .= '';
} else {
$post_ratings_images .= '';
}
}
// Display End Of Rating Image
if(file_exists(ABSPATH.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_end.gif')) {
$post_ratings_images .= '';
}
if($chars > 0) {
$temp = "".snippet_text($post_title, $chars)." ".$post_ratings_images."\n";
} else {
// Display The Contents
$temp = stripslashes(get_settings('postratings_template_highestrated'));
$temp = str_replace("%RATINGS_IMAGES%", $post_ratings_images, $temp);
$temp = str_replace("%RATINGS_MAX%", $ratings_max, $temp);
$temp = str_replace("%RATINGS_AVERAGE%", $post_ratings_average, $temp);
$temp = str_replace("%RATINGS_USERS%", number_format($post_ratings_users), $temp);
$temp = str_replace("%POST_TITLE%", $post_title, $temp);
$temp = str_replace("%POST_URL%", get_permalink(), $temp);
}
$output .= $temp;
}
} else {
$output = ''.__('N/A', 'wp-postratings').''."\n";
}
if($display) {
echo $output;
} else {
return $output;
}
}
}
### Function: Display Total Rating Votes
if(!function_exists('get_ratings_votes')) {
function get_ratings_votes($display = true) {
global $wpdb;
$ratings_votes = $wpdb->get_var("SELECT SUM(CAST(meta_value AS UNSIGNED)) FROM $wpdb->postmeta WHERE meta_key = 'ratings_score'");
if($display) {
echo number_format($ratings_votes);
} else {
return number_format($ratings_votes);
}
}
}
### Function: Display Total Rating Users
if(!function_exists('get_ratings_users')) {
function get_ratings_users($display = true) {
global $wpdb;
$ratings_users = $wpdb->get_var("SELECT SUM(CAST(meta_value AS UNSIGNED)) FROM $wpdb->postmeta WHERE meta_key = 'ratings_users'");
if($display) {
echo number_format($ratings_users);
} else {
return number_format($ratings_users);
}
}
}
### Function: Snippet Text
if(!function_exists('snippet_chars')) {
function snippet_chars($text, $length = 0) {
$text = htmlspecialchars_decode($text);
if (strlen($text) > $length){
return htmlspecialchars(substr($text,0,$length)).'...';
} else {
return htmlspecialchars($text);
}
}
}
### Function: HTML Special Chars Decode
if (!function_exists('htmlspecialchars_decode')) {
function htmlspecialchars_decode($text) {
return strtr($text, array_flip(get_html_translation_table(HTML_SPECIALCHARS)));
}
}
### Function: Process Ratings
process_ratings();
function process_ratings() {
global $wpdb, $user_identity, $user_ID;
$ratings_max = intval(get_settings('postratings_max'));
$rate = intval($_GET['rate']);
$post_id = intval($_GET['pid']);
if($rate > 0 && $post_id > 0 && check_allowtorate()) {
header('Content-Type: text/html; charset='.get_option('blog_charset'));
// Check For Bot
$bots_useragent = array('googlebot', 'google', 'msnbot', 'ia_archiver', 'lycos', 'jeeves', 'scooter', 'fast-webcrawler', 'slurp@inktomi', 'turnitinbot', 'technorati', 'yahoo', 'findexa', 'findlinks', 'gaisbo', 'zyborg', 'surveybot', 'bloglines', 'blogsearch', 'ubsub', 'syndic8', 'userland', 'gigabot', 'become.com');
$useragent = $_SERVER['HTTP_USER_AGENT'];
foreach ($bots_useragent as $bot) {
if (stristr($useragent, $bot) !== false) {
return;
}
}
$rated = check_rated($post_id);
// Check Whether Post Has Been Rated By User
if(!$rated) {
// Check Whether Is There A Valid Post
$post = get_post($post_id);
// If Valid Post Then We Rate It
if($post) {
$post_title = addslashes($post->post_title);
$post_ratings = get_post_custom($post_id);
$post_ratings_users = intval($post_ratings['ratings_users'][0]);
$post_ratings_score = intval($post_ratings['ratings_score'][0]);
// Check For Ratings Lesser Than 1 And Greater Than $ratings_max
if($rate < 1 || $rate > $ratings_max) {
$rate = 0;
}
// Add Ratings
if($post_ratings_users == 0 && $post_ratings_score == 0) {
$post_ratings_users = 1;
$post_ratings_score = $rate;
$post_ratings_average = round($rate/1, 2);
add_post_meta($post_id, 'ratings_users', 1);
add_post_meta($post_id, 'ratings_score', $rate);
add_post_meta($post_id, 'ratings_average',$post_ratings_average);
// Update Ratings
} else {
$post_ratings_users = ($post_ratings_users+1);
$post_ratings_score = ($post_ratings_score+$rate);
$post_ratings_average = round($post_ratings_score/$post_ratings_users, 2);
update_post_meta($post_id, 'ratings_users', $post_ratings_users);
update_post_meta($post_id, 'ratings_score', $post_ratings_score);
update_post_meta($post_id, 'ratings_average', $post_ratings_average);
}
// Add Log
if(!empty($user_identity)) {
$rate_user = addslashes($user_identity);
} elseif(!empty($_COOKIE['comment_author_'.COOKIEHASH])) {
$rate_user = addslashes($_COOKIE['comment_author_'.COOKIEHASH]);
} else {
$rate_user = __('Guest', 'wp-postratings');
}
$rate_userid = intval($user_ID);
// Only Create Cookie If User Choose Logging Method 1 Or 3
$postratings_logging_method = intval(get_settings('postratings_logging_method'));
if($postratings_logging_method == 1 || $postratings_logging_method == 3) {
$rate_cookie = setcookie("rated_".$post_id, 1, time() + 30000000, COOKIEPATH);
}
// Log Ratings No Matter What
$rate_log = $wpdb->query("INSERT INTO $wpdb->ratings VALUES (0, $post_id, '$post_title', $rate,'".current_time('timestamp')."', '".get_ipaddress()."', '".gethostbyaddr(get_ipaddress())."' ,'$rate_user', $rate_userid)");
// Output AJAX Result
echo the_ratings_results($post_id, $post_ratings_users, $post_ratings_score, $post_ratings_average);
exit();
} else {
printf(__('Invalid Post ID. Post ID #%s.', 'wp-postratings'), $post_id);
exit();
} // End if($post)
} else {
printf(__('You Had Already Rated This Post. Post ID #%s.', 'wp-postratings'), $post_id);
exit();
}// End if(!$rated)
} // End if($rate && $post_id && check_allowtorate())
}
### Function: Create Rating Logs Table
add_action('activate_postratings/postratings.php', 'create_ratinglogs_table');
function create_ratinglogs_table() {
global $wpdb;
include_once(ABSPATH.'/wp-admin/upgrade-functions.php');
// Create Post Ratings Table
$create_ratinglogs_sql = "CREATE TABLE $wpdb->ratings (".
"rating_id INT(11) NOT NULL auto_increment,".
"rating_postid INT(11) NOT NULL ,".
"rating_posttitle TEXT NOT NULL,".
"rating_rating INT(2) NOT NULL ,".
"rating_timestamp VARCHAR(15) NOT NULL ,".
"rating_ip VARCHAR(40) NOT NULL ,".
"rating_host VARCHAR(200) NOT NULL,".
"rating_username VARCHAR(50) NOT NULL,".
"rating_userid int(10) NOT NULL default '0',".
"PRIMARY KEY (rating_id))";
maybe_create_table($wpdb->ratings, $create_ratinglogs_sql);
// Add In Options (4 Records)
add_option('postratings_image', 'stars', 'Your Ratings Image');
add_option('postratings_max', '5', 'Your Max Ratings');
add_option('postratings_template_vote', '%RATINGS_IMAGES_VOTE% (%RATINGS_USERS% '.__('votes', 'wp-postratings').', '.__('average', 'wp-postratings').': %RATINGS_AVERAGE% '.__('out of', 'wp-postratings').' %RATINGS_MAX%)
%RATINGS_TEXT%', 'Ratings Vote Template Text');
add_option('postratings_template_text', '%RATINGS_IMAGES% (%RATINGS_USERS% '.__('votes', 'wp-postratings').', '.__('average', 'wp-postratings').': %RATINGS_AVERAGE% '.__('out of', 'wp-postratings').' %RATINGS_MAX%)', 'Ratings Template Text');
add_option('postratings_template_none', '%RATINGS_IMAGES_VOTE% ('.__('No Ratings Yet', 'wp-postratings').')
%RATINGS_TEXT%', 'Ratings Template For No Ratings');
// Database Upgrade For WP-PostRatings 1.02
add_option('postratings_logging_method', '3', 'Logging Method Of User Rated\'s Answer');
add_option('postratings_allowtorate', '2', 'Who Is Allowed To Rate');
// Database Uprade For WP-PostRatings 1.04
maybe_add_column($wpdb->ratings, 'rating_userid', "ALTER TABLE $wpdb->ratings ADD rating_userid INT( 10 ) NOT NULL DEFAULT '0';");
// Database Uprade For WP-PostRatings 1.05
add_option('postratings_ratingstext', array(__('1 Star', 'wp-postratings'), __('2 Stars', 'wp-postratings'), __('3 Stars', 'wp-postratings'), __('4 Stars', 'wp-postratings'), __('5 Stars', 'wp-postratings')), 'Individual Post Rating Text');
add_option('postratings_template_highestrated', '%POST_TITLE% %RATINGS_IMAGES% (%RATINGS_AVERAGE% '.__('out of', 'wp-postratings').' %RATINGS_MAX%)', 'Template For Highest Rated');
// Set 'manage_ratings' Capabilities To Administrator
$role = get_role('administrator');
if(!$role->has_cap('manage_ratings')) {
$role->add_cap('manage_ratings');
}
}
?>