old_contents: #
  # Copyright (c) 2005 rpath, Inc.
  #
  # All Rights Reserved
  #
  
  (
      USERNAME_ASC,
      USERNAME_DES,
      FULLNAME_ASC,
      FULLNAME_DES,
      CREATED_ASC,
      CREATED_DES,
      ACCESSED_ASC,
      ACCESSED_DES
  ) = range(0, 8)
  
  blurbindex = 5
  blurbtrunclength = 300
  sqlbase = """SELECT userid, username, fullname, timeCreated, timeAccessed,
  blurb FROM users
      ORDER BY %s
      LIMIT %d
      OFFSET %d"""
  
  ordersql = {
      USERNAME_ASC: "username ASC",
      USERNAME_DES: "username DESC",
      FULLNAME_ASC: "fullname ASC",
      FULLNAME_DES: "fullname DESC",
      CREATED_ASC:  "timeCreated ASC",
      CREATED_DES:  "timeCreated DESC",
      ACCESSED_ASC: "timeAccessed ASC",
      ACCESSED_DES: "timeAccessed DESC"
  }
  
  orderhtml = {
      USERNAME_ASC: "Username in ascending order",
      USERNAME_DES: "Username in descending order",
      FULLNAME_ASC: "Full name in ascending order",
      FULLNAME_DES: "Full name in descending order",
      CREATED_ASC:  "Oldest users",
      CREATED_DES:  "Newest users",
      ACCESSED_ASC: "Least recently accessed",
      ACCESSED_DES: "Most recently accessed"
  }
  
new_contents: #
  # Copyright (c) 2005 rpath, Inc.
  #
  # All Rights Reserved
  #
  
  (
      USERNAME_ASC,
      USERNAME_DES,
      FULLNAME_ASC,
      FULLNAME_DES,
      CREATED_ASC,
      CREATED_DES,
      ACCESSED_ASC,
      ACCESSED_DES
  ) = range(0, 8)
  
  blurbindex = 5
  blurbtrunclength = 300
  sqlbase = """SELECT userid, username, fullname, timeCreated, timeAccessed,
  blurb FROM users WHERE active=1
      ORDER BY %s
      LIMIT %d
      OFFSET %d"""
  
  ordersql = {
      USERNAME_ASC: "username ASC",
      USERNAME_DES: "username DESC",
      FULLNAME_ASC: "fullname ASC",
      FULLNAME_DES: "fullname DESC",
      CREATED_ASC:  "timeCreated ASC",
      CREATED_DES:  "timeCreated DESC",
      ACCESSED_ASC: "timeAccessed ASC",
      ACCESSED_DES: "timeAccessed DESC"
  }
  
  orderhtml = {
      USERNAME_ASC: "Username in ascending order",
      USERNAME_DES: "Username in descending order",
      FULLNAME_ASC: "Full name in ascending order",
      FULLNAME_DES: "Full name in descending order",
      CREATED_ASC:  "Oldest users",
      CREATED_DES:  "Newest users",
      ACCESSED_ASC: "Least recently accessed",
      ACCESSED_DES: "Most recently accessed"
  }
  
subject: Hide yet-to-be-activated usernames from listings