I need a SQLQuery to delete accounts fully
Delete existing characters, delete clans, etc ...
SQLQuery to delete Account
I need a SQLQuery to delete accounts fully
Delete existing characters, delete clans, etc ...
Execute in Microsoft SQL Server.Code:TRUNCATE TABLE Account TRUNCATE TABLE AccountItem TRUNCATE TABLE Character TRUNCATE TABLE CharacterItem TRUNCATE TABLE Clan TRUNCATE TABLE ClanMember TRUNCATE TABLE Friend TRUNCATE TABLE Login
An error will pop-up when you try to execute it but just press continue, it will work.
If anyone noticed I forgot a table, post it here. :)
Well, that will delete all of the accounts, he said only 1 acc D:Originally Posted by SuperWaffle
According to his post he said he wanted to "delete existing accounts, characters, clans fully"
But his title says SQLQuery to delete account, lol confusing at least you gave it some effort ;3.
i need to delete 1 account :s
Do it manually?
Yes....
Dude.
DELETE FROM Account WHERE User ID='[put user id here]'
DELETE FROM Login WHERE User ID='[put user id here]'
Example:
DELETE FROM Account WHERE User ID='iceman4154'
Yes, it deletes the accounts, but I need to delete completely and all its dependencies, Characters, Clans, Friends of the characters, etc...
Code:DELETE FROM Account WHERE AID='[AID]' DELETE FROM Login WHERE AID='[AID]' DELETE FROM Character WHERE AID='[AID]' DELETE FROM Clan WHERE NAME='[Name]'
The Order should be:
deleting all account/character Logs.
deleting all clan members of his clan(in case hes leader).
deleting his clan.
deleting all his characters.
deleting account from Login and account table.
Guys what he means is emptying the whole table not deleting it.
DELETE FROM [Table Name]
Reply With Quote