$java = "description"; include("includes/htmlareabody.php");> 0) { $iteminventory = ""; for ($i = 0; $i < $optcount; ++$i) { if ($inventory[$i] >= 0 AND $inventory[$i] != "") { $iteminventory = $iteminventory + $inventory[$i]; $addinvquery = "INSERT INTO " .$DB_Prefix ."_inventory (ProductID, Attribute, Quantity) "; $addinvquery .= "VALUES ('$itemid', '$attribute[$i]', '$inventory[$i]')"; $addinvresult = mysql_query($addinvquery, $dblink) or die("Unable to edit your options. Please try again later."); } } } // Update inventory for all records $updattquery = "UPDATE " .$DB_Prefix ."_items SET "; if ($iteminventory == "" AND $iteminventory != "0") $updattquery .= "Inventory=NULL "; else $updattquery .= "Inventory='$iteminventory' "; $updattquery .= "WHERE ID='$itemid'"; $updattresult = mysql_query($updattquery, $dblink) or die("Unable to update item inventory. Please try again later."); } // Start item display $varquery = "SELECT URL, CatalogPage, Currency, ShowDiscountPr, ItemImages, ShowCosts, DefaultProduct FROM " .$DB_Prefix ."_vars WHERE ID=1"; $varresult = mysql_query($varquery, $dblink) or die ("Unable to select your system variables. Try again later."); if (mysql_num_rows($varresult) == 1) { $varrow = mysql_fetch_row($varresult); $urllink = "http://" .$varrow[0]; $CatalogURL= $urllink ."/" .$varrow[1]; $currency = $varrow[2]; $showdiscountpr = $varrow[3]; $itemimages = $varrow[4]; $showcosts = $varrow[5]; $defprodid = $varrow[6]; } if ($catsearch OR $kwsearch OR $limitview) { if ($catsearch) { $catsearch = stripslashes($catsearch); $catlink = stripslashes($catsearch); $catlink = urlencode($catlink); } if ($kwsearch) { $kwlink = stripslashes($kwsearch); $kwlink = urlencode($kwlink); } } if (($Submit == "Add") OR ($Submit == "Edit")) { if ($Submit == "Add") { $getitemquery = "SELECT * FROM " .$DB_Prefix ."_items WHERE ID = '$defprodid'"; $getitemresult = mysql_query($getitemquery, $dblink) or die ("Unable to select. Try again later."); if (mysql_num_rows($getitemresult) == 1) { if ($Set == "Default") { $getitemrow = mysql_fetch_array($getitemresult); $prodid = $getitemrow[ID]; $catnum = $getitemrow[Catalog]; $stripitem = str_replace('"', '"', stripslashes($getitemrow[Item])); $stripmetatitle = str_replace('"', '"', stripslashes($getitemrow[MetaTitle])); $stripdescrip = stripslashes($getitemrow[Description]); $stripkeywords = stripslashes($getitemrow[Keywords]); $smallimage = $getitemrow[SmImage]; $largeimage = $getitemrow[LgImage]; $smallimage2 = $getitemrow[SmImage2]; $largeimage2 = $getitemrow[LgImage2]; $smallimage3 = $getitemrow[SmImage3]; $largeimage3 = $getitemrow[LgImage3]; $cat1 = $getitemrow[Category1]; $cat2 = $getitemrow[Category2]; $cat3 = $getitemrow[Category3]; $cat4 = $getitemrow[Category4]; $cat5 = $getitemrow[Category5]; $units = (float)$getitemrow[Units]; $regularprice = $getitemrow[RegPrice]; $saleprice = $getitemrow[SalePrice]; $outofstock = $getitemrow[OutOfStock]; $active = $getitemrow[Active]; $discountpr = $getitemrow[DiscountPr]; $wholesale = $getitemrow[Wholesale]; $wsonly = $getitemrow[WSOnly]; $featured = $getitemrow[Featured]; $itemcost = $getitemrow[ItemCost]; $taxpercent = $getitemrow[TaxPercent]; $popuppg = $getitemrow[PopUpPg]; echo "

"; echo "Remove Default

"; } else { echo "

"; echo "Set Default

"; } } } else if ($Submit == "Edit") { $getitemquery = "SELECT * FROM " .$DB_Prefix ."_items WHERE ID = '$itemid'"; $getitemresult = mysql_query($getitemquery, $dblink) or die("Could not select items"); $getitemrow = mysql_fetch_array($getitemresult); $prodid = $getitemrow[ID]; $catnum = $getitemrow[Catalog]; $stripitem = str_replace('"', '"', stripslashes($getitemrow[Item])); $stripmetatitle = str_replace('"', '"', stripslashes($getitemrow[MetaTitle])); $stripdescrip = stripslashes($getitemrow[Description]); $stripkeywords = stripslashes($getitemrow[Keywords]); $smallimage = $getitemrow[SmImage]; $largeimage = $getitemrow[LgImage]; $smallimage2 = $getitemrow[SmImage2]; $largeimage2 = $getitemrow[LgImage2]; $smallimage3 = $getitemrow[SmImage3]; $largeimage3 = $getitemrow[LgImage3]; $cat1 = $getitemrow[Category1]; $cat2 = $getitemrow[Category2]; $cat3 = $getitemrow[Category3]; $cat4 = $getitemrow[Category4]; $cat5 = $getitemrow[Category5]; $units = (float)$getitemrow[Units]; $regularprice = $getitemrow[RegPrice]; $saleprice = $getitemrow[SalePrice]; $outofstock = $getitemrow[OutOfStock]; $active = $getitemrow[Active]; $discountpr = $getitemrow[DiscountPr]; $wholesale = $getitemrow[Wholesale]; $wsonly = $getitemrow[WSOnly]; $featured = $getitemrow[Featured]; if ($getitemrow[DateEdited] != 0) { $dateedit = explode("-",$getitemrow[DateEdited]); $editdate = date("n/j/y", mktime(0,0,0,$dateedit[1],$dateedit[2],$dateedit[0])); } else $editdate = date("n/j/y", mktime (0,0,0,date("m"),date("d"),date("Y"))); $itemcost = $getitemrow[ItemCost]; $taxpercent = $getitemrow[TaxPercent]; $popuppg = $getitemrow[PopUpPg]; } // Display Product Name echo "

