// BEGIN deletemerow
if( isset($HTTP_GET_VARS['deleteme']) || isset($HTTP_POST_VARS['deleteme']) )
{
$mode = 'deleteme';
}
if ( $mode == "editprofile" )
{
$template->assign_block_vars("deletemerow", array(
"L_DELETE_ME" => "Lösche Deinen Account",
"L_DELETE_ME_INFO" => "Aktiviere die Box und schreibe YES (alles in Grossbuchstaben) in das andere Feld. Dies kann nicht rückgängig gemacht werden!",
"S_DELETE_ME" => '<input type="checkbox" name="deleteme">&&<input type="text" size="3" maxlength="3" name="deleteme_confirm" value="NO">')
);
}
// END deletemerow
// BEGIN deletemerow
} else if( $mode == "deleteme" )
{
$clear_confirm = ( isset($HTTP_POST_VARS['deleteme_confirm']) ) ? $HTTP_POST_VARS['deleteme_confirm'] : $HTTP_GET_VARS['deleteme_confirm'];
if ($clear_confirm == 'YES')
{
$sql = "SELECT g.group_id
FROM " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g
WHERE ug.user_id = " . $userdata['user_id'] . "
AND g.group_id = ug.group_id
AND g.group_single_user = 1";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Kann keine Gruppeninformation zu diesem User erhalten", "", __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$sql = "SELECT user_id FROM " . USERS_TABLE . " WHERE user_id = '" . $user_id . "'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Kann keine Information zu diesem User finden', '', __LINE, __FILE__, $sql);
}
$xrow = $db->sql_fetchrow($xresult);
$sql = "UPDATE " . POSTS_TABLE . "
SET poster_id = '-1', post_username = '" . $userdata['username'] . "'
WHERE poster_id = " . $userdata['user_id'];
if( $result = $db->sql_query($sql) )
{
$sql = "UPDATE " . TOPICS_TABLE . "
SET topic_poster = '-1'
WHERE topic_poster = " . $userdata['user_id'];
if( $result = $db->sql_query($sql) )
{
$sql = "DELETE FROM " . USERS_TABLE . "
WHERE user_id = " . $userdata['user_id'];
if( $result = $db->sql_query($sql) )
{
$sql = "DELETE FROM " . USER_GROUP_TABLE . "
WHERE user_id = " . $userdata['user_id'];
if( $result = $db->sql_query($sql) )
{
$sql = "DELETE FROM " . GROUPS_TABLE . "
WHERE group_id = " . $row['group_id'];
if( $result = $db->sql_query($sql) )
{
$sql = "DELETE FROM " . TOPICS_WATCH_TABLE . "
WHERE user_id = " . $userdata['user_id'];
$result = @$db->sql_query($sql);
}
else
{
$error = TRUE;
}
}
else
{
$error = TRUE;
}
}
else
{
$error = TRUE;
}
}
else
{
$error = TRUE;
}
}
else
{
$error = TRUE;
}
if( $error == TRUE )
{
message_die(GENERAL_MESSAGE, "Fehler beim Löschen des Accounts.");
}
else
{
message_die(GENERAL_MESSAGE, "Dein Account wurde gelöscht.");
}
}
else
{
$message = $lang['Profile_updated'] . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
message_die(GENERAL_MESSAGE, $message);
}
// END deletemerow
}
}
Mitglieder in diesem Forum: 0 Mitglieder und 15 Gäste