EQdkp-Plus - DKP System - Raidplaner - Guildportal - Gildenportal - WoW, Lotro, Runes of Magic home of the EQDKP Plus Projekt

I was planning on waiting for 0.7 at first, as EP/GP and decay supposedly will be a core feature there. Unfortunally, things changed in guild, and I had to move forward faster. Thats why I wrote this little hack.

First off all, lets be clear. This isn't a plugin, this is a hack. Instead of using EQDKP's standard ways of adding and removing points, this decay system will change your EP, GP and Adjustments right off in the database. This could in theory break your whole system, and I take no resposibility if it would do that.
This also involves changing some of the code of EQDKP, and therefor any changes will be removed come next patch (provided we have one before 0.7), and might not work with the next one.
Basicly, I would not recomend this hack at all, unless you really need a working EP/GP system, and know what you are doing.

How does it work?

It uses a modified version of the Decay plugin to work the decay magic. http://www.eqdkp-plus.com/forum/eqdkp-plus-itemstats-f509/need-decay-system-could-do-it-myself-but-t18529-s90.html
Instead of just adding adjustments for the decay, it will write straight to your earned, spend and adjustment cells, adjusting all of them by whatever percentage you specify.
It will also add an adjustment note, however, this is set to a value of 0, and no rollbacks are possible. If you mess up, you have messed up.

As for the viewing part, the standard way of pulling DKP and getting member_current is: member_earned-member_spent+member_adjustment.
This have been changed in most (all that I could find) pages to the following:
ROUND((member_earned+member_adjustment)/(member_spent+100),3)

This will give you a proper relational system. The +100 means that you have an inital 100 GP. This is a must, partly to make the system more fair to older players in the system, and more imporantly to avoid "division by zero".
The ROUND means that it will be rounded off to 3 decimal points.

The pages that have been changed to this format in my hack are:


I also changed the english translation to read EP for earned, and GP for spent.

Again, I take no responsibility for what may happen if you use this hack. It works for me, and might work for you. Make sure to make backups before using this!

(I hope this is alright to post like this, if not, I beg pardon)

Everything but the damn decay system works.
I keep getting this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/eqdkp3/plugins/decay/decay_mysql.php on line 42

DONE

Return to EQDKP+

Spent
earned .

When i try to setup the decay system, are there any files in need of editing or?

Forget i asked. xD
Turns out it didnt work on my testsite where the prefix was eqdkp3_
Has to be eqdkp_

All works! Thanks.

Just updated my own site properly, and decided to update this hack while I were at it.

Works just the same as before, but updated for 0.6.4.5. Also fixed so that it works no matter what your database structure looks like.

Base GP is by default set to 200. You will need to go into the files and change that by hand if you want another value for Base GP.


Also - this is not a plugin. This is a hack. This changes the original eqdkp+ files. Do not use this hack unless you know what you are doing. It could potentially break your install. Make sure that you make backups of all files changed before installing.
I take no responsibility for this.

(File updated, read further down)

Hi, thanks for your work, if it works is that cool!
But my Question is do I use EPGP tools. Now how do I get the data from an entire evening transferred to the system ie all GP and EP are all flown in the evening?

If you are talking about the EPGP addon then no, that will not work. Atleast I doubt it will, no idea if the export there works.

For ingame EPGP we use MorgDKP2. It's a bit like MLRaidTracker and GetDKP in one, with allot more features. Also naturally allot more advanced, so not nessesarily the best choice for you.

What this in essence do is change the calculation of "Current" dkp from "earned - spent - adjustment = current" to "earned/(spent+baseGP)=current" and add a module (not made by me, but modified) for decay.

Like the post itself say, this is a really bad hack. Yes, it works, but if you don't know what you are doing you risk breaking your whole DKP system. If you actually need any help with it, you probably shouldn't use it at all.

I can confirm this is working.

Thanks so much you have saved me a lot of time and effort!!

As it turns out, there's a minor bug in the release posted previously, which cause decay to fail.
Seems I was a bit over eager when using search/replace.

Thanks to John for pointing this out.

Working version here:

Hey Noss,
I have a question for you. Where can I obtain all of the files needed to upload this EP/GP into Eqdkp plus?

I see these are the hack files, but I am assuming I need to replace some existing files with those hacked files?

I just can't seem to find the initial EP/GP files to upload as a plugin into our Eqdkp plus system.

Bit late reply but...

This is all the files you need to run convert it to EP/GP with decay plugin.
Download and upload it into your root folder of EQDKP+, and it should be working (as soon as you enable the Decay plugin like any other plugin ofcourse).

Basicly, this doesn't go into your plugin folder, but will overwrite the original EQDKP+ files.

Also, like stated before, if you don't know what you are doing, you probably should not try it. There is a real chanse that you could break your website if you do this wrong.
If you do try, make sure to backup everything first.