//WA Database Search Include require_once "../WADbSearch/HelperPHP.php"; //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADApaypal_disputes; //Searchpage: disputes-search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("txn_id", "S_txn_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("case_id", "S_case_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("case_type", "S_case_type", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("case_creation_date", "S_case_creation_date", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payment_date", "S_payment_date", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("receipt_id", "S_receipt_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("verify_sign", "S_verify_sign", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payer_email", "S_payer_email", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payer_id", "S_payer_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("invoice", "S_invoice", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("reason_code", "S_reason_code", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("custom", "S_custom", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("notify_version", "S_notify_version", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("creation_timestamp", "S_creation_timestamp", "AND", "=", 2); $WADbSearch1->addComparisonFromEdit("ipn_status", "S_ipn_status", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("txn_type", "S_txn_type", "AND", "Includes", 0);
//WA Database Search Include require_once "../WADbSearch/HelperPHP.php"; //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADApaypal_order_items; //Searchpage: orders-items-search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("order_id", "S_order_id", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("refund_id", "S_refund_id", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("item_name", "S_item_name", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("item_number", "S_item_number", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("os0", "S_os0", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("on0", "S_on0", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("os1", "S_os1", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("on1", "S_on1", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("quantity", "S_quantity", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("custom", "S_custom", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("mc_handling", "S_mc_handling", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("mc_shipping", "S_mc_shipping", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("creation_timestamp", "S_creation_timestamp", "AND", "=", 2); $WADbSearch1->addComparisonFromEdit("raw_log_id", "S_raw_log_id", "AND", "=", 1); //save the query in a session variable
$row_father = mysql_fetch_assoc($father); $totalRows_father = mysql_num_rows($father); //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADAcategory; //Searchpage: category_search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search"]) || isset($_GET["Search_x"])) { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("cat_name", "cat_name", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("cat_desc", "cat_desc", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("cat_father_id", "cat_father_id", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("hide", "hide", "AND", "=", 1); //save the query in a session variable if (1 == 1) { $_SESSION["WADbSearch1_category_results"] = $WADbSearch1->whereClause; } } else { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //get the filter definition from a session variable if (1 == 1) { if (isset($_SESSION["WADbSearch1_category_results"]) && $_SESSION["WADbSearch1_category_results"] != "") { $WADbSearch1->whereClause = $_SESSION["WADbSearch1_category_results"]; } else {
//WA Database Search Include require_once "../WADbSearch/HelperPHP.php"; //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADApaypal_recurring_payments; //Searchpage: recurring-payments-search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("protection_eligibility", "S_protection_eligibility", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payment_date", "S_payment_date", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payment_status", "S_payment_status", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("mc_fee", "S_mc_fee", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("notify_version", "S_notify_version", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payer_status", "S_payer_status", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("currency_code", "S_currency_code", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("verify_sign", "S_verify_sign", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("amount", "S_amount", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("txn_id", "S_txn_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payment_type", "S_payment_type", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("receiver_email", "S_receiver_email", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("receiver_id", "S_receiver_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("txn_type", "S_txn_type", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("mc_currency", "S_mc_currency", "AND", "Includes", 0);
//WA Database Search Include require_once "../WADbSearch/HelperPHP.php"; //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADApaypal_recurring_payment_profiles; //Searchpage: recurring-payment-profiles-search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("payment_cycle", "S_payment_cycle", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("txn_type", "S_txn_type", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("last_name", "S_last_name", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("first_name", "S_first_name", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("next_payment_date", "S_next_payment_date", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("residence_country", "S_residence_country", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("initial_payment_amount", "S_initial_payment_amount", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("rp_invoice_id", "S_rp_invoice_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("currency_code", "S_currency_code", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("time_created", "S_time_created", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("verify_sign", "S_verify_sign", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("period_type", "S_period_type", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payer_status", "S_payer_status", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payer_email", "S_payer_email", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("receiver_email", "S_receiver_email", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payer_id", "S_payer_id", "AND", "Includes", 0);
//WA Database Search Include require_once "../WADbSearch/HelperPHP.php"; //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADApaypal_mass_payments; //Searchpage: mass-payments-search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("masspay_txn_id", "S_masspay_txn_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("mc_currency", "S_mc_currency", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("mc_fee", "S_mc_fee", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("receiver_email", "S_receiver_email", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("status", "S_status", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("unique_id", "S_unique_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("creation_timestamp", "S_creation_timestamp", "AND", "=", 2); $WADbSearch1->addComparisonFromEdit("ipn_status", "S_ipn_status", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("txn_type", "S_txn_type", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("test_ipn", "S_test_ipn", "AND", "=", 1); //save the query in a session variable if (1 == 1) { $_SESSION["WADbSearch1_masspaymentsresults"] = $WADbSearch1->whereClause; } } else {
//WA Database Search Include require_once "../WADbSearch/HelperPHP.php"; //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADApaypal_orders; //Searchpage: orders-search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("receiver_email", "S_receiver_email", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payment_status", "S_payment_status", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("pending_reason", "S_pending_reason", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payment_date", "S_payment_date", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("mc_fee", "S_mc_fee", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("tax", "S_tax", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("mc_currency", "S_mc_currency", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("txn_id", "S_txn_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("txn_type", "S_txn_type", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("first_name", "S_first_name", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("last_name", "S_last_name", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("address_street", "S_address_street", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("address_city", "S_address_city", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("address_state", "S_address_state", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("address_zip", "S_address_zip", "AND", "Includes", 0);
} require_once "../../webassist/database_management/wada_search.php"; //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADAarticles; //Searchpage: articles_search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search"]) || isset($_GET["Search_x"])) { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("articlesType", "articlesType", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("artlicesLive", "artlicesLive", "AND", "=", 1); //save the query in a session variable if (1 == 1) { $_SESSION["WADbSearch1_articles_results"] = $WADbSearch1->whereClause; } } else { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //get the filter definition from a session variable if (1 == 1) { if (isset($_SESSION["WADbSearch1_articles_results"]) && $_SESSION["WADbSearch1_articles_results"] != "") { $WADbSearch1->whereClause = $_SESSION["WADbSearch1_articles_results"]; } else { $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere; }
//WA Database Search Include require_once "../WADbSearch/HelperPHP.php"; //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADApaypal_raw_log; //Searchpage: raw-log-search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("created_timestamp", "S_created_timestamp", "AND", "=", 2); $WADbSearch1->addComparisonFromEdit("ipn_data_serialized", "S_ipn_data_serialized", "AND", "Includes", 0); //save the query in a session variable if (1 == 1) { $_SESSION["WADbSearch1_rawlogresults"] = $WADbSearch1->whereClause; } } else { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //get the filter definition from a session variable if (1 == 1) { if (isset($_SESSION["WADbSearch1_rawlogresults"]) && $_SESSION["WADbSearch1_rawlogresults"] != "") { $WADbSearch1->whereClause = $_SESSION["WADbSearch1_rawlogresults"]; } else { $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere; }
//WA Database Search Include require_once "../WADbSearch/HelperPHP.php"; //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADApaypal_subscription_payments; //Searchpage: subscription-payments-search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("first_name", "S_first_name", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("last_name", "S_last_name", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payer_email", "S_payer_email", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("memo", "S_memo", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("item_name", "S_item_name", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("item_number", "S_item_number", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("os0", "S_os0", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("on0", "S_on0", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("os1", "S_os1", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("on1", "S_on1", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("quantity", "S_quantity", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("payment_date", "S_payment_date", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payment_type", "S_payment_type", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("txn_id", "S_txn_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("mc_fee", "S_mc_fee", "AND", "=", 1);
//WA Database Search Include require_once "../WADbSearch/HelperPHP.php"; //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADApaypal_subscriptions; //Searchpage: subscriptions-search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("custom", "S_custom", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("subscr_id", "S_subscr_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("subscr_date", "S_subscr_date", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("subscr_effective", "S_subscr_effective", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("period1", "S_period1", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("period2", "S_period2", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("period3", "S_period3", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("amount1", "S_amount1", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("amount2", "S_amount2", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("amount3", "S_amount3", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("mc_amount1", "S_mc_amount1", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("mc_amount2", "S_mc_amount2", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("mc_amount3", "S_mc_amount3", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("recurring", "S_recurring", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("reattempt", "S_reattempt", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("retry_at", "S_retry_at", "AND", "Includes", 0);
//WA Database Search Include require_once "../WADbSearch/HelperPHP.php"; //WA Database Search (Copyright 2005, WebAssist.com) //Recordset: WADApaypal_refunds; //Searchpage: refunds-search.php; //Form: WADASearchForm; $WADbSearch1_DefaultWhere = ""; if (!session_id()) { session_start(); } if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") { $WADbSearch1 = new FilterDef(); $WADbSearch1->initializeQueryBuilder("MYSQL", "1"); //keyword array declarations //comparison list additions $WADbSearch1->addComparisonFromEdit("ipn_status", "S_ipn_status", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("invoice", "S_invoice", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("protection_eligibility", "S_protection_eligibility", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payer_id", "S_payer_id", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("address_street", "S_address_street", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payment_date", "S_payment_date", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("payment_status", "S_payment_status", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("charset", "S_charset", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("address_zip", "S_address_zip", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("mc_shipping", "S_mc_shipping", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("mc_handling", "S_mc_handling", "AND", "=", 1); $WADbSearch1->addComparisonFromEdit("first_name", "S_first_name", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("memo", "S_memo", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("last_name", "S_last_name", "AND", "Includes", 0); $WADbSearch1->addComparisonFromEdit("product_name", "S_product_name", "AND", "Includes", 0);