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 '
'; }else{ echo ' '; } } 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 "Your review was posted successfully!
Please enter some content to post.