Stay on the website (1)-basic functions

Source: Internet
Author: User
Just do something! It's just getting started and skillful. Create a BBS this time to implement the most basic functions
Tool: Asp. net2.0 + sqlserver2005 took a look at the functions and databases today and referred to others. It is simple to implement the most basic functions.

 
Addon BBS

**************************************** ************************************ *********
$
Super administrator $ General Administrator (bamboo) $ general user
-- | -- Delete user $ -- | -- modifyArticle $ -- | -- Post
| -- Modify user information $ | -- add an excellent article $ | -- modify an article
| -- Delete layout $ | -- top an article $ | -- modify Personal Data
| -- Add layout $ | --
| -- Modify layout $ | --
| -- Delete an article $ | --
| -- $
$
**************************************** * ** Database ************************************ ********

User table (forumusertab) Article table (forumarticletab)
-- | -- User ID (usernameid) -- | -- Article ID (ArticleID)
| -- Username | -- article title (articlename)
| -- Nickname (usernickname) | -- Article category (articleclass)
| -- Password | -- author (articleauthor)
| -- Userclass | -- article content (articlecontent)
| -- Email (useremail) | -- post time)
| -- MSN (usermsn) | -- Post IP (articlepostip)
| -- QQ (userqq) | -- layout (articleboardid)
| -- Avatar (userhead) | -- clicks (articlehits)
| -- Signature (usersign) | -- determines whether to stick to the top (articleistop)
| -- Gender (usersex) | -- whether it is articleisgood)
| -- Homepage (userhomepage) | --
| -- Registration time (userregtime) | --
| -- Register an IP address (userregip) | --
| -- Userlogintimes | --
| -- Last Logon Time (userlastlogintime) | --
| -- Last Logon IP address (userlastloginip) | --
| -- Whether to restrict posting (userlocked) | --
| -- Total number of posts (userarticles) | --
| --

Forumboardtab)
-- | -- Layout ID (boardid) -- | -- reply ID (replyid)
| -- Layout name (boardname) | -- Article ID (replyarticleid)
| -- Layout class | -- article title (replyarticlename)
| -- Reply content (replycontent)
| -- Reply to the author (replyauthor)
| -- Reply time (replytime)
| -- Reply IP (replyip)
| --

BBS info table (foruminfotab)
-- | -- BBS info table ID (foruminfoid)
| -- Copyright (foruminfocopyright)
| -- Version (foruminfoversionnumber)
| -- BBS name (foruminfobbsname)
| -- URL (foruminfourl)
| -- Email (foruminfoemail)
| -- Foruminfomaxpeople)
| -- Foruminfomaxpeopletime)
| --

I probably listed the following functions and databases, and I did not expect to add them later.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.