Emaze Auction: Lot SELECT lastBidDateTime FROM Lot WHERE lotID = #Form.lotID# SELECT lotCloseQueue FROM Lot WHERE lotID = #Form.lotID# SELECT Count(lotID) AS checkCount FROM Lot WHERE lotImage = '#Form.oldLotImage#' OR lotImageThumbnail = '#Form.oldLotImage#' SELECT Count(lotID) AS checkCount FROM Lot WHERE lotImage = '#Form.oldLotImageThumbnail#' OR lotImageThumbnail = '#Form.oldLotImageThumbnail#' SELECT nextBidMinimum FROM Lot WHERE lotID = #Form.lotID# SELECT nextBidMinimum FROM Lot WHERE lotID = #Form.lotID# UPDATE Lot SET lotName = '#Form.lotName#', lotQuantity = #Form.lotQuantity#, lotQuantityMaximum = #Form.lotQuantityMaximum#, lotReservePrice = #lotReservePrice#, lotReservePriceMet = #lotReservePriceMet#, lotSellPrice = #Form.lotSellPrice#, lotShipping = #Form.lotShipping#, lotSummary = '#lotSummary#', lotDescription = '#lotDescription#', categoryID = #Form.categoryID#, templateFile = '#Form.templateFile#', lotType = -1,1, lotImage = '#lotImage#', lotImageThumbnail = '#lotImageThumbnail#', lotOpenDateTime = #lotOpenDateTime#, lotOpeningBid = #Form.lotOpeningBid#, lotBidIncrement = #Form.lotBidIncrement#, nextBidMinimum = #nextBidMinimum#, nextNextBidMinimum = #nextBidMinimum# + #Form.lotBidIncrement#, lotHighBid = #lotHighBid#, lotCloseBasis = '#Form.lotCloseBasis#', lotCloseDateTime = #lotCloseDateTime#, lotCloseInactivity = #lotCloseInactivity#, lotPublic = #Form.lotPublic#, lotStatus = '#Form.lotStatus#', lotCloseQueue = #lotCloseQueue#, lotLocation = NULL,'#Form.lotLocation#', lotShippingPolicy = NULL,'#Form.lotShippingPolicy#', lotPaymentMethod = NULL,'#Form.lotPaymentMethod#', lotContactName = NULL, '#Form.lotContactName#', lotContactEmail = NULL, '#Form.lotContactEmail#', lotDateTimeLastEdited = #currentDateTime#, lotBold = 1,0, lotFeaturedCategory = 1,0, lotFeaturedHomepage = 10 WHERE lotID = #Form.lotID# UPDATE Category SET categoryLotCount = categoryLotCount - 1 WHERE categoryID = #Form.oldCategoryID# SELECT categoryID1, categoryID2, categoryID3, categoryID4 FROM Category WHERE categoryID = #Form.oldCategoryID# UPDATE Category SET categorySubLotCount = categorySubLotCount - 1 WHERE categoryID = 0#getCatID.categoryID1# OR categoryID = 0#getCatID.categoryID2# OR categoryID = 0#getCatID.categoryID3# OR categoryID = 0#getCatID.categoryID4# UPDATE Category SET categoryLotCount = categoryLotCount + 1 WHERE categoryID = #Form.categoryID# SELECT categoryID1, categoryID2, categoryID3, categoryID4 FROM Category WHERE categoryID = #Form.categoryID# UPDATE Category SET categorySubLotCount = categorySubLotCount - 1 WHERE categoryID = #getCatID.categoryID1# OR categoryID = #getCatID.categoryID2# OR categoryID = #getCatID.categoryID3# OR categoryID = #getCatID.categoryID4# UPDATE Category SET categoryLotCount = categoryLotCount + 1 WHERE categoryID = #Form.categoryID# SELECT categoryID1, categoryID2, categoryID3, categoryID4 FROM Category WHERE categoryID = #Form.categoryID# UPDATE Category SET categorySubLotCount = categorySubLotCount + 1 WHERE categoryID = #getCatID.categoryID1# OR categoryID = #getCatID.categoryID2# OR categoryID = #getCatID.categoryID3# OR categoryID = #getCatID.categoryID4# INSERT INTO Lot (lotName, lotQuantity, lotQuantityMaximum, lotSummary, categoryID, templateFile, lotImage, lotImageThumbnail, lotOpenDateTime, lotOpeningBid, lotBidIncrement, lotCloseBasis, lotCloseDateTime, lotCloseInactivity, lotPublic, lotStatus, lotCloseQueue, lotContactName, lotContactEmail, lotDateTimeCreated, lotDateTimeLastEdited, lotDescription, lotReservePrice, lotSellPrice, userID, lotViewCount, lotReservePriceMet, lotReserveStayOpenTimes, lotBidsExist, lotNoBidsStayOpenTimes, lotQuantityTaken, lotShipping, nextBidMinimum, nextNextBidMinimum, lastBidDateTime, secondLastBidDateTime, lotBidCount, lotHighBid, lotLocation, lotShippingPolicy, lotPaymentMethod, lotBold, lotFeaturedCategory, lotFeaturedHomepage, lotType, lotProcureLowBidAutoWins, lotProcureBidAboveOpeningBid, lotProcureBidDescription) VALUES ('#Form.lotName#', #Form.lotQuantity#, #Form.lotQuantityMaximum#, '#lotSummary#', #Form.categoryID#, '#Form.templateFile#', '#lotImage#', '#lotImageThumbnail#', #lotOpenDateTime#, #Form.lotOpeningBid#, #Form.lotBidIncrement#, '#Form.lotCloseBasis#', #lotCloseDateTime#, #lotCloseInactivity#, #Form.lotPublic#, '#Form.lotStatus#', #lotCloseQueue#, NULL, '#Form.lotContactName#', NULL, '#Form.lotContactEmail#', #currentDateTime#, #currentDateTime#, '#lotDescription#', #lotReservePrice#, #Form.lotSellPrice#, 1, 0, #lotReservePriceMet#, 0, 0, 0, 0, #Form.lotShipping#, #Form.lotOpeningBid#, #nextNextBidMinimum#, {ts '1998-07-01 00:00:01'}, {ts '1998-01-01 00:00:01'}, 0, #lotOpeningBid#, NULL,'#Form.lotLocation#', NULL,'#Form.lotShippingPolicy#', NULL,'#Form.lotPaymentMethod#', 1, 0, 1, 0, 10, -1,1, 1, 0, 0) SELECT lotID FROM Lot WHERE lotDateTimeCreated = #currentDateTime# AND lotName = '#Form.lotName#' UPDATE Category SET categoryLotCount = categoryLotCount + 1 WHERE categoryID = #Form.categoryID# SELECT categoryID1, categoryID2, categoryID3, categoryID4 FROM Category WHERE categoryID = #Form.categoryID# UPDATE Category SET categorySubLotCount = categorySubLotCount + 1 WHERE categoryID = #getCatID.categoryID1# OR categoryID = #getCatID.categoryID2# OR categoryID = #getCatID.categoryID3# OR categoryID = #getCatID.categoryID4# ">

