$WA_fieldValues = explode("|", $WA_fieldValuesStr); $WA_columns = explode("|", $WA_columnTypesStr); $WA_where_fieldValuesStr = "" . (isset($_POST["WADAUpdateRecordID"]) ? $_POST["WADAUpdateRecordID"] : "") . ""; $WA_where_columnTypesStr = "none,none,NULL"; $WA_where_comparisonStr = "="; $WA_where_fieldNames = explode("|", $WA_indexField); $WA_where_fieldValues = explode("|", $WA_where_fieldValuesStr); $WA_where_columns = explode("|", $WA_where_columnTypesStr); $WA_where_comparisons = explode("|", $WA_where_comparisonStr); $WA_connectionDB = $database_connDB; mysql_select_db($WA_connectionDB, $WA_connection); if (!session_id()) { session_start(); } $updateParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1); $WhereObj = WA_AB_generateWhereClause($WA_where_fieldNames, $WA_where_columns, $WA_where_fieldValues, $WA_where_comparisons); $WA_Sql = "UPDATE `" . $WA_table . "` SET " . $updateParamsObj->WA_setValues . " WHERE " . $WhereObj->sqlWhereClause . ""; $MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()); if ($WA_redirectURL != "") { if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) { $WA_redirectURL .= (strpos($WA_redirectURL, '?') === false ? "?" : "&") . $_SERVER["QUERY_STRING"]; } header("Location: " . $WA_redirectURL); } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Update paypal_subscriptions</title>
function WA_AB_doManageRelationalTable($WA_valuesList, $WA_appliedString, $WA_appliedList, $WA_connection, $WA_table, $WA_masterKeyField, $WA_masterKeyType, $WA_masterKeyValue, $WA_masterKeyComp, $WA_joinedKeyField, $WA_joinedKeyType, $WA_joinedKeyComp, $WA_fieldNamesStr, $WA_columnTypesStr) { global $WA_AB_Split; $WA_fieldNames = explode("|", $WA_fieldNamesStr); $WA_columns = explode("|", $WA_columnTypesStr); $WA_formerString = ""; $WA_formerList = array(); $WA_insertIDs = ""; $WhereObj = WA_AB_generateWhereClause(array($WA_masterKeyField), array($WA_masterKeyType), array($WA_masterKeyValue), array($WA_masterKeyComp)); $WA_Sql = "SELECT " . $WA_masterKeyField . ", " . $WA_joinedKeyField . " FROM " . $WA_table . " WHERE " . $WhereObj->sqlWhereClause . " ORDER BY " . $WA_joinedKeyField; $WA_mrtJoinRS = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()); if (mysql_num_rows($WA_mrtJoinRS) > 0) { while ($row_WA_mrtJoinRS = mysql_fetch_assoc($WA_mrtJoinRS)) { $WA_formerString .= "^" . $row_WA_mrtJoinRS[$WA_joinedKeyField] . "^"; $WA_formerList[] = $row_WA_mrtJoinRS[$WA_joinedKeyField]; } } for ($n = 0; $n < sizeof($WA_formerList); $n++) { if (strpos($WA_appliedString, "^" . $WA_formerList[$n] . "^") === false) { $deleteParamsObj = WA_AB_generateWhereClause(array($WA_masterKeyField, $WA_joinedKeyField), array($WA_masterKeyType, $WA_joinedKeyType), array($WA_masterKeyValue, $WA_formerList[$n]), array($WA_masterKeyComp, $WA_joinedKeyComp)); $WA_Sql = "DELETE FROM `" . $WA_table . "` WHERE " . $deleteParamsObj->sqlWhereClause; $MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()); } } for ($n = 0; $n < sizeof($WA_appliedList); $n++) { if (strpos($WA_formerString, "^" . $WA_appliedList[$n] . "^") === false) { $WA_insertIDs .= "^" . $WA_appliedList[$n] . "^"; } } for ($n = 0; $n < sizeof($WA_valuesList); $n++) { $WA_fieldValues = explode($WA_AB_Split, str_replace("^MASTERID^", $WA_masterKeyValue, str_replace("^JOINID^", $WA_valuesList[$n][0], $WA_valuesList[$n][1]))); if (strpos($WA_insertIDs, "^" . $WA_valuesList[$n][0] . "^") === false) { if (str_replace("^MASTERID^", "", str_replace("^JOINID^", "", $WA_valuesList[$n][1])) != $WA_AB_Split) { $updateParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1); $WhereObj = WA_AB_generateWhereClause(array($WA_masterKeyField, $WA_joinedKeyField), array($WA_masterKeyType, $WA_joinedKeyType), array($WA_masterKeyValue, $WA_valuesList[$n][0]), array($WA_masterKeyComp, $WA_joinedKeyComp)); $WA_Sql = "UPDATE `" . $WA_table . "` SET " . $updateParamsObj->WA_setValues . " WHERE " . $WhereObj->sqlWhereClause . ""; $MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()); } } else { $insertParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1); $WA_Sql = "INSERT INTO `" . $WA_table . "` (" . $insertParamsObj->WA_tableValues . ") VALUES (" . $insertParamsObj->WA_dbValues . ")"; $MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()); } } }
} $WA_keepQueryString = false; $WA_fieldNamesStr = "UserID"; $WA_columnTypesStr = "',none,''"; $WA_fieldValuesStr = "" . (isset($_POST["WADADeleteRecordID"]) ? $_POST["WADADeleteRecordID"] : "") . ""; $WA_comparisonStr = "="; $WA_fieldNames = explode("|", $WA_fieldNamesStr); $WA_fieldValues = explode($WA_AB_Split, $WA_fieldValuesStr); $WA_columns = explode("|", $WA_columnTypesStr); $WA_comparisions = explode("|", $WA_comparisonStr); $WA_connectionDB = $database_bikes_db; mysql_select_db($WA_connectionDB, $WA_connection); if (!session_id()) { session_start(); } $deleteParamsObj = WA_AB_generateWhereClause($WA_fieldNames, $WA_columns, $WA_fieldValues, $WA_comparisions); $WA_Sql = "DELETE FROM `" . $WA_table . "` WHERE " . $deleteParamsObj->sqlWhereClause; $MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()); if ($WA_redirectURL != "") { if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) { $WA_redirectURL .= (strpos($WA_redirectURL, '?') === false ? "?" : "&") . $_SERVER["QUERY_STRING"]; } header("Location: " . $WA_redirectURL); } } ?> <!DOCTYPE html> <head> <meta charset="utf-8"> <meta https-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
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; }