Query Gm acc + Chra ID

[tk69ok]

Hello,
as the title say i need a query to get ChraID + all Gm Account in my DB,i try look in google match and i cant found any,waiting help ppl plz .

UPppppppppppppppppppppppppp

[tk69ok]

upppppppppppppppppppppppppppppp help omg ?

[Snow*]

I hate sql. Hope this help you out

 Spoiler

SELECT JID FROM SRO_VT_ACCOUNT.dbo.TB_User where sec_primary = '1' -- Choose one of the GM's accounts

SELECT CharID FROM SRO_VT_SHARD.dbo._User where UserJID = '1' 

SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char where CharID = '42880' --It tells you the character name.

[tk69ok]

thank you snowstorm,but i need to get CharID by chra name not chra name by CharID,hope you help again thanks match.

[Zodiao]

USE [SRO_VT_SHARD]

Select CHARID from _Char where CharName16 like '%%%%%'

[tk69ok]

Thanks all for help Respect

[Yui..]

this will help you

SELECT _Char.CharName16
, TB_User.StrUserID
, TB_User.sec_content
, TB_User.sec_primary
FROM
FEAR_VT_SHARD.dbo._User
INNER JOIN FEAR_VT_SHARD.dbo._Char
ON _User.CharID = _Char.CharID
INNER JOIN FEAR_VT_ACCOUNT.dbo.TB_User
ON _User.UserJID = TB_User.JID
where sec_primary =1