bbdkp 1.08 b5 install readme

by **Sajaki** » 04 Nov 2008, 11:01

Please find below the installation instructions for a bbkdkp 1.08 b5 full install on an existing phpbb3 forum :
This post overrides all other 1.08 b5 install instructions.

Part0

Requirements

http://www.phpbb.com

- Ftp/file access

- Mysql access : PhpMyAdmin for remote access

http://notepad-plus.sourceforge.net/uk/site.htm

http://www.phpbb.com/mods/documentation/phpbb-documentation/language/index.php

.. and abit of patience

Notes :

MYSQL 4.0 IS not supported (not utf-8 compatible).

new features increasingly require php 5 because of Oop programming features unavalable in php 4

Part1

Step 1:
BACKUP YOUR PHPBB files and SQL TABLES BEFORE MAKING CHANGES

Step 2:
No seriously go BACKUP

Step 3:
download http://bbdkp.googlecode.com/files/bbDKP1.0.8b5_r72.zip

Copy files from the /Main and /plugin directory to your forum root, following the phpbb directory structure

Part2a. Database install

Step 4:
Once all files are in place, open an internet browser and navigate to

http://yoursite/phpbb3/install/install_bbdkp.php

choose your game 'wow','lotro','eq','DAoC','Vanguard-SoH','eq2'

press install.

This installs the core database tables

Part2b. Install plugins

Complete the database setup by launching the plugin installers now

navigate to

http://yoursite/phpbb3/install/install_plugin.php

Launch the plugin database installers (only for Wow atm)
- CTRT
- Bossprogress
- Roster

So now the database install is complete.

The rest is phpbb3 file editing.

Part3: Phpbb3 Core bbDKP edits

Please perform the following edit's in sequence. Please be aware that these edit's are based on the default phpBB3 template, ProSilver. You may need to make adjustments based on the use of an alternate template.
Please do backup the files you are modifying here so that just in case you mess up you can restore it back using the backup

1) Open: /common.php

1a) Find

Code: Select all: require($phpbb_root_path . 'includes/utf/utf_tools.' . $phpEx);

add after :