"; if ($Submit == "Edit") echo "Editing: $stripitem"; else if ($Submit == "Add") echo "Add New Product"; echo "

"; // Display link back to item list if ($catsearch OR $kwsearch OR $limitview) { echo "

"; echo ""; echo "(Back to Item List)

"; } ?>
1) { ?> 0) { echo ""; echo ""; echo ""; echo ""; } ?> "; echo ""; echo ""; echo ""; } echo "
Item Name: " size="47">
Description:
Item Link"; ?> 		"; echo htmlentities($stripdescrip); echo ""; ?>
Keywords:
100 chars max		 $stripkeywords"; ?>
Meta Title: " size="47">
Thumbnail URL: " size="40"> Upload"; ?>
Large Image URL: " size="40"> Upload"; ?>
Thumbnail 2: " size="40"> Upload"; ?>
Large Image 2: " size="40"> Upload"; ?>
Thumbnail 3: " size="40"> Upload"; ?>
Large Image 3: " size="40"> Upload"; ?>
Pop-Up Page:"; echo ""; echo "
Catalog #: " size="9"> Shipping Units: " size="9">
Regular Price: " size="9"> On Sale Price: " size="9">
Tax %: " size="8">% Your Costs: " size="9">
Wholesale %: " size="8">% Display:
Active Item: Out of Stock?
Featured:
Use the following to set price discounts for your products.
Price Discounts: "; $disccount = explode("~", $discountpr); for ($i = 1; $i <= 5; ++$i) { $dc = $i-1; $qtyval = ""; $amtval = ""; $discval = ""; if ($disccount[$dc]) { $discvals = explode(",", $disccount[$dc]); $qtyval = $discvals[0]; $amtval = $discvals[1]; } echo "
"; echo " or more "; echo "- "; echo " "; echo "% off "; echo "$currency off"; echo "
"; ?>
Assign up to 5 categories to this item. 0 AND $ci == 1) $thiscat = $catsearch; else $thiscat = ${"cat$ci"}; echo ""; echo "Category #$ci:"; echo ""; echo ""; echo ""; echo ""; } if ($Submit == "Edit") { ?>
Date Entered: " size="10"> (Format MM/DD/YY) "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if ($Submit == "Edit") { echo ""; echo ""; } else echo ""; ?>
">
You are about to delete the following item:

Do you want to continue?

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?>
"; else { ?>
No Items Listed.
View Items:
"; for ($getitemcount = 1; $getitemrow = mysql_fetch_row($getitemresult); ++$getitemcount) { $display = stripslashes($getitemrow[2]); if ($getitemrow[1]) $display .= " (# $getitemrow[1])"; echo ""; } echo ""; ?>
"; echo " | "; } ?>
Advanced Item Search:
Category: "; echo ""; for ($getcatcount = 1; $getcatrow = mysql_fetch_row($getcatresult); ++$getcatcount) { $display = stripslashes($getcatrow[0]); echo ""; $subcatquery = "SELECT Category, ID FROM " .$DB_Prefix ."_categories WHERE Parent = '$getcatrow[1]' ORDER BY Category"; $subcatresult = mysql_query($subcatquery, $dblink) or die ("Could not show categories. Try again later."); $subcatnum = mysql_num_rows($subcatresult); for ($subcatcount = 1; $subcatrow = mysql_fetch_row($subcatresult); ++$subcatcount) { $subdisplay = stripslashes($subcatrow[0]); echo ""; // START MULTI CATEGORY $endcatquery = "SELECT Category, ID FROM " .$DB_Prefix ."_categories WHERE Parent = '$subcatrow[1]' ORDER BY Category"; $endcatresult = mysql_query($endcatquery, $dblink) or die ("Could not show categories. Try again later."); $endcatnum = mysql_num_rows($endcatresult); for ($endcatcount = 1; $endcatrow = mysql_fetch_row($endcatresult); ++$endcatcount) { $subdisplay = stripslashes($endcatrow[0]); echo ""; } // END MULTI CATEGORY } } echo ""; } ?>
Keywords:
View:
Order By:
Display Per Page:
Edit Mode:

Add a New Item:

"; echo ""; echo "(Back to Item List)

"; } ?>