Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

bdownes

Archived
  • Posts

    69
  • Joined

  • Last visited

Everything posted by bdownes

  1. Hey David! I got it to work!!! I changed one letter in the code h.comments is now o.comments And it works great! Thanks for such a great contribution! Bobby
  2. On line 44 it reads 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'); At around line 239 it reads $pos -= SECTION_DIVIDER; if ($orders['comments']) { $pdf->ezSetY($pos); $pdf->ezText("<b>Comments:</b>\n" . $orders['comments'],GENERAL_FONT_SIZE); } This seems to be getting the data from the Orders table. I just don't know enough about funneling data from the database to the php file. I would be willing to pay for help on this. Thanks! Bobby
  3. When the check box is checked next to: Show orders without comments? (Will NOT show order with comments placed by the customer at time of order.) Then this is when the Comments on the PDF read.... Comments: The comments for your order are Automatic order update notification. What code do I put in the string to tell batch_print to get the comments from the ORDERS table? Thanks a ton! When our staff came in this morning they were thrilled about this update! Thank you, Thank you, Thank you! Bobby
  4. Using a November 2002 version. The comments field is in the ORDERS Table. Via phpMyAdmin I can see all of the custumer comments in there. Is it as simple as telling the batch_print.php to get the data from the ORDERS table? Or are there other places that must be changed as well? Thanks, Bobby
  5. Hi David, On about line 42 of admin/batch_print.php we find: $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'); Is this where I would change the IF statement to pull data from the orders table? Not sure how to do this. Bobby
  6. Found the define('PRODUCT_ATTRIBUTES_TEXT_WRAP', false); in the english/batch_print.php My brain was tired. Sorry
  7. Hi David, Regarding the Comments field on the PDF, here is what I am getting on the PDF... Comments: The comments for your order are Automatic order update notification. The above note shows up in every PDF report even when there are comments in the actual order. How do I tie the comments field that our site currently uses into this comments field in the order_status_history comments field (which is what I believe the PDF is using... is that correct?). The "comments" field I use is currently located in my "orders" table. Thoughts? Thanks! Bobby
  8. Hi David, Forgive my ignorance. Which file is define('PRODUCT_ATTRIBUTES_TEXT_WRAP', false); located in? Thanks, Bobby PS. I found some of those font size controls and it looks great now for my set up.
  9. Quick Updates is a great contribution that will speed up your ability to update product pricing in the Admin without having to individual product pages to make the updates. When a product is also listed in the Specials area, Quick Updates will not allow updating of the database info (product name, pricing etc). Which makes it rather useless if ALL of your products are discounted. Anyone know how to make it override this feature? Thanks! Bobby
  10. Also, how do I make the font size smaller for the text on the PDF form? Some of my text is doubled up over the top of other text because my product names are longer. Thanks! Bobby
  11. Radders, That worked great!!! Thank you! Now trying to add the Comments to the PDF form. Is that a quick addition to make? Any tips? Thanks! Bobby PS. This is gong to be SOOOO much better than printing orders one by one by one.
  12. Just installed the Batch Order Center Update 1.1 and am getting the following error. 1054 - Unknown column 'h.comments' in 'field list' select o.orders_id,h.comments,MIN(h.date_added) from orders o, orders_status_history h where o.date_purchased between '2004-02-27' and '2004-02-2823:59:59' and h.orders_id = o.orders_id and o.orders_status = 1 and h.orders_status_id = 1 group by o.orders_id [TEP STOP] Anyone have a clue what this means? And how to fix it? Thanks! Bobby
  13. Dice, Are you able to control the number of articles that show up now that it is working? Using the controls in the Admin or making the changes to the database itself. I was getting the same error as you and just removed... // set application wide parameters // this query set is for NewsDesk $configuration_query = tep_db_query("select configuration_key as cfgKey, configuration_value as cfgValue from " . TABLE_NEWSDESK_CONFIGURATION . ""); while ($configuration = tep_db_fetch_array($configuration_query)) { define($configuration['cfgKey'], $configuration['cfgValue']); } And mine NewsDesk does not return an error. BUT, I now have no control over how many articles show up on the front page (just 3 article summaries show up... and I want more than that.) I have all of 1.3 installed, with the exception of the code above that I removed from the catalog/includes/modules/newsdesk.php By the way, I am using the Latest News Box and it works great! I can control the number of headlines that show up there. See http://www.christiancinema.com/catalog/newsdesk.php Bobby
  14. 1064 - You have an error in your SQL syntax near 'MAX_DISPLAY_NEWSDESK_NEWS' at line 4 select p.newsdesk_id, pd.language_id, pd.newsdesk_article_name, pd.newsdesk_article_description, pd.newsdesk_article_shorttext, pd.newsdesk_article_url, p.newsdesk_image, p.newsdesk_date_added, p.newsdesk_last_modified, p.newsdesk_date_available, p.newsdesk_status from newsdesk p, newsdesk_description pd WHERE pd.newsdesk_id = p.newsdesk_id and pd.language_id = "1" and newsdesk_status = 1 ORDER BY newsdesk_date_added DESC LIMIT MAX_DISPLAY_NEWSDESK_NEWS [TEP STOP] Just did an upgrade to 1.2 overwriting the previous files AND updating each of the lines in application_top.php Any thought on what this could be? Thanks! Bobby
  15. HTTP Server: Apache/1.3.26 (Unix) PHP/4.2.2 FrontPage/4.0.4.3 PHP Version: 4.2.2 (Zend: 1.2.0) Is what my server is configured as. Thanks,
  16. Anyone know what this is? Getting this on catalog/default.php page - the admin side is working great. 1064 - You have an error in your SQL syntax near 'rand() DESC limit 9' at line 1 select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 9 [TEP STOP]
  17. Here is the sql file for Help Desk. This works for me. DROP TABLE IF EXISTS helpdesk; CREATE TABLE helpdesk (ticket_id int(255) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, email TEXT NOT NULL, problem TEXT NOT NULL, solution TEXT NOT NULL, status TEXT NOT NULL, date TEXT NOT NULL, priority TEXT NOT NULL, PRIMARY KEY (ticket_id)); DROP TABLE IF EXISTS helpdesk_members; CREATE TABLE helpdesk_members ( ? ?username VARCHAR(255) NOT NULL, ? ?password TEXT NOT NULL, ? ?email TEXT NOT NULL, ? ?signature TEXT NOT NULL, ? ?PRIMARY KEY (username) ); INSERT INTO helpdesk_members VALUES ('admin','password','[email protected]','Your Name<BR>Technical Support<BR>http://www.yourstore.com'); INSERT INTO configuration VALUES ('', 'Support Email Address', 'SUPPORT_EMAIL_ADDRESS', '[email protected]', 'Support email address', 1, '99', '', '', NULL, NULL);
  18. I installed Credit Class GV 3.1 to bring GV up to date. Only errors are: shipping weight error (if a GV is the only item). And During checkout, GIFT VOUCHER is not an option for Payment Method. Any ideas?
  19. I will try the update. And get back to you. Bobby
  20. Hi Ian, I am using 1.0 of Credit Class. Thanks, Bobby
  21. When I press Confirm Order... I get the following error on the next page... Warning: Missing argument 1 for apply_credit() in /mnt/web/guide/christiancinema/www/catalog/includes/modules/credit/gv.php on line 60 Warning: Cannot add header information - headers already sent by (output started at /mnt/web/guide/christiancinema/www/catalog/includes/modules/credit/gv.php:60) in /mnt/web/guide/christiancinema/www/catalog/includes/functions/general.php on line 23 This seems to be a Gift Voucher error since it is signaling gv.php. Anyone? thanks.
  22. I am getting the following error at checkout on the catalog/checkout_confirmation.php... Warning: Missing argument 1 for credit_deduction() in /mnt/web/guide/christiancinema/www/catalog/includes/modules/credit/gv.php on line 49 Thoughts anyone? Thanks!
  23. Would anyone mind telling me why customers continue to receive Notification emails (from Helpdesk) that do not include the entire URL? The URL's are missing the http://www.mycompany.com See sample below... _______________________________________ Your request for support has been completed. Your ticket number is: 1 To view the solution to your request, please go to: /helpdesk_status.php _________________________________________ Any thoughts on what is causing this? I have put on the configure.php files the location of the http and https servers to http://www.mycompany.com I am stumped. Cannot find a thread on this issue.
  24. At the top of the page... Parse error: parse error, unexpected T_STRING in /catalog/includes/functions/general.php on line 1102 Here is the code in general.php on line 1102: //// // For short product description contribution function osc_trunc_string($str="",$len=150,$more=1) { ? ?? ?if ($str=="") return $str; ? ?? ?if (is_array($str)) return $str; ? ?? ?$str = trim($str); ? ?? ?// if it's les than the size given, then return it ? ?? ?if (strlen($str) <= $len) return $str; ? ?? ?// else get that size of text ? ?? ?$str = substr($str,0,$len); ? ?? ?// backtrack to the end of a word ? ?? ?if ($str != "") { ? ?? ?? ?// check to see if there are any spaces left ? ?? ?? ?if (!substr_count($str," ")) { ? ?? ?? ?? ?if ($more) $str .= "..."; ? ?? ?? ?? ?return $str; ? ?? ?? ?} ? ?? ?? ?// backtrack ? ?? ?? ?while(strlen($str) && ($str[strlen($str)-1] != " ")) { ? ?? ?? ?? ?$str = substr($str,0,-1); ? ?? ?? ?} ? ?? ?? ?$str = substr($str,0,-1); ? ?? ?? ?if ($more) $str .= "..."; ? ?? ?} ? ?? ?return $str; ? ?} Under New Products... Fatal error: Call to undefined function: osc_trunc_string() in catalog/includes/modules/new_products.php on line 35 And here is the code from line 35 in new_products.php: //Short product description begin osc_trunc_string(strip_tags($new_products['products_description'], '<a><em><font><i><s><span><strong><sub><sup><u>'), PRODUCT_LIST_DESCRIPTION_LENGTH) . '<br>' . //Short product description end Any thoughts to get this working?
×
×
  • Create New...