Emaze Auction: Approve Sellers, Seller-Created Lots
Lot #lotID# does not seem to exist.
UPDATE Category
SET categoryLotCount = categoryLotCount + 1
WHERE categoryID = #categoryID#
SELECT categoryID1, categoryID2, categoryID3, categoryID4
FROM Category
WHERE categoryID = #categoryID#
UPDATE Category
SET categorySubLotCount = categorySubLotCount + 1
WHERE categoryID = #getCatID.categoryID1#
OR categoryID = #getCatID.categoryID2#
OR categoryID = #getCatID.categoryID3#
OR categoryID = #getCatID.categoryID4#
">
Lot #lotID# was opened.
SELECT lotID FROM Lot WHERE lotImage = '#lotImage#'
SELECT lotID FROM Lot WHERE lotImage = '#lotImageThumbnail#'
Lot #lotID# was deleted.
UPDATE Lot
SET lotStatus = 'Open',
lotCloseQueue = 1
WHERE lotID IN (#ListRest(approvedLots)#)
SELECT Member.userID
FROM Member INNER JOIN Lot ON Member.userID = Lot.userID
WHERE (Member.sellerExists = 0 OR Member.sellerExists IS NULL)
AND Lot.lotID IN (#ListRest(approvedLots)#)
UPDATE Member
SET sellerExists = 1,
sellerApproved = 1
WHERE userID IN (#ValueList(updateLotsApprovedUser.userID)#)
DELETE FROM Lot
WHERE lotID IN (#ListRest(rejectedLots)#)
DELETE FROM Fee
WHERE lotID IN (#ListRest(rejectedLots)#)
All designated lots either approved or rejected.
Approve Seller-Created Lots
SELECT Lot.lotID, Category.categoryName, Member.username, Lot.lotCloseBasis,
Lot.lotCloseDateTime, Lot.lotCloseInactivity, Lot.lotContactEmail, Lot.lotContactName,
Lot.lotDateTimeCreated, Lot.lotDescription, Lot.lotImage, Lot.lotImageThumbnail, Lot.lotName,
Lot.lotOpenDateTime, Lot.lotOpeningBid, Lot.lotQuantity, Lot.lotQuantityMaximum, Lot.lotReservePrice,
Lot.lotSellPrice, Lot.lotShipping, Lot.lotSummary, Lot.lotBidIncrement
FROM (Category INNER JOIN Lot ON Category.categoryID = Lot.categoryID)
INNER JOIN Member ON Lot.userID = Member.userID
WHERE Lot.lotCloseQueue = -1 AND Lot.lotType
= 1 <> 0
ORDER BY Lot.lotContactName, Lot.lotOpenDateTime
There are no users or lots awaiting approval at this time.