Code: Select all: // bbDKP require($phpbb_root_path . 'includesdkp/eqdkpfunctions.php'); require($phpbb_root_path . 'includesdkp/eqdkp.php'); $eqdkp_table_prefixx = 'bbeqdkp_'; define('URI_ADJUSTMENT', 'a'); define('URI_EVENT', 'e'); define('URI_ITEM', 'item'); define('URI_LOG', 'l'); define('URI_NAME', 'name'); define('URI_NEWS', 'n'); define('URI_ORDER', 'o'); define('URI_PAGE', 'p'); define('URI_RAID', 'r'); define('URI_SESSION', 's'); define('ADJUSTMENTS_TABLE', $eqdkp_table_prefixx . 'adjustments'); define('EQDKP_CONFIG_TABLE', $eqdkp_table_prefixx . 'config'); define('EVENTS_TABLE', $eqdkp_table_prefixx . 'events'); define('ITEMS_TABLE', $eqdkp_table_prefixx . 'items'); define('LOGS_TABLE', $eqdkp_table_prefixx . 'logs'); define('MEMBERS_TABLE', $eqdkp_table_prefixx . 'members'); define('MEMBER_RANKS_TABLE', $eqdkp_table_prefixx . 'member_ranks'); define('MEMBER_USER_TABLE', $eqdkp_table_prefixx . 'member_user'); define('NEWS_TABLE', $eqdkp_table_prefixx . 'news'); define('RAID_ATTENDEES_TABLE', $eqdkp_table_prefixx . 'raid_attendees'); define('RAIDS_TABLE', $eqdkp_table_prefixx . 'raids'); define('CLASS_TABLE', $eqdkp_table_prefixx . 'classes'); define('RACE_TABLE', $eqdkp_table_prefixx . 'races'); define('FACTION_TABLE', $eqdkp_table_prefixx . 'factions'); define('ARMORY_TABLE', $eqdkp_table_prefixx . 'armory'); define('ARMORY_SETTINGS_TABLE', $eqdkp_table_prefixx . 'armory_settings'); define('BOSSBASE_CONFIG', $eqdkp_table_prefixx . 'bb_config'); define('BOSSBASE_OFFSETS', $eqdkp_table_prefixx . 'bb_offsets'); define('INDEXPAGE_TABLE', $eqdkp_table_prefixx . 'indexpage'); // RAIDPLAN define('RP_CHARS_TABLE', $eqdkp_table_prefixx . 'raidplan_chars'); define('RP_RAIDS_TABLE', $eqdkp_table_prefixx . 'raidplan_raids'); define('RP_RAID_ATTENDEES_TABLE', $eqdkp_table_prefixx . 'raidplan_raid_attendees'); // CTRT define('CTRT_CONFIG_TABLE', $eqdkp_table_prefixx . 'ctrt_config'); define('CTRT_ALIASES_TABLE', $eqdkp_table_prefixx . 'ctrt_aliases'); define('CTRT_EVENT_TRIGGERS_TABLE', $eqdkp_table_prefixx . 'ctrt_event_triggers'); define('CTRT_RAID_NOTE_TRIGGERS_TABLE', $eqdkp_table_prefixx . 'ctrt_raid_note_triggers'); define('CTRT_OWN_RAIDS_TABLE', $eqdkp_table_prefixx . 'ctrt_own_raids'); define('CTRT_ADD_ITEMS_TABLE', $eqdkp_table_prefixx . 'ctrt_add_items'); define('CTRT_IGNORE_ITEMS_TABLE', $eqdkp_table_prefixx . 'ctrt_ignore_items'); define('CTRT_GET_ALL', 0); define('CTRT_GET_BY_ID', 1); define('CTRT_GET_BY_NAME', 2); define('URI_ID', 'id'); define('CTRT_IQ_POOR', 0); define('CTRT_IQ_COMMON', 1); define('CTRT_IQ_UNCOMMON', 2); define('CTRT_IQ_RARE', 3); define('CTRT_IQ_EPIC', 4); define('CTRT_IQ_LEGENDARY', 5); define('CTRT_AF_NONE', 0); // 0 = None define('CTRT_AF_LOOT_TIME', 1); // 1 = Loot Time define('CTRT_AF_BOSS_KILL', 2); // 2 = Boss Kill Time // CTRT // bbDKP

1b) Find :

Code: Select all: $config = $cache->obtain_config();

Add after :

Code: Select all: // bbDKP define('GUILD_NAME', $config['guildtag']); // guild name define('DATE_FORMAT', $config['date_format']); // day.month.year define('USER_ALIMIT', $config['user_alimit']); // adj limit define('USER_ELIMIT', $config['user_elimit']); // event limit define('USER_ILIMIT', $config['user_ilimit']); // item limit define('USER_NLIMIT', $config['user_nlimit']); // news limit define('USER_RLIMIT', $config['user_rlimit']); // raid limit define('USER_LLIMIT', '50'); // log limit define('USER_HIDE_INACTIVE', $config['hide_inactive']); // 1 true 0 false define('USER_ACTIVE_POINT_ADJ', $config['active_point_adj']); // active adj define('USER_INACTIVE_PERIOD', $config['inactive_period']); // inactive period define('USER_INACTIVE_POINT_ADJ', $config['inactive_point_adj']); // inactive adj define('USER_DKP_NAME', $config['dkp_name']); // dkp name // bbDKP

2) Open: /includes/cache.php

Find :

Code: Select all: $sql = 'SELECT config_name, config_value, is_dynamic FROM ' . CONFIG_TABLE;

Replace by :

Code: Select all: $sql = 'SELECT config_name, config_value, is_dynamic FROM ' . CONFIG_TABLE . ' UNION SELECT config_name, config_value, is_dynamic FROM ' . EQDKP_CONFIG_TABLE . ' ORDER BY config_name ';

3) Open: /includes/functions.php

3a) Find :

Code: Select all: 'L_INDEX' => $user->lang['FORUM_INDEX'],

Add after :

Code: Select all: 'L_FORUM' => $user->lang['FORUM_FORUM'],

