Database Info

[manticore]

Hello guys,

i do have a question about the cabal database.
In which table can i find character idx and account idx?
i need to check which character is assigned to which account.

So i hope there exist a table in which is stored the usernum (account idx) and the character idx or maybe a procedure which can check if a character idx is assigned to an account (usernum). This procedure should give me a true or false as int :)

I want to build a website where players can buy items for alz. The players need to login onto the website and need to select their character. With the alz of this char you can buy some items which will be send to the character by tempoary inventory.
All these thing are finished except for the checking which character belongs to which account :)

pls help me

[MentaL]

[Dens666]

@accountIdx * 8 = CharacterIdx+6
Ex. Accidx = 4; 4*8=32 so now Character which belong to account are under characteridx 32, 34, 34, 36, 37, 38
Why? Because account have 6 slots.
You can't directly transform accidx to charidx.
You need to do select option on web, script show all 6 character of account and he need to choose correct one. Then save characteridx into session, cookie whatever.

I think it's clear.

[PunkS7yle]

More accurate its accidx * 8 + character slot number.

I want to build a website where players can buy items for alz. The players need to login onto the website and need to select their character. With the alz of this char you can buy some items which will be send to the character by tempoary inventory.
All these thing are finished except for the checking which character belongs to which account :)

pls help me

Why not make an ingame shop to do it ?

[Dens666]

More accurate its accidx * 8 + character slot number.




Why not make an ingame shop to do it ?

Maybe he want to make some kind of item builder :-) if not then yes he better do it in game shop its much easier and safe.

About + slot number is more accuracy but just to know not in use. I mean in script this info is not needed.
He have two ways, I'm pretty sure that there is procedure in probably Account db to show all character on this account ID. Otherwise you can check array of accidx*8+6 if array[i] is not null then etc etc.
You can do this.

[PunkS7yle]

About + slot number is more accuracy but just to know not in use

but it is in use..

[estsoft]

More accurate its accidx * 8 + character slot number.

Technically, it's (accIdx << 3) + characterSlot.

[PunkS7yle]

Technically it's both.

[manticore]

I thank you for this much answers you gave me. It helped me a lot :)
Thread can be closed :)