Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

arcluna

Pioneers
  • Posts

    9
  • Joined

  • Last visited

Posts posted by arcluna

  1. Hi there,

     

    What I want to do with my cart is have all the products listed in a chart so basic information can be compared before looking at each product individually.

    I believe this would have to be done through the product_listings.php file but I have just started to learn php and am really unsure the best method to attack this.

     

    I also just installed the Product Extra Fields contribution and would like to directly link some of my new "extra fields" into the product listings.

     

     

    I saw someone else looking for the same thing and used this web page as an example. The same goes for me as well.

     

    I originally thought this would already happen with the product extra fields contribution but alas it did not.

     

    I have spent hours looking through the forums and the web for help on this but I can't come up with anything.

     

    If anyone can please help me with this endeavor I would be forever grateful.

     

    Thanks so much,

    -Zack

  2. Hi there,

     

    What I want to do with my cart is have all the products listed in a chart so basic information can be compared before looking at each product individually.

    I believe this would have to be done through the product_listings.php file but I have just started to learn php and am really unsure the best method to attack this.

     

    I also just installed the Product Extra Fields contribution and would like to directly link some of my new "extra fields" into the product listings.

     

     

    I saw someone else looking for the same thing and used this web page as an example. The same goes for me as well.

     

    I originally thought this would already happen with the product extra fields contribution but alas it did not.

     

    I have spent hours looking through the forums and the web for help on this but I can't come up with anything.

     

    If anyone can please help me with this endeavor I would be forever grateful.

     

    Thanks so much,

    -Zack

  3. Hi there

     

    I was trying to install the Products Extra Fields Contribution and when I try to pull up my shopping cart it gives me the following error:

     

    Fatal error: Call to undefined function tep_db_query() in /data/15/1/86/50/1412702/user/1516832/htdocs/oscommerce/includes/database_tables.php on line 6

     

    I am new to osCommerce and the only other contribution I have installed from my base install is STS.

     

    The funny thing is everything works fine on the admin side, it's only the front end that I receive this error.

     

    Here's the code I placed in database_tables.php (located at catalog/includes/database_tables.php)

     

    <?php
    	  // START: Extra Fields Contribution v2.0b - mintpeel display fix
    
                         $extra_fields_query = tep_db_query("
    SELECT pef.products_extra_fields_order, pef.products_extra_fields_status as status, 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)$HTTP_GET_VARS['products_id'] ." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."')
    ORDER BY pef.products_extra_fields_order");
    
    
           echo '<tr>
      <td>
      <table border="0" width="50%" cellspacing="0" cellpadding="2px">';
     while ($extra_fields = tep_db_fetch_array($extra_fields_query)) {
           if (! $extra_fields['status'])  // show only enabled extra field
              continue;
        echo'<tr><td class="main" align="left" valign="middle"><font size="1" color="#666666"><b>'.$extra_fields['name'].': </b>' . stripslashes($extra_fields['value']).'</font></td></tr>';
     }
        echo' </table>
      </td>
         </tr>'; 
          // END: Extra Fields Contribution - mintpeel display fix
    
       // START: Product Extra Fields
       define('TABLE_PRODUCTS_EXTRA_FIELDS', 'products_extra_fields');
       define('TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS', 'products_to_products_extra_fields');
       // END: Product Extra Fields
    
    ?>
    
    
    

     

    and this is the code at admin/includes/database_tables.php

     

    <?php
    /*
     $Id: database_tables.php,v 1.1 2003/06/20 00:18:30 hpdl Exp $
    
     osCommerce, Open Source E-Commerce Solutions
     http://www.oscommerce.com
    
     Copyright (c) 2003 osCommerce
    
     Released under the GNU General Public License
    */
    
    // define the database table names used in the project
     define('TABLE_ADDRESS_BOOK', 'address_book');
     define('TABLE_ADDRESS_FORMAT', 'address_format');
     define('TABLE_BANNERS', 'banners');
     define('TABLE_BANNERS_HISTORY', 'banners_history');
     define('TABLE_CATEGORIES', 'categories');
     define('TABLE_CATEGORIES_DESCRIPTION', 'categories_description');
     define('TABLE_CONFIGURATION', 'configuration');
     define('TABLE_CONFIGURATION_GROUP', 'configuration_group');
     define('TABLE_COUNTRIES', 'countries');
     define('TABLE_CURRENCIES', 'currencies');
     define('TABLE_CUSTOMERS', 'customers');
     define('TABLE_CUSTOMERS_BASKET', 'customers_basket');
     define('TABLE_CUSTOMERS_BASKET_ATTRIBUTES', 'customers_basket_attributes');
     define('TABLE_CUSTOMERS_INFO', 'customers_info');
     define('TABLE_LANGUAGES', 'languages');
     define('TABLE_MANUFACTURERS', 'manufacturers');
     define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info');
     define('TABLE_NEWSLETTERS', 'newsletters');
     define('TABLE_ORDERS', 'orders');
     define('TABLE_ORDERS_PRODUCTS', 'orders_products');
     define('TABLE_ORDERS_PRODUCTS_ATTRIBUTES', 'orders_products_attributes');
     define('TABLE_ORDERS_PRODUCTS_DOWNLOAD', 'orders_products_download');
     define('TABLE_ORDERS_STATUS', 'orders_status');
     define('TABLE_ORDERS_STATUS_HISTORY', 'orders_status_history');
     define('TABLE_ORDERS_TOTAL', 'orders_total');
     define('TABLE_PRODUCTS', 'products');
     define('TABLE_PRODUCTS_ATTRIBUTES', 'products_attributes');
     define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', 'products_attributes_download');
     define('TABLE_PRODUCTS_DESCRIPTION', 'products_description');
     define('TABLE_PRODUCTS_NOTIFICATIONS', 'products_notifications');
     define('TABLE_PRODUCTS_OPTIONS', 'products_options');
     define('TABLE_PRODUCTS_OPTIONS_VALUES', 'products_options_values');
     define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS', 'products_options_values_to_products_options');
     define('TABLE_PRODUCTS_TO_CATEGORIES', 'products_to_categories');
     define('TABLE_REVIEWS', 'reviews');
     define('TABLE_REVIEWS_DESCRIPTION', 'reviews_description');
     define('TABLE_SESSIONS', 'sessions');
     define('TABLE_SPECIALS', 'specials');
     define('TABLE_TAX_CLASS', 'tax_class');
     define('TABLE_TAX_RATES', 'tax_rates');
     define('TABLE_GEO_ZONES', 'geo_zones');
     define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones');
     define('TABLE_WHOS_ONLINE', 'whos_online');
     define('TABLE_ZONES', 'zones');
    
     // BOF Product Extra Fields
     define('TABLE_PRODUCTS_EXTRA_FIELDS', 'products_extra_fields');
     define('TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS', 'products_to_products_extra_fields');
    // EOF Product Extra Fields
    ?>
    
    

     

     

     

    Please help as I am new computer programming and am really struggling with this.

     

    Thanks so much

    -Zack

  4. Hi there,

     

    Please forgive me but I am very new to osCommerce. I just installed osCommerce and STS and am just starting to configure everything.

     

    I'm feeling extremely overwhelmed and a little unsure on the benefits of STS.

     

    I don't know if there's a beginner's guide or anything of the like, but I don't even know where to begin on a thread as long as this one.

     

    Any suggestions and guidance would be greatly appreciated.

     

    Thanks so much!

  5. Please forgive me as this must be a really basic question.

     

    I have just started to learn about databases and phpMyAdmin.

    Unfortunately, I really have no idea how to "run the file BTS.sql on your database"

     

    Any assistance would be greatly and sincerely appreciated.

     

    Thanks!

    -Zack

×
×
  • Create New...