========================2018-01-31 09:11:13======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RIU7E7C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892E09ACAA233C88 sCDKey = 003400982708 sName = DESKTOP-RIU7E7C ========================2018-01-31 09:11:13======================== 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 = '003400982708' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-31 09:11:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chojaeseong' ========================2018-01-31 09:11:13======================== SELECT idx FROM macs WHERE mac_addr = '9883892E09ACAA233C88' AND app_code = '046' ========================2018-01-31 09:11:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '198520' ========================2018-01-31 09:11:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '198520' ========================2018-01-31 09:11:13======================== UPDATE mac_detail SET pc_name = 'DESKTOP-RIU7E7C', os_type = '110', user_id = 'chojaeseong', user_name = '미소매점[조재성]', screen_w = '1366', screen_h = '768', cdkey = '003400982708' WHERE mac_idx = '198520' ========================2018-01-31 09:38:45======================== noteurl_start parm_app_code = 039 parm_pc_name = JUICY-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C67A478C0B61DC3 sCDKey = 154547355127 sName = JUICY-PC ========================2018-01-31 09:38:45======================== 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 = '154547355127' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-31 09:38:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssidangnim' ========================2018-01-31 09:38:45======================== SELECT idx FROM macs WHERE mac_addr = '408D5C67A478C0B61DC3' AND app_code = '039' ========================2018-01-31 09:38:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240860' ========================2018-01-31 09:38:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240860' ========================2018-01-31 09:38:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240860', '408D5C67A478C0B61DC3', '039', 'JUICY-PC', '90', '1920', '1080', 'ssidangnim', '쥬씨[윤대중]', '154547355127' ) ========================2018-01-31 10:39:57======================== noteurl_start parm_app_code = 047 parm_pc_name = JA1 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 6045CB5DD9A046CE542E sCDKey = 278870946981 sName = JA1 ========================2018-01-31 10:39: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 = '278870946981' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-31 10:40:06======================== noteurl_start parm_app_code = 047 parm_pc_name = JA1 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 6045CB5DD9A046CE542E sCDKey = 278870946981 sName = JA1 ========================2018-01-31 10:40:06======================== 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 = '278870946981' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-31 10:40:25======================== noteurl_start parm_app_code = 047 parm_pc_name = JA1 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 6045CB5DD9A046CE542E sCDKey = 258870946981 sName = JA1 ========================2018-01-31 10:40: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 = '258870946981' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-31 10:40:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jangangun' ========================2018-01-31 10:40:25======================== SELECT idx FROM macs WHERE mac_addr = '6045CB5DD9A046CE542E' AND app_code = '047' ========================2018-01-31 10:40:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240873' ========================2018-01-31 10:40:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240873' ========================2018-01-31 10:40:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240873', '6045CB5DD9A046CE542E', '047', 'JA1', '�쐢�룄�슦 7', '0', '0', 'jangangun', '장안건[임종희]', '258870946981' ) ========================2018-01-31 13:34:44======================== noteurl_start parm_app_code = 039 parm_pc_name = MAIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D80177CF071032D sCDKey = 037600020412 sName = MAIN-PC ========================2018-01-31 13:34:44======================== 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 = '037600020412' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-31 13:34:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lky2006' ========================2018-01-31 13:34:44======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D80177CF071032D' AND app_code = '039' ========================2018-01-31 13:34:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240900' ========================2018-01-31 13:34:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240900' ========================2018-01-31 13:34:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240900', '1C1B0D80177CF071032D', '039', 'MAIN-PC', '90', '1920', '1080', 'lky2006', '서울테크[이규영]', '037600020412' )