Please enter your motorcycle information below, it will be approved and posted to the site within few hours. |
Unable to connect to the database server at this time.
" ); } else { // Select the jokes database if (! @mysql_select_db("bikerpla_dwh") ) { echo( "Unable to locate the dwh database at this time.
" ); } else { if($submit==1) { if ($_POST["year"]!="zzzz" && $_POST["make"]!="zzzz" && $_POST["model"] && $_POST["cylinders"]!="zzzz" && num_cleanup($_POST["cc"]) && $_POST["miles"] != "" && num_cleanup($_POST["price"]) && $_POST["color"]!="zzzz" && $_POST["description"] && $_POST["type"]!="zzzz" && $_POST["city"] && $_POST["state"]!="zzzz" && $_POST["email"] && $_POST["owner"]!="zzzz" && $_FILES['imagefile1']["type"]) { $result = mysql_query("SELECT IFNULL(MAX(CLS_ID), 0) CCOUNT FROM CLS_LIVE_PRE"); $row = mysql_fetch_array($result); $ccount = $row["CCOUNT"]; $result = mysql_query("SELECT IFNULL(MAX(CLS_ID), 0) SEQ FROM CLS_LIVE"); $row = mysql_fetch_array($result); $seq = $row["SEQ"]; if($ccount>$seq) { $v_cls_id = $ccount + 1; } else { $v_cls_id = $seq + 1; } $mime = $_FILES['imagefile1']["type"]; if($mime=="image/jpeg" || $mime=="image/pjpeg") { clearstatcache; $image_name = "image/cls/" . $v_cls_id . "_1.jpg"; $image_name1 = $v_cls_id . "_1.jpg"; move_uploaded_file($_FILES['imagefile1']['tmp_name'], $image_name); clearstatcache; } $mime = $_FILES['imagefile2']["type"]; if($mime=="image/jpeg" || $mime=="image/pjpeg") { clearstatcache; $image_name = "image/cls/" . $v_cls_id . "_2.jpg"; $image_name2 = $v_cls_id . "_2.jpg"; move_uploaded_file($_FILES['imagefile2']['tmp_name'], $image_name); clearstatcache; } $mime = $_FILES['imagefile3']["type"]; if($mime=="image/jpeg" || $mime=="image/pjpeg") { clearstatcache; $image_name = "image/cls/" . $v_cls_id . "_3.jpg"; $image_name3 = $v_cls_id . "_3.jpg"; move_uploaded_file($_FILES['imagefile3']['tmp_name'], $image_name); clearstatcache; } $mime = $_FILES['imagefile4']["type"]; if($mime=="image/jpeg" || $mime=="image/pjpeg") { clearstatcache; $image_name = "image/cls/" . $v_cls_id . "_4.jpg"; $image_name4 = $v_cls_id . "_4.jpg"; move_uploaded_file($_FILES['imagefile4']['tmp_name'], $image_name); clearstatcache; } $mime = $_FILES['imagefile5']["type"]; if($mime=="image/jpeg" || $mime=="image/pjpeg") { clearstatcache; $image_name = "image/cls/" . $v_cls_id . "_5.jpg"; $image_name5 = $v_cls_id . "_5.jpg"; move_uploaded_file($_FILES['imagefile5']['tmp_name'], $image_name); clearstatcache; } $insert = mysql_query("INSERT INTO CLS_LIVE_PRE(CLS_ID, CLS_OWNER_ID, CLS_REGION_ID, CLS_MAKE_ID, CLS_COLOR_ID, CLS_MOTORCYCLE_TYPE_ID, YEAR_MADE, MODEL, CYLINDERS, CC, MILES, PRICE, DESCRIPTION, STATE_ABBR, CITY, ZIP, OWNER_NAME, PHONE, EMAIL, LISTING_PERIOD, IMG_1, IMG_2, IMG_3, IMG_4, IMG_5, IP) VALUES('" . $v_cls_id . "', '" . $_POST["owner"] . "', '" . $v_cls_region_id . "', '" . $_POST["make"] . "', '" . $_POST["color"] . "', '" . $_POST["type"] . "', '" . $_POST["year"] . "', '" . urlencode(ucwords(strtolower($_POST["model"]))) . "', '" . $_POST["cylinders"] . "', '" . num_cleanup($_POST["cc"]) . "', '" . num_cleanup($_POST["miles"]) . "', '" . num_cleanup($_POST["price"]) . "', '" . urlencode(str_replace("'", "''", str_replace("''", "~~~" , $_POST["description"]))) . "', '" . $_POST["state"] . "', '" . urlencode(ucwords(strtolower($_POST["city"]))) . "', '" . $_POST["zip"] . "', '" . urlencode(ucwords(strtolower($_POST["name"]))) . "', '" . urlencode($_POST["phone"]) . "', '" . urlencode($_POST["email"]) . "', '" . $_POST["listing_period"] . "', '" . $image_name1 . "', '" . $image_name2 . "', '" . $image_name3 . "', '" . $image_name4 . "', '" . $image_name5 . "', '" . $REMOTE_ADDR . "')"); //echo($insert); } else { $v_refill = 1; } } $cls_make_list = mysql_query("SELECT A.CLS_MAKE_ID, A.MAKE FROM CLS_MAKE A ORDER BY A.MAKE ASC"); $cls_color_list = mysql_query("SELECT A.CLS_COLOR_ID, A.COLOR FROM CLS_COLOR A ORDER BY A.COLOR ASC"); $cls_type_list = mysql_query("SELECT A.CLS_MOTORCYCLE_TYPE_ID, A.TYPE FROM CLS_MOTORCYCLE_TYPE A ORDER BY A.TYPE ASC"); $cls_owner_list = mysql_query("SELECT A.CLS_OWNER_ID, A.OWNER FROM CLS_OWNER A ORDER BY A.OWNER ASC"); } } mysql_close($dbcnx); ?>Your submission failed, please check the following:
1. Make sure that all the fields in Red are populated correctly.
2. Make sure that there are no HTML tags in the description.
3. Make sure that the format of the fileds is correct
"); echo(mysql_error()); } else { if ($submit==1) { echo("
Thank you for listing you motorcycle
You will get a confirmation email within a few hours
"); echo(""); } } ?>
Please enter your motorcycle information below, it will be approved and posted to the site within few hours. |