Is this meant for OACS 3.x? Or 4.x? If the latter, then you should really read the developer's guide and other documentation (especially acs-templating) located in /doc/. Otherwise, there are several problems with the code:
* the "users" table doesn't have all those fields. try "cc_users" instead.
* your first <tr bgcolor=... is missing a closing ">" tag.
* all your <tr>'s are missing corresponding </tr>'s.
* it's set_variables_after_query not set_variable_after_query. (you're missing an "s")
I recommend you read the docs, study your error log, debug, etc when you encounter these types of problems. Best of luck...