bbs.5isotoi5.org BBS design based on mysql (4)

5. Layout module design
The so-called classification is more for the telnet server. In cq66 mode, users can
classify according to their own wishes. Anyway, in the end, they will be accessed directly based on the version.
For access to layout articles, the entire article is used as a parameter when storing. The chunking of the article is completed by this layer
. If the upper layer transmits it in units of blocks, all the data will be transmitted in the upper layer. After combining, the parameters will be transmitted to this layer.
Decomposition; when reading, this layer is accessed in block units. If the upper layer wants to access
in full-text units, the merge work is done in the upper layer and this layer does not care.
As for whether to create an independent index without affecting the operation of the upper layer, it is mainly related to the lower-layer database structure, mainly considering feasibility, efficiency requirements, etc.
Where is the permission check performed? Let’s put it on the upper layer. In fact, on the telnet server side,
and the cq66 client will not display special command menus to ordinary users at all. Of course, users can
directly send cq66 commands, and the server still has to check. But you shouldn’t check the function module layer again
without using it. Class BoardManage {
private:
public:
// Classification-related operations
int GetClassNameInfo( int maxclass, char **classid,
char ** classname );
Returns the classification information, Chinese and English names.
int GetBoardName( int maxboards, char *classid,
char **boardname );
Returns the board information in a certain category. For general categories, select directly..
from sboard
where boardclass == .... For special categories, search corresponding table. . . .面 // Modify the privilege of the layout administrator or above
int newclass (Char * NewClassName, Intten);
New classification, ordinary classification is special classification,
int deleteclass (Char * NewClassName);
Delete the classification, but not CAS Cade, That is, this layer is not responsible for consistency, and the upper layer is responsible for changing the classification information of the corresponding layout to something else. To rename a category, delete it first and then create it,
int AddClassBoard( const char *classname, char *newboardname);
Add the already built board to a certain category, specifically for special categories. For general categories, its
effect is the same as modifyboardinfo,
int DeleteClassBoard( const char *classname, char *boardname );
                                                                out out out out out out out of  under                                                                                  To delete a certain board from a classification, is also for special classifications, and for general classifications, the effect is the same as that of modifyboardinfo, the classification attribute of a board can be empty, that is, not Belongs to any category.
// Operations related to version information.
int NewBoard( const char *boardid, char *boardname);
Create a new board and create the corresponding table. Other parameters take default values.
int DeleteBoard( const char *boardid);
Delete a board and delete the corresponding table.
int GetBoardInfo( const char *boardid, char *boardname,
int& numposts, char *masters, char *class,
long &level);
Get the board information.
int ModifyBoardId( const char *oldid, char *newid);
If the English id is changed, the name of the corresponding table should also be changed,
int ModifyBoardInfo( const char *boardid, char *boardname,
int numposts, char *masters, Char *class,
Long level);
Modify the layout information, requires privileges.
// Operations related to layout articles.
int AddText( char *boardid, char *title, char *writer,
char *text );
Add an article to the layout and internally divide the long article into 2k blocks.
int DeleteText(char *boardid, int num);
Deleting an article only makes a mark and does not modify the corresponding table immediately.
int FlushTable( char *boardid );
Refresh the layout and delete the corresponding records of the deleted articles.
int MarkText(char *boardid, int num, char mark);
Mark the article.
int ModifyTitle( char *boardid, int num, char *newtitle );
Modify the title of the article.
int ModifyText(char *boardid, int num, char *newtext);
Modifying the content of the article does not require privileges for your own article.
int GetTextInfo( const char *boardid, int num, char *title,
char *writer, char& mark );
Get the title information of the article.
int GetText( const char *boardid, int num, int block,
char *text );
Read the content of the article, in blocks.
          // Article and author query
               // Return all the query results at once?
int QueryWriter( const char *boardid, char *writer,
char **result);
Query the articles of a certain author on the page.
int QueryTitle( const char *boardid, char *title,
char **result);
Query articles on the forum whose titles contain the specified content.
}
Passing parameters is a rather annoying thing. From an abstract point of view, we hope that the returned data has nothing to do with the bottom layer, so it should be processed. However, from an efficiency point of view, we don’t want the data to be copied multiple times. On the one hand, should the application for space release be completed in the upper layer or in this layer? If you are not careful, it is easy to have memory errors.
The above introduces the bbs design of bbs.5isotoi5.org based on mysql (4), including the content of bbs.5isotoi5.org. I hope it will be helpful to friends who are interested in PHP tutorials.