========================2020-07-02 09:19:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FTTP83G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E994F9BC5E73BC05 sCDKey = 622658319188 sName = DESKTOP-FTTP83G ========================2020-07-02 09:19:17======================== 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 = '622658319188' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-02 09:19:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sj6953811' ========================2020-07-02 09:19:18======================== SELECT idx FROM macs WHERE mac_addr = 'B42E994F9BC5E73BC05' AND app_code = '039' ========================2020-07-02 09:19:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320953' ========================2020-07-02 09:19:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320953' ========================2020-07-02 09:19:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320953', 'B42E994F9BC5E73BC05', '039', 'DESKTOP-FTTP83G', '110', '1920', '1080', 'sj6953811', '(주)세종건축건업[이태규]', '622658319188' ) ========================2020-07-02 13:21:06======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-N9IVFHF parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00E070ADDF143497F3C7 sCDKey = 134957273212 sName = DESKTOP-N9IVFHF ========================2020-07-02 13:21:06======================== 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 = '134957273212' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-02 13:21:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'boltlee' ========================2020-07-02 13:21:06======================== SELECT idx FROM macs WHERE mac_addr = '00E070ADDF143497F3C7' AND app_code = '047' ========================2020-07-02 13:21:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320977' ========================2020-07-02 13:21:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320977' ========================2020-07-02 13:21:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320977', '00E070ADDF143497F3C7', '047', 'DESKTOP-N9IVFHF', '�쐢�룄�슦 10', '0', '0', 'boltlee', '(주)신흥화스너 구장지점[이원선]', '134957273212' ) ========================2020-07-02 18:45:55======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99D034C5BC2DBE12 sCDKey = 169591860148 sName = YANGJK_2020 ========================2020-07-02 18:45:55======================== 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 = '169591860148' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-02 18:46:52======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99D034C5BC2DBE12 sCDKey = 169591860148 sName = YANGJK_2020 ========================2020-07-02 18:46:52======================== 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 = '169591860148' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-02 18:46:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjss064' ========================2020-07-02 18:46:52======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99D034C5BC2DBE12' AND app_code = '046' ========================2020-07-02 18:46:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321015' ========================2020-07-02 18:46:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '321015' ========================2020-07-02 18:46:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '321015', 'B42E99D034C5BC2DBE12', '046', 'YANGJK_2020', '90', '1920', '1080', 'hjss064', '형제상사주식회사[양진규]', '169591860148' )