[RELEASE] List all Toons and Accounts grouped

11/10/2010 18:20 shaiyarebirth#1

Hey there,

With this lil piece of SQL you will bring a list of all accounts, with their respectives toons

HTML Code:

SELECT A.[UserUID], A.[UserID], A.[Email], B.[CharName] 
FROM [PS_userdata].[dbo].[Users_Detail] A 
INNER JOIN [PS_GameData].[dbo].[Chars] B 
ON B.[UserUID] = A.[UserUID] 
ORDER BY A.[UserUID]

01/25/2011 16:49 kalle801#2

Thank You, nice Script ;)

01/25/2011 23:32 Bаne#3

Ohhes you can ban people faster with this. :D TY