BEGIN

DECLARE my_tel VARCHAR(3);
DECLARE friend_tell VARCHAR(3);

DECLARE my_tel_old VARCHAR(3);
DECLARE friend_tell_old VARCHAR(3);

DECLARE var_tel VARCHAR(3);
DECLARE var_frd_tell VARCHAR(3);

SET @my_tel_old = tel_num_ins;
SET @friend_tell_old = friend_tel_ins;


IF( SELECT count( * ) 
FROM users as tkeml
WHERE tkeml.login != login_ins and tkeml.email = email_ins) !=0
 THEN
      SELECT 'email_in_base_ed';
ELSEIF (SELECT count( * ) 
     FROM users_jn
 WHERE users_jn.time_upd >= CURDATE() and users_jn.login LIKE login_ins) !=0
THEN
      SELECT 'wait_day_end';
ELSEIF (SELECT count( * ) 
FROM users as tktel
WHERE tktel.login != login_ins and tktel.tel_num = tel_num_ins) !=0
 THEN
      SELECT 'tel_in_base_ed';
ELSE


 IF pass_ins !=''
 THEN 
UPDATE users as a SET a.name = name_ins, a.surname = surname_ins, a.tel_num = tel_num_ins, a.pass=pass_ins WHERE a.login = login_ins and a.pass = pass_old_ins;
 ELSE
UPDATE users as a SET a.name = name_ins, a.surname = surname_ins, a.tel_num = tel_num_ins  WHERE a.login = login_ins and a.pass = pass_old_ins;
 END IF;


SELECT tel_num INTO @my_tel FROM users_jn WHERE login = login_ins GROUP BY time_upd DESC LIMIT 0, 1;
SELECT friend_tel INTO @friend_tell FROM users_jn WHERE login = login_ins GROUP BY time_upd DESC LIMIT 0, 1;

IF @my_tel = @my_tel_old THEN
  SET var_tel = 'NO';
ELSE 
  SET var_tel = 'YES';
END IF;


IF @friend_tell = @friend_tell_old THEN
  SET var_frd_tell = 'NO';
ELSE 
  SET var_frd_tell = 'YES';
END IF;


SELECT concat(var_tel,'||',var_frd_tell) as RESULT; 

END IF;
        
END

ELSEIF (SELECT count( * ) 
     FROM users_jn
 WHERE users_jn.time_upd >= CURDATE() and users_jn.login LIKE login_ins) !=0
THEN
      SELECT 'wait_day_end';

SELECT count(*)
     FROM users_jn as  usjn
 WHERE usjn.time_upd >= CURDATE() and usjn.login LIKE 'ppp'

CALL `UserEdit` ('ppp' , 'ppp' , '0501234569', '202cb962ac59075b964b07152d234b70');

SELECT count(*)
     FROM users_jn as  usjn
 WHERE usjn.time_upd >= CURDATE() and usjn.login LIKE 'ppp'