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
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 4

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 01 May 2010 :  03:04:52  Show Profile  Reply with Quote
In the original message, now at Auction Mod v1.2.

Cheers,

David Greening
Go to Top of Page

Giumer
Junior Member

Italy
163 Posts

Posted - 01 May 2010 :  04:25:49  Show Profile  Send Giumer an ICQ Message  Reply with Quote
problem mate for dbs : not good :

[DROP]
AUCTIONBIDS
[END]

[DROP]
AUCTIONITEMS
[END]

[CREATE]
AUCTIONBIDS

AUCTIONID#int#IDENTITY (1,1)#
BUYER#int#NULL#
MAXPRICE#money#NULL#
BIDTIME#varchar(20)#NULL#
[END]

[CREATE]
AUCTIONITEMS
AUCTIONID
SELLER#int#NOT NULL#
ITEMNAME#varchar(150)#NOT NULL#
ITEMDESC#memo#NOT NULL#
IMGURL#varchar(150)#NULL#
OPENINGBID#money#NOT NULL#
CURRENTBID#money#NULL#
STARTDATE#varchar(20)#NOT NULL#
ENDDATE#varchar(20)#NOT NULL#
[END]

valor money

=======================
http://www.Giumer.it/forum

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

Giumer
Junior Member

Italy
163 Posts

Posted - 01 May 2010 :  04:56:57  Show Profile  Send Giumer an ICQ Message  Reply with Quote
Classicmotorcycling
me test yuo mod and yuo site is ok ??? is db or file ? i have db and MYSQL is this problem ?

=======================
http://www.Giumer.it/forum

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

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 01 May 2010 :  06:01:35  Show Profile  Reply with Quote
OK, I have it working on MySQL now as well, re-download the file and over write and re-run the dbs file. I noticed the error on MySQL and also noticed that if the field is an "int" the cents would not be added, so have fixed that.

Cheers,

David Greening
Go to Top of Page

Giumer
Junior Member

Italy
163 Posts

Posted - 01 May 2010 :  06:36:36  Show Profile  Send Giumer an ICQ Message  Reply with Quote
Yeaa ! is ok ! new idea for this mod and is possibol upload immage ?

=======================
http://www.Giumer.it/forum

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

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 01 May 2010 :  11:47:00  Show Profile  Reply with Quote
Giumer, cannot make a PayPal link without knowing the PayPal information of the seller. That is possible, though.

Could add a field for the seller to include his/her PayPal Email address at the time of placing an item in the auction. Then when the auction expires, the buyer would get a "Pay Now" button that would fill in the amount and the seller's PayPal account information.
Go to Top of Page

Giumer
Junior Member

Italy
163 Posts

Posted - 01 May 2010 :  12:59:33  Show Profile  Send Giumer an ICQ Message  Reply with Quote
k mate i ,am wait finish day test for look mod , and finish day for sell and automatic botton bayout ?

=======================
http://www.Giumer.it/forum

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

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 01 May 2010 :  14:28:59  Show Profile  Reply with Quote
Ok, I wrote the PayPal feature in. I haven't used the other one you referred to and don't know the format of it's payment link. For those who use PayPal, this will work.

Zip File

Edited by - Carefree on 18 June 2010 09:40:33
Go to Top of Page

kyodai
New Member

Azerbaijan
74 Posts

Posted - 01 May 2010 :  17:32:55  Show Profile  Reply with Quote
Have added this to my forums and it's looking very good. How about some "Delete auction" button if mLev > 1 (So moderators and above can delete an auction)? I would like to help with that but i am always having tough fights with SQL statements when it comes to stuff like this...


