BEGIN
	DECLARE rad_mac VARCHAR(12);
    DECLARE rad_dev_mac VARCHAR(12);
    DECLARE rad_port VARCHAR(12);
    DECLARE usr_id INT;
    DECLARE usr_ip VARCHAR(15);

    SELECT SUBSTRING_INDEX(login, '-', 1) INTO rad_mac;
    SELECT SUBSTRING_INDEX(login, '-', -1) INTO rad_port;
    SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(login, '-', 2), '-', -1) INTO rad_dev_mac;

    SELECT uid INTO usr_id FROM mac_uid WHERE device_mac=rad_dev_mac
		    AND (device_port=rad_port OR (onedevice>0 AND device_mac<>''))
			AND (mac=rad_mac OR (oneconnect>0 AND device_mac<>''))
        		LIMIT 1;

    IF usr_id IS NULL THEN
        SELECT ipa INTO usr_ip;
    ELSE
        SELECT get_ip_by_tag(usr_id, tag) INTO usr_ip;
    END IF;

    CALL set_auth(usr_ip, CONCAT('mod=dhcp;user=', rad_mac, ';', 'dev=', rad_dev_mac, ';', 'port=', rad_port, ';',
		'ses=', ses, ';', REPLACE(properties,':','')));
	UPDATE mac_uid SET time=UNIX_TIMESTAMP() WHERE ip=INET_ATON(ipa) LIMIT 1;
END