".TXT_WPSC_SELECTABRAND."\r\n"; $values = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."product_brands` ORDER BY `id` ASC",ARRAY_A); foreach($values as $option) { if($curent_brand == $option['id']) { $selected = "selected='selected'"; } $options .= "\r\n"; $selected = ""; } $concat .= "\r\n"; return $concat; } $imagedir = ABSPATH."/wp-content/plugins/wp-shopping-cart/brand_images/"; if($_POST['submit_action'] == "add") { if($_FILES['image'] != null) { if(function_exists("getimagesize")) { // pe.{ $imagefield = 'image'; // }.pe include("image_processing.php"); } else { move_uploaded_file($_FILES['image']['tmp_name'], ($imagedir.$_FILES['image']['name'])); $image = $wpdb->escape($_FILES['image']['name']); } } else { $image = ''; } $insertsql = "INSERT INTO `".$wpdb->prefix."product_brands` ( `name` , `description`, `active`, `order` )VALUES ('".$_POST['name']."', '".$_POST['description']."', '1', '0')"; if($wpdb->query($insertsql)) { echo "

".TXT_WPSC_ITEMHASBEENADDED."

"; } else { echo "

".TXT_WPSC_ITEMHASNOTBEENADDED."

"; } } if(($_POST['submit_action'] == "edit") && is_numeric($_POST['prodid'])) { if($_POST['special'] == 'yes') { $special = 1; } else { $special = 0; } if($_POST['notax'] == 'yes') { $notax = 1; } else { $notax = 0; } $updatesql = "UPDATE `".$wpdb->prefix."product_brands` SET `name` = '".$wpdb->escape($_POST['title'])."', `description` = '".$wpdb->escape($_POST['description'])."' WHERE `id`='".(int)$_POST['prodid']."' LIMIT 1"; $wpdb->query($updatesql); echo "

".TXT_WPSC_BRANDHASBEENEDITED."

"; } if(is_numeric($_GET['deleteid'])) { $deletesql = "UPDATE `".$wpdb->prefix."product_brands` SET `active` = '0' WHERE `id`='".(int)$_GET['deleteid']."' LIMIT 1"; $wpdb->query($deletesql); } $sql = "SELECT * FROM `".$wpdb->prefix."product_brands` WHERE `active`=1"; $product_list = $wpdb->get_results($sql,ARRAY_A) ; ?>

<?php echo TXT_WPSC_ADD; ?>  Loading
\n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; /* echo " \n\r"; */ echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; if($product_list != null) { foreach($product_list as $product) { /* echo " \n\r"; echo " \n\r"; */ echo " \n\r"; $displaydescription = substr(stripslashes($product['description']),0,44); if($displaydescription != $product['description']) { $displaydescription_arr = explode(" ",$displaydescription); $lastword = count($displaydescription_arr); if($lastword > 1) { unset($displaydescription_arr[$lastword-1]); $displaydescription = ''; $j = 0; foreach($displaydescription_arr as $displaydescription_row) { $j++; $displaydescription .= $displaydescription_row; if($j < $lastword -1) { $displaydescription .= " "; } } } $displaydescription .= "..."; } echo " \n\r"; echo " \n\r"; echo " \n\r"; } } echo "
\n\r"; echo TXT_WPSC_IMAGE; echo " \n\r"; echo TXT_WPSC_NAME; echo " \n\r"; echo TXT_WPSC_DESCRIPTION; echo " \n\r"; echo TXT_WPSC_EDIT; echo "
\n\r"; if($product['image'] !=null) { echo "".$product["; } else { echo "".$product["; } echo " \n\r"; echo "".stripslashes($product['name']).""; echo " \n\r"; echo "".stripslashes($displaydescription).""; echo " \n\r"; echo "".TXT_WPSC_EDIT.""; echo "
\n\r"; echo " \n\r"; echo "
"; echo "
"; echo " \n\r";; echo " \n\r"; echo " \n\r"; echo " \n\r"; echo "
\n\r"; echo "".TXT_WPSC_EDITBRAND.""; echo "
\n\r"; echo "
\n\r"; echo "
\n\r"; echo "
"; echo "
"; ?>
:
:
\n\r"; echo " \n\r"; ?>