function WA_AB_cleanUpEquality($tEquality) { if (preg_replace('/^\\s*|\\s*$/', "", $tEquality) != "=") { return WA_AB_cleanUpColumnName($tEquality); } return $tEquality; }
function processEvent($isError) { if ($this->ToDo == "none") { return true; } if (sizeof($this->ColumnList) == 0) { return false; } $LogIncludeDirectory = getcwd(); chdir(dirname(__FILE__)); require "../../Connections/" . $this->Connection . ".php"; if (!function_exists("WA_AB_generateInsertParams")) { require_once "../database_management/wa_appbuilder_php.php"; } chdir($LogIncludeDirectory); eval("\$" . "logConnection = \$" . $this->Connection . ";"); eval("\$" . "logDatabase = \$" . "database_" . $this->Connection . ";"); mysql_select_db($logDatabase, $logConnection); $insertParams = WA_AB_generateInsertParams($this->ColumnList, $this->TypeList, $this->ValueList, -1); switch ($this->ToDo) { case "update": $emailToValue = ""; $emailToType = "',none,''"; for ($n = 0; $n < sizeof($this->ColumnList); $n++) { if ($this->ColumnList[$n] == $this->EmailColumn) { $emailToValue = $this->ValueList[$n]; $emailToType = $this->TypeList[$n]; break; } } if (!$emailToValue && isset($_SESSION[$this->MailRef . "_To"])) { $emailToValue = $_SESSION[$this->MailRef . "_To"]; } if ($emailToValue) { $toArrUpdate = WA_getEmailArray($emailToValue); $emailToValue = $toArrUpdate[0][1]; if ($emailToValue) { //check to see if record exists then update / insert as needed $whereClause = WA_AB_generateWhereClause(array($this->EmailColumn), array($emailToType), array($emailToValue), array("=")); //$logUpdateTest = mysql_query("SELECT ".WA_AB_cleanUpColumnName($this->EmailColumn)." FROM ".WA_AB_cleanUpColumnName($this->TableName)." WHERE ".$whereClause->sqlWhereClause, $logConnection) or die(mysql_error()); //if (mysql_num_rows($logUpdateTest) > 0) { //do update $logUpdate = mysql_query("UPDATE " . WA_AB_cleanUpColumnName($this->TableName) . " SET " . $insertParams->WA_setValues . " WHERE " . $whereClause->sqlWhereClause, $logConnection) or die(mysql_error()); //break; //} } } //mysql_free_result($logUpdateTest); break; case "create": //create email_log table in database (if it doesn't exist) and insert //creation handled by UI //break; // do not break, continue to insert //create email_log table in database (if it doesn't exist) and insert //creation handled by UI //break; // do not break, continue to insert case "insert": //insert record to table $logInsert = mysql_query("INSERT INTO " . WA_AB_cleanUpColumnName($this->TableName) . " (" . $insertParams->WA_tableValues . ") VALUES (" . $insertParams->WA_dbValues . ")", $logConnection) or die(mysql_error()); break; } return true; }