Author |
Topic |
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 01 May 2010 : 03:04:52
|
In the original message, now at Auction Mod v1.2. |
Cheers, David Greening |
|
|
Giumer
Junior Member
Italy
163 Posts |
Posted - 01 May 2010 : 04:25:49
|
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
======================= |
|
|
Giumer
Junior Member
Italy
163 Posts |
Posted - 01 May 2010 : 04:56:57
|
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
======================= |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 01 May 2010 : 06:01:35
|
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 |
|
|
Giumer
Junior Member
Italy
163 Posts |
Posted - 01 May 2010 : 06:36:36
|
Yeaa ! is ok ! new idea for this mod and is possibol upload immage ? |
======================= http://www.Giumer.it/forum
======================= |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 01 May 2010 : 11:47:00
|
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. |
|
|
Giumer
Junior Member
Italy
163 Posts |
Posted - 01 May 2010 : 12:59:33
|
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
======================= |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 01 May 2010 : 14:28:59
|
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 |
|
|
kyodai
New Member
Azerbaijan
74 Posts |
Posted - 01 May 2010 : 17:32:55
|
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 |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 02 May 2010 : 06:20:31
|
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:
To prevent a user from bidding on their 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 |
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 02 May 2010 : 08:07:54
|
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 |
|
|
kyodai
New Member
Azerbaijan
74 Posts |
Posted - 02 May 2010 : 12:39:32
|
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. |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 03 May 2010 : 07:34:09
|
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. |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 03 May 2010 : 07:36:26
|
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 |
|
|
kyodai
New Member
Azerbaijan
74 Posts |
Posted - 03 May 2010 : 19:42:15
|
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 |
|
|
Topic |
|