3b) Find :

Code: Select all: 'U_MEMBERLIST' => append_sid("{$phpbb_root_path}memberlist.$phpEx"),

Add After :

Code: Select all: 'U_MEMBERSLIST' => append_sid("{$phpbb_root_path}memberslist.$phpEx"),

3c) Find :

Code: Select all: 'U_INDEX' => append_sid("{$phpbb_root_path}index.$phpEx"),

Add after :

Code: Select all: 'U_FORUM' => append_sid("{$phpbb_root_path}forum.$phpEx"),

3d) Find :

Code: Select all: 'U_FAQ' => append_sid("{$phpbb_root_path}faq.$phpEx"),

Add After :

Code: Select all: 'U_DKP' => append_sid("{$phpbb_root_path}viewnews.$phpEx"),

3e) if you have phpbb3.0.2 or lower
Find :

Code: Select all: 'U_ACP' => ($auth->acl_get('a_') && $user->data['is_registered']) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", false, true, $user->session_id) : '')

Replace by :

Code: Select all: 'U_ACP' => ($auth->acl_get('a_') && $user->data['is_registered']) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", false, true, $user->session_id) : '', 'U_DKP_ACP' => ($auth->acl_get('a_') && $user->data['is_registered']) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", false, true, $user->session_id . "&i=190") : '',)

3e) if you have phpbb3.0.3
Find :

Code: Select all: 'U_ACP' => ($auth->acl_get('a_') && !empty($user->data['is_registered'])) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", false, true, $user->session_id) : '')

Replace by :

Code: Select all: 'U_ACP' => ($auth->acl_get('a_') && !empty($user->data['is_registered'])) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", false, true, $user->session_id) : '', 'U_DKP_ACP' => ($auth->acl_get('a_') && !empty($user->data['is_registered'])) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", false, true, $user->session_id . "&i=190") : '',)

4) Open: /language/en/common.php

4a) Find :

Code: Select all: 'FAQ' => 'FAQ',

Add After:

Code: Select all: 'DKP' => 'DKP',

4b) Find

Code: Select all: 'FORUM_INDEX' => 'Board index',

Add after :

Code: Select all: 'FORUM_FORUM' => 'Forum',

5) Open: /language/en/acp/permissions_phpbb.php

5a) Find :

Code: Select all: 'user_group' => 'Users & Groups',

Add After :

Code: Select all: 'eqdkp' => 'EQdkp',

5b) Find line 193:

Code: Select all: 'acl_a_board' => array('lang' => 'Can alter board settings/check for updates', 'cat' => 'settings'),

Add After :

Code: Select all: // bbDKP 'acl_a_dkp' => array('lang' => 'DKP - can add/edit dkp', 'cat' => 'eqdkp'), 'acl_a_dkp_no' => array('lang' => 'DKP - can edit dkp settings', 'cat' => 'eqdkp'),

Part4. Credits

If you omit this step we cannot give you support.

Open : Open: /styles/prosilver/template/overall_footer.html

Find :

Code: Select all: Powered by <a href="http://www.phpbb.com/">phpBB</a> © 2000, 2002, 2005, 2007 phpBB Group

Add After:

Code: Select all: <br /> <script type="text/javascript"> function pop_search() { search = window.open('about.php','search','resizable=no,toolbar=no,status=no,height=540,width=680,screenX=50,screenY=25,left=100,top=70') search.focus(); } </script> <a onclick="javascriptpop_search();" style="cursor:pointer;" onmouseover="style.textDecoration='underline';" onmouseout="style.textDecoration='none';"><font color="#105289">BBdkp Credits</font></a> <br />

Part 4A. If you install no index

1) Open: /styles/prosilver/overall_header.html

1a) Find :

Code: Select all: <ul class="linklist rightside">

Add After :

Code: Select all: <li class="icon-register"><a href="{U_DKP}">{L_DKP}</a></li> <li class="icon-home"><a href="forum.php">Forums</a></li>

1b) Open: /styles/subsilver2/template/breadcrumbs.html
Find :

Code: Select all: <p class="breadcrumbs">

