========================2021-07-16 10:21:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3RJ5HR3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D2F6DBB6277F03A sCDKey = 076018663977 sName = DESKTOP-3RJ5HR3 ========================2021-07-16 10:21:56======================== 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 = '076018663977' AND r.app_code = '039' AND r.app_block = 0 ========================2021-07-16 10:21:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyoworl' ========================2021-07-16 10:21:56======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D2F6DBB6277F03A' AND app_code = '039' ========================2021-07-16 10:21:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '347565' ========================2021-07-16 10:21:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '347565' ========================2021-07-16 10:21:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '347565', '1C1B0D2F6DBB6277F03A', '039', 'DESKTOP-3RJ5HR3', '110', '1920', '1080', 'hyoworl', '효월영농조합법인[이기영]', '076018663977' ) ========================2021-07-16 15:19:08======================== noteurl_start parm_app_code = 047 parm_pc_name = SHDWIN7-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 080027F4851128C8CA5F sCDKey = 488853966226 sName = SHDWIN7-PC ========================2021-07-16 15:19: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 = '488853966226' AND r.app_code = '047' AND r.app_block = 0 ========================2021-07-16 15:19:35======================== noteurl_start parm_app_code = 047 parm_pc_name = SHDWIN7-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 080027F4851128C8CA5F sCDKey = 777481111664 sName = SHDWIN7-PC ========================2021-07-16 15:19:35======================== 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 = '777481111664' AND r.app_code = '047' AND r.app_block = 0 ========================2021-07-16 15:20:06======================== noteurl_start parm_app_code = 047 parm_pc_name = SHDWIN7-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 080027F4851128C8CA5F sCDKey = 805782763880 sName = SHDWIN7-PC ========================2021-07-16 15:20: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 = '805782763880' AND r.app_code = '047' AND r.app_block = 0 ========================2021-07-16 15:20:10======================== noteurl_start parm_app_code = 047 parm_pc_name = SHDWIN7-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 080027F4851128C8CA5F sCDKey = 805782763880 sName = SHDWIN7-PC ========================2021-07-16 15:20:10======================== 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 = '805782763880' AND r.app_code = '047' AND r.app_block = 0 ========================2021-07-16 15:20:28======================== noteurl_start parm_app_code = 047 parm_pc_name = SHDWIN7-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 080027F4851128C8CA5F sCDKey = 805782763880 sName = SHDWIN7-PC ========================2021-07-16 15:20:28======================== 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 = '805782763880' AND r.app_code = '047' AND r.app_block = 0 ========================2021-07-16 15:20:58======================== noteurl_start parm_app_code = 047 parm_pc_name = SHDWIN7-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 080027F4851128C8CA5F sCDKey = 788887299848 sName = SHDWIN7-PC ========================2021-07-16 15:20:58======================== 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 = '788887299848' AND r.app_code = '047' AND r.app_block = 0 ========================2021-07-16 15:21:06======================== noteurl_start parm_app_code = 047 parm_pc_name = SHDWIN7-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 080027F4851128C8CA5F sCDKey = 788887299848 sName = SHDWIN7-PC ========================2021-07-16 15: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 = '788887299848' AND r.app_code = '047' AND r.app_block = 0 ========================2021-07-16 15:21:09======================== noteurl_start parm_app_code = 047 parm_pc_name = SHDWIN7-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 080027F4851128C8CA5F sCDKey = 805782763880 sName = SHDWIN7-PC ========================2021-07-16 15:21:09======================== 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 = '805782763880' AND r.app_code = '047' AND r.app_block = 0 ========================2021-07-16 15:27:37======================== noteurl_start parm_app_code = 047 parm_pc_name = SHDWIN7-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 080027F4851128C8CA5F sCDKey = 566378736978 sName = SHDWIN7-PC ========================2021-07-16 15:27:37======================== 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 = '566378736978' AND r.app_code = '047' AND r.app_block = 0 ========================2021-07-16 15:27:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nenara9999' ========================2021-07-16 15:27:37======================== SELECT idx FROM macs WHERE mac_addr = '080027F4851128C8CA5F' AND app_code = '047' ========================2021-07-16 15:27:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '347589' ========================2021-07-16 15:27:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '347589' ========================2021-07-16 15:27:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '347589', '080027F4851128C8CA5F', '047', 'SHDWIN7-PC', '�쐢�룄�슦 7', '0', '0', 'nenara9999', '[성대휘]', '566378736978' )