phpBB.de

Code: Alles auswählen

CREATE TABLE IF NOT EXISTS `phpbb_chat_messages` (
	`msg_id` int(11) unsigned NOT NULL auto_increment,
	`user_id` mediumint(8) unsigned NOT NULL default '0',
	`username` varchar(255) collate utf8_bin NOT NULL default '',
	`time` int(11) unsigned NOT NULL default '0',
	`text` varchar(255) collate utf8_bin NOT NULL default '',
	`color` varchar(6) collate utf8_bin NOT NULL default '',
	PRIMARY KEY  (`msg_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=0;

CREATE TABLE IF NOT EXISTS `phpbb_chat_sessions` (
	`user_id` mediumint(8) unsigned NOT NULL default '0',
	`username` varchar(255) collate utf8_bin NOT NULL default '',
	`last_active` int(11) unsigned NOT NULL default '0',
	`user_status` tinyint(3) unsigned NOT NULL default '0',
	`user_activity` smallint(6) NOT NULL default '0',
	`user_blocked` tinyint(1) NOT NULL default '0',
	UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Code: Alles auswählen

1.	Upload to the server
	--------------------

	Upload the chat folder to your server into your phpBB3 forum directory:
	e.g. http://example.org/phpBB3/chat/


2.	Creation of database tables
	---------------------------

	Execute the provided installation script by visiting the following URL with your browser:
	http://example.org/phpBB3/chat/install.php
	
	Replace "http://example.org/phpBB3/chat/" with the real URL to your chat directory.


3.	Delete the installation script
	------------------------------
	
	Delete the file install.php from the chat directory on your server.

Code: Alles auswählen

// Database connection values:
$config['dbConnection'] = array();
// Database hostname:
$config['dbConnection']['host'] = localhost;
// Database username:
$config['dbConnection']['user'] = xt000012_0002;
// Database password:
$config['dbConnection']['pass'] = mein_passwort^^;
// Database name:
$config['dbConnection']['name'] = xt000012_0002;
// Database type:
$config['dbConnection']['type'] = mySQL;
// Database link:
$config['dbConnection']['link'] = null;