function role_update($mysqli) { include 'db-config.php'; // get the person for whom this position as meant to be $getPosName = $mysqli->prepare('SELECT position_lastUpdate,position_id,position_code,position_people_id FROM position WHERE 1') or die('Couldn\'t check the vote.'); $getPosName->execute(); $getPosName->store_result(); $getPosName->bind_result($pos_last_updates, $pos_id, $pos_code, $pos_ppl); $base = 0; while ($getPosName->fetch()) { $pos_deletion_score = get_deletion_on_position($pos_id, $mysqli); $then = strtotime($pos_last_updates); $now = time(); $diff = $now - $then; $year_diff = date('Y', $diff); $mon_diff = date('n', $diff); $day_diff = date('j', $diff); // checking if 7 days have expired since last update if ($year_diff > 1970 || $mon_diff > 1) { $day_diff = 8; } if ($day_diff > $expiry_days && is_role_active($pos_id, $mysqli) || $pos_deletion_score > $position_deletion_ceil) { // check if he is active or his deletion status is high $sql = "DELETE FROM position WHERE position_id='" . $pos_id . "'"; // delete from positions if ($mysqli->query($sql) === false) { trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $mysqli->error, E_USER_ERROR); } else { $affected_rows = $mysqli->affected_rows; } $sql = "DELETE FROM approval WHERE app_position_id='" . $pos_id . "'"; // delete from approvals if ($mysqli->query($sql) === false) { trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $mysqli->error, E_USER_ERROR); } else { $affected_rows = $mysqli->affected_rows; } } } // Updating the topCode $getPplName = $mysqli->prepare('SELECT people_id FROM people WHERE people_archive=0') or die('Couldn\'t check the ppl.'); $getPplName->execute(); $getPplName->store_result(); $getPplName->bind_result($ppl_id); while ($getPplName->fetch()) { $where['people_id'] = $ppl_id; $upd['people_topCode'] = get_top_role($ppl_id, $mysqli); do_sql('people', $upd, 'update', $mysqli, $where); } }
<th> Name </th> <th> Edit Profile</th> <th> Roles </th> <th> Delete </th> <th> Last Login </th> </tr> </thead> '; $i = 0; while ($getInfo->fetch()) { $roles_edit = '<a href="#" class= "" data-toggle="modal" data-target="#positions_modal" title="Edit" onclick="getPosition(' . $id . ',\'' . $name . '\');" ><span class="fa fa-star"></span></a>'; // remove add role for user himself if ($id == $_SESSION['id']) { $roles_edit = '<span class="fa fa-times"></span>'; } $deletionScore = get_deletion_on_position($id, $mysqli); // check if deletion flag has been put $exclaim = '<tr>'; $alert_del = ''; if ($deletionScore > $people_deletion_ceil - 0.3) { $exclaim = '<tr class="alert alert-danger">'; $alert_del = '<p><small style="color:red;">Marked for deletion with a high vote.</small>'; } // check if the person has made a delete request $getDel = $mysqli->prepare('SELECT deletion_tbl_id FROM deletion WHERE deletion_people_id=? AND deletion_tbl=? AND deletion_tbl_id=?') or die('Couldn\'t check the deletion'); $tbl = 'people'; $getDel->bind_param('sss', $_SESSION['id'], $tbl, $id); $getDel->execute(); $getDel->store_result(); $countRows = $getDel->num_rows; if ($countRows == 0) {