Hello,
First let me thank you for developing a well rounded dkp interface.
Our guild is adopting your system with the epgp plugin. I had the Officers download and install dkpmon,dkpmon_epgp,dkpmon_eqdkp and we went on a test run in kara. We came up with a few questions and possible bugs.
1. The Bidder comes up for people on the waitlist and or outside the isntance?
2. Multiple item loot problems. Can we bid off one item at a time to ensure DKP/EP is adjusted before that person can bid on Item #2 or #3?
Currently as in last night the Tier4 Token adn a nice Staff Dropped one person bidding could use both, his priority was the same evne though he bid need on both items. I think we need to auction off 1 item then be able to auction off the next item.
3. We started a log and stopped said log for the raid, reloadedui and could view the log but could not do the eqdkp export. we had no option anywhere we could find to export? we all had the dkpmon_eqdkp mod loaded.
4. Raid time Periodic EP, the points window appeared as the timer was set for but it still had players that had left the raid selected , is there anyway to query the raid before putting the Periodic EP in the awards list? Do we have to go reselect/deselect members everytime the points window appears? IS there a module to use timediff from userjoin to userleave and calculate the periodic EP vlaue at the end of raid?
I know the _epgp modules are addons but I was wondering if you could help me change the bidder _showdkp command to bring up a window that shows more detail info such as EP column,GP Column and the priority currently showDKP only gives us priority not the 2 others. Query dkp shows EP/GP.
Is there a resource or documentation for command line inputs and such?
...
3. We started a log and stopped said log for the raid, reloadedui and could view the log but could not do the eqdkp export. we had no option anywhere we could find to export? we all had the dkpmon_eqdkp mod loaded.
...
DKPmon_eqDKP is only for importing, DKPmon_XML is the module you want for exporting stuff (which is mentioned by the DKPmon_eqDKP plugin each time you log on, by the way ;))
Hello,
First let me thank you for developing a well rounded dkp interface.
You're quite welcome. I try. :-)
Our guild is adopting your system with the epgp plugin. I had the Officers download and install dkpmon,dkpmon_epgp,dkpmon_eqdkp and we went on a test run in kara. We came up with a few questions and possible bugs.
1. The Bidder comes up for people on the waitlist and or outside the isntance?
As long as they're in the raid group, Bidder will pop up for them. You can do standby with DKPmon with people who aren't in the raid, as long as they're in your guild. Just have them select the "Raid standby" option in their Bidder menu while not in the raid, then when you're awarding points do a "Query standby" in the award window under select standby members. The people on standby can even goof around on alts, as long as they set their "Bidding name" in their Bidder menu to their main.
2. Multiple item loot problems. Can we bid off one item at a time to ensure DKP/EP is adjusted before that person can bid on Item #2 or #3?
Currently as in last night the Tier4 Token adn a nice Staff Dropped one person bidding could use both, his priority was the same evne though he bid need on both items. I think we need to auction off 1 item then be able to auction off the next item.
I don't have any experience with the EPGP plugins. In all of the DKP plugins that I did up, I made a point of allowing the loot-distributer to manually select whichever winner they want from those who "bid" by left-clicking the item in the DKPmon window. Is this option not present in the EPGP plugin?
Otherwise, if you can anticipate this problem before openning bidding on the set of items, you can right-click an item that might be double-bid and remove it from the round of bidding. Then, once the round's done, and loot distributed, reloot the corpse to do the second round.
3. We started a log and stopped said log for the raid, reloadedui and could view the log but could not do the eqdkp export. we had no option anywhere we could find to export? we all had the dkpmon_eqdkp mod loaded.
wT got this one. ;-)
4. Raid time Periodic EP, the points window appeared as the timer was set for but it still had players that had left the raid selected , is there anyway to query the raid before putting the Periodic EP in the awards list? Do we have to go reselect/deselect members everytime the points window appears? IS there a module to use timediff from userjoin to userleave and calculate the periodic EP vlaue at the end of raid?
No clue. You're going to want to post this one in the EPGP-module's thread on these forums. I think the author frequents that thread more.
I know the _epgp modules are addons but I was wondering if you could help me change the bidder _showdkp command to bring up a window that shows more detail info such as EP column,GP Column and the priority currently showDKP only gives us priority not the 2 others. Query dkp shows EP/GP.
I -think- one of the EPGP authors is working on something like this. Depending on how the EP/GP values are stored in DKPmon's database, it likely involves having the EPGP module add its own showdkp command, and constructing a points window in that.
Is there a resource or documentation for command line inputs and such?
I'm using eqDKP Plus with MultiDKP-Pools to manage our DKP.
I really wanted to use Dahn's dkpMon2Export.php to dump the dkp data from the site into the importdata.lua file. However, despite repeated attempts I couldn't get it to work, as eqDKP Plus assigns the Pools 'on the fly' based on which instances you specify are in which pools.
So I decided to hack together Dahn's work and Corgan's getdkp.php (which does work in eqDKP Plus) to produce the output file.
**WARNING** I am not a php coder at all therefore this code has been put together on a trial and error basis.
Note: I have coded it to produce the importdata.lua file on the server and provide a link to it, so you can right click the link and save the file direct rather than copy and paste.
Anyway, here you go...hope it helps.
Weeladdie
<?php
/******************************
* GetDKP Plus
*
* ? Corgan @ Server Antonidas PvE German -> [url]www.seniorenraid.de[/url]
* ------------------
* getdkp.php
*
* Version 2.4
******************************/
/******************************
Name: DKPmon2Export.php
Revision: $Revision$
Author(s): Dahn (dahnwow@mac.com)
Description: Dumps DKP data from eqDKP into a csv based table
Dependencies: eqDKP
******************************/
/******************************
Hacked together for eqDKP Plus
by Weeladdie
******************************/
########################
##Edit to reflect your setup##
########################
$poolcount = 2;
$poolNames[0] = "10 Man";
$poolNames[1] = "25 Man";
############# you dont have to change anything below !!!! ######################################
#################################################################################################
$myFile = "importdata.lua";
$fh = fopen($myFile, 'w+') or die("can't open file");
$version = "2.6";
$total_players = 0;
$total_items = 0;
$total_points = 0;
$eqdkp_version = "1.3.x";
$date_created = date("D M d H:i:s Y");
$startString = "--[START]\n";
$endString = "\n--[END]";
$member_count = 0;
$mcount = 0;
$pname = 0;
define('EQDKP_INC', true);
$eqdkp_root_path = './';
include_once($eqdkp_root_path . 'common.php');
#################################################
##This is the text info which appears at the top of the file##
#################################################
// Output headers to force plain text
header("Content-type: text/plain");
header("Cache-Control: no-store, no-cache");
fwrite($fh, "--[[\n");
fwrite($fh, " This file was generated by dkpMon2Export.php.\n");
fwrite($fh, "\n");
fwrite($fh, " Each entry in the table corresponds to a member record your database.\n");
fwrite($fh, " The data included in each entry in the table is:\n");
fwrite($fh, " \"<name>:<class>:<level>:<race>:<pool 0 points>:<pool 1 points>:<pool 2 points>:... etc\"\n");
fwrite($fh, " where <class> must be the English name of the class\n");
fwrite($fh, " ie: one of 'WARRIOR', 'MAGE', 'HUNTER', 'PRIEST', 'PALADIN', 'SHAMAN', 'ROGUE', 'DRUID', or 'WARLOCK'\n");
fwrite($fh, " The point value for each pool can be any floating point number so long as it\'s not in exponential format.\n");
fwrite($fh, "]]\n");
fwrite($fh, "\n");
fwrite($fh, "\n");
fwrite($fh, "-- DKP eqDKP dump generated " . $date_created . "\n\n");
fwrite($fh, 'DKPmon_eqDKP = {}' . "\n");
fwrite($fh, 'DKPmon_eqDKP.dkpMonVersion = ' . $version . "\n");
fwrite($fh, "DKPmon_eqDKP.poolCount = " . $poolcount . "\n");
fwrite($fh, "DKPmon_eqDKP.poolNames = {\n");
$curpool=0;
while ($curpool < $poolcount)
{
if ($curpool > 0)
fwrite($fh, ",\n");
fwrite($fh, "\t\t" . '[' . $curpool . '] = "' . $poolNames[$curpool] . '"');
$curpool++;
}
fwrite($fh, "\n\t}\n");
fwrite($fh, 'DKPmon_eqDKP.timestamp = "' . $date_created . "\"\n");
fwrite($fh, 'DKPmon_eqDKP.fileid = ' . time() . "\n");
fwrite($fh, " \n");
fwrite($fh, " \n");
fwrite($fh, "DKPmon_eqDKP.Import_Data = {\n");
##################
# Output Multi DKP##
##################
$sql = "SELECT *,
m.member_name,
c.class_name as member_class,
r.race_name as member_race,
m.member_earned + m.member_adjustment - m.member_spent as current_dkp
FROM
".$table_prefix."members m, ".$table_prefix."classes c, ".$table_prefix."races r
WHERE
m.member_class_id = c.class_id AND r.race_id = m.member_race_id
GROUP BY
m.member_name
ORDER BY
member_name ASC";
if ( !($result = mysql_query($sql)) ) {
print $sql ;
message_die('Could not obtain member DKP information', '', __FILE__, __LINE__, $sql);
}
define(TAB, "\t");
define(CRLF, "\r\n");
{
$format_multidkp = '%s';
if(mysql_num_rows($result) >= 1)
{
$sql_num_rows=(mysql_num_rows($result));
$html = new htmlPlus(); // plus html class
while ($row = $db->fetch_record($result)) # member row
{
$rc_sql = 'SELECT count(*)
FROM ' . RAIDS_TABLE . ' r, ' . RAID_ATTENDEES_TABLE . " ra
WHERE (ra.raid_id = r.raid_id)
AND (ra.member_name='".$row['member_name']."')";
if ( ($result_lifetime = mysql_query($rc_sql)) )
{
$individual_raid_count_all = $db->query_first($rc_sql);
$row['raid_count'] = $individual_raid_count_all ;
}
$outputdkp .= sprintf(TAB.'[' . $member_count . '] = {' . "\n");
$outputdkp .= sprintf(TAB.TAB.TAB.'charInfo = { name = "');
$outputdkp .= sprintf($row['member_name']);
$outputdkp .= sprintf('", class = "');
$outputdkp .= sprintf(strtoupper($row['member_class']));
$outputdkp .= sprintf('", level = ');
$outputdkp .= sprintf($row['member_level']);
$outputdkp .= sprintf(', race = "');
$outputdkp .= sprintf(strtoupper($row['member_race']));
$outputdkp .= sprintf('" },' . "\n". TAB.TAB.TAB.'DKP = { ');
$member_multidkp = $html-> multiDkpMemberArray($row['member_name']) ; // create the multiDKP Table
if(!empty($member_multidkp[$row['member_name']]))
{
foreach ($member_multidkp[$row['member_name']] as $key)
{
$outputdkp .= sprintf('['.$pname.'] = ');
$outputdkp .= sprintf($format_multidkp, $key['current'] );
if ($pname < ($poolcount - 1))
{
$outputdkp .= sprintf(',');
}
$outputdkp .= sprintf(' ');
$pname++;
}
}
$outputdkp .= sprintf('}'."\n".TAB.TAB.'}');
$member_count++;
$mcount = $member_count;
if($mcount < $sql_num_rows)
{
$outputdkp .= sprintf(','."\n");
}
else
{
$outputdkp .= sprintf("\n");
}
$pname = 0;
}
fwrite($fh, $outputdkp);
}
}
fwrite($fh, "}");
$db->free_result($result);
fclose($fh);
?>
Click this link and save the importdata.lua file in your World of Warcraft/Interface/Addons/DKPmon_eqDKP folder
<a href="[url]http://www[/url].[UPDATE WITH THE PATH TO YOUR SITE]/eqdkp/importdata.lua">importdata.lua</a>
Hi,
Been reading the whole thread here and i am still not sure if DKPmon is the correct DKP system for our guild.
But I must say that i am very impressed of what i been reading.
The DKP rules in the guild is the following.
On time bonus
People that is on time will get a ontime bonus. This one i think is no strange thing to do with the DKPMON. Just reward the people that is online in time some dkp in start of the raid.
Hourly based DKP.
On farmbosses the raid should get x amount of dkp. On progress raiding bosses aka not yet downed the raid should get twice the amount. I Guess that the raidleader needs to switch profile DKP earning in the middle of the raid, Since no addon can possible be that inteleigent that i know which boss the raidleader decided to go to next :-)
The possibilty to export the data to a webpage. It seems there is problem with using EQDKP. Does any other solution exist to be able to present the current status of the dkp?
Is those things possible in the current mod?
Is the Javek boss auction mod a way forward?
One thing im missing that my Guild uses is:
Raid Team gets 100% of the points asigned
Members get 80% of the points
Applicants get 60% of the points
No guild members get 0% of the points
is that posible? is it hard to make a plugin for this? becouse my knowledge of lua is not gona let me do it sadly, and its the only thing that its stoping all the guilds of my sever to use this.
I worked on implementing dkpmon last night with a couple of my officers. We are going to use an epgp system. One problem we found is that nobody could get the bidding to work. I discovered that they did not have the bidder_epgp plugin installed. This is because the Bidder_epgp plugin does not show up in the wowace updater. I had to direct everyone to go the files.wowace.com and manually download it. Can you please get the bidder_epgp module in the wowace updater list?
I wanted to propose a few changes to the standby system.
First, the problem:
The standby list doesn't automatically update itself in the background, it requires constant refreshing.
If someone relogs at the exact second you query they won't be on the list. There should be some sort of grace period.
Players can jump on standby after the first check. In my guild we don't allow this as you must be online ready to raid when the raid starts in order to receive standby dkp. This means the dkp leader has to remember who was on standby initially and uncheck people every time they refresh.
Members on alts outside the guild cannot standby
Not sure how common this problem is, but if you had multiple accounts you wouldn't be able to select your main on another account
Note: The last two items would be nice to have in a perfect world but may not be worth the effort.
Proposed Solution:
Make the standby list completly automatic. You would probably want an activate/deactivate button/dewdrop option.
DKPmon would then constantly keep the list populated with everyone on standby. This could be event driven for guild members assuming you can hook into the guild member logged off event. If you assume no one would uncheck their Raid Standby option then whether they're offline effectively determines if they're on standby. Unfortunatly you would have to poll people out of the guild, but just adding them to the database manually for now works.
ON_GUILD_MEMBER_OFFLINE:
* Start a grace timer
* If they log back online remove this timer
* If the timer expires remove them from standby.
This timer should probably be 5 to 10 minutes.
Instead of the current behavior where people are checked when polled, DKPmon should just add them to the standby list, but only checked them if they were previously checked since standby was activated. So in psudeo code it looks something like this:
OnStandbyActivate():
* Create checkedStandbyPlayers table
* Poll and populate standby list with everyone unchecked
* When the user checks players they are added to the checkedStandbyPlayers table
* If someone were to logoff for more than 10 minutes they would leave the list but if they came back on they would automatically be checked when the checkedStandbyPlayers table was consulted.
Optional:
* Allow out of guild players to standby by typing in the dkp leaders name into the Bidder UI. Since the player isn't in the guild you would have to poll them unless you temporarily added them to the friends list or something.
* Allow separate account users to populate their main character list.
Eraslin, are you interested in doing this or would you like me to create a patch? Does everyone like this idea or have better ideas/suggestions?
As long as your talking about standbys is it possible to award the standbys a reduced ammount of dkp over time vs the people in the actual raid? I would like the people in the raid to get the full dkp/time and the people on standby to get a percentage of it.
Can anyone tell me where the dkp points table is? I need to edit some of the values. I thought I could export to csv then edit it and import it back in but the import feature does not seem to work.
Javek:
If you want to write up a patch for that idea, please do. I really haven't had the time to do any recreational coding at all in months -- and, judging by how things are going, I won't until at least Christmas. In your patch, though, include a toggle option for that behaviour; I actually like the current method of doing standby, since I wouldn't use the patch I won't include it unless it can be toggled.
Malice:
What is the CSV import doing if not working? Tonnes of people, including myself, have used it with no issues. I wouldn't recommend manually editing the points table; there are checksums and timestamps in place, and messing with the table outside of DKPmon might mess things up on you.
1 First i do the export and it pops up the text box. I copy the text
2. I close wow and open the import data file and paste the data in. I change the numerical values/ It looks like this :
DKPmon_EPGPCSV_Import_Data = {
Ramhammer:WARRIOR:64:Tauren:25:0:325:0
Miasma:WARLOCK:70:Undead:25:0:325:0}
3. I run wow and select epgp points database import. (I used the epgp csv to export as well)
4. I get the following error:
[2007/11/07 18:45:00-934-x1]: DKPmon_EPGPCSV\importmod.lua:107: bad argument #1 to 'ipairs' (table expected, got nil)
DKPmon_EPGPCSV\importmod.lua:107: in function `PerformImport'
DKPmon_EPGPCSV\importmod.lua:76: in function `OnAccept'
Interface\FrameXML\StaticPopup.lua:2284: in function `StaticPopup_OnClick':
<string>:"*:OnClick":1: in function <[string "*:OnClick"]:1>
That doesn't contain any member names or dkp values, but when I try to import it anyway I get a couple of errors:
: DKPmon_eqDKP\importdata.lua:27:
unexpected symbol near '<'
and the line 89 error that was mentioned earlier in this thread.
I also tried to use Weeladdie's custom PHP script for eqdkp+ and it seemed to export my members wonderfully, but would not grab their DKP values, and I'm not sure why. Any suggestions or pointers to some documentation on the process would be much appreciated.
First let me thank you for developing a well rounded dkp interface.
Our guild is adopting your system with the epgp plugin. I had the Officers download and install dkpmon,dkpmon_epgp,dkpmon_eqdkp and we went on a test run in kara. We came up with a few questions and possible bugs.
1. The Bidder comes up for people on the waitlist and or outside the isntance?
2. Multiple item loot problems. Can we bid off one item at a time to ensure DKP/EP is adjusted before that person can bid on Item #2 or #3?
Currently as in last night the Tier4 Token adn a nice Staff Dropped one person bidding could use both, his priority was the same evne though he bid need on both items. I think we need to auction off 1 item then be able to auction off the next item.
3. We started a log and stopped said log for the raid, reloadedui and could view the log but could not do the eqdkp export. we had no option anywhere we could find to export? we all had the dkpmon_eqdkp mod loaded.
4. Raid time Periodic EP, the points window appeared as the timer was set for but it still had players that had left the raid selected , is there anyway to query the raid before putting the Periodic EP in the awards list? Do we have to go reselect/deselect members everytime the points window appears? IS there a module to use timediff from userjoin to userleave and calculate the periodic EP vlaue at the end of raid?
I know the _epgp modules are addons but I was wondering if you could help me change the bidder _showdkp command to bring up a window that shows more detail info such as EP column,GP Column and the priority currently showDKP only gives us priority not the 2 others. Query dkp shows EP/GP.
Is there a resource or documentation for command line inputs and such?
DKPmon_eqDKP is only for importing, DKPmon_XML is the module you want for exporting stuff (which is mentioned by the DKPmon_eqDKP plugin each time you log on, by the way ;))
You're quite welcome. I try. :-)
As long as they're in the raid group, Bidder will pop up for them. You can do standby with DKPmon with people who aren't in the raid, as long as they're in your guild. Just have them select the "Raid standby" option in their Bidder menu while not in the raid, then when you're awarding points do a "Query standby" in the award window under select standby members. The people on standby can even goof around on alts, as long as they set their "Bidding name" in their Bidder menu to their main.
I don't have any experience with the EPGP plugins. In all of the DKP plugins that I did up, I made a point of allowing the loot-distributer to manually select whichever winner they want from those who "bid" by left-clicking the item in the DKPmon window. Is this option not present in the EPGP plugin?
Otherwise, if you can anticipate this problem before openning bidding on the set of items, you can right-click an item that might be double-bid and remove it from the round of bidding. Then, once the round's done, and loot distributed, reloot the corpse to do the second round.
wT got this one. ;-)
No clue. You're going to want to post this one in the EPGP-module's thread on these forums. I think the author frequents that thread more.
I -think- one of the EPGP authors is working on something like this. Depending on how the EP/GP values are stored in DKPmon's database, it likely involves having the EPGP module add its own showdkp command, and constructing a points window in that.
http://dkpmon.googlepages.com
-Eraslin
I really wanted to use Dahn's dkpMon2Export.php to dump the dkp data from the site into the importdata.lua file. However, despite repeated attempts I couldn't get it to work, as eqDKP Plus assigns the Pools 'on the fly' based on which instances you specify are in which pools.
So I decided to hack together Dahn's work and Corgan's getdkp.php (which does work in eqDKP Plus) to produce the output file.
**WARNING** I am not a php coder at all therefore this code has been put together on a trial and error basis.
Note: I have coded it to produce the importdata.lua file on the server and provide a link to it, so you can right click the link and save the file direct rather than copy and paste.
Anyway, here you go...hope it helps.
Weeladdie
<?php /****************************** * GetDKP Plus * * ? Corgan @ Server Antonidas PvE German -> [url]www.seniorenraid.de[/url] * ------------------ * getdkp.php * * Version 2.4 ******************************/ /****************************** Name: DKPmon2Export.php Revision: $Revision$ Author(s): Dahn (dahnwow@mac.com) Description: Dumps DKP data from eqDKP into a csv based table Dependencies: eqDKP ******************************/ /****************************** Hacked together for eqDKP Plus by Weeladdie ******************************/ ######################## ##Edit to reflect your setup## ######################## $poolcount = 2; $poolNames[0] = "10 Man"; $poolNames[1] = "25 Man"; ############# you dont have to change anything below !!!! ###################################### ################################################################################################# $myFile = "importdata.lua"; $fh = fopen($myFile, 'w+') or die("can't open file"); $version = "2.6"; $total_players = 0; $total_items = 0; $total_points = 0; $eqdkp_version = "1.3.x"; $date_created = date("D M d H:i:s Y"); $startString = "--[START]\n"; $endString = "\n--[END]"; $member_count = 0; $mcount = 0; $pname = 0; define('EQDKP_INC', true); $eqdkp_root_path = './'; include_once($eqdkp_root_path . 'common.php'); ################################################# ##This is the text info which appears at the top of the file## ################################################# // Output headers to force plain text header("Content-type: text/plain"); header("Cache-Control: no-store, no-cache"); fwrite($fh, "--[[\n"); fwrite($fh, " This file was generated by dkpMon2Export.php.\n"); fwrite($fh, "\n"); fwrite($fh, " Each entry in the table corresponds to a member record your database.\n"); fwrite($fh, " The data included in each entry in the table is:\n"); fwrite($fh, " \"<name>:<class>:<level>:<race>:<pool 0 points>:<pool 1 points>:<pool 2 points>:... etc\"\n"); fwrite($fh, " where <class> must be the English name of the class\n"); fwrite($fh, " ie: one of 'WARRIOR', 'MAGE', 'HUNTER', 'PRIEST', 'PALADIN', 'SHAMAN', 'ROGUE', 'DRUID', or 'WARLOCK'\n"); fwrite($fh, " The point value for each pool can be any floating point number so long as it\'s not in exponential format.\n"); fwrite($fh, "]]\n"); fwrite($fh, "\n"); fwrite($fh, "\n"); fwrite($fh, "-- DKP eqDKP dump generated " . $date_created . "\n\n"); fwrite($fh, 'DKPmon_eqDKP = {}' . "\n"); fwrite($fh, 'DKPmon_eqDKP.dkpMonVersion = ' . $version . "\n"); fwrite($fh, "DKPmon_eqDKP.poolCount = " . $poolcount . "\n"); fwrite($fh, "DKPmon_eqDKP.poolNames = {\n"); $curpool=0; while ($curpool < $poolcount) { if ($curpool > 0) fwrite($fh, ",\n"); fwrite($fh, "\t\t" . '[' . $curpool . '] = "' . $poolNames[$curpool] . '"'); $curpool++; } fwrite($fh, "\n\t}\n"); fwrite($fh, 'DKPmon_eqDKP.timestamp = "' . $date_created . "\"\n"); fwrite($fh, 'DKPmon_eqDKP.fileid = ' . time() . "\n"); fwrite($fh, " \n"); fwrite($fh, " \n"); fwrite($fh, "DKPmon_eqDKP.Import_Data = {\n"); ################## # Output Multi DKP## ################## $sql = "SELECT *, m.member_name, c.class_name as member_class, r.race_name as member_race, m.member_earned + m.member_adjustment - m.member_spent as current_dkp FROM ".$table_prefix."members m, ".$table_prefix."classes c, ".$table_prefix."races r WHERE m.member_class_id = c.class_id AND r.race_id = m.member_race_id GROUP BY m.member_name ORDER BY member_name ASC"; if ( !($result = mysql_query($sql)) ) { print $sql ; message_die('Could not obtain member DKP information', '', __FILE__, __LINE__, $sql); } define(TAB, "\t"); define(CRLF, "\r\n"); { $format_multidkp = '%s'; if(mysql_num_rows($result) >= 1) { $sql_num_rows=(mysql_num_rows($result)); $html = new htmlPlus(); // plus html class while ($row = $db->fetch_record($result)) # member row { $rc_sql = 'SELECT count(*) FROM ' . RAIDS_TABLE . ' r, ' . RAID_ATTENDEES_TABLE . " ra WHERE (ra.raid_id = r.raid_id) AND (ra.member_name='".$row['member_name']."')"; if ( ($result_lifetime = mysql_query($rc_sql)) ) { $individual_raid_count_all = $db->query_first($rc_sql); $row['raid_count'] = $individual_raid_count_all ; } $outputdkp .= sprintf(TAB.'[' . $member_count . '] = {' . "\n"); $outputdkp .= sprintf(TAB.TAB.TAB.'charInfo = { name = "'); $outputdkp .= sprintf($row['member_name']); $outputdkp .= sprintf('", class = "'); $outputdkp .= sprintf(strtoupper($row['member_class'])); $outputdkp .= sprintf('", level = '); $outputdkp .= sprintf($row['member_level']); $outputdkp .= sprintf(', race = "'); $outputdkp .= sprintf(strtoupper($row['member_race'])); $outputdkp .= sprintf('" },' . "\n". TAB.TAB.TAB.'DKP = { '); $member_multidkp = $html-> multiDkpMemberArray($row['member_name']) ; // create the multiDKP Table if(!empty($member_multidkp[$row['member_name']])) { foreach ($member_multidkp[$row['member_name']] as $key) { $outputdkp .= sprintf('['.$pname.'] = '); $outputdkp .= sprintf($format_multidkp, $key['current'] ); if ($pname < ($poolcount - 1)) { $outputdkp .= sprintf(','); } $outputdkp .= sprintf(' '); $pname++; } } $outputdkp .= sprintf('}'."\n".TAB.TAB.'}'); $member_count++; $mcount = $member_count; if($mcount < $sql_num_rows) { $outputdkp .= sprintf(','."\n"); } else { $outputdkp .= sprintf("\n"); } $pname = 0; } fwrite($fh, $outputdkp); } } fwrite($fh, "}"); $db->free_result($result); fclose($fh); ?> Click this link and save the importdata.lua file in your World of Warcraft/Interface/Addons/DKPmon_eqDKP folder <a href="[url]http://www[/url].[UPDATE WITH THE PATH TO YOUR SITE]/eqdkp/importdata.lua">importdata.lua</a>Is there a GUI for it? I want to keep things simple for my guild. In fact it'll be time based award and fixed price dkp that is mainly wat i need.
I read all the features but the customising part is scarying me :S
Been reading the whole thread here and i am still not sure if DKPmon is the correct DKP system for our guild.
But I must say that i am very impressed of what i been reading.
The DKP rules in the guild is the following.
Is those things possible in the current mod?
Is the Javek boss auction mod a way forward?
Best Regards
Rambart Eu-Kul Tiras
Raid Team gets 100% of the points asigned
Members get 80% of the points
Applicants get 60% of the points
No guild members get 0% of the points
is that posible? is it hard to make a plugin for this? becouse my knowledge of lua is not gona let me do it sadly, and its the only thing that its stoping all the guilds of my sever to use this.
Tuks - "The Fallen" - Burning Blade -
First, the problem:
Note: The last two items would be nice to have in a perfect world but may not be worth the effort.
Proposed Solution:
Make the standby list completly automatic. You would probably want an activate/deactivate button/dewdrop option.
DKPmon would then constantly keep the list populated with everyone on standby. This could be event driven for guild members assuming you can hook into the guild member logged off event. If you assume no one would uncheck their Raid Standby option then whether they're offline effectively determines if they're on standby. Unfortunatly you would have to poll people out of the guild, but just adding them to the database manually for now works.
ON_GUILD_MEMBER_OFFLINE:
* Start a grace timer
* If they log back online remove this timer
* If the timer expires remove them from standby.
This timer should probably be 5 to 10 minutes.
Instead of the current behavior where people are checked when polled, DKPmon should just add them to the standby list, but only checked them if they were previously checked since standby was activated. So in psudeo code it looks something like this:
OnStandbyActivate():
* Create checkedStandbyPlayers table
* Poll and populate standby list with everyone unchecked
* When the user checks players they are added to the checkedStandbyPlayers table
* If someone were to logoff for more than 10 minutes they would leave the list but if they came back on they would automatically be checked when the checkedStandbyPlayers table was consulted.
Optional:
* Allow out of guild players to standby by typing in the dkp leaders name into the Bidder UI. Since the player isn't in the guild you would have to poll them unless you temporarily added them to the friends list or something.
* Allow separate account users to populate their main character list.
Eraslin, are you interested in doing this or would you like me to create a patch? Does everyone like this idea or have better ideas/suggestions?
-Javek
Javek:
If you want to write up a patch for that idea, please do. I really haven't had the time to do any recreational coding at all in months -- and, judging by how things are going, I won't until at least Christmas. In your patch, though, include a toggle option for that behaviour; I actually like the current method of doing standby, since I wouldn't use the patch I won't include it unless it can be toggled.
Malice:
What is the CSV import doing if not working? Tonnes of people, including myself, have used it with no issues. I wouldn't recommend manually editing the points table; there are checksums and timestamps in place, and messing with the table outside of DKPmon might mess things up on you.
1 First i do the export and it pops up the text box. I copy the text
2. I close wow and open the import data file and paste the data in. I change the numerical values/ It looks like this :
DKPmon_EPGPCSV_Import_Data = {
Ramhammer:WARRIOR:64:Tauren:25:0:325:0
Miasma:WARLOCK:70:Undead:25:0:325:0}
3. I run wow and select epgp points database import. (I used the epgp csv to export as well)
4. I get the following error:
[2007/11/07 18:45:00-934-x1]: DKPmon_EPGPCSV\importmod.lua:107: bad argument #1 to 'ipairs' (table expected, got nil)
DKPmon_EPGPCSV\importmod.lua:107: in function `PerformImport'
DKPmon_EPGPCSV\importmod.lua:76: in function `OnAccept'
Interface\FrameXML\StaticPopup.lua:2284: in function `StaticPopup_OnClick':
<string>:"*:OnClick":1: in function <[string "*:OnClick"]:1>
DKPmon_EPGPCSV_Import_Data = {
"Ramhammer:WARRIOR:64:Tauren:25:0:325:0",
"Miasma:WARLOCK:70:Undead:25:0:325:0"
}
Note the quotation marks around each line of the CSV, and the comma at the end of every line except the last.
http://www.eidolonguild.org/eqdkp/
My dkpMon2Export.php file currently looks like this:
http://rafb.net/p/dkQMt418.html
The output from that files comes out as this:
http://rafb.net/p/NRwqb052.html
That doesn't contain any member names or dkp values, but when I try to import it anyway I get a couple of errors:
: DKPmon_eqDKP\importdata.lua:27:
unexpected symbol near '<'
and the line 89 error that was mentioned earlier in this thread.
I also tried to use Weeladdie's custom PHP script for eqdkp+ and it seemed to export my members wonderfully, but would not grab their DKP values, and I'm not sure why. Any suggestions or pointers to some documentation on the process would be much appreciated.
You're going to have to contact the author of that mod about that one. It's not one of mine...