ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Help with a simple silent auction

December 11, 2011 1:12pm

Subscribe [4]
  • #1 / Dec 11, 2011 1:12pm

    I’m building a website for a client who wants a simple silent auction built into the website. After a user signs in, he/she can place a bid on a painting (a channel entry). The highest current bid (only the amount) is displayed for anyone to see. The administrator can obviously view all of the bids. I’m stuck deciding on the best way to go about this. Should I use the built-in comment module, or some sort of form submission? How would I go about displaying the highest bid? Can this be achieved with a sql query? It would also be great if I could send automated notification emails to someone when they have been outbidded. Thanks for your help!

  • #2 / Dec 11, 2011 6:19pm

    Boyink!

    5011 posts

    Simple answer is use comments, turn on moderation, and the moderator gets to watch the comments coming in setting the high bids visible on the site.

    Past that?  I’d use eBay. Sending outbid emails etc would require a custom module.

  • #3 / Dec 12, 2011 10:19am

    Hi, thanks for the reply. I considered the ebay route, but really would prefer creating a single product that does everything the client wants. The system doesn’t need to process payments, as that would all be done privately between the buyer and seller. If I can’t create another method, I will most likely go the comments route, where the administrator changes the high bid manually.

    In my head, I see something like this potentially working: I use Freeform as my bid submission system. Upon bidding/filling out a form, the member is added to an email list for that auction. If someone enters a bid that is a smaller numerical amount than the highest value, a custom (php?) script will return a message saying they must increase their bid and the form is not processed. However, if the value submitted is greater, the form is processed, and an email is sent to everyone who has bid so far. (As I’m writing this, I realize that email would also go to the person who just bid, which might be an issue).

    To display the highest bid, I would query the submitted forms. Something like:
    SELECT TOP 1 bids
    FROM auctionname
    ORDER BY bids DESC;

    I’m a newbie to scripting, so I might just be really optimistic about it accomplishing all of my wildest dreams. I would love it if someone who isn’t a newbie might comment on the feasibility of this. Thanks again!

  • #4 / Jan 25, 2012 2:20pm

    Matalin

    10 posts

    Hi, you might be interested in this article on building an auction addon.. http://ee-recipes.com/articles/details/our-first-module-part-1

  • #5 / Jan 26, 2012 11:00am

    Beautiful. I’ll take a more in-depth look at that next chance I get. Thanks!

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases