(SQL) Where is the link between TB_User and _Char

[arpad12]

Hello!

How can i know, which char is linked to which account? To search the account by character name to add reward on account?

[​Exo]

Shard._Users as far as I remember. You will find CharID and JID linkage there.

[xxnukertube]

Maybe IT Can help you

PHP Code:

SELECT 
t.StrUserID Login,c.CharName16 CharName,s.silk_own,s.silk_gift,t.JID,c.CharID
FROM SRO_VT_ACCOUNT..TB_User t
INNER JOIN SRO_VT_SHARD.._User u ON u.UserJID = t.JID
INNER JOIN SRO_VT_SHARD.._Char c ON c.CharID = u.CharID
INNER JOIN SRO_VT_ACCOUNT..SK_Silk s ON t.JID = s.JID 
ORDER BY c.CharID ASC 


[B1Q]

SRO_VT_SHARD.dbo._User

Cols
CharID(_Char.CharID) UserJID(TB_User.JID)