MorgDKP2
MorgDKP2 is a full featured mod that allows the master looter (ML) to control the loot distribution process. Only one member is required to have this mod. MorgDKP2 is also capable of tracking DKP and outputting the DKP string for import into eqDKP using a custom php import script.
Please help localize here.
LDB shortcuts:
- L-click => MorgBid2 query
- Shift-L-click => Invite list
- Ctrl-L-click => Raidtracker
- R-click => Options
- L-click itemlink => Add manual item for query
- Shift-L-click Itemlink => Insert link into open chatframe message
- Ctrl-L-click Itemlink => Add item to ignore list
- Hover over itemlink => Show item tooltip
- Shift-hover over itemlink => Show bid history for the item
Bag shortcut - Shift-Alt-L-click any item in your bug to add a manual query (ie a BOE item)
Video Tutorial
BlueWarlord has created a video tutorial for setting up and using the MorgDKP2 system to run a raid. Find it here.
BlueWarlord created another video tutorial for setting up and using MorgDKP2 with eqdkp/eqdkp+. Find it here.
Thanks BlueWarlord!
phpRaid Integration
If you use eqdkp+ for setting up raids you can export the raid attendees (choose lua format) and save the file to the MorgDKP2 folder. When you open the invite list (shift-click) the day of a scheduled raid the phpRaid data will pop open in its own frame.
ClassLoot Integration
If you have ClassLoot (r98 or higher) running as well as MorgDKP2 when a new item drops the classes/altclasses allowed to bid for the item will automatically be filled in if the item is in ClassLoot's database. Only if the classes are NOT already set. Thanks Pneumatis for allowing me to hook your DB:)
Importable item database
There is now and item DB included in the ImportItemDB folder of MorgDKP2. It has as many Northrend raid items I have seen so far with classes set. To import it copy the file to the main MorgDKP2 directory and load WoW. Once imported delete the file from the main directory. Note it will not overwrite any items you already have set.
Using MorgDKP2:
Basic use is identical to MorgDKP. Documentation for setting up the web scripts etc still applies. Will post more information when I have time.
Suggested to start:
- Install the webscripts to the plugins folder of your eqdkp install and install it through the admin plugin menu
- Export your DKP from the website save in MorgDKP2 folder (even if your database currently has no members!)
- Enter WoW and make sure there are no errors
- Track your raid etc
- Click export raid(s) and copy the string
- Click Import raids on the admin panel of edkp and paste the string into the window
- Win!
Webscript help
Export standings
Used to export member DKP, events, aliases, and database information (needed for proper import) to the in game mod. Access through the eqdkp admin menu (after installing plugin)
- Select your game timezone (may not match your actual timezone)
- Select if you want to export member ranks
- Ignore ranks - do not export ranks and hence do not use rank sorting for item rolls
- Use all ranks - export all ranks for all members and use rank sorting for item rolls (only way to activate rank sorting)
- Only export [rank] - only export the selected rank from the website. Caution will only export members of that rank so any unranked members or members of different rank will not be in the file.
- Enter the directory and in game name for up to 5 eqdkp installs (ie if your website is http://sodalityoftheconstant.com/aqdkp/listmembers.php? then you would enter aqdkp and whatever name you want it called in game.)
- For eqdkp+ multiple pool install only enter the main directory name the pool names will be your actual pool names
- For installs in base directory (ie http://eqdkptest.sodalityoftheconstant.com) enter - for the directory name
- Click export
- Right click the link and choose save as .. save in WOW/Interface/Addons/MorgDKP2 directory.
- Load into WoW or reloadui if already in game.
Import raids
Used to import raids recorded with the MorgDKP2 in game mod. Click export raids in the LDB tooltip or export raid in the raidtracker for a single raid. Copy the DKP string (Ctrl-C) and paste it into the editbox. When editing names or adding people you do not need to capitalize them.
- Click parse DKP string
- Check the data and make sure the import looks correct:
- If you have any aliases to import they will be shown with ADD beside them. To not import the alias simply erase the editbox.
- If you have any DKP changes they will be listed. As above erase the value or the names to not import. Can add/remove names as well.
- For each event the name, note, value, attendees, and any items will be shown. Edit them if necessary. To not import a whole event (including items) erase it's name. Erase and item or item value to not import the item.
- If you are using zerosum or skall with zerosum check the use zerosum checkbox.
- Click enter final data:)
Note: - Ranks will only be used in sorting if you export all ranks and set the weight of each rank in the in game options (database options) Higher values should be higher ranks. Also rank sorting is ONLY used on the lootframe rolling window. It is not used anywhere else such as the MorgBid2 check or raid invite tab. This means that the MorgBid2 results frame may show a different winner.
Loot window help:
Here is how the loot window is designed to work for those having trouble understanding it. When you loot a corpse if any items are above the loot threshold the mod will:
- Check each item and if any have not had their classes set (who gets to roll for the item) it will automatically open the item edit page to that item. This takes priority over all other possibilites. ie You edit this item and start the roll for it. The mod checks again and there is still another item with its classes unset so it opens the item edit page for that 2nd item NOT the roll window for the auction you started. If you want to see the roll window simply right click on the 1st item again.
- If no items have unset classes the mod next checks if any items are currently in auction. If so it opens: roll summary window if more than 1 item being rolled for or the single item roll window if only 1 item.
- If none of above conditions apply no window automatically opens (ie not roll window or item edit window) and you can right click any item to open edit window (or roll window if auction started) or alt-right click any item to start ALL queries which will cause the roll summary window to open.
Note: - If you want to use MorgDKP2 with fubar you need to have Broker2Fubar installed or it will only show a minimap icon.
Whisper commands: - whispered to someone running morgdkp2.
Waitlist
mbid wait[+/-] [main] => main only necessary if you are whispering from an unknown alt
Bidding
mbid itemid/itemlink [need/take/pass/offspec] [bid] => itemid/link must be included - bid only for BidWar
Dkp queries
dkplist [pool/s] [class/all] [class] ... => pools only if you want to see what pools are available. pool to get the dkp for that pool (leave out for default pool). all for all members in the raid (if person running morgdkp2 is in a raid), guild otherwise. You own class is automatically included so a pally whispering dkplist rogue will get paladin and rogue.
Webscript note: - The MorgDKP2 webscript requires:PHP 5.2.3 or greater and MySQL 5.0.7 or greater. If you are having issues with special characters make sure your MYSQL database is in UTF-8.
Supported DKP modules:
- Fixed DKP
- Zerosum DKP
- Percent DKP
- Relational DKP
- Random
- SKall
- TakeBid
- BidWar
Syncing:
Options
- Broadcast - enable to send sync messages out during a raid to registered listeners. Usually one person will probably broadcast to the backup people in the raid but you can have more than one broadcaster.
- Receive - enable so your mod will act as a listener and receive syncing events from MorgDKP2 installs which are broadcasting.
- Overwrite raid - enable to overwrite the current raid with the new raid info (in the initial sync) if you have already started a raid. Useful when you zone in to the instance late after raid is already in progress to get the raidlog from the whole run. If you haven't started a raid overwrite is done by default.
- Manual Syncs - ie Sync options/members/items/all/initial sync. Click one of these buttons to manually sync to the current raid.
Sync Details
- Syncing will not be enabled until a raid has started and then the mod will check for sync necessity every 60s.
- When the raid starts or someone joins the raid with receive enabled the broadcaster will send out his eqdkp data (boss events/values, aliases, current pool, certain options, current raid data, and current member DKP) Current member DKP will only be updated in the listener client if it has a newer timestamp or if they are members of your current raid. The broadcasters current raid will overwrite the receivers current raid unless Overwrite raid is off.
- When you make changes to important values the mod will schedule a sync and send those changes to the listeners throughout the raid.
What is synced?
- item database changes (value/classes)
- raid tracker changes to items (value/winner/event)
- custom events
- event changes (value/name/note/deletion)
- alias additions
- BOE items (ie hand out through your inventory and manually trade)
- DKP change events
- item costs different from actual DB cost (ie TakeBid or offspec auctions)
- items incorrectly assigned to ML/DE in listener client
- full current raid sync
- initial waitlist and waitlist changes
NOTE: - There is generally no need for the manual syncs unless you specifically want to transfer the complete itemDB or the listener wants ALL of your MorgDKP2 options. The complete member DKP and necessary options are transferred when the initial sync is sent at the start of the raid (if you have Broadcast enabled and there are listeners present in the raid)
MorgDKP2 Features:
- Allows ML to query raid for interest in loot.
- Tracks DKP including raid attendees, start bonus, and all drops.
- DKP systems supported include zero-sum, relational, random, fixed, percent, and skall.
- Options to award DKP/unit of time, include a start bonus, and include custom events such as boss attempts.
- BidWar mode for item auctions.
- Custom php scripts to export/import/change DKP and add aliases to eqDKP/eqdkp+ website. (can import multiple raids/pools in one string)
- Allows a ML and disenchanter (DE) to be set so that they are not charged for items. (Toggle)
- Remembers what raid members have equipped and will not send a query to them for loot they already have. (Exceptions for some non-unique items included.)
- Sends query results to MorgBid2 (for players in that auction)
- Displays top 5 DKP members for the moused over item in the tooltip.
- Automatically hands out items to the winning player if the loot window is still open. Note: It asks with the standard blizzard confirmation dialogue.
- Allows ML to easily set which classes are eligible and DKP value. Also remembers these values.
- Scans for base installs of MorgBid in the current raid. Automatically outputs a link to MorgBid site on click.
- Allows ML to record BOE items before trading them to member. (Alt-shift click item in your inventory)
- Can load up to 5 separate DKP pools. Ie. MC1, MC2, BWL, AQ40, NAXX. These raids can be named whatever you wish.
- multiPool feature allows up to 5 DKP pools to be used in one raid. (ie separate pool for class items)
- Can change loot threshold on the fly.
- Item history for easy recall of current raid item winners.
- Allows raid members to whisper ML for current DKP for own class or specified classes in all 5 DKP pools. (sent to MorgBid2)
- Lets you know it is working by displaying boss kills, raid changes, and looting events.
- Automatically links items to raid chat.
- Edit item values from item history (Allow you to track DKP without being ML)
- Whisper system for those crazy people who hate mods:P
- Fubar/LDB support
- Main and offspec DKP rolling
- Waitlist including DKP awarding and alt whispering.
- ListDKP - shows guild members online and in/out of group and allows 1 click inviting
- Custom item ignore list
- Automatic loot method switching for certain encounters. (Vashj/MH)
- Boss attempt mode asks if you want to record a boss attempt after dying
- Custom loot frame with buttons for self-loot/random rolling items (loot frame can be used with mod in standby mode)
- Importable item database
- Built in xloot like loot frame which can be used with mod on standby
- New itemframe/rollframe built into loot window
- Customisable font/frame options
- Modular so can disable what you don't need
- Web script can handle offbase/eqdkp installs in main directory
- Imports MorgDKP database data (be sure to run both at same time if you want to mport your database the first time)
- Fully eqdkp/eqdkp+ compatible
- In game raid browser
Yep that would be the cause:( Can always reload your UI once in a while to force a save.
edit: you said you created an event for those bonuses (like ironman) but did you also assign them to the correct DKP pool?
Nobody was their to sync with. But I did turn it on and set the channel and things. I think what happened was I crashed during a logout. Because I look now and one of my mods I moved was back in its normal spot.
@azphat - something had to have happened that your SV file didn't get saved I would say your logoff was not normal...ie you crashed. Did you have syncing enabled and broadcast or receive? Were you in a raid with another broadcaster and didnt end the raid before he started a new raid with overwrite raid enabled? Only possibilities I can think of.
I entered all the info in from the chat log... wow that sucked.
Yes, it was zero sum dkp.
@morgalm Yes I created events as Ontime Bonus and Ironman Bonus. Every adjustment done is used for one of these events.
2nd issue....
I used MorgDkp2 3.88 tonight. Everything went smoothly. I logged off, and back on and ALL of the dkp history is gone. The raid is gone from the tracker and everything. I have not uploaded this dkp information yet. Now what do I do?
God will you guys never let me rest...
If you are using eqdkp+ are you absolutely sure you assigned the DKP change to an event and made sure that event is included in the DKP pool you are interested in? It will work if you do that.
"All that said, the MorgDKP export should probably be changed to grab its' adjustments from the eqdkp_members table. :)"
Yes that would be great and makes a lot of things easier.
I don't recall where it is in the actual database, but if you look at the member from the non-admin page, it lists all of that member's points spent, earned, and adjustments in detail. MorgDKP export grabs those individual adjustments towards the bottom and adds them up, instead of looking at the total in the eqdkp_members adjustment field. If you look at that web page, and manually total them up, you should get the same number MorgDKP export gives you.
If you made your adjustments directly to the database, this would be your problem. If you made the adjustments through the individual adjustments link within EQDKP, these numbers *should* be the same, and I have no idea why they are different.
All that said, the MorgDKP export should probably be changed to grab its' adjustments from the eqdkp_members table. :)
Great i will test it tomorrow, i can't wait for the new waitlist and timebased fixes :D
Oh i've still problem with the export. The morg exporter doesn't export the adjustments for some members.
I've checked the sql database "eqdkp_members" and there are all adjustments but the exporter don't use it corectly.
@Tirdal: Which database do you mean? In which you have set the adujustments manually. This is very annoying for some memebers when they don't have the correct dkp ingame.
Alright syncing is finally in! Whew. It should be working fairly smoothly I have quite extensively tested with 1 broadcaster and multiple listeners but I have not tested multiple broadcasters. There may be some issues I have not thought of with that. Also all the Ulduar changes are in so bosses should be detected correctly (at least up to Mimiron) Greatly improved the loot detection system as well should be much more accurate. Also Mimiron will automatically switch to ffa for p3 and back for p4. Did alot of tweaking on menus as well so they should be easier to use.
Enjoy:)
How did earned spent DKP end up being a float what DKP system are you using? 0 sum?
Found an error in Morgfunc2.php (eqdkp plugin file). If earned/spent dkp is float, mysql generates an error To fix it replace row 328 with following:
if ($value != '' and $olddata[$key] != $value) $listdata[] = $key . "='" . str_replace(",",".",$value)."'";
I ran into this once.
MorgDKP Export walks through the list of all adjustments each person has received according to the logs in the database, and adds them all up. EQDKP stores the total adjustments in the same place it stores the total earned and spent. It's possible for those numbers to not match up, thus the discrepancy.
We ran into this when adding an adjustment in EQDKP, the page was slow updating that adjustment so clicked the submit button a second time, and the math for the adjustment was done twice, incrementing the player's total by two points, but the id stamp was the same, so only one of them went into the log for each player. So, the export was off by one from the website.
I had to fix this by going into the database directly to adjust the stored total adjustment for each player.
How your situation got to be this way, I don't know.
I have some problems with the exporter.
I did some adjustments in my eqdkp to clean it up a little bit. But when i try to export the updated databases with the morgdkp exporter it doesn't set the correct "adj" value. The "earned", "spend" and "bal" values seems to be correct but for some members the "adj" values are set to 0 but in the eqdkp there are adjustments set for those members.
Yeah sorry still hammering out a couple bugs/making improvements to syncing but I think it will be worth it. Definitely be this week.
Hey Morg, do you have some news about the new update? I'm really looking forward to it
Wewt ! yay :3
Sorry guys for the delay. Debugging syncing is a bastard. I will be releasing it this weekend as well as many changes/fixes you have posted. I also changed the way loot is assigned to bosses so it should be much better at assigning items to the correct boss even when you are not the ML. And of course proper boss detection for all of Ulduar (damn chests)
Oh Okay I thought I was still being a newb with this stuff haha .. Is that going to come with the Sync Database as well. I see that the Sync DB instructions are posted here now.