Database Integration -- Install Chat's database (.NET)

There two ways to keep the data. One is using the file format which is the same as the former version, there is no need for users to setup to use, Users' information and chat history are stored under the Chat server path with an encryption; the other is integrating with the present database by ASP.NET interface through which the users' information and chat history store in the database.
1) First please make sure that your web server supports ASP.net and SQL SERVER
2) Build SQL SERVER database
Operating sql statement of database.sql and build two new datatable: users and log
"users" table is for saving the users' information, the structure is as following
"users" table is for saving the users' information, the structure is as following |
uid |
Primary KEY, autoincrease |
username |
User's name |
password |
Password |
level |
The user's level, the default value is 0, if it is 1 then it is the administrator |
signDate |
Register time |
lastLogin |
The last login time |
"log" table is for chatting history, the structure as is as following |
lid |
Primary KEY, autoincrease |
target |
Massage receiving one |
ip |
The user's IP address |
username |
Massage sending one |
message |
Message content |
date |
Message sending time |
After running sql statement, insert two users in users table
username |
admin |
test |
password |
admin |
test |
level |
Administrator |
Register user |
3) Install Fluorine program
Unzip aspService.zip, go into the Fluorine file after unzipping, use Notepad or other text editor tools to open "Web.config", and modify the code.
Find the two lines of code as following:
<add key="ConnStr" value="uid=sa;password=password;database=flashchat;server=localhost" />
Modify the database server address, database uid and password, database name in sql server as your configuration respectively.
4) Configure Flashchat
After finishing install chat program, log in chat as administrator, and then go to the administrator panel.

In the Setting panel, choose "remote database" in the red pane in the picture. In "Remoting gateway URL" text field, fill the absolute url of gateway.aspx. And then fill the class path of server object in "Remoting class path" text field, save the setting.
TOP
|