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

# netstat -tulpn | grep :67
udp        0      0 0.0.0.0:67              0.0.0.0:*                           6567/accel-pppd 
udp        0      0 0.0.0.0:67              0.0.0.0:*                           6567/accel-pppd 

        DHCP-Option82 = 0x0106000400c8010d020800060012cf7ef380
        DHCP-Agent-Remote-Id = 0x00060012cf7ef380
        DHCP-Agent-Circuit-Id = 0x000400c8010d

DROP PROCEDURE IF EXISTS mx80radcheck;
DELIMITER $$  
CREATE PROCEDURE mx80radcheck (IN login VARCHAR(64))
BEGIN
 DECLARE usr_id INT;  
 DECLARE usr_mac VARCHAR(12);
 DECLARE usr_vid INT;
 DECLARE usr_port INT;
 DECLARE usr_swmac VARCHAR(12);
 
SELECT UPPER(REPLACE(SUBSTRING(login,1,14),'.','')) INTO usr_mac;
SELECT CONV(SUBSTRING(login,20,4),16,10) INTO usr_vid;
SELECT CONV(SUBSTRING(login,26,2),16,10) INTO usr_port;
SELECT SUBSTRING(login,33,12) INTO usr_swmac;


  SELECT usr_mac AS 'MAC', usr_vid AS 'VID', usr_port AS 'PORT', usr_swmac AS 'SWMAC';
END$$
DELIMITER ;