Your users table needs some lovin'.

users
user_rank => tinyint(1)
username seems to be way too long, same with password and name
and i think the hashes password will always be the same length. so it's safe to use char(n)

Sorry, only had a quick second to spare.