require('includes/application_top.php');
if (($_GET['redir'] == 'y')&&($_GET['products_id'])) {
$product_info_query = tep_db_query("select pd.products_name from products_description pd where pd.products_id = '" . $_GET['products_id'] . "' and pd.language_id = '1';");
$product_info = tep_db_fetch_array($product_info_query);
$seo = safe_for_seo($product_info['products_name']);
$url = $seo."-p".$_GET['products_id'];
tep_redirect(tep_href_link($url, '', 'NONSSL'),'Y');
}
$_GET['keywords'] = mysql_real_escape_string(strip_tags($_GET['keywords']));
if ((isset($_GET['keywords'])) and ($_GET['hl'])) {
$display_search_results = true;
} else {
$display_search_results = false;
}
$navigation->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
require("includes/header.php"); ?>
require("includes/column_left.php"); ?>
=$h1_title?>
=$breadcrumb->trail(' » ')?>
if ($product_check['total'] < 1) {
?>
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.
} else {
if (($customer_admin!='Y')&&($spider_flag == false)) { // Do not increment if admin
tep_db_query("update products_description set products_viewed = products_viewed+1, products_viewed_week = products_viewed_week+1 where products_id = '" . $_GET['products_id'] . "' and language_id = '" . $languages_id . "'");
}
// RRP code added by Dan Rucci
$display_prices='';
$rrp=0;
$price=0;
$special=0;
$rrp=$product_info['products_rrp'];
$price=$product_info['products_price'];
$special=tep_get_products_special_price($product_info['products_id']);
$extra_chars1='';
$extra_chars2='';
$display_prices .= '
';
$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'));
?>
// Product image
$prod_image = $http_prot.'://www.modyourcar.com.au/images/'.$product_info['products_image'];
list($width, $height, $type, $attr) = getimagesize($prod_image);
$prod_size = '';
if (($width > 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'])) {
?>
>
Click to enlarge
} else {
?>
>
}
//Do not display if product is a number plate
if (($product_info['products_type']!='Y')&&($product_info['products_type']!='G')) {
echo 'Image is a representation. Actual part may vary.
';
}
if ($product_info['products_type']=='N') {
for ($s=0 ; $s $z,
'text' => $z);
}
}
?>
$products_attributes_query = tep_db_query("select count(*) as total 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 . "'");
$products_attributes = tep_db_fetch_array($products_attributes_query);
if ($products_attributes['total'] > 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 .= ' ';
}
if ($icons == 'Y') $icons_text .= " ";
if ($special>0) {
$icons_text .= ' ';
$icons = 'Y';
} elseif ($product_info['group_buy']=='Y') {
$icons_text .= ' ';
$icons = 'Y';
}
if ($icons == 'Y') {
echo $icons_text;
}
//echo tep_draw_separator('pixel_trans.gif', '100%', '5').' '.$display_prices;
echo " ".$display_prices;
?>
if ($product_info['products_type']!='Y') {
if ($free_ship=='Y') {
//echo '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 MODYOURCARor
1800 663 968