========================2020-02-10 10:48:54======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-S9B4SAJ parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10E7C6044A55F4282703 sCDKey = 362230354924 sName = DESKTOP-S9B4SAJ ========================2020-02-10 10:48:54======================== 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 = '362230354924' AND r.app_code = '050' AND r.app_block = 0 ========================2020-02-10 10:48:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'emforce2287' ========================2020-02-10 10:48:54======================== SELECT idx FROM macs WHERE mac_addr = '10E7C6044A55F4282703' AND app_code = '050' ========================2020-02-10 10:48:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310237' ========================2020-02-10 10:48:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310237' ========================2020-02-10 10:48:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '310237', '10E7C6044A55F4282703', '050', 'DESKTOP-S9B4SAJ', '109', '1920', '1080', 'emforce2287', '(주)엠포스[김재영]', '362230354924' ) ========================2020-02-10 11:56:16======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-S9B4SAJ parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10E7C6044A5554340062 sCDKey = 362230354924 sName = DESKTOP-S9B4SAJ ========================2020-02-10 11:56:16======================== 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 = '362230354924' AND r.app_code = '050' AND r.app_block = 0 ========================2020-02-10 12:04:55======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E04C96CE6D34627EBF sCDKey = 518069715941 sName = POS-PC ========================2020-02-10 12:04: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 = '518069715941' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-10 12:04:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wss6011' ========================2020-02-10 12:04:55======================== SELECT idx FROM macs WHERE mac_addr = '00E04C96CE6D34627EBF' AND app_code = '046' ========================2020-02-10 12:04:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310250' ========================2020-02-10 12:04:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310250' ========================2020-02-10 12:04:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '310250', '00E04C96CE6D34627EBF', '046', 'POS-PC', '90', '1024', '768', 'wss6011', '청주신선낚시[위상선]', '518069715941' ) ========================2020-02-10 13:09:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-9RTCFP6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D45D6438C52C2C61B64F sCDKey = 754413204267 sName = DESKTOP-9RTCFP6 ========================2020-02-10 13:09:57======================== 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 = '754413204267' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-10 13:09:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2020-02-10 13:09:57======================== SELECT idx FROM macs WHERE mac_addr = 'D45D6438C52C2C61B64F' AND app_code = '039' ========================2020-02-10 13:09:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310179' ========================2020-02-10 13:09:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310179' ========================2020-02-10 13:09:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '310179', 'D45D6438C52C2C61B64F', '039', 'DESKTOP-9RTCFP6', '110', '1920', '1080', 'kdle64', '성진산업[이갑동]', '754413204267' ) ========================2020-02-10 15:50:42======================== noteurl_start parm_app_code = 039 parm_pc_name = YGKIM parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A01D48B9C1B8868087C8 sCDKey = 852701273187 sName = YGKIM ========================2020-02-10 15:50:42======================== 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 = '852701273187' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-10 15:50:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyk40633' ========================2020-02-10 15:50:42======================== SELECT idx FROM macs WHERE mac_addr = 'A01D48B9C1B8868087C8' AND app_code = '039' ========================2020-02-10 15:50:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310285' ========================2020-02-10 15:50:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310285' ========================2020-02-10 15:50:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '310285', 'A01D48B9C1B8868087C8', '039', 'YGKIM', '110', '1536', '864', 'kyk40633', '정우테크[김용규]', '852701273187' )