INNER JOIN people ppl ON pos.position_addedBy = ppl.people_id WHERE pos.position_people_id=?') or die('Couldn\'t check the profile'); $getInfo->bind_param('s', $id); $getInfo->execute(); $getInfo->store_result(); $getInfo->bind_result($pid, $pname, $pcode, $padded, $ppl_id); $pos_rows = '<table class="table"><thead> <tr> <th> Name </th> <th> Added By</th> <th> Vote </th> </tr> </thead> '; while ($getInfo->fetch()) { // votes $pscore = get_percent_on_position($pid, $mysqli, $ppl_id); $res = check_vote($pid, $mysqli); if (!$res['voted']) { $vote_td = '<td>' . '<a href="#" onclick="vote_up_dn(\'' . $pid . '\');" ><span class="fa fa-arrow-up"></span></a> <b>' . $pscore * 100 . '%</b>' . '</td>'; } else { if ($res['voted'] == 1) { $vote_td = '<td>' . '<a href="#" onclick="vote_up_dn(\'' . $pid . '\');" ><span class="fa fa-arrow-down"></span></a> <b>' . $pscore * 100 . '%</b>' . '</td>'; } else { $vote_td = '<td><b>' . $pscore * 100 . '%</b></td>'; } } // check whether eligible $active = is_role_active($pid, $mysqli, $ppl_id); if ($active) { $tr = '<tr>'; } else {
function is_role_active($app_pos_id, $mysqli, $ppl_id) { include 'db-config.php'; // get the person for whom this position as meant to be $getPos = $mysqli->prepare('SELECT position_code FROM position WHERE position_id=?') or die('Couldn\'t check the vote.'); $getPos->bind_param('s', $app_pos_id); // getting whether this person as voted for the position or not $getPos->execute(); $getPos->store_result(); $getPos->bind_result($pos_code); $app_score = get_percent_on_position($app_pos_id, $mysqli, $ppl_id); while ($getPos->fetch()) { if ($app_score >= $min_score[$pos_code]) { return 1; } else { return 0; } } }