Jump to content

pfilias

Members
  • Content count

    121
  • Joined

  • Last visited

Everything posted by pfilias

  1. pfilias

    New UPS XML Shipping Module available

    Is it just me that experiences times anywhere from 5s to 25s to get to the payment page after you click checkout? A site of mine that uses 1_2_9 doesn't have this problem. I made the switch from TEST to PRODUCTION just now, thinking THAT was the reason, but it wasn't. :( I've enabled logging and error logging. I don't see anything jumping out at me. Can anyone tell if this output shows us anything?
  2. PJ, Are you saying you need the merged code for UltraPics and QT Pro? If so, here is that code: $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=new_product') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=delete_product') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=move_product') . '">' . tep_image_button('button_move.gif', IMAGE_MOVE) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=copy_to') . '">' . tep_image_button('button_copy_to.gif', IMAGE_COPY_TO) . '</a> <a target="_blank" href="' . HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'product_info.php?products_id=' . $pInfo->products_id . '">' . tep_image_button('button_preview.gif', IMAGE_PREVIEW) . '</a> <a href="' . tep_href_link("stock.php", 'product_id=' . $pInfo->products_id) . '">' . tep_image_button('button_stock.gif', "Stock") . '</a>');
  3. pfilias

    Where do ypu insert API Log In ID

    In the Login Username box.
  4. I actually had luck with THIS mod, the one this thread is about... the new one that comes with RC2a simply does not work.
  5. I have RC2a installed with the authorize.net AIM 1.0 module. It returns: checkout_payment.php?payment_error=authorizenet_cc_aim&error=general I'm stuck, the client is going to be upset. :(
  6. pfilias

    Google Analytics module

    I am using this contribution, but I am getting the following at the top of my checkout_success.php page: pageTracker._addTrans( "5"," ","72.45","","5.45","Shelby Twp.","Michigan","United States" ); pageTracker._addItem( "5","29","Long Sleeve T-Shirt (Grey)","T-Shirts","17.00","1""5","35","MS Movement Bracelet","Bracelets","20.00","1""5","40","MS Movement Markers","Pens","30.00","1" ); pageTracker._trackTrans(); I can't seem to figure out why this is happening, either. Here is the code I have in my checkout_success.php page: <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> var pageTracker = _gat._getTracker("UA-XXXXXX-"); pageTracker._initData(); pageTracker._trackPageview(); <?php include(DIR_WS_MODULES . 'analytics/analytics.php'); ?> </script>
  7. pfilias

    Help with zone handling fee

    I have looked up and down this site for a way to add a "handling fee" for ANY customer that is outside the United States. How can I do this?
  8. pfilias

    Paypal IPN module removed from osC2.2 rc2 ?

    No matter what I do, I can't get the PayPal Website Payments Standard nor the PayPal IPN to show up as a payment option.
  9. What impact would I have with trying to implement 2.1d if I already have 2.2e installed? EDIT: I made the changes to .htaccess and upload the "old" seo.class.php. Seems to work fine! On one of my installs, I actually didn't have to change the .htaccess. It seems most of the magic is in the seo.class.php.
  10. pfilias

    Ultimate SEO URL - create account issue

    I was excited I found my solution to broken product and price sorting, but I can't find that code anywhere in my seo.class.php (I have 2-2.2e installed).
  11. Has anyone been successful in getting SEO'd pages to have sort ability? I've tried FWR Media's seo.class.php fix, but it didn't do a thing. On pages that aren't SEO'd, naturally, the sort works just fine. Thanks.
  12. I was able to make this work with the following code block in includes/functions/general.php (notice bolded text): //// // Return a product's stock // TABLES: products //++++ QT Pro: Begin Changed code as well as Price Break per Quantity function tep_get_products_stock($products_id, $attributes=array()) { global $languages_id; global $pfs; $stock = false; if (is_object($pfs)) { $stock = $pfs->getStock($products_id); } // Make this work with QT Pro // if ($stock !== false) { // return $stock; // } else { $products_id = tep_get_prid($products_id); if (sizeof($attributes)>0) { $all_nonstocked = true; $attr_list=''; $options_list=implode(",",array_keys($attributes)); $track_stock_query=tep_db_query("select products_options_id, products_options_track_stock from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id in ($options_list) and language_id= '" . (int)$languages_id . "order by products_options_id'"); while($track_stock_array=tep_db_fetch_array($track_stock_query)) { if ($track_stock_array['products_options_track_stock']) { $attr_list.=$track_stock_array['products_options_id'] . '-' . $attributes[$track_stock_array['products_options_id']] . ','; $all_nonstocked=false; } } $attr_list=substr($attr_list,0,strlen($attr_list)-1); } if ((sizeof($attributes)==0) | ($all_nonstocked)) { $stock_query = tep_db_query("select products_quantity as quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); } else { $stock_query=tep_db_query("select products_stock_quantity as quantity from " . TABLE_PRODUCTS_STOCK . " where products_id='". (int)$products_id . "' and products_stock_attributes='$attr_list'"); } if (tep_db_num_rows($stock_query)>0) { $stock=tep_db_fetch_array($stock_query); $quantity=$stock['quantity']; } else { $quantity = 0; } return $quantity; // end QT Pro and Price Break per Quantity Mods } // } // End Make this work with QT Pro
  13. I wonder if "attempt" to change general.php is actually breaking the way QT Pro is supposed to work. It's a few posts above, where a friend of mine helped me to get QT Pro working, but maybe it's not really working. Any help would be appreciated. NOTE: It is definitely a conflict between the Quantity Pricing contribution and QT Pro. global $pfs; $stock = false; if (is_object($pfs)) { $stock = $pfs->getStock($products_id); } if ($stock !== false) { return $stock; } else { The above code is setting a stock level before (or overtaking) the stock level that is being set by QT Pro. I need to get these to work together. :(
  14. Hello friends. I've got QT Pro 4.3a installed on RC2a, alongside with mod that does the Quantity Price Breaks Per Product. If I have only 1 attribute for a product, the out of stock functionality that doesn't allow you to add the product to your cart is working. However, if you are on a product that has 4 sizes, for example, and some of them are out of stock, it will still let you add the out of stock products to your site. Example: S - in stock M - in stock L - out of stock XL - out of stock XXL - out of stock If you try to order the L, it will let you. On the other hand, if you have a hat that is One Size Fits All, and you have the stock set to 0, it prevents you from adding item to your cart by throwing up the JavaScript window as well as already displaying the text that you can't order the product. Here is the piece of my product_info.php that has this logic. I don't think I've missed anything: <tr class="productListing-heading"> <td colspan="2"><strong><?php echo TEXT_PRODUCT_AVAILABILITY; ?></strong></td> </tr> <tr class="productListing-even"> <td height="10" colspan="2" align="left" valign="top" class="main"> <?php if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) { echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); } else { echo TEXT_PRODUCT_AVAILABLE; } ?></td> </tr> <tr > <td class="productListing-heading"><strong><?php echo SKU; ?></strong></td> <td class="productListing-heading"><strong><?php echo PRICING; ?></strong></td> </tr> <tr class="productListing-even"> <td height="10" align="left" valign="top" class="main"><?php echo $product_info['products_model'] ?></td> <td height="10" align="left" valign="top" class="main"><?php echo $products_price; ?></td> </tr> <tr class="productListing-heading"> <td colspan="2"><strong><?php echo TEXT_PRODUCT_OPTIONS; ?></strong></td> </tr> <tr class="productListing-even"> <td height="10" colspan="2" align="left" valign="top"> <?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) { //++++ QT Pro: Begin Changed code $products_id=(preg_match("/^\d{1,10}(\{\d{1,10}\}\d{1,10})*$/",$HTTP_GET_VARS['products_id']) ? $HTTP_GET_VARS['products_id'] : (int)$HTTP_GET_VARS['products_id']); require(DIR_WS_CLASSES . 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN . '.php'); $class = 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN; $pad = new $class($products_id); echo $pad->draw(); //++++ QT Pro: End Changed Code } ?> </td> </tr> <tr class="productListing-heading"> <td colspan="2"><strong><?php echo TEXT_ENTER_QUANTITY; ?></strong></td> </tr> <tr class="productListing-even"> <td height="10" align="center" valign="middle"><?php echo tep_draw_input_field('cart_quantity', $pf->adjustQty(1), 'size="6"'); ?></td> <td height="10" align="center" valign="middle"><?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>
  15. pfilias

    [Contribution] - USPS Methods

    I think I got my fix to work like everyone else who posted... did the text change in the DB, then reran the SQL.
  16. pfilias

    [Contribution] - USPS Methods

    I ended up getting this to work. I didn't have to make that change in line 269, Scott.
  17. pfilias

    [Contribution] - USPS Methods

    I am using 2.2 RC2a. I am getting the same error on the checkout page: United States Postal Service United States Postal Service An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner. I am using the same login id and pw I am using on another store, on another server. I've gone through the install instructions, to the T. Is something wrong with the code in general.php, perhaps? //// // Alias function for module configuration keys function tep_mod_select_option($select_array, $key_name, $key_value) { reset($select_array); while (list($key, $value) = each($select_array)) { if (is_int($key)) $key = $value; $string .= '<br><input type="radio" name="configuration[' . $key_name . ']" value="' . $key . '"'; if ($key_value == $key) $string .= ' CHECKED'; $string .= '> ' . $value; } return $string; } // USPS Methods 2.9 // Alias function for Store configuration values in the Administration Tool function tep_cfg_select_multioption($select_array, $key_value, $key = '') { for ($i=0; $i<sizeof($select_array); $i++) { $name = (($key) ? 'configuration[' . $key . '][]' : 'configuration_value'); $string .= '<br><input type="checkbox" name="' . $name . '" value="' . $select_array[$i] . '"'; $key_values = explode( ", ", $key_value); if ( in_array($select_array[$i], $key_values) ) $string .= ' CHECKED'; $string .= '> ' . $select_array[$i]; } $string .= '<input type="hidden" name="' . $name . '" value="--none--">'; return $string; }
  18. Thanks to a friend of mine, locally, I think he's found the perfect merging of that code for /includes/functions/general.php. function tep_get_products_stock($products_id, $attributes=array()) { global $languages_id; global $pfs; $stock = false; if (is_object($pfs)) { $stock = $pfs->getStock($products_id); } if ($stock !== false) { return $stock; } else { $products_id = tep_get_prid($products_id); if (sizeof($attributes)>0) { $all_nonstocked = true; $attr_list=''; $options_list=implode(",",array_keys($attributes)); $track_stock_query=tep_db_query("select products_options_id, products_options_track_stock from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id in ($options_list) and language_id= '" . (int)$languages_id . "order by products_options_id'"); while($track_stock_array=tep_db_fetch_array($track_stock_query)) { if ($track_stock_array['products_options_track_stock']) { $attr_list.=$track_stock_array['products_options_id'] . '-' . $attributes[$track_stock_array['products_options_id']] . ','; $all_nonstocked=false; } } $attr_list=substr($attr_list,0,strlen($attr_list)-1); } if ((sizeof($attributes)==0) | ($all_nonstocked)) { $stock_query = tep_db_query("select products_quantity as quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); } else { $stock_query=tep_db_query("select products_stock_quantity as quantity from " . TABLE_PRODUCTS_STOCK . " where products_id='". (int)$products_id . "' and products_stock_attributes='$attr_list'"); } if (tep_db_num_rows($stock_query)>0) { $stock=tep_db_fetch_array($stock_query); $quantity=$stock['quantity']; } else { $quantity = 0; } return $quantity; } }
  19. I'm sad nobody has replied yet. :(
  20. pfilias

    Quantity Price Breaks

    I am trying to get this contribution to work with QT Pro. My post for help is here: http://forums.oscommerce.com/index.php?sho...p;#entry1213403
  21. pfilias

    QT Pro with Quantity Price Breaks

    I posted here, looking for help on this. http://forums.oscommerce.com/index.php?sho...p;#entry1213403
  22. Has anyone implemented QT Pro with Quanity Price Breaks per product? I am running into a problem AS I'm going through the code changes of catalog/includes/functions/general.php. The problem lies in the following code, as it wants you to find: // Return a product's stock // TABLES: products function tep_get_products_stock($products_id) { $products_id = tep_get_prid($products_id); $stock_query = tep_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $stock_values = tep_db_fetch_array($stock_query); return $stock_values['products_quantity']; } And replace it with: // Return a product's stock // TABLES: products // adapted to take advantage of $pfs (instance of PriceFormatterStore) function tep_get_products_stock($products_id) { global $pfs; $stock = false; if (is_object($pfs)) { $stock = $pfs->getStock($products_id); } if ($stock !== false) { return $stock; } else { $products_id = tep_get_prid($products_id); $stock_query = tep_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $stock_values = tep_db_fetch_array($stock_query); return $stock_values['products_quantity']; } // end if/else $stock !== false } My problem is that QTPro 4.3 has the following code: function tep_get_products_stock($products_id, $attributes=array()) { global $languages_id; $products_id = tep_get_prid($products_id); if (sizeof($attributes)>0) { $all_nonstocked = true; $attr_list=''; $options_list=implode(",",array_keys($attributes)); $track_stock_query=tep_db_query("select products_options_id, products_options_track_stock from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id in ($options_list) and language_id= '" . (int)$languages_id . "order by products_options_id'"); while($track_stock_array=tep_db_fetch_array($track_stock_query)) { if ($track_stock_array['products_options_track_stock']) { $attr_list.=$track_stock_array['products_options_id'] . '-' . $attributes[$track_stock_array['products_options_id']] . ','; $all_nonstocked=false; } } $attr_list=substr($attr_list,0,strlen($attr_list)-1); } if ((sizeof($attributes)==0) | ($all_nonstocked)) { $stock_query = tep_db_query("select products_quantity as quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); } else { $stock_query=tep_db_query("select products_stock_quantity as quantity from " . TABLE_PRODUCTS_STOCK . " where products_id='". (int)$products_id . "' and products_stock_attributes='$attr_list'"); } if (tep_db_num_rows($stock_query)>0) { $stock=tep_db_fetch_array($stock_query); $quantity=$stock['quantity']; } else { $quantity = 0; } return $quantity; Without a ton of trial and error, I can't see how I'd get the QTPro code to work with the changes I need to make, above. Has anyone done this?
  23. pfilias

    QT Pro and 2.2 RC2a

    My question really had to do with a fresh install of 2.2 RC2a and QT Pro. I don't already have a store set up. Wanted to know what kind of problems I'd run into if I installed RC2a and then overwrote the files that QT Pro 4.3 overwrites, which are based on RC1 as far as I know.
  24. I'm about to being a new install of osCommerce using 2.2 RC2a. In the past, I've gone ahead and installed QT Pro since it was one of the more indepth contributions out there. However, with 2.2 RC2a being out, it seems that doing a simple install of QT Pro 4.3 might not be a smart way to go, since it looks like the files that come with QT Pro 4.3 are much older than the files that are part of 2.2 RC2a. Has anyone crossed this bridge? I was hoping to knock this portion of the installation out tonight, but it looks like I'll be facing a small roadblock with this. Having to go through each and every file that is modified in QT Pro 4.3 looks pretty painful, but I'd be willing to make that sacrifice, if that were my only option. Anyone else?
×