Emaze Auction: Admin Screens

Emaze Auction: Admin Screens

SELECT Count(lotID) AS openLotCount FROM Lot WHERE lotCloseQueue = 1 AND lotOpenDateTime <= #CreateODBCDateTime(Now())# SELECT Count(lotID) AS closeQueue FROM Lot WHERE lotCloseQueue = 2
SELECT Count(lotID) AS countApprovalLots FROM Lot WHERE lotCloseQueue < 0 AND lotType = 1 SELECT Count(lotID) AS countApprovalLots FROM Lot WHERE lotCloseQueue < 0 AND lotType = 0 SELECT Count(lotID) AS countApprovalLots FROM Lot WHERE lotCloseQueue < 0 AND lotType = -1
# currently open lots: #getNumOpenLots.openLotCount# (No lots to close at this time) Click here to close lots
# lots waiting to be closed: #getCloseQueue.closeQueue#
# seller-created lots
waiting to be approved: 		#getApprovalLots.countApprovalLots# Click here to approve
seller-created lots. (No seller-created lots
to approve at this time.)
# seller-created classified
items waiting to be approved: 		#getApprovalLots.countApprovalLots# Click here to approve
seller-created classified items. No seller-created classified
items to approve at this time.
## seller-created procure
items waiting to be approved: 		#getApprovalLots.countApprovalLots# Click here to approve
seller-created procure items. No procurement items
to approve at this time.

Users Options System
User Agreement
Registration Emails
Registration Fields
Registration Error Messages
Add/Edit/Verify Headers
Get Password Script
Edit Master User
Import Users
Create Lot Options
Closing Options
Bid Options
Search Options
Reverse Bids
Icon Options
Email Another User
Mail Auction to Friend
Create Category
Templates
Navigation Bar
Page Titles
Help Page
Header, Footer (all pages)
Login Text, Header
List, Status Messages
Bidding Emails
Closing Emails
Daily Status Emails
Reserve Emails
Bid Error Messages
System Variables
Body tag, date/time
Lot Archive
Sellers
Options Fees Create Lot Edit Lot View Bids Page Titles Emails
Charge Headers Registration Fields Registration Headers User Agreement Daily Status
Classified
Options Fees Create Item Edit Item View Buyers
Emails Buying Buy Error Messages Headers Page Titles
Procurement
Options Seller/Buyer Fees Bidder Fees Create Item Edit Item View Bidders
Seller Emails Bidding Emails Closing Emails Bid Results Headers Page Titles
Forums Create Forum Edit/Delete Forum Options/Text Homepage Admin Permissions

Seller username: Lot ID: (1 or 1,2,3) User:
Username Email First name Last name Organization
Lots opening today (yesterday) (tomorrow)
Lots closing today (yesterday) (tomorrow)
Lots currently open
Winning bids on all open lots
Winning bids on all lots closing today (yesterday) (tomorrow)
Delete lots that have been closed for more than X days:
# Days:
    Enter YES in this text field to verify your request:

Choosing to view lots will list all options for that lot. Choosing bids will list the bids for those lots instead.

SELECT categoryID, categoryName FROM Category
Lot Status: Inactive   Preview   Open   Closed  
Order by: Ascending   Descending
View Bids: Winning Bids Only   All Bids
Order by: Ascending   Descending
Lot Opens:  
  Before   On   After
Lot Closes:  
  Before   On   After
Category:
Emaze!