# 1/1 Cache ---------------------------------------------------------------
	SQLSTART
	  #				 1
	  SQL_SQL select count(gc.id)
	  SQL_SQL from geocache gc
	  SQL_SQL where gc.dtfound>0 and gc.difficulty = 1 and gc.terrain = 1
	  #
	  OUTVALUETYPE NUM	
	  SQL_CMD COLUMN EVALLOCALVAR five return(%1%)
	  OUTVALUETYPE ASCII
	  #	  
	  SQL_CMD COLUMN EVALLOCALVAR gif return(((%1% > 14) && (%1% < 20)) ? 'B' : 
	  SQL_CMD_CONTINUE ((%1% > 19) && (%1% < 30)) ? 'S' : 
	  SQL_CMD_CONTINUE ((%1% > 29) && (%1% < 50)) ? 'G' : 
	  SQL_CMD_CONTINUE ((%1% > 49) && (%1% < 80)) ? 'P' : 
	  SQL_CMD_CONTINUE ((%1% > 79) && (%1% < 120)) ? 'R' : 
	  SQL_CMD_CONTINUE ((%1% > 119) && (%1% < 180)) ? 'Sa' : 
	  SQL_CMD_CONTINUE ((%1% > 179) && (%1% < 300)) ? 'E' : 
	  SQL_CMD_CONTINUE (%1% > 299) ? 'D' : 
	  SQL_CMD_CONTINUE 'Gray')
	  SQL_CMD COLUMN EVALLOCALVAR titl return(('%gif%' eq 'B') ? 'Bronze (15-19)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'S') ? 'Silver (20-29)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'G') ? 'Gold (30-49)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'P') ? 'Platinum (50-79)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'R') ? 'Ruby (80-119)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'Sa') ? 'Sapphire (120-179)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'E') ? 'Emerald (180-299)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'D') ? 'Diamond (300+)' : 
	  SQL_CMD_CONTINUE 'None (0-14)')
	  SQL_CMD COLUMN EVALLOCALVAR ggif return('<img src="%GGS_URL%Lazy%gif%.png" width="%GGS_PSIZE%" title="The Lazy Geocacher - #%1%/%titl%" /> ')
    SQLEND
	# test na GOLD
	EVALLOCALVAR GGS_GOLD return(('%gif%' eq 'G') ? GGS_GOLD + 1 : GGS_GOLD)
	#potlaceni vystupu
	EVALLOCALVAR ggif return((%GGS_CACHEDIFFTERR% eq '0') ? '' : '%ggif%')
	#
	EVALLOCALVAR GGS_B return(('%gif%' eq 'B') ? '%GGS_B%%ggif%' : '%GGS_B%')
	EVALLOCALVAR GGS_S return(('%gif%' eq 'S') ? '%GGS_S%%ggif%' : '%GGS_S%')
	EVALLOCALVAR GGS_G return(('%gif%' eq 'G') ? '%GGS_G%%ggif%' : '%GGS_G%')
	EVALLOCALVAR GGS_P return(('%gif%' eq 'P') ? '%GGS_P%%ggif%' : '%GGS_P%')
	EVALLOCALVAR GGS_R return(('%gif%' eq 'R') ? '%GGS_R%%ggif%' : '%GGS_R%')
	EVALLOCALVAR GGS_Sa return(('%gif%' eq 'Sa') ? '%GGS_Sa%%ggif%' : '%GGS_Sa%')
	EVALLOCALVAR GGS_E return(('%gif%' eq 'E') ? '%GGS_E%%ggif%' : '%GGS_E%')
	EVALLOCALVAR GGS_D return(('%gif%' eq 'D') ? '%GGS_D%%ggif%' : '%GGS_D%')
    EVALLOCALVAR GGS_Gray return(('%gif%' eq 'Gray') ? '%GGS_Gray%%ggif%' : '%GGS_Gray%')	
	# T5 ---------------------------------------------------------------
	SQLSTART
	  #				 1
	  SQL_SQL select count(gc.id)
	  SQL_SQL from geocache gc
	  SQL_SQL where gc.dtfound>0 and gc.terrain = 5
	  #
	  OUTVALUETYPE NUM	
	  SQL_CMD COLUMN EVALLOCALVAR five return(%1%)
	  OUTVALUETYPE ASCII
	  #	  
	  SQL_CMD COLUMN EVALLOCALVAR gif return(((%1% > 4) && (%1% < 10)) ? 'B' : 
	  SQL_CMD_CONTINUE ((%1% > 9) && (%1% < 20)) ? 'S' : 
	  SQL_CMD_CONTINUE ((%1% > 19) && (%1% < 30)) ? 'G' : 
	  SQL_CMD_CONTINUE ((%1% > 29) && (%1% < 50)) ? 'P' : 
	  SQL_CMD_CONTINUE ((%1% > 49) && (%1% < 80)) ? 'R' : 
	  SQL_CMD_CONTINUE ((%1% > 79) && (%1% < 120)) ? 'Sa' : 
	  SQL_CMD_CONTINUE ((%1% > 119) && (%1% < 180)) ? 'E' : 
	  SQL_CMD_CONTINUE (%1% > 179) ? 'D' : 
	  SQL_CMD_CONTINUE 'Gray')
	  SQL_CMD COLUMN EVALLOCALVAR titl return(('%gif%' eq 'B') ? 'Bronze (5-9)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'S') ? 'Silver (10-19)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'G') ? 'Gold (20-29)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'P') ? 'Platinum (30-49)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'R') ? 'Ruby (50-79)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'Sa') ? 'Sapphire (80-119)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'E') ? 'Emerald (120-179)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'D') ? 'Diamond (180+)' : 
	  SQL_CMD_CONTINUE 'None (0-4)')
	  SQL_CMD COLUMN EVALLOCALVAR ggif return('<img src="%GGS_URL%Terr%gif%.png" width="%GGS_PSIZE%" title="The Rugged Cacher - #%1%/%titl%" /> ')
    SQLEND
	# test na GOLD
	EVALLOCALVAR GGS_GOLD return(('%gif%' eq 'G') ? GGS_GOLD + 1 : GGS_GOLD)
	#potlaceni vystupu
	EVALLOCALVAR ggif return((%GGS_CACHEDIFFTERR% eq '0') ? '' : '%ggif%')
	#
	EVALLOCALVAR GGS_B return(('%gif%' eq 'B') ? '%GGS_B%%ggif%' : '%GGS_B%')
	EVALLOCALVAR GGS_S return(('%gif%' eq 'S') ? '%GGS_S%%ggif%' : '%GGS_S%')
	EVALLOCALVAR GGS_G return(('%gif%' eq 'G') ? '%GGS_G%%ggif%' : '%GGS_G%')
	EVALLOCALVAR GGS_P return(('%gif%' eq 'P') ? '%GGS_P%%ggif%' : '%GGS_P%')
	EVALLOCALVAR GGS_R return(('%gif%' eq 'R') ? '%GGS_R%%ggif%' : '%GGS_R%')
	EVALLOCALVAR GGS_Sa return(('%gif%' eq 'Sa') ? '%GGS_Sa%%ggif%' : '%GGS_Sa%')
	EVALLOCALVAR GGS_E return(('%gif%' eq 'E') ? '%GGS_E%%ggif%' : '%GGS_E%')
	EVALLOCALVAR GGS_D return(('%gif%' eq 'D') ? '%GGS_D%%ggif%' : '%GGS_D%')
    EVALLOCALVAR GGS_Gray return(('%gif%' eq 'Gray') ? '%GGS_Gray%%ggif%' : '%GGS_Gray%')	
	# D5 ---------------------------------------------------------------
	SQLSTART
	  #				 1
	  SQL_SQL select count(gc.id)
	  SQL_SQL from geocache gc
	  SQL_SQL where gc.dtfound>0 and gc.difficulty = 5
	  #
	  OUTVALUETYPE NUM	
	  SQL_CMD COLUMN EVALLOCALVAR five return(%1%)
	  OUTVALUETYPE ASCII
	  #	  
	  SQL_CMD COLUMN EVALLOCALVAR gif return(((%1% > 1) && (%1% < 4)) ? 'B' : 
	  SQL_CMD_CONTINUE ((%1% > 3) && (%1% < 6)) ? 'S' : 
	  SQL_CMD_CONTINUE ((%1% > 5) && (%1% < 9)) ? 'G' : 
	  SQL_CMD_CONTINUE ((%1% > 8) && (%1% < 15)) ? 'P' : 
	  SQL_CMD_CONTINUE ((%1% > 14) && (%1% < 25)) ? 'R' : 
	  SQL_CMD_CONTINUE ((%1% > 24) && (%1% < 40)) ? 'Sa' : 
	  SQL_CMD_CONTINUE ((%1% > 39) && (%1% < 60)) ? 'E' : 
	  SQL_CMD_CONTINUE (%1% > 59) ? 'D' : 
	  SQL_CMD_CONTINUE 'Gray')
	  SQL_CMD COLUMN EVALLOCALVAR titl return(('%gif%' eq 'B') ? 'Bronze (2-3)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'S') ? 'Silver (4-5)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'G') ? 'Gold (6-8)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'P') ? 'Platinum (9-14)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'R') ? 'Ruby (15-24)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'Sa') ? 'Sapphire (25-39)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'E') ? 'Emerald (40-59)' : 
	  SQL_CMD_CONTINUE ('%gif%' eq 'D') ? 'Diamond (60+)' : 
	  SQL_CMD_CONTINUE 'None (0-1)')
	  SQL_CMD COLUMN EVALLOCALVAR ggif return('<img src="%GGS_URL%Difi%gif%.png" width="%GGS_PSIZE%" title="The Brainiac - #%1%/%titl%" /> ')
    SQLEND
	# test na GOLD
	EVALLOCALVAR GGS_GOLD return(('%gif%' eq 'G') ? GGS_GOLD + 1 : GGS_GOLD)
	#potlaceni vystupu
	EVALLOCALVAR ggif return((%GGS_CACHEDIFFTERR% eq '0') ? '' : '%ggif%')
	#
	EVALLOCALVAR GGS_B return(('%gif%' eq 'B') ? '%GGS_B%%ggif%' : '%GGS_B%')
	EVALLOCALVAR GGS_S return(('%gif%' eq 'S') ? '%GGS_S%%ggif%' : '%GGS_S%')
	EVALLOCALVAR GGS_G return(('%gif%' eq 'G') ? '%GGS_G%%ggif%' : '%GGS_G%')
	EVALLOCALVAR GGS_P return(('%gif%' eq 'P') ? '%GGS_P%%ggif%' : '%GGS_P%')
	EVALLOCALVAR GGS_R return(('%gif%' eq 'R') ? '%GGS_R%%ggif%' : '%GGS_R%')
	EVALLOCALVAR GGS_Sa return(('%gif%' eq 'Sa') ? '%GGS_Sa%%ggif%' : '%GGS_Sa%')
	EVALLOCALVAR GGS_E return(('%gif%' eq 'E') ? '%GGS_E%%ggif%' : '%GGS_E%')
	EVALLOCALVAR GGS_D return(('%gif%' eq 'D') ? '%GGS_D%%ggif%' : '%GGS_D%')
    EVALLOCALVAR GGS_Gray return(('%gif%' eq 'Gray') ? '%GGS_Gray%%ggif%' : '%GGS_Gray%')