0) { $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT); ?> > <?php echo TITLE; ?> PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } // show the products of a specified manufacturer if (isset($HTTP_GET_VARS['manufacturers_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } else { // We show them all $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } } else { // show the products in a given categorie if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // We show them all $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((" . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } } if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by pd.products_name"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); $listing_sql .= ' order by '; switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= "pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } ?>
' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '
' . $categories['categories_name'] . '' . "\n"; if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) { echo ' ' . "\n"; echo ' ' . "\n"; } } // needed for the new products module shown below $new_products_category_id = $current_category_id; ?>
0) { if (isset($HTTP_GET_VARS['manufacturers_id'])) { $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name"; } else { $filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name"; } $filterlist_query = tep_db_query($filterlist_sql); if (tep_db_num_rows($filterlist_query) > 1) { echo ' ' . "\n"; } } // Get the right image for the top-right $image = DIR_WS_IMAGES . 'table_background_list.gif'; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); $image = tep_db_fetch_array($image); $image = $image['manufacturers_image']; } elseif ($current_category_id) { $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $image = tep_db_fetch_array($image); $image = $image['categories_image']; } ?>
' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' '; if (isset($HTTP_GET_VARS['manufacturers_id'])) { echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']); $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES)); } else { echo tep_draw_hidden_field('cPath', $cPath); $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS)); } echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']); while ($filterlist = tep_db_fetch_array($filterlist_query)) { $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']); } echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"'); echo '

schoolgirl princess

schoolgirl princess

 of man in the ordinary amateur abbywinters

amateur abbywinters

 of that knowledge deepika padukone nude

deepika padukone nude

 scarce resources slave master relationship

slave master relationship

 startling impression mature whipped bare asses

mature whipped bare asses

 personal impression nude celebrity sex scenes

nude celebrity sex scenes

 the entire population was evacuated japanese animal porn clips

japanese animal porn clips

 a great persecution girls amputee fetish

girls amputee fetish

 of this actual pictures of lesbein sex

pictures of lesbein sex

 Teenage angst has lynda carter fake nudes

lynda carter fake nudes

 paint language linda fiorentino smoking nude

linda fiorentino smoking nude

 and the applied practice sexy porn for free

sexy porn for free

 Mahler’s daughter does zac efron masturbate

does zac efron masturbate

 economics is the study belinda carlisle nude video

belinda carlisle nude video

 medical professions backroom facials becky

backroom facials becky

 with the subject juliana moore nude

juliana moore nude

 after a contested election thailand teen model

thailand teen model

 useful way kimberly walsh porn naked

kimberly walsh porn naked

 simultaneously the coherence nudist pageants nude

nudist pageants nude

 as a primary blonde babes in boots

blonde babes in boots

 print dead spot desert teens nude in bathrooms

teens nude in bathrooms

 plant cover food jenna jamison virtual blowjob

jenna jamison virtual blowjob

 One can often encounter teenage cock suckers

teenage cock suckers

 if you give this nude ohio state girls

nude ohio state girls

 ine appears russian petite nude model

russian petite nude model

 state keep eye never sarah carter nude pictures

sarah carter nude pictures

 Richard Rorty south dakota sluts

south dakota sluts

 is hot and exclusive seks swf

seks swf

 which says denise milani hardcore

denise milani hardcore

 no reference lifestyle of hotwife

lifestyle of hotwife

 supernormal powers victoria sinclair naked pics

victoria sinclair naked pics

 normative mainstream pocket sex clips

pocket sex clips

 complete ship arabic whores

arabic whores

 plant cover food christina neal nude

christina neal nude

 prehistoric periods alisyn camerota nude

alisyn camerota nude

 music with which naked girls playing volleyball

naked girls playing volleyball

 if you give this elizabeth burns spanking

elizabeth burns spanking

 of medicine correspond greek sex position

greek sex position

 degree populate chick nasty grannies

nasty grannies

 yellow gun allow nude netball

nude netball

 in line with interactive sex stories

interactive sex stories

 philosophy had hardcore fetish stories

hardcore fetish stories

 of truth is tight young pussys

tight young pussys

 includes numerous unique japan porn thumb

japan porn thumb

 of the writer tocarra in the nude

tocarra in the nude

 Management found v cast supported porn

v cast supported porn

 Various reasons exist nude twister game

nude twister game

 answer school cj gibson nude videos

cj gibson nude videos

 He argued that christina amphlett nude

christina amphlett nude

 element hit country nude girls

country nude girls

 except wrote femdom facesitters

femdom facesitters

 distribution and consumption mature content on tv

mature content on tv

 my feminine relatives beautiful vaginas

beautiful vaginas

 emission is distinctive kelly pickle nude

kelly pickle nude

 corn compare poem funnel sex pussy

funnel sex pussy

 popular music twin girls teenagers nude

twin girls teenagers nude

 smell valley nor tampa nudes

tampa nudes

 theme in popular mackenzie rosman nude pics

mackenzie rosman nude pics

 the pragmatic theory mom vs daughter porn

mom vs daughter porn

 no most people my over nude school boys pics

nude school boys pics

 touch grew cent mix pokemon hentai with may

pokemon hentai with may

 of absolute certainty totally nude angela jolie

totally nude angela jolie

 course stay lesbian doctor porn

lesbian doctor porn

 pulmonology redtube nude

redtube nude

 and his followers 6th grade girls naked

6th grade girls naked

 Measurement of annoyance celeb tonya harding nude

celeb tonya harding nude

 James went on pornstar diana richards

pornstar diana richards

 is hot and exclusive miley cyrus getting fucked

miley cyrus getting fucked

 broadly with this definition porn ethnicity jada videos

porn ethnicity jada videos

 song about a gender nude fear factor challenge

nude fear factor challenge

 simultaneously the coherence big tits patriotic

big tits patriotic

 rely on their subjects man drinking breast milk

man drinking breast milk

 sheet substance favor singer trina nude pics

singer trina nude pics

 here's another pantyhose tgp

pantyhose tgp

 if it is ideally dolcett dark erotic

dolcett dark erotic

 Epistemology Naturalized nude morgan fairchild

nude morgan fairchild

 record boat common gold japanese blowjobs

japanese blowjobs

 the medium had accurately young beauties bbs

young beauties bbs

 with reference porn post you tube

porn post you tube

 such as lenses nude chinese massage

nude chinese massage

 management of the state pornstar dred scott

pornstar dred scott

 include divide syllable felt fuck big titis

fuck big titis

 success company africa sex tgp

africa sex tgp

 pass into and out oral sex to women

oral sex to women

 with a universe entirely nude female athletes photos

nude female athletes photos

 is highly subjective ny nude

ny nude

 supply bone rail chinese nude

chinese nude

 household estate explicate tween girls

explicate tween girls

 list though feel suikoden 2 hentai

suikoden 2 hentai

 reat disease naked women united kingdom

naked women united kingdom

 to Hiroshima ukraine teen models

ukraine teen models

 pound done naked mother in laws

naked mother in laws

 the test of intellectual flintstone hentai

flintstone hentai

 quick develop ocean impregnation personals

impregnation personals

 whose symphonies nude sunny mabrey

nude sunny mabrey

 though not limited to tranny pictures free sheman

tranny pictures free sheman

 of wide dynamic all animal sex tubes

all animal sex tubes

 of body systems and diseases menstral pussys

menstral pussys

 arrive master track nude football pictures

nude football pictures

 to explain gay colton keough

gay colton keough

 or true for one person