Check players title

[WhiteEagle]

Hey folks,
at first "Merry Xmas" ^-^

Is there any way to check per script what title a player has selected?
I want it to know for items like the Kafra Uniform. It gives bonis when a player uses the title 'Kafra'.
 

[Rynbef]

@WhiteEagle

I've selected the wrong row I saw it yet. It's should of course be:

query_sql("SELECT `title_id` FROM `char` WHERE `char_id`="+getcharid(0),.@title_id);

 

Instead of:

query_sql("SELECT `char_id` FROM `char` WHERE `char_id`="+getcharid(0),.@title_id);

 

Please let us know if u solved it.

 

Best regards,

Rynbef~

Edited January 15, 2022 by Rynbef

[Litro Endemic]

just use function in your item bonus, in the function you can query to sql db to get the tittle currenty used.

[Rynbef]

Idk which title u exactly means. The char database just contains a title id as int.

query_sql("SELECT `title_id` FROM `char` WHERE `char_id`="+getcharid(0),.@title_id);

 

I don't think u means an buying or vending store title

 

Rynbef~

 

Edited January 15, 2022 by Rynbef
wrong statement

[WhiteEagle]

6 hours ago, Rynbef said:

I don't think u means an buying or vending store title

Haha, you're right. xD
And thanks for your help.

I am interested in items that give bonuses related to titles.
Like for example:

"_______________________",
"When equipped with \"Kafra\" title: Exp gained +5%, Item drop rate +5%, All Stats +4.",
"_______________________",

Thanks, that should work.

6 hours ago, Rynbef said:

query_sql("SELECT `char_id` FROM `char` WHERE `char_id`="+getcharid(0),.@title_id);

 

[WhiteEagle]

It now works as it should, except for the fact that if you reselect the title, you have to log in again before it will be recognized.
Apart from that, I don't find any problems so far.

Thanks Rynbef~

WhiteEagle