(SQL) Where is the link between TB_User and _Char

01/02/2017 22:21 arpad12#1

Hello!

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

01/02/2017 22:58 Exo#2

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

01/09/2017 17:29 xxnukertube#3

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

01/09/2017 18:02 B1Q#4

SRO_VT_SHARD.dbo._User

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