(HELP) Sql Delete Char without Account
hai.. can someone share code sql for delete character from _Char if without account at TB_User.
because i only delete account at TB_User but not delete character so the char still in SRO_SHARD..
Example for delete account, share from members ragezone :
Code:
DELETE FROM TB_User WHERE NOT EXISTS (SELECT * FROM SR_ShardCharNames WHERE SR_ShardCharNames.UserJID=TB_User.JID)
ty
Re: (HELP) Sql Delete Char without Account
if you want to delete from SRO_SHARD the players that do not exist in TB_User. then use this sql query:
DELETE FROM SRO_SHARD WHERE UserJID NOT IN (SELECT JID FROM TB_User);
i do not know the columns names from TB_User and SRO_SHARD but you can change the names in the query.
Re: (HELP) Sql Delete Char without Account
not work
Msg 208, Level 16, State 1, Line 1
Invalid object name 'SRO_VT_SHARD'.
Re: (HELP) Sql Delete Char without Account
give me your sql tables structure. the query is fine the names are wrong
1 Attachment(s)
Re: (HELP) Sql Delete Char without Account
just use this query it will clean your shard from chr ^_^"
Re: (HELP) Sql Delete Char without Account
Quote:
Originally Posted by
kaydhm
just use this query it will clean your shard from chr ^_^"
i need delete character from _Char if without account at TB_User.
no need delete all char
Re: (HELP) Sql Delete Char without Account
Re: (HELP) Sql Delete Char without Account