--------------------
Installation Guide
--------------------

Caution:

if you have installed phpBBmychat read update from phpBBmychat.txt

Ok first thing upload room, templates and chat.php to your phpBB2 folder

QUERIES:

CREATE TABLE `phpbb_c_ban_users` (
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '',
`rooms` varchar(100) NOT NULL default '',
`ban_until` int(11) NOT NULL default '0',
`name` varchar(30) NOT NULL default ''
) TYPE=MyISAM;

Now This:

CREATE TABLE `phpbb_c_messages` (
`type` tinyint(1) NOT NULL default '0',
`room` varchar(30) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`m_time` int(11) NOT NULL default '0',
`address` varchar(30) NOT NULL default '',
`message` text NOT NULL
) TYPE=MyISAM;

Now This:

CREATE TABLE `phpbb_c_reg_users` (
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`password` varchar(32) NOT NULL default '',
`firstname` varchar(64) NOT NULL default '',
`lastname` varchar(64) NOT NULL default '',
`country` varchar(64) NOT NULL default '',
`website` varchar(64) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`showemail` tinyint(1) NOT NULL default '0',
`perms` varchar(9) NOT NULL default '',
`rooms` varchar(128) NOT NULL default '',
`reg_time` int(11) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '',
`gender` tinyint(1) NOT NULL default '0',
`name` varchar(30) NOT NULL default ''
) TYPE=MyISAM;

Now This:

CREATE TABLE `phpbb_c_users` (
`room` varchar(30) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`u_time` int(11) NOT NULL default '0',
`status` char(1) NOT NULL default '',
`ip` varchar(16) NOT NULL default '',
UNIQUE KEY `room` (`room`,`username`)
) TYPE=MyISAM;

Now This:

ALTER TABLE `phpbb_users` ADD `firstname` VARCHAR( 32 ) NOT NULL ,
ADD `lastname` VARCHAR( 32 ) NOT NULL ,
ADD `perms` VARCHAR( 9 ) NOT NULL ,
ADD `rooms` VARCHAR( 128 ) NOT NULL ,
ADD `gender` TINYINT( 1 ) NOT NULL ,
ADD `latin1` TINYINT( 1 ) NOT NULL ,
ADD `ip` VARCHAR( 16 ) NOT NULL ,
ADD `name` VARCHAR( 32 ) NOT NULL ,
ADD `chat_joined` INT( 10 ) DEFAULT '0' NOT NULL ,
ADD `language` VARCHAR( 32 ) NOT NULL ,
ADD `website` VARCHAR( 32 ) NOT NULL ,
ADD `email` VARCHAR( 32 ) NOT NULL ,
ADD `hide_email` VARCHAR( 32 ) NOT NULL ;

Now Open:

templates/subSilver/overall_header.tpl

And find:

<a href="{U_LOGIN_LOGOUT}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_login.gif" width="12" height="13" border="0" alt="{L_LOGIN_LOGOUT}" hspace="3" />{L_LOGIN_LOGOUT}</a>&nbsp;</span></td>
</tr>

After that add:

<tr>
<td nowrap="nowrap" align="center" valign="top" height="25"><span class="mainmenu">&nbsp;
<a href="chat.php" target="Chat Room" class="mainmenu" alt="Chat"><img src="templates/subSilver/images/icon_mini_members.gif" width="12" height="13" border="0" alt="Chat" hspace="3" />Chat Room</a>&nbsp;&nbsp;&nbsp;
</span></td>
</tr>

Now Open

phpBB2\templates\subSilver\admin\index_navigate.tpl

SEARCH FOR:

<td class="row1"><span class="genmed"><a href="{U_FORUM_INDEX}" target="main" class="genmed">{L_PREVIEW_FORUM}</a></span></td>
</tr>

ADD UNDER:

<tr>
<td class="row1"><span class="genmed"><a href="http://YOURFORUMHERE/phpBB2/room/admin.php" target="main" class="genmed">Feeta Chat Admin</a></span></td>
</tr>

obviously changing YOURFORUMHERE

Now Open phpBB2\templates\subSilver\feetachat.tpl

And edit

After you have uploaded everything

EDIT:

http://YOURHOST/phpBB2/room/

And change it to where your forum is

room\config\config.lib.php

FIND:

define("C_DB_NAME", 'YOUR DATABASE NAME HERE');
define("C_DB_USER", 'YOUR DATABASE USERNAME HERE');
define("C_DB_PASS", 'YOUR DATABASE PASSWORD HERE');

and fill it in with your database details

That's it you have now installed Feeta phpBB Chat!

 

Also if you wish to make a admin look at Feeta phpBB Chat V1.0\How To Make a Admin\How To Make a Admin.htm