This project will be to adapt to an existing PHP script which I recently brought that...
*runs on a cron job to check whether a merchant has a product in stock, by grabbing the page and checking if a "stockword" is present
* adds this data to a MYSQL database
The script has a simple front-end where current stock is shown, and a separate page where stock history is shown. With a admin back-end where you can change the URLs to check, as well as merchant details.
With the script I got a PDF which explains how the script works, message me if you want to see the PDF, i will link it so you can view it to have a good understanding how the current script is. I will provide the actual PHP script which the additions will be built apon to the successful bidder.
*Addons to script
The functionality I would like done to this script is just like the website [login to view URL], with email, twitter and audio alerts, where users can subscribe to a specific product and sign up for email alerts every time the stock changes to 'in-stock' for a specific product. Or whilst the user is on the page, they tick a box and every-time the product changes to in-stock the page makes a small audio sound. Where the 3rd option is the user can enter their twitter username to subscribe to twitter alerts once the product changes to 'in-stock' the script tweets all the users who have subscribed to that specific product. If you check the above website you will see what I mean with the email and audio alerts, but not the twitter function.
The other functionality I would like is to have more tables within one database for different products, because at the moment the script only allows 3 tables in a database. Because if you try and have two, the tables within the database have the same name and will not function, so the supplied SQL query needs slightly changing to add different table names every-time a new product is added.
Any additional info, just message me I'll try and answer any questions you may have.