check($_POST['captcha_code']) == false) { // the code was incorrect // handle the error accordingly with your other error checking $errors++; $err['captcha']=1; } } include("tools/functions.php"); if ((isset($_GET['id']))&&(strcasecmp($GLOBALS['ckMetImp'],"metric")!=0)) { setcookie("metimp","metric",time()+60*60*24*365); header("location:http://".$_SERVER['HTTP_HOST'].rtrim(dirname($_SERVER['PHP_SELF']), '/\\')."/modify.php?" . htmlentities($_SERVER['QUERY_STRING'])."&msg=Cannot%20modify%20specifications%20when%20measuring%20units%20are%20set%20to%20imperial,
automatically%20switched%20measuring%20units%20to%20metric."); } require_once("tools/functions.sql.php"); mysqli_select_db($db_name, $database); $query_bkb_brand = "SELECT DISTINCT bkb_specs_cars.brand FROM bkb_specs_cars ORDER BY bkb_specs_cars.brand"; $bkb_brand = mysqli_query($database, $query_bkb_brand) or die(mysqli_error()); $row_bkb_brand = mysqli_fetch_assoc($bkb_brand); $totalRows_bkb_brand = mysqli_num_rows($bkb_brand);mysqli_select_db($db_name, $database); mysqli_select_db($db_name, $database); $query_bkb_transmission = "SELECT bkb_specs_transmission.tcode, bkb_specs_transmission.tname FROM bkb_specs_transmission ORDER BY bkb_specs_transmission.tname"; $bkb_transmission = mysqli_query($database, $query_bkb_transmission) or die(mysqli_error()); $row_bkb_transmission = mysqli_fetch_assoc($bkb_transmission); $totalRows_bkb_transmission = mysqli_num_rows($bkb_transmission); mysqli_select_db($db_name, $database); $query_bkb_enumber = "SELECT DISTINCT bkb_specs_cars.enumber, bkb_specs_cars.series FROM bkb_specs_cars ORDER BY bkb_specs_cars.series"; $bkb_enumber = mysqli_query($database, $query_bkb_enumber) or die(mysqli_error()); $row_bkb_enumber = mysqli_fetch_assoc($bkb_enumber); $totalRows_bkb_enumber = mysqli_num_rows($bkb_enumber); mysqli_select_db($db_name, $database); $query_bkb_engine_bmw = "SELECT bkb_specs_engines.eid, bkb_specs_engines.mtype, bkb_specs_engines.fuel, bkb_specs_engines.cylinders, bkb_specs_engines.valves, bkb_specs_engines.arrangement, bkb_specs_engines.`displacement`, bkb_specs_engines.power, bkb_specs_engines.torque, bkb_specs_engines.mcode FROM bkb_specs_engines WHERE bkb_specs_engines.mtype LIKE 'M__' OR bkb_specs_engines.mtype LIKE 'N__' ORDER BY bkb_specs_engines.fuel, bkb_specs_engines.cylinders, bkb_specs_engines.valves, bkb_specs_engines.mtype, bkb_specs_engines.mcode"; $bkb_engine_bmw = mysqli_query($database, $query_bkb_engine_bmw) or die(mysqli_error()); $row_bkb_engine_bmw = mysqli_fetch_assoc($bkb_engine_bmw); $totalRows_bkb_engine_bmw = mysqli_num_rows($bkb_engine_bmw); mysqli_select_db($db_name, $database); $query_bkb_body = "SELECT DISTINCT bkb_specs_cars.body FROM bkb_specs_cars ORDER BY bkb_specs_cars.body"; $bkb_body = mysqli_query($database, $query_bkb_body) or die(mysqli_error()); $row_bkb_body = mysqli_fetch_assoc($bkb_body); $totalRows_bkb_body = mysqli_num_rows($bkb_body); mysqli_select_db($db_name, $database); $query_bkb_engine_other = "SELECT bkb_specs_engines.eid, bkb_specs_engines.mtype, bkb_specs_engines.fuel, bkb_specs_engines.cylinders, bkb_specs_engines.valves, bkb_specs_engines.arrangement, bkb_specs_engines.`displacement`, bkb_specs_engines.power, bkb_specs_engines.torque, bkb_specs_engines.mcode FROM bkb_specs_engines WHERE bkb_specs_engines.mtype NOT LIKE 'M__' AND bkb_specs_engines.mtype NOT LIKE 'N__' AND bkb_specs_engines.mtype <> 'Motorsport' ORDER BY bkb_specs_engines.mtype, bkb_specs_engines.fuel, bkb_specs_engines.mcode"; $bkb_engine_other = mysqli_query($database, $query_bkb_engine_other) or die(mysqli_error()); $row_bkb_engine_other = mysqli_fetch_assoc($bkb_engine_other); $totalRows_bkb_engine_other = mysqli_num_rows($bkb_engine_other); mysqli_select_db($db_name, $database); $query_bkb_engine_motorsport = "SELECT bkb_specs_engines.eid, bkb_specs_engines.mtype, bkb_specs_engines.fuel, bkb_specs_engines.cylinders, bkb_specs_engines.valves, bkb_specs_engines.arrangement, bkb_specs_engines.`displacement`, bkb_specs_engines.power, bkb_specs_engines.torque, bkb_specs_engines.mcode FROM bkb_specs_engines WHERE bkb_specs_engines.mtype = 'Motorsport' ORDER BY bkb_specs_engines.fuel, bkb_specs_engines.cylinders, bkb_specs_engines.valves, bkb_specs_engines.mtype, bkb_specs_engines.mcode"; $bkb_engine_motorsport = mysqli_query($database, $query_bkb_engine_motorsport) or die(mysqli_error()); $row_bkb_engine_motorsport = mysqli_fetch_assoc($bkb_engine_motorsport); $totalRows_bkb_engine_motorsport = mysqli_num_rows($bkb_engine_motorsport); mysqli_select_db($db_name, $database); $query_bkb_engine_noauth = "SELECT eng.eid, eng.mtype, eng.fuel, eng.cylinders, eng.valves, eng.arrangement, eng.`displacement`, eng.power, eng.torque, eng.mcode FROM bkb_specs_engines_auth eng ORDER BY eng.mtype, eng.mcode, eng.fuel, eng.cylinders, eng.valves"; $bkb_engine_noauth = mysqli_query($database, $query_bkb_engine_noauth) or die(mysqli_error()); $row_bkb_engine_noauth = mysqli_fetch_assoc($bkb_engine_noauth); $totalRows_bkb_engine_noauth = mysqli_num_rows($bkb_engine_noauth); mysqli_select_db($db_name, $database); $query_bkb_altpower = "SELECT * FROM bkb_specs_alternative_engines ae ORDER BY ae.aetype, ae.aecode, ae.aepower, ae.aetorque"; $bkb_altpower = mysqli_query($database, $query_bkb_altpower) or die(mysqli_error()); $row_bkb_altpower = mysqli_fetch_assoc($bkb_altpower); $totalRows_bkb_altpower = mysqli_num_rows($bkb_altpower); mysqli_select_db($db_name, $database); $query_gallery_parents = "SELECT jos_joomgallery_catg.cid, jos_joomgallery_catg.name FROM jos_joomgallery_catg WHERE jos_joomgallery_catg.published = 1 AND jos_joomgallery_catg.parent = 0 ORDER BY jos_joomgallery_catg.name ASC"; $gallery_parents = mysqli_query($database, $query_gallery_parents) or die(mysqli_error()); $row_gallery_parents = mysqli_fetch_assoc($gallery_parents); $totalRows_gallery_parents = mysqli_num_rows($gallery_parents); if (strcmp($GLOBALS['ckMetImp'],"metric")===0) { $valMI = "imperial"; $labelval['mi']="pounds, inches, etc."; $labelval['length_s']=" in millimeters (mm)"; $labelval['length_l']=" in meters (m)"; $labelval['weight']=" in kilograms (kg)"; $labelval['liquid_s']=" in liters (l)"; $labelval['liquid_l']=" in liters (l)"; $labelval['volume']=" in liters (l)"; $labelval['speed']=" in kilometers per hour (km/h)"; $labelval['consumption']=" in litres per 100 kilometer (l/100km)"; $labelval['0100']=" 0-100 kilometers per hour in seconds (s)"; $labelval['80120']=" 80-120 kilometres per hour (in 4th gear) in seconds (s)"; } else { $valMI = "metric"; $labelval['mi']="kilograms, meters, etc."; $labelval['length_s']=" in inch (in)"; $labelval['length_l']=" in feet (ft)"; $labelval['weight']=" in pounds (lbs)"; $labelval['liquid_s']=" in quarts (qts)"; $labelval['liquid_l']=" in gallons (gal)"; $labelval['volume']=" in cubic feet (ft3)"; $labelval['speed']=" in miles per hour (mph)"; $labelval['consumption']=" in miles per gallon (mpg)"; $labelval['0100']=" 0-62 miles per hour in seconds (s)"; $labelval['80120']=" 50-75 miles per hour (in 4th gear) in seconds (s)"; } $sbtntext = "Submit to database"; $GLOBALS['situation']=0; if ($errors) {//Situation: addition/change to database, but errors occurred Session_storePOST(); $pageval = $_SESSION; $blaaat = "1: Situation: addition/change to database, but errors occurred"; $GLOBALS['situation']=1; } else { if ($dbinsert) {//Situation: addition/change to database, successful $pageval = $carid = NULL; $blaaat = "2: Situation: addition/change to database, successful"; $GLOBALS['situation']=2; } elseif (isset($_GET['id'])) {//Situation: change page (given id) $carid = (int) $_GET['id']; mysqli_select_db($db_name, $database); $query_modify = "SELECT * FROM bkb_specs_cars WHERE id = ".$carid." LIMIT 0,1"; $modify = mysqli_query($database, $query_modify) or die(mysqli_error()); $pageval = mysqli_fetch_assoc($modify) or header("location:http://".$_SERVER['HTTP_HOST'].rtrim(dirname($_SERVER['PHP_SELF']), '/\\')."/modify.php?msg=Cannot%20find%20specifications%20for%20car."); $sbtntext = "Submit changes to database"; $blaaat = "3: Situation: change page (given id)"; $GLOBALS['situation']=3; } else {//Situation: addition page (no id) $pageval = $carid = NULL; $blaaat = "4: Situation: addition page (no id)"; $GLOBALS['situation']=4; } } if ($pageval['gid']) { //Calculate scroll for image div mysqli_select_db($db_name, $database); $qry_numgallery = "SELECT p.id, p.imgthumbname, c.catpath FROM jos_joomgallery p LEFT JOIN jos_joomgallery_catg c ON p.catid = c.cid WHERE p.approved = 1 AND p.catid = ".$pageval['gid']." ORDER BY p.ordering ASC"; $numgallery = mysqli_query($database, $qry_numgallery) or die(mysqli_error()); $row_numgallery = mysqli_fetch_assoc($numgallery); $scrollleft=$i=0; $imgwidth=""; do { if ($i>2) { list($height,$width) = getimagesize("../gallery/images/thumbnail/".$row_numgallery['catpath']."/".$row_numgallery['imgthumbname']); $scrollleft+=$width+50; } if ($row_numgallery['id']==$pageval['pid']) break; $i++; } while ($row_numgallery = mysqli_fetch_assoc($numgallery)); } $numrow=0; $errmsg=" class=\"error\""; if ($carid) DisplayHeader("Modify specifications for ".$pageval['yearbegin']." ".$pageval['brand']." ".$pageval['type']." ".$pageval['transmission'].($pageval['lci'] ? " LCI ":" ").$pageval['body']." (".$pageval['enumber'].")",1,$pageval); else DisplayHeader("Add specifications",1,$pageval); ?>