Guestbook.. approve or reject entries before being entered in DB

Hi,
you can do the following:

1. add new field to the table on the Datasource tables tab where status of added record will be stored,
   
2. edit SQL query on the Edit SQL query tab.
   
   Here is a sample:
   

   select field1,
   

   
   field2,
   
   ...
   
   fieldN
   
   from TableName
   
   where Status='approved'

2. fill Status field with non-approved value on the Before record updated event and send email.
Then admin can change value of Status field and this record will appear on the page.

Hi,

1. add new field to the table on the Datasource tables tab where status of added record will be stored,
   
2. edit SQL query on the Edit SQL query tab.
   
   Here is a sample:
   
3. fill Status field with non-approved value on the Before record updated event and send email.
   I know this post is a bit older... is there a way to do it without going back into PHPRUNNER... I make so many html changes to the templates that recreating the pages can be very frustrating... Can anyone give a step by step guide to making these changes to the code?
   Thank you!
   Then admin can change value of Status field and this record will appear on the page.
   

Bump

Hi,
use events to modify SQL query (Before SQL query event), fill status field with required value and send email to admin (Before record added event).

To add events edit generated include/..._events.php file.