Jump to content

memooney

Members
  • Posts

    8
  • Joined

  • Last visited

Contact Methods

  • Website URL
    http://www.mattmooney.net/

Profile Information

  • Location
    South Bend, IN

memooney's Achievements

Rookie

Rookie (2/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

0

Reputation

  1. Thanks for the suggestions. I have an idea and from the "Server Side" of things I want your opinions. Originally, I was thinking of something along the lines of what Jim suggested. However, I was planning to have an automated way of doing things. So here is my thought. When Sally adds some seats to her cart, it "reserves" the seats in the DB and adds the epoch date. Then if she completes the checkout, it would update to purchased from "reserved." To address the poeple that don't check, I was thinking of using a CRON job to execute a script that would query the DB and look for any "reserved" that are more the 30 minutes old and release those seats. Historically, the classes sell out in about 2-3 hours. So I was planning to have teh CRON job run every 30 minutes on the day the registration opens. Then every 6 hours have that to catch any stragglers. Does that sound like a solution that will work? I haven't used CRON job before, but understand how they work. From the server side of this do you see any problems or concerns in running this CRON job as I've described? Thanks
  2. I guess I'm lost then. How can I control records in the DB with sessions? If the session times out on the user's computer, how does the record get updated in the DB?
  3. I'm setting up an online purchase system for a cooking store. They offer classes for their customers. The classes have a limited size (e.g., 20 people max). In the past, the classes have sold out in a matter of hours. So here is my concern: Let's say Sally wants 2 seats in the Sushi class and 1 seat in the grilling class, and 1 seat in the pastry class. She adds the 2 seats in the Sushi class to her cart, then continues to the grilling class and adds 1 seat for that class to the cart, then on to the pastry class and adds a seat, then wants to check out. It's very likely that if I wait until she checks out to "reserve" those seats for her, someone else will have purchased them. So I need to "reserve" the seats when she adds them to her cart. That's no problem. My concern is, what do I do if she doesn't check out? These seats are pulled from the class, and are now unused. I've got ideas rolling around in my head, but I'm guessing some of you have already faced something like this, so I'm hoping you can save me some time and figuring it out. Basically, I'm adding a record to the DB that pulls the seat when she adds it to the cart. So what do you think the best way is to double check on a regular basis (every 15 minutes or so) that Sally has completed her transaction? Matthew
  4. That's basically what I'm wanting to do. Rather than maintaining another database table of logins/pswds, and having the users use a different login and password, I would like to use the e-mail/pswd created in cPanel. I know it is stored in a file in my account, and the passwords are MD5 encrypted. i'm just wondering if anyone has done this, or knows of a php script I can grab, rather than writing my own. Thanks
  5. Has anyone got an idea on how to use the email/pswd assigned in cPanel as the username/pswd to authenticate access to part of a website. I'm setting up a portal for a client and their employees, and I'd like to be able to use something like this, rather than making them remember another username/pswd? I'm sure there is a way to do this, but I haven't found the answer yet. Thanks Matt
×
×
  • Create New...