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 ''; } $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 ' '; for($dem = 1; $dem < 6 ; $dem ++){ if($dem <= $check_show_star_loop ){ echo '1 star'; }else{ $demss++; if(ceil($check_show_star_loop)- $check_show_star_loop > 0 and $demss == 1){ echo '1 star'; }else{ echo '1 star'; } } } echo ' (Based on '.count($check_content_loop_count).' reviews)'; }else{ echo 'No Reviews'; } } 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 "
  • Reviews
  • "; 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'); ?> user_login; $rating_member = $_POST['rating_member']; $contentss.=''; for($dem = 1; $dem < 6 ; $dem ++){ if($dem <= $rating_member ){ $contentss.= '1 star'; }else{ $contentss.='1 star'; } } $contentss.=''; $user_id = $current_user->ID; $component = "Members"; $type = "Member_review"; $action = "".$current_user->user_login." posted an Review ".$avartar_reviewd." ".$user_reviewd_name.""; $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 '

    Your review was posted successfully!

    '; } function add_title_here_error(){ echo '

    Please enter some content to post.

    '; } } ?>