We need a c# executable script along with its source code to do the following:
1- Use Mysql database to query MSN usernames and passwords from our existing mysql table
2-the script will get the info and start accessing the msn list of the users, grab their email list and store them in another table.
3- After accessing each user a flag need to be updated in the user table to make sure that he has been process so next time we run the program it will not be selected.
4- Another fields need to be implemented to collect the information about if the user msn information was correct or not
5- The program needs to handle the timeout and make sure there is a sleep time between each msn access so it will not be blocked.
6- The msn emails list for each user will be stored in another table, two main fields will be inserted the original user email and the grabbed emails- the original user email will be duplicated but its fine
We have this program up and running in PHP but the problem is it timeout, its uses sockets to connect to msn but I stop every 15min and we need to reset it manually. So figuring out how to handle thousand of emails with this C# application without getting blocked or timed out or knowing how to resetting the application automatically, is the goal of this script
We can provide the structure of the two mysql tables and small set of user info for testing.
we have attached the structure of the two mysql tables