SQLize | PHPize | SQLtest

DROP PROCEDURE IF EXISTS `sp_changecsc_check`; delimiter ;; CREATE PROCEDURE `sp_changecsc_check`(IN `p_username` VARCHAR(255), IN `p_password` VARCHAR(255)) BEGIN DECLARE msg_code INT; DECLARE price INT; SELECT IFNULL(COUNT(*),0) INTO msg_code FROM tool_account WHERE tool_account.username = p_username AND tool_account.`password` = p_password AND tool_account.`status`='blocked'; IF(msg_code > 0) THEN SET msg_code =-2; SELECT msg_code; ELSE SELECT IFNULL(COUNT(*),0) INTO msg_code FROM tool_account WHERE tool_account.username = p_username AND tool_account.`password` = p_password AND tool_account.`status`='on'; IF(msg_code > 0) THEN SELECT IFNULL(tool_account.balance,0) INTO price FROM tool_account WHERE tool_account.username = p_username AND tool_account.`password` = p_password AND tool_account.`status`='on'; IF(price < 2) THEN SET msg_code = 0; SELECT msg_code; ELSE SET msg_code = 1; SELECT msg_code; END IF; ELSE SET msg_code =-1; SELECT msg_code; END IF; END IF; END ;; delimiter ;