========================2019-03-07 08:29:03======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-PUVV8MJ parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A402B99DC98EC016F7D3 sCDKey = 921252470168 sName = DESKTOP-PUVV8MJ ========================2019-03-07 08:29:03======================== 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 = '921252470168' AND r.app_code = '046' AND r.app_block = 0 ========================2019-03-07 08:29:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cherhomes' ========================2019-03-07 08:29:03======================== SELECT idx FROM macs WHERE mac_addr = 'A402B99DC98EC016F7D3' AND app_code = '046' ========================2019-03-07 08:29:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250285' ========================2019-03-07 08:29:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250285' ========================2019-03-07 08:29:03======================== UPDATE mac_detail SET pc_name = 'DESKTOP-PUVV8MJ', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]', screen_w = '1536', screen_h = '864', cdkey = '921252470168' WHERE mac_idx = '250285' ========================2019-03-07 10:00:24======================== noteurl_start parm_app_code = 039 parm_pc_name = SC-201611031447 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D742974EE1BAE66 sCDKey = 426566431939 sName = SC-201611031447 ========================2019-03-07 10:00:24======================== 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 = '426566431939' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-07 10:00:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs1155' ========================2019-03-07 10:00:24======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D742974EE1BAE66' AND app_code = '039' ========================2019-03-07 10:00:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '200684' ========================2019-03-07 10:00:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '200684' ========================2019-03-07 10:00:24======================== UPDATE mac_detail SET pc_name = 'SC-201611031447', os_type = '90', user_id = 'bs1155', user_name = '부성분체산업[조무성]', screen_w = '1920', screen_h = '1080', cdkey = '426566431939' WHERE mac_idx = '200684' ========================2019-03-07 10:49:59======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5C030B99CF2A918 sCDKey = 990358659035 sName = USER-PC ========================2019-03-07 10:49:59======================== 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 = '990358659035' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-07 10:49:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbs8910' ========================2019-03-07 10:49:59======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5C030B99CF2A918' AND app_code = '039' ========================2019-03-07 10:49:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '220807' ========================2019-03-07 10:49:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '220807' ========================2019-03-07 10:49:59======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'bbs8910', user_name = '으뜸농산[방보식]', screen_w = '1920', screen_h = '1080', cdkey = '990358659035' WHERE mac_idx = '220807' ========================2019-03-07 11:52:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IMLH31P parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0C54157CD44AEEE6ECE7 sCDKey = 166394699588 sName = DESKTOP-IMLH31P ========================2019-03-07 11:52: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 = '166394699588' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-07 11:52:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bohyun5566' ========================2019-03-07 11:52:17======================== SELECT idx FROM macs WHERE mac_addr = '0C54157CD44AEEE6ECE7' AND app_code = '039' ========================2019-03-07 11:52:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '279315' ========================2019-03-07 11:52:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '279315' ========================2019-03-07 11:52:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '279315', '0C54157CD44AEEE6ECE7', '039', 'DESKTOP-IMLH31P', '110', '1920', '1080', 'bohyun5566', '보현전기[고순희]', '166394699588' ) ========================2019-03-07 14:09:35======================== noteurl_start parm_app_code = 045 parm_pc_name = PKJ parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F0795996DF132C3899D2 sCDKey = 807552398468 sName = PKJ ========================2019-03-07 14:09: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 = '807552398468' AND r.app_code = '045' AND r.app_block = 0 ========================2019-03-07 14:09:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ko000d40' ========================2019-03-07 14:09:35======================== SELECT idx FROM macs WHERE mac_addr = 'F0795996DF132C3899D2' AND app_code = '045' ========================2019-03-07 14:09:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '279338' ========================2019-03-07 14:09:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '279338' ========================2019-03-07 14:09:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '279338', 'F0795996DF132C3899D2', '045', 'PKJ', '90', '1920', '1080', 'ko000d40', '한국청과위탁판매[한국청과위탁판매]', '807552398468' )