| Travian Farming Tutorial: Quickly find nearby villages with inactive players and grab their resources. Import Travian map.sql files with OpenOffice Calc&Base in less than 10 mins to view nearby villages' populations, and their population growth. Reasonably up-to-date maps (maps of all villages on a server) can be downloaded from Travian servers - for FREE! Properly sorted, these files contain a wealth of information. What villages are the nearest neighbours? How fast have their populations been growing? Find your server in this list (travian.wikia.com - hint: look at the address bar while you're playing the game. Add /map.sql to the server name and you have the link to download the map. For example: s7.travian.com s2.travian.au Maps usually update once a day, so downloading and storing maps every 2-3 days gives you a good timeline of village populations to work with. Please comment if you need help or have suggestions, like the vid if this helped! Screencapped with: CamStudio sourceforge.net Edited with: Microsoft Movie Maker map.sql import with: www.OpenOffice.org Played with www.Travian.com Notes ------ (108, -62) = location of example village that's why you see ("X"-108) * ("X"-108) + ("Y"+62) * ("Y"+62) in the SQL. eg. If your village is at (64, 92) then use: ("X"-64) * ("X"-64) + ("Y"-92) * ("Y"-92) Some text strings you'll want to Copy&Paste as you follow the video: \\ \' INSERT INTO `x_world` VALUES ( ); Headings of the columns pasted at row 1 of Calc spreadsheet ... |