Which would be the best way to go?

We have a contract starting soon.
It's a prepaid thing.

Client prepays, then calls support with a pin #
Support sets up an account and emails a link with terms and conditions.

The client has 48 hours to agree to this, before the account is deactivated.

Keep in mind, that the client base is all done in CGI.

Should we continue to use CGI to track the yes or no and delete accounts, or should we use mysql and PHP.

Can this be done easily???

hmmm. i would recommend using php/mysql.. its far more efficient...


plus migrating the dbase to work with php wouldnt be a very big issue...

Is it possible to have a cron job to access the database and deactivate accounts that dont reply, or check no?
or would we need to do this manually... can it be kept secure, so that we would'nt get the database hacked into......( it holds all of the user info including credit card stuff)

Originally posted by MikeM
Is it possible to have a cron job to access the database and deactivate accounts that dont reply, or check no?
or would we need to do this manually... can it be kept secure, so that we would'nt get the database hacked into......( it holds all of the user info including credit card stuff)

It shouldn't be a big deal to schedule a script with cron that will check the database and deactivate accounts that are more than 48 hours old and haven't replied.

The security is another issue, and one that I know far less about. I can say that if you have a database with client info on a web server and someone manages to break into the machine, you're pretty much screwed. I'd be interested in hearing from some hosts about the measures that they take to safeguard the information in their client databases.

-joe

This one is currently on a secure server, but what that entails i have no idea