[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Submission form handling
Here is the current implementation I am working on for the simple submission
forms. Let me know if there is anything I am missing or if I translated the
tables wrong. The simple submission is done except for error checking and
user handling, which should be done in a few hours, the rest is still in
progress.
Simple submission stuff:
Table Articles:
Title - insert as text, check ! empty
ProblemDesc - insert as text, check ! empty
Resolution - insert as text, check ! empty (question submission forms should
be used for cases where this is empty)
Keywords - insert as text, space-delimited list of single words
Causes - insert as text, may be left empty
Table ArticleUserXref:
ArticleID - sucked from ID created from Articles insert
UserID - sucked from user handling in scripts
Advanced submission (links to change it after submitting simple):
Related Links:
RelatedLinks Table:
Href - insert as text, strip any http:// the user may add
LinkName - insert as text, check ! empty
LinkDesc - insert as text, may be empty
ArticleLinkXref Table:
ArticleID - int inserted based on article
LinkID - id pulled from RelatedLinks table on link just created
Article Categories:
ArticleCatXref Table:
ArticleID - int inserted based on article
CategoryID - int inserted based on pull-down from Categories
--
-------------------
Daniel E. Markle
syntax@ashtech.net
-------------------