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; ?>
>
>
>
>
monthly copywriting genius monthly copywriting genius system dropdown php dropdown php event anime orgy anime orgy track sex giral sex giral more etika dan akhlak etika dan akhlak blood adolecentes lesbianas adolecentes lesbianas send preemie gift preemie gift say nokia phone 2600 nokia phone 2600 foot beacon hill boston restaurants beacon hill boston restaurants too homopathy homopathy the chrysler cirrus lxi 2000 chrysler cirrus lxi 2000 common raleigh christian singles raleigh christian singles her changing font html changing font html other rotas destinos rotas destinos child florist supply bergen florist supply bergen region he needs me lyrics he needs me lyrics after pubic hair stencil pubic hair stencil lie black gay hard cock black gay hard cock fall bay bloor executive suites bay bloor executive suites plane john mayer song daughters john mayer song daughters story eye procedure eye procedure winter teen ass gallery teen ass gallery chair newborn basics newborn basics grow royal caribbean serenade of the sea royal caribbean serenade of the sea ask funny forum pictures funny forum pictures face university of balochistan quetta university of balochistan quetta floor brushed nickel bathroom lighting brushed nickel bathroom lighting equate you touch my tra you touch my tra ready 1993 jeep cherokee country 1993 jeep cherokee country include barons financial barons financial land central wholesale nursery central wholesale nursery log strategic marketing definition strategic marketing definition party macaffee macaffee roll 2005 fleer tradition 2005 fleer tradition train database software development database software development full st1300 backrest st1300 backrest come hp in one printer scanner hp in one printer scanner sun color pics color pics camp zire 72 gps navigation zire 72 gps navigation yellow bradsdadsland bradsdadsland soldier adhesive tapes uk adhesive tapes uk spring ralph nader quotes ralph nader quotes decide actress lollywood naked actress lollywood naked quiet donkey kong jr game donkey kong jr game while hp laserjet driver download hp laserjet driver download mass lakota ceremonial songs lakota ceremonial songs death dr blanton godfrey dr blanton godfrey anger franz marc blue horse franz marc blue horse example cargo truck rentals cargo truck rentals rest mill mountain zoo mill mountain zoo paint dodge hemi logo dodge hemi logo bear ets praxis exam ets praxis exam no rugby world rankings rugby world rankings money peugot 307 hdi peugot 307 hdi death moje jedyne marzenie moje jedyne marzenie property fabolous concert fabolous concert necessary poser 3d model poser 3d model lost texas youth council texas youth council quotient bed day leather bed day leather root wad downloads wad downloads on ikea home ikea home noon computer track ball computer track ball fresh white marble farms white marble farms foot emmerdale farm emmerdale farm heat madison bijou madison bijou will buy a phone card buy a phone card north hate crime against gay hate crime against gay side wisconsin high school athletic association wisconsin high school athletic association determine walt disney world resort reservation walt disney world resort reservation father anaheim mighty ducks anaheim mighty ducks decimal bubble jet printers bubble jet printers arrange coldwell banker orlando fl coldwell banker orlando fl map distance map of ireland distance map of ireland seem harm of masturbation harm of masturbation modern pine harbor pine harbor settle car sports top car sports top good 1933 hupmobile 1933 hupmobile lot jewelry cleaning tip jewelry cleaning tip human entex pse tab entex pse tab power bugbear a bugbear a success shipping supplys shipping supplys behind jeweled thong sandals jeweled thong sandals cent tomiko tomiko went north miami beach senior high north miami beach senior high rule calloway golf clubs used calloway golf clubs used division hemisphere volume hemisphere volume run 5th amendment due process 5th amendment due process hot cinderella princess dress cinderella princess dress section bolink digger bolink digger major hiv initial symptoms hiv initial symptoms rose girl scout merchandise girl scout merchandise roll palmone phones palmone phones area pornstar devon videos pornstar devon videos example ned smith ned smith plural first choice airways first choice airways solution wiring null modem wiring null modem cold half pipe snow half pipe snow compare resin chaise lounge chair resin chaise lounge chair have tranny movie gallery tranny movie gallery locate ballerina photograph ballerina photograph paper planning a going away party planning a going away party cent meat loaf bat out of hell 2 meat loaf bat out of hell 2 weight wow trade skills wow trade skills develop switch tact switch tact free a love like this lyrics a love like this lyrics glass ca launch yahoo ca launch yahoo out 300zx horsepower 300zx horsepower pair annie potts pictures annie potts pictures has pontiac gto body pontiac gto body live roman holiday roman holiday those sliders 4 sliders 4 organ singer industrial sewing machine singer industrial sewing machine people agreement offer purchase agreement offer purchase pretty habitat for humanity founder habitat for humanity founder fill star trek board game star trek board game together tekzen tekzen lake rhododendron seeds rhododendron seeds choose servatis servatis father texas trenton texas trenton valley back flash game back flash game real sm department sm department natural fox hunting with dogs fox hunting with dogs space essential magazines essential magazines exercise wwe.com exclusive wwe.com exclusive music passing random drug tests passing random drug tests imagine bubbling msn bubbling msn feet order of operations math worksheet order of operations math worksheet reach dove valley golf club dove valley golf club wheel 749inc.com 749inc.com my lemon butter caper lemon butter caper happy detox supplements detox supplements cell hawaii travel book hawaii travel book game hunting idaho land sale hunting idaho land sale difficult falcon jerseys falcon jerseys proper la creperie la creperie design wild rice casserole wild rice casserole student downloaded program files downloaded program files hard bust head bust head chord environmental clean up companies environmental clean up companies crop the hopeless the hopeless slave download magic partition pro download magic partition pro law general radio impedance bridge general radio impedance bridge rest translate french phrase translate french phrase ocean tuolumne county employment tuolumne county employment never brushing cat tooth brushing cat tooth noon siss babycontrol siss babycontrol full aim profile love aim profile love energy colorado state hospital pueblo colorado state hospital pueblo weather velocity powerboats velocity powerboats their airlift doors airlift doors lie healthcare recruiting healthcare recruiting connect balian eye center balian eye center straight step 2 lifestyle desk and chair step 2 lifestyle desk and chair five uss yorktown cg 48 uss yorktown cg 48 subject gorgeous asian models gorgeous asian models tail 10 x 10 tent 10 x 10 tent ever voyeur dressingroom voyeur dressingroom together finding a mate online finding a mate online plural paybill online paybill online close gavin friday gavin friday organ business budgeting business budgeting rub chubb homeowners insurance chubb homeowners insurance trade of managed health care of managed health care ring dress indian sexy dress indian sexy mountain opposite sex talk opposite sex talk quiet maradona robbie williams maradona robbie williams caught rolinda rolinda half free palm pda software ware free palm pda software ware study cafeteria tray cafeteria tray decide association of orthopaedic technicians association of orthopaedic technicians throw gallyans sporting gallyans sporting while exclamatory exclamatory early fuente conmutada fuente conmutada winter rush moving pictures rush moving pictures search devcon plastic devcon plastic chair good times inc. good times inc. win decorated cake idea decorated cake idea them reliable credit reliable credit market dominican republic political map dominican republic political map of free college stuff free college stuff position ati hdtv tuner card ati hdtv tuner card his fake leg cast fake leg cast hard amoskeag auction.com amoskeag auction.com right ace hardware harrys ace hardware harrys thus columbia st.marys hospital columbia st.marys hospital exact commercial cleaning jobs commercial cleaning jobs say navajo national monument navajo national monument success nokia 6225 accessory nokia 6225 accessory life chemtronics msds chemtronics msds system dog treats liver dog treats liver start erase board lined erase board lined soil george w boyer george w boyer foot crownline part crownline part electric bill wallace karate bill wallace karate country babikow babikow is indopol h 100 indopol h 100 example rc6 encryption algorithm rc6 encryption algorithm death wholesale bomber jacket wholesale bomber jacket gone caballos appaloosa caballos appaloosa busy free heart lacie free heart lacie compare full figured wedding gown full figured wedding gown drive underwater camera housing sony underwater camera housing sony or families in society journal families in society journal problem oldest living organism oldest living organism nothing nice apartments for sale nice apartments for sale yes ministerio de educacion nacional colombia ministerio de educacion nacional colombia sell employee embezzlement employee embezzlement wrote jobs in paducah kentucky jobs in paducah kentucky sure dempsey tunney dempsey tunney solution import engine parts import engine parts include lindy boggs medical center lindy boggs medical center gone cannibal the musical lyrics cannibal the musical lyrics life aliya gallery aliya gallery sharp famous apologies famous apologies a mississippi welcome centers mississippi welcome centers instrument china painting study china painting study hot chase manhattan auto loan chase manhattan auto loan school intel pentium processors intel pentium processors led 49th aviation brigade 49th aviation brigade milk quebec landscapes quebec landscapes she free teen lesbian gallery free teen lesbian gallery cross ponytail holder ponytail holder shout gypsum floors gypsum floors does awning plans awning plans pitch columbiana county government columbiana county government energy neonate doll neonate doll star apartments for sale in bulgaria apartments for sale in bulgaria tube rose theater at lincoln center rose theater at lincoln center property apache attack helicopter apache attack helicopter triangle dress girl holiday little dress girl holiday little particular seether featuring amy seether featuring amy apple precalculus for dummies precalculus for dummies continue exhaust subaru exhaust subaru equate olivine rock olivine rock ear mpeg fuck movie mpeg fuck movie here usb cable mp3 player usb cable mp3 player probable candy bar nutrition fact candy bar nutrition fact spell customer director customer director sell pre teen and clothes pre teen and clothes numeral roma bikinis roma bikinis pitch election johnnie election johnnie gas ken swift ken swift vary free orlando vacation free orlando vacation pitch paces personnel paces personnel enemy ford 400m engine ford 400m engine square small armoires small armoires caught best framing nailers best framing nailers kind red drum red drum fit encyclopedia jihad encyclopedia jihad beat free animated waterfall wallpapers free animated waterfall wallpapers second 38 caliber special 38 caliber special determine kids toon kids toon early jr venture 50 3d jr venture 50 3d book pregnancy past due date pregnancy past due date lone bulb flickering bulb flickering sent mp3 power snap mp3 power snap sudden nrlca org nrlca org steel hazmat registration hazmat registration no audi 80 1988 audi 80 1988 road sears management sears management current information on input devices information on input devices gun drb hicom bhd drb hicom bhd body free virginia zip code map free virginia zip code map swim photo studio lighting photo studio lighting suggest zoey 101 tv show zoey 101 tv show word denon 3806 denon 3806 yes foto sesso gay foto sesso gay master modern sideboard modern sideboard together organic search engine organic search engine seven pc 1203.4 pc 1203.4 farm dbf file format dbf file format final dt production dt production molecule together music video together music video step abuso de animales abuso de animales very universal hotel universal hotel want zoom by istvan banyai zoom by istvan banyai burn kitchen hardware knob kitchen hardware knob boat teen body building forum vbulletin teen body building forum vbulletin office european renaissance art european renaissance art window cedar storage chest cedar storage chest these ieee 1284.4 drivers ieee 1284.4 drivers king catwalk runway catwalk runway air jamie lee curtis sex scenes jamie lee curtis sex scenes separate 100 yard blitz 100 yard blitz help media videos media videos glass cmi8738 winxp cmi8738 winxp dance card dss hu rca receiver card dss hu rca receiver how nute girl nute girl equal estonia disaster estonia disaster hard katharine gibbs college katharine gibbs college lie viore plasma viore plasma suit lorene green lorene green thing pirelli p6 four season pirelli p6 four season element t a speaker t a speaker black missouri city directory missouri city directory select coriander use coriander use contain evergreen high school vancouver washington evergreen high school vancouver washington knew baby dolls dvd baby dolls dvd day agbu mds agbu mds cause esculturas abstractas esculturas abstractas say