MACROMEDIA FLASH MEDIA SERVER 2-INSTALLING FLASH MEDIA SERVER 2 Informacje Techniczne Pobierz pdf (Strona 47)

Database Integration

Install Chat's database (PHP)

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 PHP interface through which the users' information and chat

history store in the database.

1) First please make sure that your web server supports php and MySQL

2) Build MySQL database

please use your MySQL control panel to create a data base named "flashchat".

Operating sql statement of database.sql and build two new data tables: users and log

"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

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

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

1 2 ... 42 43 44 45 46 47 48 49 50 51 52 ... 65 66

Brak uwag

MACROMEDIA FLASH MEDIA SERVER 2-INSTALLING FLASH MEDIA SERVER 2 Informacje Techniczne Strona 47