========================2018-06-21 09:04:15======================== noteurl_start parm_app_code = 046 parm_pc_name = USER02 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002522BC714732ECD3EF sCDKey = 752642067081 sName = USER02 ========================2018-06-21 09:04:15======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '752642067081' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-21 09:04:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanadaein' ========================2018-06-21 09:04:15======================== SELECT idx FROM macs WHERE mac_addr = '002522BC714732ECD3EF' AND app_code = '046' ========================2018-06-21 09:04:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '221677' ========================2018-06-21 09:04:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '221677' ========================2018-06-21 09:04:15======================== UPDATE mac_detail SET pc_name = 'USER02', os_type = '90', user_id = 'hanadaein', user_name = '자인미래텍[김종환]', screen_w = '1920', screen_h = '1080', cdkey = '752642067081' WHERE mac_idx = '221677' ========================2018-06-21 11:11:29======================== noteurl_start parm_app_code = 039 parm_pc_name = 미건의료기-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCAEC56EB6BCA4B5D345 sCDKey = 320698337766 sName = 미건의료기-PC ========================2018-06-21 11:11:29======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '320698337766' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-21 11:11:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jmj6175' ========================2018-06-21 11:11:29======================== SELECT idx FROM macs WHERE mac_addr = 'BCAEC56EB6BCA4B5D345' AND app_code = '039' ========================2018-06-21 11:11:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250715' ========================2018-06-21 11:11:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250715' ========================2018-06-21 11:11:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '250715', 'BCAEC56EB6BCA4B5D345', '039', '미건의료기-PC', '90', '1920', '1080', 'jmj6175', '미건원적외선[이두엽]', '320698337766' ) ========================2018-06-21 13:06:19======================== noteurl_start parm_app_code = 039 parm_pc_name = U-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0D55E5FDFF6620DDBB7 sCDKey = 549176813222 sName = U-PC ========================2018-06-21 13:06:19======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '549176813222' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-21 13:06:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'js1212' ========================2018-06-21 13:06:19======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E5FDFF6620DDBB7' AND app_code = '039' ========================2018-06-21 13:06:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252525' ========================2018-06-21 13:06:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252525' ========================2018-06-21 13:06:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '252525', 'E0D55E5FDFF6620DDBB7', '039', 'U-PC', '90', '1680', '1050', 'js1212', '정성테크[김길례]', '549176813222' ) ========================2018-06-21 13:06:25======================== noteurl_start parm_app_code = 039 parm_pc_name = U-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0D55E5FDFF6620DDBB7 sCDKey = 549176813222 sName = U-PC ========================2018-06-21 13:06:25======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '549176813222' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-21 13:06:31======================== noteurl_start parm_app_code = 039 parm_pc_name = U-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0D55E5FDFF6620DDBB7 sCDKey = 549176813222 sName = U-PC ========================2018-06-21 13:06:31======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '549176813222' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-21 13:06:40======================== noteurl_start parm_app_code = 039 parm_pc_name = U-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0D55E5FDFF6620DDBB7 sCDKey = 549176813222 sName = U-PC ========================2018-06-21 13:06:40======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '549176813222' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-21 13:06:53======================== noteurl_start parm_app_code = 039 parm_pc_name = U-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0D55E5FDFF6620DDBB7 sCDKey = 549176813222 sName = U-PC ========================2018-06-21 13:06:53======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '549176813222' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-21 13:34:08======================== noteurl_start parm_app_code = 046 parm_pc_name = A21S parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = B4B6763BC469A88691E1 sCDKey = 938129979397 sName = A21S ========================2018-06-21 13:34:08======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '938129979397' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-21 13:34:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mdpet' ========================2018-06-21 13:34:08======================== SELECT idx FROM macs WHERE mac_addr = 'B4B6763BC469A88691E1' AND app_code = '046' ========================2018-06-21 13:34:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252533' ========================2018-06-21 13:34:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252533' ========================2018-06-21 13:34:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '252533', 'B4B6763BC469A88691E1', '046', 'A21S', '110', '1280', '720', 'mdpet', '엠디펫[이종원]', '938129979397' ) ========================2018-06-21 15:12:33======================== noteurl_start parm_app_code = 047 parm_pc_name = WIN-5T6QC55P54I parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50465DB8679B3419979E sCDKey = 942067945302 sName = WIN-5T6QC55P54I ========================2018-06-21 15:12:33======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '942067945302' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-21 15:12:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'joesakic' ========================2018-06-21 15:12:33======================== SELECT idx FROM macs WHERE mac_addr = '50465DB8679B3419979E' AND app_code = '047' ========================2018-06-21 15:12:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252550' ========================2018-06-21 15:12:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252550' ========================2018-06-21 15:12:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '252550', '50465DB8679B3419979E', '047', 'WIN-5T6QC55P54I', '�쐢�룄�슦 7', '0', '0', 'joesakic', '레트로게임[전오성]', '942067945302' )