Characters by user id

[ciclope]

Someone have the sql script to get all characters from a user id?

[MentaL]

[Purplex3]

Don't have the script and I don't know If you only need the sql script to do something further than looking into the characters..
But If you just wanna see all chars of the userid, use the Bega Admin Tool.
There you can look up all characters of the userid.

[HariSeldon]

select c.CharacterIdx, c.Name, c.LEV, c.Nation
 from Server01.dbo.cabal_character_table c
inner join Account.dbo.cabal_auth_table a
on a.UserNum=c.CharacterIdx/8
where a.ID='UserId'