Query affinity

[RiiOT]

Might be an easy question to an easy answer, what is the sql query to * affinity.

[Gambit]

Depends what type of affinity you are multiplying  a_work_type = 0 is for affinity earned by the items donated to the affinity and a_work_type = 1 is for affinity you earn when you kill a monster

 

so do a query like this

UPDATE t_affinity_work SET a_value = a_value * 10 WHERE a_work_type = 1 ;

that will multiply the affinity points u get from the monsters by 10.... change the work_type to 0 for affinity earned by items.... so on so on and work_type is from quests i believe, i never messed with that...

 

After you have done this on database, you need the exact same thing on your client... much easier if you have a tool that grabs all data from database...

[RiiOT]

Thanks so much.

[Paramount]

Hi.

As you got your answer, and your problem is solved, I am gonna move that topic to Solved section and mark it as solved.

 

Thanks,

 

-LCKB Staff