Add After :

Code: Select all: <a href="{U_DKP}">{L_DKP}</a>

Part4B. bbDKP Index

Follow this if you want to use the BBDkp Portal.

Caution, first install the Bossprogress database tables if you havent done so at step 2b, because there's a dependency on those tables in the index code.

1) Rename old /index.php to /forum.php
2) Copy index.php to /index.php

3) Open: /forum.php

3a) Find :

Code: Select all: 'U_MARK_FORUMS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}index.$phpEx", 'mark=forums') : '',

Change to :

Code: Select all: 'U_MARK_FORUMS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}forum.$phpEx", 'mark=forums') : '',

4) Open: /styles/prosilver/overall_header.html

find :

Code: Select all: <ul class="linklist rightside">

Add After :

Code: Select all: <li class="icon-home"><a href="{U_INDEX}">{L_INDEX}</a></li> <li class="icon-faq"><a href="{U_DKP}">{L_DKP}</a></li> <li class="icon-home"><a href="{U_FORUM}">{L_FORUM}</a></li>

5) Open: /styles/subsilver2/template/breadcrumbs.html

Find :

Code: Select all: <p class="breadcrumbs">

Add After :

Code: Select all: <a href="{U_INDEX}">{L_INDEX}</a> <a href="{U_DKP}">{L_DKP}</a> <a href="{U_FORUM}">{L_FORUM}</a>

Part5 : CSS

1) Open: /styles/prosilver/theme/stylesheet.css

Find :

Code: Select all: @import url("colours.css");

Add after :

Code: Select all: @import url("classcolor.css");

Open: subsilver2/theme/stylesheet.css

at bottom of page Add :

Code: Select all: .Druid, .Druid:link, .Druid:visited, .Druid:active { text-decoration: none; color: #FF7C0A; } .Druid:link:hover { text-decoration: underline; color: #FF7C0A; } .Hunter, .Hunter:link, .Hunter:visited, .Hunter:active { text-decoration: none; color: #AAD372; } .Hunter:link:hover { text-decoration: underline; color: #AAD372; } .Mage, .Mage:link, .Mage:visited, .Mage:active { text-decoration: none; color: #68CCEF; } .Mage:link:hover { text-decoration: underline; color: #68CCEF; } .Paladin, .Paladin:link, .Paladin:visited, .Paladin:active { text-decoration: none; color: #F48CBA; } .Paladin:link:hover { text-decoration: underline; color: #F48CBA; } .Shaman, .Shaman:link, .Shaman:visited, .Shaman:active { text-decoration: none; color: #214FDE; } .Shaman:link:hover { text-decoration: underline; color: #214FDE; } .Priest, .Priest:link, .Priest:visited, .Priest:active { text-decoration: none; color: #FFFFFF; } .Priest:link:hover { text-decoration: underline; color: #FFFFFF; } .Rogue, .Rogue:link, .Rogue:visited, .Rogue:active { text-decoration: none; color: #FFF468; } .Rogue:link:hover { text-decoration: underline; color: #FFF468; } .Warlock, .Warlock:link, .Warlock:visited, .Warlock:active { text-decoration: none; color: #9382C9; } .Warlock:link:hover { text-decoration: underline; color: #9382C9; } .Warrior, .Warrior:link, .Warrior:visited, .Warrior:active { text-decoration: none; color: #C69B6D; } .Warrior:link:hover { text-decoration: underline; color: #C69B6D; } td.Druid, td.Druid a:link, td.Druid a:visited, td.Druid a:active { text-decoration: none; color: #FF7C0A; } td.Druid a:hover { text-decoration: underline; color: #FF7C0A; } td.Hunter, td.Hunter a:link, td.Hunter a:visited, td.Hunter a:active { text-decoration: none; color: #AAD372; } td.Hunter a:hover { text-decoration: underline; color: #AAD372; } td.Mage, td.Mage a:link, td.Mage a:visited, td.Mage a:active { text-decoration: none; color: #68CCEF; } td.Mage a:hover { text-decoration: underline; color: #68CCEF; } td.Paladin, td.Paladin a:link, td.Paladin a:visited, td.Paladin a:active { text-decoration: none; color: #F48CBA; } td.Paladin a:hover { text-decoration: underline; color: #F48CBA; } td.Shaman, td.Shaman a:link, td.Shaman a:visited, td.Shaman a:active { text-decoration: none; color: #214FDE; } td.Shaman a:hover { text-decoration: underline; color: #214FDE; } td.Priest, td.Priest a:link, td.Priest a:visited, td.Priest a:active { text-decoration: none; color: #d6d6d6; } td.Priest a:hover { text-decoration: underline; color: #d6d6d6; } td.Rogue, td.Rogue a:link, td.Rogue a:visited, td.Rogue a:active { text-decoration: none; color: #FFF468; } td.Rogue a:hover { text-decoration: underline; color: #FFF468; } td.Warlock, td.Warlock a:link, td.Warlock a:visited, td.Warlock a:active { text-decoration: none; color: #9382C9; } td.Warlock a:hover { text-decoration: underline; color: #9382C9; } td.Warrior, td.Warrior a:link, td.Warrior a:visited, td.Warrior a:active { text-decoration: none; color: #C69B6D; } td.Warrior a:hover { text-decoration: underline; color: #C69B6D; }

Part6: Itemstats

1) Open: /itemstats/config_itemstats.php
Set your options or leave defaults as they are. Important : if you want to use the French/German/Spanish wowhead, set line 58 "define('item_lang_default', 'en');" as appropriate :
'fr' for French, 'de' for German

