include $phpbb_root_path . 'extension.inc';
include $phpbb_root_path . 'common.' . $phpEx;
include_once $phpbb_root_path . 'adr/includes/adr_global.' . $phpEx;
//
// Start session management
$userdata = session_pagestart($user_ip, PAGE_ADR);
init_userprefs($userdata);
// End session management
//
adr_template_file('adr_cell_body.tpl');
include_once $phpbb_root_path . 'includes/page_header.' . $phpEx;
$user_id = $userdata['user_id'];
$caution = $userdata['user_cell_caution'];
$pay = isset($HTTP_POST_VARS['submit']);
// Update the time sentence
adr_cell_update_users();
if ($pay) {
$sql = "UPDATE " . ADR_JAIL_USERS_TABLE . " \r\n\t\tSET user_freed_by = {$user_id}\r\n\t\tWHERE user_id = {$user_id} ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, "", __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM " . ADR_JAIL_VOTES_TABLE . " \r\n\t\tWHERE vote_id = {$user_id} ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, "", __LINE__, __FILE__, $sql);
}
$sql = "UPDATE " . USERS_TABLE . " \r\n\t\tSET user_points = user_points - {$caution} ,\r\n\t\tuser_cell_time = 0 ,\r\n\t\tuser_cell_time_judgement = 0 ,\r\n\t\tuser_cell_enable_caution = 0,\r\n\t\tuser_cell_enable_free = 0,\r\n\t\tuser_cell_sentence = '',\r\n\t\tuser_cell_caution = 0\r\n\t\tWHERE user_id = {$user_id} ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, "", __LINE__, __FILE__, $sql);
}
message_die(GENERAL_MESSAGE, $lang['Adr_cell_free']);
}
$sql = "SELECT * FROM " . USERS_TABLE . "\n\t\tWHERE user_cell_time > 0\n\t\tORDER BY username";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not obtain celled list', '', __LINE__, __FILE__, $sql);
}
$celleds = $db->sql_fetchrowset($result);
$sql = array();
while (list(, $celled) = @each($celleds)) {
if (isset($_POST[$celled['user_id']])) {
adr_cell_free_user($celled['user_id'], 2);
}
}
adr_previous(Adr_cell_admin_uncelled_ok, admin_adr_cell_users, '');
} else {
if ($manual_update) {
$free = '';
$free = adr_cell_update_users();
$free = $free == '' ? $lang['None'] : $free;
message_die(GENERAL_MESSAGE, $lang['Adr_cell_admin_celled_manual_update_ok'] . '<br />' . $free);
} else {
$sql = "SELECT * FROM " . USERS_TABLE . "\n\t\tWHERE user_cell_time > 0\n\t\tAND user_id > 1\n\t\tORDER by username";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not obtain celled list', '', __LINE__, __FILE__, $sql);
}
$celled = $db->sql_fetchrowset($result);
for ($i = 0; $i < count($celled); $i++) {
$user_id = $celled[$i]['user_id'];
$template->assign_block_vars('celled', array('CELLED_ID' => $celled[$i]['user_id'], 'CELLED_NAME' => $celled[$i]['username'], 'CELLED_SENTENCE' => $celled[$i]['user_cell_sentence'], 'CELLED_TIME' => adr_make_time($celled[$i]['user_cell_time']), 'CELLED_CAUTION' => $celled[$i]['user_cell_caution'], 'U_EDIT' => append_sid("admin_adr_cell_users.{$phpEx}?from=list&id=" . $user_id . "")));
}
}
}
}