Design of BBS based on MySQL (i.)

1. System Architecture:
Using modular thinking, divided into 3 layers:
A. Data storage layer: Use MySQL to store all the data of BBS, including user information,
Article data, user letters, user messages, System data (?) ), Key issues:
Database planning, whether or not to use a file to assist.
B. System Functional Layer: complete the basic functions of BBS, composed of multiple parallel modules, downward
Call MySQL's function to access the database, up, accept processing requests, and will handle the
The results are returned to the upper level, and the results of success and other data are returned depending on the type of request. And
The module is highly flexible and can be easily modified to increase. Including:
* * User module, processing the user's registration, basic data modification, permission changes,
Information of the user inquiries.
* * Layout module, complete the article published, read the article, delete the article, the article
Tagging, read and delete permission checks, this module on the database requirements of the highest.
* * Essence area module, including the essence of the article, directory of the increase, delete, move up and down
（？ Read and delete permission check, directory structure is one of the difficulties.
* * Letter modules, including new letters, read and delete letters, letterhead marks, new letters to pass
Know
* * Message modules, including sending messages, receiving messages, new message notifications, message reviews,
Messages are stored in letters.
* * System dynamic module, including the current number of stations, the current dynamic, due to frequent changes,
This type of data can be better achieved with shared memory implementations.
* * Chat module, whether two people chat can learn from the practice of ICQ, by both sides direct calls,
But chat results save letters may be more cumbersome, while, for compatibility with telnet features, when
When the upper service layer is Telnet, it adds a specialized module for processing.
* * Chat room module, using shared memory or database? Open the room, the right inside.
Problem.
You can add new features as needed. For example: Active Kanban module, but for non-
Telnet terminal, the meaning is not as good as ...
C. Service layer: Direct and client dialogue, according to the client's request, invoke the function module to obtain
Data, and then sends the data back to the client, depending on the type of client, to develop different
Service module, and as reasonable as possible to abstract, so that the different service layer, can share
The module of the system function layer. The specific include:
cq66 server, take the original cq66 approach, and re-plan the Protocol to support system functions
Layer of all functions, but to use a dedicated client program (CQ66), if it can be done to
Under Compatibility is better, the client program to upgrade with the server side, the user may have
Little inconvenience. There is a need to add encryption in the process of transmission, similar to SSH.