## Удаление пользователей ##
############################################################################################
case "del":
$uid = check($_GET['uid']);
$deldate = abs(intval($_GET['deldate']));
$point = abs(intval($_GET['point']));
if ($uid == $_SESSION['token']) {
if ($deldate >= 180) {
$deltime = $deldate * 24 * 3600;
$queryusers = DB::run()->query("SELECT users_login FROM users WHERE users_timelastlogin<? AND users_point<=?;", array(SITETIME - $deltime, $point));
$users = $queryusers->fetchAll(PDO::FETCH_COLUMN);
$total = count($users);
if ($total > 0) {
foreach ($users as $value) {
delete_album($value);
delete_users($value);
}
echo 'Пользователи не посещавшие сайт более <b>' . $deldate . '</b> дней, успешно удалены!<br />';
echo 'Было удалено пользователей: <b>' . $total . '</b><br /><br />';
} else {
show_error('Пользователи для удаления отсутсвуют!');
}
} else {
show_error('Ошибка! Указанно недопустимое время для удаления!');
}
} else {
show_error('Ошибка! Неверный идентификатор сессии, повторите действие!');
}
echo '<img src="/images/img/back.gif" alt="image" /> <a href="delusers.php">Вернуться</a><br />';
break;
default:
show_admin_header();
if ($action == "deleteuser") {
$deleteusers = isset($HTTP_POST_VARS['deleteusers']) ? $HTTP_POST_VARS['deleteusers'] : array();
$delcomments = intval($HTTP_POST_VARS['delcomments']);
$delimages = intval($HTTP_POST_VARS['delimages']);
$user_ids = "";
if (!empty($deleteusers)) {
foreach ($deleteusers as $val) {
$user_ids .= ($user_ids != "" ? ", " : "") . $val;
}
}
$lang_key = sizeof($deleteusers) > 1 ? 'users' : 'user';
show_table_header($lang[$lang_key], 1);
echo "<tr><td class=\"tablerow\">\n";
echo "<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\"><tr><td> </td><td>\n";
$error_log = delete_users($user_ids, $delcomments, $delimages);
echo "</td></tr></table>\n";
echo "</td></tr>\n";
show_table_footer();
if ($error_log) {
show_table_header("Error Log:", 1);
echo "<tr><td class=\"tablerow\">\n";
echo "<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\"><tr><td> </td><td>\n";
echo "<b>" . $lang['error_log_desc'] . "</b>\n<ul>\n";
foreach ($error_log as $val) {
echo "<li>" . $val . "</li>\n";
}
echo "</ul>\n</td></tr></table>\n";
echo "</td></tr>\n";
show_table_footer();
}
$dbc = mysql_connect('localhost', 'root', 'rishi');
if (!$dbc) {
die('NOT CONNECTED:' . mysql_error());
}
$db_selected = mysql_select_db("restaurant", $dbc);
if (!$db_selected) {
die('NOT CONNECTED TO DATABASE:' . mysql_error());
}
if (empty($user_id)) {
echo "<script type=\"text/javascript\">" . "\n";
echo "alert(\"No Users Selected!!!\");" . "\n";
echo "</script>" . "\n";
echo "<meta HTTP-EQUIV=\"REFRESH\" content=\"0; url=admin.html\">" . "\n";
} else {
$num_users = count($user_id);
for ($i = 0; $i < $num_users; $i++) {
$query = "DELETE FROM USER WHERE User_Id = {$user_id[$i]};";
mysql_query($query);
}
echo "<script type=\"text/javascript\">" . "\n";
echo "alert(\"Selected Users Deleted!!!\");" . "\n";
echo "</script>" . "\n";
echo "<meta HTTP-EQUIV=\"REFRESH\" content=\"0; url=admin.html\">" . "\n";
}
}
delete_users($_POST["user"]);
?>
</html>
</body>
</html>
require_once 'include/lib/fileManageLib.inc.php';
load_js('bootstrap-datepicker');
$head_content .= "\n<script type='text/javascript'>\n\$(function() {\n\$('#before_date').datepicker({\n format: 'dd-mm-yyyy',\n language: '" . $language . "',\n autoclose: true\n });\n});\n</script>";
$toolName = $langCourseInfo;
$pageName = $langRefreshCourse;
$navigation[] = array('url' => "index.php?course={$course_code}", 'name' => $langCourseInfo);
if (isset($_POST['submit'])) {
$tool_content .= action_bar(array(array('title' => $langBack, 'url' => "refresh_course?course={$course_code}", 'icon' => 'fa-reply', 'level' => 'primary')));
$output = array();
if (isset($_POST['delusers'])) {
if (isset($_POST['before_date'])) {
$date_obj = DateTime::createFromFormat('d-m-Y', $_POST['before_date']);
$date = $date_obj->format('Y-m-d');
$output[] = delete_users(q($date));
} else {
$output[] = delete_users();
}
}
if (isset($_POST['delannounces'])) {
$output[] = delete_announcements();
}
if (isset($_POST['delagenda'])) {
$output[] = delete_agenda();
}
if (isset($_POST['hideworks'])) {
$output[] = hide_work();
}
if (isset($_POST['delworkssubs'])) {
$output[] = del_work_subs();
}
if (isset($_POST['purgeexercises'])) {
restatement('blog');
}
if (!empty($delcommload)) {
DB::run()->query("DELETE FROM `commload` WHERE `commload_author`=?;", array($uz));
restatement('load');
}
if (!empty($delcommphoto)) {
DB::run()->query("DELETE FROM `commphoto` WHERE `commphoto_user`=?;", array($uz));
restatement('gallery');
}
if (!empty($delcommnews)) {
DB::run()->query("DELETE FROM `commnews` WHERE `commnews_author`=?;", array($uz));
restatement('news');
}
// Удаление профиля
delete_users($uz);
echo '<img src="/images/img/open.gif" alt="image" /> <b>Профиль пользователя успешно удален!</b><br /><br />';
} else {
show_error('Ошибка! У вас недостаточно прав для удаления этого профиля!');
}
} else {
show_error('Ошибка! Пользователя с данным логином не существует!');
}
} else {
show_error('Ошибка! Неверный идентификатор сессии, повторите действие!');
}
echo '<img src="/images/img/back.gif" alt="image" /> <a href="users.php">Вернуться</a><br />';
break;
default:
redirect("users.php");
}
}
// adding default media as well as album
User_Registration::add_default_media($_REQUEST['uid'], '', PA::$network_info);
User_Registration::add_default_media($_REQUEST['uid'], '_audio', PA::$network_info);
User_Registration::add_default_media($_REQUEST['uid'], '_video', PA::$network_info);
User_Registration::add_default_blog($_REQUEST['uid']);
//adding default link categories & links
User_Registration::add_default_links($_REQUEST['uid']);
$message = __('Status of selected user(s) updated successfully');
} catch (CNException $e) {
$message = $e->message;
}
break;
case 'delete':
require_once "api/Activities/Activities.php";
$message_array = delete_users($params);
if ($message_array == null) {
$_GET['msg'] = '7020';
} else {
$message = __('An error has occured on deleting users.') . implode(',', $message_array) . '';
}
break;
}
}
}
function setup_module($column, $module, $obj)
{
global $paging, $super_user_and_mothership;
switch ($module) {
case 'NetworkResultUserModule':
if (@$_GET['keyword']) {
<?php
// ワンタイムトークン
if (!token('check')) {
error('不正なアクセスです。');
}
// トランザクションを開始
db_transaction();
// ユーザを削除
$resource = delete_users(array('where' => array('id = :id', array('id' => $_SESSION['auth']['user']['id']))), array('associate' => true));
if (!$resource) {
error('データを削除できません。');
}
// トランザクションを終了
db_commit();
// 認証セッションを初期化
unset($_SESSION['auth']['user']);
// リダイレクト
redirect('/user/delete_complete');
case 'new':
user_form();
break;
case 'edit':
user_form(true);
break;
case 'save':
save_data();
break;
case 'saveedit':
save_data(true);
break;
case 'mailer':
show_mailer();
break;
case 'sendmail':
send_mail();
break;
case 'deactivate':
activate_users(0);
break;
case 'activate':
activate_users(1);
break;
case 'delete':
delete_users();
break;
default:
show_users();
break;
}
<?php
// ワンタイムトークン
if (!token('check')) {
error('不正なアクセスです。');
}
if (!empty($_POST['id'])) {
// トランザクションを開始
db_transaction();
// ユーザを削除
$resource = delete_users(array('where' => array('id = :id', array('id' => $_POST['id']))), array('associate' => true));
if (!$resource) {
error('データを削除できません。');
}
// トランザクションを終了
db_commit();
// リダイレクト
redirect('/admin/user?ok=delete');
} else {
// リダイレクト
redirect('/admin/user?warning=delete');
}
if (file_exists(DATADIR . "profil/{$users}.prof")) {
$uzdata = reading_profil($users);
if ($uzdata[7] < 101 || $uzdata[7] > 105) {
if ($mailblack == 1) {
$mailstring = search_string(DATADIR . "blackmail.dat", $uzdata[4], 1);
if (empty($mailstring)) {
write_files(DATADIR . "blackmail.dat", $log . '|' . $uzdata[4] . '|' . SITETIME . "|\r\n");
}
}
if ($loginblack == 1) {
$loginstring = search_string(DATADIR . "blacklogin.dat", $uzdata[0], 1);
if (empty($loginstring)) {
write_files(DATADIR . "blacklogin.dat", $log . '|' . $uzdata[0] . '|' . SITETIME . "|\r\n");
}
}
delete_users($users);
echo '<b>Профиль пользователя успешно удален!</b><br />';
} else {
echo '<img src="../images/img/error.gif" alt="image" /> <b>Ошибка, у вас недостаточно прав для удаления этого профиля</b><br />';
}
} else {
echo '<img src="../images/img/error.gif" alt="image" /> <b>Ошибка, пользователя с данным логином не существует!</b><br />';
}
} else {
echo '<img src="../images/img/error.gif" alt="image" /> <b>Ошибка! Неверный идентификатор сессии, повторите действие!</b><br />';
}
echo '<br /><img src="../images/img/back.gif" alt="image" /> <a href="users.php?' . SID . '">Вернуться</a>';
}
echo '<br /><img src="../images/img/panel.gif" alt="image" /> <a href="index.php?' . SID . '">В админку</a><br />';
echo '<img src="../images/img/homepage.gif" alt="image" /> <a href="../index.php?' . SID . '">На главную</a><br />';
} else {
change_profil($data[0], array(46 => 0, 47 => ''));
}
}
}
delete_lines(DATADIR . "datatmp/reglist.dat", $id);
header("Location: reglist.php?start={$start}&isset=mp_addregusers&" . SID);
exit;
}
//----------------------------------- Запрет регистрации -------------------------------------//
if ($choice == 2) {
$file = file(DATADIR . "datatmp/reglist.dat");
foreach ($id as $val) {
if (isset($file[$val])) {
$data = explode("|", $file[$val]);
if (file_exists(DATADIR . "profil/{$data['0']}.prof")) {
delete_users($data[0]);
}
}
}
delete_lines(DATADIR . "datatmp/reglist.dat", $id);
header("Location: reglist.php?start={$start}&isset=mp_delregusers&" . SID);
exit;
}
} else {
echo '<img src="../images/img/error.gif" alt="image" /> <b>Ошибка! Отсутствуют выбранные пользователи!</b><br />';
}
} else {
echo '<img src="../images/img/error.gif" alt="image" /> <b>Ошибка! Не выбрано действие!</b><br />';
}
} else {
echo '<img src="../images/img/error.gif" alt="image" /> <b>Ошибка! Неверный идентификатор сессии, повторите действие!</b><br />';
function vm_edit_users_check()
{
$IDs = array();
$Delete_IDs = array();
$dirty_IDs = array();
// Get all IDs from Form
foreach ($_POST as $index => $value) {
if (startsWith($index, "ID_")) {
$IDs[] = str_replace("ID_", "", $index);
} elseif (startsWith($index, "Delete_")) {
$Delete_IDs[] = str_replace("Delete_", "", $index);
}
}
// Now check for dirty elements
foreach ($IDs as $id) {
if ($_POST['username_' . $id] != $_POST['username_new_' . $id] || $_POST['debt_' . $id] != $_POST['debt_new_' . $id] || $_POST['state_' . $id] != $_POST['state_new_' . $id] || $_POST['comment_' . $id] != $_POST['comment_new_' . $id]) {
// This is a dirty ID
$dirty_IDs[] = $id;
}
}
$edited_users = array();
// create User Objects for edited users
foreach ($dirty_IDs as $id) {
$user = new User();
$user->comment = $_POST['comment_new_' . $id];
$user->username = $_POST['username_new_' . $id];
$user->debt = floatval(str_replace(",", ".", $_POST['debt_new_' . $id]));
$user->state = $_POST['state_new_' . $id];
$user->iD = $id;
$edited_users[] = $user;
}
if (count($edited_users) > 0) {
$response = update_users($edited_users);
}
if (count($Delete_IDs) > 0) {
$response2 = delete_users($Delete_IDs);
}
$resp;
if (isset($response) && !isset($response2)) {
$resp = $response;
} elseif (isset($response2) && !isset($response)) {
$resp = $response2;
} elseif (isset($response2) && isset($response)) {
$resp = $response;
$resp->status &= $response2->status;
$resp->errorDescription = $resp->errorDescription . " " . $response2->errorDescription;
} else {
return "";
}
return $resp;
}
