Jump to content

custodian

Members
  • Content count

    620
  • Joined

  • Last visited

Everything posted by custodian

  1. custodian

    How To Intall Contributions

    Also The contrib may also come with new files to place in the store. The new file are in a directory structure the same as the live store is, so that you know exactly where it goes. So if you have new file call My_new_file.php inside catalog/includes/functions then on the server you would place this file in catalog/includes/functions/ folder (obviously your store may not be in catalog, and may be in / or in /store ect...) the purpose of including /catalog/ and /admin/ in the directory structure is only to differentiate the files that are in catalog/includes and admin/includes The contrib may also contain identical files of what you have. If you have a stock store then these are used as drop in replacements with the new code already in it. But if you have an already modified store, these will break your other contrib if you use them.
  2. custodian

    How To Intall Contributions

    After you download the contrib, unzip it. Inside there are usually several files/folders (sometimes only a single file) File may include Read Me Install contribname.slq The read me and the install documents may be in one file. They will usually detail each step to talk, what file to edit (and where to edit it) and what to replace The .sql file is only included with contrib's that require changs (ie: additions) to the databse. An example of what a read me might look like it Step 1: In /catalog/includes/column_right.php Look for if (isset($HTTP_GET_VARS['products_id'])) Change to if (isset($HTTP_GET_VARS['new_products_id'])) Step 2... and so on Some contribs may have A LOT of these steps. Its not difficult at first, though after you have more and more mod's installed the code changes so much that it become more difficult to merge the code. Though after installing that many mod's a person is also typically more familiar with the code at that point. Of course, always backup all the file first, and a database backup before proceeding.
  3. I use securepay.com I can give you the name and email of my sale's rep - he's fantastic. It is monthly fee based, I pay around $28 and I have Visa, MC, AMX and Discover cards. They have a payment mod for oscommerce which the customer never leaves our site (which I like a lot). Funny thing is that my sales rep was the one that hooked me up with oscommerce. I was going to install ZenCart and my sales rep told me he'd give me a discount if I use oscommerce - I thought that was weird, as at that time I didn't know about oscommerce and didn't know it was free too. Kind of odd that a sales rep would give you a discount for using free software - I don't know what his motivation behind the recommendation was, as he is obviously not getting a commission from referring people to oscommerce - the only thing I can think of is that the mod is intergrated that well that it makes less work for them. Anyway, low monthly fees, sales rep's seem on top of things and I haven't had a single issue with the payment. OH.. the $28 I pay is for the e-commerce transactions AND a vertual terminal. But if I recall correctly, if I just wanted the virtual terminal, it was like $10 a mo. Now if only PayPal could be this customer friendly - LOL
  4. custodian

    Promotion code discount suggestions

    Credit Class & Gift Voucher http://www.oscommerce.com/community/contributions,282
  5. custodian

    NEW! Complete Order Editing Tool!

    It worked, but only showed first field. I put all the functions at the top of the file right before // New "Status History" and everything works now. Thank! - BTW, any idea why this would work for some people and not for others? Just curious in the event something else wouldn't work for me - it might be a trick to try when troubleshooting.
  6. custodian

    NEW! Complete Order Editing Tool!

    My logs show PHP Fatal error: Call to undefined function tep_field_exists() in /usr/home/beth/public_html/[admindir]/edit_orders.php on line 29, referer: https://www.memorylaneprimitives.com/[admindir]/orders.php?page=2&oID=13 line 29 is // New "Status History" table has different format. $OldNewStatusValues = (tep_field_exists(TABLE_ORDERS_STATUS_HISTORY, "old_value") && tep_field_exists(TABLE_ORDERS_STATUS_HISTORY, "new_value")); Suggestions
  7. custodian

    NEW! Complete Order Editing Tool!

    Installed the 2 Mar 2006 release. Buttons show up, everything look normal. Click edit (outside the invoice or from within, doesn't matter) , which take me to https://www.mydomain.com/admindir/edit_orders.php?oID=65 And it's blank. I didn't touch the edit_order.php as it is a new file with the package. What now?
  8. custodian

    oscommerce_paypal_ipn contribution

    LOL - I can't even run the Master Card through the PayPal Sandbox test servers.
  9. custodian

    oscommerce_paypal_ipn contribution

    I was using another PayPal contrib that was working, unfortunately I also use the Reward Point Contrib and it need specific changes to the IPN file which the other contrib didn't have a specific IPN file. So I uninstalled the other contrib and installed the PayPal IPN provided by the dev of oscommerce. Issue: If I go through check out and use a paypal account, or a visa card, everythign seems to work without a problem. Though I've had five orders today and all are stuck at "Preparing [PayPal IPN]" I had a previous IPN setup configured at PayPal, so I disabled it in the hopes it was simply interferring, though no difference has been seen. I tried a Mater Card two different Master Card's (both issued by PayPal) and I get an error saying they can't verify the card. This is the only lead I have at this point and will be contacting one of the customers today to see what they used for checkout. I really do not know where to look, I've been over the contrib several times and it is installed correctly. I have 40+ contribs installed, so I know my way around the files and what they should look like... am I simply missing something?
  10. custodian

    ### POINTS AND REWARDS MODULE V1.00 ###

    That's the one I'm using that I can't get to work. I got that one becuase I assumed that since it was from the Dev Team that... oh well... I'm just going to drop it. I've been up all night setting up SSL, Merchant accounts, assigning new IP's to the system. The horse is already dead, and I'm tired of continually beating it. It's not worth my time.
  11. custodian

    ### POINTS AND REWARDS MODULE V1.00 ###

    The money never ends up in my account. I installed the oscommerce PayPal+IPN, the latest version supplied by the dev team in order to make the Point Rewards work with PayPal, since the Points Rewards states to make changes in the PayPayl_IPN, which I didn't have. At this point I am going to need to choose... which seems like I'll need to ditch Points Rewards 1.60. Maybe an odler version will work better, but oh my.. what work it will be to unistall and reinstall
  12. custodian

    oscommerce_paypal_ipn contribution

    No, in fact I thought of that too. I enabled, saved and then went back in and disabled and save again (to ensure that it was in fact off). What files should I replace in order to ensure that the files are the correct ones? Contrib link, so that I can do a diff on the files? The whole contrib seems flakey at time. I just got my sixth order today, this person is Verified, therefore I would need to assume that they have a PayPal account. Payment DID go through, but order stays at Perparing PayPal IPN. Shoudln't this update to Processing? I have the Perparing IPN for the initial order, and then Processing for the "Acknowledged Order Status". egardless, I still need to manually go in an update the order to processing. Just to make it clear, if I haven't in my previous post. Here's what is happening. Customer adds items to their cart. They check out (unsure of what happens or they see here as it is working for me with PP and Visa payments that I've done myself.) I then see an order with Preparing PayPal IPN status. I go to PayPal and NO payment - zero. So something happened that caused 5 orders to not get paid. I'd like to ramble a little bit, and if there is an easier way of doing this, please correct me, but the forum has been a big thorn in my side as well. Oddly enough I'm fortunate that I have been able to install all the contrib's that I have thus far. I beleive the entire forum is difficult to navigate, find anything, contribs are intermixed and difficult to determine what is a patch, a full package, and more. There really should be some strict guidelines for contrib submissions, with mandatory detail field Contrib Name Full Package Yes/No What it does Who needs it? Known Issues: Contrib pages have plug-ins/add-ons for that contrib on the same page also... so is the full package included? Just the additional files? Each contrib should have two pages to it. The Main contribution, and then an add-on/plug-in page. When I installed SPPC it was a nightmare to figure out what was what... A good example is http://www.oscommerce.com/community/contri...all/search,SPPC It's got the full packages, MS2 packages, ACA Modules... And then states As a new person to oscommerce this reads as This is the better version of SPPC, in module format; which is for providing SPPC in OC. If you not already usings our older version 2611, then you don't need this new version. Of course, you could always start using this version. I'm not picking in SPPC, it is a great contrib and I thank those who made it possible - it was just one of many that stuck in my head.
  13. custodian

    oscommerce_paypal_ipn contribution

    Exactly, and it not that oscommerce isn't seeing the payment, the Payment is not in PayPal either.. it's not completing it. I've had 30 orders in the past week with 0 failures, I use the oscommerce paypal IPN and (other than my tests on both snadbox and live servers) 100% of transaction have failed. Now, it IS possible by a fluke that the last five orders have all used a Master Card, though I need to contact them to find this out. Is it possible to set the DEBUG to email ALL the time? Atleast I may be able to see what's going on.
  14. custodian

    ### POINTS AND REWARDS MODULE V1.00 ###

    Can someone suggest the PayPal IPN that they currently have workig with Reward Points. I had a previous PayPal IPN that worked great, but as my previous post show, it did not play well with Reward Points. The suggested modifications to the PayPal_IPN file could NOT be done since the contrib didn't have a PayPal IPN file specifically. So, I uninstalled it, added the oscommerece PayPal IPN and the points work, but now I have issues with the IPN working as well aas the previous IPN... I'm losing money with every order. These forums are set up so poorly and the contributions are so intermixed with each other, have same titles, etc etc.. that it's quite difficult to accurately find something. If someone doesn't mind, please specify the contrib # (or link to it directly) that yo have working with Reward Points, it would be great apprecieated.
  15. custodian

    ### POINTS AND REWARDS MODULE V1.00 ###

    The PayPal isn't the issue. PayPal is recognizing the points and adjusting properly. When I go into Admin in OC two things aren't working #1 - If a customer checks out and USES their points they are not deducted from the database. Example; Person check out with $100.00 order Uses 100 points (ie $2.50). PayPal and the order ARE CORRECT. In Admin, the customer points still shows 200 points. It didn't remove them. #2 - If a customer checks with a $100.00 order they should be given 200 points (ie $5.00). In admin, there are no points added to the customer. Not on the main customer points screen, or pending, approced, or Show ALL screen. Are you still saying that this is a PayPal IPN issue? If so I will look into it. I have a slightly modify PayPal setup.. if that the case, I'll take a look.
  16. custodian

    ### POINTS AND REWARDS MODULE V1.00 ###

    Got everything working except one aspect. Customer signs up. I give them 200 points for this They check out and use their 200 points Money subtracted from total and goes to paypal Check out completed I go in Admin adn look at the customers account, they still have 200 points. It's not subtracting the points. I been manually removing the points if I see they've used them. Where can I look to correct this issue or to see where the problem is? The checkout pages all look good so I must by missing something. Where (page and code snippet) would I find the code that is suppose to deduct the points so that I can check it and verify it for accuracy? Thanks Henry
  17. custodian

    Official thread for Great Categories

    I'm still at it too. I've tried trim and chop in numerous places believing the issue lied with an extra set of white spaces or a return before of after the code, but nothing. Results the same. I haven't given up, though I'm currently stumped as well. And of course this board has SOOOO much activity :(
  18. I have all the need requirements Latest PHP, Apache 2.2, mod_rewrite, etc... When I install the SEO my index.php is displayed a one complete screen of TEXT... If I look at the generated HTML source through the browser, everything looks very clean and I can easily see and read the SEO code. But the HTML output is solid wall to wall text. Any suggestions? Henry
  19. custodian

    Problems with newsletter contrib

    Try this for me. Open both of those files (actually the first one in the error is, I beleive more vital due to it coming first) ..anyway, check to see if there are ANY blank lines at the end of those file. The VERY last line should have something - ?> or </html> nut NOT blank returns. After you''ve removed them, try again. It's usually the simple stuff that breaks the complex stuff. Henry
  20. custodian

    Seperate Pricing Per Customer v3.5

    JanZ - MySQL is my downfall, I am an old school shell scripting, perl/cgi, *nix guy. Never touch MySQL until 30 days ago. I've always used flat text datafiles due to low to medium volume use, went with OS, PPH and MySQL due to recent increases in traffic and sales. I needed something that could handle the traffic. It's to late to look back on hwat I could have done, though I do have the export I did from MyphpAdmin pior to dropping and reinstalling the tables. I'm going to see if I can come up with a way to JUST update the wholesale fields in relation to Price, Quantity Blocks, All Price break level's, and Select Groups To Hide This Product From field. I better make another backup :)
  21. custodian

    Seperate Pricing Per Customer v3.5

    Wow, what a nightmare. Going on 36 hours of awake time.. java script:emoticon(":'(", smilie Anyway, it's fixed. It wasn't me or the code. Both drove me crazy as I consdier myself quite proficient in this area. Turns out, while I assume this happened during the testing phase of OC, that Whole in the group_id got set to 3 and not 1, additionally. Which I also assume is why I needed to 'play' with the code the first time I installed, but evidently it was only a bandaid and not the cure. I tried removing the Wholesale Group and readding... which only fixed the price issuce, all products also had the code group price related to the original group_id 3. In the end my fix was - group the group ID wholesale. I didn't want to lose the customers supplied TAX ID # so I ran part of the uninstall ALTER TABLE customers DROP customers_group_id, DROP customers_group_ra, DROP customers_payment_allowed, DROP customers_shipment_allowed; DROP TABLE IF EXISTS customers_groups; ALTER TABLE specials DROP customers_group_id; and then part of the reinstall ALTER TABLE customers ADD customers_group_id smallint UNSIGNED NOT NULL default '0', ADD customers_group_ra enum('0','1') NOT NULL, ADD customers_payment_allowed varchar(255) NOT NULL default '', ADD customers_shipment_allowed varchar(255) NOT NULL default ''; ALTER TABLE specials ADD customers_group_id smallint UNSIGNED NOT NULL default '0'; DROP TABLE IF EXISTS customers_groups; CREATE TABLE customers_groups ( customers_group_id smallint UNSIGNED NOT NULL, customers_group_name varchar(32) NOT NULL default '', customers_group_show_tax enum('1','0') NOT NULL, customers_group_tax_exempt enum('0','1') NOT NULL, group_payment_allowed varchar(255) NOT NULL default '', group_shipment_allowed varchar(255) NOT NULL default '', PRIMARY KEY (customers_group_id) ); INSERT INTO customers_groups VALUES('0','Retail','1','0','',''); So that I could preserver the TAX ID. Bad News - I'm so tried that I wasn't thinking about the products themselves, only having it displayed properly.... so I lost all my wholesale price values, qnty discount rates.. etc... Thanks for the quick replay Janz, at least the confirmed my belief that it wasn't in my modification with installing contrib. Henry
  22. custodian

    Seperate Pricing Per Customer v3.5

    BTW: As a test I have cut and paste the code directtly from the the install readme file and still zilch! Henry
  23. custodian

    Seperate Pricing Per Customer v3.5

    OK, I've tried and tried, but for the life of me I can't get this to work My retail page shows Wholesale : $8.00 My wholepage shows Retail : $8.00 Wholesale : $12.00 I also use rewards points, they are now adding up in regards to these -intermix figures. I've gone into the code and changed the setting, enough that one side will display properly, but then the other side doesn't. I'd really appreciate it if someone could help me with this, I've been up all night with the sotre in maint mode until I can get this fixed. Here is my code <?php /* $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $ adapted for Separate Pricing Per Customer v4 and Price Break 1.11.3 2005/03/12 adapted for Separate Pricing Per Customer v4.1, Hide products from groups mod 2005/03/28 osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); // BOF Separate Pricing Per Customer if(!tep_session_is_registered('sppc_customer_group_id')) { $customer_group_id = '0'; } else { $customer_group_id = $sppc_customer_group_id; } $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 "); $product_check = tep_db_fetch_array($product_check_query); // EOF Separate Pricing Per Customer ?> <!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; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link href="http://www.memorylaneprimitives.com/favicon.ico" rel="shortcut icon"> <link type="text/css" rel="stylesheet" href="http://www.memorylaneprimitives.com/css/memorylaneprimitives.css"> <link type="text/css" rel="stylesheet" href="http://www.memorylaneprimitives.com/css/MLPnavcontainer.css"> <link type="text/css" rel="stylesheet" href="http://www.memorylaneprimitives.com/catalog/stylesheet.css"> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le ft=150') } //--></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- body //--> <center> <table style="background-color: rgb(249, 250, 245); text-align: left; margin-left: auto; margin-right: auto; width: 750px;" class="solid" border="0" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="background-image: url(http://www.memorylaneprimitives.com/images/MLPlogo.jpg); height: 188px; text-align: center; vertical-align: middle; width: 750px;"></td> </tr> <tr> <td style="background-image: url(http://www.memorylaneprimitives.com/images/MLP_2.jpg); height: 20px; padding-left: 15px; padding-right: 15px; padding-top: 2px; width: 750px;"><div align="center"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> </div></td> </tr> <tr> <td style="background-image: url(http://www.memorylaneprimitives.com/images/MLP_3.jpg); height: 28px; padding-left: 15px; padding-right: 15px; padding-top: 2px; width: 750px;"></td> </tr> <tr> <td style="background-image: url(http://www.memorylaneprimitives.com/images/MLP_4.jpg); width: 750px;"> <table align="center" border="0" cellpadding="0" cellspacing="0" width="750"> <tbody> <tr> <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="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0"> <?php if ($product_check['total'] < 1) { ?> <tr> <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <?php } else { // BOF Show price list for SPPC 4.1 /* Original SPPC 4.1 code $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { // BOF Separate Price per Customer $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } // EOF Separate Price per Customer $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { // BOF Separate Price per Customer $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } // EOF Separate Price per Customer $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } */ $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_price as list_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { // BOF Separate Price per Customer $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } $products_price = ''; if ($customer_group_id != '0') { $products_price = '<span class="header">' . SHOW_PRICE_LIST; $products_price .= $currencies->display_price($product_info['list_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); $products_price .= '</span><br>'; // customer group prices on the next line end of small text for retail prices } $products_price .= '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; // EOF Separate Price per Customer } else { // BOF Separate Price per Customer $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } $products_price = ''; if ($customer_group_id != '0') { $products_price = '<span class="header">' . SHOW_PRICE_LIST; $products_price .= $currencies->display_price($product_info['list_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); $products_price .= '</span><br>'; // customer group prices on the next line end of small text for retail prices } $products_price .= SHOW_YOUR_PRICE ; $products_price .= $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); // EOF Separate Price per Customer } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading" valign="top"><?php echo $products_name; ?> </td> </tr><tr> <td class="pageHeading" valign="top"><h2><BR><?php echo $products_price; ?></h2></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '1'); ?></td> </tr> <tr> <td class="main"> <?php if (tep_not_null($product_info['products_image'])) { ?> <table border="0" cellspacing="0" cellpadding="3" align="right"> <tr> <td align="center" class="smallText"> <script language="javascript"><!-- document.write('<?php echo '<a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></script> <noscript> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </noscript> </td> </tr> </table> <?php } ?> <!-- Points/Rewards Module V1.60 show_points_info bof --> <?php if ((USE_POINTS_SYSTEM == 'true') && (DISPLAY_POINTS_INFO == 'true')) { // check that the points system is enabled if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price_points = tep_display_points($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price_points = tep_display_points($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } $products_points = tep_calc_products_price_points($products_price_points); $products_points_value = tep_calc_price_pvalue($products_points); if (USE_POINTS_FOR_SPECIALS == 'true' || $new_price == false){ ?> <p><?php echo sprintf(TEXT_PRODUCT_POINTS , $products_points) .TEXT_PRODUCT_POINTS_VALUE . $currencies->format($products_points_value); ?></p> <?php } else { ?> <p><?php echo TEXT_PRODUCT_NO_POINTS; ?></p> <?php } }// else do not show points_value ?> <!-- Points/Rewards Module V1.60 show_points_info eof --> <p><?php echo stripslashes($product_info['products_description']); ?></p> <?php $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td> </tr> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> <tr> <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td> <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td> </tr> <?php } ?> </table> <?php } ?> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); if ($reviews['count'] > 0) { ?> <tr> <td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if (tep_not_null($product_info['products_url'])) { ?> <tr> <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td> </tr> <?php } else { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td> </tr> <?php } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '10', '45'); ?><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td> <!-- BOF price-break-1.11.3 <td class="main" align="right"><?php // echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td> --> <td class="main" align="right"> <table border="0" align="right"> <tr><td align="center"> <?php echo TEXT_ENTER_QUANTITY . ":" . tep_draw_input_field('cart_quantity', $pf->adjustQty(1), 'size="6"'); ?> </td></tr> <tr><td align="center"> <?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?> </td></tr> </table> </td> <!-- EOF price-break-1.11.3 --> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } } ?> </td> </tr> </table></form></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- 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 //--> <br> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> </tr> </tbody> </td> </tr> <tr> <td style="background-image: url(http://www.memorylaneprimitives.com/images/MLP_5.jpg); height: 28px; width: 750px; text-align: center;"> </td> </tr> <tr> <td style="padding: 2px 15px 13px; background-image: url(http://www.memorylaneprimitives.com/images/MLP_6.jpg); height: 37px; width: 750px;"> </td> </tr> </tbody> </table> </center> </body> </html> Thank you Henry
  24. custodian

    ### POINTS AND REWARDS MODULE V1.00 ###

    OK, I got that issue fixed, was a SPPC contrib conflict. Also went though all files and remove the extra '.' in dead center of pages. ei: see. referred us FAQ And the gammar and spelling of ajust <-- adjust amout <-- amount Redeemptions <-- Redemptions Though I wil say this. Given all the spelling and grammar that I needed to do, it is still a Great contirb. I think you dearly - it's wonderful. I see if I can pull a diff in a few days and post the corrections. Henry
  25. custodian

    ### POINTS AND REWARDS MODULE V1.00 ###

    Browsed quickly through the threads but didn't see these.. First admin/customer_points.php Line 264 ================= <tr><td class="smalltext"><?php echo ' <b> ' . HEADING_RATE . ' </b> ' . HEADING_AWARDS . $curren cies->format(1) . ' = ' . number_format(POINTS_PER_AMOUNT_PURCHASE,2) .' ' . $point_or_points . ' ' . HEADING_REDEEM . number_format(POINTS_PER_AMOUNT_PURCHASE,2) .' ' . $point_or_points . ' = ' . $currencies->format(P OINTS_PER_AMOUNT_PURCHASE * REDEEM_POINT_VALUE); ?></td> </tr> </table></td> ================= Two separate place have as (not no trailing ; ) [the aboce example had already been correct prior to post. But it's easily found Second admin/customer_points_pending.php Line 279 ================= <td class="smalltext" align="right"><?php echo ' <b> ' . HEADING_RATE . ' </b> ' . HEADING_AWARD S . $currencies->format(1) . ' = ' . number_format(POINTS_PER_AMOUNT_PURCHASE,2) .' ' . HEADING_POINTS .' ' . HEADING_REDEEM . number_format(POINTS_PER_AMOUNT_PURCHASE,2) .' ' . HEADING_POINTS .' = ' . $currencies->format (POINTS_PER_AMOUNT_PURCHASE * REDEEM_POINT_VALUE); ?></td> ================ Same thing.. no trailing ; Which make the code show on the page as text Last issue - In the admin panel, I have the Module and I have the Points/RewardsV1.60 under the Configuration menu. But that's it. I see no place to authorize, delete, modify, or even view points unless I physically type in the customer_ppoints_pending.php and the customer_points.php address myself. And because of this I really don't know what other features I am missing. Suggestions are welcome. I'm assume a incorrect install or syntax. In the very least please identify the files that are directly related to the admin not showing these items so that I at least now where to start looking myself.
×