Characters by user id

Results 1 to 3 of 3
  1. #1
    Newbie ciclope is offline
    MemberRank
    May 2020 Join Date
    4Posts

    Characters by user id

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


  2. #2
    Member Purplex3 is offline
    MemberRank
    Mar 2012 Join Date
    25Posts

    Re: Characters by user id

    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.
    Attached Thumbnails Attached Thumbnails unknown.png  

  3. #3
    Member HariSeldon is online now
    MemberRank
    Oct 2019 Join Date
    73Posts

    Re: Characters by user id

    Code:
    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'



Advertisement