fixed a sql bug
some jsps
client and admin templates