include("setting.php");
include("includes/login_cek.php");
$db_connect = mysql_connect($db_host, $db_username, $db_password);
mysql_select_db($db_name, $db_connect) || die(mysql_error());
$sql_query = "
INSERT INTO listing_stat SET
stat_listing = '$listing',
stat_datetime = '$date_database'
";
mysql_query($sql_query) or die(mysql_error());
$sql_query = "
SELECT * FROM listing, showroom, setup_make, setup_condition, setup_verkstatus, setup_doors, setup_category, setup_fuel, setup_transmission
WHERE
listing_id = '$listing' AND
listing_showroom = showroom_id AND
listing_make = make_id AND
listing_status = verkaufst_id AND
listing_condition = condition_id AND
listing_category = category_id AND
listing_fuel = fuel_id AND
listing_transmission = transmission_id
";
$result = mysql_query($sql_query) or die(mysql_error());
$row = mysql_fetch_array($result);
$row = decode_array($row);
$showroom_name = $row[showroom_name];
$showroom_address1 = $row[showroom_address1];
$showroom_address2 = $row[showroom_address2];
$showroom_city = $row[showroom_city];
$showroom_state = $row[showroom_state];
$showroom_country = get_country_name($row[showroom_country]);
$showroom_zip = $row[showroom_zip];
$showroom_phone = $row[showroom_phone];
$showroom_fax = $row[showroom_fax];
$showroom_email = $row[showroom_email];
$showroom_website = $row[showroom_website];
if ($showroom_name) { $showroom_detail .= "$showroom_name
"; }
if ($showroom_address1) { $showroom_detail .= "$showroom_address1
"; }
if ($showroom_address2) { $showroom_detail .= "$showroom_address2
"; }
if ($showroom_city) { $showroom_detail .= "$showroom_city
"; }
if ($showroom_state) { $showroom_detail .= "$showroom_state"; }
if ($showroom_zip) { $showroom_detail .= " - $showroom_zip"; }
if ($showroom_country) { $showroom_detail .= "
$showroom_country"; }
$listing_stocknumber = $row[listing_stocknumber];
$listing_vin = $row[listing_vin];
$listing_year = $row[listing_year];
$listing_make = $row[make_name];
$listing_model = $row[listing_model];
$listing_condition = $row[condition_name];
$listing_category = $row[category_name];
$listing_mile = $row[listing_mile];
$listing_usage = $row[listing_usage];
$listing_price_normal = $row[listing_price_normal];
$listing_price_sale = $row[listing_price_sale];
$listing_description = $row[listing_description];
$listing_color_exterior = $row[listing_color_exterior];
$listing_color_interior = $row[listing_color_interior];
$listing_doors = $row[doors_name];
$listing_fuel = $row[fuel_name];
$listing_drive_train = $row[listing_drive_train];
$listing_engine = $row[listing_engine];
$listing_transmission = $row[transmission_name];
$listing_top_speed = $row[listing_top_speed];
$listing_horse_power = $row[listing_horse_power];
$listing_torque = $row[listing_torque];
$listing_towing_capacity = $row[listing_towing_capacity];
$listing_feature_checkbox = $row[listing_feature_checkbox];
$listing_feature_additional = $row[listing_feature_additional];
$listing_tagline = $row[listing_tagline];
$listing_info_url = $row[listing_info_url];
$listing_info_text = $row[listing_info_text];
$listing_auction_url = $row[listing_auction_url];
$listing_status = $row[verkaufst_name];
$listing_status_featured = $row[listing_status_featured];
$listing_status_displayed = $row[listing_status_displayed];
$sql_query = "SELECT * FROM listing_photo WHERE photo_listing = '$listing' AND photo_status = 'main'";
$result = mysql_query($sql_query) or die(mysql_error());
$row = mysql_fetch_array($result);
$photo_main = $row[photo_id];
$photo_title = $row[photo_title];
$array_features = explode("," , $listing_feature_checkbox);
$array_list = "";
for ( $i=0; $i<=sizeof($array_features); $i++) {
$item_feature = $array_features[$i];
$sql_query = "SELECT * FROM setup_feature WHERE feature_id = '$item_feature'";
$result = mysql_query($sql_query) or die(mysql_error());
$row = mysql_fetch_array($result);
$row = decode_array($row);
$feature_name = $row[feature_name];
if ($feature_name) {
$total_features++;
$array_list[$total_features] = $feature_name;
}
}
sort($array_list);
// calculate rows for columns
$row_col = floor($total_features / 3);
if ($total_features % 3 == 1) {
$arr_col[1] = $row_col + 1;
$arr_col[2] = $row_col;
$arr_col[3] = $row_col;
}
if ($total_features % 3 == 2) {
$arr_col[1] = $row_col + 1;
$arr_col[2] = $row_col + 1;
$arr_col[3] = $row_col;
}
if ($total_features % 3 == 0) {
$arr_col[1] = $row_col;
$arr_col[2] = $row_col;
$arr_col[3] = $row_col;
}
mysql_close($db_connect);
?>
include("includes/global_top.php") ?> |
include("includes/global_left.php") ?> |
$db_connect = mysql_connect($db_host, $db_username, $db_password);
mysql_select_db($db_name, $db_connect) || die(mysql_error());
$i = 0;
$sql_query = "
SELECT * FROM listing, setup_make, setup_verkstatus
WHERE
listing_make = make_id AND
listing_status = verkaufst_id AND
listing_status_featured = 'yes'
ORDER BY make_name ASC";
$result = mysql_query($sql_query) or die(mysql_error());
while($row = mysql_fetch_array($result)) {
$i++;
$row = decode_array($row);
$listing_id = $row[listing_id];
$listing_make = $row[make_name];
$make_name = $row[make_name];
$listing_model = $row[listing_model];
$listing_year = $row[listing_year];
$listing_status = $row[verkaufst_name];
$listing_price_sale = $row[listing_price_sale];
$listing_description = limit_text(html_entity_decode($row[listing_description]), 50);
$listing_name = "$listing_make - $listing_model";
$sql_query = "
SELECT * FROM listing_photo
WHERE
photo_listing = '$listing_id' AND
photo_status = 'main'
";
$result_1 = mysql_query($sql_query) or die(mysql_error());
$row_1 = mysql_fetch_array($result_1);
$photo_main = $row_1[photo_id];
?>
|
if ($row = mysql_fetch_array($result)) {
$i++;
$row = decode_array($row);
$listing_id = $row[listing_id];
$listing_make = $row[make_name];
$listing_model = $row[listing_model];
$listing_year = $row[listing_year];
$listing_status = $row[verkaufst_name];
$listing_price_sale = $row[listing_price_sale];
$listing_description = limit_text(html_entity_decode($row[listing_description]), 50);
$listing_name = "$listing_make - $listing_model";
$tmp_description = explode(" ", $listing_description);
$new_description = "";
for ($i=0; $i<=sizeof($tmp_description); $i++) {
if (strlen($new_description) <= 50) { $new_description = "$new_description ".$tmp_description[$i]; }
}
$listing_description = $new_description;
$sql_query = "
SELECT * FROM listing_photo
WHERE
photo_listing = '$listing_id' AND
photo_status = 'main'
";
$result_1 = mysql_query($sql_query) or die(mysql_error());
$row_1 = mysql_fetch_array($result_1);
$photo_main = $row_1[photo_id];
?>
|
} ?>
}
mysql_close($db_connect);
?>
|
include("includes/global_bottom.php") ?> |
|