AppGini Community Forums

Code: Select all

   function contacten_insert(){
       // mm: save record change data
       $recID=mysql_insert_id();
       sql("insert into membership_userrecords set tableName='contacten', pkValue='$recID',
       memberID=' ".getLoggedMemberID()."', dateAdded=' ".time()."', dateUpdated='".time()." ',
       groupID=' ".getLoggedGroupID().".", $eo);
       
       @mail(
       /*comma-separated listed of recipients */
       "[email protected]",
       
       /*message subject */
       "Database change to the Contacten table notification",
       
       
       /*message contents */
       "A new record has been added by:  ".getLoggedMemberID().
       ".\n\n".
       "To view it, please go to: \n"
       "http://oursite.com/appginidatabasefilefolder/routes_view.php?SelectedID=$redID",
       
       /*sender email */
       "From: [email protected]"
       );

       return (get_magic_quotes_gpc() ? stripslashes($recID) : $recID);

}
	function contacten_before_insert(&$data, $memberInfo, &$args){
	/* verhoog lidaatschapsnummer automatisch met 1 */
 
	/* $data['LidNR'] = 1 + (1 - $data['LidNR']; */ 
		return TRUE;
	}

Code: Select all

function contacten_after_insert($data, $memberInfo, &$args){

Code: Select all

	function routes_after_insert($data, $memberInfo, &$args){

// to compose a message containing the submitted data when changes are done to routes table,
// we need to iterate through the $data array
foreach($data as $field => $value){
$messageData .= "$field: $value \n";
}

$recID=mysql_insert_id();
sql("insert into membership_userrecords set tableName='routes' , pkValue='#recID', 
memberID=' ".getLoggedMemberID()."', dateAdded=' ".time()."', dateUpdated='".time()."',
groupID= ".getLoggedGroupID().".", $eo);
 
@mail(
// mail recipient
"[email protected], [email protected], [email protected], [email protected]",
 
// subject
"A Record in the Routes table of the database was changed - notification",
 
// message
"The following new record was submitted today. To view it, please go to: \n", 
"http://bigschoolbus.com/asdata2/routes_view.php?electedID=$recID  Changes done by {$memberInfo['username']}: \n\n".
$messageData, 
 
// sender address
"From: [email protected]"
);

		return TRUE;

	}

Code: Select all

<?php
   mail(
     "[email protected]", /* better set this to an external email outside your server */
     "Test",
     "If you receive this, mail is working",
     "From: [email protected]"
  );

Code: Select all

function YourTableName_after_update($data, $memberInfo, &$args){

foreach($data as $field => $value){
$messageData .= "$field: $value \n";
}
$recID=mysql_insert_id();
sql("insert into membership_userrecords set tableName='YourTableName' , pkValue='#recID', 
memberID=' ".getLoggedMemberID()."', dateAdded=' ".time()."', dateUpdated='".time()."',
groupID= ".getLoggedGroupID().".", $eo);
 
@mail(
// mail recipient
"[email protected], [email protected]",
 
// subject
"A Record in the Driver Compliance table of the database was changed - notification - Driver RECORD NUMBER-{$data['Record_Id']}",
 
// message
      "The above record {$data['Record_Id']} was just modified by:{$memberInfo['username']} The record was updated on and by:{$data['LastUpdatedby']} \n To view the record please go to \n http://YourDomainName.com/YourAppGiniFileFolder/YourTableName_view.php?SelectedID=".$data['selectedID']."  Newly entered data shows as actual table values below:,
    {$messageData} \n.  The user that changed this record did so from IP Address: {$memberInfo['IP']}  \n\n", 
     
 
// sender address
"[email protected]"
);
   return TRUE;

   }