add_current_page(); // Check if customer is logged in if writing a review /* if ($_GET['write_review']=='Y') { if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL')); } if ($is_guest_account=='1') { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_ACCOUNT_EDIT, 'review=true&guest_account=true', 'SSL')); } }*/ $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . $_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); if ($product_check['total'] > 0) { $product_info_query = tep_db_query("select p.group_buy, p.products_weight, p.products_type, pd.products_viewed, p.products_weight, p.products_date_added, p.products_last_modified, p.products_ordered, m.product_promotion, m.manufacturers_image, m.manufacturers_name, p.products_suppliers_prod_code, p.products_universal, p.products_type, p.products_id, pd.products_name, pd.products_description, pd.products_diy_tips, p.products_model, p.products_quantity, p.products_image, p.products_bimage, pd.products_url, p.products_price, p.products_rrp, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id) where p.products_status = '1' and p.products_id = '" . $_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); $word_count=0;$search_string='';$search_string2=''; $search_string_array = explode(" ",$product_info['products_name']); foreach($search_string_array AS $search_entry) { if(strlen($search_entry) > 3) { $word_count++; if ($word_count>1) { $search_string .= ", "; $search_string2 .= ", "; } $search_string .= ''.$search_entry.''; $search_string2 .= $search_entry; } } $meta_description = $product_info['products_name']; $meta_title = $product_info['products_name']; $h1_title = $product_info['products_name']; if (strlen($h1_title)>90) { $h1_title = substr($h1_title,0,90)."..."; } $meta_keywords = $search_string2; // Grab group buy info if ($product_info['group_buy']=='Y') { $group_buy = mysql_fetch_array(mysql_query("SELECT gb.*, gbs.status FROM group_buys gb, group_buy_status gbs WHERE gb.products_id='$product_info[products_id]' and gb.group_buy_status_id=gbs.group_buy_status_id")); $gb_price = $currencies->display_price($group_buy['price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } else { $group_buy=''; } } else { // Product not found $meta_description = 'Product requested not available on ModYourCar.com'; $meta_title = 'Product not found'; $h1_title = 'Product not found'; $meta_keywords = ''; $breadcrumb->add('Product not found',''); } ?> <?=$meta_title?> - ModYourCar.com



The product you requested is not currently available in our catalogue.

The product may not be available because:

  • The product never existed.
  • The product is no longer available.
  • The web address was mistyped.

If you are looking for a specific product and are having trouble finding it on our web site please get in contact with us as we can most likely help you.

