========================2018-12-31 10:20:14======================== noteurl_start parm_app_code = 046 parm_pc_name = HANYANG-HSM parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74D4353AD104E6F1D2E1 sCDKey = 950239637620 sName = HANYANG-HSM ========================2018-12-31 10:20:14======================== 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 = '950239637620' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-31 10:20:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kkj8097' ========================2018-12-31 10:20:14======================== SELECT idx FROM macs WHERE mac_addr = '74D4353AD104E6F1D2E1' AND app_code = '046' ========================2018-12-31 10:20:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272444' ========================2018-12-31 10:20:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272444' ========================2018-12-31 10:20:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272444', '74D4353AD104E6F1D2E1', '046', 'HANYANG-HSM', '90', '1920', '1080', 'kkj8097', '(주)한양건재[김기준]', '950239637620' ) ========================2018-12-31 11:39:25======================== noteurl_start parm_app_code = 046 parm_pc_name = YOUNG-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4D9B0BF1873953B sCDKey = 950239637620 sName = YOUNG-PC ========================2018-12-31 11:39:25======================== 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 = '950239637620' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-31 11:39:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kkj8097' ========================2018-12-31 11:39:25======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4D9B0BF1873953B' AND app_code = '046' ========================2018-12-31 11:39:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244580' ========================2018-12-31 11:39:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244580' ========================2018-12-31 11:39:25======================== UPDATE mac_detail SET pc_name = 'YOUNG-PC', os_type = '90', user_id = 'kkj8097', user_name = '(주)한양건재[김기준]', screen_w = '1024', screen_h = '768', cdkey = '950239637620' WHERE mac_idx = '244580' ========================2018-12-31 15:14:10======================== noteurl_start parm_app_code = 039 parm_pc_name = 우영복 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D2094AE1CF0EC22 sCDKey = 505709793149 sName = 우영복 ========================2018-12-31 15:14: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 = '505709793149' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-31 15:14:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kk032w' ========================2018-12-31 15:14:10======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D2094AE1CF0EC22' AND app_code = '039' ========================2018-12-31 15:14:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272486' ========================2018-12-31 15:14:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272486' ========================2018-12-31 15:14:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272486', '1C1B0D2094AE1CF0EC22', '039', '우영복', '90', '1920', '1080', 'kk032w', '(주)건국내츄럴에프앤비[우영삼]', '505709793149' ) ========================2018-12-31 17:43:52======================== noteurl_start parm_app_code = 050 parm_pc_name = DD_10039 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C5C8E9525315CA0FB6D sCDKey = 226231526622 sName = DD_10039 ========================2018-12-31 17:43:52======================== 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 = '226231526622' AND r.app_code = '050' AND r.app_block = 0 ========================2018-12-31 17:43:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daumsoft' ========================2018-12-31 17:43:52======================== SELECT idx FROM macs WHERE mac_addr = '9C5C8E9525315CA0FB6D' AND app_code = '050' ========================2018-12-31 17:43:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270452' ========================2018-12-31 17:43:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270452' ========================2018-12-31 17:43:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '270452', '9C5C8E9525315CA0FB6D', '050', 'DD_10039', '90', '1920', '1080', 'daumsoft', '다음소프트[다음소프트]', '226231526622' ) ========================2018-12-31 19:17:14======================== noteurl_start parm_app_code = 045 parm_pc_name = MAIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10C37B91DF1A1C386B54 sCDKey = 883534114755 sName = MAIN-PC ========================2018-12-31 19:17:14======================== 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 = '883534114755' AND r.app_code = '045' AND r.app_block = 0 ========================2018-12-31 19:17:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ohmyhun0323' ========================2018-12-31 19:17:14======================== SELECT idx FROM macs WHERE mac_addr = '10C37B91DF1A1C386B54' AND app_code = '045' ========================2018-12-31 19:17:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272519' ========================2018-12-31 19:17:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272519' ========================2018-12-31 19:17:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272519', '10C37B91DF1A1C386B54', '045', 'MAIN-PC', '90', '1920', '1080', 'ohmyhun0323', '은평전기조명[김영훈]', '883534114755' )