Class.php (Database checks here)

<?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>


        ';


    }








}


?>