WordPress database error: [Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=']
(
SELECT 0 AS is_personal, 1 AS is_ip, status, country_code, network, mask
FROM wp_xxcdtb_spbc_firewall_data_v4
WHERE network IN (58720256,59244544,59375616,59392000,59400192,59404288,59404544,59404672,59404704,59404720,59404728,59404732)
AND network = 59404732 & mask
AND country_code = "0"
) UNION (
SELECT 1 AS is_personal, 1 AS is_ip, status, 0 AS country_code, network, mask
FROM wp_xxcdtb_spbc_firewall__personal_ips_v4
WHERE network IN (58720256,59244544,59375616,59392000,59400192,59404288,59404544,59404672,59404704,59404720,59404728,59404732)
AND network = 59404732 & mask
) UNION (
SELECT 1 AS is_personal, 0 AS is_ip, tbl_private.status, country_code, network, mask
FROM wp_xxcdtb_spbc_firewall__personal_countries AS tbl_private
RIGHT JOIN wp_xxcdtb_spbc_firewall_data_v4 AS tbl_common USING(country_code)
WHERE network IN (58720256,59244544,59375616,59392000,59400192,59404288,59404544,59404672,59404704,59404720,59404728,59404732)
AND network = 59404732 & mask
AND tbl_private.status IS NOT NULL
AND 78430 <> 0
)
"First Name" field is required.
"Last Name" field is required.
"Street Address" field is required.
"City" field is required.
"ZIP Code" field is required.
"State" field is required.
"Country" field is required.
"Cardholder Name" field is required.
"Card Number" field is required.
"Expiration Date" field is required.
"Expiration Date" field is required.
"Security Code" field is required.
No card info sent
Deprecated: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in
/home/jasonvincik/magicprintbox.net/wp-includes/kses.php on line
1685
-
8 x 6.5 Postcards
14pt C2S
Matte/Dull Finish
4/4 Full Color
Qty: 2,171
$390.32
1
8.875%
$424.96
-
Postage
USPS Every Door Direct
Magic Print Box USPS Approved Indicia (required)
$334.33
1
8.875%
$364
-
Fulfillment Services
Mail Piece Setup, Bundling, USPS Paperwork, Delivery to USPS
$234.03
1
8.875%
$254.80
Notes
- Selected Routes:
-
10003-C025
-
10003-C026
-
10003-C042
-
10003-C045
-
10003-C046
-
10003-C084
- Price does not include graphic design services. Customer is responsible for using a USPS approved Magic Print Box template to deliver print-ready artwork.
- Minimum turnaround time for Full Service EDDM orders is 12 days. The 12 day turnaround includes Print, EDDM Processing, and delivery time to Local USPS Location.
Terms
Invoices & Payment
Magic Print Box accepts all major credit cards for payment. Cash will not be accepted for products and services. Rates and fees quoted in the Agreement are subject to change until the Agreement is accepted by the customer. Factors that can alter rates and fees can include fluctuations in the cost of fuel, inks, and papers, and are out of the control of Magic Print Box.
Unless otherwise noted, all invoices are due upon receipt. All outstanding invoices must be paid in full before new orders will be accepted by Magic Print Box. Past due invoices are subject to late fees in the amount of 5% of the total amount due, and are assessed at the sole discretion of Magic Print Box. While Magic Print Box may offer a grace period on outstanding invoices, customers who abuse this policy are subject to accumulation of late fee charges, and the forfeit of a grace period on future invoices. Unless otherwise noted in the Agreement, offering a grace period option on invoices is at the sole discretion of Magic Print Box, and is not a guaranteed benefit.
Product Delivery
Magic Print Box, and its parent company Vincik Enterprises LLC, assume no liability for delayed delivery of products by third party shipping carriers. In the event a product does not pass quality assurance testing while in production, Magic Print Box will re-print the product in our priority queue, and notify the customer of the delay. Magic Print Box will make every effort to expedite the re-printed product order, and ship it to the customer as close to the estimated delivery date as possible.
Production Times
All production turnaround times quoted in the Agreement are estimates only. Magic Print Box makes every effort to produce printed products quickly and efficiently while maintaining quality. Please allow a minimum of 3-5 business days for print production of most standard products, not including time for delivery by third party shipping carriers. Large orders, custom printed products, and products produced in non-local facilities can take longer to produce. Please refer to the Agreement for production estimates and print facility location.
View full terms of service here.
Imported
January 1, 1970 @ 12:33 am
{"ID":"424","post_author":"1","post_date":"2016-11-29 12:29:12","post_date_gmt":"2016-11-29 17:29:12","post_content":"
\n \t
Selected Routes:\n
\n \t
\n
10003-C025\n \t
\n
10003-C026\n \t
\n
10003-C042\n \t
\n
10003-C045\n \t
\n
10003-C046\n \t
\n
10003-C084\n\n\n \t
Price does not include graphic design services. \u00a0Customer is responsible for using a USPS approved Magic Print Box template to deliver print-ready artwork.\n \t
Minimum turnaround time for Full Service EDDM orders is 12 days. The 12 day turnaround includes Print, EDDM Processing, and delivery time to Local USPS Location.\n","post_title":"QUOTE: Red Fleece Cafe Direct Mail Piece","post_excerpt":"","post_status":"active","comment_status":"closed","ping_status":"closed","post_password":"","post_name":"quote-red-fleece-cafe-direct-mail-piece","to_ping":"","pinged":"","post_modified":"2017-01-07 15:46:50","post_modified_gmt":"2017-01-07 20:46:50","post_content_filtered":"","post_parent":"0","guid":"https:\/\/www.magicprintbox.net\/wpi_object\/quote-red-fleece-cafe-direct-mail-piece\/","menu_order":"0","post_type":"wpi_object","post_mime_type":"","comment_count":"0","invoice_id":"47325397","deposit_amount":"0","due_date_year":"2017","due_date_month":"02","due_date_day":"06","default_currency_code":"USD","tax":"8.875","custom_id":"83893981","type":"invoice","use_manual_payment":"off","default_payment_method":"wpi_authorize","tax_method":"after_discount","billing":{"wpi_authorize":{"allow":"on","default_option":"true","settings":{"gateway_username":{"value":"100156444524","label":"API Login ID","description":"Your credit card processor will provide you with a gateway username."},"gateway_tran_key":{"value":"R4QOR1O059KVNYSF0I.87HJAG0RTTH3Q","label":"API Transaction Key","description":"You will be able to generate this in your credit card processor's control panel."},"gateway_url":{"value":"https:\/\/secure.bluepay.com\/gateway\/transact.dll","label":"Gateway URL","description":"This is the URL provided to you by your credit card processing company.","special":{"MerchantPlus":"https:\/\/gateway.merchantplus.com\/cgi-bin\/PAWebClient.cgi","Authorize.Net":"https:\/\/secure2.authorize.net\/gateway\/transact.dll","Authorize.Net Developer":"https:\/\/test.authorize.net\/gateway\/transact.dll"}},"recurring_gateway_url":{"value":"","label":"Recurring Billing Gateway URL","description":"Recurring billing gateway URL is most likely different from the Gateway URL, and will almost always be with Authorize.net. Be advised - test credit card numbers will be declined even when in test mode.","special":{"Authorize.net ARB":"https:\/\/api2.authorize.net\/xml\/v1\/request.api","Authorize.Net ARB Testing":"https:\/\/apitest.authorize.net\/xml\/v1\/request.api"}},"gateway_test_mode":{"value":"FALSE","label":"Test \/ Live Mode","type":"select","data":{"TRUE":"Test - Do Not Process Transactions","FALSE":"Live - Process Transactions"}},"gateway_delim_char":{"value":",","label":"Delimiter Character","description":"Get this from your credit card processor. If the transactions are not going through, this character is most likely wrong."},"gateway_encap_char":{"value":"","label":"Encapsulation Character","description":"Authorize.net default is blank. Otherwise, get this from your credit card processor. If the transactions are going through, but getting strange responses, this character is most likely wrong."},"gateway_email_customer":{"value":"TRUE","label":"Email Customer (on success)","type":"select","data":{"TRUE":"Yes","FALSE":"No"}},"gateway_merchant_email":{"value":"jason@marcommpro.net","label":"Merchant Email","description":"Email address to which the merchant's copy of the customer confirmation email should be sent. If a value is submitted, an email will be sent to this address as well as the address(es) configured in the Merchant Interface."},"gateway_header_email_receipt":{"value":"","label":"Customer Receipt Email Header"},"gateway_MD5Hash":{"value":"","label":"Security: MD5 Hash"},"gateway_delim_data":{"value":"TRUE","label":"Delim Data","type":"select","data":{"TRUE":"Yes","FALSE":"No"}},"silent_post_url":{"value":"https:\/\/www.magicprintbox.net\/wp-admin\/admin-ajax.php?action=wpi_gateway_server_callback&type=wpi_authorize","label":"Silent Post URL","type":"readonly","description":"Silent Post responses are returned in real-time, meaning as soon as the transaction processes the Silent Post is sent to your specified URL. Go to https:\/\/account.authorize.net -> Settings -> Silent Post URL and copy this URL to input field. Required only for Recurring Billing and not for all Merchants."}},"name":"Credit Card"}},"itemized_list":{"1":{"name":"8 x 6.5 Postcards","description":"14pt C2S\nMatte\/Dull Finish\n4\/4 Full Color\nQty: 2,171","quantity":"1","price":"390.32","tax_rate":"8.875","line_total_tax":34.6409,"line_total_before_tax":390.32,"line_total_after_tax":424.9609},"2":{"name":"Postage","description":"USPS Every Door Direct\nMagic Print Box USPS Approved Indicia (required)","quantity":"1","price":"334.33","tax_rate":"8.875","line_total_tax":29.6717875,"line_total_before_tax":334.33,"line_total_after_tax":364.0017875},"3":{"name":"Fulfillment Services","description":"Mail Piece Setup, Bundling, USPS Paperwork, Delivery to USPS","quantity":"1","price":"234.03","tax_rate":"8.875","line_total_tax":20.7701625,"line_total_before_tax":234.03,"line_total_after_tax":254.8001625}},"user_email":"jeremy.flori@brooksbrothers.com","subtotal":"958.68","total_tax":"85.08285","total_discount":"0","total_payments":"0","adjustments":"0","net":"1043.76","hash":"680c4c4eef5c8ba6bc744a4dba346b88","log":[{"ID":"301","blog_id":"1","object_id":"424","user_id":"1","attribute":"invoice","action":"create","value":"","text":"Created by jasonvincik","time":"1480440553"},{"ID":"302","blog_id":"1","object_id":"424","user_id":"1","attribute":"invoice","action":"update","value":"","text":"Updated.","time":"1480440819"},{"ID":"303","blog_id":"1","object_id":"424","user_id":"1","attribute":"invoice","action":"notification","value":"","text":"Notification Sent (New Invoice) to jeremy.flori@brooksbrothers.com at 12:35 pm November 29, 2016.","time":"1480440915"},{"ID":"308","blog_id":"1","object_id":"424","user_id":"10","attribute":"invoice","action":"update","value":"","text":"Viewed by 65.215.52.12","time":"1480447024"},{"ID":"392","blog_id":"1","object_id":"424","user_id":"1","attribute":"invoice","action":"update","value":"","text":"Updated.","time":"1483821942"},{"ID":"393","blog_id":"1","object_id":"424","user_id":"1","attribute":"invoice","action":"update","value":"","text":"Updated.","time":"1483822011"},{"ID":"394","blog_id":"1","object_id":"424","user_id":"1","attribute":"invoice","action":"notification","value":"","text":"Notification Sent (New Invoice) to jeremy.flori@brooksbrothers.com at 3:48 pm January 7, 2017.","time":"1483822115"},{"ID":"395","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 24.90.60.189","time":"1483822221"},{"ID":"396","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 54.146.230.211","time":"1483822228"},{"ID":"397","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 54.70.115.159","time":"1483822248"},{"ID":"398","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 65.215.52.12","time":"1483974159"},{"ID":"399","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 54.81.175.153","time":"1483974176"},{"ID":"400","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 52.13.107.218","time":"1483974224"},{"ID":"401","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 23.23.53.200","time":"1483985701"},{"ID":"402","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 54.188.104.53","time":"1483985724"},{"ID":"412","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 208.202.62.40","time":"1483998635"},{"ID":"413","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 54.146.60.44","time":"1483998642"},{"ID":"414","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 54.226.134.190","time":"1483998659"},{"ID":"424","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 65.215.52.12","time":"1484079396"},{"ID":"425","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 54.163.26.49","time":"1484079483"},{"ID":"426","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 54.244.107.106","time":"1484079503"},{"ID":"440","blog_id":"1","object_id":"424","user_id":"0","attribute":"invoice","action":"update","value":"","text":"Viewed by 24.90.60.189","time":"1484924853"}],"user_data":{"ID":"10","user_login":"jeremy.flori@brooksbrothers.com","user_pass":"$P$B5\/E0fZs3l0pd9SZpW3s3LiXIn73zv0","user_nicename":"jeremy-floribrooksbrothers-com","user_email":"jeremy.flori@brooksbrothers.com","user_url":"","user_registered":"2016-11-29 17:11:06","user_activation_key":"1484930361:$P$B0D3QwBaP\/9mCWqxv7PDc2Ve3ymd3j\/","user_status":"0","display_name":"Jeremy Flori","first_name":"Jeremy","last_name":"Flori","company_name":"Brooks Brothers","phonenumber":"917-724-7055","streetaddress":"901 Broadway, Red Fleece Cafe","city":"New York","state":"NY","zip":"10003","country":"United States"}}
Viewed
May 14, 2017 @ 9:58 pm
Invoice viewed by 66.249.64.46 for the first time.
Viewed
May 31, 2018 @ 9:04 am
Invoice viewed by 66.249.64.74 for the first time.
Viewed
August 24, 2018 @ 1:59 pm
Invoice viewed by 157.55.39.214 for the first time.
