Emaze Auction: Seller Status
UPDATE Member
SET sellerApproved = 1
WHERE userID = #ListGetAt(newStatusApproved,2)#
OR userID = #ListGetAt(newStatusApproved,statusCount)#
- The following user IDs were updated to Approved status:
- #ListRest(newStatusApproved)#
UPDATE Member
SET sellerApproved = 0
WHERE userID = #ListGetAt(newStatusProbation,2)#
OR userID = #ListGetAt(newStatusProbation,statusCount)#
- The following user IDs were updated to Probation status:
- #ListRest(newStatusProbation)#
UPDATE Member
SET sellerApproved = -1
WHERE userID = #ListGetAt(newStatusBanished,2)#
OR userID = #ListGetAt(newStatusBanished,statusCount)#
- The following user IDs were updated to Banished status:
- #ListRest(newStatusBanished)#
Seller statuses updated.
Seller Status
SELECT firstName, lastName, email, userID, sellerApproved, username
FROM Member
WHERE sellerExists = 1
There are no sellers at this time.