Fulltext results:

Travian Map Download Script

5 Hits, Last modified: 12 years ago

echo " `date +'%H:%M:%S'`: ${world}_village" TEMP_TABLE="tmp_${world}_village_${today_}$$" ${MYSQL}... __SQL__ -- -- update villages -- CREATE TABLE ${TEMP_TABLE} ( fid int(11) NOT NULL, x smallint(6) ... T CHARSET=utf8 ROW_FORMAT=COMPACT; INSERT INTO ${TEMP_TABLE} SELECT v.* , h.inactive + ... lage h ON h.vid = v.vid GROUP BY v.vid; UPDATE ${TEMP_TABLE} SET inactive = 0 WHERE population > histor