Consider that in Travian the password identifies you. You might be able to access more than one account with your own password – that is if the owner gives you that option.
Logically the internet connection is therefore linked to the ip address and hence the proxy that is used.
For example suppose my password for account jimh is also used to access account Asuna which is owned by somebody else. That means the same ip address can be used for aceessing Travian with my password.
It is normal for several people to be on a single account and therefore normal to have ip addresses from all over the world.
Tables 1. and 2. are generally how I would store the data, table 3. is also required to avoid using the same proxy for two different passwords (a table of used proxies).
I have the idea that generally 2 proxies would be "open" at any one time.
The idea is that the required code would be an object which could be used by VB, Access or Java for further code to be written. The technology used for this part of the project is open.
The functionality required currently is as follows:
1) return the html for a given web page
2) Update a table containing links with the html (a "batch job" if you like)
3) Hold a link to a page open so that fields can be filled in, buttons pressed etc after being retrieved
In all cases either the password / account will be specified or can be "any" - this allows for faster download if (say) 300 pages are required (as per 2) above
I would expect this normally to be an object “with events” but in the case where only the html is required I would think it is going to be easier for me to give the code a job number and let it fill in tables 4 and 5.
Would it be possible to give some kind of help to know what options there are when trying to navigate to a page and then click a button or fill in fields say?
The last project I posted I will re-activate once I have this core software ;)