configread("config.ini");
// set default levels for the store
if (wheel_id == "") {
wheel_id = 998;
}
if (p_returnpage == "")
stateset("p_returnpage", "skin-wheels.html?size_id=" & size_id);
search( DB_DIR,
"*",
"ST_MMODEL",
"ID=:wheel_id","","")
{
category_name = ST_MMODEL.CATNAME;
l_defsize=ST_MMODEL.DIAMETER;
parentid = ST_MMODEL.GID; // for back button
l_catimage = "";
}
if ((category_name=="FORD") || (category_name=="CHEVY") || (category_name=="DODGE") ||
(category_name=="HONDA") || (category_name=="TOYOTA") || (category_name=="NISSAN") ||
(category_name=="MAZDA") || (category_name=="CHRYSLER") || (category_name=="NISSAN") ||
(category_name=="GMC"))
category_name = category_name & " CAR N' TRUCK";
l_cat =tolower (category_name);
p_title= category_name & " ";
printtag("HEADER"); //fix title
printtag("BODY");
if (wheel_id < 997) {
search( DB_DIR,
"*",
"ST_MMODEL",
"GID=:wheel_id", "", "MAKE,MODEL,YEAR DESC")
{
if (SQLCOUNT == 1)
printtagarea("CATEGORY_LEVEL1", "", "table", "begin,1");
l_mfg = ST_MMODEL.MFG;
l_make = ST_MMODEL.MAKE;
l_model = ST_MMODEL.MODEL;
l_year = ST_MMODEL.YEAR;
if (l_model =="") l_model="-";
if (l_year =="") l_year="-";
printtagarea("CATEGORY_LEVEL1", "", "table", "2");
}
if (SQLCODE!=0) printtag("SQL_ERROR",ERR_FILE);
else
printtagarea("CATEGORY_LEVEL1", "", "table", "end");
} //if wheel_id < 1000
// now print out any products in the main category only for categories with listings
//if (wheel_id>1000){
else {
if (size_id=="")
l_search="GID=:wheel_id";
else
l_search="GID=:wheel_id and SIZE=:size_id";
// search( DB_DIR,"*","ST_MMODEL","ID=:wheel_id","",""){
// category_name = ST_MMODEL.CATNAME;
// parentid = ST_MMODEL.GID; // for back button
// l_catimage = "
";
// }
search( DB_DIR,"*","ST_PRODUCTS",l_search, "", "SIZE,YEAR DESC,")
{
if (SQLCOUNT == 1) {
printtagarea("WHEEL_TABLE", "", "table", "begin,1");
curgid=ST_PRODUCTS.GID;
}
l_pid= ST_PRODUCTS.ID;
l_name= ST_PRODUCTS.NAME;
l_partnum= ST_PRODUCTS.PARTNUM;
l_dprice = format("%.2f",ST_PRODUCTS.LISTPRICE * 1.20);
//l_dprice= ST_PRODUCTS.LISTPRICE;
if (l_dprice =="0") l_dprice="N/A";
l_price= ST_PRODUCTS.NETPRICE;
if (l_price =="0") l_price="Call";
l_color= ST_PRODUCTS.COLOR;
l_year= ST_PRODUCTS.YEAR;
l_make= ST_PRODUCTS.MAKE;
l_model= ST_PRODUCTS.MODEL;
if ((ST_PRODUCTS.SIZE != "") && (ST_PRODUCTS.SIZE != "0")){
l_size = ST_PRODUCTS.SIZE;
if (ST_PRODUCTS.SIZE < 30) l_size = l_size & "\"";
}
if ((ST_PRODUCTS.WIDTH != "") && (ST_PRODUCTS.WIDTH != "0")) {
l_size = l_size & " x " & ST_PRODUCTS.WIDTH;
if (ST_PRODUCTS.WIDTH < 30) l_size = l_size & "\"";
}
if (ST_PRODUCTS.TYPE == "TYC")
l_size="N/A";
if (mod(SQLCOUNT,2) == 1) {
l_image ="
";
printtagarea("WHEEL_TABLE", "", "table", "2");
}
else {
l_image ="
";
printtagarea("WHEEL_TABLE", "", "table", "3");
}
} //search( DB_DIR,
if (SQLCOUNT > 0)
printtagarea("WHEEL_TABLE", "", "table", "end");
l_sql=SQLCOUNT;
//DISPLAY GENERIC PRODUCTS - WCOVERS, TRIMS, SKINS
//print(l_search & "
");
//print("Size:" & l_defsize & "
");
//print("Cur GID:" & curgid & "
");
//print("
";
// printtagarea("WHEEL_TABLE", "", "table", "2");
// }
// else {
// l_image ="
";
// printtagarea("WHEEL_TABLE", "", "table", "3");
// }
// } //search( DB_DIR,
//
//
// if (SQLCOUNT > 0)
// printtagarea("WHEEL_TABLE", "", "table", "end");
}//if (wheel_id>100)
if (wheel_id != 0) printtag("BACK");
printtag("SITE_FOOTER", "home.html");
Email This Website To a Friend© 2002 Copyright: All database of auto wheels and rims belong to Auto Alloy Wheels N' Auto Chrome Rims & Custom Hubcaps. Terms & Conditions |