[michaelxu]

Q:How do I integrate the 123flashchat into my mysql database?

A:1) Create database.

Input the following instructions in the MS-DOS window in a Windows server or command prompt in a Linux server:
<mysql installed directory>/bin/mysql --user=[user] --password=[password] --execute="CREATE DATABASE flashchat CHARACTER SET utf8 COLLATE utf8_bin;"

The [user],[password] here is MySQL account.

(2) Import 123FlashChat table.

Enter the following commends in command prompt:
<mysql installed directory>/bin/mysql --user=[user] --password=[password] --default-character-set=utf8 flashchat < <123flashhcat installed directory>/server/etc/mysql.sql.

(3) Modify fcserver.xml.
3.1 Open this file: <123flashchat installed directory>/server/etc/fcserver.xml.
3.2 Find this node: <database-mode>Default</database-mode>, and change "Default" to MySQL.
3.3 Find this node: <database-server port="9001" ip="localhost" enable="On"></database-server>, and change enable="On" to enable="Off".

(4) Configure Mysql.xml
Open this file: <123flashchat installed directory>server/etc/Mysql.xml, and configure the relevant parameters according to the instructions, the section between <connection-pool>...</connection-pool> is database connection pool configuration and may be not need to be modified.

Keywords:flash chat, flash chat client, flash chat room, flash chat script, flash chat software, flashchat