Author |
Topic |
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 27 May 2014 : 16:13:38
|
I know why, as I only updated the SnitzBitz.com copy and not the temporary one. Removing it from the server now.
I had thought about the "Buy Now" and this would required a heap of coding to be done and defeats the purpose of the Auction Mod, so will not be adding it in as there is a Classifieds Mod for buying items already.
|
Cheers, David Greening |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 27 May 2014 : 16:29:17
|
Would it be much trouble to add a means for members to upload a picture of the item? I know they can upload the picture to a post and then use the link but it would obviously be convenient for them to be able to upload in the auction area.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 30 May 2014 : 02:59:22
|
I listed a few test items for the auction. The first listed item is scheduled to end on today's date. However; when I click to leave feedback, I receive this error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 5.1 Driver][mysqld-5.5.28]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5 DATEBUYER, BUYERCOMMENT FROM FORUM_AUCTIONFEEDBACK WHERE SELLERID = 155 ORDER ' at line 1
/fp/auction_feedback.asp, line 198
Here are lines 197 - 207.
strSql="SELECT TOP 5 DATEBUYER, BUYERCOMMENT FROM " & strMemberTablePrefix & "AUCTIONFEEDBACK WHERE SELLERID = " & FeedbackID & " ORDER BY DATEBUYER DESC" set rsTop5=my_Conn.Execute(strSql) if not rsTop5.EOF then xx=0 rsTop5.MoveFirst do until rsTop5.EOF Response.Write "<br>" & rsTop5("BUYERCOMMENT") xx=xx+1 if xx<5 then Response.Write " " else
I probably should have stated that it's not my admin account I am trying to leave feedback for.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 30 May 2014 03:01:30 |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 30 May 2014 : 04:49:55
|
Hello MaGraham,
Can you please try this auction_feedback.asp and let me know how it goes?:
|
Cheers, David Greening |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 30 May 2014 : 12:28:59
|
Hi, David. I am clicking on the listed item and in the next screen in the "Seller Feedback" area I am clicking on the "Member's Name" but all I am seeing is this below (no error now after using your auction_feedback.asp above). Shouldn't there be something in this area, a button or a link, for me to click on to leave feedback?
Note: A score of 10 is the highest possible score with 1 being the lowest score The closer a Seller's reputation is to 10.0 the better the reputation A score of 0 means the Seller has not received any Feedback currently
Number of Feedbacks received as a Seller: 0 Average Feedback score as a Seller: 0
Last 5 Comments received as a Seller:
Number of Feedbacks received as a Buyer: 0 Average Feedback score as a Buyer: 0
Last 5 Comments received as a Buyer:
Total Average Feedback score (as Buyer and Seller):
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 30 May 2014 12:42:17 |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 31 May 2014 : 21:34:56
|
David, this seems to be working fine now. Thank you so much for all of your help!
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 01 June 2014 : 03:09:27
|
Cool.. I have changed a couple of things in the .zip file as I did not like that it did not show the winning bidder but what they won, so put the name and link back to their profile. It is only cosmetics as well.
|
Cheers, David Greening |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 01 June 2014 : 07:02:44
|
Oh, that sounds great! Thank you, David!
I think I will download the revised version if you are finished with it?
Question: How long does an item display once the "Auction Ended" is displayed?
Just a FYI with these:
- After initial installation and/or any database updates, I always receive this error here when adding a new category.
- Also, when adding a new category, if you don't add two categories (for an even number of categories) it causes dis array in the table columns. That may be an MySQL issue.
- It would be nice, if you make changes in the future, if it listed the categories in alphabetical order so we wouldn't have to do that manually. Just sayin'.
- Also, if you make changes in the future, it would be nice to have the option to list an item for 30 days in hopes more members would see the listed item.
- If you make changes in the future it would be nice for members to have the ability to upload an image rather than having to upload it to a post first. Just sayin'.
- It would also be nice, when listing an item (if you make changes in the future), if there were fields for:
Condition of Item (would be great to have a drop-down menu here like you have for "Auction Length" with options for: As is, Poor, Fair, Good, Like New, New Item)
Shipping Price (including Shipping Method)
Payment Method(s) Accepted (would be great to have a drop-down menu here as well with payment options)
Returns (with drop-down menu here as well for number of days allowed for return)
Guarantee (with possibly "No DOA" to appear as the default unless member removes it and types any guarantee they might offer.)
Delivery (Date estimated)
Item Location
Buy Now Price (in addition to the "Opening Bid" field.) Couldn't a member place a bid for the item with the "Buy Now Price" in order to skip the bidding process and simply purchase the item? The seller could then edit the item and choose "End Auction."
Your auction really is a good addition, David. Thank you so much for your hard work in doing this mod for us! I'll do a mod review later.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 01 June 2014 09:18:44 |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 01 June 2014 : 16:35:56
|
Hi MaGraham,
Please see my answers after each of your questions/comments:
quote: Originally posted by MaGraham
I think I will download the revised version if you are finished with it?
I am finished with it now.
quote: Originally posted by MaGraham
Question: How long does an item display once the "Auction Ended" is displayed?
Until it is deleted by the poster or the admin.
quote: Originally posted by MaGraham
- After initial installation and/or any database updates, I always receive this error here when adding a new category.
Fixed that and updated the code now.
quote: Originally posted by MaGraham
Also, when adding a new category, if you don't add two categories (for an even number of categories) it causes dis array in the table columns. That may be an MySQL issue.
I don't have that issue at all with the tables, they display fine for me. I am testing on a fresh blank Snitz Forum 3.4.07 with MySQL backend (to fix the DB issues) with no issues in the display.
quote: Originally posted by MaGraham
It would be nice, if you make changes in the future, if it listed the categories in alphabetical order so we wouldn't have to do that manually. Just sayin'.
This has now been fixed to list them in alphabetical order.
quote: Originally posted by MaGraham
Also, if you make changes in the future, it would be nice to have the option to list an item for 30 days in hopes more members would see the listed item.
Added both 30 days and 21 days for you, but I think that this would be to long for an action.
quote: Originally posted by MaGraham
If you make changes in the future it would be nice for members to have the ability to upload an image rather than having to upload it to a post first. Just sayin'.
I have not added this as I know a heap of people that have space issues with their sites and do not want to give a chance for users to fill up sites disk space, after all there are a heap of free online image hosts out there.
quote: Originally posted by MaGraham
It would also be nice, when listing an item (if you make changes in the future), if there were fields for:
Condition of Item (would be great to have a drop-down menu here like you have for "Auction Length" with options for: As is, Poor, Fair, Good, Like New, New Item)
Shipping Price (including Shipping Method)
Payment Method(s) Accepted (would be great to have a drop-down menu here as well with payment options)
Returns (with drop-down menu here as well for number of days allowed for return)
Guarantee (with possibly "No DOA" to appear as the default unless member removes it and types any guarantee they might offer.)
Delivery (Date estimated)
Item Location
Buy Now Price (in addition to the "Opening Bid" field.) Couldn't a member place a bid for the item with the "Buy Now Price" in order to skip the bidding process and simply purchase the item? The seller could then edit the item and choose "End Auction."
I may implement some of the items, but not all. For example, I think that "Condition of Item" and "Item Location" is fine, but Shipping, Payment, Guarantee and the Delivery Estimated should be kept private between buyer and seller and that is why I left the e-mail link there.
I don't want to add the "Buy Now Price" as it is an auction and not a classifieds (as there is already a mod for that: Classifieds).
Enjoy the mod and I will see about adding the extra's in when I get back from my Europe trip in 6 weeks. (I cannot promise I will have it done by then.) |
Cheers, David Greening |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 02 June 2014 : 20:52:27
|
Thank you, David!
Be safe as you travel.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 03 June 2014 : 05:36:09
|
Where are you traveling? I've been in every European country at least once, most of them many times; but it has been a very long time. My daughter is trying to beat my traveling record, I think. She's been in at least 30 countries in the last 2 years. |
|
|
Maxime
Average Member
France
521 Posts |
Posted - 03 June 2014 : 08:21:23
|
Hello Carefree,
Have you visited France and which region, Paris, Lyon, Marseille, the Alpes etc? |
Cordially, Maxime
Taxation consists in so plucking the goose to get the most out of feathers with the least possible cries.(Jean-Baptiste Colbert)
|
Edited by - Maxime on 03 June 2014 12:53:51 |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 04 June 2014 : 01:32:03
|
Yes, I've been there. Paris, Marseille, Lyons, Bordeaux, Toulouse, Reims, Grenoble, and a few dozen more that I cannot remember well. Also skied in the Alps (Austria, France, Germany, Italy, Switzerland, etc.) |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 04 June 2014 : 03:28:14
|
Both the wife and I are travelling on the following path, leaving for the trip on Sunday (Melbourne, Australia time) evening. Looking forward to it. Google Maps |
Cheers, David Greening |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 04 June 2014 : 05:07:12
|
Liechtenstein is it's own country, they used to have pretty strict immigration rules, not sure how the laws are now. You cannot even get there from Germany; must go through either Switzerland or Austria since those two countries completely surround it. |
|
|
Topic |
|
|
|