: SELECT
: user_id AS userid,
: user_crypt AS crypt,
: user_isadmin AS isadmin
: FROM
: user
: WHERE
: user_name = ${mysql::cgi.param.login_username}
);
if (declared u.crypt and check_crypt(cgi.param.login_password, u.crypt)) {
userid = u.userid;
isadmin = u.isadmin;
set_cookie_auth(cgi.param.login_username, cgi.param.login_password);
?>Logged in.
Login failed.
Password and retyped password are different!
Username must be in format /^[a-z][a-z0-9]*$$/!
Username '${xml::cgi.param.newuser_username}' is already used!
: INSERT INTO
: user
: SET
: user_name = ${mysql::cgi.param.newuser_username},
: user_email = ${mysql::cgi.param.newuser_email},
: user_crypt = ${mysql::crypt(cgi.param.newuser_password_1)}
);
userid = sql_value(db, "SELECT last_insert_id()");
isadmin = 0;
set_cookie_auth(cgi.param.newuser_username, cgi.param.newuser_password_1);
?>Logged in.