do_sql('approval', $send, 'delete', $mysqli, $where); } else { // inserting a vote $send['app_position_id'] = $pos_id; $send['app_people_id'] = $_SESSION['id']; do_sql('approval', $send, 'insert', $mysqli); } // update top role // fetching user id $getUID = $mysqli->prepare('SELECT position_people_id FROM position WHERE position_id=? ') or die('Couldn\'t check the userid'); $getUID->bind_param('s', $pos_id); $getUID->execute(); $getUID->store_result(); $getUID->bind_result($user_id); while ($getUID->fetch()) { $top_role = get_top_role($user_id, $mysqli); } } break; case 'blog_add': if ($_POST['submit'] == 'Save & Publish') { $send['blog_final'] = '1'; } if ($_POST['submit'] == 'Save') { $send['blog_final'] = '0'; } $send['blog_by'] = $_SESSION['id']; $send['blog_title'] = htmlentities($_POST['blog_title']); $send['blog_created'] = date("Y-m-d H:i:s"); /** ------------------------------------------image digestion starts---------------------------------------- **/ // separating out all image tags
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); } }