$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;
}
