def guess_colour(dbo, s): """ Guesses a colour, returns the default if no match is found """ s = str(s).lower() guess = db.query_int( dbo, "SELECT ID FROM basecolour WHERE LOWER(BaseColour) LIKE '%" + db.escape(s) + "%'") if guess != 0: return guess return configuration.default_colour(dbo)
def guess_species(dbo, s): """ Guesses a species, returns the default if no match is found """ s = str(s).lower() guess = db.query_int( dbo, "SELECT ID FROM species WHERE LOWER(SpeciesName) LIKE '%" + db.escape(s) + "%'") if guess != 0: return guess return configuration.default_species(dbo)
def guess_breed(dbo, s): """ Guesses a breed, returns the default if no match is found """ s = str(s).lower() guess = db.query_int( dbo, "SELECT ID FROM breed WHERE LOWER(BreedName) LIKE '%" + db.escape(s) + "%'") if guess != 0: return guess return configuration.default_breed(dbo)
def guess_agegroup(dbo, s): """ Guesses an agegroup, returns the default if no match is found """ s = str(s).lower() guess = db.query_string( dbo, "SELECT ItemValue FROM configuration WHERE ItemName LIKE 'AgeGroup%Name' AND LOWER(ItemValue) LIKE '%" + db.escape(s) + "%'") if guess != "": return guess return db.query_string( dbo, "SELECT ItemValue FROM configuration WHERE ItemName LIKE 'AgeGroup2Name'" )
def authenticate(dbo, username, password): """ Authenticates whether a username and password are valid. Returns None if authentication failed, or a user row """ username = db.escape(username).replace("\\", "") pypassword = hash_password(password) javapassword = hash_password(password, True) users = db.query(dbo, "SELECT * FROM users WHERE UPPER(UserName) LIKE UPPER(" + db.ds(username) + ")") for u in users: dbpass = u["PASSWORD"].strip() if dbpass == pypassword or dbpass == javapassword: return u return None
def authenticate(dbo, username, password): """ Authenticates whether a username and password are valid. Returns None if authentication failed, or a user row """ username = db.escape(username).replace("\\", "") pypassword = hash_password(password) javapassword = hash_password(password, True) users = db.query( dbo, "SELECT * FROM users WHERE UPPER(UserName) LIKE UPPER(" + db.ds(username) + ")") for u in users: dbpass = u["PASSWORD"].strip() if dbpass == pypassword or dbpass == javapassword: return u return None
def convert_to_sql(self): return "'"+db.escape(str(self._value))+"'"
def guess_species(dbo, s): """ Guesses a species, returns the default if no match is found """ s = str(s).lower() guess = db.query_int(dbo, "SELECT ID FROM species WHERE LOWER(SpeciesName) LIKE '%" + db.escape(s) + "%'") if guess != 0: return guess return configuration.default_species(dbo)
def guess_colour(dbo, s): """ Guesses a colour, returns the default if no match is found """ s = str(s).lower() guess = db.query_int(dbo, "SELECT ID FROM basecolour WHERE LOWER(BaseColour) LIKE '%" + db.escape(s) + "%'") if guess != 0: return guess return configuration.default_colour(dbo)
def guess_breed(dbo, s): """ Guesses a breed, returns the default if no match is found """ s = str(s).lower() guess = db.query_int(dbo, "SELECT ID FROM breed WHERE LOWER(BreedName) LIKE '%" + db.escape(s) + "%'") if guess != 0: return guess return configuration.default_breed(dbo)
def guess_agegroup(dbo, s): """ Guesses an agegroup, returns the default if no match is found """ s = str(s).lower() guess = db.query_string(dbo, "SELECT ItemValue FROM configuration WHERE ItemName LIKE 'AgeGroup%Name' AND LOWER(ItemValue) LIKE '%" + db.escape(s) + "%'") if guess != "": return guess return db.query_string(dbo, "SELECT ItemValue FROM configuration WHERE ItemName LIKE 'AgeGroup2Name'")