Home arrow MySQL arrow Page 6 - Data Management Made Easy Using Nennius: Advanced Data Handling

Component Notes - MySQL

Welcome to part three of this tutorial introducing application development for the Nennius engine. In this article, we will enhance the News Manager application from part two.

  1. Data Management Made Easy Using Nennius: Advanced Data Handling
  2. Advanced Application Configuration
  3. Expanding Our Application Menu
  4. Creating the User Comments Component
  5. Creating Component Dependencies
  6. Component Notes
  7. Help Files
  8. File Attachments
By: Brian Vaughn
Rating: starstarstarstarstar / 6
August 03, 2005

print this article



Our Comments component is now fully functional. However, we have not yet created any method for moderators to communicate regarding User Comments. This could be an unfortunate oversight. If one moderator is unsure of whether a comment should be edited/removed but has no way of asking another moderator for advice, what will happen? In order to avoid this scenario, let's allow our moderators to attach private messages, or notes, to each User Comment. This can be done simply by adding the following lines to the end of the '/descriptors/comments.php' file:

# set record notes table info (if notes desired)

$GLOBALS['g_optional_notes_db_table']         = 'comment_notes';

$GLOBALS['g_optional_notes_db_key']           = 'id';

$GLOBALS['g_optional_notes_db_index']         = 'news_id';

$GLOBALS['g_optional_notes_db_user_id']              = 'user_id';

$GLOBALS['g_optional_notes_db_datetime']      = 'datetime';

$GLOBALS['g_optional_notes_db_text']          = 'description';

Now ADMIN users will have the ability to attach private messages to user-submitted comments. These messages may be modified or deleted at a later time.

>>> More MySQL Articles          >>> More By Brian Vaughn

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates


Dev Shed Tutorial Topics: