========================2018-04-13 11:27:34======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 001377CF87348851CD14 sCDKey = 699676022619 sName = 대경산업 ========================2018-04-13 11:27:34======================== 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 = '699676022619' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-13 11:27:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ko613200' ========================2018-04-13 11:27:34======================== SELECT idx FROM macs WHERE mac_addr = '001377CF87348851CD14' AND app_code = '039' ========================2018-04-13 11:27:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247158' ========================2018-04-13 11:27:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247158' ========================2018-04-13 11:27:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '247158', '001377CF87348851CD14', '039', '대경산업', '90', '1920', '1080', 'ko613200', '대경산업[이숙자]', '699676022619' ) ========================2018-04-13 14:26:47======================== noteurl_start parm_app_code = 039 parm_pc_name = 사용자-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E81132DBE1BE7A1F35E1 sCDKey = 339774264407 sName = 사용자-PC ========================2018-04-13 14:26: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 = '339774264407' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-13 14:26:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'manim' ========================2018-04-13 14:26:47======================== SELECT idx FROM macs WHERE mac_addr = 'E81132DBE1BE7A1F35E1' AND app_code = '039' ========================2018-04-13 14:26:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247175' ========================2018-04-13 14:26:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247175' ========================2018-04-13 14:26:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '247175', 'E81132DBE1BE7A1F35E1', '039', '사용자-PC', '90', '1600', '900', 'manim', '(주)대원특수화물[박명희]', '339774264407' ) ========================2018-04-13 14:33:47======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-LD8NAMU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2C56DC4DC5838E886C9B sCDKey = 735832194513 sName = DESKTOP-LD8NAMU ========================2018-04-13 14:33: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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-13 15:46:27======================== noteurl_start parm_app_code = 050 parm_pc_name = SNUGLOBAL-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A845C2349188FF sCDKey = 783168390290 sName = SNUGLOBAL-PC ========================2018-04-13 15:46:27======================== 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 = '783168390290' AND r.app_code = '050' AND r.app_block = 0 ========================2018-04-13 15:46:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lcckorea1' ========================2018-04-13 15:46:27======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A845C2349188FF' AND app_code = '050' ========================2018-04-13 15:46:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '246568' ========================2018-04-13 15:46:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '246568' ========================2018-04-13 15:46:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '246568', '50B7C3A845C2349188FF', '050', 'SNUGLOBAL-PC', '90', '1920', '1080', 'lcckorea1', '서울대학교[서울대학교]', '783168390290' ) ========================2018-04-13 17:03:32======================== noteurl_start parm_app_code = 039 parm_pc_name = INDI-1804-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D850E6DD0BAED6BAE6F9 sCDKey = 361043205852 sName = INDI-1804-PC ========================2018-04-13 17:03:32======================== 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 = '361043205852' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-13 17:03:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hngstyle' ========================2018-04-13 17:03:32======================== SELECT idx FROM macs WHERE mac_addr = 'D850E6DD0BAED6BAE6F9' AND app_code = '039' ========================2018-04-13 17:03:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247199' ========================2018-04-13 17:03:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247199' ========================2018-04-13 17:03:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '247199', 'D850E6DD0BAED6BAE6F9', '039', 'INDI-1804-PC', '90', '1920', '1080', 'hngstyle', '(주)에이치앤지스타일[송보람]', '361043205852' )