Home | 
Forum | 
Wiki | 
Translate | 
Bugtracker | 
WebSVN | USVN
There is a table in the database called "eqdkp_members". This table includes information about the members various DKP points.
member_id = defined memberid
member_name = name
member_earned = earn points
member_spent = output points for items
member_adjustment = corrects points
the current points then result from
+ current = member_earned member_spent - member_adjustment
When a change is made it is translated to all DKP calculations. For example if a item is distributed then the member_spent value is increased the associated member will also increase the member_adjust. In principle, all quite simple.
When a raid is entered the table eqdkp_Raids makes a new entry. For example "Example-Raid" goes to Molton Core and when they register it is entered under eqdkp_raid_attendees".
We can use the "earned value to simply recalculate when there is a query on who participated in which raids. If we include all the raids then we will get the same value as described abvove.
If you only call on the name of BWL then we only get the points of the players who have ever participated in BWL.
Another way to assign points is to check the table eqdkp_items. For each new item a new row is created in the RaidID stands. We can run a SQL query that will give us only the items that came from, and was purchased from, Molton Core.
There are several ways to manage DKP and this is what Multi-DKP does.
|  |