Deleted account

[_Diavolino_]

Hello,
i would like to know, if it exists a process to deleting an account and ALL chars, item ,etc without creating trouble in database ?

because i did already the manipulation and was make a disorder in table like some new account get other characters etc and all was move.

exemple

1 2 3 4 5 6
i delete 3 and 4
so all line was move of s "stair" as 5 and 6 become 3 and 4 deleting...

if someone can propose a perform script to Delete without any problem som account

thank you very much

ps :

why to delete account ? because usually the number of account is the return of your Server, if you got account that not serve, why to keep them ? better to delete prperly without disturbed the work of the database xD

Regards ! and thanks for helping

[Mark.Teal1982]

this is a script to delete a account and all traces of it I didn't write it so no credit to me

 Spoiler

declare @Account as int
set @Account = xxxxxxx -- Type the UserUID and hit F5 to delete that Account


delete
from PS_UserData.dbo.Users_Master
where UserUID = @Account

select CharID
into #CharIDs
from PS_GameData.dbo.Chars
where UserUID = @Account

delete
from PS_GameData.dbo.Chars
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.CharItems
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.CharRenameLog
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.CharSavePoint
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.CharSkills
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.FriendChars
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.GuildChars
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.Market
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.MarketCharConcern
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.MarketCharResultItems
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.MarketCharResultItems_DelLog
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.MarketCharResultMoney
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.MarketCharResultMoney_DelLog
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.ProductLog
where CharID in (select CharID from #CharIDs)



delete
from PS_GameData.dbo.UserMaxGrow
where UserUID = @Account

delete
from PS_GameData.dbo.UserStoredItems
where UserUID = @Account


drop table #CharIDs

and this one searchs for inactive accounts and deletes all traces of al inactive account just specify the number of days inactive to look for

 Spoiler

SELECT UserUID
into #UserUIDs
FROM [PS_UserData].[dbo].[Users_Master]
where AdminLevel = 0
and UserID not like '%%' -- userid inside %% you want to keep that is above 180 day's old
and LeaveDate <= GETDATE()-180 -- change how many day's inactivity

select CharID
into #CharIDs
from PS_GameData.dbo.Chars
where UserUID in (select UserUID from #UserUIDs)

delete
from PS_UserData.dbo.Users_Master
where UserUID in (select UserUID from #UserUIDs)

delete
from PS_GameData.dbo.Chars
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.CharItems
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.CharRenameLog
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.CharSavePoint
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.CharSkills
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.FriendChars
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.GuildChars
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.Market
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.MarketCharConcern
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.MarketCharResultItems
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.MarketCharResultItems_DelLog
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.MarketCharResultMoney
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.MarketCharResultMoney_DelLog
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.ProductLog
where CharID in (select CharID from #CharIDs)

delete
from PS_GameData.dbo.UserMaxGrow
where UserUID in (select UserUID from #UserUIDs)

delete
from PS_GameData.dbo.UserStoredItems
where UserUID in (select UserUID from #UserUIDs)


drop table #CharIDs
drop table #UserUIDs

[_Diavolino_]

i got that one too, but is it without risk to shift the account ?
is it safe to delete Row with Column UserUID as incremented of table Usermaster?
i notice that i got already that kinda of 'bug'...

Thank you

[nick4ever]

I dont see that is necessary to delete, just simply block that account. That's all