========================2018-04-23 10:11:23======================== noteurl_start parm_app_code = 039 parm_pc_name = KD82 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D850E64141494C733CCA sCDKey = 146845660413 sName = KD82 ========================2018-04-23 10:11: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 = '146845660413' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-23 10:11:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kd4052' ========================2018-04-23 10:11:23======================== SELECT idx FROM macs WHERE mac_addr = 'D850E64141494C733CCA' AND app_code = '039' ========================2018-04-23 10:11:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247868' ========================2018-04-23 10:11:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247868' ========================2018-04-23 10:11:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '247868', 'D850E64141494C733CCA', '039', 'KD82', '90', '1920', '1080', 'kd4052', '극동타이어[정막래]', '146845660413' ) ========================2018-04-23 10:23:51======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-01 parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 1C6F6532BE4D3A021653 sCDKey = 937619922300 sName = WIN7-01 ========================2018-04-23 10:23: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 = '937619922300' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-23 10:23:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'amaggol53' ========================2018-04-23 10:23:51======================== SELECT idx FROM macs WHERE mac_addr = '1C6F6532BE4D3A021653' AND app_code = '039' ========================2018-04-23 10:23:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247870' ========================2018-04-23 10:23:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247870' ========================2018-04-23 10:23: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 ( '247870', '1C6F6532BE4D3A021653', '039', 'WIN7-01', '90', '1680', '1050', 'amaggol53', '유비인쇄소[박근엽]', '937619922300' ) ========================2018-04-23 11:06:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4QACU67 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00012E7101F04AFE4B30 sCDKey = 409399638114 sName = DESKTOP-4QACU67 ========================2018-04-23 11:06: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 = '409399638114' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-23 11:06:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hzhzhzz' ========================2018-04-23 11:06:45======================== SELECT idx FROM macs WHERE mac_addr = '00012E7101F04AFE4B30' AND app_code = '039' ========================2018-04-23 11:06:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '215056' ========================2018-04-23 11:06:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '215056' ========================2018-04-23 11:06:45======================== UPDATE mac_detail SET pc_name = 'DESKTOP-4QACU67', os_type = '110', user_id = 'hzhzhzz', user_name = '성지피복[유영우]', screen_w = '1920', screen_h = '1080', cdkey = '409399638114' WHERE mac_idx = '215056' ========================2018-04-23 13:41:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BBM2L87 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF4427E2D2C9D9E6D sCDKey = 810081081334 sName = DESKTOP-BBM2L87 ========================2018-04-23 13:41: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 = '810081081334' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-23 13:41:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'owner' ========================2018-04-23 13:41:52======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4427E2D2C9D9E6D' AND app_code = '039' ========================2018-04-23 13:41:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247894' ========================2018-04-23 13:41:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247894' ========================2018-04-23 13:41: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 ( '247894', 'BC5FF4427E2D2C9D9E6D', '039', 'DESKTOP-BBM2L87', '110', '1920', '1080', 'owner', '무지개조명[조성규]', '810081081334' ) ========================2018-04-23 14:46:53======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-1803191458 parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 2CFDA15D18036C37D15B sCDKey = 315323793787 sName = MSDN-1803191458 ========================2018-04-23 14:46:53======================== 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 = '315323793787' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-23 14:46:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rainbow2277' ========================2018-04-23 14:46:53======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA15D18036C37D15B' AND app_code = '039' ========================2018-04-23 14:46:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '246574' ========================2018-04-23 14:46:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '246574' ========================2018-04-23 14:46:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '246574', '2CFDA15D18036C37D15B', '039', 'MSDN-1803191458', '110', '1440', '900', 'rainbow2277', '레인보우[송미란]', '315323793787' ) ========================2018-04-23 15:41:37======================== noteurl_start parm_app_code = 046 parm_pc_name = PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 309C23287E9E84DD40CF sCDKey = 376188659226 sName = PC ========================2018-04-23 15:41:37======================== 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 = '376188659226' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-23 15:41:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sokimapet' ========================2018-04-23 15:41:37======================== SELECT idx FROM macs WHERE mac_addr = '309C23287E9E84DD40CF' AND app_code = '046' ========================2018-04-23 15:41:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247913' ========================2018-04-23 15:41:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247913' ========================2018-04-23 15:41:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '247913', '309C23287E9E84DD40CF', '046', 'PC', '90', '1280', '1024', 'sokimapet', ' THE ROOT(더루트)[송호승]', '376188659226' )