Forum module (helpdesk system)

Forum features

Key features: 

  • Ask a question (authorized, and unauthorized)
  • Give an answer + correspondence on the question by GUID. Question status. 
  • Posting a question to the forum (if it is published, then the question can no longer be changed).
  • Forum Review
  • Tags for forum questions/topics. 
  • Notifications on the question - to the mail of the user + responsible for the question
  • Answers to the post - likes for them + mark as a Solution (Key answer) - similar to stack overflow.
  • The ability to assign a responsible person for a question (+ automatically assign a responsible person when creating it). 
  • View all questions from the admin by status
  • Styling questions and emails via rich editor

Topic Page:

Managing topics:

Page for managing the topic: 

Continuation of the topic management page: 

Nuances of business logic

  • If you wrote an authorized question , then the question is immediately published on the forum. If an unauthorized user has written, the request is not published immediately on the forum (the manager can then publish it).
  • The author of the topic can mark one of the posts to it as a Solution.  
  • If an unauthorized user - then the user can specify the mail to receive a response to it.
  • The operator can change the author, can publish, can edit the question and comments to it. 

Main Forum blocks

  • Managing topics 
    • ForumTopics table-output of forum questions 
  • Managing thr first topic (question). 
    • ForumTopicPosts table-output of the topic (question) posts 
    • Table forumTopicTags-tags associated with the question.
    • ForumTopic form - managing data on a question
  • Forum list / forum-search by topic with filters and tags.
    • Forms createForumTopic  - ask a Question form
  • Forum - a page of one question with posts on it.
    • Form addForumPost - add a post to a topic
    • Form setForumTopicSolution - mark the post as a solution to the topic
    • Form editForumPost - edit a post
    • Form editForumTopic - edit a topic

 DB tables: 

  • as_tags - universal tags
  • frm_topics - forum topics
  • frm_posts - posts to the topic (or answers to questions) 
  • frm_topicTags - linking tags to posts

Roles: 

  • forumManager - content manager
  • forumAdmin - manages the forum settings (so far the same as forumManager)
  • forumUser - registered forum member

Additional

SQL-tool for creating personal accounts on the site

The essence of the approach and the history of the creation of Falcon Space
Web platform for creating personal accounts

Falcon Space Platform

This is a reduction in the cost of ownership

at the expense of fewer people to support

This is a quick change

while using the program

This is a modern interface

full adaptation for mobile devices

MS SQL web applications. Affiliate program for developers and web studios

You can develop on your own or collaborate with us on Falcon Space web development using only SQL and HTML.
See examples with SQL code
Platform documentation
Working on MS SQL Server
NOTE! Модули, представленные в данном каталоге не являются частью ядра платформы. Это микрорешения, сделанные на базе платформы.
Модули не предполагают автоматического обновления. Развитие, доработка модулей, исправление возможных ошибок/коллизий не входит в стоимость платформы.
Component demo stand
At the stand you can see various components in action - tables, forms, modal windows, diagrams, a map, etc.
Solution demo site
Basic solutions that can be flexibly adapted for yourself - change the appearance, business logic and even the structure of the database.
Discuss the project
Ask the initial questions about the project that concern you right now. We will advise you for free and recommend the best solution.