PHP HelperFunctions::escapeConvert Exemples

Exemple #1

Fichier : callback.php Projet : shophelfer/shophelfer.com-shop

function updateShopAdresses($invoiceAddress, $shippingAddress, $orderId)
{
    if (!$orderId) {
        exit("No order_id given to function updateShopAdresses(). Exit!");
    }
    xtc_db_query("\tUPDATE\t" . HelperFunctions::escapeSql(TABLE_ORDERS) . " \n\t\t\t\t\tSET\t\tbilling_name = '" . HelperFunctions::escapeConvert($invoiceAddress['firstname'], 2) . " " . HelperFunctions::escapeConvert($invoiceAddress['lastname'], 2) . "',\n\t\t\t\t\t\t\tbilling_firstname = '" . HelperFunctions::escapeConvert($invoiceAddress['firstname'], 2) . "',\n\t\t\t\t\t\t\tbilling_lastname = '" . HelperFunctions::escapeConvert($invoiceAddress['lastname'], 2) . "', \n\t\t\t\t\t\t\tbilling_company = '', \n\t\t\t\t\t\t\tbilling_street_address = '" . HelperFunctions::escapeConvert($invoiceAddress['street'], 2) . " " . HelperFunctions::escapeConvert($invoiceAddress['street_number'], 2) . "', \n\t\t\t\t\t\t\tbilling_suburb = '" . HelperFunctions::escapeConvert($invoiceAddress['street_additive'], 2) . "', \n\t\t\t\t\t\t\tbilling_city = '" . HelperFunctions::escapeConvert($invoiceAddress['city'], 2) . "', \n\t\t\t\t\t\t\tbilling_postcode = '" . HelperFunctions::escapeConvert($invoiceAddress['zipcode'], 2) . "', \n\t\t\t\t\t\t\tbilling_state = '', \n\t\t\t\t\t\t\tbilling_country = 'Germany',\n\t\t\t\t\t\t\tbilling_country_iso_code_2 = '" . HelperFunctions::escapeConvert($invoiceAddress['country_code'], 2) . "',\n\t\t\t\t\t\t\tlast_modified = now() \n\t\t\t\t\tWHERE\torders_id = '" . (int) $orderId . "'");
    xtc_db_query("\tUPDATE\t" . HelperFunctions::escapeSql(TABLE_ORDERS) . "\n\t\t\t\t\tSET\t\tdelivery_name = '" . HelperFunctions::escapeConvert($shippingAddress['firstname'], 2) . " " . HelperFunctions::escapeConvert($shippingAddress['lastname'], 2) . "',\n\t\t\t\t\t\t\tdelivery_firstname = '" . HelperFunctions::escapeConvert($shippingAddress['firstname'], 2) . "', \n\t\t\t\t\t\t\tdelivery_lastname = '" . HelperFunctions::escapeConvert($shippingAddress['lastname'], 2) . "', \n\t\t\t\t\t\t\tdelivery_company = '', \n\t\t\t\t\t\t\tdelivery_street_address = '" . HelperFunctions::escapeConvert($shippingAddress['street'], 2) . " " . HelperFunctions::escapeConvert($shippingAddress['street_number'], 2) . "', \n\t\t\t\t\t\t\tdelivery_suburb = '" . HelperFunctions::escapeConvert($shippingAddress['street_additive'], 2) . "', \n\t\t\t\t\t\t\tdelivery_city = '" . HelperFunctions::escapeConvert($shippingAddress['city'], 2) . "', \n\t\t\t\t\t\t\tdelivery_postcode = '" . HelperFunctions::escapeConvert($shippingAddress['zipcode'], 2) . "', \n\t\t\t\t\t\t\tdelivery_state = '', \n\t\t\t\t\t\t\tdelivery_country = 'Germany',\n\t\t\t\t\t\t\tdelivery_country_iso_code_2 = '" . HelperFunctions::escapeConvert($shippingAddress['country_code'], 2) . "',\n\t\t\t\t\t\t\tlast_modified = now() \n\t\t\t\t\tWHERE\torders_id = '" . (int) $orderId . "'");
    echo MODULE_PAYMENT_SOFORT_SR_SUCCESS_ADDRESS_UPDATED . "\n";
}