'); } ?> " . $meta_title . ""); echo (""); ?>

BikerPlaza.com - Motorcycle Event and Classifieds Directory
= '" . $jump_month . "-01'"; } else { $date_from = "DATE_TO >= DATE_SUB('" . $curdate . "',INTERVAL 3 DAY)"; } if($avail=="sold") { $v_table_name = "CLS_LIVE_SOLD"; } ELSE { $v_table_name = "CLS_LIVE"; } $v_filter_where = filter_where(); $classified = mysql_query("SELECT A.*, DATE_FORMAT(A.PUBLISH_TSP, '%d-%b-%Y') F_PUBLISH_TSP, B.TYPE, C.REGION, D.OWNER, E.MAKE, F.COLOR, G.STATE_NAME FROM " . $v_table_name . " A, CLS_MOTORCYCLE_TYPE B, CLS_REGION C, CLS_OWNER D, CLS_MAKE E, CLS_COLOR F, state G WHERE A.CLS_MOTORCYCLE_TYPE_ID = B.CLS_MOTORCYCLE_TYPE_ID AND A.CLS_REGION_ID = C.CLS_REGION_ID AND A.CLS_OWNER_ID = D.CLS_OWNER_ID AND A.CLS_MAKE_ID = E.CLS_MAKE_ID AND A.CLS_COLOR_ID = F.CLS_COLOR_ID AND A.STATE_ABBR = G.STATE_PREFIX " . $v_filter_where . " AND TO_DAYS('" . $curdate . "') - TO_DAYS(A.PUBLISH_TSP) <= A.LISTING_PERIOD ORDER BY A.PUBLISH_TSP DESC LIMIT " . $limit_from . ", " . $limit); $cls_motorcycle_type_list = mysql_query("SELECT DISTINCT B.CLS_MOTORCYCLE_TYPE_ID, B.TYPE FROM CLS_MOTORCYCLE_TYPE B, " . $v_table_name . " A WHERE B.CLS_MOTORCYCLE_TYPE_ID = A.CLS_MOTORCYCLE_TYPE_ID AND TO_DAYS('" . $curdate . "') - TO_DAYS(A.PUBLISH_TSP) <= A.LISTING_PERIOD " . filter_where('type') . " ORDER BY B.TYPE ASC"); $cls_make_list = mysql_query("SELECT DISTINCT B.CLS_MAKE_ID, B.MAKE FROM CLS_MAKE B, " . $v_table_name . " A WHERE B.CLS_MAKE_ID = A.CLS_MAKE_ID AND TO_DAYS('" . $curdate . "') - TO_DAYS(A.PUBLISH_TSP) <= A.LISTING_PERIOD " . filter_where('make') . " ORDER BY B.MAKE ASC"); $state_list = mysql_query("SELECT DISTINCT B.STATE_PREFIX, B.STATE_NAME FROM state B, " . $v_table_name . " A WHERE B.STATE_PREFIX NOT IN ('AK', 'HI', 'FM', 'VI', 'PR', 'MP', 'AS', 'MH', 'GU', 'PW') AND B.STATE_PREFIX = A.STATE_ABBR AND TO_DAYS('" . $curdate . "') - TO_DAYS(A.PUBLISH_TSP) <= A.LISTING_PERIOD " . filter_where('state') . " ORDER BY B.STATE_PREFIX ASC"); $cls_region_list = mysql_query("SELECT DISTINCT B.CLS_REGION_ID, B.REGION FROM CLS_REGION B, " . $v_table_name . " A WHERE B.CLS_REGION_ID = A.CLS_REGION_ID AND TO_DAYS('" . $curdate . "') - TO_DAYS(A.PUBLISH_TSP) <= A.LISTING_PERIOD " . filter_where('region') . " ORDER BY B.REGION ASC"); $cls_owner_list = mysql_query("SELECT DISTINCT B.CLS_OWNER_ID, B.OWNER FROM CLS_OWNER B, " . $v_table_name . " A WHERE B.CLS_OWNER_ID = A.CLS_OWNER_ID AND TO_DAYS('" . $curdate . "') - TO_DAYS(A.PUBLISH_TSP) <= A.LISTING_PERIOD " . filter_where('owner') . " ORDER BY B.OWNER ASC"); $cls_color_list = mysql_query("SELECT DISTINCT B.CLS_COLOR_ID, B.COLOR FROM CLS_COLOR B, " . $v_table_name . " A WHERE B.CLS_COLOR_ID = A.CLS_COLOR_ID AND TO_DAYS('" . $curdate . "') - TO_DAYS(A.PUBLISH_TSP) <= A.LISTING_PERIOD " . filter_where('color') . " ORDER BY B.COLOR ASC"); $year_list = mysql_query("SELECT DISTINCT A.YEAR_MADE FROM " . $v_table_name . " A WHERE TO_DAYS('" . $curdate . "') - TO_DAYS(A.PUBLISH_TSP) <= A.LISTING_PERIOD " . filter_where('year') . " ORDER BY A.YEAR_MADE ASC"); $rowcount = mysql_num_rows($classified); mysql_close($dbcnx); ?> "); $v_counter = $v_counter + 1; } if($rowcount < 7) { echo(""); } echo("


Filters (select any combination of any criterias to narrow your results)
'); ?>
List Your Motorcycle For Sale     Buy & Sell Motorcycle Parts & Accessories
"); $info_page = ''; echo(''); echo("" . $row["CITY"] . ", " . $row["STATE_ABBR"] . "     "); echo("Asking Price: $". number_format($row["PRICE"]) . "     "); echo("Listed on: " . $row["F_PUBLISH_TSP"] . "

"); if ($row["IMG_1"]) { list($image_width, $image_height, $type, $attr) = getimagesize('image/cls/thumb/' . $row["IMG_1"]); if($image_width>200) { $image_width = 200; $image_height = ''; } echo($info_page . " " . special_cleanup($row["YEAR_MADE"] . " - " . $row["MAKE"] . " - " . $row["MODEL"]) . " "); } $v_description = "Motorcycle for sale by " . $row["OWNER"] . ", a " . $row["YEAR_MADE"] . " " . $row["MAKE"] . " - " . $row["MODEL"] . ", " . $row["CYLINDERS"] . " Cylinders, " . number_format($row["CC"]) . "cc engine with " . number_format($row["MILES"]) . " miles, located in " . $row["CITY"] . " " . ucwords(strtolower($row["STATE_NAME"])) . ".

" . special_cleanup($row["DESCRIPTION"]); $desc_len = strlen($v_description); $cutoff = 350; if ($desc_len > $cutoff) { echo(substr($v_description, 0, $cutoff) . '...... ' . $info_page . 'For More Information Click Here

'); } else { echo($v_description . '

'); } if ($v_table_name=="CLS_LIVE") { if($row["OWNER_NAME"]) {echo($row["OWNER_NAME"] . "     ");} if($row["PHONE"]) {echo($row["PHONE"] . "     ");} if($row["EMAIL"]) { echo("Send Email     "); } $map_click_out = "maps.google.com/maps?f=q&hl=en&geocode=&q=" . $row["CITY"] . ", " . $row["STATE_ABBR"] . "&ie=UTF8&z=10&iwloc=addr&om=1"; $map_click_out_log = ""; echo($map_click_out_log); echo('Map/Direction'); } else { echo("SOLD"); } echo("
"); //echo("rc = " . $rowcount . "
lf = " . $limit_from . "
lt = " . $limit_to . "
lm = " . $limit . "
" . $jump_month); if($rowcount == $limit && $limit_from == 0) { $page = $page + 1; echo("
Previous | Next
"); echo("
"); } elseif($rowcount == $limit && $limit_from > 1) { $page_p = $page - 1; $page_n = $page + 1; echo("
Previous | Next
"); echo("
"); } elseif($rowcount < $limit && $limit_from > 1) { $page = $page - 1; echo("
Previous | Next
"); echo("
"); } ?>