(HELP) Sql Delete Char without Account

[hatibudak]

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 :

DELETE FROM TB_User WHERE NOT EXISTS (SELECT * FROM SR_ShardCharNames WHERE SR_ShardCharNames.UserJID=TB_User.JID)

ty

[MentaL]

[DaRkAnGeL]

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.

[ahmedelbeah]

not work

Msg 208, Level 16, State 1, Line 1
Invalid object name 'SRO_VT_SHARD'.

[DaRkAnGeL]

give me your sql tables structure. the query is fine the names are wrong

[kaydhm]

just use this query it will clean your shard from chr ^_^"

[ahmedelbeah]

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

[ahmedelbeah]

need help

[ahmedelbeah]

Uppppppppppppppppppppp