Jump to content

kickus

Members
  • Content count

    2
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Kristian B?ckstr?m
  1. kickus

    Suomi - Finland payment modules

    Is this file still available somewhere? I would be interested..
  2. kickus

    [Contribution] Extra Fields

    The admin search query (in admin/categories.php) should probably have something like this (it's somewhere around line 912).. $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " p2pef using(products_id) where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and (pd.products_name like '%" . tep_db_input($search) . "%' or (p2pef.products_extra_fields_value like '%" . tep_db_input($search) . "%')) order by pd.products_name"); I've used the extra fields for barcodes, salescodes, price bands etc, and it's important for the admins to find a product based on barcode. The installation of this contribution was a bit messy (a .diff file for patch would be nice), but it seems to work.
×