\n"; $rs = recordset_execute("SELECT * FROM catalog_make order by make"); $counter0 = 1; while (recordset_grab($rs,$counter0,"id") != " "){ $local_categories_id = recordset_grab($rs,$counter0,"id"); $local_categories_name = recordset_grab($rs,$counter0,"make"); if ( $local_categories_id == $selected ) { //OPEN // bgcolor=\"$coreCatBgOpen\ $return_val .="$local_categories_name \n"; } else { //level 3 product detail CLOSED $return_val .="$local_categories_name
"; } $counter0++; } $return_val .= ""; return $return_val; } //############################################################ // build_main_cat() //############################################################ function build_main_cat() { $return_val = ""; $rs = recordset_execute("SELECT * FROM categories, categories_description where categories.parent_id = 0 and categories.categories_id = categories_description.categories_id order by categories_name"); $counter0 = 1; while (recordset_grab($rs,$counter0,"categories_id") != " "){ $local_categories_id = recordset_grab($rs,$counter0,"categories_id"); $local_categories_name = recordset_grab($rs,$counter0,"categories_name"); $local_categories_image = recordset_grab($rs,$counter0,"categories_image"); $return_val .=""; if ($counter0 % 4 == 0) { $return_val .="\n\n"; } $counter0++; } $counter0 --; if ($counter0 % 4 != 0) { $return_val .="\n";} $return_val .= "
$local_categories_name
\"View
\n 
"; return $return_val; } //############################################################ // build_sidebar_level_1($selected ,$c, $l) //############################################################ function build_sidebar_level_1($selected, $c, $l) { $return_val = "\n"; $rs = recordset_execute("SELECT * FROM phpcatalog_categories where parent_id = $selected order by category_name"); $counter0 = 1; while (recordset_grab($rs,$counter0,"category_id") != " "){ $local_category_id = recordset_grab($rs,$counter0,"category_id"); $local_parent_id = recordset_grab($rs,$counter0,"parent_id"); $local_category_name= recordset_grab($rs,$counter0,"category_name"); //$pn_link = get_1st_pn($selected); $return_val .=""; if ($counter0 % 3 == 0) { $return_val .="\n\n"; } $counter0++; } $counter0 --; if ($counter0 % 3 != 0) { $return_val .="\n";} $return_val .= "
$local_category_name
\"View
\n 
"; return $return_val; } //############################################################ // build_sidebar_level_2 //############################################################ function build_sidebar_level_2($parent_id, $selected, $c, $l) { $subCatBgOpen = "#daddeb"; $subCatBgClosed = "#f2f3f9"; $font2 ="level2"; $return_val = "\n"; $rs = recordset_execute("SELECT * FROM phpcatalog_categories where parent_id = $parent_id order by category_name"); $counter0 = 1; while (recordset_grab($rs,$counter0,"category_id") != " "){ $local_category_id = recordset_grab($rs,$counter0,"category_id"); $local_parent_id = recordset_grab($rs,$counter0,"parent_id"); $local_category_name= recordset_grab($rs,$counter0,"category_name"); if ( $local_category_id == $selected ) { //OPEN $return_val .= " "; } else { //CLOSED $return_val .="";} if ($counter0 % 3 == 0) { $return_val .="\n\n";} $counter0++; } $counter0 --; if ($counter0 % 3 != 0) { $return_val .="\n";} $return_val .= "
$local_category_name$local_category_name
\n 
"; return $return_val; } //############################################################ // build_sidebar_level_3($selected ,$c, $l) //############################################################ function build_sidebar_level_3($parent_id, $selected, $c, $cc, $l) { $return_val = "\n"; $rs = recordset_execute("SELECT * FROM phpc_catalog WHERE category_id = $selected order by product_name"); $counter0 = 1; while (recordset_grab($rs,$counter0,"product_id") != " ") { $local_product_name = recordset_grab($rs,$counter0,"product_name"); $local_product_id = recordset_grab($rs,$counter0,"product_id"); //$pn_link = get_1st_pn($selected); $return_val .=""; if ($counter0 % 3 == 0) { $return_val .="\n\n"; } $counter0++; } $counter0 --; if ($counter0 % 3 != 0) { $return_val .="\n";} $return_val .= "
$local_product_name
\"View
\n 
"; return $return_val; } // product bar menu. //############################################################## function build_sidebarp($selected , $cat_id, $id, $catalog_id, $parent_id, $c, $cc) { //Change these colours at your will for design. $subCatBgRegular = "#DBE2F0"; $subCatBgRoll = "#ffffff"; $subCatBgSelected = "#FFFFFF"; $return_val = "\n"; $rs = recordset_execute("SELECT * FROM phpc_catalog WHERE category_id = $selected order by product_name"); $counter=1; while (recordset_grab($rs,$counter,"product_id") != " ") { $local_product_name = recordset_grab($rs,$counter,"product_name"); $local_product_id = recordset_grab($rs,$counter,"product_id"); if ( $local_product_id == $id ) { //level 3 product detail OPEN $return_val .="\n"; } else { //level 3 product detail CLOSED $return_val .="\n"; } $counter++; } $return_val .= "
$local_product_name
$local_product_name
"; return $return_val; } // build product //############################################################## function build_product($output_main_template, $parent_id, $sel_category, $id){ $rs = recordset_execute("SELECT * FROM phpc_catalog where product_id = $id"); $local_product_id = recordset_grab($rs,1,"product_id"); $local_category_id = $sel_category; $local_product_name = recordset_grab($rs,1,"product_name"); $local_product_desc = recordset_grab($rs,1,"product_desc"); $local_product_price = sprintf("%.2f",1.1 * recordset_grab($rs,1,"product_price")); if ($local_product_price == '0.00'){ $local_product_price = '
enquire for price
'; $output_main_template = replaceArray("{button}",'',$output_main_template); } // product code $local_product_sku = recordset_grab($rs,1,"product_sku"); // link to other sites/pages of interest/related $local_product_use_tag = recordset_grab($rs,1,"product_use_tag"); $output_main_template = replaceArray("{product_id}",$local_product_id,$output_main_template); $output_main_template = replaceArray("{parent_id}",$parent_id,$output_main_template); $output_main_template = replaceArray("{product_name}",$local_product_name,$output_main_template); $output_main_template = replaceArray("{product_desc}",$local_product_desc,$output_main_template); $output_main_template = replaceArray("{product_price}",$local_product_price,$output_main_template); $output_main_template = replaceArray("{product_sku}",$local_product_sku,$output_main_template); $output_main_template = replaceArray("{product_use_tag}",$local_product_use_tag,$output_main_template); $output_main_template = replaceArray("{cat_id}",$local_category_id,$output_main_template); if ($parent_id == '27' || $local_category_id == '185' || $local_category_id == '186' || $local_category_id == '191' || $local_category_id == '189' || $local_category_id == '188' || $local_category_id == '123' || $parent_id == '25' ) { $output_main_template = replaceArray("{button}",'',$output_main_template); $output_main_template = replaceArray("{message}",'*Please note: These items are unable to be ordered over the internet due to freight issues at this time. We apologise for any inconvenience this may cause. Please feel free to contact us directly to see if any other options are available.',$output_main_template);} elseif ($parent_id == '30' ) { $output_main_template = replaceArray("{button}",'',$output_main_template); $output_main_template = replaceArray("{message}",'*Please note:
Please fill in shipping details for the person that will receive the voucher at checkout.',$output_main_template);} else{$output_main_template = replaceArray("{button}",'',$output_main_template); $output_main_template = replaceArray("{message}",'',$output_main_template);} return $output_main_template; } // product search //############################################################## function build_sidebar_search($query){ $rs = recordset_execute("SELECT * from phpc_catalog where product_name like '%$query%' or product_name like '%$query% ' or product_sku like '%$query%'ORDER BY category_id ASC limit 200"); $return_val = "\n"; //$rs = recordset_execute("SELECT * FROM phpc_catalog WHERE category_id = $selected order by product_name"); $counter=1; while (recordset_grab($rs,$counter,"product_id") != " ") { $local_product_name = recordset_grab($rs,$counter,"product_name"); $local_product_id = recordset_grab($rs,$counter,"product_id"); $local_category_id = recordset_grab($rs,$counter,"category_id"); $parent_id = get_parent_id($local_category_id); $c = get_parent_name($parent_id); $cc = get_parent_name($local_category_id); $return_val .="\n"; $counter++; } $return_val .= "
$counter.$c >> $cc >> $local_product_name
"; return $return_val ; return $c; } function get_orders($customer_number, $order_id){ $rs = recordset_execute("SELECT * from orders where customer_number = '$customer_number' ORDER BY timestamp desc "); $return_val = "\n"; $counter=1; while (recordset_grab($rs,$counter,"order_id") != " ") { $local_order_id = recordset_grab($rs,$counter,"order_id"); $order = recordset_grab($rs,$counter,"order"); $local_timestamp = recordset_grab($rs,$counter,"timestamp"); $my_time = mktime('$local_timestamp'); $my_formatted_time = getdate($my_time); //$order_date = "$my_formatted_time[weekday], // $my_formatted_time[month] $my_formatted_time[mday], //$my_formatted_time[year] $my_formatted_time[hour]:$my_formatted_time[minutes]"; //$order_date = date("d/m/Y; H:i", $local_timestamp); $ert = ereg("^([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$local_timestamp,$res); $year=$res[1]; $month=$res[2]; $day=$res[3]; $hour=$res[4]; $min=$res[5]; $sec=$res[6]; $order_date = $day.'/'.$month.'/'.$year.' '.$hour.':'.$min; //$order_date = mktime("d/m/Y; H:i",'$local_timestamp'); if ( $local_order_id == $order_id ) { $return_val .="\n";}else{ $return_val .="\n";} $counter++; } $return_val .= "
$order_date
$order_date
"; return $return_val ; } $session_id = session_id(); $melbdate = date("d/m/Y; H:i",time() ); function fexists($check_file) { $check_file = trim($check_file); clearstatcache(); // flush out any cache values. if (file_exists($check_file)) {return 1;} else {return 0;} }; function fsize($check_file) { $check_file = trim($check_file); clearstatcache(); // flush out any cache values. return filesize($check_file); }; function inArray($needle,$haystack) { for ($i=0;$iMy Account Details | Orders | Logout | CheckoutShopping";}else{ //$log="Log in"; } $total = sprintf("%.2f",$total); $return_val = " $log
Items:$loop_productquantity  Total:$ $total  View Cart
"; return $return_val; } ?>= $row_num) { mysql_data_seek($db_result,$row_num-1); $local_row = mysql_fetch_array($db_result); if (trim($local_row[$field_name]) == "") { return " "; } else { return trim($local_row[$field_name]); } } else { return " "; } }; function recordset_grab_row($db_result,$row_num) { if (mysql_num_rows($db_result) >= $row_num) { mysql_data_seek($db_result,$row_num-1); $local_row = mysql_fetch_array($db_result); return $local_row; } else { return " "; } }; function count_rows($rs) { if ($rs <> "") { $rowcount = mysql_num_rows($rs); } if ($rowcount > 0) { return $rowcount; } else { return 0; } }; ?> FATAL ERROR: register_globals is disabled in php.ini, please enable it!