I have two scripts to complete. They are half way written but I need these completed ASAP. Very short. Both are ran from the command line.
1. It takes an argument of file number followed by and email address. It should be able to accept multiple file numbers separated by commas. (it grabs the person who ran the command user id) Then it attempts to make a database connection to a mysql host and insert the file number, email address, requester, and a flag into a table. If it successfully works it prints a response to the command line saying it was successful. If it fails it reports a failure. In either case it logs into a file. (test)
2. This script runs via crontab. It will simply query the table looking for anything that is flagged as new and attempts to copy the numbered file to a remote host. If it works it send an email saying that it successfully completed. If not it sends a failure notice. In either case it logs to a file. (test1)
Please include standard error handling, etc.
25 freelancers are bidding on average $102 for this job
This sounds like an interesting script, and I love scripting languages. The scripts you provided are not very well written, they even have an SQL injection vulnerability. I can do much better than this.