1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
CREATE FUNCTION `tmallstars`.`add_user2` (p1 varchar(60),p2 varchar(100),p3 varchar(60),p4 varchar(60),p5 varchar(60),p6 varchar(120),p7 varchar(60),p8 date,fk_group int,fk_player int,fk_country int) RETURNS INT
BEGIN
DECLARE v_login,v_login_tm,v_email varchar(60) DEFAULT NULL;
DECLARE v_fk_group,v_fk_player,v_fk_country INT DEFAULT 0;
DECLARE var1 int DEFAULT 0;
SELECT login INTO v_login FROM users
WHERE login=p1;
SELECT login_tm INTO v_login_tm FROM users
WHERE login_tm=p3;
SELECT email INTO v_email FROM users
WHERE email=p7;
SELECT id_country INTO v_fk_country FROM country
WHERE id_country = fk_country;
IF v_login IS NOT NULL THEN
SET var1=1;
ELSEIF v_tm_login IS NOT NULL THEN
SET var1=2;
ELSEIF v_email IS NOT NULL THEN
SET var1=3;
ELSE
INSERT INTO users (login,pass,login_tm,first_name,last_name,adress,email,last_logon,fk_id_group,fk_id_player,fk_id_country)
VALUES (p1,p2,p3,p4,p5,p6,p7,p8,1,NULL,v_fk_country);
SET var1=0;
END IF;
END IF;
END IF;
RETURN var1;
END |
Partager