dcsimg
www.webdeveloper.com
Results 1 to 3 of 3

Thread: Stopping multiple submissions

  1. #1
    Join Date
    Mar 2003
    Location
    Somewhere on Planet Earth, I hope.
    Posts
    987

    Stopping multiple submissions

    Hello there.

    I hope you can help me please with a big of "forward planning" we're considering.

    We have just launched a new custom made script which we use for Support, when each
    new Support ticket is opened it's inserted into a MySQL database and therefore
    awaiting staff viewing. Immediately an email is sent to the user detailing their
    unique ID, and a link to "open" their ticket from a user script which lets them
    add replies to the ticket.

    This is all working perfectly, but one thing that concerns me is they could post
    loads of information, repeatidly, and therefore put strain on the server and MySQL
    server.

    Is there a possible piece of code I can include in the script that would stop
    multiple submissions to the same ID? Let's say ... 2 per hour? Not only for replying
    a ticket they made, but from the original form too? Is it possible to "block" an IP
    and echo out a message that they cannot submit a new ticket, or update one for the
    required time:submission ratio?

    Many thhanks for any advice.

  2. #2
    Join Date
    Feb 2005
    Location
    Tauranga
    Posts
    2,062
    that logic eludes me? say you block them for a min 2 hours posting a request withthe ticket Id. What if you reply right away (which would be cinsidered good service) and they reply to that (thanking you, or asking more questions?

    I would be blocked.

    But the answer is yes, set a time on the ticket machine the ticket ID and ip address. then check time differnce between posting

  3. #3
    Join Date
    Jun 2006
    Posts
    58
    If I understand the situation correctly there are a number of fairly easy ways to prevent someone from over-posting. Probably the most obvious would be to simply timestamp the entries in the database. This way whenever you get a submission it takes only a small piece of logic to first check if that user has posted to this ticket within the last hour, two hours, whatever time frame you want. If the user has posted too recently you simply redirect them to an error page explaining the problem. The obvious trap to avoid here is to make sure that you are only blocking users from over-posting and not your support people.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles