arcluna
-
Posts
9 -
Joined
-
Last visited
Posts posted by arcluna
-
-
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
-
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
-
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!
-
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
Product Listings as sortable chart?
in General Add-Ons Support
Posted
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