Where in the database does it link accounts with characters?

Results 1 to 7 of 7
  1. #1
    Apprentice ducati996r is offline
    MemberRank
    Jan 2007 Join Date
    19Posts

    Where in the database does it link accounts with characters?

    Where in the database does it link accounts with characters?, the reason i am asking is because i would like to have a premium service to be able to move characters to other accounts.... I've searched and searched for an answer to this in just about every forum .. and nothing ...


  2. #2
    Account Upgraded | Title Enabled! luis R is offline
    MemberRank
    Nov 2015 Join Date
    467Posts

    Re: Where in the database does it link accounts with characters?

    Account: Account>Tables>cabal_auth_table (Edit Top Rows)
    Character: Server01>Tables>cabal_character_table (Edit Top Rows)

  3. #3
    Trying to be developer ^^ Dens666 is offline
    MemberRank
    Jul 2010 Join Date
    PolandLocation
    1,080Posts

    Re: Where in the database does it link accounts with characters?

    AccountID = CharacterIdx divided by 8 ;)

  4. #4
    Apprentice ducati996r is offline
    MemberRank
    Jan 2007 Join Date
    19Posts

    Re: Where in the database does it link accounts with characters?

    so this should work ..

    Account.dbo.cabal_auth_table.UserNum=floor(Server01.dbo.cabal_character_table.CharacterIdx/8)

    right ?

  5. #5
    Trying to be developer ^^ Dens666 is offline
    MemberRank
    Jul 2010 Join Date
    PolandLocation
    1,080Posts

    Re: Where in the database does it link accounts with characters?

    Quote Originally Posted by ducati996r View Post
    so this should work ..

    Account.dbo.cabal_auth_table.UserNum=floor(Server01.dbo.cabal_character_table.CharacterIdx/8)

    right ?
    Yes something like that, but of course this query is incorrect. But schema is fine.
    Remember about one thing: Account may have 6 characters -> for ex. CharIDX=4084 (4084,4085...4090) = One account
    Think about it while and u will get it

  6. #6
    Apprentice ducati996r is offline
    MemberRank
    Jan 2007 Join Date
    19Posts

    Re: Where in the database does it link accounts with characters?

    well appearantly i dont know enough mssql to get this to work ... any pointers or info on how to transfer characters between accounts would be helpful...

  7. #7
    Trying to be developer ^^ Dens666 is offline
    MemberRank
    Jul 2010 Join Date
    PolandLocation
    1,080Posts

    Re: Where in the database does it link accounts with characters?

    Bro no one give you full implementation.
    It's your server, you want to add additional donate method so you need to work on that.
    If you want you can contact me but I'll not make it for free.



Advertisement