'; $reviews_query_average = tep_db_query("select (count(r.reviews_id)) as review_count, (avg(reviews_rating)) as average_rating from " . TABLE_REVIEWS . " r," . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . $product_info['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and r.approved='1'"); $reviews_average = tep_db_fetch_array($reviews_query_average); $reveiws_stars = $reviews_average['average_rating']; $num_of_reviews = $reviews_average['review_count']; $reviews_rating = number_format($reveiws_stars,2); if ($num_of_reviews > 0) { $full = ''; $half = ''; if ($reviews_rating <= 0.5) { $t = "½"; $rating_stars = $half; } elseif ($reviews_rating <= 1.0) { $t = "1"; $rating_stars = $full; } elseif ($reviews_rating <= 1.5) { $t = "1½"; $rating_stars = $full.$half; } elseif ($reviews_rating <= 2.0) { $t = "2;"; $rating_stars = $full.$full; } elseif ($reviews_rating <= 2.5) { $t = "2½"; $rating_stars = $full.$full.$half; } elseif ($reviews_rating <= 3.0) { $t = "3"; $rating_stars = $full.$full.$full; } elseif ($reviews_rating <= 3.5) { $t = "3½"; $rating_stars = $full.$full.$full.$half; } elseif ($reviews_rating <= 4.0) { $rating_stars = $full.$full.$full.$full; $t = "4"; } elseif ($reviews_rating <= 4.5) { $t = "4½"; $rating_stars = $full.$full.$full.$full.$half; } else { $t = "5"; $rating_stars = $full.$full.$full.$full.$full; } $display_prices.='
Average Rating: '.$rating_stars.'
'; } if (($product_info['products_weight']==0)&&($product_info['products_type']=='N')) { $free_ship = 'Y'; } // If product is on special if ($special > 0) { if ($product_info['products_price']==0) { $price = '$CALL'; } else { $price = $currencies->display_price($price, tep_get_tax_rate($product_info['products_tax_class_id'])); } $display_prices.=''; if ($product_info['products_price']>$special) { $display_prices.= $price.''; } $display_prices.=''.$currencies->display_price($special, tep_get_tax_rate($product_info['products_tax_class_id'])); $display_prices.=''; $display_prices.='Saving of '.tep_you_save(tep_get_tax_rate($product_info['products_tax_class_id']), 0, $product_info['products_price'], $special,'N').''; $reward_price = $currencies->display_price($special, tep_get_tax_rate($product_info['products_tax_class_id'])); } elseif ($product_info['group_buy']=='Y') { if ($product_info['products_price']==0) { $price = '$CALL'; } else { $price = $currencies->display_price($price, tep_get_tax_rate($product_info['products_tax_class_id'])); } $display_prices.=''; if ($product_info['products_price']>$special) { $display_prices.= $price.''; } $display_prices.=''.$gb_price.''; $display_prices.='Saving of '.tep_you_save(tep_get_tax_rate($product_info['products_tax_class_id']), 0, $product_info['products_price'], $group_buy['price'],'N').''; $reward_price = $gb_price; } else { if ($product_info['products_price']==0) { $price = '$CALL'; } else { $price = $currencies->display_price($price, tep_get_tax_rate($product_info['products_tax_class_id'])); } $display_prices.=''; $display_prices.= $price.''; $reward_price = $price; } $display_prices.=''; $products_name = $product_info['products_name']; echo tep_draw_form('cart_quantity', tep_href_link('product-details', tep_get_all_get_params(array('action')) . 'action=add_product')); ?>
100) || ($height > 100)) $prod_size = ' width=100px height=100px'; $image_margin=''; if ($height<100) { $t = abs($height - 100); $t = number_format($t/2,0); $image_margin = 'style="margin-top:'.$t.'px;"'; } if (tep_not_null($product_info['products_bimage'])) { ?>
<?=$product_info['products_name']?>>
Click to enlarge
<?=$product_info['products_name']?>>
Image is a representation.
Actual part may vary.'; } if ($product_info['products_type']=='N') { for ($s=0 ; $s $z, 'text' => $z); } } ?>
0) { echo 'Product Options
'; $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . $_GET['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . $languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . $_GET['products_id'] . "' and pa.options_id = '" . $products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "' order by pa.order asc, pov.products_options_values_name"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (isset($cart->contents[$_GET['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$_GET['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } echo $products_options_name['products_options_name'] . ': '; // Products with long attribute names need to have fixed width so it doesnt screw up page if ($_GET['products_id'] == '485') { // Apexi Power FC echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute,'style="width:170px;"').'
'; } else { echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute).'
'; } } echo "
"; } // Specials, free shipping and group buy icons $icons_text=''; if ($free_ship=='Y') { $icons = 'Y'; $icons_text .= 'FREE Shipping'; } if ($icons == 'Y') $icons_text .= "
"; if ($special>0) { $icons_text .= 'On Special'; $icons = 'Y'; } elseif ($product_info['group_buy']=='Y') { $icons_text .= 'Group Buy'; $icons = 'Y'; } if ($icons == 'Y') { echo $icons_text; } //echo tep_draw_separator('pixel_trans.gif', '100%', '5').'
'.$display_prices; echo " 
".$display_prices; ?>
Enquire'; } elseif ($product_info['products_type']=='E') { echo ''; } $seo = safe_for_seo($product_info['products_name']); echo ''; echo ''; if (($product_info['products_type']=='N')||($product_info['products_type']=='G')) { ?>
EnquireTell A FriendPrice Match
This product qualifies for FREE SHIPPING... click here for details'; } elseif ($product_info['products_type']!='G') { echo '
Shipping calculator available in shopping cart
'; } } } elseif (($product_info['group_buy']=='Y')&&($group_buy['group_buy_status_id']==2)) { // Processing group buy echo '
This group buy is now CLOSED and we are processing
'; } elseif (($product_info['group_buy']=='Y')&&($group_buy['group_buy_status_id']==3)) { // Group buy complete echo '
This group buy is complete - thanks to those that participated
'; } ?>
Call NOW to speak to us or to order over the phone
 1800 MODYOURCAR
or  1800 663 968