Database to Permanent/Temporary Character Variable

[Nitrate]

Hello, I would just like to ask if this is possible, and if it is, how to do it.

 

My idea would be getting a variable from a certain database table and turning it into a character variable.

 

For example:

 

I have a table named `table_a`, and in that table there would be the following : `char_id`, `account_id`, `char`, `variable_a`. Let's say variable_a is a number not less than 0.

 

Now lets say I would like to attach into a OnPcLoginEvent that when a player logs in, the variable_a would, lets say become a permanent character variable (ex: VariableA). How would I be able to do it? set VariableA,???;

 

I hope some can guide me with this. Thank you

[Zell]

With getd and setd you can make this, see on doc

[Nitrate]

With getd and setd you can make this, see on doc

 

Oh cool, i'll try to read and learn about it then. Thank you very much.

 

Edit:

 

Tho I do not really understand how I could fetch the information from a sql table with the command.

Edited January 9, 2015 by Nitrate

[Zell]

oh, I think I understood you wrong. you wanna pick the value of the table?

just use query_sql

[Luciar]

Yes, use query_sql.

[Winz]

https://rathena.org/wiki/Query_sql