Hello,
I find my self in the following situation. My implementation of osTicket requires that users enter a Receipt Number showing that they have made the required payment making them eligible for services. whilst hardcopies were hard to forge since we would retain the original, entering a number has created problems for us since people have started reusing previous numbers for more than once. this has lead to a requirement to change the field receiptnumber to a unique one, so that a number can only be entered once. in this, i have two requirements
a script to do form validation when the user is entering the number
database validation, when the form script checks the DB to see if it has been entered before.
in doing this, i encountered a problem where this recieptnumber column has duplicate values. my intention is to set ticketID=recieptnumber for all rows where recieptnumber=0 in the table ost-ticket (because the ticketID is uniquee for all rows)
my requests
code for form validation
SQL query for updating my ost_ticket.recieptnumber where its equal to 0
I would totally appreciate assistance in this.
Regards
Emmanuel