Another idea by me would be a "Buy it now" price along with a BIN button. And maybe some additional table for feedback (So you can see like "Ewww this guy has a feedback score of -5, i wont buy from him).


Another good idea would be to disallow users to bid on their own item.

Also maybe show the seller name or - in future maybe - his auction feedback. I think it is important to know from whom you are buying something.


EDIT: Found a bug, a quite serious one. Try putting like "I don't care" in the auction description. SPOILER: The problem here seems to be the ' character. It smashes the whole SQL query. I SMELL SQL INJECTION!

How can such stuff be properly escaped?

Edited by - kyodai on 01 May 2010 19:22:35
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 02 May 2010 :  06:20:31  Show Profile  Reply with Quote
Most important first. In "auction_save.asp", look for the following line (appx line 96):

strDesc = cstr(Request.form("strDesc"))


change it to say:

strDesc = chkString(cstr(Request.form("strDesc")), "SQLString")



Then, in order of comments:

The delete auction capability already exists for the person placing the auction. Note: I made a programming error on the initial version of this, please replace the code. To add moderator & admin ability, follow instructions below. To add admin only, change the mLev number from 3 to 4:


In "auction_edititem.asp", look for the following line (appx 131):

			strSql="DELETE * FROM "& strTablePrefix & "AUCTIONITEMS WHERE AUCTIONID="&AuctionID&" AND (SELLER="&SELLER&" OR SELLER="&intAdminMemberID&")"

Change it to say:

			if mLev < 3 then
				strSql="DELETE * FROM "& strTablePrefix & "AUCTIONITEMS WHERE AUCTIONID=" & AuctionID & " AND (SELLER=" & SELLER & ")"
			else
				strSql="DELETE * FROM "& strTablePrefix & "AUCTIONITEMS WHERE AUCTIONID=" & AuctionID
			end if


Then look for the following line (appx 88):

			strSql="SELECT * FROM "& strTablePrefix & "AUCTIONITEMS WHERE AUCTIONID=" & AuctionID & " AND (SELLER=" & SELLER & " OR SELLER=" & intAdminMemberID & ")"

Change it to say:  

			if mLev < 3 then
				strSql="SELECT * FROM "& strTablePrefix & "AUCTIONITEMS WHERE AUCTIONID=" & AuctionID & " AND (SELLER=" & SELLER & ")"
			else
				strSql="SELECT * FROM "& strTablePrefix & "AUCTIONITEMS WHERE AUCTIONID=" & AuctionID
			end if

Then, in "auction_my_bid.asp", look for the following line (appx 105):

		if strBuyer > "" or MemberID = intAdminMemberID then

Change it to say:

		if strBuyer > "" or mLev > 2 then


To prevent a user from bidding on their own auction:


In "auction_biditem.asp", look for the following line (appx 79):

Application.Lock

ABOVE IT, insert the following:

'	Prevent Seller from Bidding
strSql="SELECT SELLER FROM " & strTablePrefix & "AUCTIONITEMS WHERE AUCTIONID=" & intAuctionID
set rsCheck=my_Conn.Execute(strSql)
if not rsCheck.EOF then
	intSeller=cIint(rsCheck("SELLER"))
	rsCheck.Close
end if
set rsCheck = Nothing
if intSeller = MEMBERID then
	Response.Write	"<table border=""0"" width=""100%"" cellspacing=""0"" cellpadding=""0"" align=""center"">" & vbNewLine & _
		"	<tr>" & vbNewLine & _
		"		<td align=""center"">" & vbNewLine & _
		"			<font color=""" & strDefaultFontColor & """ size=""" & strDefaultFontSize & """ face=""" & strDefaultFontFace & """>" & strLang_Auction_00517 & "" & vbNewLine & _
		"			</font>" & vbNewLine & _
		"		</td>" & vbNewLine & _
		"	</tr>" & vbNewLine & _
		"</table>" & vbNewLine & _
		"<meta http-equiv=""Refresh"" content=""3; URL=auction.asp"">" & vbNewLine
	Response.End
end if


Then, in "auction_language.asp", look for the following line (appx 130):

strLang_Auction_00516 = "reserves the right to refuse or delete any auction listing at any time"

Below it, insert the following:

strLang_Auction_00517 = "Cannot bid on own auction."


To make a "buy it now" option, we'll have to add another field to the auction table to specify a minimum amount for which the seller will be satisfied. That won't be too difficult, but I don't have time now.


As for feedback, that's a whole additional project.

I have updated the zip file in my first reply with the code changes.

Edited by - Carefree on 02 May 2010 06:39:12
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts

Posted - 02 May 2010 :  08:07:54  Show Profile  Visit bobby131313's Homepage  Reply with Quote
OK, how tough would a "watch" function be? I see there is an outbid email that goes out so hopefully not too hard.

By "watch," I mean a non-bidding member is interested and clicks the watch button, then they get an email when there are bids.

Switch the order of your title tags

Edited by - bobby131313 on 02 May 2010 08:08:21
Go to Top of Page

kyodai
New Member

Azerbaijan
74 Posts

Posted - 02 May 2010 :  12:39:32  Show Profile  Reply with Quote
Thanks for the update carefree.

I have tried it out but i only see the delete button in "Auctions I am selling", so although i am admin i can only delete my own auctions. Or did i miss the delete button? How do i delete another users auction?

Feedback would be cool, definitely would make the whole thing better.

How about the sellers name in the auction? I think that would be quite easy, right?
Also cool would be like "All auctions from (Seller name)" as a link or button.


Anyways, good work on this.
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 03 May 2010 :  07:34:09  Show Profile  Reply with Quote
quote:
Originally posted by bobby131313

OK, how tough would a "watch" function be? I see there is an outbid email that goes out so hopefully not too hard.

By "watch," I mean a non-bidding member is interested and clicks the watch button, then they get an email when there are bids.



I'm travelling now, so I won't be writing mods for a bit, but that wouldn't be too difficult ... a simple modification of the subscription routine.
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 03 May 2010 :  07:36:26  Show Profile  Reply with Quote
quote:
Originally posted by kyodai

Thanks for the update carefree.

I have tried it out but i only see the delete button in "Auctions I am selling", so although i am admin i can only delete my own auctions. Or did i miss the delete button? How do i delete another users auction?

Feedback would be cool, definitely would make the whole thing better.

How about the sellers name in the auction? I think that would be quite easy, right?
Also cool would be like "All auctions from (Seller name)" as a link or button.

Anyways, good work on this.



You need to look at the "my auction items" page to see the controls. But if you used the latest changes, admins should have edit and delete access to all auctions.

Displaying the seller's name would be very simple & a list of auctions is also fairly easy. When I get to my next destination, I'll try and get these done if nobody else has.

Edited by - Carefree on 05 May 2010 09:22:24
Go to Top of Page

kyodai
New Member

Azerbaijan
74 Posts

Posted - 03 May 2010 :  19:42:15  Show Profile  Reply with Quote
Here is a mini update i made to auction_item.asp

It now shows the time left and the current forum time at the bottom of the page as users frquently asked what the current time is, which time zone and stuff. This looks bad and its displaying the time left in seconds (which is not that great looking if its like 7 days left), but maybe something to base on?


Here it is:

http://www.tankraider.com/userup/1273013335.zip



Edit: i think there might be a difference between "NOW" and the forum time. However, i used "now" as it seemed easy to be used. I am sure some pros here know how to make it better.

Edited by - kyodai on 03 May 2010 19:44:11
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Previous Page | 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.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07