[ippe]

phpBB3 + EQdkp integration





Project news:
24.12.2007 - Project got new website -> http://phpbb3-eqdkp.sourceforge.net/
24.12.2007 - Medraut joined project on SF
16.12.2007 - MonkeyTech joined project on SF
16.12.2007 - Project continue.. new site for support coming / couple developers start hard work =)
30.9.2007 - Project paused. (moving to another city, need buy new computer).
30.7.2007 - Moved cvs to svn.

Current version: beta 1.0.7


Need feedback before release 1.0.8, (dont use on live sites)
On feedback please add link your site phpinfo, thanks
<a href="http://www.explodinglabrats.com/phpbb3+eqdkp1.0.8pre3.rar" target="_blank">http://www.explodinglabrats.com/phpbb3+eqdkp1.0.8pre3.rar</a>


1.0.8 - x.x.2007
- installer
- templates moved /dkp/
- itemstats for lotro
- itemstats wowhead update
- bossbase for lotro
- armory fix
- CTRT template fix + bug fix
- Indexpage + acp config (Recruitment block)
- eq, eq2, lotro, DAoC, Vanguard-SoH support
- ..
- ..


1.0.7 - 16.7.2007
- php4 support to roster
- bossprogress image update
- plugin ctrt-1.16.3 (first test version)


What is phpBB3 + EQdkp integration:
EQdkp+ Integration for phpBB3 is a MOD which does exactly as the name suggests.
It brings together the DKP managment facilites of EQdkp and integrates it fully with phpBB3's facilites. This means your users gain single sign on to dkp, and you gain a clean interface, robust admin facilities and less headaches.
The framework supports multiple games, with the featureset currently varying between games.
For LOTRO these addional features include BossProgress, BossCounter, BossOffset and Itemstats. In addition WoW also includes CT Raidtracker, CT_Import and Armoury integration into the guild roster. Other games have standard EQdkp facilities at this time.
As of the current release, it does not (yet) make coffee.

Theme examples:
Prosilver
Subsilver2
Exploding Labrats
Prodigy
Keepers of the Shadow
Fatal Design
Ars-Chaotica
Phoenix des Arith
Legiones del Caos
Relic

Some nice example missing? send it PM.


EQdkp adminpanel images:
Index
Add member
Add item
Item search (itemstats)
Eqdkp config

On develop:
- Installer
- Lotro support (bossbase, itemstats)
- recruitment block to index (ACP config)

Plugins: (beta)
- CTRaidTracker import
- Roster
- Bossprogress

Todo plugins:
- Raid Planner
- CharManager (required for Raid Planner)
- Attunement/Key Tracker
- Tradeskills
- RaidBanker


Download:
phpBB3 + EQdkp
phpBB3 + EQdkp - Index Page

[ippe]

Quote

I check my PhpAdmin, and there was no table name called 'EQDKP_CONFIG_TABLE' however "EQDKP_CONFIG" WAS present, I simply created the "EQDKP_config_table" and inserted

Yes becoss we define tables in common.php
$eqdkp_table_prefixx = 'eqdkp_';
..
define('EQDKP_CONFIG_TABLE', $eqdkp_table_prefixx . 'config');
..
Now EQDKP_CONFIG_TABLE = eqdkp_config

Can u paste your common.php to http://pastebin.com/

and btw just change also my eqdkp prefixx, found many bugs =)

Quote

PS: I do like what i can see so far ... where is your paypal donations button at???

I did't even think about that..


Btw i have only tested this with:
PHP Version 5.1.2 + 5.0.37-community-nt MySQL Community Edition (GPL)

Edit: i found for that error.. my mistake. Need update README
common.php
find:
define('CONFIG_TABLE', $table_prefixx . 'config');
replace:
define('EQDKP_CONFIG_TABLE', $table_prefixx . 'config');

[ippe]

Dahn, on May 20 2007, 12:02 PM, said:

phpBB RC1 was just released. I'm trying to do a diff now for the integration. Cool project!

Only couple lines in template headers, but nothing important.
I'll hope some person whose mother language is English, fix thoes language files.

[ippe]

Mysticcal, on May 20 2007, 06:24 PM, said:

Ok, so i installed it and everything looks good, only one question, and it may seem like a newbish one, but you mentioned that the mod would pull guild members from the armory website, where would one accomplish that? is it enabled in the current release?

EDIT: Found a config armory in the module adding.... is this for later use? because there are no tables included with the SQL file for it.

Meaby next release it will work.

Edit: atm status done =)

[ippe]

angelninja, on May 19 2007, 07:57 PM, said:

the b1.0.1 version fixxed it... back to some more testing!!

on Your site: phpBB 3.0 + EQDkp Modded by ANGELNINJA <--- wtf is this?
You violate GPL if remove thoes lines overall_footer.html

[ippe]

Dahn, on May 21 2007, 08:31 PM, said:

I'm using RC1 and your 1.0.1 beta to test this out. Add Raid is showing a blank page in the ACP. I'm assuming it might be due to the template but having a hard time finding the error. Have you tried this page? Any suggestions for a fix? I'll post if I find one.

Never get that kind error in my host Omena.org.. but now when i install apache 2.2.4 + php 5.5.2 to my own comp, i will get them.
Thoes errors come from lines:

acp_dkp_raid.php
line 1309
$float = @explode('.', $max_value);

acp_dkp_item.php
line 489
$float = @explode('.', $max_value);

If remove them, thay will show pages but all funtions not work correct. I'll working fix for that.

Edit:
fix to acp_dkp_raid.php

$result = $db->sql_query('SELECT max(event_value) AS max_value FROM ' . EVENTS_TABLE);
		
while ( $row = $db->sql_fetchrow($result) ){
	$max_value = $row['max_value'];
}	
	
if (!isset($max_value)){
	$max_value = 0;
}
		
$float = @explode('.', $max_value);
$format = '%0' . @strlen($float[0]) . '.2f';

fix to acp_dkp_item.php

$result = $db->sql_query('SELECT max(item_value) AS max_value FROM ' . ITEMS_TABLE);
while ( $row = $db->sql_fetchrow($result) ){
	$max_value = $row['max_value'];
}		
$float = @explode('.', $max_value);
$floatlen = @strlen($float[0]);
$format = '%0' . $floatlen . '.2f';

fix to additem.html

function switch_item_val()
{
  document.post.item_name.value  = document.post.select_item_name.options[document.post.select_item_name.selectedIndex].value;
  document.post.item_value.value = document.post.select_item_name.options[document.post.select_item_name.selectedIndex].text.replace(/[^\.0-9]/g, "");
}

[ippe]

coldsun, on May 22 2007, 03:11 AM, said:

If you'd like, i can rewrite the sections that break on mysql4.

Just start write..