I was asked by a few of my users for some Auction software on the site, so I put together a small Auction Mod v1.2
The Auction Mod v1.2 is easy to install and with 10 being easy and 1 being hard, this is a 10.
The Auction Mod v1.2 is fully intergrated into Snitz and e-mails others that have bidded on an item so they (hopefully) don't miss out on the item. I have also allowed visitors to go to the first page of the Auction Mod v1.2 but no further and need to be a logged in member to view items and bid. This has been tested on and MS SQL Database and MS Access only.
I have plans to add in the next release (v2.0) to have Categories, Admin Interface and the abillity to upload images.
Please read the readme in the download and if you have issues, please post in the Help: MOD Implementation forum. E-mails will not be returned. Enjoy.
David, you overlooked a couple potential problems.
The current/minimum bids should be numeric only or your call to "formatnumber" will fail. Should do a check for isNumeric on the querystring calls. Also, those field types in the table should be changed from text to long int.
I made changes to allow admin or the seller to modify or delete an auction item, fixed the numeric bid issue, and fixed the missing image issue. You can change whatever you don't like. Modified Zip File
I will have a look at it on the week-end and redo the edit function that Carefree put together with the code that I originally put together as I ahve found another issue with the current bid in that code. In the mean time I have placed the original one back up that I did as it worked for me.
The error that Giumer encountered is due to the field type and content. You cannot double a text field, must be numeric. If you enter a 3 (without the $ symbol), the error is eliminated. With the changes I made, that problem also is gone.
carefre I tried to put your modified files, but I was always the same error, if you tell me in which file should I do with the change. and me cauntry is € is possibol modification ?
carefre I tried to put your modified files, but I was always the same error, if you tell me in which file should I do with the change. and me cauntry is € is possibol modification ?
Did you change the field types in the database when you replaced the files? If not, you'll need to modify them. If you use my dbs file and re-run it, it will replace your auction tables as necessary.
Look for the following lines in "auction_my_bid.asp" (appx 134-145):
while not rsBuyer.EOF
intAuctionID = rsBuyer.fields.item(0)
rsItem.MoveFirst
rsItem.Find "auctionID = " & intAuctionID
if rsItem("ImgURL") = "http://" then
strImage = strImageURL+"blank.gif"
else
strImage=rsItem("ImgURL")
end if
Response.Write " <tr>" & vbNewLine & _
Change them to say:
while not rsBuyer.EOF
intAuctionID = rsBuyer.fields.item(0)
if not rsItem.EOF then
rsItem.MoveFirst
rsItem.Find "auctionID = " & intAuctionID
if rsItem("ImgURL") = "http://" then
strImage = strImageURL+"blank.gif"
else
strImage=rsItem("ImgURL")
end if
end if
Response.Write " <tr>" & vbNewLine & _
I have updated the code to 1.2 now as there was some issues when placing a bid with some code. I have fixed that and it works fine on MS Access and MS SQL.
MOD: Auction v1.2
Posted - 26 April 2010 : 04:37:45
