<?php
global $wpdb;
$wpdb->query("ALTER TABLE ".$wpdb->prefix."bp_activity
ADD star int(11)");
$wpdb->query("ALTER TABLE ".$wpdb->prefix."bp_activity
ADD usercheck int(11)");
function setupdata_depro($user_id,$component,$type,$action,$content,$primary_link,$item_id,$secondary_item_id,$date_recorded,$hide_sitewide,$mptt_left,$mptt_right,$star,$usercheck){
global $wpdb;
$wpdb->query( $wpdb->prepare(
"
INSERT INTO ".$wpdb->prefix."bp_activity
( user_id, component, type ,action, content, primary_link, item_id, secondary_item_id, date_recorded, hide_sitewide, mptt_left, mptt_right,star,usercheck)
VALUES ( %d, %s, %s ,%s, %s ,%s, %s ,%s, %s ,%s, %s ,%s,%s,%s)
",
array(
$user_id,
$component,
$type,
$action,
$content,
$primary_link,
$item_id,
$secondary_item_id,
$date_recorded,
$hide_sitewide,
$mptt_left,
$mptt_right,
$star,
$usercheck
)
) );
}
add_action('bp_member_options_nav','deprohoang_add_style');
function deprohoang_add_style(){
echo '<style type="text/css">.Member_review{display:none;}</style>';
}
$options = get_option('reviews_options');
if($options['profile'] == "profile"){
add_action('bp_after_member_header','add_star_loop_header');
add_action('bp_directory_members_actions','add_star_loop_content');
function add_star_loop_header(){
return add_star_loop(2);
}
function add_star_loop_content(){
return add_star_loop(1);
}
function add_star_loop($checkitem){
global $wpdb;
if($checkitem == 1){
$check_content_loop = $wpdb->get_results("SELECT AVG(star) AS Average FROM ".$wpdb->prefix."bp_activity WHERE type = 'Member_review' AND usercheck='".bp_get_member_user_id()."'");
$check_content_loop_count = $wpdb->get_col("SELECT star FROM ".$wpdb->prefix."bp_activity WHERE type = 'Member_review' AND usercheck='".bp_get_member_user_id()."'");
}else{
$check_content_loop = $wpdb->get_results("SELECT AVG(star) AS Average FROM ".$wpdb->prefix."bp_activity WHERE type = 'Member_review' AND usercheck='".bp_displayed_user_id()."'");
$check_content_loop_count = $wpdb->get_col("SELECT star FROM ".$wpdb->prefix."bp_activity WHERE type = 'Member_review' AND usercheck='".bp_displayed_user_id()."'");
}
if($check_content_loop[0]->Average != ""){
$check_show_star_loop = $check_content_loop[0]->Average;
$demss = 0;
echo '<span class="rating-top" style="position:relative;top:-10px"> ';
for($dem = 1; $dem < 6 ; $dem ++){
if($dem <= $check_show_star_loop ){
echo '<img alt="1 star" src="'.DEPROURL.'/images/star.png">';
}else{
$demss++;
if(ceil($check_show_star_loop)- $check_show_star_loop > 0 and $demss == 1){
echo '<img alt="1 star" src="'.DEPROURL.'/images/star_half.png">';
}else{
echo '<img alt="1 star" src="'.DEPROURL.'/images/star_off.png">';
}
}
}
echo ' (Based on '.count($check_content_loop_count).' reviews)</span>';
}else{
echo '<span class="rating-top" style="position:relative;top:-5px;font-weight:bold">No Reviews</span>';
}
}
add_action('bp_member_options_nav','deprohoang_add');
function deprohoang_add(){
if(isset($_GET['review'])){
$check = $_GET['review'];
}
if($check == "true"){
$addclass = "class='supper_current supper_selected supper_deproadd'";
}else{
$addclass = "class='supper_deproadd'";
}
echo "<li ".$addclass." ><a href='".get_bloginfo('home')."/members/".bp_core_get_username(bp_displayed_user_id())."/?review=true'>Reviews</a></li>";
require_once('css/customstylememberone.php');
}
add_action('bp_before_member_body','deprohoang_addbody');
function deprohoang_addbody(){
if(isset($_GET['review'])){
$check = $_GET['review'];
}else{
$check = "";
}
if($check == "true"){
require_once('css/customstylemembertwo.php');
require_once('function/postreviewform.php');
?>
<?php
}
}
if(isset($_POST['review_member_submit'])){
if(isset($_POST['review_member_content']) and $_POST['review_member_content'] != ""){
add_action('template_notices','add_title_here_success');
$current_user = wp_get_current_user();
$user_reviewd = $_POST['rating_member_id'];
$user_reviewd_name = $_POST['rating_member_name'];
$avartar_reviewd = "";
$link_set = get_bloginfo('home')."/members/".$current_user->user_login;
$rating_member = $_POST['rating_member'];
$contentss.='<span class="ratingtop">';
for($dem = 1; $dem < 6 ; $dem ++){
if($dem <= $rating_member ){
$contentss.= '<img alt="1 star" src="'.DEPROURL.'/images/star.png">';
}else{
$contentss.='<img alt="1 star" src="'.DEPROURL.'/images/star_off.png">';
}
}
$contentss.='</span>';
$user_id = $current_user->ID;
$component = "Members";
$type = "Member_review";
$action = "<a href='".$link_set."' title='".$current_user->user_login."'>".$current_user->user_login."</a> posted an Review ".$avartar_reviewd." <a href='".get_bloginfo('home')."/members/".$user_reviewd_name."'>".$user_reviewd_name."</a>";
$content = $contentss.$_POST['review_member_content'];
$primary_link = $link_set ;
$item_id = "";
$secondary_item_id = "";
$date_recorded = date('Y-m-d H:i:s ');
$hide_sitewide = 0;
$mptt_left = 0;
$mptt_right = 0;
$star = $rating_member;
$usercheck = $user_reviewd;
setupdata_depro($user_id,$component,$type,$action,$content,$primary_link,$item_id,$secondary_item_id,$date_recorded,$hide_sitewide,$mptt_left,$mptt_right,$star,$usercheck);
$setcheckoption = $user_id."-".$usercheck;
$checkfirst = get_option($setcheckoption);
if($checkfirst){
update_option( $setcheckoption, $checkfirst + 1 );
}else{
add_option( $setcheckoption, 1, '', 'yes' );
}
}else{
add_action('template_notices','add_title_here_error');
}
}
function add_title_here_success(){
echo '
<div id="message" class="updated">
<p>Your review was posted successfully!</p>
</div>
';
}
function add_title_here_error(){
echo '
<div id="message" class="error" style="display: block;">
<p>Please enter some content to post.</p>
</div>
';
}
}
?>