03-14-2014, 03:45 AM
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...