Lot #Form.lotID#, #Form.lotName# updated.

Lot #Form.lotName# created with lotID = #lotID#.

View this lot. Edit this lot.
Below is the full URL to this lot:
#systemURL#/lot.cfm?lotID=#lotID#

You may create another lot below, or switch to another screen.

Edit Lot - #lotID# SELECT * FROM Lot WHERE lotID = #lotID# Create Lot SELECT * FROM Lot WHERE lotID = #lotID# SELECT categoryID, categoryName FROM Category WHERE categoryID > 0 ORDER BY categoryName

You must create at least one category before you may create a lot.

You may re-open this lot since there were either no bids or the reserve price was not met. To re-open the lot, simply change the closing time and change the lot status to "Open." You may also change the closing time. The lot will automatically re-open at the specific opening time.

SELECT templateName, templateFile FROM Template WHERE templateType = 'lot' OR templateType = 'reverse' ORDER BY templateName SELECT email, firstName, lastName FROM Member WHERE userID = 1
Name:
Status: Open (will re-open at designated Open time; Preview until then)
Inactive (will not re-open at Open time until made active)
Auction closed (completed)
 --  Open (will open at designated Open time; Preview until then)
 --  Inactive (will not open at Open time until made active)
Auction closed (completed) CHECKED> Active (will open at designated Open time; Preview until then)
CHECKED> Inactive (will not open at Open time until made active)
 --  Auction closed (completed) Active (will open at designated Open time; Preview until then)
Inactive (will not open at Open time until made active)
 --  Auction closed (completed)
Extra Options: CHECKED> Bold auction
CHECKED> Featured auction on category page
CHECKED> Featured auction on homepage
 
Open date/time: / / , : (MM/DD/YYYY : HH:MM AM/PM)
Open lot now (If checked, above date/time is ignored)
Close date/time: / / , : (MM/DD/YYYY : HH:MM AM/PM)
Close lots X days after opening date/time. (If not blank, above date is ignored)
Close Basis: CHECKED> Time
CHECKED> Time + Inactivity
Close Inactivity: (in whole minutes)
 
Quantity:   
  
Max. Quantity:    (0 = unlimited)
   (0 = unlimited)
Opening bid: $
Bid Increment: $
Reserve Price: $ (0.00 = none; Applies only if lot quantity = 1.)
Shipping: $ (0.00 = none; Not used, but is available)
Sell Price: $ (0.00 = none)
$ (0.00 = none)
 
Category:
Template:
Public: CHECKED> Public (all users may bid)
CHECKED> Private (users need permission to access lot page) Public (all users may bid)
Private (users need permission to bid)
Location:
Shipping Policy:
Payment Method:
Contact Name:
Contact Email:
 
If using the lotimage directory, select the image from your computer by
clicking the "Browse" button. This will upload the image to the server.
If using an image in another directory, enter the full URL.
If not using an image, just ignore both fields.
If changing an image, simply change the URL or choose an image file to upload.
If deleting an image, erase the URL in the URL field.
Image: (If uploading, File. If other, URL. If none, ignore.)
File:
URL:
Thumbnail: (If uploading, File. If other, URL. If none, ignore.)
File:
URL:
 
Summary:
Description: