Jump to content

partsace

Members
  • Content count

    63
  • Joined

  • Last visited

Everything posted by partsace

  1. partsace

    [Contribution]Product Image Verify

    I am trying to add the missing products_image filen ame to the image_verify.php page without having to click on then "edit" button to get the image I'm trying to add to the server. I want to put the missing image name on the right sidebar, but I'm having problems figuring it out. Here is what I've done so for and maybe you can point me in the right direct. $contents[] = array('text' => '' . $verify['products_image']); $contents[] = array('text' => '' . tep_image(DIR_WS_IMAGES . 'pixel_black.gif', '', '100%', 3)); I also don't have a problem adding the image name to the list of products in the center of the page. You can do this by adding it to line 154: <td class="dataTableContent"><?php echo $verify['products_image']; ?></td> Thanks, Scott
  2. partsace

    Freightquote.com Shipping Module Support

    I checked 3 times and I get the same results. I got it to work, but I had to add a lot of code like this: if ($action == 'new_product') { $parameters = array('products_name' => '', 'products_description' => '', 'products_url' => '', 'products_id' => '', 'products_quantity' => '', 'products_model' => '', 'products_image' => '', 'products_price' => '', 'products_weight' => '', 'products_freightquote_enable' => '', 'products_freightquote_class' => '', 'products_freightquote_length' => '', 'products_freightquote_width' => '', 'products_freightquote_height' => '', 'products_freightquote_nmfc' => '', 'products_freightquote_hzmt' => '', 'products_freightquote_package_type' => '', 'products_freightquote_commodity_type' => '', 'products_freightquote_class' => '', 'products_freightquote_content_type' => '', 'products_date_added' => '', 'products_last_modified' => '', 'products_date_available' => '', 'products_status' => '', 'products_tax_class_id' => '', 'manufacturers_id' => ''); //---Freightquote Modification START ---// $parameters = $freightQuote->mergePostParameters($parameters); //---Freightquote Modification END ---// Scott
  3. partsace

    Freightquote.com Shipping Module Support

    Here is my problem. I have installed the contribution in a fresh site and everything seems to be working, except for the FQ interface in /admin/categories.php. I put all the package information in the FQ section in Catalog -> Categories, hit Preview and then Update. I go back into that same item and the "Enable with Freightquote:" is un-checked and all of the dimensions boxes say "0". Just for fun, I have gone into the Products database and manually edit the product and it looks good. I can checkout and all of the FQ stuff works just fine. When I go and edit that product again and change a dimension, it will not save the updated size. What can I do to fix this? Scott
  4. I've had PayPal Website Payments Pro - Direct Payments installed on a working site since March, 2012 and now all of a sudden I am getting a looping issue. When you checkout and put in your credit card information, you are sent back to shopping_cart.php and the URL reads "https://www.xxxxxxxxxxxxxxxx.com/shopping_cart.php?error_message=". This happens in Chrome, IE, and Firefox. It also happens with a new, fresh OSCommerce site. I have also checked to see if cURL was installed correctly and it is. I have many sites running PPWPP and this is the only one it's happening to. Any help would be great. Scott running 2.3.1
  5. Ironheat, 1 post and you’re a genius! I have been searching for days to try and figure this out. Thanks, Scott
  6. Here's a good one for you... I have 2 sites using the Quick Price Updates and both are working just fine, but I do not have the "<< Page 1 of 27 >>" at the bottom of one of the sites. One has it and the other one doesn’t! What am I missing? I've made sure that the "Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)" is on. I've also been using this for years (Great add-on), just can't figure this one out. I've even put up the lastest version and still have the same problem. Scott
  7. partsace

    Google XML Sitemap w/ Admin support

    This is line 757: foreach ( array_merge(glob($this->savepath . $pattern)) as $filename ) {
  8. partsace

    Google XML Sitemap w/ Admin support

    Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/xxxxxxx/public_html/sitemap.class.php on line 757 Warning: Invalid argument supplied for foreach() in /home/xxxxxxx/public_html/sitemap.class.php on line 757 Generated Google Sitemap Index Successfully I am getting the above error message when I run the script. It says "Generated Google Sitemap Index Successfully", but there is only the main URL in this file. Is this correct? Scott
  9. partsace

    PayPal WPP Direct Payments & Express Checkout Support

    How do I fix this: 1 - Database update in place? NO 2 - I have installed everything and I can add a product to cart, add CC info, get to checkout screen then instead of confirmation, I go back to checkout_shipping.php. #2 may be fixed by #1, but I need to know what to do. Thanks, Scott
  10. partsace

    PayPal WPP Direct Payments & Express Checkout Support

    That's it! Thanks, Scott
  11. partsace

    PayPal WPP Direct Payments & Express Checkout Support

    I have Login and Logoff for OSCommerce Administrators installed in my catalog and I need to know what pages are opened when you hit "Issue Refund" and "Add Charges" on the orders page in admin. I need to add these files to the File Access. Thanks, Scott
  12. partsace

    [Contribution] Availability

    I got this error when I tried the above. Scott
  13. partsace

    [Contribution] Availability

    I want to add the availability to shopping_cart.php Is there any way to do this? The image is hard coded and not a working item. I need to do this so if someone uses the "Buy Now" button, they will see the availability before finding out later that it is not in-stock. Thanks, Scott
  14. partsace

    Custom Computer Creator v9 Support

    Has anyone come up with a solution for the radio buttons? Let me now, C. Scott Williams
  15. partsace

    Attribute Sets Plus

    Has anyone had any luck with an image as an attribute? I have a project that I am working on for a cosmetic site that wants to have a choice of images. I would think that I would use radio buttons for the choice but have an image to select for color. Thanks, Scott
  16. partsace

    [Contribution] Extra Fields

    Has anyone successfully added Extra Fields to includes/modules/product_listing.php? I have tried everything I know and have been working on it for 10 hours straight and still no success. I have tried the below code, but nothing shows up: // START: Extra Fields Contribution v2.0a $extra_fields_query = tep_db_query(" SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=".(int)$products_id." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".$languages_id."') ORDER BY products_extra_fields_order"); while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { echo '<b>'.$extra_fields['name'].': </b>'; echo $extra_fields['value'].'<BR>'; } // END: Extra Fields Contribution I would love some insight to this one. Thanks, Scott
  17. I have to revamp a customers website and I cannot find a contribution for this: http://www.cs4u.org/router_bits.htm Does anyone have a clue what the best one to use is? I have tried a few, but just can't seem to find the right one. Thanks for your help, Scott
  18. My admin login.php page keeps reloading itself after putting in the correct username and PW. Has anyone had this problem and know who it fix it? I have made 3 differenct admin setions and it keeps doing it. Thanks, Scott Ps. I know it is the correct UN & PW because I checked the database and it says that I have logged in 5 times
  19. My admin login.php page keeps reloading itself after putting in the correct username and PW. Has anyone had this problem and know who it fix it? I have made 3 differenct admin setions and it keeps doing it. Thanks, Scott Ps. I know it is the correct UN & PW because I checked the database and it says that I have logged in 5 times.
  20. partsace

    Quick Updates Help

    I am working on the quick updates contributions. I am having problems with updating a field in by database that uses both numbers and characters. The field is products_years. We sell parts for cars online and we need this field to let customers know if the part they are about to purchase is for their vehicle. Below is the code that I am using. The problem is that when I change the products_years field, it thinks it?s a number field. For instance, if I put 1995-1998, it puts in -3 after the update is done. Or if I put "All", it keeps is the original field. Does anyone have a clue on how I can make this work or what I am doing wrong? Scott foreach($HTTP_POST_VARS['product_new_years'] as $id => $new_years) { mysql_query("UPDATE products SET products_years=$new_years WHERE products_id=$id"); }
  21. partsace

    Quick Updates Help

    I forgot to let you know that the table setting is: products_years VARCHAR(25) DEFAULT NULL I have tried tinytext, didn't work. I have tried puting quotes around the number or word, didn't work. Below is the code for quick_updates.php. <?php /* $Id: quick_updates.php,v 1.4b $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Based on the original script contributed by Burt (burt@xwww.co.uk) and by Henri Bredehoeft (hrb@nermica.net) and Blue Dog (simon@bluedogweb.co.uk) updated by GniDhal (fx@geniehalles.com) & xaglo (xaglo@free.fr) Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); if ($HTTP_POST_VARS) { if ($action == "update") { $messageStack->add(TEXT_PRODUCTS_UPDATED, 'success'); foreach($HTTP_POST_VARS['product_new_price'] as $id => $new_price) { mysql_query("UPDATE products SET products_price=$new_price WHERE products_id=$id"); } foreach($HTTP_POST_VARS['product_new_weight'] as $id => $new_weight) { mysql_query("UPDATE products SET products_weight=$new_weight WHERE products_id=$id"); } foreach($HTTP_POST_VARS['product_new_years'] as $id => $new_years) { mysql_query("UPDATE products SET products_years=$new_years WHERE products_id=$id"); } foreach($HTTP_POST_VARS['product_new_quantity'] as $id => $new_quantity) { mysql_query("UPDATE products SET products_quantity=$new_quantity WHERE products_id=$id"); } foreach($HTTP_POST_VARS['product_new_status'] as $id => $new_status) { tep_set_product_status($id, $new_status); } foreach($HTTP_POST_VARS['product_new_tax'] as $id => $new_tax_id) { mysql_query("UPDATE products SET products_tax_class_id=$new_tax_id WHERE products_id=$id"); } } } ?> <!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> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <form name="update" method="post" action="<?php echo "$PHP_SELF?action=update"; ?>"> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td align=middle><?php if ($HTTP_GET_VARS['pID']) { echo tep_image_submit('button_update.gif', IMAGE_UPDATE); } else { echo tep_image_submit('button_update.gif', IMAGE_INSERT); } echo ' <a href="' . tep_href_link(FILENAME_QUICK_UPDATES, 'cPath=' . $cPath . '&pID=' . $HTTP_GET_VARS['pID']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>';?> </td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_model DESC' )."" >-</a> " . TABLE_HEADING_MODEL . " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_model ASC' )."" >+</a>"; ?> </td> <td class="dataTableHeadingContent"><?php echo " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=pd.products_name DESC' )."" >-</a> " . TABLE_HEADING_PRODUCTS . " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=pd.products_name ASC' )."" >+</a>"; ?> </td> <td class="dataTableHeadingContent" align="center"><?php echo " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_status DESC' )."" >-</a> " . TABLE_HEADING_STATUS . " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_status ASC' )."" >+</a>"; ?> <br>off / on</td> <td class="dataTableHeadingContent" align="center"><?php echo " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_weight DESC' ) ."" >-</a> " . TABLE_HEADING_WEIGHT . " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_weight ASC' ) ."" >+</a> "; ?> </td> <td class="dataTableHeadingContent" align="center"><?php echo " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_quantity DESC' )."" >-</a> " . TABLE_HEADING_QUANTITY . " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_quantity ASC' )."" >+</a> "; ?> </td> <td class="dataTableHeadingContent" align="center"><?php echo " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_price DESC' ) ."" >-</a>" . TABLE_HEADING_PRICE . " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_price ASC' ) ."" >+</a>"; ?> </td> <td class="dataTableHeadingContent" align="center"><?php echo " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_years DESC' ) ."" >-</a>" . TABLE_HEADING_YEARS . " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_years ASC' ) ."" >+</a>"; ?> </td> <td class="dataTableHeadingContent" align="center"><?php echo " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_tax_class_id DESC' )."" >-</a> " . TABLE_HEADING_TAX . " <a href="" . tep_href_link( FILENAME_QUICK_UPDATES, 'sort_by=p.products_tax_class_id ASC' )."" >+</a> "; ?> </td> </tr> <tr class="datatableRow"> <? $tax_class_array = array(array('id' => '0', 'text' => NO_TAX_TEXT)); $tax_class_query = tep_db_query("select tax_class_id, tax_class_title from " . TABLE_TAX_CLASS . " order by tax_class_title"); while ($tax_class = tep_db_fetch_array($tax_class_query)) { $tax_class_array[] = array('id' => $tax_class['tax_class_id'], 'text' => $tax_class['tax_class_title']); } ($sort_by) ? $sort_by = 'ORDER BY '.$sort_by : $sort_by = $HTTP_POST_VARS['sort_order']; $result = tep_db_query("SELECT DISTINCT p.products_id, p.products_model, pd.products_name, p.products_years, p.products_status, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id FROM " . TABLE_PRODUCTS . " as p LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " as pd ON (p.products_id = pd.products_id) WHERE pd.language_id = '$languages_id' $sort_by "); if ($row = mysql_fetch_array($result)) { do { echo tep_draw_hidden_field( 'sort_order', $sort_by); echo '<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'">'; echo "<td class="smallText" >".$row["products_model"]."</td>n"; echo "<td><a href="".tep_href_link (FILENAME_CATEGORIES, 'pID='.$row["products_id"].'&action=new_product'). "">".$row["products_name"]."</a></td>n"; if ($row['products_status'] == '1') { echo "<td class="smallText" align="center"><input type="radio" name="product_new_status[".$row['products_id']."]" value="0" ><input type="radio" name="product_new_status[".$row['products_id']."]" value="1" checked ></td>n"; } else { echo "<td nowrap align="center"><input type="radio" style="background-color: #EEEEEE" name="product_new_status[".$row['products_id']."]" value="0" checked ><input type="radio" style="background-color: #EEEEEE" name="product_new_status[".$row['products_id']."]" value="1"></td>n"; } echo "<td nowrap align="center"><input type="text" size="6" name="product_new_weight[".$row['products_id']."]" value={$row['products_weight']}></td>n"; echo "<td class="smallText" align="center"><input type="text" size="3" name="product_new_quantity[".$row['products_id']."]" value={$row['products_quantity']}></td>n"; echo "<td class="smallText" align="center"><input type="text" size="7" name="product_new_price[".$row['products_id']."]" value={$row['products_price']}></td>n"; echo "<td class="smallText" align="center"><input type="text" size="9" name="product_new_years[".$row['products_id']."]" value={$row['products_years']}></td>n"; echo "<td class="smallText" align="center">".tep_draw_pull_down_menu("product_new_tax[".$row['products_id']."]"", $tax_class_array, $row['products_tax_class_id'])."</td>n"; } while($row = mysql_fetch_array($result) ); } echo "</table>n"; ?></td> </tr> </table></td> </tr> <tr> <td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2"> </table></td> </tr> </table></td> </tr> </table></td> <table width="100%" border="0" cellspacing="1"> <tr> <td align=middle><?php if ($HTTP_GET_VARS['pID']) { echo tep_image_submit('button_update.gif', IMAGE_UPDATE); } else { echo tep_image_submit('button_update.gif', IMAGE_INSERT); } echo ' <a href="' . tep_href_link(FILENAME_QUICK_UPDATES, 'cPath=' . $cPath . '&pID=' . $HTTP_GET_VARS['pID']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td> </tr> </table> </form> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Thanks, Scott
  22. After getting the tables in mySQL (don't know much about adding tables to mySQL {the sql included did not work for me and I had to do it by hand}), this contribution is one of the best that I have seen!!! Thanks, Scott
  23. partsace

    Bestsellers scroller

    function infoBoxContents($contents) { $this->table_cellpadding = '3'; $this->table_parameters = 'class="infoBoxContents"'; $info_box_contents = array(); $info_box_contents[] = array(array('text' => tep_draw_separator('pixel_trans.gif', '100%', '1'))); for ($i=0; $i<sizeof($contents); $i++) { $info_box_contents[] = array(array('align' => $contents[$i]['align'], 'form' => $contents[$i]['form'], 'params' => 'class="boxText"', 'text' => $contents[$i]['text'])); } $info_box_contents[] = array(array('text' => tep_draw_separator('pixel_trans.gif', '100%', '1'))); return $this->tableBox($info_box_contents); } } The above code does not exist in CATALOG/INCLUDES/CLASSES/BOXES.PHP Where do I put your code? Scott
×