function CheckRegistration (id)
     if testMYSQLconnect then
     local checkUSGN = player(id, "usgn")
     print("debug 1")
     conn:query("SELECT id, usgn FROM users WHERE usgn = "..checkUSGN)
     result = conn:store_result()
          for id, usgn in result:rows() do
          local USGN = usgn
          if (player(id, "usgn") == USGN) then
               print(USGN)
          else
               msg2(id, "\169255000000Username doesn't exist in the database")
          end
         -- end
     conn:close()
     end
     else
          return 1
     end
end