link account with character

[magraopb]

anyone can tell me how i can find on MSSQL the link account to character?

[MentaL]

[chumpywumpy]

Do you mean how to tell which char numbers go with which account?

Check your gamedb stored procedures:

CREATE PROCEDURE [dbo].[cabal_tool_GetCharacter]( @UserNum int )
AS
BEGIN
	SELECT *
	FROM cabal_character_table
	WHERE CharacterIdx  BETWEEN @UserNum * 8 AND @UserNum * 8 + 5	
END

This lists the chars for the given account UserNum. UserNum * 8 is your first CharacterIdx. Your CharacterIdx / 8 (rounded down) is your account UserNum.

[magraopb]

i want to create a user panel to my own web site, so need a script to link the account with character to the functions, understand?

[kadion]

i want to create a user panel to my own web site, so need a script to link the account with character to the functions, understand?

Try to post your request in your own language (ofc with english translation as stated in RZ rules). maybe we can understand you in portuguese.

[chumpywumpy]

You are going to need several different queries for this depending on what you want the control panel to edit. My last post is the first and most important part you need as your login system will probably be remembering the players UserNum and you need to be able to find the CharacterIdx's.

Give me an example of a change you want the CP to do and i can give example queries.

[magraopb]

ok chumpy, i'll code and put here... wait a moment please

[magraopb]

example:
move char to another map

data:
UserNum=1
Characteridx=1
Characteridx=2

Script:

Update cabal_character_table set worldidx='$' and x='$' and y='$' where Characteridx='1' and UserNum='1' and Login='0'