Style:
welcome to bbDKP.com Downloads Tracker Development Jade Deathwing FreenodeIRC
Developer
Sajaki
Developer
level ?? boss
level ?? boss
Posts: 2278
Joined: 28 Dec 2007, 14:56
Location: Ulduar

bbdkp 1.08 b5 install readme

Postby 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

    - Ftp/file access
    - Mysql access : PhpMyAdmin for remote access


.. 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
    some of the forms contain many components. if your host has the Suhosin PHP extension this may cause malfunction because the default options limiting $_POST and $_REQUEST array, are set to suhosin.post.max_vars 200 and suhosin.request.max_vars 200. You may have to bump these defaults.

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 :D


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> &copy; 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"><!-- overLIB © Erik Bosrup --></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 :
Last edited by Sajaki on 04 Nov 2008, 10:57, edited 9 times in total.


Last bumped by Sajaki on 04 Nov 2008, 11:01.