========================2018-12-12 13:44:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-57ITALS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6B82D8674A9918 sCDKey = 363761528323 sName = DESKTOP-57ITALS ========================2018-12-12 13:44:12======================== 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 = '363761528323' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-12 13:44:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'syu007' ========================2018-12-12 13:44:12======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6B82D8674A9918' AND app_code = '039' ========================2018-12-12 13:44:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270715' ========================2018-12-12 13:44:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270715' ========================2018-12-12 13:44:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '270715', 'E8039A6B82D8674A9918', '039', 'DESKTOP-57ITALS', '110', '1920', '1080', 'syu007', '직거래농산[이병학]', '363761528323' ) ========================2018-12-12 13:57:23======================== noteurl_start parm_app_code = 039 parm_pc_name = LYS-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 513185320426 sName = LYS-PC ========================2018-12-12 13:57:23======================== 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 = '513185320426' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-12 13:57:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lys0121' ========================2018-12-12 13:57:23======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '039' ========================2018-12-12 13:57:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269693' ========================2018-12-12 13:57:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269693' ========================2018-12-12 13:57:23======================== UPDATE mac_detail SET pc_name = 'LYS-PC', os_type = '110', user_id = 'lys0121', user_name = '[이윤솔]', screen_w = '1920', screen_h = '1080', cdkey = '513185320426' WHERE mac_idx = '269693' ========================2018-12-12 14:02:47======================== noteurl_start parm_app_code = 039 parm_pc_name = LYS-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 513185320426 sName = LYS-PC ========================2018-12-12 14:02:47======================== 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 = '513185320426' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-12 14:02:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lys0121' ========================2018-12-12 14:02:47======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '039' ========================2018-12-12 14:02:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269693' ========================2018-12-12 14:02:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269693' ========================2018-12-12 14:02:47======================== UPDATE mac_detail SET pc_name = 'LYS-PC', os_type = '110', user_id = 'lys0121', user_name = '[이윤솔]', screen_w = '1920', screen_h = '1080', cdkey = '513185320426' WHERE mac_idx = '269693' ========================2018-12-12 17:38:51======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E811323BDA5230235CB2 sCDKey = 510826302879 sName = SAMSUNG-PC ========================2018-12-12 17:38:51======================== 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 = '510826302879' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-12 17:38:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kcco1trading' ========================2018-12-12 17:38:51======================== SELECT idx FROM macs WHERE mac_addr = 'E811323BDA5230235CB2' AND app_code = '039' ========================2018-12-12 17:38:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270751' ========================2018-12-12 17:38:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270751' ========================2018-12-12 17:38:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '270751', 'E811323BDA5230235CB2', '039', 'SAMSUNG-PC', '90', '1920', '1080', 'kcco1trading', '주식회사 케이씨씨오[김태엽]', '510826302879' ) ========================2018-12-12 19:15:41======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-D8OVV1J parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 802BF9045A0338B36F7E sCDKey = 916970945314 sName = DESKTOP-D8OVV1J ========================2018-12-12 19:15:41======================== 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 = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-12 19:15:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'danjinail' ========================2018-12-12 19:15:41======================== SELECT idx FROM macs WHERE mac_addr = '802BF9045A0338B36F7E' AND app_code = '046' ========================2018-12-12 19:15:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270762' ========================2018-12-12 19:15:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270762' ========================2018-12-12 19:15:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '270762', '802BF9045A0338B36F7E', '046', 'DESKTOP-D8OVV1J', '110', '1280', '720', 'danjinail', '단지네네일가게[임재완]', '916970945314' ) ========================2018-12-12 20:23:47======================== noteurl_start parm_app_code = 039 parm_pc_name = SDSHOP-PC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 681729D66D616012A825 sCDKey = 917325696225 sName = SDSHOP-PC ========================2018-12-12 20:23:47======================== 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 = '917325696225' AND r.app_code = '039' AND r.app_block = 0