Tooltron

      aug20 = datetime.date(today.year, 8, 20) # Fall semester

      may21 = datetime.date(today.year, 5, 21) # summer

      jan1  = datetime.date(today.year, 1,  1) # Spring semester

      # if they don't fall after those two, its fall

      if today > aug20:

         print "its fall semester!"

         #its fall, so they must have paid after may21 (either full year of half) to be paid

                 DATE_FORMAT(civicrm_value_roboclub_info_2.date_paid_10, '%M %d %Y') \

                 FROM civicrm_value_roboclub_info_2 \

                 WHERE civicrm_value_roboclub_info_2.card_number_1 = " + cardnum + ";"

      elif today > may21:

         print "its summer!"

         #its summer, so they need to have paid either full year since aug20 or one semester since jan 1

                         civicrm_value_roboclub_info_2.amount_paid_11 = 25) OR \

                        (civicrm_value_roboclub_info_2.date_paid_10 >= STR_TO_DATE('" + jan1.strftime('%m/%d/%Y') + "', '%m/%d/%Y') AND \

                         civicrm_value_roboclub_info_2.amount_paid_11 = 15) , \

      else:

         print "its spring!"

         #its spring, so they must have either paid full after aug20 or one semester since jan 1 (this is the same as summer)

                         civicrm_value_roboclub_info_2.amount_paid_11 = 25) OR \

                        (civicrm_value_roboclub_info_2.date_paid_10 >= STR_TO_DATE('" + jan1.strftime('%m/%d/%Y') + "', '%m/%d/%Y') AND \

                         civicrm_value_roboclub_info_2.amount_paid_11 = 15) , \

            logMessage(user + " has not paid since " + result[0][1] + ", revoking access!")

         else:

            logMessage(user + " has not paid, revoking access!")

      toolName = reverseTool(key)