2) Open: /itemstats/config.php
Enter your database info here : dbhost can be left blank

Code: Select all: // Database config define('dbhost', ''); define('dbname', ''); define('dbuser', ''); define('dbpass', '');

3) Open: /styles/prosilver/template/overall_header.html and
Open: /styles/subsilver2/template/overall_header.html

Find :

Code: Select all: { META }

Add after : (Wowhead)

Code: Select all: <link rel="stylesheet" href="itemstats/templates/wowhead.css" type="text/css"> <script src="http://www.wowhead.com/widgets/power.js"></script>

or for Lotr:

Code: Select all: <link rel="stylesheet" href="itemstats/templates/lotro.css" type="text/css"> <script type="text/javascript" src="itemstats/overlib/overlib.js"></script>

4) Open: /viewtopic.php

Find :

Code: Select all: include($phpbb_root_path . 'includes/bbcode.' . $phpEx);

Add After :

Code: Select all: include($phpbb_root_path . 'itemstats/phpbb_itemstats.' . $phpEx);

Find :

Code: Select all: $message = smiley_text($message);

Add after :

Code: Select all: $message = itemstats_parse($message);

5) Adding itemstats preview on the post preview
Open: /posting.php

5a)
find :

Code: Select all: include($phpbb_root_path . 'includes/message_parser.' . $phpEx);

add after :

Code: Select all: include($phpbb_root_path . 'itemstats/phpbb_itemstats.' . $phpEx);

5b) Open: /includes/message_parser.php

find :

Code: Select all: $this->message = smiley_text($this->message, !$allow_smilies);

add after :

Code: Select all: $this->message = itemstats_parse($this->message);

6) Add itemstats bbButton to your posting page. Go to Admin Control Panel > Posting > BBCodes. Press "Add a new BBCode" and enter these settings:
* BBCode usage:

Code: Select all: [item]{SIMPLETEXT}[/item]

* HTML replacement:

Code: Select all: [item]{SIMPLETEXT}[/item]

* Help line: WoW Item Tooltip:

Code: Select all: [item]text[/item] example: [item]862en[/item] or [item]Blight[/item]

* Display on posting page: Yes

7) fixing signature preview.

Open : /includes/ucp/ucp_profile.php
find line 465

Code: Select all: include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

add after :

Code: Select all: include($phpbb_root_path . 'itemstats/phpbb_itemstats.' . $phpEx);

Part7. Final steps

Remove Install folder
Purge cache :
Refresh templates :

bbdkp 1.08 b5 install readme

bbdkp 1.08 b5 install readme

Who is online