Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  1. Going through the paces here before opening up this new Contrib on my store. I'm going to use it with Discount Coupons as a Gift Certificate module. Coupla small issues. 1: As mentioned, format breaks on checkout_confirmation as well as other areas like admin. 2: Order Editor cuts the string somewhere around 35 characters. 3: When ordering several items, the attributes are in reverse order for all but the last item.(not a big deal, but it makes an impression of an unprofessional site)
  2. brushwood

    Imprint Text Options

    I have moved on to the other contrib for text options and it works much better. Product Attributes Option Type Feature
  3. brushwood

    Imprint Text Options

    Got back here too late to edit previous post. Bad news. Adding another product with another attribute works except the input text on the first one is written over with the second. Back to the drawing board.
  4. brushwood

    Imprint Text Options

    OK, found it. I dropped this: // denuz text attr tep_db_query("delete from customers_basket_text_attributes where products_id = " . tep_get_prid($HTTP_POST_VARS['products_id'][$i]) . " and session_id = '" . $osCsid . "'"); // eof denuz text attr from application_top.php and it seems to work very well now. I have a few details to finish but this is looking great for now.
  5. brushwood

    Imprint Text Options

    OK, I've backed out of the More Entries addition and the single quote issue seems to be resolved. My work-around for it is to generate a regular set of attributes for the gift certificates. Recipients: 1st Gift Certificate, 2nd Gift Certificate, etc. This makes each one into a separate product at checkout and displays just fine in testing. It also encourages the customer to buy for more than 1 person at a time. However, when I remove 1 of them from the cart, all lose the imprint data. I'll try looking in the code to see if there's something I can do but I'd love to hear some thoughts on it.
  6. brushwood

    Imprint Text Options

    I've been working through this contrib with the intention to offer gift certificates in conjunction with the coupon code contrib. So far, it's been pretty good. A problem i hit while testing centers on the customer entering a single quote into the text box like: Hi, Johnnie! We're looking forward to seeing this blah, blah, blah... You get the idea. Sometimes it seems fine and other times it throws errors. I first noticed it when I deleted another product that was in the cart 9not even a custom item). I looked in the DB and saw the single quote there and realized sometimes it would screw with the code depending on where and how and maybe even how many of them were added. Any thoughts?
  7. Please pardon my laziness for not wanting to read all 78 pages in this thread. I've read though many of them and read through the manual briefly. Before I install this, I have a big question. I've been looking for a way to do Gift Certificates for some time. I think CCGV is awkward and not likely to be used by my customers. Also, I've tried installing it with my heavily modded site and ran into serious difficulties with some of my custom work. Maybe it's changed, but I'm against it for now. I want to use something like Imprint Text Options contrib to create a section of gift certificates that the customer just goes in and buys. They enter fields for the gift (the custom imprint text) like name, email and address of the recipient then just check out as usual. They can add several certificates and even order products for themselves at the same time. I convert their custom product to a coupon (with Discount Coupon Codes) and email it to the recipient. (Maybe I'm not remembering CCGV correctly, but it seemed much more awkward for the customer with several steps needed to send the gift. Really, any advice on Gift Certificate knowledge would be welcome) So, first, will this work? Second, can a customer use only part of a coupon and have a remaining balance on it with this contrib or must they apply the entire code balance at once?
  8. brushwood

    Batch Print Center (support thread)

    OK, brain function needs coffee! I remembered and found the problem. It is a date query issue. I needed to put a space in from of the time 23:59:59 here: . tep_db_input($enddate) . "23:59:59' and h.orders_id = o.orders_id" . $pull_w_status . Working fine now.
  9. brushwood

    Batch Print Center (support thread)

    OK, no. I was wrong. My server was not restarted and I think I loaded an older version of my batch print php file yesterday. Somewhere in the back of my brain there's something about mysql asking for dates in a different way in newer versions. Some minor change in the way to query the db. I may have tweaked it by ftp just after the move to this host (a month ago) and not updated my backup. This is the top of my batch_print.php file and the error is: Fatal error: Call to undefined function: message_handler() in /home/brushwoo/public_html/catalog/amin/batch_print.php on line 48 <?php require('includes/application_top.php'); if ($HTTP_GET_VARS['mkey']) { $key = $HTTP_GET_VARS['mkey']; $message = $error[$key]; $HTTP_GET_VARS['act'] = 0; } if ($HTTP_GET_VARS['act'] == '') { $HTTP_GET_VARS['act'] = 0; } if (strlen($HTTP_GET_VARS['act']) == 1 && is_numeric($HTTP_GET_VARS['act'])) { switch ($HTTP_GET_VARS['act']) { case 1: // CHECK DATE ENTERED, GRAB ALL ORDERS FROM THAT DATE, AND CREATE PDF FOR ORDERS if (!isset($HTTP_POST_VARS[ 'startdate'])) { message_handler(); } if ((strlen($HTTP_POST_VARS['startdate']) != 10) || verify_start_date($HTTP_POST_VARS['startdate'])) { message_handler('ERROR_BAD_DATE'); } if (!is_writeable(BATCH_PDF_DIR)) { message_handler('SET_PERMISSIONS'); } $time0 = time(); $startdate = tep_db_prepare_input($HTTP_POST_VARS['startdate']); if (!isset($HTTP_POST_VARS['enddate'])) { message_handler(); } if ((strlen($HTTP_POST_VARS['enddate']) != 10) || verify_end_date($HTTP_POST_VARS['enddate'])) { message_handler('ERROR_BAD_DATE'); } if (!is_writeable(BATCH_PDF_DIR)) { message_handler('SET_PERMISSIONS'); } $time0 = time(); $enddate = tep_db_prepare_input($HTTP_POST_VARS['enddate']); require(DIR_WS_CLASSES . 'currencies.php'); require(BATCH_PRINT_INC . 'class.ezpdf.php'); require(DIR_WS_CLASSES . 'order.php'); $pdf = new Cezpdf(PAGE); $currencies = new currencies(); $pdf->selectFont(BATCH_PDF_DIR . 'Helvetica.afm'); $pdf->setFontFamily(BATCH_PDF_DIR . 'Helvetica.afm'); if ($HTTP_POST_VARS['show_comments']) { $get_customer_comments = ' and h.orders_status_id = ' . DEFAULT_ORDERS_STATUS_ID; } if ($HTTP_POST_VARS['pull_status']){ $pull_w_status = " and o.orders_status = ". $HTTP_POST_VARS['pull_status']; } $orders_query = tep_db_query("select o.orders_id,h.comments,MIN(h.date_added) from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_STATUS_HISTORY . " h where o.date_purchased between '" . tep_db_input($startdate) . "' and '" . tep_db_input($enddate) . "23:59:59' and h.orders_id = o.orders_id" . $pull_w_status . $get_customer_comments . ' group by o.orders_id'); if (!tep_db_num_rows($orders_query) > 0) { message_handler('NO_ORDERS'); } $num = 0; while ($orders = tep_db_fetch_array($orders_query)) { $order = new order($orders['orders_id']); if ($num != 0) { $pdf->EzNewPage(); } $y = $pdf->ezText("PACKING SLIP",COMPANY_HEADER_FONT_SIZE); $y = $pdf->ezText(STORE_NAME_ADDRESS,SUB_HEADING_FONT_SIZE); $y -= 10; Line 48 is: if (!tep_db_num_rows($orders_query) > 0) { message_handler('NO_ORDERS'); } Any thoughts?
  10. brushwood

    Batch Print Center (support thread)

    My batch print just stopped working yesterday. Now, when I try to pull any status, I get this error: Fatal error: Call to undefined function: message_handler() in /home/brushwoo/public_html/catalog/amin/batch_print.php on line 48 This worked yesterday early morning and not in the afternoon. I looked and saw in my logs that the server was restarted at 11:21 AM. Can anyone guide me to an answer? I had this happen to me on the storefront with credit card entry error messages when I first moved to my new host. I'm concerned that they have upgraded something and I need the batch print almost daily. Any thoughts?
  11. brushwood

    Some credit cards not working

    I've been running osC for years and have been baffled by the occasional error before confirmation that returns a blank pink box at the top of the page. I just tried to run a customer's Amex card on my cart for her and it did that. Then I went over to my Auth.net Virtual Terminal and it went through just fine. This has happened before. I'm wondering if there's something in the module (Auth Consolidated 1.7,I believe) that's rejecting some cards and why. Kills me to think some folks may be surfing away in frustration.
  12. brushwood

    osC mySQL

    Mark, I still think this has the most tremendous potential of just about any Contrib. I run queries manually on a regular basis and this would make it much easier. Please continue to work on it as you get the time! Request: I could use a csv file export option. Trouble: I get an error of headers already sent like this: Warning: Cannot modify header information - headers already sent by (output started at /home/brushwoo/public_html/catalog/amin/includes/application_top.php:11) in /home/brushwoo/public_html/catalog/amin/pdf/fpdf/fpdf.php on line 1071 FPDF error: Some data has already been output to browser, can't send PDF file Then again, I just moved hosts and have a few issues on this. I get it also when I use the search function looking up a customer (in customers.php). I'll probably ask about it in general support but thought I'd mention it here in case it's code specific.
  13. I need to know exactly where the credit card number and expiration date are stripped from the order table when using Auth.net Consolidated (if in fact that contrib is doing it). I've been digging through the files for an hour looking for the spot. It has to happen after the response from Auth.net, but I can't seem to get it.
  14. brushwood

    Held Orders v2.0 MS2 ready

    Just installed this Contrib, which is convenient for Paypal dropoffs, but I'm hoping to log cc numbers for when folks wish to add to their orders. Is there a way to block the orders from clearing from these tables when my CC processor returns a confirmation of payment? That way, I can go back and use my cc virtual terminal to chaarge them for the added product(s). I see a few additions to files calling for deletion from the tables. If I drop one, would that help? Which? Will it mess up anything else?
  15. brushwood

    Automatically send data feed to Froogle

    More likely your database server is down. Maybe rebooting. Ask you host.