Email_Sending event error in register.php

Plorenzo9 · Post by **Plorenzo9** » Thu Aug 08, 2013 3:29 am

I cant acces to Args["rs"] values in the mail event. Error:

Notice: Undefined property: cregister::$AuditTrailOnAdd in C:\xampp\htdocs\pedidosentresectores\register.php on line 1021

Fatal error: Cannot use object of type mysqlt_driver_ResultSet as array in C:\xampp\htdocs\pedidosentresectores\register.php on line 1109

Paste the code here:

// Email Sending event
function Email_Sending(&$Email, &$Args) {
$Email->Subject = "PeS. Registro Nuevo Usuario."; // Change subject
$Email->Content ="Gracias por registrarse en el sistema de Pedidos entre Sectores. ";
$Email->Content .= " ";
$Email->Content .= "Los datos de registro son los soguientes: ";
$Email->Content .= " ";
$Email->Content .=" ";
$Email->Content .= "Sitio: ".$Args["rs"]["sitio"]." "; //line 1109 Fatal Error.
$Email->Content .= " ";
$Email->Content .= "Sector: ".$Args["rs"]["sector"]." ";
$Email->Content .= " ";
$Email->Content .="Nombre: ".$Args["rs"]["nombre"]." ";
$Email->Content .=" ";
$Email->Content .="Usuario: ".$Args["rs"]["usuario"]." ";
$Email->Content .=" ";
$Email->Content .="Iniciales: ".$Args["rs"]["iniciales"]." ";
$Email->Content .=" ";
$Email->Content .="Email: ".$Args["rs"]["email"]." ";
$Email->Content .=" ";
$Email->Content .=" ";
$Email->Content .=" ";
$Email->Content .="Su usuario requiere ser activado por el administrador de sistemas, hasta";
$Email->Content .="tanto no podra acceder al mismo. ";
$Email->Content .="Cualquier duda o consulta, por favor escriba a xxx@xxx.com ";
$Email->Content .=" ";
$Email->Content .="Saludos, Dto Sistemas Amegabiotech.";

	//var_dump($Email); var_dump($Args); exit();
	return TRUE;
}

Any Help? TKS.-

mobhar · Post by **mobhar** » Thu Aug 08, 2013 11:21 am

What is the code in line 1021 and 1109 in your generated register.php file?

danielc · Post by **danielc** » Thu Aug 08, 2013 11:49 am

You are loading recordset not array. Use:
$Args["rs"]->fields("sitio")
// not $Args["rs"]["sitio"]

Plorenzo9 · Post by **Plorenzo9** » Thu Aug 08, 2013 11:52 am

Hi Mobhar, here are the lines, im using phpm v10.1, audit trail is enabled.
<<---<<----1021 marked down in line

// Write Audit Trail (add page)
function WriteAuditTrailOnAdd(&$rs) {
if (!$this->AuditTrailOnAdd) return;//fatal error 1021 <<------------<<---------<<--------<<---------<<--------<<---
$table = 'usuarios';

<<----<<----1109 marked down in line

// Email Sending event
function Email_Sending(&$Email, &$Args) {
$Email->Subject = "PeS. Registro Nuevo Usuario."; // Change subject
$Email->Content ="Gracias por registrarse en el sistema de Pedidos entre Sectores. ";
$Email->Content .= " ";
$Email->Content .= "Los datos de registro son los soguientes: ";
$Email->Content .= " ";
$Email->Content .=" ";
$Email->Content .= "Sitio: ".$Args["rs"]["sitio"]." "; //line 1109 Fatal Error.<<--------<<<-------<<------<<<--------<<<----
$Email->Content .= " ";
$Email->Content .= "Sector: ".$Args["rs"]["sector"]." ";
$Email->Content .= " ";
$Email->Content .="Nombre: ".$Args["rs"]["nombre"]." ";
$Email->Content .=" ";
$Email->Content .="Usuario: ".$Args["rs"]["usuario"]." ";
$Email->Content .=" ";
$Email->Content .="Iniciales: ".$Args["rs"]["iniciales"]." ";
$Email->Content .=" ";
$Email->Content .="Email: ".$Args["rs"]["email"]." ";
$Email->Content .=" ";
$Email->Content .=" ";
$Email->Content .=" ";
$Email->Content .="Su usuario requiere ser activado por el administrador de sistemas, hasta";
$Email->Content .="tanto no podra acceder al mismo. ";
$Email->Content .="Cualquier duda o consulta, por favor escriba a xxx@xxx.com ";
$Email->Content .=" ";
$Email->Content .="Saludos, Dto Sistemas Amegabiotech.";

//var_dump($Email); var_dump($Args); exit();
return TRUE;
}

Plorenzo9 · Post by **Plorenzo9** » Thu Aug 08, 2013 12:00 pm

Perfect! Tks Danielc, that its the error.

Postby danielc Â» Thu Aug 08, 2013 11:49 am
You are loading recordset not array. Use:
$Args["rs"]->fields("sitio")
// not $Args["rs"]["sitio"]

TKS Again.

Post by **Webmaster** » Thu Aug 08, 2013 12:34 pm

That is inconsistent with other pages, to be changed in next build. For the time being, you can modify register.php, change:

$Args["rs"] = &$rsnew;

to:

$Args["rs"] = $rsnew->fields;

Then you'll be able to access the data as in other pages, e.g. $Args["rs"]["xxx"].

Plorenzo9 · Post by **Plorenzo9** » Thu Aug 08, 2013 9:09 pm

Tks Webmaster, tks DanielC.