Биллинговая система Nodeny

DROP PROCEDURE IF EXISTS `radcheck`;
DELIMITER $$
CREATE PROCEDURE `radcheck` (IN login VARCHAR(64), IN umac VARCHAR(64))
BEGIN
  SELECT LOWER(REPLACE(umac, ':', '')) INTO umac;
  SELECT u.id, u.name, 'Password' AS Attribute, AES_DECRYPT(u.passwd,'hardpass') AS Value,'=='
    FROM users u JOIN mac_uid m ON u.id=m.uid WHERE u.name=login AND m.mac=umac;
END$$
DELIMITER ;

ee /usr/local/etc/raddb/sql.conf

authorize_check_query = "call radcheck('%{User-Name}', '%{Calling-Station-Id}')"

DROP PROCEDURE IF EXISTS `radcheck`;
DELIMITER $$
CREATE PROCEDURE `radcheck` (IN login VARCHAR(64))
BEGIN
  SELECT u.id, u.name, 'Password' AS Attribute, AES_DECRYPT(passwd,'hardpass3') AS Value,'=='
	AS Op FROM users u WHERE u.name=login ;
IF ((SELECT m.uid FROM users u JOIN mac_uid m WHERE uid=u.id ORDER BY m.uid DESC LIMIT 1) <> '') 
THEN
  SELECT users.id,users.name,'Calling-Station-Id' AS Attribute,mac_uid.mac AS Value,'==' AS Op FROM users,mac_uid WHERE mac_uid.uid=users.id AND users.name=login ORDER BY mac_uid.uid DESC LIMIT 1;
END IF;   
END$$
DELIMITER ;

set pppoe mac-format unformatted