+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: Query affinity (/showthread.php?tid=3646)
- RiiOT - 03-13-2014
Might be an easy question to an easy answer, what is the sql query to * affinity.
- Gambit - 03-14-2014
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 - 03-14-2014
Thanks so much.
- Paramount - 03-14-2014
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