;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;  MarXet by WolfkillArcadia
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[createNewListing]
SQL1_1 = INSERT INTO marxet SET listingID = ?, itemAvailable = ?, itemArray = ?, price = ?, sellerUID = ?
Number Of Inputs = 5
SQL1_INPUTS = 1,2,3,4,5

[getListings]
SQL1_1 = SELECT listingID, itemAvailable, itemArray, price, sellerUID FROM marxet
Number Of Inputs = 0
OUTPUT = 1-STRING,2,3,4-STRING,5-STRING

[updateListing]
SQL1_1 = UPDATE marxet SET itemAvailable = 0 WHERE listingID = ?
Number Of Inputs = 1
SQL1_INPUTS = 1

[deleteListing]
SQL1_1 = DELETE FROM marxet WHERE listingID = ?
Number Of Inputs = 1
SQL1_INPUTS = 1

[restrictOldListings]
SQL1_1 = UPDATE marxet SET sellerUID = 0 WHERE created_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND sellerUID != 0
Number of Inputs = 1
SQL1_INPUTS = 1

[deleteOldListings]
SQL1_1 = DELETE FROM marxet WHERE created_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND sellerUID = 0
Number of Inputs = 1
SQL1_INPUTS = 1

[getListingsCount]
SQL1_1 = SELECT COUNT(listingID) FROM marxet WHERE sellerUID = ?
SQL1_INPUTS = 1
OUTPUT = 1