comparison sheep.pl @ 22:552528bb4917

refined the cache timeout is 12 hours.
author "Rex Tsai <chihchun@kalug.linux.org.tw>"
date Wed, 08 Oct 2008 19:27:54 +0800
parents fd44e3a1f800
children 54ab0becd730
comparison
equal deleted inserted replaced
21:d5e02a25b000 22:552528bb4917
17 AND island.y <= ? 17 AND island.y <= ?
18 AND island.y >= ? 18 AND island.y >= ?
19 AND cities.status = 'i' 19 AND cities.status = 'i'
20 } 20 }
21 ); 21 );
22
22 Ikariam::User->set_sql(sheeps => qq { 23 Ikariam::User->set_sql(sheeps => qq {
23 SELECT user.id 24 SELECT user.id
24 FROM user, cities, island 25 FROM user, cities, island
25 WHERE user.id == cities.user 26 WHERE user.id == cities.user
26 AND cities.island == island.id 27 AND cities.island == island.id