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

DROP PROCEDURE IF EXISTS `radreply`;
DELIMITER $$ 
CREATE PROCEDURE `radreply` (IN login VARCHAR(64))
BEGIN
  DECLARE usr_id INT; 
  DECLARE usr_ip VARCHAR(15);
  DECLARE speedrx VARCHAR(15);
  DECLARE speedtx VARCHAR(15);

  SELECT id,ip INTO usr_id,usr_ip FROM users WHERE name=login;
  INSERT into dblogin (mid,act,time) VALUES (usr_id,47,unix_timestamp());
  SELECT speed INTO speedrx from plans2 where id=(select paket from users where id=usr_id);
  SELECT speed_out INTO speedtx from plans2 where id=(select paket from users where id=usr_id);

  SELECT NULL,login,'Framed-IP-Address',usr_ip,'=';
  SELECT NULL,login,'Framed-IP-Netmask','255.255.255.255','=';
  SELECT NULL,login,'Acct-Interim-Interval','50','=';
  SELECT NULL,login,'Ascend-Data-Rate',speedtx,'=';
  SELECT NULL,login,'Ascend-Xmit-Rate',speedrx,'=';

END$$
DELIMITER ;