Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 MOD: Auction v1.2		  New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 4

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 26 April 2010 :  04:37:45  Show Profile  Reply with Quote
Hello,

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.
Cheers,

David Greening

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 26 April 2010 :  04:43:46  Show Profile  Reply with Quote
I almost forgot to mention that I Language Packed the MOD for the International users so they can change the text on each page easy.
Cheers,

David Greening
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 27 April 2010 :  10:28:20  Show Profile  Visit bobby131313's Homepage  Reply with Quote
This sounds awesome, I will be looking into it. Is there a demo somewhere?
Switch the order of your title tags
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 27 April 2010 :  11:23:25  Show Profile  Reply with Quote
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
Edited by - Carefree on 18 June 2010 09:40:08
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts
Posted - 28 April 2010 :  13:46:38  Show Profile  Visit Etymon's Homepage  Reply with Quote
Thanks Classic for the MOD! Looks great!
Go to Top of Page

Giumer
Junior Member

Italy
163 Posts
Posted - 29 April 2010 :  01:34:48  Show Profile  Send Giumer an ICQ Message  Reply with Quote
hi all me test yuo mod mate is very nice i have 1 problem is this and me look item and go for bid , i have this error :

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'cDbl'

/forum1/auction_bidItem.asp, line 77


forum is this http://www.darksid.net/forum1/auction_item.asp?intAuctionID=1 User : test pass: demo thx
=======================
http://www.Giumer.it/forum

=======================
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 29 April 2010 :  06:29:46  Show Profile  Reply with Quote
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.
Cheers,

David Greening
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 29 April 2010 :  07:19:36  Show Profile  Reply with Quote
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.
Go to Top of Page

Giumer
Junior Member

Italy
163 Posts
Posted - 29 April 2010 :  10:17:49  Show Profile  Send Giumer an ICQ Message  Reply with Quote
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 ?
=======================
http://www.Giumer.it/forum

=======================
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 29 April 2010 :  18:12:48  Show Profile  Reply with Quote
quote:
Originally posted by Giumer

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.
Go to Top of Page

Giumer
Junior Member

Italy
163 Posts
Posted - 30 April 2010 :  10:13:30  Show Profile  Send Giumer an ICQ Message  Reply with Quote
thx carefree snif error '80020009'
/forum1/auction_my_bid.asp, line 139

use thi accaunt user test pass test
=======================
http://www.Giumer.it/forum

=======================
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 30 April 2010 :  16:16:31  Show Profile  Reply with Quote
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 & _

Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 30 April 2010 :  19:59:41  Show Profile  Reply with Quote
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.
Cheers,

David Greening
Go to Top of Page

Giumer
Junior Member

Italy
163 Posts
Posted - 01 May 2010 :  00:41:18  Show Profile  Send Giumer an ICQ Message  Reply with Quote
nope ! error is this :
error '80020009'
/forum1/auction_my_bid.asp, line 147

and line this : Response.Write " <tr>" & vbNewLine & _
=======================
http://www.Giumer.it/forum

=======================
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 01 May 2010 :  01:27:24  Show Profile  Reply with Quote
Did you download the new version I have put up and ran the new dbs file? I get all the stuff working.
Cheers,

David Greening
Go to Top of Page

Giumer
Junior Member

Italy
163 Posts
Posted - 01 May 2010 :  02:52:16  Show Profile  Send Giumer an ICQ Message  Reply with Quote
thx for help mate link for new version not download ! give me plz link for download new version ! thx
=======================
http://www.Giumer.it/forum

=======================
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07