Jump to content

spd81

Members
  • Content count

    12
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Rick
  1. For the recommended price you might want to checkout EZ new field. I just found it but have not implemented it yet. But it looks good and have support forum also at: http://forums.oscommerce.com/index.php?showtopic=87832 in case you need help installing.
  2. Hi, I've been searching this forum but can't find an answer to my problem. I am using Live Support V 1.5.1 and everything's working but I want to use the online.jpg and offline.jpg images on live_support/images to appear dynamically (i.e use online.jpg if someone on admin side is login) instead of just the live_support.jpg on catalog/images. Do I just change this line on my column_left.php? How? $info_box_contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link('live_support/client.php') . '" target="_blank">' . tep_image(DIR_WS_IMAGES . 'live_support.jpg', BOX_INFO_LIVESUPPORT) . '<br><br>' . BOX_INFO_LIVESUPPORT . '</a>'); Any help is appreciated. Thanks.
  3. spd81

    Allprods.php error

    Never mind. Got it. Some lines in Categories.php is leftover from the old version.
  4. I've replaced all the header_tags**** files with those from v2.4.9 and it works nicely now. Thank you.
  5. Hi, I've installed the allprods.php contribution. When I clicked on the All products link. It gives me this error message: Fatal error: Call to a member function on a non-object in .../catalog/allprods.php on line 103 <?php /* $Id: allprods.php,v 1.5 2002/09/29 1 osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ALLPRODS); // Set number of columns in listing define ('NR_COLUMNS', 1); // $breadcrumb->add(HEADING_TITLE, tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL')); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <?php // BOF: WebMakers.com Changed: Header Tag Controller v1.0 // Replaced by header_tags.php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <title><?php echo TITLE ?></title> <?php } // EOF: WebMakers.com Changed: Header Tag Controller v1.0 ?> <base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="8"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <?php //begin change. We want the same listing for the categories than for the products. // create column list $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($column, $value) = each($define_list)) { if ($value) $column_list[] = $column; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } // We show everything $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.sold_out_status, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$osC_Session->value('languages_id') . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id"; if ( (!isset($_GET['sort'])) || (!ereg('[1-8][ad]', $_GET['sort'])) || (substr($_GET['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { //because we don't display the model but we want it to be default, we fool the sort var and set it to a higher number and set the order by to products model $_GET['sort'] = $i+5 . 'a'; $listing_sql .= " order by p.products_model"; break; } } } else { $sort_col = substr($_GET['sort'], 0 , 1); $sort_order = substr($_GET['sort'], 1); $listing_sql .= ' order by '; switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= "pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="8"> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td> </tr> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="8"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Can someone please check and see what am I missing? Looks like line 103 is this line $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.sold_out_status, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$osC_Session->value('languages_id') . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id"; Thanks.
  6. Hi, I've installed the Header Tag Controller v2.5.0. Everything seems to be ok until I clicked on Header tag in the left column of admin. The "Header Tag" is replaced by a string of error message: Fatal error: Call to undefined function: tep_admin_files_boxes() in .../admin/includes/boxes/header_tags_controller.php on line 28 Here's the code for admin/includes/boxes/header_tags_controller.php <?php /* $Id: header_tags_controller.php,v 1.00 2003/10/02 Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ ?> <!-- header_tags_controller //--> <tr> <td> <?php $heading = array(); $contents = array(); $heading[] = array('text' => BOX_HEADING_HEADER_TAGS_CONTROLLER, 'link' => tep_href_link(FILENAME_HEADER_TAGS_CONTROLLER, 'selected_box=header tags')); if ($selected_box == 'header tags') { $contents[] = array('text' => // '<a href="' . tep_href_link(FILENAME_HEADER_TAGS_CONTROLLER, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_HEADER_TAGS_ADD_A_PAGE . '</a><br>' . // '<a href="' . tep_href_link(FILENAME_HEADER_TAGS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_HEADER_TAGS . '</a>' // for admin access level, change the // tep_admin_files_boxes(FILENAME_HEADER_TAGS_CONTROLLER, BOX_HEADER_TAGS_ADD_A_PAGE) . tep_admin_files_boxes(FILENAME_HEADER_TAGS, BOX_HEADER_TAGS) ); } $box = new box; echo $box->menuBox($heading, $contents); ?> </td> </tr> <!-- header_tags_controller_eof //--> Thanks.
  7. spd81

    Log IP Addresses?

    Exactly what I am looking for. I was searching using the word "IP" only and the result isn't quite the same. Thank you very much.
  8. Is there an existing contribution that would log the IP addresses of customers when they signup. Currently, you can go to admin-Tools-Who's online and it would give you the IP address. But I am hoping to have this info on customers details. Thanks
  9. 1 subtotal 2 Payment Type Discount 3 Shipping 4 Tax 99 Total Thanks
  10. Under Admin -> Order total Module -> Payment Type Discount. With recalculate tax set to false, it will show: Sub-Total: $679.99 Payment Type Discount: $13.60 Shipping: $7.56 15% tax: $102.00 15% tax on shipping: $1.13 Total: $777.08 The 2% discount price shows the correct amount on above example. However, my customer would have to pay taxes based on the sub-total amount before the discount. Which seems a bit unfair. So I have changed "recalculate tax" options to true. It then shows: Sub-Total: $679.99 Payment Type Discount: $15.64 >>>but it should be $13.60 Shipping: $7.56 15% tax: $99.96 15% tax on shipping: $1.13 Total: $775.04 The tax is now calculated as desired. But the weird thing is the 2% discount price showing is wrong. It should be $13.60 not $15.64. But when I tried to add it up, it's apparent that the discount amount that is actually deducted is the correct amount of $13.60 not the $15.64 being displayed. I am really a newbie in php. Can someone guide me how or where to modify the "Discount for Payment Type" module so that the discount amount would come out correctly when "recalculate tax" is set to true? Seems like the calculations are ok but the discount amount showing is wrong. Any help is appreciated. Thanks, Rick
×