--do vsech realmu:

delimiter //
DROP FUNCTION IF EXISTS portal_pass_change//
CREATE FUNCTION portal_pass_change (
 N_USERNAME VARCHAR(40),
 N_OLDPASS VARCHAR(40),
 N_NEWPASS VARCHAR(40))
RETURNS INT
BEGIN
IF sha1(CONCAT_WS(':',N_USERNAME,N_OLDPASS)) = (SELECT sha_pass_hash FROM account WHERE username = N_USERNAME) THEN
  IF (SELECT gmlevel FROM account WHERE username = N_USERNAME) = 0 THEN

    UPDATE account SET sha_pass_hash = sha1(CONCAT_WS(':',N_USERNAME,N_NEWPASS)),
     v=0,
     s=0
     WHERE username = N_USERNAME;

  ELSE
    RETURN 2;
  END IF;

    RETURN 1;
ELSE
    RETURN 2;
END IF;
END//

-- do k_users

delimiter //

DROP FUNCTION IF EXISTS portal_pass_change//
CREATE FUNCTION portal_pass_change`k_users` (
 N_USERNAME VARCHAR(40),
 N_OLDPASS VARCHAR(40),
 N_NEWPASS VARCHAR(40))
RETURNS INT
BEGIN
IF sha1(CONCAT_WS(':',N_USERNAME,N_OLDPASS)) = (SELECT user_pass FROM k_users WHERE user_name = N_USERNAME) THEN
UPDATE k_users SET user_pass = sha1(CONCAT_WS(':',USERNAME,N_NEWPASS)) WHERE user_name = N_USERNAME;
RETURN 1;
ELSE
RETURN 2;
END IF;
END//